桥下车间综合看板增加采购订单

yl

2024-09-26 7d1ef31efa71b7514e1d912de43ff2096880ef92

 VueWebCoreApi/DLL/DAL/KanBanManagerentDAL.cs

@@ -182,6 +182,34 @@
        }
        #endregion

        #region[车间综合看板,左下采购订单]
        public static ToMessage WorkShopCompreLeftBottom()
        {
            var sql = "";
            Dictionary<object, object> dir = new Dictionary<object, object>();
            try
            {
                sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftBottom_Top";
                var data = DapperHelper.selecttable(sql);
                sql = @"select * from h_v_JLKanBan_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()
        {