/// <summary>
/// 整合并得出最终DT
/// </summary>
/// <param name="materialdt"></param>
/// <param name="importdt"></param>
/// <returns></returns>
private DataTable Merge(DataTable materialdt, DataTable importdt)
{
var dt = dbList.ImportMergeTemp();
foreach (DataRow rows in importdt.Rows)
{
var newrow = dt.NewRow();
//通过‘物料编码’获取FMATERIALID
var dtlrow = materialdt.Select("物料编码='" + rows[0] + "'");
newrow[0] = dtlrow.Length == 0 ? 0 : dtlrow[0][0]; //fmaterialid
newrow[1] = rows[0]; //BOM物料编码
newrow[2] = rows[1]; //BOM物料名称
dt.Rows.Add(newrow);
}
return(dt);
}
