private void ImportCmdExcute(object param) { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Filter = "Excel (*.XLS)|*.xls";; if ((bool)(openFileDialog.ShowDialog())) { string excelName = openFileDialog.FileName; DataTable dt = _excelHelper.LoadExcel(excelName); DataGridSource = dt.DefaultView; } }
public void DaoIn() { OpenFileDialog openFileDialog = new OpenFileDialog(); ExcelHelp _excelHelper = new ExcelHelp(); openFileDialog.Filter = "Excel (*.XLS)|*.xls"; int i = 0, j = 0; if ((bool)(openFileDialog.ShowDialog())) { try { DataTable dt = _excelHelper.LoadExcel(openFileDialog.FileName); List <wrench> s = ListWrench(dt); if (s != null && s.Count > 0) { foreach (wrench w in s) { try { if (Wrench.add(w)) { i++; } else { j++; LogUtil.WriteLog(typeof(string), "序号为 " + w.id.ToString() + "到入失败:"); } } catch { j++; LogUtil.WriteLog(typeof(wrench), w.wrenchBarCode + "导入失败!"); } } MessageBox.Show("成功导入" + i.ToString() + "条" + " 失败" + j.ToString() + "条"); } // Wrench.addlist(ListWrench (dt)); } catch (Exception ex) { LogUtil.WriteLog(typeof(string), "工具批量导入失败:" + ex); MessageBox.Show("批量导入工具信息失败,填写信息有误"); return; } } }