List<int> order_item_id = new List<int>(); //用来记录订单明细中的item_id,根据它找到订单ID
order_item_id.Add(1);
order_item_id.Add(2);
order_item_id.Add(1);
IEnumerable<int> r = order_item_id..AsEnumerable().Distinct();
string last_value="";
foreach (int r_orderId in r)
{
last_value+=r_orderId+",";
}
//输出1,2
namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
DataTable tbl = new DataTable();
tbl.Columns.Add("Id", typeof(System.Int32));
tbl.Columns.Add("City", typeof(System.String));
tbl.Columns.Add("Province", typeof(System.String));
tbl.Rows.Add(1, "武汉", "湖北");
tbl.Rows.Add(2, "应城", "湖北");
tbl.Rows.Add(3, "武汉", "湖北");
IEnumerable <DataRow> r = tbl.AsEnumerable().Distinct(new CityComparer());
//到这一步,r里就是去重复的记录了
foreach (var item in r)
{
Console.WriteLine(item["Id"] + "," + item["City"] + "," + item["Province"]);
}
Console.ReadLine();
}
}
class CityComparer : IEqualityComparer <DataRow>
{
public bool Equals(DataRow r1, DataRow r2)
{
return r1["City"] == r2["City"];
}
public int GetHashCode(DataRow obj)
{
return obj.ToString().GetHashCode();
}
}
}