private void btnInExcel_Click(object sender, EventArgs e)
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
//MessageDialog.ShowPromptMessage(m_err);
return;
}
if (dtTemp.Rows.Count == 0 ||
!dtTemp.Columns.Contains("新箱号") ||
!dtTemp.Columns.Contains("旧箱号") ||
!dtTemp.Columns.Contains("新箱型号") ||
!dtTemp.Columns.Contains("旧箱型号") ||
!dtTemp.Columns.Contains("备注"))
{
MessageDialog.ShowPromptMessage(string.Format("{0} 中没有包含所需的信息，无法导入！",
openFileDialog1.FileName));
}
else
{
string strBatchNo = m_sell.GetMatchingBillID();
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
m_lnqNewAndOld.BatchNo = strBatchNo;
m_lnqNewAndOld.NewProductCode = dtTemp.Rows[i]["新箱号"].ToString();
m_lnqNewAndOld.OldProductCode = dtTemp.Rows[i]["旧箱号"].ToString();
m_lnqNewAndOld.NewEdition = dtTemp.Rows[i]["新箱型号"].ToString();
m_lnqNewAndOld.OldEdition = dtTemp.Rows[i]["旧箱型号"].ToString();
m_lnqNewAndOld.Remark = dtTemp.Rows[i]["备注"].ToString();
if (m_sell.IsSameProductMatchingInfo(m_lnqNewAndOld))
{
if (!m_sell.AddMatchingInfo(m_lnqNewAndOld, out m_err))
{
MessageDialog.ShowPromptMessage(m_err);
}
}
}
MessageDialog.ShowPromptMessage("导入成功!");
}
dataGridView1.DataSource = m_sell.GetProductCodeMatchingInfo();
dataGridView1.Columns["序号"].Visible = false;
}
