public static CSException <List <TH_HAZALOCA> > BuildListByNPOISheet(NPOI.HSSF.UserModel.HSSFSheet HSSFSheet)
{
try
{
var db = new SAFEDB();
var rowcount = HSSFSheet.LastRowNum + 1;
var hazaList = new List <TH_HAZALOCA>();
for (var i = 0; i < rowcount; i++)
{
var row = HSSFSheet.GetRow(i);
var deptCode = row.Cells[0].StringCellValue;
var locaName = row.Cells[1].StringCellValue;
var newLoca = new TH_HAZALOCA(locaName, deptCode);
var allowed = newLoca.IsAllowed();
if (!allowed.Flag)
{
db.TH_HAZALOCA.Add(newLoca);
db.SaveChanges();
}
else
{
throw new Exception(allowed.Msg);
}
}
return(new CSException <List <TH_HAZALOCA> >(true, rowcount.ToString(), hazaList));
}
catch (Exception ex)
{
return(new CSException <List <TH_HAZALOCA> >(ex.Message, new List <TH_HAZALOCA>()));
}
}
public TH_THAZA01(string newstring)
{
if (newstring == "new")
{
var db = new SAFEDB();
var _haza_id = Guid.NewGuid().ToString("N");
this.HAZA_ID = _haza_id;
this.REC_CREATETIME = DateTime.Now.ToString("yyyyMMddHHmmss");
var re = this.SetStats("审核");
}
else if (newstring == "insert")
{
var db = new SAFEDB();
var _haza_id = Guid.NewGuid().ToString("N");
this.HAZA_ID = _haza_id;
this.REC_CREATETIME = DateTime.Now.ToString("yyyyMMddHHmmss");
var re = this.SetStats("正式");
}
else
{
throw new Exception("不是新建命令");
}
}
public CSException AddDB(AdvWorkFlow AdvWork)
{
try
{
var db = new SAFEDB();
try
{
var res = (from x in db.TH_THAZA02
where x.REC_ID == this.REC_ID
select x).First();
this.REC_ID = Guid.NewGuid().ToString("N").Substring(0, 8);
db.HD_APP_DETAILFLOW.Add(this);
db.SaveChanges();
}
catch
{
if (this.REC_ID == null)
{
this.REC_ID = Guid.NewGuid().ToString("N").Substring(0, 8);
}
db.HD_APP_DETAILFLOW.Add(this);
db.SaveChanges();
}
return(new CSException());
}
catch (Exception ex)
{
throw ex;
}
}
public IWORKFLOW_NODE Static_GetWORKFLOWNodeByid(string id)
{
var db = new SAFEDB();
var res = (IWORKFLOW_NODE)(from x in db.VERI_WORKFLOW_NODE where x.NODE_ID == id select x).First();
return(res);
}
public IVerifyEntity StaticGetEntityByid(string id)
{
var db = new SAFEDB();
var res = (IVerifyEntity)db.HD_APP_DETAILFLOW.Find(id);
return(res);
}
protected IQueryable <TH_HAZALOCA> SearchResult()
{
var loca_name = this.HAZALOCA_NAMEText.Text;
IQueryable <TH_HAZALOCA> res;
if (loca_name != "")
{
var db = new SAFEDB();
res = (from x in db.TH_HAZALOCA
where x.C_NAME.Contains(loca_name) && x.STATS != "04"
orderby x.ID
select x);
}
else
{
var db = new SAFEDB();
res = (from x in db.TH_HAZALOCA
where x.STATS != "04"
orderby x.ID
select x);
}
if (this.dept_tbxMyBox1.Text != "")
{
var dept_code = this.dept_tbxMyBox1.Text.Split('_')[0];
res = (from x in res
where x.DEPT == dept_code
orderby x.ID
select x);
}
return(res);
}
public AdvUserInfo(string console)
{
var db = new SAFEDB();
if (console == "cookie")
{
var userid = new PageBase().GetCookieUserID();
var user = (from x in db.SAFE_HIDDEN_USER
where x.NAME == userid
select x).First();
this.USER_ID = userid;
this.USER_NAME = user.CHINESENAME;
this.USER_INFO = user;
}
else
{
var res = (from x in db.SAFE_HIDDEN_USER
where x.NAME == console
select x).First();
this.USER_INFO = res;
this.USER_ID = res.NAME;
this.USER_NAME = res.CHINESENAME;
}
this.USER_ROLE_LIST = (from x in db.SAFE_ROLEUSERS_T
where x.USER_ID == this.USER_ID
select x).Select(x => x.ROLE_ID).ToList();
}
/// <summary>
/// 查询数据库中是否存在相同描述的地址,true 有，false 没有
/// </summary>
/// <returns></returns>
public CSException IsAllowed()
{
try
{
var db = new SAFEDB();
var res = (from x in db.TH_HAZALOCA
where x.DEPT == this.DEPT && x.C_NAME == this.C_NAME && x.STATS != "04"
select x).ToList();
if (res.Count() == 0)
{
try
{
var res1 = new ORG_JOBUNITRELATION_V().FindDeptById(this.DEPT);
return(new CSException(false));
}
catch
{
return(new CSException(true, "数据库中没有这个单位代号：" + this.DEPT));
}
}
else
{
var msgstr = string.Format("{0}、{1}的区域已经存在于数据库中", this.DEPT, this.C_NAME.ToString());
return(new CSException(true, msgstr));
}
}
catch (Exception ex)
{
return(new CSException(true, ex.Message));
}
}
public CSException User_VerifyAble_Node(IWORKFLOW_NODE node)
{
try
{
var cate_cn = EP_TEPEP01.GetDicByCName("节点状态")[node.NODE_CATEGORY];
if (cate_cn != "开始" && cate_cn != "审核")
{
throw new Exception("1");
}
var db = new SAFEDB();
List <decimal> res1;
this.Fill_USER_ROLE_LIST();
res1 = this.USER_ROLE_LIST;
List <decimal> res2 = (from x in db.VERI_ROLEAUTH_NODE
where x.WORKFLOW_NODE_ID == node.NODE_ID
select x).Select(x => x.ROLE_ID).ToList();
var intersec = res1.Intersect(res2);
if (intersec.Count() > 0)
{
return(new CSException());
}
else
{
return(new CSException("该节点不能审核"));
}
}
catch
{
return(new CSException("该节点不能审核"));
}
}
protected void RISK_DETAIL_Window_Close(object sender, WindowCloseEventArgs e)
{
if (e.CloseArgument.Contains("add"))
{
//将grid的datasource读出来，加一项后赋值回去
var risk_id = e.CloseArgument.ToString().Split('_')[1];
var ds = GridGetDataSource();
var addrisk = TH_TRISK01.FindByID(risk_id);
ds.Add(addrisk);
this.HAZA_RISKGrid.DataSource = ds;
this.HAZA_RISKGrid.DataBind();
this.RefreshHAZA_LVL(ds);
}
else if (e.CloseArgument.Contains("edit"))
{
//将grid datasource读出来，替换成数据库中的那一项，赋值回去
var ds = GridGetDataSource();
var risk_id = e.CloseArgument.ToString().Split('_')[1];
var db = new SAFEDB();
var new_risk = (from x in db.TR_TRISK01
where x.RISK_ID == risk_id
select x).FirstOrDefault();
var remove_item = ds.Find(x => x.RISK_ID == risk_id);
ds.Remove(remove_item);
ds.Add(new_risk);
this.HAZA_RISKGrid.DataSource = ds;
this.HAZA_RISKGrid.DataBind();
this.RefreshHAZA_LVL(ds);
}
}
public IVerifyEntity StaticGetEntityByid(string id)
{
var db = new SAFEDB();
var res = (IVerifyEntity)db.TH_THAZA02.Find(id);
return(res);
}
public IWORKFLOW_LINK Static_GetWorkFlowLinkByNode(IWORKFLOW_NODE start_node, IWORKFLOW_NODE end_node, IWORKFLOW workflow)
{
var db = new SAFEDB();
var res = (IWORKFLOW_LINK)((from x in db.VERI_WORKFLOW_LINK where x.START_NODE_ID == start_node.NODE_ID && x.END_NODE_ID == end_node.NODE_ID && x.WORKFLOW_ID == workflow.WORKFLOW_ID select x).First());
return(res);
}
/// <summary>
/// 通过字符串绑定
/// </summary>
/// <param name="SOL_string"></param>
protected void BindSOL_Grid(string SOL_string)
{
try
{
var db = new SAFEDB();
var sollist = EP_TEPEP01.GetListByCName("风险处理措施");
this.RISK_SOL_Grid.DataSource = sollist;
this.RISK_SOL_Grid.DataBind();
var arr = new List <int>();
foreach (var row in this.RISK_SOL_Grid.Rows)
{
if (SOL_string.Contains(row.DataKeys[0].ToString()))
{
arr.Add(row.RowIndex);
}
}
int[] arr1 = new int[arr.Count()];
for (var i = 0; i < arr.Count(); i++)
{
arr1[i] = arr[i];
}
this.RISK_SOL_Grid.SelectedRowIndexArray = arr1;
}
catch { }
}
public IQueryable <IWORKFLOW_LINK> Static_GetLinkByFomulaEntity(string Formula, IVerifyEntity entity)
{
var start_node = entity.AUDITSTEP_ID;
var db = new SAFEDB();
var res = ((IQueryable <IWORKFLOW_LINK>)(from x in db.VERI_WORKFLOW_LINK where x.START_NODE_ID == start_node && x.FORMULA == Formula select x));
return(res);
}
public static List <EP_TEPEP02> GetListByCode(string code)
{
var db = new SAFEDB();
var res = (from x in db.EP_TEPEP02
where x.CODE_CLASS == code
select x).ToList();
return(res);
}
public IUserInfo USERINFO_GetUserINFO(string userid)
{
var db = new SAFEDB();
var res = (from x in db.SAFE_HIDDEN_USER
where x.NAME == userid
select x).First();
return(res);
}
/// <summary>
/// 列出同一HAZAID（表示同类）的危险源
/// </summary>
/// <param name="haza_id"></param>
/// <returns></returns>
public static List <TH_THAZA01> GetListByEntityID(string haza_id)
{
var db = new SAFEDB();
var res = (from x in db.TH_THAZA01
where x.HAZA_ID == haza_id
select x).ToList();
return(res);
}
public static TH_TRISK01 FindByID(string id)
{
var db = new SAFEDB();
var res = (from x in db.TR_TRISK01
where x.RISK_ID == id
select x).First();
return(res);
}
public System.Collections.Generic.List <IVerifyEntity> GetListBythisFlowid()
{
var db = new SAFEDB();
var res = ((IQueryable <IVerifyEntity>)(from x in db.TH_THAZA02
where x.FLOW_ID == this.FLOW_ID
select x)).ToList();
return(res);
}
public IQueryable <VERI_WORKFLOW_INSTEP> GetInstepByWorkflow(IWORKFLOW workflow)
{
var db = new SAFEDB();
var res = (from x in db.VERI_WORKFLOW_INSTEP
where x.WORKFLOW_ID == workflow.WORKFLOW_ID
select x);
return(res);
}
public IQueryable <IWORKFLOW_NODE> GetWorkFlowNodeList()
{
var db = new SAFEDB();
var res = ((IQueryable <IWORKFLOW_NODE>)(from x in db.VERI_WORKFLOW_NODE
where x.WORKFLOW_ID == this.WORKFLOW_ID
select x));
return(res);
}
/// <summary>
/// 通过id寻找
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static TH_HAZALOCA FindbyID(string id)
{
var db = new SAFEDB();
var res = (from x in db.TH_HAZALOCA
where x.ID == id
select x).FirstOrDefault();
return(res);
}
public static List <TH_TRISK01> FindListByIDList(List <string> idlist)
{
var db = new SAFEDB();
var res = (from x in db.TR_TRISK01
where idlist.Contains(x.RISK_ID)
select x).ToList();
return(res);
}
public IWORKFLOW Static_GetWORKFLOWByCNAME(string name)
{
var db = new SAFEDB();
var res = (IWORKFLOW)(from x in db.VERI_WORKFLOW where x.WORKFLOW_NAME == name select x).First();
res.TableType = Type.GetType(res.TABLENAME);
res.ContextType = Type.GetType(res.TABLEDBCONTEXT);
return(res);
}
public static TH_THAZA01 FindByID(int id_value)
{
var db = new SAFEDB();
var res = (from x in db.TH_THAZA01
where x.ID == id_value
select x).FirstOrDefault();
return(res);
}
public static SAFE_HIDDEN_USER GetUserById(string id)
{
var db = new SAFEDB();
var res = (from x in db.SAFE_HIDDEN_USER
where x.NAME == id
select x).First();
return(res);
}
/// <summary>
/// 获得该hazaid名下唯一一个审核节点，注意，每个haza01id有且仅有一个审核节点
/// </summary>
/// <returns></returns>
public TH_THAZA01 GetVeriHAZA01InThisHAZAID()
{
var db = new SAFEDB();
var res = (from x in db.TH_THAZA01
where x.HAZA_ID == this.HAZA_ID && x.HAZA_CATEGORY == "03"
select x).First();
return(res);
}
public List <IWORKFLOW_LINK> GetLinkListStartedBythis()
{
var db = new SAFEDB();
var res = ((IQueryable <IWORKFLOW_LINK>)(from x in db.VERI_WORKFLOW_LINK
where x.START_NODE_ID == this.NODE_ID
select x)).ToList();
return(res);
}
public static List <TH_THAZA01> FindListByIDList(List <int> id_value)
{
var db = new SAFEDB();
var res = (from x in db.TH_THAZA01
where id_value.Contains(x.ID)
select x).ToList();
return(res);
}
/// <summary>
/// 关闭窗口，刷新危险源区域画面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void AddLOCA_Window_Close(object sender, WindowCloseEventArgs e)
{
var db = new SAFEDB();
var haza_loca = (from x in db.TH_HAZALOCA
where x.STATS != "04"
orderby x.ID
select x);
this.BindGrid(haza_loca);
}
