分支自 SuZhouGuanHong/TaiYuanTaiZhong
blame | 历史 | 补丁 | 提交 | 提交对比 | 显示空白
dengjunjie
2024-07-05 ddab693f389b648157c8b48c7fcbdefc92561dd2 
 ´úÂë¹ÜÀí/WMS/WMS_Server/WIDESEA_WebApi/Controllers/LargescreenController.cs


@@ -6,6 +6,8 @@


using System.Linq;


using System.Security.Cryptography;


using System.Xml.Linq;


using WIDESEA_Comm;


using WIDESEA_Common;


using WIDESEA_Core.EFDbContext;


using WIDESEA_Entity.DomainModels;


using WIDESEA_WMS.IRepositories;


@@ -96,21 +98,21 @@


            var endDate = startDate.AddMonths(1).AddDays(-1);


            var today = DateTime.Today;




            var data2 = db.Find(x => x.agv_createtime >= startDate && x.agv_createtime <= endDate);


            var data2 = db.Find(x => x.agv_finishedtime >= startDate && x.agv_finishedtime <= endDate);




            var data3 = db.Find(x => x.agv_createtime >= today && x.agv_createtime < today.AddDays(1)).ToList();


            var data3 = db.Find(x => x.agv_finishedtime >= today && x.agv_finishedtime < today.AddDays(1)).ToList();




            // ç»Ÿè®¡è¿™æœˆçš„入库数量


            var monthlyInventory = data2.Where(x => x.agv_tasktype == "TaskType_Inbound").Sum(x => x.agv_qty);


            var monthlyInventory = data2.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_Inbound.ToString()).Sum(x => x.agv_qty);




            // ç»Ÿè®¡è¿™æœˆçš„出库数量


            var monthlyOutbound = data2.Where(x => x.agv_tasktype == "TaskType_Outbound").Sum(x => x.agv_qty);


            var monthlyOutbound = data2.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_Outbound.ToString() || x.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceCarry.ToString()).Sum(x => x.agv_qty);




            // ç»Ÿè®¡ä»Šæ—¥å…¥åº“数量


            var dayInventory = data3.Where(x => x.agv_tasktype == "TaskType_Inbound").Sum(x => x.agv_qty);


            var dayInventory = data3.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_Inbound.ToString()).Sum(x => x.agv_qty);




            // ç»Ÿè®¡ä»Šæ—¥å‡ºåº“数量


            var dayOutbound = data3.Where(x => x.agv_tasktype == "TaskType_Outbound").Sum(x => x.agv_qty);


            var dayOutbound = data3.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_Outbound.ToString() || x.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceCarry.ToString()).Sum(x => x.agv_qty);




            var data = new


            {


@@ -141,31 +143,31 @@






            //今日待检测入库


            var dayTaskType_Inbound = data2.Where(x => x.agv_tasktype == "TaskType_Inbound").Sum(x => x.agv_qty);


            var dayTaskType_Inbound = data2.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_Inbound.ToString()).Sum(x => x.agv_qty);


            //待检测出库


            var dayTaskType_Outbound = data2.Where(x => x.agv_tasktype == "TaskType_Outbound").Sum(x => x.agv_qty);


            var dayTaskType_Outbound = data2.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_Outbound.ToString()).Sum(x => x.agv_qty);


            //外协库入库


            var dayTaskType_OutsourceInbound = data2.Where(x => x.agv_tasktype == "TaskType_OutsourceInbound").Sum(x => x.agv_qty);


            var dayTaskType_OutsourceInbound = data2.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceInbound.ToString()).Sum(x => x.agv_qty);


            //外协库出库


            var dayTaskType_OutsourceOutbound = data2.Where(x => x.agv_tasktype == "TaskType_OutsourceOutbound").Sum(x => x.agv_qty);


            var dayTaskType_OutsourceOutbound = data2.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceOutbound.ToString()).Sum(x => x.agv_qty);


            //待检移库外协


            var dayTaskType_OutsourceCarry = data2.Where(x => x.agv_tasktype == "TaskType_OutsourceCarry").Sum(x => x.agv_qty);


            var dayTaskType_OutsourceCarry = data2.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceCarry.ToString()).Sum(x => x.agv_qty);


            //空托数量


            var dayTaskType_EmptyPallet = data2.Where(x => x.agv_tasktype == "TaskType_EmptyPallet").Sum(x => x.agv_qty);


            var dayTaskType_EmptyPallet = data2.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_EmptyPallet.ToString()).Sum(x => x.agv_qty);




            //统计月入库总量


            var startDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);


            var endDate = startDate.AddMonths(1).AddDays(-1);


            var data4 = db.Find(x => x.agv_createtime >= startDate && x.agv_createtime <= endDate);


            // ç»Ÿè®¡è¿™æœˆçš„入库数量


            var monthlyInventory = data4.Where(x => x.agv_tasktype == "TaskType_Inbound").Sum(x => x.agv_qty);


            var monthlyInventory = data4.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_Inbound.ToString()).Sum(x => x.agv_qty);


            // ç»Ÿè®¡è¿™æœˆçš„出库数量


            var monthlyOutbound = data4.Where(x => x.agv_tasktype == "TaskType_Outbound").Sum(x => x.agv_qty);


            var monthlyOutbound = data4.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_Outbound.ToString() || x.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceCarry.ToString()).Sum(x => x.agv_qty);


            // ç»Ÿè®¡ä»Šæ—¥å…¥åº“数量


            var dayInventory = data2.Where(x => x.agv_tasktype == "TaskType_Inbound").Sum(x => x.agv_qty);


            var dayInventory = data2.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_Inbound.ToString()).Sum(x => x.agv_qty);




            // ç»Ÿè®¡ä»Šæ—¥å‡ºåº“数量


            var dayOutbound = data2.Where(x => x.agv_tasktype == "TaskType_Outbound").Sum(x => x.agv_qty);


            var dayOutbound = data2.Where(x => x.agv_tasktype == AGVTaskTypeEnum.TaskType_Outbound.ToString() || x.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceCarry.ToString()).Sum(x => x.agv_qty);






            var data3 = db2.Find(_ => true).Where(x => x.stationCode.Contains("A") || x.stationCode.Contains("B") || x.stationCode.Contains("C") || x.stationCode.Contains("D01")).ToList();


@@ -183,7 +185,7 @@


                 tray_type = g.Key.tray_type


             }).ToList();




            var Number_wheels = Number_wheels1.Where(x => x.stationType != "LargeTray" && x.stationType != "SmallTray").ToList();


            var Number_wheels = Number_wheels1.Where(x => x.stationType != TrayTypeEnum.LargeTray.ToString() && x.stationType != TrayTypeEnum.SmallTray.ToString()).ToList();


            #endregion






@@ -244,12 +246,10 @@


        [HttpPost("Warehouse_area")]


        public object Warehouse_area()


        {






            VOLContext volContext = new VOLContext();


            Idt_stationinfoRepository db = new dt_stationinfoRepository(volContext);


            string[] areas = { "2", "3", "4" };


            var data2 = db.Find(a => areas.Contains(a.area)).ToList();


            var data2 = db.Find(a => areas.Contains(a.area)).OrderBy(x => x.stationCode).ToList();


            var dataList = new List<dynamic>();




            foreach (string area in areas)


@@ -261,10 +261,10 @@


                    Area = x.Key.area,


                    x.Key.line,


                    x.Key.stationType,


                    combined_heatNumber = string.Join(", ", x.Select(y => y.heatNumber).Distinct())


                    combined_heatNumber = string.Join(", ", x.Select(y => y.heatNumber).Distinct()),


                })


                .OrderBy(x => x.Area)


                .ThenBy(x => x.line)


                .OrderBy(x => x.line)


                //.ThenBy(x => x.line)


                .GroupBy(x => x.line) // ä½¿ç”¨ GroupBy æŒ‰ Line å­—段分组


                .Select(group =>


                {


@@ -302,15 +302,15 @@


            var today = DateTime.Today;


            var dateRange = Enumerable.Range(0, 5).Select(offset => today.AddDays(-offset)); // èŽ·å–最近15天的日期范围




            var data2 = db.Find(x => x.agv_createtime >= startDate && x.agv_createtime < today.AddDays(1)).ToList();


            var data2 = db.Find(x => x.agv_finishedtime >= startDate && x.agv_finishedtime < today.AddDays(1)).ToList();




            var result = dateRange.Reverse().Select(date =>


            {


                // ç»Ÿè®¡å½“日入库数量


                var dayInventory = data2.Where(x => x.agv_createtime >= date && x.agv_createtime < date.AddDays(1) && x.agv_tasktype == "TaskType_Inbound").Sum(x => x.agv_qty);


                var dayInventory = data2.Where(x => x.agv_finishedtime >= date && x.agv_finishedtime < date.AddDays(1) && x.agv_tasktype == AGVTaskTypeEnum.TaskType_Inbound.ToString()).Sum(x => x.agv_qty);




                // ç»Ÿè®¡å½“日出库数量


                var dayOutbound = data2.Where(x => x.agv_createtime >= date && x.agv_createtime < date.AddDays(1) && x.agv_tasktype == "TaskType_Outbound").Sum(x => x.agv_qty);


                var dayOutbound = data2.Where(x => x.agv_finishedtime >= date && x.agv_finishedtime < date.AddDays(1) && x.agv_tasktype == AGVTaskTypeEnum.TaskType_Outbound.ToString() || x.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceCarry.ToString()).Sum(x => x.agv_qty);




                return new


                {