/// <summary>
/// 修改安全组织体系
/// </summary>
/// <param name="safetySystem"></param>
public static void UpdateSafetySystem(Model.SecuritySystem_SafetySystem safetySystem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SecuritySystem_SafetySystem newSafetySystem = db.SecuritySystem_SafetySystem.FirstOrDefault(e => e.SafetySystemId == safetySystem.SafetySystemId);
if (newSafetySystem != null)
{
newSafetySystem.Remark = safetySystem.Remark;
newSafetySystem.AttachUrl = safetySystem.AttachUrl;
newSafetySystem.SeeFile = safetySystem.SeeFile;
db.SubmitChanges();
}
}
/// <summary>
/// 添加安全组织体系
/// </summary>
/// <param name="safetySystem"></param>
public static void AddSafetySystem(Model.SecuritySystem_SafetySystem safetySystem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SecuritySystem_SafetySystem newSafetySystem = new Model.SecuritySystem_SafetySystem
{
SafetySystemId = safetySystem.SafetySystemId,
ProjectId = safetySystem.ProjectId,
Remark = safetySystem.Remark,
AttachUrl = safetySystem.AttachUrl,
SeeFile = safetySystem.SeeFile,
UnitId = safetySystem.UnitId
};
db.SecuritySystem_SafetySystem.InsertOnSubmit(newSafetySystem);
db.SubmitChanges();
}
/// <summary>
/// 根据主键删除安全组织体系
/// </summary>
/// <param name="SafetySystemId"></param>
public static void DeleteSafetySystem(string SafetySystemId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SecuritySystem_SafetySystem safetySystem = db.SecuritySystem_SafetySystem.FirstOrDefault(e => e.SafetySystemId == SafetySystemId);
if (safetySystem != null)
{
if (!string.IsNullOrEmpty(safetySystem.AttachUrl))
{
BLL.UploadAttachmentService.DeleteFile(Funs.RootPath, safetySystem.AttachUrl);//删除附件
}
////删除附件表
BLL.CommonService.DeleteAttachFileById(safetySystem.SafetySystemId);
db.SecuritySystem_SafetySystem.DeleteOnSubmit(safetySystem);
db.SubmitChanges();
}
}
