using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using CoreFS.CA06;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;

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

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

        /// <summary>
        /// 查询
        /// </summary>
        public List<CraftAutoPeopleEntity> Query(string customInfo)
        {
            List<CraftAutoPeopleEntity> craftAutoPeopleEntity = EntityHelper.GetData<CraftAutoPeopleEntity>(
                "com.steering.pss.sale.order.DAL.CraftAutoPeopleDAL.Query", new object[] { customInfo }, _ob);
            return craftAutoPeopleEntity;
        }

        /// <summary>
        /// 查询
        /// </summary>
        public List<CraftAutoPeopleEntity> QueryPopup(string ordLnPk)
        {
            List<CraftAutoPeopleEntity> craftAutoPeopleEntity = EntityHelper.GetData<CraftAutoPeopleEntity>(
                "com.steering.pss.sale.order.DAL.CraftAutoPeopleDAL.QueryPopup", new object[] { ordLnPk }, _ob);
            return craftAutoPeopleEntity;
        }

        /// <summary>
        /// 确认人工评审
        /// </summary>
        /// <param name="ordLnPk"></param>
        /// <param name="auditCode"></param>
        /// <param name="auditCode1"></param>
        /// <param name="approveCode"></param>
        /// <param name="approveCode1"></param>
        public void Submit(string ordLnPk, string auditCode, string auditCode1,
            string approveCode, string approveCode1, string userId, string userName)
        {
            ServerHelper.SetData("com.steering.pss.sale.order.DAL.CraftAutoPeopleDAL.Submit",
                new object[] { ordLnPk, auditCode, auditCode1, approveCode, approveCode1, userId, userName }, _ob);
        }

        /// <summary>
        /// 通过主键查询
        /// </summary>
        public List<CraftAutoPeopleEntity> QueryByPk(string Pk)
        {
            List<CraftAutoPeopleEntity> craftAutoPeopleEntity = EntityHelper.GetData<CraftAutoPeopleEntity>(
                "com.steering.pss.sale.order.DAL.CraftAutoPeopleDAL.QueryByPk", new object[] { Pk }, _ob);
            return craftAutoPeopleEntity;
        }

        /// <summary>
        /// 新增
        /// </summary>
        public void Insert(List<CraftAutoPeopleEntity> craftAutoPeopleEntitys)
        {
            List<string> jsons = new List<string>();
            foreach (var craftAutoPeopleEntity in craftAutoPeopleEntitys)
            {
                jsons.Add(JsonConvert.SerializeObject(craftAutoPeopleEntity));
            }
            ServerHelper.SetData("com.steering.pss.sale.order.DAL.CraftAutoPeopleDAL.Insert", new object[] { jsons }, _ob);
        }

        /// <summary>
        /// 修改
        /// </summary>
        public void Update(List<CraftAutoPeopleEntity> craftAutoPeopleEntitys)
        {
            List<string> jsons = new List<string>();
            foreach (var craftAutoPeopleEntity in craftAutoPeopleEntitys)
            {
                jsons.Add(JsonConvert.SerializeObject(craftAutoPeopleEntity));
            }
            ServerHelper.SetData("com.steering.pss.sale.order.DAL.CraftAutoPeopleDAL.Update", new object[] { jsons }, _ob);
        }

        /// <summary>
        /// 保存
        /// </summary>
        public void Save(List<CraftAutoPeopleEntity> craftAutoPeopleEntitys)
        {
            List<string> jsons = new List<string>();
            foreach (var craftAutoPeopleEntity in craftAutoPeopleEntitys)
            {
                jsons.Add(JsonConvert.SerializeObject(craftAutoPeopleEntity));
            }
            ServerHelper.SetData("com.steering.pss.sale.order.DAL.CraftAutoPeopleDAL.Save", new object[] { jsons }, _ob);
        }

        /// <summary>
        /// 修改作废标志
        /// </summary>
        public void UpdateValidflag(List<CraftAutoPeopleEntity> craftAutoPeopleEntitys, string validflag)
        {
            List<string> jsons = new List<string>();
            foreach (var craftAutoPeopleEntity in craftAutoPeopleEntitys)
            {
                jsons.Add(JsonConvert.SerializeObject(craftAutoPeopleEntity));
            }
            ServerHelper.SetData("com.steering.pss.sale.order.DAL.CraftAutoPeopleDAL.UpdateValidflag", new object[] { jsons, validflag }, _ob);
        }

        /// <summary>
        /// 删除
        /// </summary>
        public void Delete(List<CraftAutoPeopleEntity> craftAutoPeopleEntitys)
        {
            List<string> jsons = new List<string>();
            foreach (var craftAutoPeopleEntity in craftAutoPeopleEntitys)
            {
                jsons.Add(JsonConvert.SerializeObject(craftAutoPeopleEntity));
            }
            ServerHelper.SetData("com.steering.pss.sale.order.DAL.CraftAutoPeopleDAL.Delete", new object[] { jsons }, _ob);
        }

        /// <summary>
        /// 是否存在科室
        /// </summary>
        /// <param name="unitCode"></param>
        /// <param name="pk"></param>
        /// <returns></returns>
        public bool IsExistUnit(string unitCode, string pk)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.DAL.CraftAutoPeopleDAL.IsExisUnit",
                new object[] { unitCode, pk }, _ob);
            if (dt.Rows[0][0].ToString() == "0")
            {
                return false;
            }
            else
            {
                return true;
            }
        }

        /// <summary>
        /// 是否存在科室（人工审核）
        /// </summary>
        /// <param name="unitCode"></param>
        /// <param name="auditCode"></param>
        /// <param name="auditCode1"></param>
        /// <param name="approveCode"></param>
        /// <param name="approveCode1"></param>
        /// <param name="pk"></param>
        /// <returns></returns>
        public bool IsExistUnit2(string unitCode, string auditCode, string auditCode1,
            string approveCode, string approveCode1, string pk)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.DAL.CraftAutoPeopleDAL.IsExisUnit2",
                new object[] { unitCode, auditCode, auditCode1, approveCode, approveCode1, pk }, _ob);
            if (dt.Rows[0][0].ToString() == "0")
            {
                return false;
            }
            else
            {
                return true;
            }
        }

        /// <summary>
        /// 获取工艺评审制定的审核人
        /// </summary>
        /// <param name="ordLnPk"></param>
        /// <returns></returns>
        public DataRow GetCraftOrdUnit(string ordLnPk)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.DAL.CraftAutoPeopleDAL.getCraftOrdUnit",
                new object[] { ordLnPk }, _ob);
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            else
            {
                return null;
            }
        }
    }
}