/// <summary> /// 根据Id获取数据 /// </summary> /// <param name="AccidentCauseReportId"></param> public static void DeleteAccidentCauseReportByAccidentCauseReportId(string AccidentCauseReportId) { Model.SUBHSSEDB db = Funs.DB; Model.Information_AccidentCauseReport newAccidentCauseReport = db.Information_AccidentCauseReport.FirstOrDefault(e => e.AccidentCauseReportId == AccidentCauseReportId); if (newAccidentCauseReport != null) { ////删除审核流程表 BLL.CommonService.DeleteFlowOperateByID(AccidentCauseReportId); db.Information_AccidentCauseReport.DeleteOnSubmit(newAccidentCauseReport); db.SubmitChanges(); } }
/// <summary> /// 修改职工伤亡事故原因分析报表 /// </summary> /// <param name="AccidentCauseReport">职工伤亡事故原因分析报表实体</param> public static void UpdateAccidentCauseReport(Model.Information_AccidentCauseReport AccidentCauseReport) { Model.SUBHSSEDB db = Funs.DB; Model.Information_AccidentCauseReport newAccidentCauseReport = db.Information_AccidentCauseReport.FirstOrDefault(e => e.AccidentCauseReportId == AccidentCauseReport.AccidentCauseReportId); if (newAccidentCauseReport != null) { newAccidentCauseReport.AccidentCauseReportCode = AccidentCauseReport.AccidentCauseReportCode; newAccidentCauseReport.Year = AccidentCauseReport.Year; newAccidentCauseReport.Month = AccidentCauseReport.Month; newAccidentCauseReport.UnitId = AccidentCauseReport.UnitId; newAccidentCauseReport.DeathAccident = AccidentCauseReport.DeathAccident; newAccidentCauseReport.DeathToll = AccidentCauseReport.DeathToll; newAccidentCauseReport.InjuredAccident = AccidentCauseReport.InjuredAccident; newAccidentCauseReport.InjuredToll = AccidentCauseReport.InjuredToll; newAccidentCauseReport.MinorWoundAccident = AccidentCauseReport.MinorWoundAccident; newAccidentCauseReport.MinorWoundToll = AccidentCauseReport.MinorWoundToll; newAccidentCauseReport.AverageTotalHours = AccidentCauseReport.AverageTotalHours; newAccidentCauseReport.AverageManHours = AccidentCauseReport.AverageManHours; newAccidentCauseReport.TotalLossMan = AccidentCauseReport.TotalLossMan; newAccidentCauseReport.LastMonthLossHoursTotal = AccidentCauseReport.LastMonthLossHoursTotal; newAccidentCauseReport.KnockOffTotal = AccidentCauseReport.KnockOffTotal; newAccidentCauseReport.DirectLoss = AccidentCauseReport.DirectLoss; newAccidentCauseReport.IndirectLosses = AccidentCauseReport.IndirectLosses; newAccidentCauseReport.TotalLoss = AccidentCauseReport.TotalLoss; newAccidentCauseReport.TotalLossTime = AccidentCauseReport.TotalLossTime; newAccidentCauseReport.FillCompanyPersonCharge = AccidentCauseReport.FillCompanyPersonCharge; newAccidentCauseReport.TabPeople = AccidentCauseReport.TabPeople; newAccidentCauseReport.AuditPerson = AccidentCauseReport.AuditPerson; newAccidentCauseReport.FillCompanyPersonCharge = AccidentCauseReport.FillCompanyPersonCharge; newAccidentCauseReport.TabPeople = AccidentCauseReport.TabPeople; newAccidentCauseReport.AuditPerson = AccidentCauseReport.AuditPerson; newAccidentCauseReport.FillingDate = AccidentCauseReport.FillingDate; newAccidentCauseReport.UpState = AccidentCauseReport.UpState; newAccidentCauseReport.HandleState = AccidentCauseReport.HandleState; newAccidentCauseReport.HandleMan = AccidentCauseReport.HandleMan; db.SubmitChanges(); } }
/// <summary> /// 增加职工伤亡事故原因分析报表 /// </summary> /// <param name="AccidentCauseReport">职工伤亡事故原因分析报表实体</param> public static void AddAccidentCauseReport(Model.Information_AccidentCauseReport AccidentCauseReport) { Model.SUBHSSEDB db = Funs.DB; Model.Information_AccidentCauseReport newAccidentCauseReport = new Model.Information_AccidentCauseReport { AccidentCauseReportId = AccidentCauseReport.AccidentCauseReportId, AccidentCauseReportCode = AccidentCauseReport.AccidentCauseReportCode, Year = AccidentCauseReport.Year, Month = AccidentCauseReport.Month, UnitId = AccidentCauseReport.UnitId, DeathAccident = AccidentCauseReport.DeathAccident, DeathToll = AccidentCauseReport.DeathToll, InjuredAccident = AccidentCauseReport.InjuredAccident, InjuredToll = AccidentCauseReport.InjuredToll, MinorWoundAccident = AccidentCauseReport.MinorWoundAccident, MinorWoundToll = AccidentCauseReport.MinorWoundToll, AverageTotalHours = AccidentCauseReport.AverageTotalHours, AverageManHours = AccidentCauseReport.AverageManHours, TotalLossMan = AccidentCauseReport.TotalLossMan, LastMonthLossHoursTotal = AccidentCauseReport.LastMonthLossHoursTotal, KnockOffTotal = AccidentCauseReport.KnockOffTotal, DirectLoss = AccidentCauseReport.DirectLoss, IndirectLosses = AccidentCauseReport.IndirectLosses, TotalLoss = AccidentCauseReport.TotalLoss, TotalLossTime = AccidentCauseReport.TotalLossTime, FillCompanyPersonCharge = AccidentCauseReport.FillCompanyPersonCharge, TabPeople = AccidentCauseReport.TabPeople, FillingDate = AccidentCauseReport.FillingDate, AuditPerson = AccidentCauseReport.AuditPerson, UpState = AccidentCauseReport.UpState, HandleState = AccidentCauseReport.HandleState, HandleMan = AccidentCauseReport.HandleMan }; db.Information_AccidentCauseReport.InsertOnSubmit(newAccidentCauseReport); 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_DataIn_AccidentCauseReport> report = new List <Model.View_DataIn_AccidentCauseReport>(); if (Session["reports"] != null) { report = Session["reports"] as List <Model.View_DataIn_AccidentCauseReport>; } int a = report.Count(); for (int i = 0; i < a; i++) { string accidentCauseReportId = string.Empty; //判断职工伤亡事故原因分析是否存在 var isExist = BLL.AccidentCauseReportService.GetAccidentCauseReportByUnitIdAndYearAndMonth(report[i].UnitId, Convert.ToInt32(report[i].Year), Convert.ToInt32(report[i].Month)); if (isExist != null) { accidentCauseReportId = isExist.AccidentCauseReportId; } else { accidentCauseReportId = SQLHelper.GetNewID(typeof(Model.Information_AccidentCauseReport)); Model.Information_AccidentCauseReport newReport = new Model.Information_AccidentCauseReport { AccidentCauseReportId = accidentCauseReportId, UnitId = report[i].UnitId, AccidentCauseReportCode = report[i].AccidentCauseReportCode, Year = report[i].Year, Month = report[i].Month, DeathAccident = report[i].DeathAccident, DeathToll = report[i].DeathToll, InjuredAccident = report[i].InjuredAccident, InjuredToll = report[i].InjuredToll, MinorWoundAccident = report[i].MinorWoundAccident, MinorWoundToll = report[i].MinorWoundToll, AverageTotalHours = report[i].AverageTotalHours, AverageManHours = report[i].AverageManHours, TotalLossMan = report[i].TotalLossMan, LastMonthLossHoursTotal = report[i].LastMonthLossHoursTotal, KnockOffTotal = report[i].KnockOffTotal, DirectLoss = report[i].DirectLoss, IndirectLosses = report[i].IndirectLosses, TotalLoss = report[i].TotalLoss, TotalLossTime = report[i].TotalLossTime, FillCompanyPersonCharge = report[i].FillCompanyPersonCharge, TabPeople = this.CurrUser.UserName, AuditPerson = this.CurrUser.UserName, FillingDate = DateTime.Now, UpState = BLL.Const.UpState_2, HandleState = BLL.Const.HandleState_1, HandleMan = this.CurrUser.UserId }; BLL.AccidentCauseReportService.AddAccidentCauseReport(newReport); } Model.Information_AccidentCauseReportItem newReportItem = new Model.Information_AccidentCauseReportItem { AccidentCauseReportItemId = report[i].AccidentCauseReportItemId, AccidentCauseReportId = accidentCauseReportId, AccidentType = report[i].AccidentType, Death1 = report[i].Death1, Injuries1 = report[i].Injuries1, MinorInjuries1 = report[i].MinorInjuries1, Death2 = report[i].Death2, Injuries2 = report[i].Injuries2, MinorInjuries2 = report[i].MinorInjuries2, Death3 = report[i].Death3, Injuries3 = report[i].Injuries3, MinorInjuries3 = report[i].MinorInjuries3, Death4 = report[i].Death4, Injuries4 = report[i].Injuries4, MinorInjuries4 = report[i].MinorInjuries4, Death5 = report[i].Death5, Injuries5 = report[i].Injuries5, MinorInjuries5 = report[i].MinorInjuries5, Death6 = report[i].Death6, Injuries6 = report[i].Injuries6, MinorInjuries6 = report[i].MinorInjuries6, Death7 = report[i].Death7, Injuries7 = report[i].Injuries7, MinorInjuries7 = report[i].MinorInjuries7, Death8 = report[i].Death8, Injuries8 = report[i].Injuries8, MinorInjuries8 = report[i].MinorInjuries8, Death9 = report[i].Death9, Injuries9 = report[i].Injuries9, MinorInjuries9 = report[i].MinorInjuries9, Death10 = report[i].Death10, Injuries10 = report[i].Injuries10, MinorInjuries10 = report[i].MinorInjuries10, Death11 = report[i].Death11, Injuries11 = report[i].Injuries11, MinorInjuries11 = report[i].MinorInjuries11, TotalDeath = report[i].TotalDeath, TotalInjuries = report[i].TotalInjuries, TotalMinorInjuries = report[i].TotalMinorInjuries }; BLL.AccidentCauseReportItemService.AddAccidentCauseReportItem(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); } }