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)
{
}
}
}
}