From dac1d793ad118eebf9048588a356ae0ea8a3aa95 Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期四, 10 二月 2022 17:42:41 +0800
Subject: [PATCH] 基础建模每个模块的权限

---
 WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs b/WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs
index 71c441a..af7fa64 100644
--- a/WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs
@@ -43,12 +43,12 @@
 
                 if (sWhere == null || sWhere.Equals(""))
                 {
-                    ds = oCN.RunProcReturn("select * from h_v_Gy_CurrencyList where 绂佺敤鏍囪=''" + sWhere, "h_v_Gy_CurrencyList");
+                    ds = oCN.RunProcReturn("select * from h_v_Gy_CurrencyList where 绂佺敤鏍囪=''" + sWhere+ " order by 璐у竵浠g爜", "h_v_Gy_CurrencyList");
                 }
                 else
                 {
                     string sql1 = "select * from h_v_Gy_CurrencyList where 绂佺敤鏍囪='' ";
-                    string sql = sql1 + sWhere;
+                    string sql = sql1 + sWhere+ " order by 璐у竵浠g爜";
                     ds = oCN.RunProcReturn(sql, "h_v_Gy_CurrencyList");
                 }
                 if (ds == null || ds.Tables[0].Rows.Count == 0)

--
Gitblit v1.9.1