From 947a0f63b0071fcef2535b5aee397ca0668d72dc Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 08 八月 2023 10:18:52 +0800
Subject: [PATCH] 修改用户组新增编辑、查看接口
---
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 12 +++++++-----
1 files changed, 7 insertions(+), 5 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index 6433422..cd70037 100644
--- a/VueWebApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
@@ -1013,14 +1013,14 @@
//鍐欏叆鐢ㄦ埛缁勫叧绯昏〃
for (int i = 0; i < json[0].children.Count; i++)
{
- sql = @"insert into TGroup(group_code,user_code) values(@groupcode,@usercode)";
+ sql = @"insert into TGroupUser(group_code,user_code) values(@groupcode,@usercode)";
list.Add(new
{
str = sql,
parm = new
{
groupcode = json[0].code,
- groupename = json[0].children[i].usercode
+ usercode = json[0].children[i].usercode
}
});
}
@@ -1044,7 +1044,7 @@
else
{
//淇敼鐢ㄦ埛缁勮〃
- sql = @"update TGroup see group_name=@,lm_user=@lm_user,lm_date=@lm_date,description=@description,torg_code=@torg_code where group_code=@groupcode";
+ sql = @"update TGroup see group_name=@groupename,lm_user=@lm_user,lm_date=@lm_date,description=@description,torg_code=@torg_code where group_code=@groupcode";
list.Add(new
{
str = sql,
@@ -1078,7 +1078,7 @@
parm = new
{
groupcode = json[0].code,
- groupename = json[0].children[i].usercode
+ usercode = json[0].children[i].usercode
}
});
}
@@ -1168,7 +1168,9 @@
var dynamicParams = new DynamicParameters();
try
{
- sql = @"select * from TGroupUser where group_code=@groupcode";
+ sql = @"select U.usercode,U.username from TGroupUser GU
+ left join TUser U on GU.user_code=U.usercode
+ where GU.group_code=@groupcode";
dynamicParams.Add("@groupcode", groupcode);
var data = DapperHelper.selectdata(sql, dynamicParams);
if (data.Rows.Count > 0)
--
Gitblit v1.9.3