修改

ke_junjie

2025-06-04 84620534eb627e95811b971a4b552b6a177829bf

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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
using Furion.DatabaseAccessor;
using Furion.DependencyInjection;
using Furion.DynamicApiController;
using Furion.FriendlyException;
using iWare.Wms.Core;
using iWare.Wms.Core.Enum;
using Mapster;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup;
using System.Linq.Dynamic.Core;
 
namespace iWare.Wms.Application
{
    /// <summary>
    /// 库位视图
    /// </summary>
    [ApiDescriptionSettings("统计查询", Name = "LocationView", Order = 100)]
    [Route("api/[Controller]")]
    public class LocationViewService : ILocationViewService, IDynamicApiController, ITransient
    {
        private readonly IRepository<WmsContainer, MasterDbContextLocator> _wmsContainerRep;
        private readonly IRepository<WmsMaterial, MasterDbContextLocator> _wmsMaterialRep;
        private readonly IRepository<WmsMaterialContainer, MasterDbContextLocator> _wmsMaterialContainerRep;
        private readonly IRepository<WmsArea, MasterDbContextLocator> _wmsAreaRep;
        private readonly IRepository<WmsPlace, MasterDbContextLocator> _wmsPlaceRep;
        private readonly IRepository<WmsTask, MasterDbContextLocator> _wmsTaskRep;
        private readonly IRepository<WmsMaterialStock, MasterDbContextLocator> _wmsMaterialStockRep;
        private readonly IRepository<WareContainerVsMaterial, MasterDbContextLocator> _wmsContainerPlaceRep;
        private readonly IRepository<WareLocationVsContainer, MasterDbContextLocator> _wareLocationVsContainer;
        private readonly IRepository<v_ware_inventory_by_container, MasterDbContextLocator> _v_ware_inventory_by_container;
 
        public LocationViewService(
             IRepository<WmsContainer, MasterDbContextLocator> wmsContainerRep,
            IRepository<WmsMaterial, MasterDbContextLocator> wmsMaterialRep,
            IRepository<WmsMaterialContainer, MasterDbContextLocator> wmsMaterialContainerRep,
            IRepository<WmsArea, MasterDbContextLocator> wmsAreaRep,
            IRepository<WmsPlace, MasterDbContextLocator> wmsPlaceRep,
            IRepository<WmsTask, MasterDbContextLocator> wmsTaskRep,
            IRepository<WmsMaterialStock, MasterDbContextLocator> wmsMaterialStockRep,
            IRepository<WareContainerVsMaterial, MasterDbContextLocator> wmsContainerPlaceRep,
            IRepository<WareLocationVsContainer, MasterDbContextLocator> wareLocationVsContainer,
            IRepository<v_ware_inventory_by_container, MasterDbContextLocator> v_ware_inventory_by_container
        )
        {
            _wmsContainerRep = wmsContainerRep;
            _wmsMaterialRep = wmsMaterialRep;
            _wmsMaterialContainerRep = wmsMaterialContainerRep;
            _wmsAreaRep = wmsAreaRep;
            _wmsPlaceRep = wmsPlaceRep;
            _wmsTaskRep = wmsTaskRep;
            _wmsMaterialStockRep = wmsMaterialStockRep;
            _wmsContainerPlaceRep = wmsContainerPlaceRep;
            _wareLocationVsContainer = wareLocationVsContainer;
            _v_ware_inventory_by_container = v_ware_inventory_by_container;
        }
 
        /// <summary>
        /// 获取库区信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("GetArea")]
        public async Task<List<WmsArea>> GetArea()
        {
            var areaList = await _wmsAreaRep.Where(n => n.AreaStatus == CommonStatus.ENABLE).ToListAsync();
            return areaList;
        }
 
        /// <summary>
        /// 根据库区获取排
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("GetPalceRowno")]
        public async Task<object> GetPalceRowno([FromQuery] GetPalceRownoInput input)
        {
            return await _wmsPlaceRep.Where(n => n.AreaId == input.Areaid).Select(n => n.RowNo).Distinct().ToListAsync();
        }
 
 
        /// <summary>
        /// 根据库区 排获取库位信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("GetPalceList")]
        public async Task<PalceInfoOtput> GetPalceList([FromQuery] GetPalceListInput input)
        {
            //var palceList = await _wmsPlaceRep.Where(p => p.AreaId == input.Areaid && p.RowNo == input.Rowno).ToListAsync();
            var palceList = await _wmsPlaceRep.DetachedEntities.AsQueryable().ToListAsync();
            var lvc = await _wareLocationVsContainer.DetachedEntities.AsQueryable().ToListAsync();
            foreach (var item in palceList)
            {
                if (lvc.Any(u => u.WareLocationCode == item.PlaceCode))
                {
                    item.PlaceStatus = PlaceStatus.CUNHUO;
                }
                else
                {
                    item.PlaceStatus = PlaceStatus.KONGXIAN;
                }
            }
            return new PalceInfoOtput()
            {
                countNum = palceList.Count,
                cunhuoNum = palceList.Where(n => n.PlaceStatus == Core.Enum.PlaceStatus.CUNHUO).Count(),
                emptyNum = palceList.Where(n => n.PlaceStatus == Core.Enum.PlaceStatus.KONGXIAN).Count(),
                emptyContainerNum = palceList.Where(p => p.EmptyContainer == YesOrNot.Y && p.PlaceStatus == Core.Enum.PlaceStatus.CUNHUO).Count(),
                materialNum = palceList.Where(p => p.EmptyContainer == YesOrNot.N && p.PlaceStatus == Core.Enum.PlaceStatus.CUNHUO).Count(),
                lockNum = palceList.Where(p => p.Islock == YesOrNot.Y).Count(),
                PalceDetails = palceList.Adapt<List<PalceDetail>>()
            };
        }
 
        /// <summary>
        /// 根据库位获取对应信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("GetMaterialDetail")]
        [UnifyResult(typeof(MaterialDetailsOutput))]
        public async Task<object> GetMaterialDetail([FromQuery] GetMaterialDetailInput input)
        {
            var palceModel = await _wmsPlaceRep.FirstOrDefaultAsync(p => p.Id == input.ID);
            if (palceModel == null) return XnRestfulResultProvider.RESTfulMesaage("库位信息不存在!");
            var MaterialStockList = await _v_ware_inventory_by_container.Where(p => p.WareLocationCode == palceModel.PlaceCode).ToListAsync();
            var model = new MaterialDetailsOutput()
            {
                PalceDetails = palceModel.Adapt<PalceDetail>()
            };
            if (MaterialStockList.Count>0) {
                model.Containercode = MaterialStockList.FirstOrDefault().WareContainerCode;
                model.WmsMaterialStocks = MaterialStockList.Adapt<List<MaterialDetails>>() ;
            }
            return XnRestfulResultProvider.RESTfulResult(model);
        }
 
        /// <summary>
        /// 修改库位锁定信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("UpdatePalceIslock")]
        [UnifyResult(typeof(object))]
        public async Task<object> UpdatePalceIslock([FromQuery] GetMaterialDetailInput input)
        {
            var palceModel = await _wmsPlaceRep.FirstOrDefaultAsync(p => p.Id == input.ID);
            if (palceModel == null) return XnRestfulResultProvider.RESTfulMesaage("库位信息不存在!");
            if (palceModel.Islock == YesOrNot.Y)
            {
                palceModel.Islock = YesOrNot.N;
            }
            else
            {
                palceModel.Islock = YesOrNot.Y;
            }
            await _wmsPlaceRep.UpdateAsync(palceModel);
            return XnRestfulResultProvider.RESTfulResult();
        }
    }
}