From eb744ecfecc0f1b6d9c0999c65bc740d93e30eda Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期三, 22 一月 2025 13:38:52 +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