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_FILE_LV2所对应的BLL类（生成工具：代码生成工具4.0   访问地址：http://172.16.2.128/tool/）
    /// 作者：tgcx-test   时间：2016-07-04
    /// </summary>
    public class CraftFileLv2BLL
    {
        private OpeBase _ob;

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

        /// <summary>
        /// 查询
        /// </summary>
        public List<CraftFileLv2Entity> Query(string craftNoLv2, string validflag, string msc, string processCode)
        {
            List<CraftFileLv2Entity> craftFileLv2Entity = EntityHelper.GetData<CraftFileLv2Entity>(
                "com.steering.pss.sale.order.DAL.CraftFileLv2DAL.Query", new object[] {
                    craftNoLv2, validflag, msc, processCode }, _ob);
            return craftFileLv2Entity;
        }

        /// <summary>
        /// 查询所有二级工艺文件
        /// </summary>
        public List<CraftFileLv2Entity> QueryAll()
        {
            List<CraftFileLv2Entity> craftFileLv2Entity = EntityHelper.GetData<CraftFileLv2Entity>(
                "com.steering.pss.sale.order.DAL.CraftFileLv2DAL.QueryAll", new object[] {}, _ob);
            return craftFileLv2Entity;
        }

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

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

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

        /// <summary>
        /// 保存
        /// </summary>
        public object Save(List<CraftFileLv2Entity> craftFileLv2Entitys, List<CraftFileLv2CEntity> craftFileLv2CEntitys)
        {
            List<string> jsons = new List<string>();
            foreach (var craftFileLv2Entity in craftFileLv2Entitys)
            {
                jsons.Add(JsonConvert.SerializeObject(craftFileLv2Entity));
            }

            List<string> jsons2 = new List<string>();
            foreach (var craftFileLv2CEntity in craftFileLv2CEntitys)
            {
                jsons2.Add(JsonConvert.SerializeObject(craftFileLv2CEntity));
            }
            
            return ServerHelper.SetDataReturnObj("com.steering.pss.sale.order.DAL.CraftFileLv2DAL.Save",
                new object[] { jsons, jsons2 }, _ob);
        }

        /// <summary>
        /// 修改作废标志
        /// </summary>
        public void UpdateValidflag(List<CraftFileLv2Entity> craftFileLv2Entitys, List<CraftFileLv2CEntity> craftFileLv2CEntitys,  string validflag)
        {
            List<string> jsons = new List<string>();
            foreach (var craftFileLv2Entity in craftFileLv2Entitys)
            {
                jsons.Add(JsonConvert.SerializeObject(craftFileLv2Entity));
            }

            List<string> jsons2 = new List<string>();
            foreach (var craftFileLv2CEntity in craftFileLv2CEntitys)
            {
                jsons2.Add(JsonConvert.SerializeObject(craftFileLv2CEntity));
            }
            ServerHelper.SetData("com.steering.pss.sale.order.DAL.CraftFileLv2DAL.UpdateValidflag",
                new object[] { jsons, jsons2, validflag }, _ob);
        }

        /// <summary>
        /// 过滤二级工艺文件
        /// </summary>
        /// <returns></returns>
        public List<CraftFileLv2Entity> FilterCraftFileLv2(string designKey, string processCode, string craftNoLv2,
            string validflag, string craftNo, string msc)
        {
            List<CraftFileLv2Entity> craftFileLv2Entity = EntityHelper.GetData<CraftFileLv2Entity>(
                "com.steering.pss.sale.order.DAL.CraftFileLv2DAL.FilterCraftFileLv2",
                new object[] { designKey, processCode, craftNoLv2, validflag, craftNo, msc }, _ob);
            return craftFileLv2Entity;
        }

        public int IsExistCraftLv2(string craftNoLv2, string pk)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.DAL.CraftFileLv2DAL.IsExistCraftLv2",
                new object[]{ craftNoLv2, pk }, _ob);
            return dt.Rows.Count;
        }
    }
}