生产进度报表优化查询语句

yl

2024-03-15 27f0636da2b4b22a16404a3dbea4b3d3d477a65e

 VueWebApi/Controllers/KanBanManagerentController.cs

@@ -18,9 +18,9 @@
        ToMessage mes = new ToMessage();
        RedisHelper redis = new RedisHelper();

        #region[大岛车间综合看板,获取生产车间]
        #region[正清和车间看板,获取生产车间]
        /// <summary>
        /// 大岛车间综合看板,获取生产车间
        /// 正清和车间看板,获取生产车间
        /// </summary>
        /// <returns></returns>
        [Route(template: "ShopSearch")]
@@ -32,9 +32,9 @@
        }
        #endregion

        #region[大岛车间综合看板,左上产线加工任务接口]
        #region[正清和车间看板,左上产线加工任务接口]
        /// <summary>
        /// 大岛车间综合看板,左上产线加工任务接口
        /// 正清和车间看板,左上产线加工任务接口
        /// </summary>
        /// <param name="shopcode">车间编码</param>
        /// <returns></returns>
@@ -47,9 +47,9 @@
        }
        #endregion

        #region[大岛车间综合看板,左下列表接口]
        #region[正清和车间看板,左下列表接口]
        /// <summary>
        /// 大岛车间综合看板,左下列表接口
        /// 正清和车间看板,左下列表接口
        /// </summary>
        /// <param name="shopcode">车间编码</param>
        /// <returns></returns>
@@ -62,9 +62,9 @@
        }
        #endregion

        #region[大岛车间综合看板,右上top排行接口]
        #region[正清和车间看板,右上top排行接口]
        /// <summary>
        /// 大岛车间综合看板,右上top排行接口
        /// 正清和车间看板,右上top排行接口
        /// </summary>
        /// <param name="shopcode">车间编码</param>
        /// <returns></returns>
@@ -77,9 +77,9 @@
        }
        #endregion

        #region[大岛车间综合看板,右下top排行接口]
        #region[正清和车间看板,右下top排行接口]
        /// <summary>
        /// 大岛车间综合看板,右下top排行接口
        /// 正清和车间看板,右下top排行接口
        /// </summary>
        /// <param name="shopcode">车间编码</param>
        /// <returns></returns>
@@ -94,53 +94,73 @@



        #region[采购订单跟踪管理看板,左上本月采购订单数、本月采购进货单数、本月采购入库单数]

        #region[正清和车间质量数字化看板,左上top5不良]
        /// <summary>
        /// 采购订单跟踪管理看板,左上本月采购订单数、本月采购进货单数、本月采购入库单数
        /// 正清和车间质量数字化看板,左上top5不良
        /// </summary>
        /// <param name="wkshopcode">车间编码字符串集</param>
        /// <returns></returns>
        [Route(template: "PurchaseLeftTop")]
        [Route(template: "QCBadTop")]
        [HttpGet]
        public HttpResponseMessage PurchaseLeftTop()
        public HttpResponseMessage QCBadTop(string wkshopcode)
        {
            mes = KanBanManagerentBLL.PurchaseLeftTop();
            mes = KanBanManagerentBLL.QCBadTop(wkshopcode);
            return TJson.toJson(mes);
        }
        #endregion

        #region[采购订单跟踪管理看板,左下采购订单跟踪列表]
        #region[正清和车间质量数字化看板,左中周不良趋势]
        /// <summary>
        /// 采购订单跟踪管理看板,左下采购订单跟踪列表
        /// 正清和车间质量数字化看板,左中周不良趋势
        /// </summary>
        /// <param name="wkshopcode">车间编码字符串集</param>
        /// <returns></returns>
        [Route(template: "PurchaseLeftBottom")]
        [Route(template: "QCBadCenterLeftWeek")]
        [HttpGet]
        public HttpResponseMessage PurchaseLeftBottom()
        public HttpResponseMessage QCBadCenterLeftWeek(string wkshopcode)
        {
            mes = KanBanManagerentBLL.PurchaseLeftBottom();
            mes = KanBanManagerentBLL.QCBadCenterLeftWeek(wkshopcode);
            return TJson.toJson(mes);
        }
        #endregion

        #region[采购订单跟踪管理看板,右侧Top]
        #region[正清和车间质量数字化看板,右中周完成数/率]
        /// <summary>
        /// 采购订单跟踪管理看板,右侧Top
        /// 正清和车间质量数字化看板,右中周完成数/率
        /// </summary>
        /// <param name="wkshopcode">车间编码字符串集</param>
        /// <returns></returns>
        [Route(template: "PurchaseRight")]
        [Route(template: "QCBadCenterRightWeek")]
        [HttpGet]
        public HttpResponseMessage PurchaseRight()
        public HttpResponseMessage QCBadCenterRightWeek(string wkshopcode)
        {
            mes = KanBanManagerentBLL.PurchaseRight();
            mes = KanBanManagerentBLL.QCBadCenterRightWeek(wkshopcode);
            return TJson.toJson(mes);
        }
        #endregion

        #region[正清和车间质量数字化看板,下任务进度]
        /// <summary>
        /// 正清和车间质量数字化看板,下任务进度
        /// </summary>
        /// <param name="wkshopcode">车间编码字符串集</param>
        /// <returns></returns>
        [Route(template: "QCBadBottomWeek")]
        [HttpGet]
        public HttpResponseMessage QCBadBottomWeek(string wkshopcode)
        {
            mes = KanBanManagerentBLL.QCBadBottomWeek(wkshopcode);
            return TJson.toJson(mes);
        }
        #endregion



        #region[大岛仓库看板,左上产品待入库列表]

        #region[正清和仓库看板,左上产品待入库列表]
        /// <summary>
        /// 大岛仓库看板,左上产品待入库列表
        /// 正清和仓库看板,左上产品待入库列表
        /// </summary>
        /// <returns></returns>
        [Route(template: "WareHouseTopLeftData")]
@@ -152,9 +172,9 @@
        }
        #endregion

        #region[大岛仓库看板,左下产品待发货列表]
        #region[正清和仓库看板,左下产品待发货列表]
        /// <summary>
        /// 大岛仓库看板,左下产品待发货列表
        /// 正清和仓库看板,左下产品待发货列表
        /// </summary>
        /// <returns></returns>
        [Route(template: "WareHouseTopBottomData")]
@@ -166,9 +186,9 @@
        }
        #endregion

        #region[大岛仓库看板,右上成品库、半成品库top5库存排行]
        #region[正清和仓库看板,右上成品库、半成品库top5库存排行]
        /// <summary>
        /// 大岛仓库看板,右上成品库、半成品库top5库存排行
        /// 正清和仓库看板,右上成品库、半成品库top5库存排行
        /// </summary>
        /// <returns></returns>
        [Route(template: "WareHouseRightTopData")]
@@ -180,9 +200,9 @@
        }
        #endregion

        #region[大岛仓库看板,右下原料库库top5库存排行]
        #region[正清和仓库看板,右下原料库库top5库存排行]
        /// <summary>
        /// 大岛仓库看板,右下原料库库top5库存排行
        /// 正清和仓库看板,右下原料库库top5库存排行
        /// </summary>
        /// <returns></returns>
        [Route(template: "WareHouseRightBottomData")]
@@ -196,17 +216,45 @@



        #region[车间看板公告]
        #region[正清和车间综合看板,左上生产订单]
        /// <summary>
        /// 车间看板公告
        /// 正清和车间综合看板,左上生产订单
        /// </summary>
        /// <param name="shopcode">车间编码</param>
        /// <param name="wkshopcode">车间编码字符串集</param>
        /// <returns></returns>
        [Route(template: "WkspReportNotice")]
        [HttpPost]
        public HttpResponseMessage WkspReportNotice(string shopcode)
        [Route(template: "WorkShopCompreLeftTop")]
        [HttpGet]
        public HttpResponseMessage WorkShopCompreLeftTop(string wkshopcode)
        {
            mes = KanBanManagerentBLL.WkspReportNotice(shopcode);
            mes = KanBanManagerentBLL.WorkShopCompreLeftTop(wkshopcode);
            return TJson.toJson(mes);
        }
        #endregion

        #region[正清和车间综合看板,右上销售订单]
        /// <summary>
        /// 正清和车间综合看板,右上销售订单
        /// </summary>
        /// <returns></returns>
        [Route(template: "WorkShopCompreRightTop")]
        [HttpGet]
        public HttpResponseMessage WorkShopCompreRightTop()
        {
            mes = KanBanManagerentBLL.WorkShopCompreRightTop();
            return TJson.toJson(mes);
        }
        #endregion

        #region[正清和车间综合看板,右下库存]
        /// <summary>
        /// 正清和车间综合看板,右下库存
        /// </summary>
        /// <returns></returns>
        [Route(template: "WorkShopCompreRightBottom")]
        [HttpGet]
        public HttpResponseMessage WorkShopCompreRightBottom()
        {
            mes = KanBanManagerentBLL.WorkShopCompreRightBottom();
            return TJson.toJson(mes);
        }
        #endregion