private void DoWork(object sender, DoWorkEventArgs e)
{
#region Set Bill Grid
foreach (DataRow dr in DS1.Tables["PartMtl"].Rows)
{
DataRow Dr = DS0.Tables[0].NewRow();
Dr["Pnum"] = dr["MtlPartNum"].ToString();
Dr["Qty1"] = dr["QtyPer"].ToString();
Dr["Qty2"] = "0";
Dr["Desc"] = DataList.GetCurrentDesc(Dr["Pnum"].ToString());
DS0.Tables[0].Rows.Add(Dr);
backgroundWorker1.ReportProgress(1);
}
bool found = false;
foreach (DataRow dr in DS2.Tables["PartMtl"].Rows)
{
found = false;
foreach (DataRow Dr in DS0.Tables[0].Rows)
{
if (dr["MtlPartNum"].ToString() == Dr["Pnum"].ToString())
{
Dr["Qty2"] = dr["QtyPer"].ToString();
found = true;
backgroundWorker1.ReportProgress(1);
break;
}
}
if (!found)
{
DataRow DR = DS0.Tables[0].NewRow();
DR["Pnum"] = dr["MtlPartNum"].ToString();
DR["Qty2"] = dr["QtyPer"].ToString();
DR["Qty1"] = "0";
DR["Desc"] = DataList.GetCurrentDesc(DR["Pnum"].ToString());
DS0.Tables[0].Rows.Add(DR);
backgroundWorker1.ReportProgress(1);
}
}
#endregion
#region Set Ops Grid
try
{
foreach (DataRow dr in DS1.Tables["PartOpr"].Rows)
{
DataRow Dr = DS0.Tables[1].NewRow();
Dr["Seq"] = dr["OprSeq"].ToString();
Dr["ProdHrs1"] = dr["ProdStandard"].ToString();
//Dr["ProdHrs2"] = "0";
Dr["Code"] = dr["OpCode"].ToString();
DS0.Tables[1].Rows.Add(Dr);
backgroundWorker1.ReportProgress(1);
}
found = false;
foreach (DataRow dr in DS2.Tables["PartOpr"].Rows)
{
found = false;
foreach (DataRow Dr in DS0.Tables[1].Rows)
{
if (dr["OpCode"].ToString() == Dr["Code"].ToString() && dr["OprSeq"].ToString() == Dr["Seq"].ToString())
{
Dr["ProdHrs2"] = dr["ProdStandard"].ToString();
found = true;
backgroundWorker1.ReportProgress(1);
break;
}
}
if (!found)
{
DataRow Dr = DS0.Tables[1].NewRow();
Dr["Seq"] = dr["OprSeq"].ToString();
Dr["ProdHrs2"] = dr["ProdStandard"].ToString();
//Dr["ProdHrs1"] = "0";
Dr["Code"] = dr["OpCode"].ToString();
DS0.Tables[1].Rows.Add(Dr);
backgroundWorker1.ReportProgress(1);
}
}
}
catch { }
#endregion
}