/// <summary>
/// 根据主键删除体检管理
/// </summary>
/// <param name="FileId"></param>
public static void DeletePhysicalExaminationById(string FileId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.OccupationHealth_PhysicalExamination PhysicalExamination = db.OccupationHealth_PhysicalExamination.FirstOrDefault(e => e.FileId == FileId);
if (PhysicalExamination != null)
{
///删除编码表记录
BLL.CodeRecordsService.DeleteCodeRecordsByDataId(FileId);
////删除附件表
BLL.CommonService.DeleteAttachFileById(PhysicalExamination.FileId);
BLL.CommonService.DeleteFlowOperateByID(FileId);
db.OccupationHealth_PhysicalExamination.DeleteOnSubmit(PhysicalExamination);
db.SubmitChanges();
}
}
/// <summary>
/// 修改体检管理
/// </summary>
/// <param name="PhysicalExamination"></param>
public static void UpdatePhysicalExamination(Model.OccupationHealth_PhysicalExamination PhysicalExamination)
{
Model.SUBHSSEDB db = Funs.DB;
Model.OccupationHealth_PhysicalExamination newPhysicalExamination = db.OccupationHealth_PhysicalExamination.FirstOrDefault(e => e.FileId == PhysicalExamination.FileId);
if (newPhysicalExamination != null)
{
newPhysicalExamination.FileCode = PhysicalExamination.FileCode;
newPhysicalExamination.FileName = PhysicalExamination.FileName;
newPhysicalExamination.FileContent = PhysicalExamination.FileContent;
newPhysicalExamination.CompileMan = PhysicalExamination.CompileMan;
newPhysicalExamination.CompileDate = PhysicalExamination.CompileDate;
newPhysicalExamination.AttachUrl = PhysicalExamination.AttachUrl;
newPhysicalExamination.States = PhysicalExamination.States;
db.SubmitChanges();
}
}
/// <summary>
/// 添加体检管理
/// </summary>
/// <param name="PhysicalExamination"></param>
public static void AddPhysicalExamination(Model.OccupationHealth_PhysicalExamination PhysicalExamination)
{
Model.SUBHSSEDB db = Funs.DB;
Model.OccupationHealth_PhysicalExamination newPhysicalExamination = new Model.OccupationHealth_PhysicalExamination
{
FileId = PhysicalExamination.FileId,
FileCode = PhysicalExamination.FileCode,
ProjectId = PhysicalExamination.ProjectId,
FileName = PhysicalExamination.FileName,
FileContent = PhysicalExamination.FileContent,
CompileMan = PhysicalExamination.CompileMan,
CompileDate = PhysicalExamination.CompileDate,
AttachUrl = PhysicalExamination.AttachUrl,
States = PhysicalExamination.States
};
db.OccupationHealth_PhysicalExamination.InsertOnSubmit(newPhysicalExamination);
db.SubmitChanges();
////增加一条编码记录
BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.PhysicalExaminationMenuId, PhysicalExamination.ProjectId, null, PhysicalExamination.FileId, PhysicalExamination.CompileDate);
}