From a23b0dc904a0af0fcfd9716b3dd69fa8147b0a71 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期一, 22 一月 2024 12:43:36 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/LMESController.cs | 9 ++++++++- 1 files changed, 8 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/LMESController.cs b/WebAPI/Controllers/LMESController.cs index a1fe776..fbacc0b 100644 --- a/WebAPI/Controllers/LMESController.cs +++ b/WebAPI/Controllers/LMESController.cs @@ -572,6 +572,7 @@ //鑾峰彇绯荤粺鍙傛暟 string Ret = ""; + string Count = ""; if (oSystemParameter.ShowBill(ref Ret)) { //鍒ゆ柇瀹㈡埛涓洪緳灞辨苯閰� @@ -582,10 +583,16 @@ sWhere += sql_splice; } + //鍒ゆ柇瀹㈡埛涓虹憺涓庣ズ + if (oSystemParameter.omodel.WMS_CampanyName == "鐟炰笌绁�") + { + Count = "top 1000"; + } } + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); - ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeIssueBillQuery where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeIssueBillQuery"); + ds = oCN.RunProcReturn("select " + Count + " * from h_v_Sc_ProcessExchangeIssueBillQuery where 1 = 1 " + sWhere + " order by hmainid desc,CONVERT(int,娴佹按鍙�) asc", "h_v_Sc_ProcessExchangeIssueBillQuery"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess锛�"; -- Gitblit v1.9.1