From 50aeb4c0145561bc137732bc4d383a890bd401dd Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 12 九月 2023 18:56:57 +0800
Subject: [PATCH] 组织架构去掉分页 班组管理，角色管理，岗位管理导入功能开发
---
VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs | 12 +++++-------
1 files changed, 5 insertions(+), 7 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs b/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
index ae634a7..32b019b 100644
--- a/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
@@ -680,7 +680,7 @@
#region[缁勭粐鏋舵瀯,鏌ヨ缁勭粐淇℃伅]
- public static ToMessage STorgData(string storg_code, string storg_name, int startNum, int endNum, string prop, string order)
+ public static ToMessage STorgData(string storg_code, string storg_name)
{
var dynamicParams = new DynamicParameters();
string search = "";
@@ -696,18 +696,16 @@
search += "and T.torg_name like '%'+@storg_name+'%' ";
dynamicParams.Add("@storg_name", storg_name);
}
- // --------------鏌ヨ鎸囧畾鏁版嵁--------------
- var total = 0; //鎬绘潯鏁�
var sql = @"select T.id,T.parent_id,T.torg_code,T.torg_name,T.status,T.leve,T.torg_seq,
T.lm_user as usercode,U.username,T.lm_date
from TOrganization T
left join TUser U on T.lm_user=U.usercode
- where 1=1" + search + "";
- var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
+ where 1=1" + search + " order by T.lm_date desc";
+ var data = DapperHelper.selectdata(sql, dynamicParams);
mes.code = "200";
mes.Message = "鏌ヨ鎴愬姛!";
- mes.count = total;
- mes.data = data.ToList();
+ mes.count = data.Rows.Count;
+ mes.data = data;
}
catch (Exception e)
{
--
Gitblit v1.9.3