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

yl

2024-03-15 72fb3e7707c38e113eeab778565e4da209f04a3d

 VueWebApi/Controllers/KanBanManagerentController.cs

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

        #region[正清和车间看板,获取生产车间]
        #region[北鸣仓库看板左上,生产待入库]
        /// <summary>
        /// 正清和车间看板,获取生产车间
        /// 北鸣仓库看板左上,生产待入库
        /// </summary>
        /// <returns></returns>
        [Route(template: "ShopSearch")]
        [Route(template: "ProductionStockedInLeftTop")]
        [HttpGet]
        public HttpResponseMessage ShopSearch()
        public HttpResponseMessage ProductionStockedInLeftTop()
        {
            mes = KanBanManagerentBLL.ShopSearch();
            mes = KanBanManagerentBLL.ProductionStockedInLeftTop();
            return TJson.toJson(mes);
        }
        #endregion

        #region[正清和车间看板,左上产线加工任务接口]
        #region[北鸣仓库看板左下,产品待发货]
        /// <summary>
        /// 正清和车间看板,左上产线加工任务接口
        /// 北鸣仓库看板左下,产品待发货
        /// </summary>
        /// <param name="shopcode">车间编码</param>
        /// <returns></returns>
        [Route(template: "LineSearchTopLeftData")]
        [HttpPost]
        public HttpResponseMessage LineSearchTopLeftData(string shopcode)
        [Route(template: "ProductConsignmentLeftBottom")]
        [HttpGet]
        public HttpResponseMessage ProductConsignmentLeftBottom()
        {
            mes = KanBanManagerentBLL.LineSearchTopLeftData(shopcode);
            mes = KanBanManagerentBLL.ProductConsignmentLeftBottom();
            return TJson.toJson(mes);
        }
        #endregion

        #region[正清和车间看板,左下列表接口]
        #region[北鸣仓库看板右上,近一周生产待入库产品排行TOP5]
        /// <summary>
        /// 正清和车间看板,左下列表接口
        /// 北鸣仓库看板右上,近一周生产待入库产品排行TOP5
        /// </summary>
        /// <param name="shopcode">车间编码</param>
        /// <returns></returns>
        [Route(template: "LineSearchBottomLeftData")]
        [Route(template: "ProductionStockedInRightTop")]
        [HttpGet]
        public HttpResponseMessage LineSearchBottomLeftData(string shopcode)
        public HttpResponseMessage ProductionStockedInRightTop()
        {
            mes = KanBanManagerentBLL.LineSearchBottomLeftData(shopcode);
            mes = KanBanManagerentBLL.ProductionStockedInRightTop();
            return TJson.toJson(mes);
        }
        #endregion

        #region[正清和车间看板,右上top排行接口]
        #region[北鸣仓库看板右下,近一周销售待发货产品排行TOP5]
        /// <summary>
        /// 正清和车间看板,右上top排行接口
        /// 北鸣仓库看板右下,近一周销售待发货产品排行TOP5
        /// </summary>
        /// <param name="shopcode">车间编码</param>
        /// <returns></returns>
        [Route(template: "LineSearchTopRightData")]
        [Route(template: "ProductionStockedInRightBottom")]
        [HttpGet]
        public HttpResponseMessage LineSearchTopRightData(string shopcode)
        public HttpResponseMessage ProductionStockedInRightBottom()
        {
            mes = KanBanManagerentBLL.LineSearchTopRightData(shopcode);
            return TJson.toJson(mes);
        }
        #endregion

        #region[正清和车间看板,右下top排行接口]
        /// <summary>
        /// 正清和车间看板,右下top排行接口
        /// </summary>
        /// <param name="shopcode">车间编码</param>
        /// <returns></returns>
        [Route(template: "LineSearchBottomRightData")]
        [HttpGet]
        public HttpResponseMessage LineSearchBottomRightData(string shopcode)
        {
            mes = KanBanManagerentBLL.LineSearchBottomRightData(shopcode);
            mes = KanBanManagerentBLL.ProductionStockedInRightBottom();
            return TJson.toJson(mes);
        }
        #endregion




        #region[正清和车间质量数字化看板,左上top5不良]
        #region[北鸣采购委外看板左上,采购待入库]
        /// <summary>
        /// 正清和车间质量数字化看板,左上top5不良
        /// 北鸣采购委外看板左上,采购待入库
        /// </summary>
        /// <param name="wkshopcode">车间编码字符串集</param>
        /// <returns></returns>
        [Route(template: "QCBadTop")]
        [Route(template: "ProcureOutsourcLeftTop")]
        [HttpGet]
        public HttpResponseMessage QCBadTop(string wkshopcode)
        public HttpResponseMessage ProcureOutsourcLeftTop()
        {
            mes = KanBanManagerentBLL.QCBadTop(wkshopcode);
            mes = KanBanManagerentBLL.ProcureOutsourcLeftTop();
            return TJson.toJson(mes);
        }
        #endregion

        #region[正清和车间质量数字化看板,左中周不良趋势]
        #region[北鸣采购委外看板左下,委外待入库]
        /// <summary>
        /// 正清和车间质量数字化看板,左中周不良趋势
        /// 北鸣采购委外看板左上,委外待入库
        /// </summary>
        /// <param name="wkshopcode">车间编码字符串集</param>
        /// <returns></returns>
        [Route(template: "QCBadCenterLeftWeek")]
        [Route(template: "ProcureOutsourcLeftBottom")]
        [HttpGet]
        public HttpResponseMessage QCBadCenterLeftWeek(string wkshopcode)
        public HttpResponseMessage ProcureOutsourcLeftBottom()
        {
            mes = KanBanManagerentBLL.QCBadCenterLeftWeek(wkshopcode);
            mes = KanBanManagerentBLL.ProcureOutsourcLeftBottom();
            return TJson.toJson(mes);
        }
        #endregion

        #region[正清和车间质量数字化看板,右中周完成数/率]
        #region[北鸣采购委外看板右上,近一周采购待入库物料排行TOP5]
        /// <summary>
        /// 正清和车间质量数字化看板,右中周完成数/率
        /// 北鸣采购委外看板右上,近一周采购待入库物料排行TOP5
        /// </summary>
        /// <param name="wkshopcode">车间编码字符串集</param>
        /// <returns></returns>
        [Route(template: "QCBadCenterRightWeek")]
        [Route(template: "ProcureOutsourcRightTop")]
        [HttpGet]
        public HttpResponseMessage QCBadCenterRightWeek(string wkshopcode)
        public HttpResponseMessage ProcureOutsourcRightTop()
        {
            mes = KanBanManagerentBLL.QCBadCenterRightWeek(wkshopcode);
            mes = KanBanManagerentBLL.ProcureOutsourcRightTop();
            return TJson.toJson(mes);
        }
        #endregion

        #region[正清和车间质量数字化看板,下任务进度]
        #region[北鸣采购委外看板右下,近一周委外待入库产品排行TOP5]
        /// <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[正清和仓库看板,左上产品待入库列表]
        /// <summary>
        /// 正清和仓库看板,左上产品待入库列表
        /// 北鸣采购委外看板右下,近一周委外待入库产品排行TOP5
        /// </summary>
        /// <returns></returns>
        [Route(template: "WareHouseTopLeftData")]
        [Route(template: "ProcureOutsourcRightBottom")]
        [HttpGet]
        public HttpResponseMessage WareHouseTopLeftData()
        public HttpResponseMessage ProcureOutsourcRightBottom()
        {
            mes = KanBanManagerentBLL.WareHouseTopLeftData();
            return TJson.toJson(mes);
        }
        #endregion

        #region[正清和仓库看板,左下产品待发货列表]
        /// <summary>
        /// 正清和仓库看板,左下产品待发货列表
        /// </summary>
        /// <returns></returns>
        [Route(template: "WareHouseTopBottomData")]
        [HttpGet]
        public HttpResponseMessage WareHouseTopBottomData()
        {
            mes = KanBanManagerentBLL.WareHouseTopBottomData();
            return TJson.toJson(mes);
        }
        #endregion

        #region[正清和仓库看板,右上成品库、半成品库top5库存排行]
        /// <summary>
        /// 正清和仓库看板,右上成品库、半成品库top5库存排行
        /// </summary>
        /// <returns></returns>
        [Route(template: "WareHouseRightTopData")]
        [HttpGet]
        public HttpResponseMessage WareHouseRightTopData()
        {
            mes = KanBanManagerentBLL.WareHouseRightTopData();
            return TJson.toJson(mes);
        }
        #endregion

        #region[正清和仓库看板,右下原料库库top5库存排行]
        /// <summary>
        /// 正清和仓库看板,右下原料库库top5库存排行
        /// </summary>
        /// <returns></returns>
        [Route(template: "WareHouseRightBottomData")]
        [HttpGet]
        public HttpResponseMessage WareHouseRightBottomData()
        {
            mes = KanBanManagerentBLL.WareHouseRightBottomData();
            return TJson.toJson(mes);
        }
        #endregion



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