/// <summary>
/// 修改安全文件
/// </summary>
/// <param name="SafeReport">安全文件实体</param>
public static void UpdateSafeReport(Model.Manager_SafeReport SafeReport)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Manager_SafeReport newSafeReport = db.Manager_SafeReport.First(e => e.SafeReportId == SafeReport.SafeReportId);
newSafeReport.SafeReportCode = SafeReport.SafeReportCode;
newSafeReport.SafeReportName = SafeReport.SafeReportName;
newSafeReport.SupSafeReportId = SafeReport.SupSafeReportId;
newSafeReport.Requirement = SafeReport.Requirement;
newSafeReport.RequestTime = SafeReport.RequestTime;
newSafeReport.CompileManId = SafeReport.CompileManId;
newSafeReport.CompileTime = SafeReport.CompileTime;
newSafeReport.IsEndLever = SafeReport.IsEndLever;
newSafeReport.States = SafeReport.States;
db.SubmitChanges();
}
/// <summary>
/// 添加安全文件
/// </summary>
/// <param name="SafeReport">安全文件实体</param>
public static void AddSafeReport(Model.Manager_SafeReport SafeReport)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Manager_SafeReport newSafeReport = new Model.Manager_SafeReport
{
SafeReportId = SafeReport.SafeReportId,
SafeReportCode = SafeReport.SafeReportCode,
SafeReportName = SafeReport.SafeReportName,
SupSafeReportId = SafeReport.SupSafeReportId,
Requirement = SafeReport.Requirement,
RequestTime = SafeReport.RequestTime,
CompileManId = SafeReport.CompileManId,
CompileTime = SafeReport.CompileTime,
IsEndLever = SafeReport.IsEndLever,
States = SafeReport.States
};
db.Manager_SafeReport.InsertOnSubmit(newSafeReport);
db.SubmitChanges();
}
/// <summary>
/// 根据安全文件Id删除一个安全文件
/// </summary>
/// <param name="safeReportId">安全文件ID</param>
public static void DeleteSafeReportBySafeReportId(string safeReportId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Manager_SafeReport delSafeReport = db.Manager_SafeReport.FirstOrDefault(e => e.SafeReportId == safeReportId);
if (delSafeReport != null)
{
var items = SafeReportItemService.GetSafeReportItemListBySafeReportId(safeReportId);
foreach (var item in items)
{
SafeReportItemService.DeleteSafeReportItemBySafeReportItemId(item.SafeReportItemId);
}
var unitItems = SafeReportUnitItemService.GetSafeReportUnitItemListBySafeReportId(safeReportId);
foreach (var item in unitItems)
{
SafeReportUnitItemService.DeleteSafeReportUnitItemBySafeReportUnitItemId(item.SafeReportUnitItemId);
}
db.Manager_SafeReport.DeleteOnSubmit(delSafeReport);
db.SubmitChanges();
}
}
/// <summary>
/// 根据安全文件Id查询安全文件实体
/// </summary>
/// <param name="SafeReportId">安全文件主键</param>
/// <returns>安全文件实体</returns>
public static Model.Manager_SafeReport GetSafeReportBySafeReportId(string SafeReportId)
{
Model.Manager_SafeReport SafeReport = Funs.DB.Manager_SafeReport.FirstOrDefault(e => e.SafeReportId == SafeReportId);
return(SafeReport);
}