/// <summary>
/// 根据主键删除
/// </summary>
/// <param name="drillPlanHalfYearReportItemId"></param>
public static void DeleteDrillPlanHalfYearReportItemById(string drillPlanHalfYearReportItemId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Information_DrillPlanHalfYearReportItem drillPlanHalfYearReportItem = db.Information_DrillPlanHalfYearReportItem.FirstOrDefault(e => e.DrillPlanHalfYearReportItemId == drillPlanHalfYearReportItemId);
if (drillPlanHalfYearReportItem != null)
{
db.Information_DrillPlanHalfYearReportItem.DeleteOnSubmit(drillPlanHalfYearReportItem);
db.SubmitChanges();
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="drillPlanHalfYearReportItem"></param>
public static void UpdateDrillPlanHalfYearReportItem(Model.Information_DrillPlanHalfYearReportItem drillPlanHalfYearReportItem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Information_DrillPlanHalfYearReportItem newDrillPlanHalfYearReportItem = db.Information_DrillPlanHalfYearReportItem.FirstOrDefault(e => e.DrillPlanHalfYearReportItemId == drillPlanHalfYearReportItem.DrillPlanHalfYearReportItemId);
if (newDrillPlanHalfYearReportItem != null)
{
//newDrillPlanHalfYearReportItem.DrillPlanHalfYearReportId = drillPlanHalfYearReportItem.DrillPlanHalfYearReportId;
newDrillPlanHalfYearReportItem.DrillPlanName = drillPlanHalfYearReportItem.DrillPlanName;
newDrillPlanHalfYearReportItem.OrganizationUnit = drillPlanHalfYearReportItem.OrganizationUnit;
newDrillPlanHalfYearReportItem.DrillPlanDate = drillPlanHalfYearReportItem.DrillPlanDate;
newDrillPlanHalfYearReportItem.AccidentScene = drillPlanHalfYearReportItem.AccidentScene;
newDrillPlanHalfYearReportItem.ExerciseWay = drillPlanHalfYearReportItem.ExerciseWay;
newDrillPlanHalfYearReportItem.SortIndex = drillPlanHalfYearReportItem.SortIndex;
db.SubmitChanges();
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="drillPlanHalfYearReportItem"></param>
public static void AddDrillPlanHalfYearReportItem(Model.Information_DrillPlanHalfYearReportItem drillPlanHalfYearReportItem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Information_DrillPlanHalfYearReportItem newDrillPlanHalfYearReportItem = new Model.Information_DrillPlanHalfYearReportItem
{
DrillPlanHalfYearReportItemId = drillPlanHalfYearReportItem.DrillPlanHalfYearReportItemId,
DrillPlanHalfYearReportId = drillPlanHalfYearReportItem.DrillPlanHalfYearReportId,
DrillPlanName = drillPlanHalfYearReportItem.DrillPlanName,
OrganizationUnit = drillPlanHalfYearReportItem.OrganizationUnit,
DrillPlanDate = drillPlanHalfYearReportItem.DrillPlanDate,
AccidentScene = drillPlanHalfYearReportItem.AccidentScene,
ExerciseWay = drillPlanHalfYearReportItem.ExerciseWay,
SortIndex = drillPlanHalfYearReportItem.SortIndex
};
db.Information_DrillPlanHalfYearReportItem.InsertOnSubmit(newDrillPlanHalfYearReportItem);
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);
}
}
