From 5339020eae4f4ed4938302a902087a0693743898 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期三, 22 五月 2024 11:28:00 +0800 Subject: [PATCH] 器具模块功能完善(器具档案、器具分类、器具保养项目,器具保养规程、器具保养计划、器具保养记录 器具维修项目、器具故障登记、器具维修记录单、器具维修验收单 器具寿命调整单、器具寿命耗用单 产品器具清单) --- WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs index 134f9dc..9812528 100644 --- a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs +++ b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs @@ -87,12 +87,12 @@ if (sWhere == null || sWhere.Equals("")) { - ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList order by hmainid desc", "h_v_IF_SeOrderBillList"); + ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList order by hmainid desc,hsubid asc", "h_v_IF_SeOrderBillList"); } else { string sql1 = "select * from h_v_IF_SeOrderBillList where 1 = 1 "; - string sql = sql1 + sWhere+ " order by hmainid desc"; + string sql = sql1 + sWhere+ " order by hmainid desc,hsubid asc"; ds = oCN.RunProcReturn(sql, "h_v_IF_SeOrderBillList"); } @@ -1268,7 +1268,7 @@ try { - ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList where hmainid =" + HInterID, "h_v_IF_SeOrderBillList"); + ds = oCN.RunProcReturn("select * from h_v_IF_SeOrderBillList where hmainid =" + HInterID + " order by hsubid asc", "h_v_IF_SeOrderBillList"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; -- Gitblit v1.9.1