/// <summary> ///根据主键删除安全评价 /// </summary> /// <param name="appraise"></param> public static void DeleteAppraiseById(string appraiseId) { Model.SUBHSSEDB db = Funs.DB; Model.Technique_Appraise appraise = db.Technique_Appraise.FirstOrDefault(e => e.AppraiseId == appraiseId); if (appraise != null) { if (!string.IsNullOrEmpty(appraise.AttachUrl)) { BLL.UploadFileService.DeleteFile(Funs.RootPath, appraise.AttachUrl); } ////删除附件表 BLL.CommonService.DeleteAttachFileById(appraise.AppraiseId); db.Technique_Appraise.DeleteOnSubmit(appraise); db.SubmitChanges(); } }
/// <summary> /// 修改安全评价信息 /// </summary> /// <param name="appraise"></param> public static void UpdateAppraise(Model.Technique_Appraise appraise) { Model.SUBHSSEDB db = Funs.DB; Model.Technique_Appraise newAppraise = db.Technique_Appraise.FirstOrDefault(e => e.AppraiseId == appraise.AppraiseId); if (newAppraise != null) { newAppraise.AppraiseCode = appraise.AppraiseCode; newAppraise.AppraiseTitle = appraise.AppraiseTitle; newAppraise.Abstract = appraise.Abstract; newAppraise.AppraiseDate = appraise.AppraiseDate; newAppraise.ArrangementPerson = appraise.ArrangementPerson; newAppraise.AttachUrl = appraise.AttachUrl; newAppraise.ArrangementDate = appraise.ArrangementDate; newAppraise.UpState = appraise.UpState; db.SubmitChanges(); } }
/// <summary> /// 添加安全评价信息 /// </summary> /// <param name="appraise"></param> public static void AddAppraise(Model.Technique_Appraise appraise) { Model.SUBHSSEDB db = Funs.DB; Model.Technique_Appraise newAppraise = new Model.Technique_Appraise { AppraiseId = appraise.AppraiseId, AppraiseCode = appraise.AppraiseCode, AppraiseTitle = appraise.AppraiseTitle, Abstract = appraise.Abstract, AppraiseDate = appraise.AppraiseDate, ArrangementPerson = appraise.ArrangementPerson, AttachUrl = appraise.AttachUrl, ArrangementDate = appraise.ArrangementDate, UnitId = appraise.UnitId, IsPass = appraise.IsPass, UpState = appraise.UpState }; db.Technique_Appraise.InsertOnSubmit(newAppraise); db.SubmitChanges(); }