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 System;
using System.Collections.Generic;
using System.Data;

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

        public List<ComBaseWaterGroupEntity> QueryWaterGroup()
        {
            return EntityHelper.GetData<ComBaseWaterGroupEntity>(
                "com.steering.pss.qcm.DAL.ComBaseWaterGroupDAL.queryWaterGroup", null, ob);
        }

        public List<ComBaseWaterGroupEntity> QueryWaterGroupGrade(string waterGroupCode)
        {
            return EntityHelper.GetData<ComBaseWaterGroupEntity>(
                "com.steering.pss.qcm.DAL.ComBaseWaterGroupDAL.queryWaterGroupGrade", new object[] { waterGroupCode }, ob);
        }

        public string SaveWaretGroupGrade(List<ComBaseWaterGroupEntity> listWaterGroups)
        {
            List<String> strWaterGroups = new List<string>();
            foreach (ComBaseWaterGroupEntity waterGroup in listWaterGroups)
            {
                strWaterGroups.Add(JSONFormat.Format(waterGroup));
            }
            return ServerHelper.SetDataReturnObj("com.steering.pss.qcm.DAL.ComBaseWaterGroupDAL.saveWaretGroupGrade",
                new object[] { strWaterGroups }, ob).ToString();
        }

        public int GetWaterGroupCnt(string waterGroup, string waterGroupCode)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.DAL.ComBaseWaterGroupDAL.getWaterGroupCnt",
                new object[] { waterGroup, waterGroupCode }, ob);
            return int.Parse(dt.Rows[0][0].ToString());
        }

        public int GetWaterGroupGradeCnt(string gradeCodes, string waterGroupCode, out string waterGrope)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.DAL.ComBaseWaterGroupDAL.getWaterGroupGradeCnt",
                new object[] { gradeCodes, waterGroupCode }, ob);
            if (dt.Rows.Count > 0)
            {
                waterGrope = dt.Rows[0]["WATER_GROUP"].ToString();
                return dt.Rows.Count;
            }
            else
            {
                waterGrope = "";
                return 0;
            }
        }
    }
}