2025/5/29提交

Tjiny

2025-05-29 d471478f1b3373a9001ab9ebc4eb7f52384a4ec3

 HH.WCS.Mobox3.RiDong/generalMethod/LocationMethod.cs

@@ -173,7 +173,28 @@
            // 查询出所有该优先级的可用货位
            var locations = sqlSugarClient.Queryable<Location>()
                .Where(p => p.N_PRIORITY == priority && p.N_CURRENT_NUM == 0 && p.N_LOCK_STATE == 0 && p.N_PURPOSE == 1).ToList();
                
            
            // 优先查询今日份任务中未完成的（等待，执行中）
            var notQueryList = AdoSqlMethod<Operation>.QueryList(p=>p.N_B_STATE < 2 && p.T_CREATE.Date == DateTime.Today);

            if (notQueryList.Count > 0)
            {
                var groupBy = notQueryList.GroupBy(p=>p.N_ROADWAY);

                foreach (var item in groupBy)
                {
                    if (item.Key == 1 || item.Key == 2 || item.Key == 3 ||
                        item.Key == 4)
                    {
                        locations = locations.Where(p=>p.N_ROADWAY != item.Key).ToList();
                    }
                    else if (item.Key == 5 && item.ToList().Count >= 3)
                    {
                        locations = locations.Where(p=>p.N_ROADWAY != item.Key).ToList();
                    }
                }
            }
            
            // 存在该优先级的可用货位
            if (locations.Count > 0)
            {
@@ -199,7 +220,8 @@
                    .Where(p => p.N_PRIORITY == i && p.N_CURRENT_NUM == 0 && p.N_LOCK_STATE == 0 && p.N_PURPOSE == 1).ToList();
                
                // 优先查询今日份任务中未完成的（等待，执行中）
                var notQueryList = AdoSqlMethod<Operation>.QueryList(p=>p.N_B_STATE < 2 && p.T_CREATE.Date == DateTime.Today);
                var notQueryList = AdoSqlMethod<Operation>
                    .QueryList(p=>p.N_B_STATE < 2 && p.T_CREATE.Date == DateTime.Today && (p.N_TYPE == 1 || p.N_TYPE == 3));

                if (notQueryList.Count > 0)
                {