/// <summary>
/// 删除
/// </summary>
/// <param name="safetyInstitutionId"></param>
public static void DeleteSafetyInstitutionById(string safetyInstitutionId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SecuritySystem_SafetyInstitution safetyInstitution = db.SecuritySystem_SafetyInstitution.FirstOrDefault(e => e.SafetyInstitutionId == safetyInstitutionId);
if (safetyInstitution != null)
{
if (!string.IsNullOrEmpty(safetyInstitution.AttachUrl))
{
BLL.UploadAttachmentService.DeleteFile(Funs.RootPath, safetyInstitution.AttachUrl);//删除附件
}
db.SecuritySystem_SafetyInstitution.DeleteOnSubmit(safetyInstitution);
db.SubmitChanges();
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="safetyInstitution"></param>
public static void UpdateSafetyInstitution(Model.SecuritySystem_SafetyInstitution safetyInstitution)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SecuritySystem_SafetyInstitution newSafetyInstitution = db.SecuritySystem_SafetyInstitution.FirstOrDefault(e => e.SafetyInstitutionId == safetyInstitution.SafetyInstitutionId);
if (newSafetyInstitution != null)
{
newSafetyInstitution.Title = safetyInstitution.Title;
newSafetyInstitution.EffectiveDate = safetyInstitution.EffectiveDate;
newSafetyInstitution.Scope = safetyInstitution.Scope;
newSafetyInstitution.Remark = safetyInstitution.Remark;
newSafetyInstitution.AttachUrl = safetyInstitution.AttachUrl;
newSafetyInstitution.SeeFile = safetyInstitution.SeeFile;
db.SubmitChanges();
}
}
/// <summary>
/// 添加安全制度
/// </summary>
/// <param name="safetyInstitution"></param>
public static void AddSafetyInstitution(Model.SecuritySystem_SafetyInstitution safetyInstitution)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SecuritySystem_SafetyInstitution newSafetyInstitution = new Model.SecuritySystem_SafetyInstitution
{
SafetyInstitutionId = safetyInstitution.SafetyInstitutionId,
ProjectId = safetyInstitution.ProjectId,
Title = safetyInstitution.Title,
EffectiveDate = safetyInstitution.EffectiveDate,
Scope = safetyInstitution.Scope,
Remark = safetyInstitution.Remark,
AttachUrl = safetyInstitution.AttachUrl,
SeeFile = safetyInstitution.SeeFile,
UnitId = safetyInstitution.UnitId
};
db.SecuritySystem_SafetyInstitution.InsertOnSubmit(newSafetyInstitution);
db.SubmitChanges();
}