protected void HAZA_Edit_Click(object sender, System.EventArgs e) { var haza = new TH_THAZA01("edit", this.HAZA_ID.Text); haza.HAZA_NAME = this.HAZA_NAME.Text; haza.HAZA_LOCA = this.hazaloca_tbxMyBox1.Text.Substring(0, this.hazaloca_tbxMyBox1.Text.LastIndexOf('_'));; haza.HAZA_LVL = this.HAZALVL_DList.SelectedValue; haza.HAZA_D = decimal.Parse(this.HAZA_D_TEXT.Text); haza.SetStats("审核"); var advuser = new AdvUserInfo(GetIdentityName()); this.HAZA_CREATOR.Text = advuser.USER_ID; haza.REC_CREATOR = advuser.USER_ID; var worflow = new VERI_WORKFLOW().Static_GetWORKFLOWByCNAME("危险源修改审核"); var node = new VERI_WORKFLOW_NODE().Static_GetWORKFLOWNodeByid("0301"); var haza01old = new TH_THAZA01(); var haza02 = new TH_THAZA02().SetEditFLOW(haza, haza, node); var re1 = haza02.AddDB(); var ds = this.GridGetDataSource(); haza.RISKLIST = ds; var csre = haza.Fill_RiskString(); var re = haza.AddNew(); if (re.Flag) { Notify.ShowMessage("保存成功,关闭页面"); } else { Notify.ShowMessage(re.Msg); } }
protected void HAZA_RISKGrid_PageIndexChange(object sender, GridPageEventArgs e) { this.HAZA_RISKGrid.PageIndex = e.NewPageIndex; var haza01 = TH_THAZA01.FindByID(int.Parse(this.ID_HAZA.Text)); var list = haza01.GetRiskList(); this.BindGrid(list.AsQueryable()); }
protected List<TH_THAZA01> GetGridDataSource() { var resint = new List<int>(); foreach (var row in this.HAZAGrid.Rows) { int ID = int.Parse((string)row.DataKeys[0]); resint.Add(ID); } var res = TH_THAZA01.FindListByIDList(resint); return res; }
protected void RefreshHAZA_LVL(List <TH_TRISK01> risk_list) { if (risk_list.Count == 0 || risk_list == null) { this.HAZALVL_DList.SelectedValue = ""; return; } decimal haza_d; string hazalvl; TH_THAZA01.ReCalcHAZA_LVL(risk_list, out haza_d, out hazalvl); if (this.HAZALVLEdit.Text == "0") { this.HAZALVL_DList.SelectedValue = hazalvl; } this.HAZA_D_TEXT.Text = haza_d.ToString(); }
protected void Btn_DelHAZA_Click(object sender, EventArgs e) { int[] array = this.HAZAGrid.SelectedRowIndexArray; foreach (int a in array) { var ac = HAZAGrid.Rows[a]; var haza_rec = int.Parse(ac.DataKeys[0].ToString()); var re = TH_THAZA01.SetStatsAndSave(haza_rec, "删除"); if (!re.Flag) { Notify.ShowMessage(re.Msg); return; } } var searchform = (HAZASearchForm)this.HAZASearchForm; searchform.Btn_Search_Click(sender, e); }
protected void HAZA_Add_Click(object sender, System.EventArgs e) { TH_THAZA01 new_haza01 = new TH_THAZA01("new") { HAZA_NAME = this.HAZA_NAME.Text, HAZA_LOCA = this.hazaloca_tbxMyBox1.Text.Substring(0, this.hazaloca_tbxMyBox1.Text.LastIndexOf('_')), HAZA_LVL = this.HAZALVL_DList.SelectedValue, HAZA_D = decimal.Parse(this.HAZA_D_TEXT.Text), HAZA_DEPT = this.hazaloca_tbxMyBox1.Text.Split('_')[0] }; new_haza01.SetStats("审核"); var advuser = new AdvUserInfo(GetIdentityName()); this.HAZA_CREATOR.Text = advuser.USER_ID; new_haza01.REC_CREATOR = advuser.USER_ID; var ds = this.GridGetDataSource(); new_haza01.RISKLIST = ds; var csre = new_haza01.Fill_RiskString(); var node = new VERI_WORKFLOW_NODE().Static_GetWORKFLOWNodeByid("0101"); var tmp = new_haza01.CheckNode(node); var re0 = new_haza01.AddNew(); try { var db = new SAFEDB(); var haza02 = new TH_THAZA02().SetAddFLOW(new_haza01, node); var re = haza02.AddDB(); } catch (Exception ex) { throw new Exception("添加审核权限失败,该用户没有权利添加这个审核"); } if (re0.Flag) { Notify.ShowMessage("添加成功,请关闭页面"); } else { Notify.ShowMessage(re0.Msg); } }
/// <summary> /// 文件导入函数 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Btn_AddInRISK_Click(object sender, System.EventArgs e) { try { string strFileName = this.File_Upload.FileName; //验证是否选择了文件 if ("" == strFileName.Trim()) { throw new Exception("没有选择文件"); } //验证文件类型是不是Excel //if (strFileName.Substring(strFileName.LastIndexOf('.')) != ".xlsx" && strFileName.Substring(strFileName.LastIndexOf('.')) != ".xls") //{ // throw new Exception("文件类型错误"); //} if (strFileName.Substring(strFileName.LastIndexOf('.')) != ".xls") { throw new Exception("文件类型错误"); } //获取上载文件内容 var fileStream = File_Upload.PostedFile.InputStream; NPOI.HSSF.UserModel.HSSFWorkbook wb = new NPOI.HSSF.UserModel.HSSFWorkbook(fileStream); if (wb == null) { throw new Exception("Excel表格数据为空"); } HSSFSheet sheet = wb.GetSheetAt(0) as HSSFSheet; var userid = base.GetIdentityName(); var re0 = TH_THAZA01.BuildListByNPOISheet(sheet, userid); if (!re0.Flag) { throw new Exception(re0.Msg); } foreach (var in_hazard in re0.Entity) { foreach (var in_risk in in_hazard.RISKLIST) { var re = in_risk.CheckAndSaveRiskinDB(); if (!re.Flag) { throw new Exception(re.Msg); } } var re1 = in_hazard.AddSaveEntitytoDB(); if (!re1.Flag) { throw new Exception(re1.Msg); } } Notify.ShowMessage("成功添加所有条目"); return; } catch (Exception ex) { Notify.ShowMessage(ex.Message); return; } }