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; } }