1
duyongjia
2025-02-20 e949e6c395aa94e64204b5f4a7be0a86626db8a0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
 
 
using WIDESEAWCS_Core;
using WIDESEAWCS_Core.BaseRepository;
using WIDESEAWCS_Core.BaseServices;
using WIDESEAWCS_IWMSPart;
using WIDESEAWCS_Model.Models;
 
namespace WIDESEAWCS_WMSPart
{
    /// <summary>
    /// 货位信息业务接口实现层
    /// </summary>
    public partial class LocationInfoService : ServiceBase<Dt_LocationInfo, IRepository<Dt_LocationInfo>>, ILocationInfoService
    {
        public IRepository<Dt_LocationInfo> Repository => BaseDal;
 
        public LocationInfoService(IRepository<Dt_LocationInfo> BaseDal) : base(BaseDal)
        {
        }
 
        public override PageGridData<Dt_LocationInfo> GetPageData(PageDataOptions options)
        {
            return base.GetPageData(options);
        }
 
        public WebResponseContent GetLocationLayer()
        {
            WebResponseContent content = new WebResponseContent();
            try
            {
                List<object> data = new List<object>();
                var layerNum = Repository.QueryData().Max(v => v.Layer);
                for (int i = 0; i < layerNum; i++)
                {
                    object obj = new
                    {
                        value = i + 1,
                        label = (i + 1) + "层"
                    };
                    data.Add(obj);
                }
                return content = WebResponseContent.Instance.OK(data: data);
            }
            catch (Exception ex)
            {
                return content = WebResponseContent.Instance.Error(ex.Message);
            }
        }
 
        public WebResponseContent GetLocationConfigs(int layer)
        {
            try
            {
                object locationConfigs = Repository.QueryData(x => x.Layer == layer).GroupBy(x => x.RoadwayNo).Select(x => new
                {
                    colNum = x.Max(v => v.Column),
                    rowNum = x.Max(v => v.Row),
                    layer = layer,
                    tunnel = x.Key,
                    tunnelRowNo = x.Key,
                    location = layer + "层",
                    locationList = x.Select(v => new LocationConfig
                    {
                        col = v.Column,
                        row = v.Row,
                        state = v.LocationStatus,
                        code = v.LocationCode,
                        islock = v.EnableStatus,
                        layer = layer,
                        name = v.LocationName,
                        materiaCode = "",
                        materialName = "",
                        barcode = "",
                        qty = 0
                    })
                }).ToList();
 
                return WebResponseContent.Instance.OK(data: locationConfigs);
            }
            catch (Exception ex)
            {
                return WebResponseContent.Instance.Error(ex.Message);
            }
        }
 
    }
 
    public class LocationConfig
    {
        public int layer { get; set; }
        public int col { get; set; }
 
        public int row { get; set; }
 
        public string name { get; set; }
 
        public string code { get; set; }
 
        public int state { get; set; }
 
        public int islock { get; set; }
 
        public string materiaCode { get; set; }
 
        public string materialName { get; set; }
 
        public string barcode { get; set; }
 
        public decimal? qty { get; set; }
    }
}