WMSlite/WmsLite.Api/Services/OrderNumberGenerator.cs

115 lines
4.0 KiB
C#
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

using System.Globalization;
using SqlSugar;
using WmsLite.Api.Common;
using WmsLite.Api.Services.Interfaces;
namespace WmsLite.Api.Services;
public class OrderNumberGenerator : IOrderNumberGenerator
{
private readonly ISqlSugarClient _db;
public OrderNumberGenerator(ISqlSugarClient db)
{
_db = db;
}
public async Task<string> NextInboundOrderNoAsync(string tenantId, string ownerCode, CancellationToken cancellationToken = default)
=> await NextOrderNoAsync<Models.InboundOrder>(tenantId, ownerCode, "IN", "入库单");
public async Task<string> NextOutboundOrderNoAsync(string tenantId, string ownerCode, CancellationToken cancellationToken = default)
=> await NextOrderNoAsync<Models.OutboundOrder>(tenantId, ownerCode, "OUT", "出库单");
private async Task<string> NextOrderNoAsync<TOrder>(string tenantId, string ownerCode, string prefix, string displayName)
where TOrder : Models.BaseEntity, new()
{
var tenant = tenantId.Trim();
var owner = ownerCode.Trim();
var datePart = DateTime.Now.ToString("yyyyMMdd", CultureInfo.InvariantCulture);
const int maxAttempts = 5;
for (var attempt = 0; attempt < maxAttempts; attempt++)
{
var seq = await AllocateSequenceAsync(tenant, owner, prefix, datePart);
var no = $"{prefix}{datePart}{seq.ToString("D5", CultureInfo.InvariantCulture)}";
var exists = await _db.Queryable<TOrder>()
.Where(x => !x.IsDeleted && x.TenantId == tenant && x.OwnerCode == owner)
.Where("order_no = @orderNo", new { orderNo = no })
.AnyAsync();
if (!exists)
{
return no;
}
}
throw new BusinessException($"生成唯一{displayName}单号失败,请重试。");
}
private async Task<int> AllocateSequenceAsync(string tenantId, string ownerCode, string prefix, string dateYyyyMmDd)
{
try
{
_db.Ado.BeginTran();
var row = await _db.Ado.SqlQuerySingleAsync<OrderNoCounterRow>(
"""
SELECT id, last_seq AS LastSeq
FROM order_no_counter
WHERE tenant_id = @tenant AND owner_code = @owner AND prefix = @prefix AND date_yyyymmdd = @date
FOR UPDATE
""",
new { tenant = tenantId, owner = ownerCode, prefix, date = dateYyyyMmDd });
int next;
if (row is null)
{
next = 1;
await _db.Ado.ExecuteCommandAsync(
"""
INSERT INTO order_no_counter (id, tenant_id, owner_code, prefix, date_yyyymmdd, last_seq, create_time, update_time)
VALUES (@id, @tenant, @owner, @prefix, @date, @seq, NOW(), NOW())
""",
new
{
id = SnowFlakeSingle.Instance.NextId(),
tenant = tenantId,
owner = ownerCode,
prefix,
date = dateYyyyMmDd,
seq = next,
});
}
else
{
next = row.LastSeq + 1;
if (next > 99999)
{
throw new BusinessException("当日入库单单号序号已超过最大值(99999),请稍后重试或联系管理员。");
}
await _db.Ado.ExecuteCommandAsync(
"""
UPDATE order_no_counter SET last_seq = @seq, update_time = NOW()
WHERE id = @id
""",
new { id = row.Id, seq = next });
}
_db.Ado.CommitTran();
return next;
}
catch
{
_db.Ado.RollbackTran();
throw;
}
}
private sealed class OrderNoCounterRow
{
public long Id { get; set; }
public int LastSeq { get; set; }
}
}