/// <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);
}
}
