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