119 lines
4.2 KiB
C#
119 lines
4.2 KiB
C#
using System.Linq;
|
|
using System;
|
|
|
|
namespace BLL
|
|
{
|
|
public class SSRService
|
|
{
|
|
public static Model.SSR GetSSRById(string ssrId)
|
|
{
|
|
return Funs.DB.SSR.FirstOrDefault(e => e.SSRId == ssrId);
|
|
}
|
|
|
|
public static Model.SSR GetSSRBySESNo(string sesNo)
|
|
{
|
|
return Funs.DB.SSR.FirstOrDefault(e => e.SES_No == sesNo);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 添加
|
|
/// </summary>
|
|
/// <param name="ssr"></param>
|
|
public static void AddSSR(Model.SSR ssr)
|
|
{
|
|
Model.SSR newSSR = new Model.SSR();
|
|
newSSR.SSRId = ssr.SSRId;
|
|
newSSR.SES_No = ssr.SES_No;
|
|
newSSR.WorkOrder = ssr.WorkOrder;
|
|
newSSR.Op = ssr.Op;
|
|
newSSR.Network = ssr.Network;
|
|
newSSR.Nop = ssr.Nop;
|
|
newSSR.RequisitionerId = ssr.RequisitionerId;
|
|
newSSR.RequisitionerName = ssr.RequisitionerName;
|
|
newSSR.DepartmentId = ssr.DepartmentId;
|
|
newSSR.DepartmentName = ssr.DepartmentName;
|
|
newSSR.SubmmisionDate = ssr.SubmmisionDate;
|
|
newSSR.CompletionDate = ssr.CompletionDate;
|
|
newSSR.ContractNo = ssr.ContractNo;
|
|
newSSR.Address = ssr.Address;
|
|
newSSR.Remark = ssr.Remark;
|
|
newSSR.InputDate = ssr.InputDate;
|
|
newSSR.RetrunDuration = ssr.RetrunDuration;
|
|
newSSR.NotRetrunDuration = ssr.NotRetrunDuration;
|
|
newSSR.ContractAdmin = ssr.ContractAdmin;
|
|
newSSR.ReturnDate = ssr.ReturnDate;
|
|
Funs.DB.SSR.InsertOnSubmit(newSSR);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改
|
|
/// </summary>
|
|
/// <param name="ssr"></param>
|
|
public static void UpdateSSR(Model.SSR ssr)
|
|
{
|
|
Model.SSR newSSR = Funs.DB.SSR.FirstOrDefault(e => e.SSRId == ssr.SSRId);
|
|
if (newSSR != null)
|
|
{
|
|
newSSR.SES_No = ssr.SES_No;
|
|
newSSR.WorkOrder = ssr.WorkOrder;
|
|
newSSR.Op = ssr.Op;
|
|
newSSR.Network = ssr.Network;
|
|
newSSR.Nop = ssr.Nop;
|
|
newSSR.RequisitionerId = ssr.RequisitionerId;
|
|
newSSR.RequisitionerName = ssr.RequisitionerName;
|
|
newSSR.DepartmentId = ssr.DepartmentId;
|
|
newSSR.DepartmentName = ssr.DepartmentName;
|
|
newSSR.SubmmisionDate = ssr.SubmmisionDate;
|
|
newSSR.CompletionDate = ssr.CompletionDate;
|
|
newSSR.ContractNo = ssr.ContractNo;
|
|
newSSR.Address = ssr.Address;
|
|
newSSR.Remark = ssr.Remark;
|
|
newSSR.InputDate = ssr.InputDate;
|
|
newSSR.RetrunDuration = ssr.RetrunDuration;
|
|
newSSR.NotRetrunDuration = ssr.NotRetrunDuration;
|
|
newSSR.ContractAdmin = ssr.ContractAdmin;
|
|
newSSR.ReturnDate = ssr.ReturnDate;
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
public static void UpdateSSR_SubmmisionDate(string sSRId, DateTime? SubmmisionDate)
|
|
{
|
|
Model.SSR newSSR = Funs.DB.SSR.FirstOrDefault(e => e.SSRId == sSRId);
|
|
if (newSSR != null)
|
|
{
|
|
newSSR.SubmmisionDate = SubmmisionDate;
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
/// <summary>
|
|
/// 更新取回日期
|
|
/// </summary>
|
|
/// <param name="ssr"></param>
|
|
public static void UpdateSSRRetrunDate(Model.SSR ssr)
|
|
{
|
|
Model.SSR newSSR = Funs.DB.SSR.FirstOrDefault(e => e.SSRId == ssr.SSRId);
|
|
if (newSSR != null)
|
|
{
|
|
newSSR.ReturnDate = ssr.ReturnDate;
|
|
newSSR.IsRetruned = ssr.IsRetruned;
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据主键删除
|
|
/// </summary>
|
|
/// <param name="ssr"></param>
|
|
public static void DeleteSSRById(string ssrId)
|
|
{
|
|
Model.SSR ssr = Funs.DB.SSR.FirstOrDefault(e => e.SSRId == ssrId);
|
|
if (ssr != null)
|
|
{
|
|
Funs.DB.SSR.DeleteOnSubmit(ssr);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
}
|
|
} |