/// <summary>
///根据主键删除安全评价
/// </summary>
/// <param name="appraise"></param>
public static void DeleteAppraiseById(string appraiseId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Technique_Appraise appraise = db.Technique_Appraise.FirstOrDefault(e => e.AppraiseId == appraiseId);
if (appraise != null)
{
if (!string.IsNullOrEmpty(appraise.AttachUrl))
{
BLL.UploadFileService.DeleteFile(Funs.RootPath, appraise.AttachUrl);
}
////删除附件表
BLL.CommonService.DeleteAttachFileById(appraise.AppraiseId);
db.Technique_Appraise.DeleteOnSubmit(appraise);
db.SubmitChanges();
}
}
/// <summary>
/// 修改安全评价信息
/// </summary>
/// <param name="appraise"></param>
public static void UpdateAppraise(Model.Technique_Appraise appraise)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Technique_Appraise newAppraise = db.Technique_Appraise.FirstOrDefault(e => e.AppraiseId == appraise.AppraiseId);
if (newAppraise != null)
{
newAppraise.AppraiseCode = appraise.AppraiseCode;
newAppraise.AppraiseTitle = appraise.AppraiseTitle;
newAppraise.Abstract = appraise.Abstract;
newAppraise.AppraiseDate = appraise.AppraiseDate;
newAppraise.ArrangementPerson = appraise.ArrangementPerson;
newAppraise.AttachUrl = appraise.AttachUrl;
newAppraise.ArrangementDate = appraise.ArrangementDate;
newAppraise.UpState = appraise.UpState;
db.SubmitChanges();
}
}
/// <summary>
/// 添加安全评价信息
/// </summary>
/// <param name="appraise"></param>
public static void AddAppraise(Model.Technique_Appraise appraise)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Technique_Appraise newAppraise = new Model.Technique_Appraise
{
AppraiseId = appraise.AppraiseId,
AppraiseCode = appraise.AppraiseCode,
AppraiseTitle = appraise.AppraiseTitle,
Abstract = appraise.Abstract,
AppraiseDate = appraise.AppraiseDate,
ArrangementPerson = appraise.ArrangementPerson,
AttachUrl = appraise.AttachUrl,
ArrangementDate = appraise.ArrangementDate,
UnitId = appraise.UnitId,
IsPass = appraise.IsPass,
UpState = appraise.UpState
};
db.Technique_Appraise.InsertOnSubmit(newAppraise);
db.SubmitChanges();
}
