222

schangxiang@126.com

2024-12-14 3eabfd8dfa2574efbe8ce8d4a64862c16ad04823

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
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
using Admin.NET.Core.Service;
using Admin.NET.Application.Entity;
using Microsoft.AspNetCore.Http;
using System.Data;
using System.Web;
using System.Text;
namespace Admin.NET.Application;
/// <summary>
/// 操作履历服务
/// </summary>
[ApiDescriptionSettings(ApplicationConst.ReportCenterGroupName, Order = 100)]
public class WmsLogActionService : IDynamicApiController, ITransient
{
    private readonly SqlSugarRepository<WmsLogAction> _rep;
    public WmsLogActionService(SqlSugarRepository<WmsLogAction> rep)
    {
        _rep = rep;
    }
 
    /// <summary>
    /// 分页查询操作履历
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpPost]
    [ApiDescriptionSettings(Name = "Page")]
    [Description("WmsLogAction/Page")]
    public async Task<SqlSugarPagedList<WmsLogActionOutput>> Page(WmsLogActionInput input)
    {
        var query = CommonPageFilter(input);
        return await query.OrderBuilder(input, "", "Id").ToPagedListAsync(input.Page, input.PageSize);
    }
 
    /// <summary>
    /// 不分页查询操作履历
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpGet]
    [ApiDescriptionSettings(Name = "List")]
    [Description("WmsLogAction/List")]
    public async Task<List<WmsLogActionOutput>> List([FromQuery] WmsLogActionInput input)
    {
        var query = CommonPageFilter(input);
        return await query.OrderBuilder(input, "", "Id").Select<WmsLogActionOutput>().ToListAsync();
    }
 
    /// <summary>
    /// 增加操作履历
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpPost]
    [ApiDescriptionSettings(Name = "Add")]
    [Description("WmsLogAction/Add")]
    public async Task<long> Add(AddWmsLogActionInput input)
    {
        var entity = input.Adapt<WmsLogAction>();
 
        //重复性验证
        await CheckExist(entity);
 
        await _rep.InsertAsync(entity);
        return entity.Id;
    }
 
    /// <summary>
    /// 删除操作履历
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpPost]
    [ApiDescriptionSettings(Name = "Delete")]
    [Description("WmsLogAction/Delete")]
    public async Task Delete(DeleteWmsLogActionInput input)
    {
        var entity = await _rep.GetFirstAsync(u => u.Id == input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002);
        //await _rep.FakeDeleteAsync(entity);   //假删除
        await _rep.DeleteAsync(entity);   //真删除
    }
 
    /// <summary>
    /// 更新操作履历
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpPost]
    [ApiDescriptionSettings(Name = "Update")]
    [Description("WmsLogAction/Update")]
    public async Task Update(UpdateWmsLogActionInput input)
    {
        var entity = input.Adapt<WmsLogAction>();
 
        //重复性验证
        await CheckExist(entity,true);
 
        await _rep.AsUpdateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync();
    }
 
    /// <summary>
    /// 获取操作履历
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpGet]
    [ApiDescriptionSettings(Name = "Detail")]
    [Description("WmsLogAction/Detail")]
    public async Task<WmsLogAction> Detail([FromQuery] QueryByIdWmsLogActionInput input)
    {
        return await _rep.GetFirstAsync(u => u.Id == input.Id);
    }
 
 
 
 
 
 
    #region 私有方法
 
    /// <summary>
    /// 公共查询操作履历条件
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    private ISugarQueryable<WmsLogActionOutput> CommonPageFilter(WmsLogActionInput input)
    {
        var query = _rep.AsQueryable()
            .WhereIF(!string.IsNullOrWhiteSpace(input.SearchKey), u =>
                u.Title.Contains(input.SearchKey.Trim())
                || u.Remarks.Contains(input.SearchKey.Trim())
                || u.CreateUserName.Contains(input.SearchKey.Trim())
                || u.UpdateUserName.Contains(input.SearchKey.Trim())
            )
            .WhereIF(!string.IsNullOrWhiteSpace(input.Title), u => u.Title.Contains(input.Title.Trim()))
            .WhereIF(input.DbId>0, u => u.DbId == input.DbId)
            .Select<WmsLogActionOutput>();
        return query;
       }
 
        /// <summary>
        /// 重复性验证
        /// </summary>
        /// <param name="input">验证对象</param>
        /// <param name="isEdit">是否是编辑</param>
        /// <returns></returns>
        private async Task CheckExist( WmsLogAction input,bool isEdit=false)
        {
           
 
 
            //没有配置组合校验，不需要验重
 
           
            //没有配置单独校验，不需要验重
       }
 
       /// <summary>
        /// 根据组合校验和单独校验验证数据是否已存在-导入时验证
        /// </summary>
        /// <param name="inputs"></param>
        /// <returns></returns>
        private async Task CheckExisitForImport(List<WmsLogAction> inputs)
        { 
            if (inputs?.Count <= 0)
            {
                throw Oops.Oh($"导入数据不能为空");
            }
            //根据组合校验验证表格中中是否已存在相同数据  
                      
 
 
 
 
 
 
          
           //根据单独校验验证表格中中是否已存在相同数据  
           
           
           
        }
     #endregion
 
}