修改

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
using Furion.DatabaseAccessor;
using Furion.DatabaseAccessor.Extensions;
using Furion.DependencyInjection;
using Furion.DynamicApiController;
using Furion.FriendlyException;
using iWare.Wms.Core;
using Mapster;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using System.Linq.Dynamic.Core;
 
namespace iWare.Wms.Application
{
    /// <summary>
    /// 物料信息
    /// </summary>
    [ApiDescriptionSettings("基础信息", Name = "WmsMaterial", Order = 100)]
    [Route("api/[Controller]")]
    public class WmsMaterialService : IWmsMaterialService, IDynamicApiController, ITransient
    {
        private readonly IRepository<WmsMaterial,MasterDbContextLocator> _wmsMaterialRep;
 
 
        public WmsMaterialService(
            IRepository<WmsMaterial,MasterDbContextLocator> wmsMaterialRep
        )
        {
            _wmsMaterialRep = wmsMaterialRep;
        }
 
        /// <summary>
        /// 分页查询物料信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("page")]
        public async Task<PageResult<WmsMaterialOutput>> Page([FromQuery] WmsMaterialSearch input)
        {
            var wmsMaterials = await _wmsMaterialRep.DetachedEntities
                                     .Where(!string.IsNullOrEmpty(input.Materialname), u => EF.Functions.Like(u.MaterialName, $"%{input.Materialname.Trim()}%"))
                                     .Where(!string.IsNullOrEmpty(input.Materialno), u => EF.Functions.Like(u.MaterialNo, $"%{input.Materialno.Trim()}%"))
                                     .Where(!string.IsNullOrEmpty(input.Materialbatch), u => EF.Functions.Like(u.MaterialBatch, $"%{input.Materialbatch.Trim()}%"))
                                     .Where(input.Inspectionmethod != null, u => u.InspectionMethod == input.Inspectionmethod)
                                     .Where(input.Materialtype != null, u => u.MaterialType == input.Materialtype)
                                     .Where(!string.IsNullOrEmpty(input.Materialspec), u => u.MaterialSpec == input.Materialspec)
                                     .Where(input.Unittype != null, u => u.UnitType == input.Unittype)
                                     .Where(input.Unitno != null, u => u.UnitNo == input.Unitno)
                                     .Where(input.Keymaterials != null, u => u.Keymaterials == input.Keymaterials)
                                     .OrderBy(PageInputOrder.OrderBuilder<WmsMaterialSearch>(input))
                                     .ProjectToType<WmsMaterialOutput>()
                                     .ToADPagedListAsync(input.PageNo, input.PageSize);
            return wmsMaterials;
        }
 
        /// <summary>
        /// 增加物料信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("add")]
        public async Task Add(AddWmsMaterialInput input)
        {
            var isExit = await _wmsMaterialRep.AnyAsync(n => n.MaterialNo==input.Materialno);
            if (isExit) throw Oops.Oh("存在的相同的物料编号！");
            var wmsMaterial = input.Adapt<WmsMaterial>();
            await _wmsMaterialRep.InsertAsync(wmsMaterial);
        }
 
        /// <summary>
        /// 删除物料信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("delete")]
        public async Task Delete(DeleteWmsMaterialInput input)
        {
            var wmsMaterial = await _wmsMaterialRep.FirstOrDefaultAsync(u => u.Id == input.Id);
            await _wmsMaterialRep.DeleteAsync(wmsMaterial);
        }
 
        /// <summary>
        /// 更新物料信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost("edit")]
        public async Task Update(UpdateWmsMaterialInput input)
        {
            var isExist = await _wmsMaterialRep.AnyAsync(u => u.Id == input.Id, false);
            if (!isExist) throw Oops.Oh(ErrorCode.D3000);
 
            var wmsMaterial = input.Adapt<WmsMaterial>();
            await _wmsMaterialRep.UpdateAsync(wmsMaterial,ignoreNullValues:false);
        }
 
        /// <summary>
        /// 获取物料信息
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("detail")]
        public async Task<WmsMaterialOutput> Get([FromQuery] QueryeWmsMaterialInput input)
        {
            return (await _wmsMaterialRep.DetachedEntities.FirstOrDefaultAsync(u => u.Id == input.Id)).Adapt<WmsMaterialOutput>();
        }
 
        /// <summary>
        /// 获取物料信息列表
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("list")]
        public async Task<dynamic> List([FromQuery] WmsMaterialInput input)
        {
            //return await _wmsMaterialRep.DetachedEntities.ProjectToType<WmsMaterialOutput>().ToListAsync();
            var list = await _wmsMaterialRep.DetachedEntities.ToListAsync();
            return list.Select(e => new { Code = e.MaterialNo, Name = e.MaterialName });
        }
    }
}