From a619299816f2f632c7c6ba3a1bb869e2c212797d Mon Sep 17 00:00:00 2001
From: fcx <2246384483@qq.com>
Date: 星期五, 19 十二月 2025 14:12:33 +0800
Subject: [PATCH] 对添加巡检单物料编码进行去重
---
StandardPda/MES.Service/util/GetSeqUtil.cs | 11 +++++------
1 files changed, 5 insertions(+), 6 deletions(-)
diff --git a/StandardPda/MES.Service/util/GetSeqUtil.cs b/StandardPda/MES.Service/util/GetSeqUtil.cs
index 712e6a6..82bad7d 100644
--- a/StandardPda/MES.Service/util/GetSeqUtil.cs
+++ b/StandardPda/MES.Service/util/GetSeqUtil.cs
@@ -8,19 +8,18 @@
* 鍒ゆ柇瀛楃涓叉槸鍚︿负绌�
* 涓虹┖鏃惰繑鍥瀟rue
*/
- public static Decimal GetSeq(string? seqName)
+ public static decimal GetSeq(string? seqName)
{
var db = SqlSugarHelper.GetInstance();
- string sequenceName = $"{seqName}.NEXTVAL"; // 娉ㄦ剰杩欓噷鐩存帴浣跨敤浜哊EXTVAL鏉ヨ幏鍙栦笅涓�涓��
+ var sequenceName = $"{seqName}.NEXTVAL"; // 娉ㄦ剰杩欓噷鐩存帴浣跨敤浜哊EXTVAL鏉ヨ幏鍙栦笅涓�涓��
// 鐢变簬SQLSugar涓嶇洿鎺ユ敮鎸佸簭鍒楄皟鐢ㄤ綔涓哄弬鏁帮紝鎴戜滑闇�瑕佹瀯閫犱竴涓猄QL璇彞
- string sql = $"SELECT {sequenceName} FROM DUAL"; // DUAL鏄疧racle涓殑涓�涓櫄鎷熻〃锛岀敤浜庝粠涓嶉渶瑕佸疄闄呰〃鐨勫嚱鏁版垨琛ㄨ揪寮忎腑閫夋嫨鏁版嵁
+ var sql =
+ $"SELECT {sequenceName} FROM DUAL"; // DUAL鏄疧racle涓殑涓�涓櫄鎷熻〃锛岀敤浜庝粠涓嶉渶瑕佸疄闄呰〃鐨勫嚱鏁版垨琛ㄨ揪寮忎腑閫夋嫨鏁版嵁
// 鎵ц鍘熺敓SQL璇彞骞惰幏鍙栫粨鏋�
- Decimal result = Convert.ToDecimal( db.Ado.GetScalar(sql));
+ var result = Convert.ToDecimal(db.Ado.GetScalar(sql));
return result;
}
-
-
}
\ No newline at end of file
--
Gitblit v1.9.3