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

yl

2024-09-26 7d1ef31efa71b7514e1d912de43ff2096880ef92

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

 VueWebCoreApi/Controllers/KanBanManagerentController.cs

@@ -92,6 +92,20 @@
        }
        #endregion

        #region[车间综合看板,左下采购订单]
        /// <summary>
        /// 车间综合看板,左下采购订单
        /// </summary>
        /// <returns></returns>
        [Route(template: "WorkShopCompreLeftBottom")]
        [HttpGet]
        public JsonResult WorkShopCompreLeftBottom()
        {
            mes = KanBanManagerentBLL.WorkShopCompreLeftBottom();
            return Json(mes);
        }
        #endregion

        #region[车间综合看板,右下库存]
        /// <summary>
        /// 车间综合看板,右下库存

 VueWebCoreApi/DLL/BLL/KanBanManagerentBLL.cs

@@ -45,6 +45,13 @@
        }
        #endregion

        #region[车间综合看板,左下采购订单]
        public static ToMessage WorkShopCompreLeftBottom()
        {
            return KanBanManagerentDAL.WorkShopCompreLeftBottom();
        }
        #endregion

        #region[车间综合看板,右下库存]
        public static ToMessage WorkShopCompreRightBottom()
        {

 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()
        {