/// <summary>
/// 添加应急预案管理
/// </summary>
/// <param name="EmergencyList"></param>
public static void AddEmergencyList(Model.Emergency_EmergencyList EmergencyList)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Emergency_EmergencyList newEmergencyList = new Model.Emergency_EmergencyList
{
EmergencyListId = EmergencyList.EmergencyListId,
ProjectId = EmergencyList.ProjectId,
EmergencyCode = EmergencyList.EmergencyCode,
EmergencyName = EmergencyList.EmergencyName,
UnitId = EmergencyList.UnitId,
EmergencyTypeId = EmergencyList.EmergencyTypeId,
VersionCode = EmergencyList.VersionCode,
EmergencyContents = EmergencyList.EmergencyContents,
CompileMan = EmergencyList.CompileMan,
CompileDate = EmergencyList.CompileDate,
States = EmergencyList.States,
AttachUrl = EmergencyList.AttachUrl,
AuditMan = EmergencyList.AuditMan,
ApproveMan = EmergencyList.ApproveMan
};
db.Emergency_EmergencyList.InsertOnSubmit(newEmergencyList);
db.SubmitChanges();
////增加一条编码记录
BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.ProjectEmergencyListMenuId, EmergencyList.ProjectId, null, EmergencyList.EmergencyListId, EmergencyList.CompileDate);
}
/// <summary>
/// 根据主键删除应急预案管理
/// </summary>
/// <param name="EmergencyListId"></param>
public static void DeleteEmergencyListById(string EmergencyListId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Emergency_EmergencyList EmergencyList = db.Emergency_EmergencyList.FirstOrDefault(e => e.EmergencyListId == EmergencyListId);
if (EmergencyList != null)
{
///删除编码表记录
BLL.CodeRecordsService.DeleteCodeRecordsByDataId(EmergencyList.EmergencyListId);
////删除附件表
BLL.CommonService.DeleteAttachFileById(EmergencyList.EmergencyListId);
////删除流程表
BLL.CommonService.DeleteFlowOperateByID(EmergencyList.EmergencyListId);
db.Emergency_EmergencyList.DeleteOnSubmit(EmergencyList);
db.SubmitChanges();
}
}
/// <summary>
/// 修改应急预案管理
/// </summary>
/// <param name="EmergencyList"></param>
public static void UpdateEmergencyList(Model.Emergency_EmergencyList EmergencyList)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Emergency_EmergencyList newEmergencyList = db.Emergency_EmergencyList.FirstOrDefault(e => e.EmergencyListId == EmergencyList.EmergencyListId);
if (newEmergencyList != null)
{
newEmergencyList.EmergencyCode = EmergencyList.EmergencyCode;
newEmergencyList.EmergencyName = EmergencyList.EmergencyName;
newEmergencyList.UnitId = EmergencyList.UnitId;
newEmergencyList.EmergencyTypeId = EmergencyList.EmergencyTypeId;
newEmergencyList.VersionCode = EmergencyList.VersionCode;
newEmergencyList.EmergencyContents = EmergencyList.EmergencyContents;
newEmergencyList.CompileMan = EmergencyList.CompileMan;
newEmergencyList.CompileDate = EmergencyList.CompileDate;
newEmergencyList.States = EmergencyList.States;
newEmergencyList.AttachUrl = EmergencyList.AttachUrl;
newEmergencyList.AuditMan = EmergencyList.AuditMan;
newEmergencyList.ApproveMan = EmergencyList.ApproveMan;
db.SubmitChanges();
}
}
/// <summary>
/// 保存emergencyInfo
/// </summary>
/// <param name="emergencyInfo">会议信息</param>
/// <returns></returns>
public static void SaveEmergency(Model.FileInfoItem emergencyInfo)
{
using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString))
{
string menuId = string.Empty;
if (emergencyInfo.MenuType == "1")
{
Model.Emergency_EmergencyList newEmergency = new Model.Emergency_EmergencyList
{
EmergencyListId = emergencyInfo.FileId,
ProjectId = emergencyInfo.ProjectId,
UnitId = emergencyInfo.UnitId == "" ? null : emergencyInfo.UnitId,
EmergencyTypeId = emergencyInfo.FileType == "" ? null : emergencyInfo.FileType,
EmergencyCode = emergencyInfo.FileCode,
EmergencyName = emergencyInfo.FileName,
EmergencyContents = emergencyInfo.FileContent,
CompileMan = emergencyInfo.CompileManId,
CompileDate = Funs.GetNewDateTime(emergencyInfo.CompileDate),
States = Const.State_2,
};
if (!string.IsNullOrEmpty(emergencyInfo.AuditManId))
{
newEmergency.AuditMan = emergencyInfo.AuditManId;
}
if (!string.IsNullOrEmpty(emergencyInfo.ApproveManId))
{
newEmergency.ApproveMan = emergencyInfo.ApproveManId;
}
if (emergencyInfo.States != Const.State_1)
{
newEmergency.States = Const.State_0;
}
var updateEmergency = db.Emergency_EmergencyList.FirstOrDefault(x => x.EmergencyListId == emergencyInfo.FileId);
if (updateEmergency == null)
{
newEmergency.CompileDate = DateTime.Now;
emergencyInfo.FileId = newEmergency.EmergencyListId = SQLHelper.GetNewID();
newEmergency.EmergencyCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectClassMeetingMenuId, newEmergency.ProjectId, null);
db.Emergency_EmergencyList.InsertOnSubmit(newEmergency);
db.SubmitChanges();
////增加一条编码记录
CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectEmergencyListMenuId, newEmergency.ProjectId, null, newEmergency.EmergencyListId, newEmergency.CompileDate);
}
else
{
updateEmergency.EmergencyName = newEmergency.EmergencyName;
updateEmergency.UnitId = newEmergency.UnitId;
updateEmergency.EmergencyTypeId = newEmergency.EmergencyTypeId;
updateEmergency.EmergencyContents = newEmergency.EmergencyContents;
updateEmergency.AuditMan = newEmergency.AuditMan;
updateEmergency.ApproveMan = newEmergency.ApproveMan;
db.SubmitChanges();
}
if (emergencyInfo.States == Const.State_1)
{
CommonService.btnSaveData(newEmergency.ProjectId, Const.ProjectEmergencyListMenuId, newEmergency.EmergencyListId, newEmergency.CompileMan, true, newEmergency.EmergencyName, "../Emergency/EmergencyListView.aspx?EmergencyListId={0}");
}
menuId = Const.ProjectEmergencyListMenuId;
}
else if (emergencyInfo.MenuType == "2")
{
Model.Emergency_EmergencySupply newEmergency = new Model.Emergency_EmergencySupply
{
FileId = emergencyInfo.FileId,
ProjectId = emergencyInfo.ProjectId,
UnitId = emergencyInfo.UnitId == "" ? null : emergencyInfo.UnitId,
FileCode = emergencyInfo.FileCode,
FileName = emergencyInfo.FileName,
FileContent = emergencyInfo.FileContent,
CompileMan = emergencyInfo.CompileManId,
CompileDate = Funs.GetNewDateTime(emergencyInfo.CompileDate),
States = Const.State_2,
};
if (emergencyInfo.States != Const.State_1)
{
newEmergency.States = Const.State_0;
}
var updateEmergency = db.Emergency_EmergencySupply.FirstOrDefault(x => x.FileId == emergencyInfo.FileId);
if (updateEmergency == null)
{
newEmergency.CompileDate = DateTime.Now;
emergencyInfo.FileId = newEmergency.FileId = SQLHelper.GetNewID();
newEmergency.FileCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectEmergencySupplyMenuId, newEmergency.ProjectId, null);
db.Emergency_EmergencySupply.InsertOnSubmit(newEmergency);
}
else
{
updateEmergency.UnitId = newEmergency.UnitId;
updateEmergency.FileCode = newEmergency.FileCode;
updateEmergency.FileName = newEmergency.FileName;
updateEmergency.FileContent = newEmergency.FileContent;
db.SubmitChanges();
}
if (emergencyInfo.States == Const.State_1)
{
CommonService.btnSaveData(newEmergency.ProjectId, Const.ProjectEmergencySupplyMenuId, newEmergency.FileId, newEmergency.CompileMan, true, newEmergency.FileName, "../Emergency/EmergencySupplyView.aspx?FileId={0}");
}
menuId = Const.ProjectEmergencySupplyMenuId;
}
else if (emergencyInfo.MenuType == "3")
{
Model.Emergency_EmergencyTeamAndTrain newEmergency = new Model.Emergency_EmergencyTeamAndTrain
{
FileId = emergencyInfo.FileId,
ProjectId = emergencyInfo.ProjectId,
UnitId = emergencyInfo.UnitId == "" ? null : emergencyInfo.UnitId,
FileCode = emergencyInfo.FileCode,
FileName = emergencyInfo.FileName,
FileContent = emergencyInfo.FileContent,
CompileMan = emergencyInfo.CompileManId,
CompileDate = Funs.GetNewDateTime(emergencyInfo.CompileDate),
States = Const.State_2,
};
if (emergencyInfo.States != Const.State_1)
{
newEmergency.States = Const.State_0;
}
var updateEmergency = db.Emergency_EmergencyTeamAndTrain.FirstOrDefault(x => x.FileId == emergencyInfo.FileId);
if (updateEmergency == null)
{
newEmergency.CompileDate = DateTime.Now;
emergencyInfo.FileId = newEmergency.FileId = SQLHelper.GetNewID();
newEmergency.FileCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectEmergencyTeamAndTrainMenuId, newEmergency.ProjectId, null);
db.Emergency_EmergencyTeamAndTrain.InsertOnSubmit(newEmergency);
}
else
{
updateEmergency.UnitId = newEmergency.UnitId;
updateEmergency.FileCode = newEmergency.FileCode;
updateEmergency.FileName = newEmergency.FileName;
updateEmergency.FileContent = newEmergency.FileContent;
db.SubmitChanges();
var delItem = from x in db.Emergency_EmergencyTeamItem where x.FileId == updateEmergency.FileId select x;
if (delItem.Count() > 0)
{
db.Emergency_EmergencyTeamItem.DeleteAllOnSubmit(delItem);
db.SubmitChanges();
}
}
if (emergencyInfo.EmergencyTeamItem != null && emergencyInfo.EmergencyTeamItem.Count() > 0)
{
var getItems = from x in emergencyInfo.EmergencyTeamItem
select new Model.Emergency_EmergencyTeamItem
{
EmergencyTeamItemId = x.EmergencyTeamItemId,
FileId = x.FileId,
PersonId = x.PersonId,
Job = x.Job,
Tel = x.Tel,
};
if (getItems.Count() > 0)
{
Funs.DB.Emergency_EmergencyTeamItem.InsertAllOnSubmit(getItems);
Funs.DB.SubmitChanges();
}
}
if (emergencyInfo.States == Const.State_1)
{
CommonService.btnSaveData(newEmergency.ProjectId, Const.ProjectEmergencyTeamAndTrainMenuId, newEmergency.FileId, newEmergency.CompileMan, true, newEmergency.FileName, "../Emergency/EmergencyTeamAndTrainView.aspx?FileId={0}");
}
menuId = Const.ProjectEmergencyTeamAndTrainMenuId;
}
else
{
}
///// 附件保存
if (!string.IsNullOrEmpty(menuId) && !string.IsNullOrEmpty(emergencyInfo.FileId))
{
APIUpLoadFileService.SaveAttachUrl(menuId, emergencyInfo.FileId, emergencyInfo.AttachUrl, "0");
}
}
}
