/// <summary>
/// 修改专项方案 是否采用
/// </summary>
/// <param name="specialSchemeList"></param>
public static void UpdateSpecialSchemeListIsPass(Model.Technique_SpecialScheme specialSchemeList)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Technique_SpecialScheme newSpecialSchemeList = db.Technique_SpecialScheme.FirstOrDefault(e => e.SpecialSchemeId == specialSchemeList.SpecialSchemeId);
if (newSpecialSchemeList != null)
{
newSpecialSchemeList.AuditMan = specialSchemeList.AuditMan;
newSpecialSchemeList.AuditDate = specialSchemeList.AuditDate;
newSpecialSchemeList.IsPass = specialSchemeList.IsPass;
db.SubmitChanges();
}
}
/// <summary>
/// 修改专项方案
/// </summary>
/// <param name="specialSchemeList"></param>
public static void UpdateSpecialSchemeList(Model.Technique_SpecialScheme specialSchemeList)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Technique_SpecialScheme newSpecialSchemeList = db.Technique_SpecialScheme.FirstOrDefault(e => e.SpecialSchemeId == specialSchemeList.SpecialSchemeId);
if (newSpecialSchemeList != null)
{
newSpecialSchemeList.SpecialSchemeTypeId = specialSchemeList.SpecialSchemeTypeId;
newSpecialSchemeList.SpecialSchemeCode = specialSchemeList.SpecialSchemeCode;
newSpecialSchemeList.SpecialSchemeName = specialSchemeList.SpecialSchemeName;
newSpecialSchemeList.Summary = specialSchemeList.Summary;
newSpecialSchemeList.AttachUrl = specialSchemeList.AttachUrl;
newSpecialSchemeList.CompileMan = specialSchemeList.CompileMan;
newSpecialSchemeList.CompileDate = specialSchemeList.CompileDate;
newSpecialSchemeList.UnitId = specialSchemeList.UnitId;
newSpecialSchemeList.UpState = specialSchemeList.UpState;
db.SubmitChanges();
}
}
/// <summary>
///根据主键删除专项方案
/// </summary>
/// <param name="specialSchemeId"></param>
public static void DeleteSpecialSchemeListById(string specialSchemeId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Technique_SpecialScheme specialSchemeList = db.Technique_SpecialScheme.FirstOrDefault(e => e.SpecialSchemeId == specialSchemeId);
if (specialSchemeList != null)
{
if (!string.IsNullOrEmpty(specialSchemeList.AttachUrl))
{
BLL.UploadFileService.DeleteFile(Funs.RootPath, specialSchemeList.AttachUrl);
}
////删除附件表
BLL.CommonService.DeleteAttachFileById(specialSchemeList.SpecialSchemeId);
db.Technique_SpecialScheme.DeleteOnSubmit(specialSchemeList);
db.SubmitChanges();
}
}
/// <summary>
/// 添加专项方案
/// </summary>
/// <param name="specialSchemeList"></param>
public static void AddSpecialSchemeList(Model.Technique_SpecialScheme specialSchemeList)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Technique_SpecialScheme newSpecialSchemeList = new Model.Technique_SpecialScheme
{
SpecialSchemeId = specialSchemeList.SpecialSchemeId,
SpecialSchemeTypeId = specialSchemeList.SpecialSchemeTypeId,
SpecialSchemeCode = specialSchemeList.SpecialSchemeCode,
SpecialSchemeName = specialSchemeList.SpecialSchemeName,
Summary = specialSchemeList.Summary,
AttachUrl = specialSchemeList.AttachUrl,
CompileMan = specialSchemeList.CompileMan,
CompileDate = specialSchemeList.CompileDate,
UnitId = specialSchemeList.UnitId
};
newSpecialSchemeList.CompileMan = specialSchemeList.CompileMan;
newSpecialSchemeList.CompileDate = specialSchemeList.CompileDate;
newSpecialSchemeList.IsPass = specialSchemeList.IsPass;
newSpecialSchemeList.UpState = specialSchemeList.UpState;
db.Technique_SpecialScheme.InsertOnSubmit(newSpecialSchemeList);
db.SubmitChanges();
}
