返回的是什么类型,具体返回什么数据,是否list{samedt,diffdt}两张表
public List<DataTable> CompareList()
{
List<DataTable> listdt = new List<DataTable>();
DataTable dtBefore = ExcelToDataTable(txtBeforePath.Text.ToString());
DataTable dtAfter = ExcelToDataTable(txtAfterPath.Text.ToString());
DataTable samedt = new DataTable();
DataTable diffdt = new DataTable();
samedt.Columns.Add("slot");
samedt.Columns.Add("PN");
diffdt.Columns.Add("slot");
diffdt.Columns.Add("PN");
//after table
foreach (DataRow dr in dtAfter.Rows)
{
string afterPartNumber = dr["PN"].ToString();
//before and after compare
DataRow[] drs= dtBefore.Select("PN=" + afterPartNumber);
if (drs.Length > 0)
{
//to do:add to same table
DataRow samedr = samedt.NewRow();
samedr["slot"] = dr["slot"].ToString();
samedr["PN"] = dr["PN"].ToString();
samedt.Rows.Add(samedr);
}
else
{
//to do:add to diff table
DataRow diffdr = diffdt.NewRow();
diffdr["slot"] = dr["slot"].ToString();
diffdr["PN"] = dr["PN"].ToString();
diffdt.Rows.Add(diffdr);
}
}
listdt.Add(samedt);
listdt.Add(diffdt);
return listdt;
}