87 lines
4.3 KiB
C#
87 lines
4.3 KiB
C#
using System.Linq;
|
|
|
|
namespace BLL
|
|
{
|
|
/// <summary>
|
|
/// CT销售合同
|
|
/// </summary>
|
|
public class CTSalesContractsService
|
|
{
|
|
/// <summary>
|
|
/// 根据主键获取CT销售合同
|
|
/// </summary>
|
|
/// <param name="ctSalesContractsId"></param>
|
|
/// <returns></returns>
|
|
public static Model.EMC_CTSalesContracts GetCTSalesContractsById(string ctSalesContractsId)
|
|
{
|
|
return Funs.DB.EMC_CTSalesContracts.FirstOrDefault(e => e.CTSalesContractsId == ctSalesContractsId);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 添加CT销售合同
|
|
/// </summary>
|
|
/// <param name="ctSalesContracts"></param>
|
|
public static void AddCTSalesContracts(Model.EMC_CTSalesContracts ctSalesContracts)
|
|
{
|
|
Model.EMC_CTSalesContracts newCTSalesContracts = new Model.EMC_CTSalesContracts();
|
|
newCTSalesContracts.CTSalesContractsId = ctSalesContracts.CTSalesContractsId;
|
|
newCTSalesContracts.ContractNumber = ctSalesContracts.ContractNumber;
|
|
newCTSalesContracts.ContractTitle = ctSalesContracts.ContractTitle;
|
|
newCTSalesContracts.Customer = ctSalesContracts.Customer;
|
|
newCTSalesContracts.CustomerNum = ctSalesContracts.CustomerNum;
|
|
newCTSalesContracts.PriceType = ctSalesContracts.PriceType;
|
|
newCTSalesContracts.ServiceType = ctSalesContracts.ServiceType;
|
|
newCTSalesContracts.ContractPrice = ctSalesContracts.ContractPrice;
|
|
newCTSalesContracts.VAT = ctSalesContracts.VAT;
|
|
newCTSalesContracts.ContractTermStart = ctSalesContracts.ContractTermStart;
|
|
newCTSalesContracts.ContractTermEnd = ctSalesContracts.ContractTermEnd;
|
|
newCTSalesContracts.Status = ctSalesContracts.Status;
|
|
newCTSalesContracts.DeptOfRevenue = ctSalesContracts.DeptOfRevenue;
|
|
newCTSalesContracts.ConfirmedBy = ctSalesContracts.ConfirmedBy;
|
|
newCTSalesContracts.Remark = ctSalesContracts.Remark;
|
|
Funs.DB.EMC_CTSalesContracts.InsertOnSubmit(newCTSalesContracts);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改CT销售合同
|
|
/// </summary>
|
|
/// <param name="ctSalesContracts"></param>
|
|
public static void UpdateCTSalesContracts(Model.EMC_CTSalesContracts ctSalesContracts)
|
|
{
|
|
Model.EMC_CTSalesContracts newCTSalesContracts = Funs.DB.EMC_CTSalesContracts.FirstOrDefault(e => e.CTSalesContractsId == ctSalesContracts.CTSalesContractsId);
|
|
if (newCTSalesContracts != null)
|
|
{
|
|
newCTSalesContracts.ContractNumber = ctSalesContracts.ContractNumber;
|
|
newCTSalesContracts.ContractTitle = ctSalesContracts.ContractTitle;
|
|
newCTSalesContracts.Customer = ctSalesContracts.Customer;
|
|
newCTSalesContracts.CustomerNum = ctSalesContracts.CustomerNum;
|
|
newCTSalesContracts.PriceType = ctSalesContracts.PriceType;
|
|
newCTSalesContracts.ServiceType = ctSalesContracts.ServiceType;
|
|
newCTSalesContracts.ContractPrice = ctSalesContracts.ContractPrice;
|
|
newCTSalesContracts.VAT = ctSalesContracts.VAT;
|
|
newCTSalesContracts.ContractTermStart = ctSalesContracts.ContractTermStart;
|
|
newCTSalesContracts.ContractTermEnd = ctSalesContracts.ContractTermEnd;
|
|
newCTSalesContracts.Status = ctSalesContracts.Status;
|
|
newCTSalesContracts.DeptOfRevenue = ctSalesContracts.DeptOfRevenue;
|
|
newCTSalesContracts.ConfirmedBy = ctSalesContracts.ConfirmedBy;
|
|
newCTSalesContracts.Remark = ctSalesContracts.Remark;
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据主键删除CT销售合同
|
|
/// </summary>
|
|
/// <param name="CTSalesContractsId"></param>
|
|
public static void DeleteCTSalesContractsById(string CTSalesContractsId)
|
|
{
|
|
Model.EMC_CTSalesContracts ctSalesContracts = Funs.DB.EMC_CTSalesContracts.FirstOrDefault(e => e.CTSalesContractsId == CTSalesContractsId);
|
|
if (ctSalesContracts != null)
|
|
{
|
|
Funs.DB.EMC_CTSalesContracts.DeleteOnSubmit(ctSalesContracts);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
}
|
|
} |