From 1142525a181bdfebad871bf4a6191f2f637c94a5 Mon Sep 17 00:00:00 2001 From: black-goat-me <226547893@qq.com> Date: 星期三, 24 五月 2023 12:46:04 +0800 Subject: [PATCH] 白坯发布汇总、明细报表:列宽 --- WebAPI/Controllers/CJGL/Sc_ProcExchRecordBackBillController.cs | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Sc_ProcExchRecordBackBillController.cs b/WebAPI/Controllers/CJGL/Sc_ProcExchRecordBackBillController.cs index 75fefaa..13811d8 100644 --- a/WebAPI/Controllers/CJGL/Sc_ProcExchRecordBackBillController.cs +++ b/WebAPI/Controllers/CJGL/Sc_ProcExchRecordBackBillController.cs @@ -77,7 +77,7 @@ { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); string sql = string.Format(@"select top 2 * from h_v_Sc_ProcessExchangeBillQuerySub"); - ds = oCN.RunProcReturn(sql + sWhere+ " order by 娴佹按鍙� ", "h_v_Sc_ProcessExchangeBillQuerySub"); + ds = oCN.RunProcReturn(sql + sWhere+ " order by cast(娴佹按鍙� as int) ", "h_v_Sc_ProcessExchangeBillQuerySub"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; -- Gitblit v1.9.1