From 41c53f7d9e245f90ac125956a3282006cfae1cf8 Mon Sep 17 00:00:00 2001 From: zjh <2207896513@qq.com> Date: 星期一, 21 七月 2025 09:49:23 +0800 Subject: [PATCH] 退货申请单接口bug修复 --- 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