using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Qcm.model;
using CoreFS.CA06;
using Newtonsoft.Json;
using System.Collections.Generic;
using System.Data;

namespace Core.StlMes.Client.Qcm.BLL
{
    /// <summary>
    /// 数据库表COM_BASE_CCM所对应的BLL类（生成工具：代码生成工具4.0   访问地址：http://172.16.2.128/tool/）
    /// 作者：tgcx-test   时间：2017-08-21
    /// </summary>
    public class ComBaseCcmBLL
    {
        private OpeBase _ob;

        public ComBaseCcmBLL(OpeBase ob)
        {
            _ob = ob;
        }

        /// <summary>
        /// 查询
        /// </summary>
        public List<ComBaseCcmEntity> Query(string pline, string validflag)
        {
            List<ComBaseCcmEntity> comBaseCcmEntity = EntityHelper.GetData<ComBaseCcmEntity>(
                "com.steering.pss.qcm.DAL.ComBaseCcmDAL.Query", new object[] { pline, validflag }, _ob);
            return comBaseCcmEntity;
        }

        /// <summary>
        /// 通过主键查询
        /// </summary>
        public List<ComBaseCcmEntity> QueryByPk(string CcmCode)
        {
            List<ComBaseCcmEntity> comBaseCcmEntity = EntityHelper.GetData<ComBaseCcmEntity>(
                "com.steering.pss.qcm.DAL.ComBaseCcmDAL.QueryByPk", new object[] { CcmCode }, _ob);
            return comBaseCcmEntity;
        }

        /// <summary>
        /// 新增
        /// </summary>
        public void Insert(List<ComBaseCcmEntity> comBaseCcmEntitys)
        {
            List<string> jsons = new List<string>();
            foreach (var comBaseCcmEntity in comBaseCcmEntitys)
            {
                jsons.Add(JsonConvert.SerializeObject(comBaseCcmEntity));
            }
            ServerHelper.SetData("com.steering.pss.qcm.DAL.ComBaseCcmDAL.Insert", new object[] { jsons }, _ob);
        }

        /// <summary>
        /// 修改
        /// </summary>
        public void Update(List<ComBaseCcmEntity> comBaseCcmEntitys)
        {
            List<string> jsons = new List<string>();
            foreach (var comBaseCcmEntity in comBaseCcmEntitys)
            {
                jsons.Add(JsonConvert.SerializeObject(comBaseCcmEntity));
            }
            ServerHelper.SetData("com.steering.pss.qcm.DAL.ComBaseCcmDAL.Update", new object[] { jsons }, _ob);
        }

        /// <summary>
        /// 保存
        /// </summary>
        public void Save(List<ComBaseCcmEntity> comBaseCcmEntitys)
        {
            List<string> jsons = new List<string>();
            foreach (var comBaseCcmEntity in comBaseCcmEntitys)
            {
                jsons.Add(JsonConvert.SerializeObject(comBaseCcmEntity));
            }
            ServerHelper.SetData("com.steering.pss.qcm.DAL.ComBaseCcmDAL.Save", new object[] { jsons }, _ob);
        }

        /// <summary>
        /// 修改作废标志
        /// </summary>
        public void UpdateValidflag(List<ComBaseCcmEntity> comBaseCcmEntitys, string validflag)
        {
            List<string> jsons = new List<string>();
            foreach (var comBaseCcmEntity in comBaseCcmEntitys)
            {
                jsons.Add(JsonConvert.SerializeObject(comBaseCcmEntity));
            }
            ServerHelper.SetData("com.steering.pss.qcm.DAL.ComBaseCcmDAL.UpdateValidflag", new object[] { jsons, validflag }, _ob);
        }

        /// <summary>
        /// 获取铸造产线基础数据
        /// </summary>
        /// <returns></returns>
        public DataTable GetPline()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.DAL.ComBaseCcmDAL.GetPline",
                new object[] { }, _ob);
            return dt;
        }

        /// <summary>
        /// 是否存在重复数据
        /// </summary>
        /// <param name="plineCode"></param>
        /// <param name="dimater"></param>
        /// <param name="waterNo"></param>
        /// <param name="ccmCode"></param>
        /// <returns></returns>
        public bool Exists(string plineCode, string dimater, string waterNo,
            string gradeCode, string cic, string ccmCode)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.DAL.ComBaseCcmDAL.Exists",
                new object[] { plineCode, dimater, waterNo, gradeCode, cic, ccmCode }, _ob);
            if (dt.Rows[0][0].ToString() == "0")
            {
                return false;
            }
            else
            {
                return true;
            }
        }

        /// <summary>
        /// 获取内控成分索引码
        /// </summary>
        /// <returns></returns>
        public static DataTable GetNkCic(OpeBase ob)
        {
            return ServerHelper.GetData("com.steering.pss.qcm.DAL.ComBaseCcmDAL.getNkCic",
                new object[] { }, ob);
        }
    }
}