/// <summary> /// 根据主键删除应急演练工作计划半年报 /// </summary> /// <param name="drillPlanHalfYearReportId"></param> public static void DeleteDrillPlanHalfYearReportById(string drillPlanHalfYearReportId) { Model.SUBHSSEDB db = Funs.DB; Model.Information_DrillPlanHalfYearReport drillPlanHalfYearReport = db.Information_DrillPlanHalfYearReport.FirstOrDefault(e => e.DrillPlanHalfYearReportId == drillPlanHalfYearReportId); if (drillPlanHalfYearReport != null) { db.Information_DrillPlanHalfYearReport.DeleteOnSubmit(drillPlanHalfYearReport); db.SubmitChanges(); } }
/// <summary> /// 修改应急演练工作计划半年报 /// </summary> /// <param name="drillPlanHalfYearReport"></param> public static void UpdateDrillPlanHalfYearReport(Model.Information_DrillPlanHalfYearReport drillPlanHalfYearReport) { Model.SUBHSSEDB db = Funs.DB; Model.Information_DrillPlanHalfYearReport newDrillPlanHalfYearReport = db.Information_DrillPlanHalfYearReport.FirstOrDefault(e => e.DrillPlanHalfYearReportId == drillPlanHalfYearReport.DrillPlanHalfYearReportId); if (newDrillPlanHalfYearReport != null) { newDrillPlanHalfYearReport.UnitId = drillPlanHalfYearReport.UnitId; newDrillPlanHalfYearReport.CompileMan = drillPlanHalfYearReport.CompileMan; newDrillPlanHalfYearReport.CompileDate = drillPlanHalfYearReport.CompileDate; newDrillPlanHalfYearReport.YearId = drillPlanHalfYearReport.YearId; newDrillPlanHalfYearReport.HalfYearId = drillPlanHalfYearReport.HalfYearId; newDrillPlanHalfYearReport.Telephone = drillPlanHalfYearReport.Telephone; newDrillPlanHalfYearReport.UpState = drillPlanHalfYearReport.UpState; newDrillPlanHalfYearReport.HandleState = drillPlanHalfYearReport.HandleState; newDrillPlanHalfYearReport.HandleMan = drillPlanHalfYearReport.HandleMan; db.SubmitChanges(); } }
/// <summary> /// 添加应急演练工作计划半年报 /// </summary> /// <param name="drillPlanHalfYearReport"></param> public static void AddDrillPlanHalfYearReport(Model.Information_DrillPlanHalfYearReport drillPlanHalfYearReport) { Model.SUBHSSEDB db = Funs.DB; Model.Information_DrillPlanHalfYearReport newDrillPlanHalfYearReport = new Model.Information_DrillPlanHalfYearReport { DrillPlanHalfYearReportId = drillPlanHalfYearReport.DrillPlanHalfYearReportId, UnitId = drillPlanHalfYearReport.UnitId, CompileMan = drillPlanHalfYearReport.CompileMan, CompileDate = drillPlanHalfYearReport.CompileDate, YearId = drillPlanHalfYearReport.YearId, HalfYearId = drillPlanHalfYearReport.HalfYearId, Telephone = drillPlanHalfYearReport.Telephone, UpState = drillPlanHalfYearReport.UpState, HandleState = drillPlanHalfYearReport.HandleState, HandleMan = drillPlanHalfYearReport.HandleMan }; db.Information_DrillPlanHalfYearReport.InsertOnSubmit(newDrillPlanHalfYearReport); db.SubmitChanges(); }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { if (errorInfos.Count <= 0) { List <Model.View_Information_DrillPlanHalfYearReportItem> report = new List <Model.View_Information_DrillPlanHalfYearReportItem>(); if (Session["reports"] != null) { report = Session["reports"] as List <Model.View_Information_DrillPlanHalfYearReportItem>; } int a = report.Count(); for (int i = 0; i < a; i++) { string drillPlanHalfYearReportId = string.Empty; //判断应急演练工作计划半年报是否存在 var isExist = BLL.DrillPlanHalfYearReportService.GetDrillPlanHalfYearReportByUnitIdDate(report[i].UnitId, Convert.ToInt32(report[i].YearId), Convert.ToInt32(report[i].HalfYearId)); if (isExist != null) { drillPlanHalfYearReportId = isExist.DrillPlanHalfYearReportId; } else { drillPlanHalfYearReportId = SQLHelper.GetNewID(typeof(Model.Information_DrillPlanHalfYearReport)); Model.Information_DrillPlanHalfYearReport newReport = new Model.Information_DrillPlanHalfYearReport { DrillPlanHalfYearReportId = drillPlanHalfYearReportId, UnitId = report[i].UnitId, YearId = report[i].YearId, HalfYearId = report[i].HalfYearId, Telephone = report[i].Telephone, CompileDate = DateTime.Now, CompileMan = this.CurrUser.UserName, HandleMan = this.CurrUser.UserId, UpState = BLL.Const.UpState_2, HandleState = BLL.Const.HandleState_1 }; BLL.DrillPlanHalfYearReportService.AddDrillPlanHalfYearReport(newReport); } Model.Information_DrillPlanHalfYearReportItem newReportItem = new Model.Information_DrillPlanHalfYearReportItem { DrillPlanHalfYearReportItemId = report[i].DrillPlanHalfYearReportItemId, DrillPlanHalfYearReportId = drillPlanHalfYearReportId, DrillPlanName = report[i].DrillPlanName, OrganizationUnit = report[i].OrganizationUnit, DrillPlanDate = report[i].DrillPlanDate, AccidentScene = report[i].AccidentScene, ExerciseWay = report[i].ExerciseWay, SortIndex = i }; BLL.DrillPlanHalfYearReportItemService.AddDrillPlanHalfYearReportItem(newReportItem); } string rootPath = Server.MapPath("~/"); string initFullPath = rootPath + initPath; string filePath = initFullPath + this.hdFileName.Text; if (filePath != string.Empty && System.IO.File.Exists(filePath)) { System.IO.File.Delete(filePath);//删除上传的XLS文件 } ShowNotify("导入成功!", MessageBoxIcon.Success); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { ShowNotify("请先将错误数据修正,再重新导入保存!", MessageBoxIcon.Warning); } }