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

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

        /// <summary>
        /// 查询排产队列表
        /// </summary>
        /// <param name="plaSaleOrdProc"></param>
        /// <returns></returns>
        public List<PlnSaleordProcEntity> query(string craftNo, string craftNoV)
        {
            return EntityHelper.GetData<PlnSaleordProcEntity>("com.steering.pss.sale.order.DAL.PlaSaleOrdProcDAL.query",
                new object[] { craftNo, craftNoV }, ob);
        }

        /// <summary>
        /// 查询排产队列表数目
        /// </summary>
        /// <param name="plaSaleOrdProc"></param>
        /// <returns></returns>
        public int QueryCount(string craftNo, string craftNoV)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.DAL.PlaSaleOrdProcDAL.queryCount",
                new object[] { craftNo, craftNoV }, ob);
            return int.Parse(dt.Rows[0]["COUNT"].ToString());
        }

        /// <summary>
        /// 升级工艺文件
        /// </summary>
        /// <param name="plaSaleOrdProcList"></param>
        public void UpgradeCraft(List<PlnSaleordProcEntity> plaSaleOrdProcList)
        {
            ArrayList list = new ArrayList();
            foreach (PlnSaleordProcEntity plaSaleOrdProc in plaSaleOrdProcList)
            {
                list.Add(JSONFormat.Format(plaSaleOrdProc));
            }
            ServerHelper.SetData("com.steering.pss.sale.order.DAL.PlaSaleOrdProcDAL.upgradeCraft",
                new object[] { list }, ob);
        }

        /// <summary>
        /// 通过主键查询排产队列表
        /// </summary>
        /// <param name="ordLnDlyPk"></param>
        /// <param name="plaDivideId"></param>
        /// <returns></returns>
        public DataTable QueryPlaProcByPk(string ordLnDlyPk, string plaDivideId)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.DAL.PlaSaleOrdProcDAL.queryPlaProcByPk",
                new object[] { ordLnDlyPk, plaDivideId }, ob);
            return dt;
        }

        /// <summary>
        /// 是否已下发
        /// </summary>
        /// <param name="craftNo"></param>
        /// <param name="craftNoV"></param>
        /// <returns></returns>
        public int IsIssued(string craftNo, string craftNoV)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.DAL.PlaSaleOrdProcDAL.IsIssued",
                new object[]{ craftNo, craftNoV}, ob);
            return dt.Rows.Count;
        }
    }
}