/// <summary> /// 修改施工机具、安全设施检查验收 /// </summary> /// <param name="equipmentSafetyList"></param> public static void UpdateEquipmentSafetyList(Model.License_EquipmentSafetyList equipmentSafetyList) { Model.SUBHSSEDB db = Funs.DB; Model.License_EquipmentSafetyList newEquipmentSafetyList = db.License_EquipmentSafetyList.FirstOrDefault(e => e.EquipmentSafetyListId == equipmentSafetyList.EquipmentSafetyListId); if (newEquipmentSafetyList != null) { //newEquipmentSafetyList.ProjectId = equipmentSafetyList.ProjectId; newEquipmentSafetyList.EquipmentSafetyListCode = equipmentSafetyList.EquipmentSafetyListCode; newEquipmentSafetyList.EquipmentSafetyListName = equipmentSafetyList.EquipmentSafetyListName; newEquipmentSafetyList.UnitId = equipmentSafetyList.UnitId; newEquipmentSafetyList.EquipmentSafetyListCount = equipmentSafetyList.EquipmentSafetyListCount; newEquipmentSafetyList.WorkAreaId = equipmentSafetyList.WorkAreaId; newEquipmentSafetyList.CompileMan = equipmentSafetyList.CompileMan; newEquipmentSafetyList.CompileDate = equipmentSafetyList.CompileDate; newEquipmentSafetyList.States = equipmentSafetyList.States; newEquipmentSafetyList.SendMan = equipmentSafetyList.SendMan; db.SubmitChanges(); } }
/// <summary> /// 添加施工机具、安全设施检查验收 /// </summary> /// <param name="equipmentSafetyList"></param> public static void AddEquipmentSafetyList(Model.License_EquipmentSafetyList equipmentSafetyList) { Model.SUBHSSEDB db = Funs.DB; Model.License_EquipmentSafetyList newEquipmentSafetyList = new Model.License_EquipmentSafetyList { EquipmentSafetyListId = equipmentSafetyList.EquipmentSafetyListId, ProjectId = equipmentSafetyList.ProjectId, EquipmentSafetyListCode = equipmentSafetyList.EquipmentSafetyListCode, EquipmentSafetyListName = equipmentSafetyList.EquipmentSafetyListName, UnitId = equipmentSafetyList.UnitId, EquipmentSafetyListCount = equipmentSafetyList.EquipmentSafetyListCount, WorkAreaId = equipmentSafetyList.WorkAreaId, CompileMan = equipmentSafetyList.CompileMan, CompileDate = equipmentSafetyList.CompileDate, States = equipmentSafetyList.States, SendMan = equipmentSafetyList.SendMan }; db.License_EquipmentSafetyList.InsertOnSubmit(newEquipmentSafetyList); db.SubmitChanges(); ////增加一条编码记录 BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.ProjectEquipmentSafetyListMenuId, equipmentSafetyList.ProjectId, null, equipmentSafetyList.EquipmentSafetyListId, equipmentSafetyList.CompileDate); }
/// <summary> /// 根据主键删除施工机具、安全设施检查验收 /// </summary> /// <param name="equipmentSafetyListId"></param> public static void DeleteEquipmentSafetyListById(string equipmentSafetyListId) { Model.SUBHSSEDB db = Funs.DB; Model.License_EquipmentSafetyList equipmentSafetyList = db.License_EquipmentSafetyList.FirstOrDefault(e => e.EquipmentSafetyListId == equipmentSafetyListId); if (equipmentSafetyList != null) { BLL.CodeRecordsService.DeleteCodeRecordsByDataId(equipmentSafetyListId); //删除编号 BLL.CommonService.DeleteAttachFileById(equipmentSafetyListId); //删除附件 ///删除工程师日志收集记录 var flowOperate = from x in db.Sys_FlowOperate where x.DataId == equipmentSafetyList.EquipmentSafetyListId select x; if (flowOperate.Count() > 0) { foreach (var item in flowOperate) { BLL.HSSELogService.CollectHSSELog(equipmentSafetyList.ProjectId, item.OperaterId, item.OperaterTime, "24", equipmentSafetyList.EquipmentSafetyListName, Const.BtnDelete, 1); } ////删除流程表 BLL.CommonService.DeleteFlowOperateByID(equipmentSafetyList.EquipmentSafetyListId); } db.License_EquipmentSafetyList.DeleteOnSubmit(equipmentSafetyList); db.SubmitChanges(); } }