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();
            }
        }
    }
}