From 63b6be972c27f9000b97809b627369d8a17741a0 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期二, 09 五月 2023 11:18:38 +0800 Subject: [PATCH] 生产订单编码规则(S+年(23)+五位流水号)实例:S2300001 生产订单按照日期最新的排在最前面 --- WebAPI/Controllers/LMESController.cs | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/LMESController.cs b/WebAPI/Controllers/LMESController.cs index db1c9f7..10c5f28 100644 --- a/WebAPI/Controllers/LMESController.cs +++ b/WebAPI/Controllers/LMESController.cs @@ -593,7 +593,7 @@ return objJsonResult; } - ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1 = 1 " + sWhere + " order by 鍗曟嵁鍙� desc", "h_v_IF_ICMOBillList"); + ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1 = 1 " + sWhere + " order by 鍒跺崟鏃ユ湡 desc,鍗曟嵁鍙� desc", "h_v_IF_ICMOBillList"); } catch (Exception e) { -- Gitblit v1.9.1