/// <summary>
/// 运算-获取要生成的表头信息(MEASUREMENT_COLOR)
/// </summary>
/// <param name="dt">从模板EXCEL处获取的DT</param>
/// <returns></returns>
public DataTable Generatetemp(DataTable dt)
{
var resultdt = new DataTable();
try
{
//获取对应临时表(表头)
resultdt = dtList.Get_MeasureMentColordt();
//获取来源DT(后面判断时使用)
var sourcedt = GetSourcedt();
//循环从模板EXCEL获取的DT
foreach (DataRow row in dt.Rows)
{
//判断若内部色号对应的“来源”只有一个并且为CHINA;就不需要获取并插入致临时表内(注:若判断了版本日期为空,也作排除)
var result = CheckIncloudSource(Convert.ToString(row[1]), row[112].ToString(), sourcedt);
if (!result)
{
continue;
}
else
{
var newrow = resultdt.NewRow();
newrow[0] = row[0]; //BMMEASUREMENTID(主键)
newrow[1] = row[1]; //COLORCODE(内部色号)
newrow[2] = row[112]; //FORMULAVERSIONDATE(版本日期)
newrow[3] = row[2]; //DIFFUSECOARSENESS(颗粒度)
newrow[4] = DateTime.Now.Date; //CREATEDDATE(创建日期)
newrow[5] = row[111]; //MEASUREMENTTIME(测量时间)
resultdt.Rows.Add(newrow);
}
}
}
catch (Exception)
{
resultdt.Rows.Clear();
resultdt.Columns.Clear();
}
return(resultdt);
}
