//datatable 去重
DataTable FilterRepeatTable(DataTable table)
{
DataTable _table = table.Clone();
foreach (DataRow row in table.Rows)
{
int rowCount = (from DataRow q in _table.Rows where q["REFERENCECODE"].ToString() == row["REFERENCECODE"].ToString() select q).ToList().Count();
if (rowCount == 0)
{
DataRow _row = _table.NewRow();
_row.ItemArray = row.ItemArray;
_table.Rows.Add(_row);
}
}
return _table;
}