From 0cc1531f55cfa7927abec8624ddce3db45201ee7 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 24 十月 2023 17:24:43 +0800
Subject: [PATCH] 1.班组工资报表功能接口、人员工资明细报表功能接口 2.委外报表功能接口、不良明细报表功能接口、维修明细报表功能接口 3.模具清单查看履历接口、模具上机过滤已上模设备接口 4.模具点检记录报表功能接口、模具保养记录报表功能接口 5.模具维修记录报表功能接口

---
 VueWebCoreApi/DLL/DAL/LoginDAL.cs |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/VueWebCoreApi/DLL/DAL/LoginDAL.cs b/VueWebCoreApi/DLL/DAL/LoginDAL.cs
index 666a512..17e0c81 100644
--- a/VueWebCoreApi/DLL/DAL/LoginDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/LoginDAL.cs
@@ -267,7 +267,7 @@
                         string codeString = string.Join(",", menuCodes);
                         //鏌ヨ鑿滃崟鏁版嵁
                         sql = @"select menucode,menuname,menu_seq,imgurl,'0' as flag,parent_id,is_show   
-                                from TMenu where is_show='Y' and Type=@usertype order by menu_seq";
+                                from TMenu where is_show='Y' and Type=@usertype order by CAST(menu_seq as int) ASC";
                         dynamicParams.Add("@usertype", usertype);
                         var data0 = DapperHelper.selectdata(sql, dynamicParams);
                         if (data0.Rows.Count > 0)

--
Gitblit v1.9.3