using Core.Mes.Client.Comm.Format;
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 System.Collections.Generic;
using System.Data;

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

        public List<ComBaseSplineEntity> Query(string phyNameMin, string sampleStyle, string validflag,string seamArea)
        {
            return EntityHelper.GetData<ComBaseSplineEntity>("com.steering.pss.qcm.DAL.ComBaseSplineDAL.Query",
                new object[] { phyNameMin, sampleStyle, validflag, seamArea }, _ob);
        }

        public List<ComBaseSplineEntity> Query2(string phyCodeMin, string itemCodeF,
            string itemCodeC, string ordLnPk, string itemCodeW)
        {
            return EntityHelper.GetData<ComBaseSplineEntity>("com.steering.pss.qcm.DAL.ComBaseSplineDAL.Query2",
                new object[] { phyCodeMin, itemCodeF, itemCodeC, ordLnPk, itemCodeW }, _ob);
        }

        public List<ComBaseSplineEntity> QueryNk(string phyCodeMin, string stdCode,
            string stdCodeTest, string itemCodeF)
        {
            return EntityHelper.GetData<ComBaseSplineEntity>("com.steering.pss.qcm.DAL.ComBaseSplineDAL.QueryNk",
                new object[] { phyCodeMin, stdCode, stdCodeTest, itemCodeF }, _ob);
        }

        public void Save(List<ComBaseSplineEntity2> splineEntitys, List<ComBaseSplineCEntity2> splineCEntitys)
        {
            List<string> parms = new List<string>();
            List<string> parmCs = new List<string>();

            foreach (ComBaseSplineEntity2 splineEntity in splineEntitys)
            {
                parms.Add(JsonConvert.SerializeObject(splineEntity));
            }
            foreach (ComBaseSplineCEntity2 splineCEntity in splineCEntitys)
            {
                parmCs.Add(JsonConvert.SerializeObject(splineCEntity));
            }

            ServerHelper.SetData("com.steering.pss.qcm.DAL.ComBaseSplineDAL.Save", new object[] { parms, parmCs }, _ob);
        }

        public void UpdateValidflag(List<ComBaseSplineEntity> splineEntitys, string validflag)
        {
            List<string> parms = new List<string>();
            foreach (ComBaseSplineEntity splineEntity in splineEntitys)
            {
                parms.Add(JSONFormat.Format(splineEntity));
            }
            ServerHelper.SetData("com.steering.pss.qcm.DAL.ComBaseSplineDAL.UpdateValidflag", new object[] { parms, validflag }, _ob);
        }

        public DataTable GetComBasePhyC()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.DAL.ComBaseSplineDAL.GetComBasePhyC",
                new object[] { }, _ob);
            return dt;
        }

        public void UpdateFilePosition(string filePath, string eic)
        {
            ServerHelper.SetData("com.steering.pss.qcm.DAL.ComBaseSplineDAL.UpdateFilePosition",
                new object[] { filePath, eic }, _ob);
        }

        public DataTable GetComBaseStdS(string eic)
        {
            return ServerHelper.GetData("com.steering.pss.qcm.DAL.ComBaseSplineDAL.GetComBaseStdS",
                new object[] { eic }, _ob);
        }

        public bool IsRepeat(ComBaseSplineEntity2 splineEntity)
        {

            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.DAL.ComBaseSplineDAL.IsRepeat",
                new object[] { JSONFormat.Format(splineEntity) }, _ob);
            if (dt.Rows[0][0].ToString() != "0")
            {
                return true;
            }
            else
            {
                return false;
            }
        }
    }
}