108 lines
4.7 KiB
C#
108 lines
4.7 KiB
C#
using System.Collections.Generic;
|
|
using System.Linq;
|
|
|
|
namespace BLL
|
|
{
|
|
/// <summary>
|
|
/// 季节性/节假日检查明细表
|
|
/// </summary>
|
|
public static class Check_CheckHolidayDetailService
|
|
{
|
|
/// <summary>
|
|
/// 根据季节性/节假日检查id获取所有相关明细信息
|
|
/// </summary>
|
|
/// <param name="CheckRectifyId"></param>
|
|
/// <returns></returns>
|
|
public static List<Model.Check_CheckHolidayDetail> GetCheckHolidayDetailByCheckHolidayId(string checkHolidayId)
|
|
{
|
|
return (from x in Funs.DB.Check_CheckHolidayDetail where x.CheckHolidayId == checkHolidayId select x).ToList();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据主键获取季节性/节假日检查明细信息
|
|
/// </summary>
|
|
/// <param name="checkHolidayDetailId"></param>
|
|
/// <returns></returns>
|
|
public static Model.Check_CheckHolidayDetail GetCheckHolidayDetailByCheckHolidayDetailId(string checkHolidayDetailId)
|
|
{
|
|
return Funs.DB.Check_CheckHolidayDetail.FirstOrDefault(e => e.CheckHolidayDetailId == checkHolidayDetailId);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 增加季节性/节假日检查明细信息
|
|
/// </summary>
|
|
/// <param name="CheckHolidayDetail"></param>
|
|
public static void AddCheckHolidayDetail(Model.Check_CheckHolidayDetail CheckHolidayDetail)
|
|
{
|
|
Model.Check_CheckHolidayDetail newCheckHolidayDetail = new Model.Check_CheckHolidayDetail
|
|
{
|
|
CheckHolidayDetailId = CheckHolidayDetail.CheckHolidayDetailId,
|
|
CheckHolidayId = CheckHolidayDetail.CheckHolidayId,
|
|
CheckItem = CheckHolidayDetail.CheckItem,
|
|
CheckResult = CheckHolidayDetail.CheckResult,
|
|
CheckOpinion = CheckHolidayDetail.CheckOpinion,
|
|
CheckStation = CheckHolidayDetail.CheckStation,
|
|
HandleResult = CheckHolidayDetail.HandleResult,
|
|
CheckContent = CheckHolidayDetail.CheckContent,
|
|
WorkArea = CheckHolidayDetail.WorkArea
|
|
};
|
|
Funs.DB.Check_CheckHolidayDetail.InsertOnSubmit(newCheckHolidayDetail);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改季节性/节假日检查明细信息
|
|
/// </summary>
|
|
/// <param name="CheckHolidayDetail"></param>
|
|
public static void UpdateCheckHolidayDetail(Model.Check_CheckHolidayDetail CheckHolidayDetail)
|
|
{
|
|
var newCheckHolidayDetail = Funs.DB.Check_CheckHolidayDetail.FirstOrDefault(x => x.CheckHolidayDetailId == CheckHolidayDetail.CheckHolidayDetailId);
|
|
if (newCheckHolidayDetail != null)
|
|
{
|
|
newCheckHolidayDetail.CheckResult = CheckHolidayDetail.CheckResult;
|
|
newCheckHolidayDetail.CheckOpinion = CheckHolidayDetail.CheckOpinion;
|
|
newCheckHolidayDetail.CheckStation = CheckHolidayDetail.CheckStation;
|
|
newCheckHolidayDetail.HandleResult = CheckHolidayDetail.HandleResult;
|
|
newCheckHolidayDetail.CheckContent = CheckHolidayDetail.CheckContent;
|
|
newCheckHolidayDetail.WorkArea = CheckHolidayDetail.WorkArea;
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据季节性/节假日检查ID删除所有季节性/节假日检查明细信息
|
|
/// </summary>
|
|
/// <param name="checkHolidayId"></param>
|
|
public static void DeleteCheckHolidayDetails(string checkHolidayId)
|
|
{
|
|
var q = (from x in Funs.DB.Check_CheckHolidayDetail where x.CheckHolidayId == checkHolidayId select x).ToList();
|
|
if (q != null)
|
|
{
|
|
foreach (var item in q)
|
|
{
|
|
////删除附件表
|
|
BLL.CommonService.DeleteAttachFileById(item.CheckHolidayDetailId);
|
|
}
|
|
Funs.DB.Check_CheckHolidayDetail.DeleteAllOnSubmit(q);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据季节性/节假日检查ID删除一条季节性/节假日检查明细信息
|
|
/// </summary>
|
|
/// <param name="checkHolidayDetailId"></param>
|
|
public static void DeleteCheckHolidayDetailById(string checkHolidayDetailId)
|
|
{
|
|
var q = (from x in Funs.DB.Check_CheckHolidayDetail where x.CheckHolidayDetailId == checkHolidayDetailId select x).FirstOrDefault();
|
|
if (q != null)
|
|
{
|
|
////删除附件表
|
|
BLL.CommonService.DeleteAttachFileById(q.CheckHolidayDetailId);
|
|
Funs.DB.Check_CheckHolidayDetail.DeleteOnSubmit(q);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
}
|
|
}
|