using Dapper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Threading.Tasks;
using VueWebCoreApi.Tools;

namespace VueWebCoreApi.DLL.DAL
{
    public class KanBanManagerentDAL
    {
        public static ToMessage mes = new ToMessage(); //定义全局返回信息对象

        #region[车间看板,上生产信息]
        public static ToMessage WorkShopProduceTopData()
        {
            string sql = "";
            try
            {
                sql = @"select * from h_v_JLKanBan_WorkshopTop";
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[车间看板,下左近一周不良趋势]
        public static ToMessage WorkShopProduceBottomLeftData()
        {
            string sql = "";
            Dictionary<object, object> dir = new Dictionary<object, object>();
            try
            {
                sql = @"h_p_JLKanBan_WorkshopBottomLeft";
                var data = DapperHelper.lissql(sql);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[车间看板,下右近一月不良统计]
        public static ToMessage WorkShopProduceBottomRightData()
        {
            string sql = "";
            try
            {
                sql = @"select * from h_v_JLKanBan_WorkshopBottomRight";
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion


        #region[车间综合看板,左上生产订单]
        public static ToMessage WorkShopCompreLeftTop()
        {
            var sql = "";
            Dictionary<object, object> dir = new Dictionary<object, object>();
            try
            {
                sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftTop";
                var data = DapperHelper.selecttable(sql);
                sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftCenter";
                var data1 = DapperHelper.selecttable(sql);
                dir.Add("LeftTop", data);
                dir.Add("LeftBottom", data1);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = dir;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[车间综合看板,右上销售订单]
        public static ToMessage WorkShopCompreRightTop()
        {
            var sql = "";
            Dictionary<object, object> dir = new Dictionary<object, object>();
            try
            {
                sql = @"select * from h_v_JLKanBan_WorkShopCompreRightTop";
                var data = DapperHelper.selecttable(sql);
                sql = @"select * from h_v_JLKanBan_WorkShopCompreRightCenter";
                var data1 = DapperHelper.selecttable(sql);
                dir.Add("RightTop", data);
                dir.Add("RightBottom", data1);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = dir;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[车间综合看板,右下库存]
        public static ToMessage WorkShopCompreRightBottom()
        {
            var sql = "";
            Dictionary<object, object> dir = new Dictionary<object, object>();
            try
            {
                //存储过程名
                sql = @"h_p_IFCLD_StockInventory";
                var data = DapperHelper.lissql(sql);
                if (data.Rows.Count > 0)
                {
                    // 使用Lambda表达式对qty列进行汇总，并通过type列分组
                    var groupedData = data.AsEnumerable()
                    .GroupBy(row => row.Field<string>("FErpCls"))
                    .Select(group => new
                    {
                        Type = group.Key,
                        Qty = group.Sum(row => row.Field<decimal>("FCUUQty"))
                    }).ToList();
                    
                    mes.code = "200";
                    mes.message = "查询成功!";
                    mes.data = groupedData;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.message = "暂无库存信息!";
                    mes.data = null;
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion



        #region[仓库看板,左上产品待入库列表]
        public static ToMessage WareHouseTopLeftData()
        {
            string sql = "";
            try
            {
                //获取仓库生产加工单待入库列表
                sql = @"select * from h_v_MHKanBan_WareHouseTopLeft order by voucherdate";
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[仓库看板,左下产品待发货列表]
        public static ToMessage WareHouseTopBottomData()
        {
            string sql = "";
            try
            {
                //获取仓库销售订单产品待发货列表
                sql = @"select * from h_v_MHKanBan_WareHouseTopBottom order by voucherdate";
                var data = DapperHelper.selecttable(sql);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[仓库看板,右即时库存]
        public static ToMessage WareHouseRightTopData()
        {
            string sql = "";
            try
            {
                sql = @"h_p_IFCLD_SumStockInventory";
                var data = DapperHelper.lissql(sql);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = data;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        
    }
}