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 Newtonsoft.Json.Converters;
using System.Collections.Generic;

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

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

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

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

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

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

        /// <summary>
        /// 保存
        /// </summary>
        public string Save(ComBasePurchaseAgreementEntity comBasePurchaseAgreementEntity,
            List<ComBasePurchaseProviderEntity> purchaseProviders, List<ComBasePurchaseStdIdxEntity> purchaseStdIdxs)
        {
            List<string> jsonProviders = new List<string>();
            foreach (var purchaseProvider in purchaseProviders)
            {
                jsonProviders.Add(JsonConvert.SerializeObject(purchaseProvider));
            }

            List<string> jsonStdIdxs = new List<string>();
            foreach (var purchaseStdIdx in purchaseStdIdxs)
            {
                jsonStdIdxs.Add(JsonConvert.SerializeObject(purchaseStdIdx));
            }

            var aIsoDateTimeConverter = new IsoDateTimeConverter();
            aIsoDateTimeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
            string purchaseAgreementJson = comBasePurchaseAgreementEntity == null ?
                "" : JsonConvert.SerializeObject(comBasePurchaseAgreementEntity, Formatting.Indented, aIsoDateTimeConverter);
            return ServerHelper.SetDataReturnObj("com.steering.pss.qcm.DAL.ComBasePurchaseAgreementDAL.Save",
                new object[] { purchaseAgreementJson, jsonProviders, jsonStdIdxs }, _ob).ToString();
        }

        /// <summary>
        /// 修改作废标志
        /// </summary>
        public void UpdateValidflag(ComBasePurchaseAgreementEntity comBasePurchaseAgreementEntity, string validflag)
        {
            ServerHelper.SetData("com.steering.pss.qcm.DAL.ComBasePurchaseAgreementDAL.UpdateValidflag",
                new object[] { JsonConvert.SerializeObject(comBasePurchaseAgreementEntity), validflag }, _ob);
        }
    }
}