private void btInputBomData_Click(object sender, EventArgs e)
{
try
{
if (iasyncresult1 == null || iasyncresult1.IsCompleted)
{
string temp = "";//string.Empty;
OpenFileDialog ofd = new OpenFileDialog();
ofd.Title = "选择BOM数据";
ofd.Filter = "(*.xls Excel 2003)|*.xls";
//ofd.InitialDirectory = "c:\\";
DialogResult dlr = ofd.ShowDialog();
if (dlr == DialogResult.Yes || dlr == DialogResult.OK)
{
string filename = ofd.SafeFileName;
filename = filename.Split('.')[0];
if (filename.Split('-').Length != 2)
{
throw new Exception("BOM文件名称格式错误,请确认是否为BOM文件..");
}
DataTable mdt = FrmBLL.ClsReadExcel.getTableForSql(ofd.FileName,
string.Format("select 子件号,子件描述,替代组,'{1}'as Bom版本,排序字符串,用量,长文本（位号） from [{0}] where{2} 长文本（位号）<>''",
FrmBLL.ClsReadExcel.GetTableNames(ofd.FileName)[0], filename.Split('-')[1], temp));
this.progressBarItem1.Maximum = mdt.Rows.Count;
eventrundata = new delegaterundata(this.RunData);
iasyncresult1 = eventrundata.BeginInvoke(mdt, null, null);
}
}
else
{
MessageBoxEx.Show("程序还在运作中,请稍后....");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btcompare_Click(object sender, EventArgs e)
{
try
{
if ((iasyncresult != null && !iasyncresult.IsCompleted) || iasyncresult1 != null && !iasyncresult1.IsCompleted)
{
MessageBoxEx.Show("程序还在运作中,请稍后....");
return;
}
this.rtbmsg.Clear();
if (this.BomDataTable == null || this.BomDataTable.Rows.Count < 1)
{
MessageBoxEx.Show("请先加载BOM数据");
return;
}
if (this.rbtnPsCom.Checked)
{//SMT程式料站表与系统料站表比对
//判断是否加载SMT料站表
if (this.SmtSoftKpList == null || this.SmtSoftKpList.Rows.Count < 1)
{
MessageBoxEx.Show("请先加载SMT料站表");
return;
}
this.SmtSoftKpListCompareBomData("NO", null, null, null);
eventrundata = new delegaterundata(this.CompareSmtKpSfisKp);
iasyncresult = eventrundata.BeginInvoke(null, null, null);
return;
}
if (rbtnBsCom.Checked)
{
//判断是否加载SMT料站表
if (this.SmtSoftKpList == null || this.SmtSoftKpList.Rows.Count < 1)
{
MessageBoxEx.Show("请先加载SMT料站表");
return;
}
this.SmtSoftKpListCompareBomData("NO", null, null, null);
RunKpdetalt_New(null, null, null, SmtKpTable);
}
if (rbbomsfccom.Checked)
{
//判断是否加载系统料站表
if (this.KpDetaltNewTable == null || this.KpDetaltNewTable.Rows.Count < 1)
{
MessageBoxEx.Show("没有可以进行比较的数据,请先加载系统料站表");
return;
}
}
eventrundata = new delegaterundata(CompareKp);
iasyncresult = eventrundata.BeginInvoke(KpDetaltNewTable, null, null);
}
catch (Exception ex)
{
this.ShowMsg(LogMsgType.Error, ex.Message);
}
}
