Пример #1
0
 /// <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();
     }
 }
Пример #2
0
        /// <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);
                }
            }
        }
Пример #3
0
        ///// <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);
            }
        }