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