车间看板新增车间参数

yl

2024-07-26 7c78ddfc867ac8cf06cc911bb59977d9381deb12

 VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs

@@ -12,7 +12,147 @@
    {
        public static ToMessage mes = new ToMessage(); //定义全局返回信息对象

        #region[车间看板,上生产信息]
        #region[圣沣仓库看板左上,采购待入库]
        public static ToMessage ProcureOutsourcLeftTop()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_SFKanBan_ProcureNotReceived";
                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 ProductConsignmentLeftBottom()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_SFKanBan_ProductionNotDeliver";
                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[圣沣仓库看板右上,近一周采购待入库物料排行TOP5]
        public static ToMessage ProcureOutsourcRightTop()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_SFKanBan_ProcureNotReceivedSumTop";
                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[圣沣仓库看板右下,近一周销售待发货产品排行TOP5]
        public static ToMessage ProductionStockedInRightBottom()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_SFKanBan_ProductionNotDeliverSumTop";
                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 ProductionStockedInLeftTop()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_SFKanBan_ProductionNotReceived";
                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[圣沣生产看板右上,近一周生产待入库产品排行TOP10]
        public static ToMessage ProductionStockedInRightTop()
        {
            var sql = "";
            try
            {
                sql = @"select * from h_v_SFKanBan_ProductionNotReceivedSumTop";
                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 WorkShopProduceTopData(string wkshopcode)
        {
            string sql = "";
@@ -20,7 +160,7 @@
            try
            {
                string[] wkshoplist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string分割转string[] 
                sql = @"select * from h_v_JLKanBan_WorkshopTop where wkshp_code in @wkshoplist";
                sql = @"select * from h_v_SFKanBan_WorkshopTop where wkshp_code in @wkshoplist";
                dynamicParams.Add("@wkshoplist", wkshoplist);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                mes.code = "200";
@@ -38,7 +178,7 @@
        }
        #endregion

        #region[车间看板,下左近一周不良趋势]
        #region[圣沣车间看板,下左近一周不良趋势]
        public static ToMessage WorkShopProduceBottomLeftData(string wkshopcode)
        {
            string sql = "";
@@ -47,7 +187,7 @@
            {
                //存储过程名(当前时间往前一周)
                string[] wkshoplist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string分割转string[] 
                sql = @"h_p_JLKanBan_WorkshopBottomLeft";
                sql = @"h_p_SFKanBan_WorkshopBottomLeft";
                for (int i = 0; i < wkshoplist.Length; i++)
                {
                    var dynamicParams = new DynamicParameters();
@@ -55,7 +195,6 @@
                    var dt = DapperHelper.selectProcedure(sql, dynamicParams);
                    dir.Add(wkshoplist[i].ToString(), dt);
                }

                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = dir;
@@ -71,7 +210,7 @@
        }
        #endregion

        #region[车间看板,下右近一月不良统计]
        #region[圣沣车间看板,下右近一月不良统计]
        public static ToMessage WorkShopProduceBottomRightData(string wkshopcode)
        {
            string sql = "";
@@ -79,7 +218,7 @@
            try
            {
                string[] wkshoplist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string分割转string[] 
                sql = @"select * from h_v_JLKanBan_WorkshopBottomRight where wkshp_code in @wkshoplist";
                sql = @"select * from h_v_SFKanBan_WorkshopBottomRight where wkshp_code in @wkshoplist";
                dynamicParams.Add("@wkshoplist", wkshoplist);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                mes.code = "200";
@@ -98,47 +237,19 @@
        #endregion


        #region[车间综合看板,左上生产订单]
        #region[圣沣车间综合看板,左上生产订单]
        public static ToMessage WorkShopCompreLeftTop(string wkshopcode)
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            Dictionary<object, object> dir = new Dictionary<object, object>();
            Dictionary<object, object> dir0 = new Dictionary<object, object>();
            Dictionary<object, object> dir1 = new Dictionary<object, object>();
            try
            {
                string[] wkshoplist = Array.ConvertAll<string, string>(wkshopcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string分割转string[] 
                sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftTop";
                sql = @"select * from h_v_SFKanBan_WorkShopCompreLeftTop";
                var data = DapperHelper.selecttable(sql);
                sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftCenter";
                sql = @"select * from h_v_SFKanBan_WorkShopCompreLeftCenter";
                var data1 = DapperHelper.selecttable(sql);
                for (int i = 0; i < wkshoplist.Length; i++)
                {
                    var top0 = data.AsEnumerable()
                               .Where(row => row.Field<string>("wkshp_code") == wkshoplist[i].ToString()) // 添加查询条件
                               .Select(group => new
                               {
                                   wkshp_code = group.Field<string>("wkshp_code"),
                                   plan_qty = group.Field<decimal>("plan_qty"),
                                   good_qty = group.Field<decimal>("good_qty")
                               }).DefaultIfEmpty(new { wkshp_code = wkshoplist[i].ToString(), plan_qty = 0m, good_qty = 0m })//为空时指定默认值
                               .ToList();
                    dir0.Add(wkshoplist[i].ToString(), top0);

                    var top1 = data1.AsEnumerable()
                               .Where(row => row.Field<string>("wkshp_code") == wkshoplist[i].ToString()) // 添加查询条件
                               .Select(group => new
                               {
                                   wkshp_code = group.Field<string>("wkshp_code"),
                                   plan_qty = group.Field<decimal>("plan_qty"),
                                   quantity = group.Field<decimal>("quantity")
                               }).DefaultIfEmpty(new { wkshp_code = wkshoplist[i].ToString(), plan_qty = 0m, quantity = 0m })//为空时指定默认值
                               .ToList();
                    dir1.Add(wkshoplist[i].ToString(), top1);
                }
                dir.Add("LeftTop", dir0);
                dir.Add("LeftBottom", dir1);
                dir.Add("LeftTop", data);
                dir.Add("LeftBottom", data1);
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = dir;
@@ -154,16 +265,16 @@
        }
        #endregion

        #region[车间综合看板,右上销售订单]
        #region[圣沣车间综合看板,右上销售订单]
        public static ToMessage WorkShopCompreRightTop()
        {
            var sql = "";
            Dictionary<object, object> dir = new Dictionary<object, object>();
            try
            {
                sql = @"select * from h_v_JLKanBan_WorkShopCompreRightTop";
                sql = @"select * from h_v_SFKanBan_WorkShopCompreRightTop";
                var data = DapperHelper.selecttable(sql);
                sql = @"select * from h_v_JLKanBan_WorkShopCompreRightCenter";
                sql = @"select * from h_v_SFKanBan_WorkShopCompreRightCenter";
                var data1 = DapperHelper.selecttable(sql);
                dir.Add("RightTop", data);
                dir.Add("RightBottom", data1);
@@ -182,21 +293,58 @@
        }
        #endregion

        #region[车间综合看板,右下库存]
        #region[圣沣车间综合看板,左下采购订单]
        public static ToMessage WorkShopCompreLeftBottom()
        {
            var sql = "";
            Dictionary<object, object> dir = new Dictionary<object, object>();
            try
            {
                sql = @"select * from h_v_SFKanBan_WorkShopCompreLeftBottom_Top";
                var data = DapperHelper.selecttable(sql);
                sql = @"select * from h_v_SFKanBan_WorkShopCompreLeftBottom_Bottom";
                var data1 = DapperHelper.selecttable(sql);
                dir.Add("BottomLeftTop", data);
                dir.Add("BottomLeftBottom", 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 = @"select * from h_v_JLKanBan_WorkShopCompreRightBottom";
                sql = @"select * from h_v_SFKanBan_WorkShopCompreRightBottom";
                var data = DapperHelper.selecttable(sql);
                dir.Add("Y", data.Rows[0]["BaseQuantity"].ToString());
                dir.Add("B", data.Rows[1]["BaseQuantity"].ToString());
                dir.Add("C", data.Rows[2]["BaseQuantity"].ToString());
                mes.code = "200";
                mes.message = "查询成功!";
                mes.data = dir;
                if (data.Rows.Count > 0)
                {
                    dir.Add("Y", data.Rows[0]["BaseQuantity"].ToString());
                    dir.Add("B", data.Rows[1]["BaseQuantity"].ToString());
                    dir.Add("C", data.Rows[2]["BaseQuantity"].ToString());
                    mes.code = "200";
                    mes.message = "查询成功!";
                    mes.data = dir;
                }
                else 
                {
                    mes.code = "200";
                    mes.message = "查询成功!";
                    mes.data = null;
                }
            }
            catch (Exception e)
            {