/// <summary>
/// 增加百万工时安全统计月报表明细表
/// </summary>
/// <param name="MillionsMonthlyReportItem">百万工时安全统计月报表明细表实体</param>
public static void AddMillionsMonthlyReportItem(Model.Information_MillionsMonthlyReportItem MillionsMonthlyReportItem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Information_MillionsMonthlyReportItem newMillionsMonthlyReportItem = new Model.Information_MillionsMonthlyReportItem
{
MillionsMonthlyReportItemId = MillionsMonthlyReportItem.MillionsMonthlyReportItemId,
MillionsMonthlyReportId = MillionsMonthlyReportItem.MillionsMonthlyReportId,
SortIndex = MillionsMonthlyReportItem.SortIndex,
Affiliation = MillionsMonthlyReportItem.Affiliation,
Name = MillionsMonthlyReportItem.Name,
PostPersonNum = MillionsMonthlyReportItem.PostPersonNum,
SnapPersonNum = MillionsMonthlyReportItem.SnapPersonNum,
ContractorNum = MillionsMonthlyReportItem.ContractorNum,
SumPersonNum = MillionsMonthlyReportItem.SumPersonNum,
TotalWorkNum = MillionsMonthlyReportItem.TotalWorkNum,
SeriousInjuriesNum = MillionsMonthlyReportItem.SeriousInjuriesNum,
SeriousInjuriesPersonNum = MillionsMonthlyReportItem.SeriousInjuriesPersonNum,
SeriousInjuriesLossHour = MillionsMonthlyReportItem.SeriousInjuriesLossHour,
MinorAccidentNum = MillionsMonthlyReportItem.MinorAccidentNum,
MinorAccidentPersonNum = MillionsMonthlyReportItem.MinorAccidentPersonNum,
MinorAccidentLossHour = MillionsMonthlyReportItem.MinorAccidentLossHour,
OtherAccidentNum = MillionsMonthlyReportItem.OtherAccidentNum,
OtherAccidentPersonNum = MillionsMonthlyReportItem.OtherAccidentPersonNum,
OtherAccidentLossHour = MillionsMonthlyReportItem.OtherAccidentLossHour,
RestrictedWorkPersonNum = MillionsMonthlyReportItem.RestrictedWorkPersonNum,
RestrictedWorkLossHour = MillionsMonthlyReportItem.RestrictedWorkLossHour,
MedicalTreatmentPersonNum = MillionsMonthlyReportItem.MedicalTreatmentPersonNum,
MedicalTreatmentLossHour = MillionsMonthlyReportItem.MedicalTreatmentLossHour,
FireNum = MillionsMonthlyReportItem.FireNum,
ExplosionNum = MillionsMonthlyReportItem.ExplosionNum,
TrafficNum = MillionsMonthlyReportItem.TrafficNum,
EquipmentNum = MillionsMonthlyReportItem.EquipmentNum,
QualityNum = MillionsMonthlyReportItem.QualityNum,
OtherNum = MillionsMonthlyReportItem.OtherNum,
FirstAidDressingsNum = MillionsMonthlyReportItem.FirstAidDressingsNum,
AttemptedEventNum = MillionsMonthlyReportItem.AttemptedEventNum,
LossDayNum = MillionsMonthlyReportItem.LossDayNum
};
db.Information_MillionsMonthlyReportItem.InsertOnSubmit(newMillionsMonthlyReportItem);
db.SubmitChanges();
}
/// <summary>
/// 修改百万工时安全统计月报表明细表
/// </summary>
/// <param name="MillionsMonthlyReportItem">百万工时安全统计月报表明细表实体</param>
public static void UpdateMillionsMonthlyReportItem(Model.Information_MillionsMonthlyReportItem MillionsMonthlyReportItem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Information_MillionsMonthlyReportItem newMillionsMonthlyReportItem = db.Information_MillionsMonthlyReportItem.FirstOrDefault(e => e.MillionsMonthlyReportItemId == MillionsMonthlyReportItem.MillionsMonthlyReportItemId);
newMillionsMonthlyReportItem.SortIndex = MillionsMonthlyReportItem.SortIndex;
newMillionsMonthlyReportItem.Affiliation = MillionsMonthlyReportItem.Affiliation;
newMillionsMonthlyReportItem.Name = MillionsMonthlyReportItem.Name;
newMillionsMonthlyReportItem.PostPersonNum = MillionsMonthlyReportItem.PostPersonNum;
newMillionsMonthlyReportItem.SnapPersonNum = MillionsMonthlyReportItem.SnapPersonNum;
newMillionsMonthlyReportItem.ContractorNum = MillionsMonthlyReportItem.ContractorNum;
newMillionsMonthlyReportItem.SumPersonNum = MillionsMonthlyReportItem.SumPersonNum;
newMillionsMonthlyReportItem.TotalWorkNum = MillionsMonthlyReportItem.TotalWorkNum;
newMillionsMonthlyReportItem.SeriousInjuriesNum = MillionsMonthlyReportItem.SeriousInjuriesNum;
newMillionsMonthlyReportItem.SeriousInjuriesPersonNum = MillionsMonthlyReportItem.SeriousInjuriesPersonNum;
newMillionsMonthlyReportItem.SeriousInjuriesLossHour = MillionsMonthlyReportItem.SeriousInjuriesLossHour;
newMillionsMonthlyReportItem.MinorAccidentNum = MillionsMonthlyReportItem.MinorAccidentNum;
newMillionsMonthlyReportItem.MinorAccidentPersonNum = MillionsMonthlyReportItem.MinorAccidentPersonNum;
newMillionsMonthlyReportItem.MinorAccidentLossHour = MillionsMonthlyReportItem.MinorAccidentLossHour;
newMillionsMonthlyReportItem.OtherAccidentNum = MillionsMonthlyReportItem.OtherAccidentNum;
newMillionsMonthlyReportItem.OtherAccidentPersonNum = MillionsMonthlyReportItem.OtherAccidentPersonNum;
newMillionsMonthlyReportItem.OtherAccidentLossHour = MillionsMonthlyReportItem.OtherAccidentLossHour;
newMillionsMonthlyReportItem.RestrictedWorkPersonNum = MillionsMonthlyReportItem.RestrictedWorkPersonNum;
newMillionsMonthlyReportItem.RestrictedWorkLossHour = MillionsMonthlyReportItem.RestrictedWorkLossHour;
newMillionsMonthlyReportItem.MedicalTreatmentPersonNum = MillionsMonthlyReportItem.MedicalTreatmentPersonNum;
newMillionsMonthlyReportItem.MedicalTreatmentLossHour = MillionsMonthlyReportItem.MedicalTreatmentLossHour;
newMillionsMonthlyReportItem.FireNum = MillionsMonthlyReportItem.FireNum;
newMillionsMonthlyReportItem.ExplosionNum = MillionsMonthlyReportItem.ExplosionNum;
newMillionsMonthlyReportItem.TrafficNum = MillionsMonthlyReportItem.TrafficNum;
newMillionsMonthlyReportItem.EquipmentNum = MillionsMonthlyReportItem.EquipmentNum;
newMillionsMonthlyReportItem.QualityNum = MillionsMonthlyReportItem.QualityNum;
newMillionsMonthlyReportItem.OtherNum = MillionsMonthlyReportItem.OtherNum;
newMillionsMonthlyReportItem.FirstAidDressingsNum = MillionsMonthlyReportItem.FirstAidDressingsNum;
newMillionsMonthlyReportItem.AttemptedEventNum = MillionsMonthlyReportItem.AttemptedEventNum;
newMillionsMonthlyReportItem.LossDayNum = MillionsMonthlyReportItem.LossDayNum;
db.SubmitChanges();
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
int PostPersonNumSum = 0, SnapPersonNumSum = 0, ContractorNumSum = 0, SumPersonNumSum = 0, SeriousInjuriesNumSum = 0, SeriousInjuriesPersonNumSum = 0, SeriousInjuriesLossHourSum = 0, MinorAccidentNumSum = 0, MinorAccidentPersonNumSum = 0, MinorAccidentLossHourSum = 0, OtherAccidentNumSum = 0, OtherAccidentPersonNumSum = 0, OtherAccidentLossHourSum = 0, RestrictedWorkPersonNumSum = 0, RestrictedWorkLossHourSum = 0, MedicalTreatmentPersonNumSum = 0, MedicalTreatmentLossHourSum = 0, FireNumSum = 0, ExplosionNumSum = 0, TrafficNumSum = 0, EquipmentNumSum = 0, QualityNumSum = 0, OtherNumSum = 0, FirstAidDressingsNumSum = 0, AttemptedEventNumSum = 0, LossDayNumSum = 0;
decimal TotalWorkNumSum = 0;
if (errorInfos.Count <= 0)
{
List <Model.View_DataIn_MillionsMonthlyReport> report = new List <Model.View_DataIn_MillionsMonthlyReport>();
if (Session["reports"] != null)
{
report = Session["reports"] as List <Model.View_DataIn_MillionsMonthlyReport>;
}
int a = report.Count();
for (int i = 0; i < a; i++)
{
MillionsMonthlyReportId = string.Empty;
//判断百万工时安全统计月报是否存在
var isExist = BLL.MillionsMonthlyReportService.GetMillionsMonthlyReportByUnitIdAndYearAndMonth(report[i].UnitId, Convert.ToInt32(report[i].Year), Convert.ToInt32(report[i].Month));
if (isExist != null)
{
MillionsMonthlyReportId = isExist.MillionsMonthlyReportId;
}
else
{
MillionsMonthlyReportId = SQLHelper.GetNewID(typeof(Model.Information_MillionsMonthlyReport));
Model.Information_MillionsMonthlyReport newReport = new Model.Information_MillionsMonthlyReport
{
MillionsMonthlyReportId = MillionsMonthlyReportId,
UnitId = report[i].UnitId,
Year = report[i].Year,
Month = report[i].Month,
FillingMan = this.CurrUser.UserName,
FillingDate = DateTime.Now,
DutyPerson = report[i].DutyPerson,
RecordableIncidentRate = report[i].RecordableIncidentRate,
LostTimeRate = report[i].LostTimeRate,
LostTimeInjuryRate = report[i].LostTimeInjuryRate,
DeathAccidentFrequency = report[i].DeathAccidentFrequency,
AccidentMortality = report[i].AccidentMortality,
UpState = BLL.Const.UpState_2,
HandleState = BLL.Const.HandleState_1,
HandleMan = this.CurrUser.UserId
};
BLL.MillionsMonthlyReportService.AddMillionsMonthlyReport(newReport);
}
Model.Information_MillionsMonthlyReportItem newReportItem = new Model.Information_MillionsMonthlyReportItem
{
MillionsMonthlyReportItemId = report[i].MillionsMonthlyReportItemId,
MillionsMonthlyReportId = MillionsMonthlyReportId,
Affiliation = report[i].Affiliation,
Name = report[i].Name,
PostPersonNum = report[i].PostPersonNum,
SnapPersonNum = report[i].SnapPersonNum,
ContractorNum = report[i].ContractorNum,
SumPersonNum = report[i].SumPersonNum,
TotalWorkNum = report[i].TotalWorkNum,
SeriousInjuriesNum = report[i].SeriousInjuriesNum,
SeriousInjuriesPersonNum = report[i].SeriousInjuriesPersonNum,
SeriousInjuriesLossHour = report[i].SeriousInjuriesLossHour,
MinorAccidentNum = report[i].MinorAccidentNum,
MinorAccidentPersonNum = report[i].MinorAccidentPersonNum,
MinorAccidentLossHour = report[i].MinorAccidentLossHour,
OtherAccidentNum = report[i].OtherAccidentNum,
OtherAccidentPersonNum = report[i].OtherAccidentPersonNum,
OtherAccidentLossHour = report[i].OtherAccidentLossHour,
RestrictedWorkPersonNum = report[i].RestrictedWorkPersonNum,
RestrictedWorkLossHour = report[i].RestrictedWorkLossHour,
MedicalTreatmentPersonNum = report[i].MedicalTreatmentPersonNum,
MedicalTreatmentLossHour = report[i].MedicalTreatmentLossHour,
FireNum = report[i].FireNum,
ExplosionNum = report[i].ExplosionNum,
TrafficNum = report[i].TrafficNum,
EquipmentNum = report[i].EquipmentNum,
QualityNum = report[i].QualityNum,
OtherNum = report[i].OtherNum,
FirstAidDressingsNum = report[i].FirstAidDressingsNum,
AttemptedEventNum = report[i].AttemptedEventNum,
LossDayNum = report[i].LossDayNum
};
var sortIndexMax = ((from x in Funs.DB.Information_MillionsMonthlyReportItem where x.MillionsMonthlyReportId == MillionsMonthlyReportId select x.SortIndex).Max());
if (sortIndexMax != null)
{
newReportItem.SortIndex = sortIndexMax + 10;
}
else
{
newReportItem.SortIndex = i + 10;
}
PostPersonNumSum += Convert.ToInt32(newReportItem.PostPersonNum);
SnapPersonNumSum += Convert.ToInt32(newReportItem.SnapPersonNum);
ContractorNumSum += Convert.ToInt32(newReportItem.ContractorNum);
SumPersonNumSum += Convert.ToInt32(newReportItem.SumPersonNum);
TotalWorkNumSum += Convert.ToDecimal(newReportItem.TotalWorkNum);
SeriousInjuriesNumSum += Convert.ToInt32(newReportItem.SeriousInjuriesNum);
SeriousInjuriesPersonNumSum += Convert.ToInt32(newReportItem.SeriousInjuriesPersonNum);
SeriousInjuriesLossHourSum += Convert.ToInt32(newReportItem.SeriousInjuriesLossHour);
MinorAccidentNumSum += Convert.ToInt32(newReportItem.MinorAccidentNum);
MinorAccidentPersonNumSum += Convert.ToInt32(newReportItem.MinorAccidentPersonNum);
MinorAccidentLossHourSum += Convert.ToInt32(newReportItem.MinorAccidentLossHour);
OtherAccidentNumSum += Convert.ToInt32(newReportItem.OtherAccidentNum);
OtherAccidentPersonNumSum += Convert.ToInt32(newReportItem.OtherAccidentPersonNum);
OtherAccidentLossHourSum += Convert.ToInt32(newReportItem.OtherAccidentLossHour);
RestrictedWorkPersonNumSum += Convert.ToInt32(newReportItem.RestrictedWorkPersonNum);
RestrictedWorkLossHourSum += Convert.ToInt32(newReportItem.RestrictedWorkLossHour);
MedicalTreatmentPersonNumSum += Convert.ToInt32(newReportItem.MedicalTreatmentPersonNum);
MedicalTreatmentLossHourSum += Convert.ToInt32(newReportItem.MedicalTreatmentLossHour);
FireNumSum += Convert.ToInt32(newReportItem.FireNum);
ExplosionNumSum += Convert.ToInt32(newReportItem.ExplosionNum);
TrafficNumSum += Convert.ToInt32(newReportItem.TrafficNum);
EquipmentNumSum += Convert.ToInt32(newReportItem.EquipmentNum);
QualityNumSum += Convert.ToInt32(newReportItem.QualityNum);
OtherNumSum += Convert.ToInt32(newReportItem.OtherNum);
FirstAidDressingsNumSum += Convert.ToInt32(newReportItem.FirstAidDressingsNum);
AttemptedEventNumSum += Convert.ToInt32(newReportItem.AttemptedEventNum);
LossDayNumSum += Convert.ToInt32(newReportItem.LossDayNum);
BLL.MillionsMonthlyReportItemService.AddMillionsMonthlyReportItem(newReportItem);
}
//增加本月合计数
Model.Information_MillionsMonthlyReportItem totalItem = new Model.Information_MillionsMonthlyReportItem
{
MillionsMonthlyReportItemId = SQLHelper.GetNewID(typeof(Model.Information_MillionsMonthlyReportItem)),
MillionsMonthlyReportId = MillionsMonthlyReportId
};
var sort = ((from x in Funs.DB.Information_MillionsMonthlyReportItem where x.MillionsMonthlyReportId == MillionsMonthlyReportId select x.SortIndex).Max());
if (sort != null)
{
totalItem.SortIndex = sort + 10;
}
totalItem.Affiliation = "本月合计";
totalItem.Name = "本月合计";
totalItem.PostPersonNum = PostPersonNumSum;
totalItem.SnapPersonNum = SnapPersonNumSum;
totalItem.ContractorNum = ContractorNumSum;
totalItem.SumPersonNum = SumPersonNumSum;
totalItem.TotalWorkNum = TotalWorkNumSum;
totalItem.SeriousInjuriesNum = SeriousInjuriesNumSum;
totalItem.SeriousInjuriesPersonNum = SeriousInjuriesPersonNumSum;
totalItem.SeriousInjuriesLossHour = SeriousInjuriesLossHourSum;
totalItem.MinorAccidentNum = MinorAccidentNumSum;
totalItem.MinorAccidentPersonNum = MinorAccidentPersonNumSum;
totalItem.MinorAccidentLossHour = MinorAccidentLossHourSum;
totalItem.OtherAccidentNum = OtherAccidentNumSum;
totalItem.OtherAccidentPersonNum = OtherAccidentPersonNumSum;
totalItem.OtherAccidentLossHour = OtherAccidentLossHourSum;
totalItem.RestrictedWorkPersonNum = RestrictedWorkPersonNumSum;
totalItem.RestrictedWorkLossHour = RestrictedWorkLossHourSum;
totalItem.MedicalTreatmentPersonNum = MedicalTreatmentPersonNumSum;
totalItem.MedicalTreatmentLossHour = MedicalTreatmentLossHourSum;
totalItem.FireNum = FireNumSum;
totalItem.ExplosionNum = ExplosionNumSum;
totalItem.TrafficNum = TrafficNumSum;
totalItem.EquipmentNum = EquipmentNumSum;
totalItem.QualityNum = QualityNumSum;
totalItem.OtherNum = OtherNumSum;
totalItem.FirstAidDressingsNum = FirstAidDressingsNumSum;
totalItem.AttemptedEventNum = AttemptedEventNumSum;
totalItem.LossDayNum = LossDayNumSum;
BLL.MillionsMonthlyReportItemService.AddMillionsMonthlyReportItem(totalItem);
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);
}
}
