/// <summary> /// 修改 /// </summary> /// <param name="MonthPlan"></param> public static void UpdateMonthPlan(Model.SiteConstruction_MonthPlan MonthPlan) { Model.SUBHSSEDB db = Funs.DB; Model.SiteConstruction_MonthPlan newMonthPlan = db.SiteConstruction_MonthPlan.FirstOrDefault(e => e.MonthPlanId == MonthPlan.MonthPlanId); if (newMonthPlan != null) { newMonthPlan.CompileDate = MonthPlan.CompileDate; newMonthPlan.JobContent = MonthPlan.JobContent; newMonthPlan.AttachUrl = MonthPlan.AttachUrl; newMonthPlan.SeeFile = MonthPlan.SeeFile; newMonthPlan.States = MonthPlan.States; db.SubmitChanges(); } }
/// <summary> /// 删除 /// </summary> /// <param name="MonthPlanId"></param> public static void DeleteMonthPlanById(string MonthPlanId) { Model.SUBHSSEDB db = Funs.DB; Model.SiteConstruction_MonthPlan MonthPlan = db.SiteConstruction_MonthPlan.FirstOrDefault(e => e.MonthPlanId == MonthPlanId); if (MonthPlan != null) { if (!string.IsNullOrEmpty(MonthPlan.AttachUrl)) { BLL.UploadAttachmentService.DeleteFile(Funs.RootPath, MonthPlan.AttachUrl);//删除附件 } BLL.CommonService.DeleteFlowOperateByID(MonthPlanId); db.SiteConstruction_MonthPlan.DeleteOnSubmit(MonthPlan); db.SubmitChanges(); } }
/// <summary> /// 添加月度计划 /// </summary> /// <param name="MonthPlan"></param> public static void AddMonthPlan(Model.SiteConstruction_MonthPlan MonthPlan) { Model.SUBHSSEDB db = Funs.DB; Model.SiteConstruction_MonthPlan newMonthPlan = new Model.SiteConstruction_MonthPlan { MonthPlanId = MonthPlan.MonthPlanId, ProjectId = MonthPlan.ProjectId, UnitId = MonthPlan.UnitId, Months = MonthPlan.Months, CompileMan = MonthPlan.CompileMan, CompileDate = MonthPlan.CompileDate, JobContent = MonthPlan.JobContent, AttachUrl = MonthPlan.AttachUrl, SeeFile = MonthPlan.SeeFile, States = MonthPlan.States }; db.SiteConstruction_MonthPlan.InsertOnSubmit(newMonthPlan); db.SubmitChanges(); }