From 7e4e747ae508578c15fc93a40a9cb0de289706bd Mon Sep 17 00:00:00 2001
From: pan <antony1029@163.com>
Date: 星期三, 26 十一月 2025 00:45:07 +0800
Subject: [PATCH] 提交
---
项目代码/WMS无仓储版/WIDESEA_WMSServer/WIDESEA_BasicService/DailySequenceService.cs | 52 ++++++++++++++++++++++++++++++++++------------------
1 files changed, 34 insertions(+), 18 deletions(-)
diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS\346\227\240\344\273\223\345\202\250\347\211\210/WIDESEA_WMSServer/WIDESEA_BasicService/DailySequenceService.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS\346\227\240\344\273\223\345\202\250\347\211\210/WIDESEA_WMSServer/WIDESEA_BasicService/DailySequenceService.cs"
index 6d287d8..73c8b3b 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS\346\227\240\344\273\223\345\202\250\347\211\210/WIDESEA_WMSServer/WIDESEA_BasicService/DailySequenceService.cs"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS\346\227\240\344\273\223\345\202\250\347\211\210/WIDESEA_WMSServer/WIDESEA_BasicService/DailySequenceService.cs"
@@ -10,6 +10,7 @@
using System.Threading.Tasks;
using WIDESEA_Core.BaseRepository;
using WIDESEA_Core.BaseServices;
+using WIDESEA_Core.Seed;
using WIDESEA_IBasicService;
using WIDESEA_Model.Models;
using WIDESEA_Model.Models.Basic;
@@ -193,28 +194,43 @@
private async Task UpdateSequenceInDatabase(DateTime date, string sequenceKey, int value)
{
- var sequence = await Repository.Db.Queryable<DT_DailySequence>()
- .Where(x => x.SequenceDate == date && x.SequenceKey == sequenceKey)
- .FirstAsync();
-
- if (sequence != null)
+ try
{
- sequence.CurrentValue = value;
-
- await Repository.Db.Updateable(sequence).ExecuteCommandAsync();
- }
- else
- {
- // 濡傛灉鏁版嵁搴撹褰曚笉瀛樺湪锛屽垯鍒涘缓
- sequence = new DT_DailySequence
+ using SqlSugarClient sugarClient = new SqlSugarClient(new ConnectionConfig
{
- SequenceDate = date,
- SequenceKey = sequenceKey,
- CurrentValue = value,
+ IsAutoCloseConnection = true,
+ DbType = DbType.SqlServer,
+ ConnectionString = DBContext.ConnectionString
+ });
+ var result = await sugarClient.Updateable<DT_DailySequence>()
+ .SetColumns(it => new DT_DailySequence()
+ {
+ CurrentValue = value,
+ })
+ .Where(it => it.SequenceDate == date && it.SequenceKey == sequenceKey)
+ .ExecuteCommandAsync();
- };
- await Repository.Db.Insertable(sequence).ExecuteCommandAsync();
+ if (result == 0)
+ {
+ // 濡傛灉娌℃湁鏇存柊鍒拌褰曪紝鍙兘鏄娆′娇鐢紝鎻掑叆鏂拌褰�
+ var newSequence = new DT_DailySequence
+ {
+ SequenceKey = sequenceKey,
+ SequenceDate = date,
+ CurrentValue = value,
+ Creater="admin",
+ CreateDate=DateTime.Now,
+ };
+ await sugarClient.Insertable(newSequence).ExecuteCommandAsync();
+ }
}
+ catch (Exception ex)
+ {
+ // 璁板綍鏃ュ織骞堕噸鏂版姏鍑哄紓甯�
+ Console.WriteLine($"鏇存柊搴忓垪澶辫触: {ex.Message}");
+ throw;
+ }
+
}
public async Task CleanOldSequencesAsync(int keepDays = 30)
--
Gitblit v1.9.3