93 lines
3.0 KiB
C#
93 lines
3.0 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
|
|
namespace BLL
|
|
{
|
|
/// <summary>
|
|
/// 规格定义
|
|
/// </summary>
|
|
public class Base_VCSService
|
|
{
|
|
/// <summary>
|
|
/// 根据主键获取规格定义
|
|
/// </summary>
|
|
/// <param name="formatId"></param>
|
|
/// <returns></returns>
|
|
public static Model.Base_VCS GetFormatById(string vvsId)
|
|
{
|
|
return Funs.DB.Base_VCS.FirstOrDefault(e => e.VvsId == vvsId);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 添加规格定义
|
|
/// </summary>
|
|
/// <param name="format"></param>
|
|
public static void AddVCS(Model.Base_VCS VCS )
|
|
{
|
|
Model.Base_VCS newVCS = new Model.Base_VCS();
|
|
newVCS.VvsId = VCS.VvsId;
|
|
newVCS.WeldingMethodId = VCS.WeldingMethodId;
|
|
newVCS.ProjectId = VCS.ProjectId;
|
|
newVCS.MaterialId = VCS.MaterialId;
|
|
newVCS.SteelFormat = VCS.SteelFormat;
|
|
newVCS.Sch = VCS.Sch;
|
|
newVCS.Voltage = VCS.Voltage;
|
|
newVCS.Current = VCS.Current;
|
|
newVCS.Speed = VCS.Speed;
|
|
newVCS.PrepareTemp = VCS.PrepareTemp;
|
|
newVCS.LastTemp = VCS.LastTemp;
|
|
newVCS.Layers = VCS.Layers;
|
|
newVCS.Remark = VCS.Remark;
|
|
newVCS.CreateDate = VCS.CreateDate;
|
|
|
|
Funs.DB.Base_VCS.InsertOnSubmit(newVCS);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改规格定义
|
|
/// </summary>
|
|
/// <param name="format"></param>
|
|
public static void UpdateVCS(Model.Base_VCS VCS)
|
|
{
|
|
Model.Base_VCS newVCS = Funs.DB.Base_VCS.FirstOrDefault(e => e.VvsId == VCS.VvsId);
|
|
if (newVCS != null)
|
|
{
|
|
newVCS.VvsId = VCS.VvsId;
|
|
newVCS.WeldingMethodId = VCS.WeldingMethodId;
|
|
newVCS.MaterialId = VCS.MaterialId;
|
|
newVCS.ProjectId = VCS.ProjectId;
|
|
newVCS.SteelFormat = VCS.SteelFormat;
|
|
newVCS.Sch = VCS.Sch;
|
|
newVCS.Voltage = VCS.Voltage;
|
|
newVCS.Current = VCS.Current;
|
|
newVCS.Speed = VCS.Speed;
|
|
newVCS.PrepareTemp = VCS.PrepareTemp;
|
|
newVCS.LastTemp = VCS.LastTemp;
|
|
newVCS.Layers = VCS.Layers;
|
|
newVCS.Remark = VCS.Remark;
|
|
newVCS.CreateDate = VCS.CreateDate;
|
|
|
|
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据主键删除规格定义
|
|
/// </summary>
|
|
/// <param name="formatId"></param>
|
|
public static void DeleteVCSById(string vvsId)
|
|
{
|
|
Model.Base_VCS base_VCS = Funs.DB.Base_VCS.FirstOrDefault(e => e.VvsId == vvsId);
|
|
if (base_VCS != null)
|
|
{
|
|
Funs.DB.Base_VCS.DeleteOnSubmit(base_VCS);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
}
|
|
} |