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 { /// /// 开单支付方式配置服务 /// [ApiDescriptionSettings(Tag = "Extend", Name = "LqPaymentMethod", Order = 201)] [Route("api/Extend/[controller]")] public class LqPaymentMethodService : ILqPaymentMethodService, IDynamicApiController, ITransient { private const string BizLogModule = "开单管理"; private readonly ISqlSugarRepository _repository; private readonly SqlSugarScope _db; private readonly IUserManager _userManager; private readonly IBusinessOperationLogService _businessOperationLogService; public LqPaymentMethodService( ISqlSugarRepository repository, IUserManager userManager, IBusinessOperationLogService businessOperationLogService) { _repository = repository; _db = _repository.Context; _userManager = userManager; _businessOperationLogService = businessOperationLogService; } /// /// 获取支付方式详情 /// /// /// 返回未删除的支付方式详情,供管理页编辑回显。 /// /// 参数说明: /// - id: 支付方式主键 /// /// 主键 /// 支付方式详情 /// 查询成功 /// 记录不存在 /// 服务器内部错误 [HttpGet("{id}")] public async Task GetInfo(string id) { var entity = await ApplyNotDeletedFilter(_db.Queryable()) .FirstAsync(p => p.Id == id); _ = entity ?? throw NCCException.Oh(ErrorCode.COM1005); return MapInfo(entity); } /// /// 获取支付方式管理列表 /// /// /// 分页查询支付方式配置。可见已停用项,排除已删除项。 /// /// 示例请求: /// ``` /// GET /api/Extend/LqPaymentMethod/List?currentPage=1&pageSize=20&keyword=微信&enabledMark=1 /// ``` /// /// 参数说明: /// - keyword: 按名称或备注模糊搜索 /// - enabledMark: 启用状态(1-启用,0-停用;不传则不过滤) /// - currentPage: 当前页码 /// - pageSize: 每页条数 /// /// 查询参数 /// 分页列表 /// 查询成功 /// 服务器内部错误 [HttpGet("List")] public async Task 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.SqlSugarPageResult(data); } /// /// 获取支付方式下拉选项 /// /// /// 供开单/筛选下拉使用:仅返回未删除且启用的项,按 SortCode 排序。 /// /// **重要**:历史开单 `lq_kd_kdjlb.fkfs` 存的是中文名称,因此 `id` / `fullName` / `name` 均为支付方式名称, /// 前端可直接 `:value="item.id"` 绑定 fkfs。`configId` 为配置表主键,仅供管理场景参考。 /// /// 返回示例: /// ```json /// { /// "list": [ /// { "id": "微信", "fullName": "微信", "name": "微信", "configId": "1980080609000000001" } /// ] /// } /// ``` /// /// 下拉列表 /// 查询成功 /// 服务器内部错误 [HttpGet("Selector")] public async Task GetSelector() { var list = await ApplyNotDeletedFilter(_db.Queryable()) .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 }; } /// /// 新增支付方式 /// /// /// 示例请求: /// ```json /// { /// "name": "星驿付", /// "sortCode": 10, /// "remark": "第三方支付" /// } /// ``` /// /// 参数说明: /// - name: 支付方式名称(未删除范围内唯一) /// - sortCode: 排序(可选,不传则追加到末尾) /// - remark: 备注(可选) /// /// 新增参数 /// /// 新增成功 /// 名称重复或参数无效 /// 服务器内部错误 [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 } })); } /// /// 修改支付方式 /// /// /// 示例请求: /// ```json /// { /// "name": "微信支付", /// "sortCode": 1, /// "remark": "" /// } /// ``` /// /// 参数说明: /// - name: 支付方式名称(未删除范围内唯一) /// - sortCode: 排序 /// - remark: 备注 /// /// 注意:启用/停用请调用 SetEnabled 接口,本接口不修改启用状态。 /// /// 主键 /// 修改参数 /// /// 修改成功 /// 名称重复或记录不存在 /// 服务器内部错误 [HttpPut("{id}")] public async Task Update(string id, [FromBody] LqPaymentMethodUpInput input) { input ??= new LqPaymentMethodUpInput(); var before = await ApplyNotDeletedFilter(_db.Queryable()) .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 }, })); } /// /// 删除支付方式(标记删除) /// /// /// 逻辑删除,禁止物理删除。历史开单 fkfs 仍保留原中文名称,不受本操作影响。 /// /// 主键 /// /// 删除成功 /// 记录不存在 /// 服务器内部错误 [HttpDelete("{id}")] public async Task Delete(string id) { var entity = await ApplyNotDeletedFilter(_db.Queryable()) .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() .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 } })); } /// /// 设置支付方式启用/停用状态 /// /// /// 示例请求: /// ```json /// { /// "enabledMark": 0 /// } /// ``` /// /// 参数说明: /// - enabledMark: 目标状态(1-启用,0-停用) /// /// 主键 /// 目标状态参数 /// /// 设置成功 /// 参数错误或记录不存在 /// 服务器内部错误 [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()) .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() .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 BuildListQuery(LqPaymentMethodListQueryInput input) { var keyword = string.IsNullOrWhiteSpace(input.keyword) ? null : input.keyword.Trim(); return ApplyNotDeletedFilter(_db.Queryable()) .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 ApplyNotDeletedFilter(ISugarQueryable 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()) .WhereIF(!string.IsNullOrEmpty(excludeId), p => p.Id != excludeId) .AnyAsync(p => p.Name == name); if (exists) { throw NCCException.Oh("支付方式名称已存在"); } } private async Task GetNextSortCodeAsync() { var maxSort = await ApplyNotDeletedFilter(_db.Queryable()) .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(); 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) { } } } }