LqPaymentMethodService.cs
17.9 KB
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
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
using System;
using System.Linq;
using System.Threading.Tasks;
using Mapster;
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json;
using NCC.Common.Core.Manager;
using NCC.Common.Enum;
using NCC.Common.Filter;
using NCC.Dependency;
using NCC.DynamicApiController;
using NCC.Extend.Entitys.Dto.LqPaymentMethod;
using NCC.Extend.Entitys.Enum;
using NCC.Extend.Entitys.lq_payment_method;
using NCC.Extend.Interfaces.BusinessOperationLog;
using NCC.Extend.Interfaces.LqPaymentMethod;
using NCC.FriendlyException;
using SqlSugar;
using Yitter.IdGenerator;
namespace NCC.Extend.LqPaymentMethod
{
/// <summary>
/// 开单支付方式配置服务
/// </summary>
[ApiDescriptionSettings(Tag = "Extend", Name = "LqPaymentMethod", Order = 201)]
[Route("api/Extend/[controller]")]
public class LqPaymentMethodService : ILqPaymentMethodService, IDynamicApiController, ITransient
{
private const string BizLogModule = "开单管理";
private readonly ISqlSugarRepository<LqPaymentMethodEntity> _repository;
private readonly SqlSugarScope _db;
private readonly IUserManager _userManager;
private readonly IBusinessOperationLogService _businessOperationLogService;
public LqPaymentMethodService(
ISqlSugarRepository<LqPaymentMethodEntity> repository,
IUserManager userManager,
IBusinessOperationLogService businessOperationLogService)
{
_repository = repository;
_db = _repository.Context;
_userManager = userManager;
_businessOperationLogService = businessOperationLogService;
}
/// <summary>
/// 获取支付方式详情
/// </summary>
/// <remarks>
/// 返回未删除的支付方式详情,供管理页编辑回显。
///
/// 参数说明:
/// - id: 支付方式主键
/// </remarks>
/// <param name="id">主键</param>
/// <returns>支付方式详情</returns>
/// <response code="200">查询成功</response>
/// <response code="400">记录不存在</response>
/// <response code="500">服务器内部错误</response>
[HttpGet("{id}")]
public async Task<dynamic> GetInfo(string id)
{
var entity = await ApplyNotDeletedFilter(_db.Queryable<LqPaymentMethodEntity>())
.FirstAsync(p => p.Id == id);
_ = entity ?? throw NCCException.Oh(ErrorCode.COM1005);
return MapInfo(entity);
}
/// <summary>
/// 获取支付方式管理列表
/// </summary>
/// <remarks>
/// 分页查询支付方式配置。可见已停用项,排除已删除项。
///
/// 示例请求:
/// ```
/// GET /api/Extend/LqPaymentMethod/List?currentPage=1&pageSize=20&keyword=微信&enabledMark=1
/// ```
///
/// 参数说明:
/// - keyword: 按名称或备注模糊搜索
/// - enabledMark: 启用状态(1-启用,0-停用;不传则不过滤)
/// - currentPage: 当前页码
/// - pageSize: 每页条数
/// </remarks>
/// <param name="input">查询参数</param>
/// <returns>分页列表</returns>
/// <response code="200">查询成功</response>
/// <response code="500">服务器内部错误</response>
[HttpGet("List")]
public async Task<dynamic> GetList([FromQuery] LqPaymentMethodListQueryInput input)
{
input ??= new LqPaymentMethodListQueryInput();
var orderBy = string.IsNullOrWhiteSpace(input.sidx)
? "sortCode asc"
: input.sidx + " " + input.sort;
var data = await BuildListQuery(input)
.Select(it => new LqPaymentMethodListOutput
{
id = it.Id,
name = it.Name,
sortCode = it.SortCode,
enabledMark = it.EnabledMark,
remark = it.Remark,
createTime = it.CreateTime,
lastModifyTime = it.LastModifyTime,
})
.MergeTable()
.OrderBy(orderBy)
.ToPagedListAsync(input.currentPage, input.pageSize);
return PageResult<LqPaymentMethodListOutput>.SqlSugarPageResult(data);
}
/// <summary>
/// 获取支付方式下拉选项
/// </summary>
/// <remarks>
/// 供开单/筛选下拉使用:仅返回未删除且启用的项,按 SortCode 排序。
///
/// **重要**:历史开单 `lq_kd_kdjlb.fkfs` 存的是中文名称,因此 `id` / `fullName` / `name` 均为支付方式名称,
/// 前端可直接 `:value="item.id"` 绑定 fkfs。`configId` 为配置表主键,仅供管理场景参考。
///
/// 返回示例:
/// ```json
/// {
/// "list": [
/// { "id": "微信", "fullName": "微信", "name": "微信", "configId": "1980080609000000001" }
/// ]
/// }
/// ```
/// </remarks>
/// <returns>下拉列表</returns>
/// <response code="200">查询成功</response>
/// <response code="500">服务器内部错误</response>
[HttpGet("Selector")]
public async Task<dynamic> GetSelector()
{
var list = await ApplyNotDeletedFilter(_db.Queryable<LqPaymentMethodEntity>())
.Where(p => p.EnabledMark == null || p.EnabledMark == (int)PaymentMethodEnabledEnum.启用)
.OrderBy(p => p.SortCode)
.Select(p => new
{
id = p.Name,
fullName = p.Name,
name = p.Name,
configId = p.Id,
})
.ToListAsync();
return new { list };
}
/// <summary>
/// 新增支付方式
/// </summary>
/// <remarks>
/// 示例请求:
/// ```json
/// {
/// "name": "星驿付",
/// "sortCode": 10,
/// "remark": "第三方支付"
/// }
/// ```
///
/// 参数说明:
/// - name: 支付方式名称(未删除范围内唯一)
/// - sortCode: 排序(可选,不传则追加到末尾)
/// - remark: 备注(可选)
/// </remarks>
/// <param name="input">新增参数</param>
/// <returns></returns>
/// <response code="200">新增成功</response>
/// <response code="400">名称重复或参数无效</response>
/// <response code="500">服务器内部错误</response>
[HttpPost("")]
public async Task Create([FromBody] LqPaymentMethodCrInput input)
{
input ??= new LqPaymentMethodCrInput();
var name = NormalizeName(input.name);
if (string.IsNullOrEmpty(name))
{
throw NCCException.Oh("支付方式名称不能为空");
}
await EnsureNameUniqueAsync(name, null);
var userInfo = await _userManager.GetUserInfo();
var now = DateTime.Now;
var entity = new LqPaymentMethodEntity
{
Id = YitIdHelper.NextId().ToString(),
Name = name,
SortCode = input.sortCode ?? await GetNextSortCodeAsync(),
EnabledMark = (int)PaymentMethodEnabledEnum.启用,
DeleteMark = null,
Remark = NormalizeOptional(input.remark),
CreateTime = now,
CreateUserId = userInfo?.userId,
LastModifyTime = now,
LastModifyUserId = userInfo?.userId,
LastModifyUserName = userInfo?.userName,
};
var isOk = await _db.Insertable(entity).ExecuteCommandAsync();
if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1000);
await TryWriteBusinessLogAsync(BizLogModule, "新增支付方式", "lq_payment_method", entity.Id,
$"新增支付方式:{entity.Name}",
JsonConvert.SerializeObject(new { after = new { entity.Id, entity.Name, entity.SortCode } }));
}
/// <summary>
/// 修改支付方式
/// </summary>
/// <remarks>
/// 示例请求:
/// ```json
/// {
/// "name": "微信支付",
/// "sortCode": 1,
/// "remark": ""
/// }
/// ```
///
/// 参数说明:
/// - name: 支付方式名称(未删除范围内唯一)
/// - sortCode: 排序
/// - remark: 备注
///
/// 注意:启用/停用请调用 SetEnabled 接口,本接口不修改启用状态。
/// </remarks>
/// <param name="id">主键</param>
/// <param name="input">修改参数</param>
/// <returns></returns>
/// <response code="200">修改成功</response>
/// <response code="400">名称重复或记录不存在</response>
/// <response code="500">服务器内部错误</response>
[HttpPut("{id}")]
public async Task Update(string id, [FromBody] LqPaymentMethodUpInput input)
{
input ??= new LqPaymentMethodUpInput();
var before = await ApplyNotDeletedFilter(_db.Queryable<LqPaymentMethodEntity>())
.FirstAsync(p => p.Id == id);
_ = before ?? throw NCCException.Oh(ErrorCode.COM1005);
var name = NormalizeName(input.name);
if (string.IsNullOrEmpty(name))
{
throw NCCException.Oh("支付方式名称不能为空");
}
await EnsureNameUniqueAsync(name, id);
var userInfo = await _userManager.GetUserInfo();
var now = DateTime.Now;
var beforeSnapshot = new { before.Name, before.SortCode, before.Remark };
before.Name = name;
before.SortCode = input.sortCode ?? before.SortCode;
before.Remark = NormalizeOptional(input.remark);
before.LastModifyTime = now;
before.LastModifyUserId = userInfo?.userId;
before.LastModifyUserName = userInfo?.userName;
var isOk = await _db.Updateable(before)
.IgnoreColumns(ignoreAllNullColumns: true)
.IgnoreColumns(it => new { it.EnabledMark, it.DeleteMark, it.DeleteTime, it.DeleteUserId, it.CreateTime, it.CreateUserId })
.ExecuteCommandAsync();
if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1001);
await TryWriteBusinessLogAsync(BizLogModule, "修改支付方式", "lq_payment_method", id,
$"修改支付方式:{before.Name}",
JsonConvert.SerializeObject(new
{
before = beforeSnapshot,
after = new { before.Name, before.SortCode, before.Remark },
}));
}
/// <summary>
/// 删除支付方式(标记删除)
/// </summary>
/// <remarks>
/// 逻辑删除,禁止物理删除。历史开单 fkfs 仍保留原中文名称,不受本操作影响。
/// </remarks>
/// <param name="id">主键</param>
/// <returns></returns>
/// <response code="200">删除成功</response>
/// <response code="400">记录不存在</response>
/// <response code="500">服务器内部错误</response>
[HttpDelete("{id}")]
public async Task Delete(string id)
{
var entity = await ApplyNotDeletedFilter(_db.Queryable<LqPaymentMethodEntity>())
.FirstAsync(p => p.Id == id);
_ = entity ?? throw NCCException.Oh(ErrorCode.COM1005);
var userInfo = await _userManager.GetUserInfo();
var userId = userInfo?.userId;
var userName = userInfo?.userName;
var now = DateTime.Now;
var isOk = await _db.Updateable<LqPaymentMethodEntity>()
.SetColumns(it => new LqPaymentMethodEntity
{
DeleteMark = 1,
DeleteTime = now,
DeleteUserId = userId,
LastModifyTime = now,
LastModifyUserId = userId,
LastModifyUserName = userName,
})
.Where(d => d.Id == id)
.ExecuteCommandAsync();
if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1002);
await TryWriteBusinessLogAsync(BizLogModule, "删除支付方式", "lq_payment_method", id,
$"标记删除支付方式:{entity.Name}",
JsonConvert.SerializeObject(new { before = new { entity.Id, entity.Name } }));
}
/// <summary>
/// 设置支付方式启用/停用状态
/// </summary>
/// <remarks>
/// 示例请求:
/// ```json
/// {
/// "enabledMark": 0
/// }
/// ```
///
/// 参数说明:
/// - enabledMark: 目标状态(1-启用,0-停用)
/// </remarks>
/// <param name="id">主键</param>
/// <param name="input">目标状态参数</param>
/// <returns></returns>
/// <response code="200">设置成功</response>
/// <response code="400">参数错误或记录不存在</response>
/// <response code="500">服务器内部错误</response>
[HttpPut("{id}/Actions/SetEnabled")]
public async Task SetEnabled(string id, [FromBody] LqPaymentMethodSetEnabledInput input)
{
if (input.enabledMark != (int)PaymentMethodEnabledEnum.启用
&& input.enabledMark != (int)PaymentMethodEnabledEnum.停用)
{
throw NCCException.Oh("启用状态无效");
}
var entity = await ApplyNotDeletedFilter(_db.Queryable<LqPaymentMethodEntity>())
.FirstAsync(p => p.Id == id);
_ = entity ?? throw NCCException.Oh(ErrorCode.COM1005);
var beforeEnabledMark = entity.EnabledMark;
if ((beforeEnabledMark ?? (int)PaymentMethodEnabledEnum.启用) == input.enabledMark)
{
return;
}
var userInfo = await _userManager.GetUserInfo();
var userId = userInfo?.userId;
var userName = userInfo?.userName;
var now = DateTime.Now;
var isOk = await _db.Updateable<LqPaymentMethodEntity>()
.SetColumns(it => new LqPaymentMethodEntity
{
EnabledMark = input.enabledMark,
LastModifyTime = now,
LastModifyUserId = userId,
LastModifyUserName = userName,
})
.Where(d => d.Id == id)
.ExecuteCommandAsync();
if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1001);
var actionCode = input.enabledMark == (int)PaymentMethodEnabledEnum.启用 ? "启用支付方式" : "停用支付方式";
await TryWriteBusinessLogAsync(BizLogModule, actionCode, "lq_payment_method", id,
$"{actionCode}:{entity.Name}",
JsonConvert.SerializeObject(new
{
before = new { enabledMark = beforeEnabledMark },
after = new { enabledMark = input.enabledMark },
}));
}
private ISugarQueryable<LqPaymentMethodEntity> BuildListQuery(LqPaymentMethodListQueryInput input)
{
var keyword = string.IsNullOrWhiteSpace(input.keyword) ? null : input.keyword.Trim();
return ApplyNotDeletedFilter(_db.Queryable<LqPaymentMethodEntity>())
.WhereIF(!string.IsNullOrEmpty(keyword),
p => p.Name.Contains(keyword) || p.Remark.Contains(keyword))
.WhereIF(input.enabledMark == (int)PaymentMethodEnabledEnum.启用,
p => p.EnabledMark == null || p.EnabledMark == (int)PaymentMethodEnabledEnum.启用)
.WhereIF(input.enabledMark == (int)PaymentMethodEnabledEnum.停用,
p => p.EnabledMark == (int)PaymentMethodEnabledEnum.停用);
}
private static ISugarQueryable<LqPaymentMethodEntity> ApplyNotDeletedFilter(ISugarQueryable<LqPaymentMethodEntity> query)
{
return query.Where(it => it.DeleteMark == null || it.DeleteMark == 0);
}
private async Task EnsureNameUniqueAsync(string name, string excludeId)
{
var exists = await ApplyNotDeletedFilter(_db.Queryable<LqPaymentMethodEntity>())
.WhereIF(!string.IsNullOrEmpty(excludeId), p => p.Id != excludeId)
.AnyAsync(p => p.Name == name);
if (exists)
{
throw NCCException.Oh("支付方式名称已存在");
}
}
private async Task<int> GetNextSortCodeAsync()
{
var maxSort = await ApplyNotDeletedFilter(_db.Queryable<LqPaymentMethodEntity>())
.MaxAsync(p => p.SortCode);
return maxSort + 1;
}
private static string NormalizeName(string name) =>
string.IsNullOrWhiteSpace(name) ? null : name.Trim();
private static string NormalizeOptional(string value) =>
string.IsNullOrWhiteSpace(value) ? null : value.Trim();
private static LqPaymentMethodInfoOutput MapInfo(LqPaymentMethodEntity entity) =>
entity.Adapt<LqPaymentMethodInfoOutput>();
private async Task TryWriteBusinessLogAsync(string moduleCode, string actionCode, string bizType, string bizId, string summary, string detailJson = null)
{
try
{
await _businessOperationLogService.WriteAsync(moduleCode, actionCode, bizType, bizId, summary, detailJson);
}
catch (Exception)
{
}
}
}
}