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

namespace Core.StlMes.Client.SaleOrder.BLL
{
    public class CraftOrdDesignStdPicBLL
    {
        private OpeBase _ob;
        public CraftOrdDesignStdPicBLL(OpeBase ob)
        {
            _ob = ob;
        }

        /// <summary>
        /// 查询质量设计成分
        /// </summary>
        /// <param name="designStdPicEntity"></param>
        /// <returns></returns>
        public List<CraftOrdDesignStdPicEntity> Query(CraftOrdDesignStdPicEntity designStdPicEntity)
        {
            List<CraftOrdDesignStdPicEntity> designStdPicEntityList = EntityHelper.GetData<CraftOrdDesignStdPicEntity>(
                "com.steering.pss.sale.order.DAL.CraftOrdDesignStdPicDAL.query", new object[] { JSONFormat.Format(designStdPicEntity) }, _ob);
            return designStdPicEntityList;
        }

        /// <summary>
        /// 查询质量设计成分
        /// </summary>
        /// <param name="designStdPicEntity"></param>
        /// <returns></returns>
        public List<CraftOrdDesignStdPicEntity> QueryByDesignKeyPic(string[] parms)
        {
            List<CraftOrdDesignStdPicEntity> designStdPicEntityList = EntityHelper.GetData<CraftOrdDesignStdPicEntity>(
                "com.steering.pss.sale.order.DAL.CraftOrdDesignStdPicDAL.queryByDesignKeyPic", new object[] { parms }, _ob);
            return designStdPicEntityList;
        }

        /// <summary>
        /// 通过试样组获取检验大项
        /// </summary>
        /// <param name="phyCodeMin"></param>
        /// <returns></returns>
        public DataRow GetPhyMaxByPhyMin(string phyCodeMin)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.DAL.CraftOrdDesignStdPicDAL.getPhyMaxByPhyMin",
                new object[] { phyCodeMin }, _ob);
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            else
            {
                return null;
            }
        }

        /// <summary>
        /// 通过DESIGN_KEY查询质量设计成分
        /// </summary>
        /// <param name="designStdPicEntity"></param>
        /// <returns></returns>
        public List<CraftOrdDesignStdPicEntity> QueryPicByDesignKey(CraftOrdDesignStdPicEntity designStdPicEntity)
        {
            List<CraftOrdDesignStdPicEntity> designStdPicEntityList = EntityHelper.GetData<CraftOrdDesignStdPicEntity>(
                "com.steering.pss.sale.order.DAL.CraftOrdDesignStdPicDAL.queryPicByDesignKey", new object[] { JSONFormat.Format(designStdPicEntity) }, _ob);
            return designStdPicEntityList;
        }

        /// <summary>
        /// 保存
        /// </summary>
        public void Save(List<CraftOrdDesignStdPicEntity> craftOrdDesignStdPicEntitys)
        {
            List<string> jsons = new List<string>();
            foreach (var craftOrdDesignStdPicEntity in craftOrdDesignStdPicEntitys)
            {
                jsons.Add(JSONFormat.Format(craftOrdDesignStdPicEntity));
            }
            ServerHelper.SetData("com.steering.pss.sale.order.DAL.CraftOrdDesignStdPicDAL.Save", new object[] { jsons }, _ob);
        }

        /// <summary>
        /// 删除
        /// </summary>
        public void Delete(List<CraftOrdDesignStdPicEntity> craftOrdDesignStdPicEntitys)
        {
            List<string> jsons = new List<string>();
            foreach (var craftOrdDesignStdPicEntity in craftOrdDesignStdPicEntitys)
            {
                jsons.Add(JSONFormat.Format(craftOrdDesignStdPicEntity));
            }
            ServerHelper.SetData("com.steering.pss.sale.order.DAL.CraftOrdDesignStdPicDAL.Delete", new object[] { jsons }, _ob);
        }

        /// <summary>
        /// 获取工艺评审制程
        /// </summary>
        /// <param name="designKey"></param>
        /// <returns></returns>
        public DataTable getCraftMscPline(string designKey, string processCode)
        {
            return ServerHelper.GetData("com.steering.pss.sale.order.DAL.CraftOrdDesignStdPicDAL.getCraftMscPline",
                new object[] { designKey, processCode }, _ob);
        }

        /// <summary>
        /// 获取评审记录试样组的分组
        /// </summary>
        /// <param name="designKey"></param>
        /// <param name="mscPline"></param>
        /// <param name="processCode"></param>
        /// <param name="pic"></param>
        /// <returns></returns>
        public DataTable getGroupPhyMin(string designKey, string pic, string mscPline, string processCode)
        {
            return ServerHelper.GetData("com.steering.pss.sale.order.DAL.CraftOrdDesignStdPicDAL.getGroupPhyMin",
                new object[] { designKey, pic, mscPline, processCode }, _ob);
        }

        /// <summary>
        /// 获取理化
        /// </summary>
        /// <returns></returns>
        public DataTable getPhyNameMin()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.DAL.CraftOrdDesignStdPicDAL.getPhyNameMin",
                new object[]{  }, _ob);
            return dt;
        }
    }
}