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