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