/// <summary> /// 修改管理规定 是否采用 /// </summary> /// <param name="manageRule"></param> public static void UpdateManageRuleIsPass(Model.Law_ManageRule manageRule) { Model.SUBHSSEDB db = Funs.DB; Model.Law_ManageRule newManageRule = db.Law_ManageRule.FirstOrDefault(e => e.ManageRuleId == manageRule.ManageRuleId); if (newManageRule != null) { newManageRule.IsPass = manageRule.IsPass; newManageRule.AuditMan = manageRule.AuditMan; newManageRule.AuditDate = manageRule.AuditDate; db.SubmitChanges(); } }
/// <summary> /// 根据主键删除管理规定 /// </summary> /// <param name="manageRuleId"></param> public static void DeleteManageRuleById(string manageRuleId) { Model.SUBHSSEDB db = Funs.DB; Model.Law_ManageRule manageRule = db.Law_ManageRule.FirstOrDefault(e => e.ManageRuleId == manageRuleId); if (manageRule != null) { //if (!string.IsNullOrEmpty(manageRule.AttachUrl)) //{ // BLL.UploadFileService.DeleteFile(Funs.RootPath, manageRule.AttachUrl); //} ////删除附件表 //BLL.CommonService.DeleteAttachFileById(manageRule.ManageRuleId); db.Law_ManageRule.DeleteOnSubmit(manageRule); db.SubmitChanges(); } }
/// <summary> /// 修改管理规定 /// </summary> /// <param name="manageRule"></param> public static void UpdateManageRule(Model.Law_ManageRule manageRule) { Model.SUBHSSEDB db = Funs.DB; Model.Law_ManageRule newManageRule = db.Law_ManageRule.FirstOrDefault(e => e.ManageRuleId == manageRule.ManageRuleId); if (newManageRule != null) { newManageRule.ManageRuleCode = manageRule.ManageRuleCode; newManageRule.ManageRuleName = manageRule.ManageRuleName; newManageRule.ManageRuleTypeId = manageRule.ManageRuleTypeId; newManageRule.VersionNo = manageRule.VersionNo; //newManageRule.CompileMan = manageRule.CompileMan; //newManageRule.CompileDate = manageRule.CompileDate; newManageRule.AttachUrl = manageRule.AttachUrl; newManageRule.Remark = manageRule.Remark; newManageRule.UpState = manageRule.UpState; newManageRule.SeeFile = manageRule.SeeFile; db.SubmitChanges(); } }
/// <summary> /// 添加管理规定 /// </summary> /// <param name="manageRule"></param> public static void AddManageRule(Model.Law_ManageRule manageRule) { Model.SUBHSSEDB db = Funs.DB; Model.Law_ManageRule newManageRule = new Model.Law_ManageRule { ManageRuleId = manageRule.ManageRuleId, ManageRuleCode = manageRule.ManageRuleCode, ManageRuleName = manageRule.ManageRuleName, ManageRuleTypeId = manageRule.ManageRuleTypeId, VersionNo = manageRule.VersionNo, AttachUrl = manageRule.AttachUrl, Remark = manageRule.Remark, CompileMan = manageRule.CompileMan, CompileDate = manageRule.CompileDate, IsPass = manageRule.IsPass, UnitId = manageRule.UnitId, UpState = manageRule.UpState, SeeFile = manageRule.SeeFile }; db.Law_ManageRule.InsertOnSubmit(newManageRule); db.SubmitChanges(); }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { if (ItemSelectedList.Count() > 0) { foreach (var item in ItemSelectedList) { Model.Law_ManageRule rule = BLL.ManageRuleService.GetManageRuleById(item); if (rule != null) { string newKeyID = SQLHelper.GetNewID(typeof(Model.ActionPlan_ManagerRule)); Model.ActionPlan_ManagerRule newManagerRule = new Model.ActionPlan_ManagerRule { ManagerRuleId = newKeyID, OldManageRuleId = rule.ManageRuleId, ProjectId = this.CurrUser.LoginProjectId, ManageRuleName = rule.ManageRuleName, ManageRuleTypeId = rule.ManageRuleTypeId, CompileDate = DateTime.Now, Remark = rule.Remark, CompileMan = this.CurrUser.UserId, IsIssue = false, Flag = true, State = BLL.Const.State_0, AttachUrl = rule.AttachUrl, SeeFile = rule.SeeFile }; BLL.ActionPlan_ManagerRuleService.AddManageRule(newManagerRule); ////保存流程审核数据 this.ctlAuditFlow.btnSaveData(this.CurrUser.LoginProjectId, BLL.Const.ActionPlan_ManagerRuleMenuId, newManagerRule.ManagerRuleId, true, newManagerRule.ManageRuleName, "../ActionPlan/ManagerRuleView.aspx?ManagerRuleId={0}"); Model.SUBHSSEDB db = Funs.DB; Model.AttachFile attachFile = db.AttachFile.FirstOrDefault(x => x.ToKeyId == item); if (attachFile != null) { Model.AttachFile newAttachFile = new Model.AttachFile { AttachFileId = SQLHelper.GetNewID(typeof(Model.AttachFile)), ToKeyId = newKeyID }; string[] urls = attachFile.AttachUrl.Split(','); foreach (string url in urls) { string urlStr = BLL.Funs.RootPath + url; if (File.Exists(urlStr)) { string newUrl = urlStr.Replace("ManageRule", "ActionPlanManagerRule"); if (!Directory.Exists(newUrl.Substring(0, newUrl.LastIndexOf("\\")))) { Directory.CreateDirectory(newUrl.Substring(0, newUrl.LastIndexOf("\\"))); } if (!File.Exists(newUrl)) { File.Copy(urlStr, newUrl); } } } newAttachFile.AttachSource = attachFile.AttachSource.Replace("ManageRule", "ActionPlanManagerRule"); newAttachFile.AttachUrl = attachFile.AttachUrl.Replace("ManageRule", "ActionPlanManagerRule"); newAttachFile.MenuId = BLL.Const.ActionPlan_ManagerRuleMenuId; db.AttachFile.InsertOnSubmit(newAttachFile); db.SubmitChanges(); } } } PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInParent("请至少选择一条记录!"); return; } }