/// <summary>
/// 根据危险源辨识与评价清单Id删除一个危险源辨识与评价清单信息
/// </summary>
/// <param name="hazardListCode">危险源辨识与评价清单Id</param>
public static void DeleteHazardListByHazardListId(string hazardListId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Hazard_HazardList hazardList = db.Hazard_HazardList.FirstOrDefault(e => e.HazardListId == hazardListId);
if (hazardList != null)
{
///删除工程师日志收集记录
var flowOperate = from x in db.Sys_FlowOperate where x.DataId == hazardList.HazardListId select x;
if (flowOperate.Count() > 0)
{
foreach (var item in flowOperate)
{
BLL.HSSELogService.CollectHSSELog(hazardList.ProjectId, item.OperaterId, item.OperaterTime, "25", "职业健康安全危险源辨识与评价", Const.BtnDelete, 1);
}
////删除审核流程表
BLL.CommonService.DeleteFlowOperateByID(hazardList.HazardListId);
}
///删除附件
BLL.CommonService.DeleteAttachFileById(hazardList.HazardListId);
///删除编码表记录
BLL.CodeRecordsService.DeleteCodeRecordsByDataId(hazardList.HazardListId);
db.Hazard_HazardList.DeleteOnSubmit(hazardList);
db.SubmitChanges();
}
}
/// <summary>
/// 修改危险源辨识与评价清单信息
/// </summary>
/// <param name="hazardList">危险源辨识与评价清单实体</param>
public static void UpdateHazardList(Model.Hazard_HazardList hazardList)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Hazard_HazardList newHazardList = db.Hazard_HazardList.FirstOrDefault(e => e.HazardListId == hazardList.HazardListId);
if (newHazardList != null)
{
newHazardList.HazardListCode = hazardList.HazardListCode;
//newHazardList.ProjectId = hazardList.ProjectId;
newHazardList.VersionNo = hazardList.VersionNo;
newHazardList.CompileMan = hazardList.CompileMan;
newHazardList.CompileDate = hazardList.CompileDate;
newHazardList.States = hazardList.States;
newHazardList.WorkStage = hazardList.WorkStage;
newHazardList.Contents = hazardList.Contents;
newHazardList.WorkAreaName = hazardList.WorkAreaName;
newHazardList.IdentificationDate = hazardList.IdentificationDate;
newHazardList.ControllingPerson = hazardList.ControllingPerson;
db.SubmitChanges();
}
}
/// <summary>
/// 增加危险源辨识与评价清单信息
/// </summary>
/// <param name="hazardList">危险源辨识与评价清单实体</param>
public static void AddHazardList(Model.Hazard_HazardList hazardList)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Hazard_HazardList newHazardList = new Model.Hazard_HazardList
{
HazardListId = hazardList.HazardListId,
HazardListCode = hazardList.HazardListCode,
ProjectId = hazardList.ProjectId,
VersionNo = hazardList.VersionNo,
CompileMan = hazardList.CompileMan,
CompileDate = hazardList.CompileDate,
States = hazardList.States,
WorkStage = hazardList.WorkStage,
Contents = hazardList.Contents,
WorkAreaName = hazardList.WorkAreaName,
IdentificationDate = hazardList.IdentificationDate,
ControllingPerson = hazardList.ControllingPerson
};
Funs.DB.Hazard_HazardList.InsertOnSubmit(newHazardList);
Funs.DB.SubmitChanges();
////增加一条编码记录
BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.ProjectHazardListMenuId, hazardList.ProjectId, null, hazardList.HazardListId, hazardList.CompileDate);
}
