From b7308bba3d7ffad271ce7fc7a93c8c45d76be87d Mon Sep 17 00:00:00 2001 From: 杨前锦 <1010338399@qq.com> Date: 星期五, 13 六月 2025 17:21:03 +0800 Subject: [PATCH] 优化印尼佳通-硫化胚胎出入库逻辑策略优化 --- HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/SYSHelper.cs | 44 ++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 44 insertions(+), 0 deletions(-) diff --git a/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/SYSHelper.cs b/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/SYSHelper.cs new file mode 100644 index 0000000..46fa3ee --- /dev/null +++ b/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/SYSHelper.cs @@ -0,0 +1,44 @@ +锘縰sing HH.WCS.Mobox3.FJJT.util; +using SqlSugar; +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace HH.WCS.Mobox3.FJJT.wms +{ + internal class SYSHelper + { + private static object locker = new object(); + internal 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) { + 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; + } + } + else { + //鎻掑叆琛�+ sId = new OI_SYS_MAXID { CN_S_TYPE = snType, CN_S_PRE = prefix, CN_N_MAX = 1 }; + result = db.Insertable<OI_SYS_MAXID>(sId).ExecuteCommand() > 0 ? 1 : 0; + + } + } + return result; + } + + [SugarTable("OI_SYS_MAXID")] + public class OI_SYS_MAXID + { + public string CN_S_APP_TYPE { get; set; } = "MOBOX"; + public string CN_S_TYPE { get; set; } + public string CN_S_PRE { get; set; } + public int CN_N_MAX { get; set; } + } + } +} -- Gitblit v1.9.1