Admin
2026-01-22 bde09c027eee16a7b05b82e71dea4d3405d6d52d
ÏîÄ¿´úÂë/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/LocationInfoService.cs
@@ -305,5 +305,68 @@
            public DateTime DateTime { get; set; }
        }
        public WebResponseContent GetArea()
        {
            // WarehouseId分组,然后是RoadwayNo
            var result = BaseDal.QueryData()
                .GroupBy(x => x.WarehouseId)
                .Select(g => new {
                    WarehouseId = g.Key,
                    RoadwayNo = g.Select(x => x.RoadwayNo).Distinct().ToList()
                })
                .ToList();
            return WebResponseContent.Instance.OK("成功", result);
        }
        public WebResponseContent GetLocationStatus(int WarehouseId, string RoadwayNo)
        {
            // æ ¼å¼{层,{这一层的列数据}}
            var locations = BaseDal.QueryData(x => x.WarehouseId == WarehouseId && x.RoadwayNo == RoadwayNo)
                .Select(x => new
                {
                    x.RoadwayNo,
                    x.WarehouseId,
                    x.Row,
                    x.Column,
                    x.Layer,
                    x.Depth,
                    x.LocationType,
                    x.LocationStatus,
                    x.EnableStatus
                })
                .ToList();
            // å¦‚果没有找到数据,返回空列表而不是null
            if (locations == null || !locations.Any())
            {
                return WebResponseContent.Instance.OK("未找到对应巷道的货位数据", new List<object>());
            }
            // ä¿®æ”¹ä¸ºå±‚下面放所有列的信息
            var result = locations
                .GroupBy(x => x.Layer)  // æŒ‰å±‚分组
                .Select(layerGroup => new
                {
                    layer = layerGroup.Key,
                    columns = layerGroup.GroupBy(x => x.Column)  // æ¯å±‚中按列分组
                                       .Select(columnGroup => new
                                       {
                                           column = columnGroup.Key,
                                           depths = columnGroup.Select(d => new
                                           {
                                               row = d.Row,
                                               depth = d.Depth,
                                               locationType = d.LocationType,
                                               locationStatus = d.LocationStatus,
                                               enableStatus = d.EnableStatus
                                           }).ToList()
                                       }).ToList()
                }).ToList();
            return WebResponseContent.Instance.OK("成功", result);
        }
    }
}