/// <summary>
/// 根据主键删除应急演练
/// </summary>
/// <param name="DrillRecordListId"></param>
public static void DeleteDrillRecordListById(string DrillRecordListId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Emergency_DrillRecordList DrillRecordList = db.Emergency_DrillRecordList.FirstOrDefault(e => e.DrillRecordListId == DrillRecordListId);
if (DrillRecordList != null)
{
///删除编码表记录
BLL.CodeRecordsService.DeleteCodeRecordsByDataId(DrillRecordList.DrillRecordListId);
////删除附件表
BLL.CommonService.DeleteAttachFileById(DrillRecordList.DrillRecordListId);
///删除工程师日志收集记录
var flowOperate = from x in db.Sys_FlowOperate where x.DataId == DrillRecordList.DrillRecordListId select x;
if (flowOperate.Count() > 0)
{
foreach (var item in flowOperate)
{
BLL.HSSELogService.CollectHSSELog(DrillRecordList.ProjectId, item.OperaterId, item.OperaterTime, "26", "应急演练:" + DrillRecordList.DrillRecordName, Const.BtnDelete, 1);
}
////删除流程表
BLL.CommonService.DeleteFlowOperateByID(DrillRecordList.DrillRecordListId);
}
db.Emergency_DrillRecordList.DeleteOnSubmit(DrillRecordList);
db.SubmitChanges();
}
}
/// <summary>
/// 添加应急演练
/// </summary>
/// <param name="DrillRecordList"></param>
public static void AddDrillRecordList(Model.Emergency_DrillRecordList DrillRecordList)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Emergency_DrillRecordList newDrillRecordList = new Model.Emergency_DrillRecordList
{
DrillRecordListId = DrillRecordList.DrillRecordListId,
ProjectId = DrillRecordList.ProjectId,
DrillRecordCode = DrillRecordList.DrillRecordCode,
DrillRecordName = DrillRecordList.DrillRecordName,
UnitIds = DrillRecordList.UnitIds,
UnitNames = DrillRecordList.UnitNames,
UserIds = DrillRecordList.UserIds,
UserNames = DrillRecordList.UserNames,
DrillRecordDate = DrillRecordList.DrillRecordDate,
DrillRecordContents = DrillRecordList.DrillRecordContents,
CompileMan = DrillRecordList.CompileMan,
CompileDate = System.DateTime.Now,
States = DrillRecordList.States,
AttachUrl = DrillRecordList.AttachUrl,
DrillRecordType = DrillRecordList.DrillRecordType,
JointPersonNum = DrillRecordList.JointPersonNum,
DrillCost = DrillRecordList.DrillCost
};
db.Emergency_DrillRecordList.InsertOnSubmit(newDrillRecordList);
db.SubmitChanges();
////增加一条编码记录
BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.ProjectDrillRecordListMenuId, DrillRecordList.ProjectId, null, DrillRecordList.DrillRecordListId, DrillRecordList.DrillRecordDate);
}
/// <summary>
/// 修改应急演练
/// </summary>
/// <param name="DrillRecordList"></param>
public static void UpdateDrillRecordList(Model.Emergency_DrillRecordList DrillRecordList)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Emergency_DrillRecordList newDrillRecordList = db.Emergency_DrillRecordList.FirstOrDefault(e => e.DrillRecordListId == DrillRecordList.DrillRecordListId);
if (newDrillRecordList != null)
{
newDrillRecordList.DrillRecordCode = DrillRecordList.DrillRecordCode;
newDrillRecordList.DrillRecordName = DrillRecordList.DrillRecordName;
newDrillRecordList.UnitIds = DrillRecordList.UnitIds;
newDrillRecordList.UnitNames = DrillRecordList.UnitNames;
newDrillRecordList.UserIds = DrillRecordList.UserIds;
newDrillRecordList.UserNames = DrillRecordList.UserNames;
newDrillRecordList.DrillRecordDate = DrillRecordList.DrillRecordDate;
newDrillRecordList.DrillRecordContents = DrillRecordList.DrillRecordContents;
newDrillRecordList.CompileMan = DrillRecordList.CompileMan;
//newDrillRecordList.CompileDate = DrillRecordList.CompileDate;
newDrillRecordList.States = DrillRecordList.States;
newDrillRecordList.AttachUrl = DrillRecordList.AttachUrl;
newDrillRecordList.DrillRecordType = DrillRecordList.DrillRecordType;
newDrillRecordList.JointPersonNum = DrillRecordList.JointPersonNum;
newDrillRecordList.DrillCost = DrillRecordList.DrillCost;
db.SubmitChanges();
}
}