/// <summary>
/// 增加职工伤亡事故原因分析报表明细表
/// </summary>
/// <param name="AccidentCauseReportItem">职工伤亡事故原因分析报表明细表实体</param>
public static void AddAccidentCauseReportItem(Model.Information_AccidentCauseReportItem AccidentCauseReportItem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Information_AccidentCauseReportItem newAccidentCauseReportItem = new Model.Information_AccidentCauseReportItem
{
AccidentCauseReportItemId = AccidentCauseReportItem.AccidentCauseReportItemId,
AccidentCauseReportId = AccidentCauseReportItem.AccidentCauseReportId,
AccidentType = AccidentCauseReportItem.AccidentType,
TotalDeath = AccidentCauseReportItem.TotalDeath,
TotalInjuries = AccidentCauseReportItem.TotalInjuries,
TotalMinorInjuries = AccidentCauseReportItem.TotalMinorInjuries,
Death1 = AccidentCauseReportItem.Death1,
Injuries1 = AccidentCauseReportItem.Injuries1,
MinorInjuries1 = AccidentCauseReportItem.MinorInjuries1,
Death2 = AccidentCauseReportItem.Death2,
Injuries2 = AccidentCauseReportItem.Injuries2,
MinorInjuries2 = AccidentCauseReportItem.MinorInjuries2,
Death3 = AccidentCauseReportItem.Death3,
Injuries3 = AccidentCauseReportItem.Injuries3,
MinorInjuries3 = AccidentCauseReportItem.MinorInjuries3,
Death4 = AccidentCauseReportItem.Death4,
Injuries4 = AccidentCauseReportItem.Injuries4,
MinorInjuries4 = AccidentCauseReportItem.MinorInjuries4,
Death5 = AccidentCauseReportItem.Death5,
Injuries5 = AccidentCauseReportItem.Injuries5,
MinorInjuries5 = AccidentCauseReportItem.MinorInjuries5,
Death6 = AccidentCauseReportItem.Death6,
Injuries6 = AccidentCauseReportItem.Injuries6,
MinorInjuries6 = AccidentCauseReportItem.MinorInjuries6,
Death7 = AccidentCauseReportItem.Death7,
Injuries7 = AccidentCauseReportItem.Injuries7,
MinorInjuries7 = AccidentCauseReportItem.MinorInjuries7,
Death8 = AccidentCauseReportItem.Death8,
Injuries8 = AccidentCauseReportItem.Injuries8,
MinorInjuries8 = AccidentCauseReportItem.MinorInjuries8,
Death9 = AccidentCauseReportItem.Death9,
Injuries9 = AccidentCauseReportItem.Injuries9,
MinorInjuries9 = AccidentCauseReportItem.MinorInjuries9,
Death10 = AccidentCauseReportItem.Death10,
Injuries10 = AccidentCauseReportItem.Injuries10,
MinorInjuries10 = AccidentCauseReportItem.MinorInjuries10,
Death11 = AccidentCauseReportItem.Death11,
Injuries11 = AccidentCauseReportItem.Injuries11,
MinorInjuries11 = AccidentCauseReportItem.MinorInjuries11
};
db.Information_AccidentCauseReportItem.InsertOnSubmit(newAccidentCauseReportItem);
db.SubmitChanges();
}
/// <summary>
/// 修改职工伤亡事故原因分析报表明细表
/// </summary>
/// <param name="AccidentCauseReportItem">职工伤亡事故原因分析报表明细表实体</param>
public static void UpdateAccidentCauseReportItem(Model.Information_AccidentCauseReportItem AccidentCauseReportItem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Information_AccidentCauseReportItem newAccidentCauseReportItem = db.Information_AccidentCauseReportItem.FirstOrDefault(e => e.AccidentCauseReportItemId == AccidentCauseReportItem.AccidentCauseReportItemId);
newAccidentCauseReportItem.AccidentType = AccidentCauseReportItem.AccidentType;
newAccidentCauseReportItem.TotalDeath = AccidentCauseReportItem.TotalDeath;
newAccidentCauseReportItem.TotalInjuries = AccidentCauseReportItem.TotalInjuries;
newAccidentCauseReportItem.TotalMinorInjuries = AccidentCauseReportItem.TotalMinorInjuries;
newAccidentCauseReportItem.Death1 = AccidentCauseReportItem.Death1;
newAccidentCauseReportItem.Injuries1 = AccidentCauseReportItem.Injuries1;
newAccidentCauseReportItem.MinorInjuries1 = AccidentCauseReportItem.MinorInjuries1;
newAccidentCauseReportItem.Death2 = AccidentCauseReportItem.Death2;
newAccidentCauseReportItem.Injuries2 = AccidentCauseReportItem.Injuries2;
newAccidentCauseReportItem.MinorInjuries2 = AccidentCauseReportItem.MinorInjuries2;
newAccidentCauseReportItem.Death3 = AccidentCauseReportItem.Death3;
newAccidentCauseReportItem.Injuries3 = AccidentCauseReportItem.Injuries3;
newAccidentCauseReportItem.MinorInjuries3 = AccidentCauseReportItem.MinorInjuries3;
newAccidentCauseReportItem.Death4 = AccidentCauseReportItem.Death4;
newAccidentCauseReportItem.Injuries4 = AccidentCauseReportItem.Injuries4;
newAccidentCauseReportItem.MinorInjuries4 = AccidentCauseReportItem.MinorInjuries4;
newAccidentCauseReportItem.Death5 = AccidentCauseReportItem.Death5;
newAccidentCauseReportItem.Injuries5 = AccidentCauseReportItem.Injuries5;
newAccidentCauseReportItem.MinorInjuries5 = AccidentCauseReportItem.MinorInjuries5;
newAccidentCauseReportItem.Death6 = AccidentCauseReportItem.Death6;
newAccidentCauseReportItem.Injuries6 = AccidentCauseReportItem.Injuries6;
newAccidentCauseReportItem.MinorInjuries6 = AccidentCauseReportItem.MinorInjuries6;
newAccidentCauseReportItem.Death7 = AccidentCauseReportItem.Death7;
newAccidentCauseReportItem.Injuries7 = AccidentCauseReportItem.Injuries7;
newAccidentCauseReportItem.MinorInjuries7 = AccidentCauseReportItem.MinorInjuries7;
newAccidentCauseReportItem.Death8 = AccidentCauseReportItem.Death8;
newAccidentCauseReportItem.Injuries8 = AccidentCauseReportItem.Injuries8;
newAccidentCauseReportItem.MinorInjuries8 = AccidentCauseReportItem.MinorInjuries8;
newAccidentCauseReportItem.Death9 = AccidentCauseReportItem.Death9;
newAccidentCauseReportItem.Injuries9 = AccidentCauseReportItem.Injuries9;
newAccidentCauseReportItem.MinorInjuries9 = AccidentCauseReportItem.MinorInjuries9;
newAccidentCauseReportItem.Death10 = AccidentCauseReportItem.Death10;
newAccidentCauseReportItem.Injuries10 = AccidentCauseReportItem.Injuries10;
newAccidentCauseReportItem.MinorInjuries10 = AccidentCauseReportItem.MinorInjuries10;
newAccidentCauseReportItem.Death11 = AccidentCauseReportItem.Death11;
newAccidentCauseReportItem.Injuries11 = AccidentCauseReportItem.Injuries11;
newAccidentCauseReportItem.MinorInjuries11 = AccidentCauseReportItem.MinorInjuries11;
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);
}
}
