using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using HH.WCS.Mobox3.DSZSH.util;
|
using SqlSugar;
|
|
namespace HH.WCS.Mobox3.DSZSH.wms {
|
/// <summary>
|
/// [ 序列号生成 ] 帮助类
|
/// </summary>
|
public class SYSHelper {
|
private static object locker = new object();
|
/// <summary>
|
/// <c>"{prefix}-{DateTime.Now.ToString(dateFormat)}-{id.ToString().PadLeft(length,'0')}"</c>
|
/// </summary>
|
/// <param name="snType"></param>
|
/// <param name="prefix"></param>
|
/// <param name="dateFormat"></param>
|
/// <param name="length"></param>
|
/// <example><code><![CDATA[
|
/// private static string GenerateOrderNo(string snType, string prefix) {
|
/// //var id = SYSHelper.GetSerialNumber(snType, prefix);
|
/// //var date = DateTime.Now.ToString("yyMMdd");
|
/// //return $"{prefix}{date}-{id.ToString().PadLeft(4, '0')}";
|
/// return SYSHelper.GenerateSN(snType, prefix, "yyMMdd");
|
/// }
|
/// ]]></code></example>
|
/// <returns></returns>
|
public static string GenerateSN(string snType, string prefix, string dateFormat = "yyMM", int length = 4) {
|
var header = $"{prefix}{DateTime.Now.ToString(dateFormat)}-";
|
var res = GetSerialNumber(snType, header);
|
if (res == 0) return "";
|
else {
|
return $"{header}{res.ToString().PadLeft(length, '0')}";
|
}
|
}
|
//原框架方法,不会按日更新MAXID,现在设为私有隐藏,默认调用封装后的GenerateSN方法
|
private static int GetSerialNumber(string snType, string prefix) {
|
int result = 0;
|
lock (locker) {
|
var db = new SqlHelper<object>().GetInstance();
|
var sId = db.Queryable<OI_SYS_MAXID>().Where(a => a.CN_S_TYPE.Trim() == snType && a.CN_S_PRE.Trim() == prefix).First();
|
if (sId != null) {
|
//原框架逻辑(更接近Mobox的序列号生成方法)
|
sId.CN_N_MAX++;
|
if (db.Ado.ExecuteCommand($"update OI_SYS_MAXID set CN_N_MAX={sId.CN_N_MAX} " +
|
$"where CN_S_TYPE='{snType}' and CN_S_PRE='{prefix}' ") > 0) {
|
result = sId.CN_N_MAX;
|
}
|
//按日重置MAXID的逻辑(现不考虑使用)
|
//sId.CN_N_MAX = sId.CN_T_LAST < DateTime.Today ? 1 : sId.CN_N_MAX + 1;
|
//sId.CN_T_LAST = DateTime.Now;
|
//if (db.Ado.ExecuteCommand($"update OI_SYS_MAXID set CN_N_MAX={sId.CN_N_MAX}, CN_T_LAST='{sId.CN_T_LAST}' " +
|
// $"where CN_S_TYPE='{snType}' and CN_S_PRE='{prefix}' ") > 0) {
|
// result = sId.CN_N_MAX;
|
//}
|
}
|
else {
|
//插入表
|
sId = new OI_SYS_MAXID { CN_S_TYPE = snType, CN_S_PRE = prefix, CN_N_MAX = 1 };
|
result = db.Insertable(sId).ExecuteCommand() > 0 ? 1 : 0;
|
}
|
}
|
return result;
|
}
|
[SugarTable("dbo.OI_SYS_MAXID")]
|
public class OI_SYS_MAXID {
|
public string CN_S_TYPE { get; set; }
|
public string CN_S_PRE { get; set; }
|
public int CN_N_MAX { get; set; }
|
public DateTime CN_T_LAST { get; set; }
|
}
|
}
|
}
|
