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;
using System.Collections.Generic;
using System.Data;

namespace Core.StlMes.Client.Qcm.BLL
{
    /// <summary>
    /// 数据库表QCM_ZBS_TEMPLATE_R_MSC所对应的BLL类（生成工具：代码生成工具）
    /// 作者：tgcx-test   时间：2016-05-13
    /// </summary>
    public class QcmZbsTemplateRMscBLL
    {
        private OpeBase _ob;

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

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

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

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

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

        /// <summary>
        /// 保存
        /// </summary>
        public void Save(List<QcmZbsTemplateRMscEntity> qcmZbsTemplateRMscEntitys, List<QcmZbsTemplateRMscSpecEntity> qcmZbsTemplateRMscSpecEntitys)
        {
            List<string> jsons = new List<string>();
            foreach (var qcmZbsTemplateRMscEntity in qcmZbsTemplateRMscEntitys)
            {
                jsons.Add(JsonConvert.SerializeObject(qcmZbsTemplateRMscEntity));
            }

            List<string> jsons2 = new List<string>();
            foreach (var qcmZbsTemplateRMscSpecEntity in qcmZbsTemplateRMscSpecEntitys)
            {
                jsons2.Add(JsonConvert.SerializeObject(qcmZbsTemplateRMscSpecEntity));
            }
            ServerHelper.SetData("com.steering.pss.qcm.DAL.QcmZbsTemplateRMscDAL.Save", new object[] { jsons, jsons2 }, _ob);
        }

        /// <summary>
        /// 修改作废标志
        /// </summary>
        public void UpdateValidflag(List<QcmZbsTemplateRMscEntity> qcmZbsTemplateRMscEntitys, List<QcmZbsTemplateRMscSpecEntity> qcmZbsTemplateRMscSpecEntitys, string validflag)
        {
            List<string> jsons = new List<string>();
            foreach (var qcmZbsTemplateRMscEntity in qcmZbsTemplateRMscEntitys)
            {
                jsons.Add(JsonConvert.SerializeObject(qcmZbsTemplateRMscEntity));
            }

            List<string> jsons2 = new List<string>();
            foreach (var qcmZbsTemplateRMscSpecEntity in qcmZbsTemplateRMscSpecEntitys)
            {
                jsons2.Add(JsonConvert.SerializeObject(qcmZbsTemplateRMscSpecEntity));
            }
            ServerHelper.SetData("com.steering.pss.qcm.DAL.QcmZbsTemplateRMscDAL.UpdateValidflag", new object[] { jsons, jsons2, validflag }, _ob);
        }

        public int GetZbsRMscCnt(string msc, string tbh)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.DAL.QcmZbsTemplateRMscDAL.GetZbsRMscCnt",
                new object[] { msc, tbh }, _ob);
            return Convert.ToInt32(dt.Rows[0][0]);
        }
    }
}