private void btnImport_Click(object sender, EventArgs e) { UseWaitCursor = true; Application.DoEvents(); try { DataTable dt = ExcelToTable(System.Environment.CurrentDirectory + @"\剧毒化学品目录\" + "judu.xls"); //this.enforceLawGridViewChemicalsHighlyToxic.DataSource = dt; for (int j = 0; j < dt.Rows.Count; j++) { ChemicalsHighlyToxic ChemicalsHighlyToxic = new ChemicalsHighlyToxic(); ChemicalsHighlyToxic.ChemicalName = dt.Rows[j][0].ToString(); ChemicalsHighlyToxic.ChemicalAlias = dt.Rows[j][1].ToString(); ChemicalsHighlyToxic.ChemicalNameEn = dt.Rows[j][2].ToString(); ChemicalsHighlyToxic.ChemicalAliasEn = dt.Rows[j][3].ToString(); ChemicalsHighlyToxic.Formula = dt.Rows[j][4].ToString(); ChemicalsHighlyToxic.CAS = dt.Rows[j][5].ToString(); ChemicalsHighlyToxic.UN = dt.Rows[j][6].ToString(); ChemicalsHighlyToxic.LimitedRange = dt.Rows[j][7].ToString(); /*EList<ChemicalsHighlyToxic> ChemicalsHighlyToxics = InvokeUtil.SystemService.ChemicalsHighlyToxicGetAll(1, 20, ChemicalsHighlyToxic.ChemicalName, ChemicalsHighlyToxic.ChemicalAlias); if (ChemicalsHighlyToxics.Items.Count <= 0) { InvokeUtil.SystemService.EntityUpdate(ChemicalsHighlyToxic); } */ InvokeUtil.SystemService.EntityUpdate(ChemicalsHighlyToxic); } Reload(); CommonInvoke.MessageBox("操作成功!"); } catch (Exception ex) { CommonInvoke.ErrorMessageBox(ex); } UseWaitCursor = false; }
private void buttonOK_Click(object sender, EventArgs e) { UseWaitCursor = true; Application.DoEvents(); try { if (chemicalsHighlyToxic == null) chemicalsHighlyToxic = new ChemicalsHighlyToxic(); GetEntity(chemicalsHighlyToxic); InvokeUtil.SystemService.EntityUpdate(chemicalsHighlyToxic); CommonInvoke.MessageBox("操作成功!"); CloseWindow(); } catch (Exception ex) { CommonInvoke.ErrorMessageBox(ex); } UseWaitCursor = false; }
public frmChemicalsHighlyToxic(ChemicalsHighlyToxic chemicalsHighlyToxic) : this() { this.chemicalsHighlyToxic = chemicalsHighlyToxic; }
/// <summary> /// 剧毒化学品目录 /// </summary> /// <param name="page"></param> /// <param name="pageSize"></param> /// <param name="ChemicalName">化学名</param> /// <param name="ChemicalAlias">别名</param> /// <returns></returns> public EList<ChemicalsHighlyToxic> ChemicalsHighlyToxicGetAll(int page, int pageSize, string ChemicalName, string ChemicalAlias) { try { ChemicalsHighlyToxic Obj = new ChemicalsHighlyToxic(); Obj.SystemService = this; return Obj.ChemicalsHighlyToxicGetAll(page, pageSize, ChemicalName, ChemicalAlias); } catch (Exception ex) { throw ex; } }