/// <summary>
/// 修改事故处理
/// </summary>
/// <param name="accidentStatistics"></param>
public static void UpdateAccidentStatistics(Model.ProjectAccident_AccidentStatistics accidentStatistics)
{
Model.SUBHSSEDB db = Funs.DB;
Model.ProjectAccident_AccidentStatistics newAccidentStatistics = db.ProjectAccident_AccidentStatistics.FirstOrDefault(e => e.AccidentStatisticsId == accidentStatistics.AccidentStatisticsId);
if (newAccidentStatistics != null)
{
newAccidentStatistics.ProjectId = accidentStatistics.ProjectId;
newAccidentStatistics.UnitId = accidentStatistics.UnitId;
newAccidentStatistics.Person = accidentStatistics.Person;
newAccidentStatistics.Treatment = accidentStatistics.Treatment;
newAccidentStatistics.CompileDate = accidentStatistics.CompileDate;
newAccidentStatistics.AttachUrl = accidentStatistics.AttachUrl;
newAccidentStatistics.States = accidentStatistics.States;
db.SubmitChanges();
}
}
/// <summary>
/// 添加事故处理
/// </summary>
/// <param name="accidentStatistics"></param>
public static void AddAccidentStatistics(Model.ProjectAccident_AccidentStatistics accidentStatistics)
{
Model.SUBHSSEDB db = Funs.DB;
Model.ProjectAccident_AccidentStatistics newAccidentStatistics = new Model.ProjectAccident_AccidentStatistics
{
AccidentStatisticsId = accidentStatistics.AccidentStatisticsId,
ProjectId = accidentStatistics.ProjectId,
UnitId = accidentStatistics.UnitId,
Person = accidentStatistics.Person,
Treatment = accidentStatistics.Treatment,
CompileDate = accidentStatistics.CompileDate,
AttachUrl = accidentStatistics.AttachUrl,
States = accidentStatistics.States
};
db.ProjectAccident_AccidentStatistics.InsertOnSubmit(newAccidentStatistics);
db.SubmitChanges();
}
/// <summary>
/// 根据主键删除事故处理
/// </summary>
/// <param name="accidentStatisticsId"></param>
public static void DeleteAccidentStatisticsById(string accidentStatisticsId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.ProjectAccident_AccidentStatistics accidentStatistics = db.ProjectAccident_AccidentStatistics.FirstOrDefault(e => e.AccidentStatisticsId == accidentStatisticsId);
if (accidentStatistics != null)
{
if (!string.IsNullOrEmpty(accidentStatistics.AttachUrl))
{
BLL.UploadFileService.DeleteFile(Funs.RootPath, accidentStatistics.AttachUrl);//删除附件
}
////删除附件表
BLL.CommonService.DeleteAttachFileById(accidentStatistics.AccidentStatisticsId);
///删除编码表记录
BLL.CodeRecordsService.DeleteCodeRecordsByDataId(accidentStatistics.AccidentStatisticsId);
////删除流程表
BLL.CommonService.DeleteFlowOperateByID(accidentStatistics.AccidentStatisticsId);
db.ProjectAccident_AccidentStatistics.DeleteOnSubmit(accidentStatistics);
db.SubmitChanges();
}
}
