/// <summary> /// 根据主键删除信息 /// </summary> /// <param name="SafetyDataEId"></param> public static void DeleteSafetyDataEByID(string SafetyDataEId) { Model.SUBHSSEDB db = Funs.DB; Model.SafetyDataE_SafetyDataE SafetyDataE = db.SafetyDataE_SafetyDataE.FirstOrDefault(e => e.SafetyDataEId == SafetyDataEId); { ///删除相应的计划总表 BLL.SafetyDataEPlanService.DeleteSafetyDataEPlanBySafetyDataEId(SafetyDataEId); db.SafetyDataE_SafetyDataE.DeleteOnSubmit(SafetyDataE); db.SubmitChanges(); } }
/// <summary> /// 修改企业安全管理资料 /// </summary> /// <param name="SafetyDataE"></param> public static void UpdateSafetyDataE(Model.SafetyDataE_SafetyDataE SafetyDataE) { Model.SUBHSSEDB db = Funs.DB; Model.SafetyDataE_SafetyDataE newSafetyDataE = db.SafetyDataE_SafetyDataE.FirstOrDefault(e => e.SafetyDataEId == SafetyDataE.SafetyDataEId); if (newSafetyDataE != null) { newSafetyDataE.Code = SafetyDataE.Code; newSafetyDataE.Title = SafetyDataE.Title; newSafetyDataE.Score = SafetyDataE.Score; newSafetyDataE.Digit = SafetyDataE.Digit; newSafetyDataE.SupSafetyDataEId = SafetyDataE.SupSafetyDataEId; newSafetyDataE.IsEndLever = SafetyDataE.IsEndLever; newSafetyDataE.Remark = SafetyDataE.Remark; newSafetyDataE.IsCheck = SafetyDataE.IsCheck; db.SubmitChanges(); ///更新考核项 if (newSafetyDataE.IsCheck == true) { UpdateSafetyDataEIsCheck(newSafetyDataE.SupSafetyDataEId); } } }
///// <summary> ///// 根据菜单id获取企业安全管理资料 ///// </summary> ///// <param name="appraise"></param> ///// <returns></returns> //public static Model.SafetyDataE_SafetyDataE GetSafetyDataEByMenuId(string menuid) //{ // return Funs.DB.SafetyDataE_SafetyDataE.FirstOrDefault(x => x.MenuId == menuid && x.IsCheck == true); //} /// <summary> /// 添加企业安全管理资料 /// </summary> /// <param name="SafetyDataE"></param> public static void AddSafetyDataE(Model.SafetyDataE_SafetyDataE SafetyDataE) { Model.SUBHSSEDB db = Funs.DB; Model.SafetyDataE_SafetyDataE newSafetyDataE = new Model.SafetyDataE_SafetyDataE { SafetyDataEId = SafetyDataE.SafetyDataEId, Code = SafetyDataE.Code, Title = SafetyDataE.Title, Score = SafetyDataE.Score, Digit = SafetyDataE.Digit, SupSafetyDataEId = SafetyDataE.SupSafetyDataEId, IsEndLever = SafetyDataE.IsEndLever, Remark = SafetyDataE.Remark, IsCheck = SafetyDataE.IsCheck }; db.SafetyDataE_SafetyDataE.InsertOnSubmit(newSafetyDataE); db.SubmitChanges(); ///更新考核项 if (newSafetyDataE.IsCheck == true) { UpdateSafetyDataEIsCheck(newSafetyDataE.SupSafetyDataEId); } }