private void btnInputExcel_Click(object sender, EventArgs e)
{
try
{
DataTable dtTemp = ExcelHelperP.RenderFromExcel(openFileDialog1);
if (dtTemp == null)
{
return;
}
if (!dtTemp.Columns.Contains("图号型号"))
{
MessageDialog.ShowPromptMessage("文件无【图号型号】列名");
return;
}
if (!dtTemp.Columns.Contains("物品名称"))
{
MessageDialog.ShowPromptMessage("文件无【物品名称】列名");
return;
}
if (!dtTemp.Columns.Contains("规格"))
{
MessageDialog.ShowPromptMessage("文件无【规格】列名");
return;
}
if (!dtTemp.Columns.Contains("批次号"))
{
MessageDialog.ShowPromptMessage("文件无【批次号】列名");
return;
}
if (!dtTemp.Columns.Contains("数量"))
{
MessageDialog.ShowPromptMessage("文件无【数量】列名");
return;
}
m_goodsServer.InsertInfoExcel(m_billNo, dtTemp);
MessageDialog.ShowPromptMessage("导入成功");
m_queryGoodsInfo = m_goodsServer.GetGoods(m_billNo);
RefreshDataGridView(m_queryGoodsInfo);
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
return;
}
}
