From 947a0f63b0071fcef2535b5aee397ca0668d72dc Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 08 八月 2023 10:18:52 +0800
Subject: [PATCH] 修改用户组新增编辑、查看接口
---
VueWebApi/obj/Release/VueWebApi.pdb | 0
VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache | 0
VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.pdb | 0
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 12 +++++++-----
VueWebApi/obj/Debug/VueWebApi.pdb | 0
VueWebApi/bin/VueWebApi.pdb | 0
.vs/VueWebApi/v16/.suo | 0
VueWebApi/Properties/PublishProfiles/FolderProfile1.pubxml.user | 6 +++---
8 files changed, 10 insertions(+), 8 deletions(-)
diff --git a/.vs/VueWebApi/v16/.suo b/.vs/VueWebApi/v16/.suo
index 1f3e7fe..2aa4031 100644
--- a/.vs/VueWebApi/v16/.suo
+++ b/.vs/VueWebApi/v16/.suo
Binary files differ
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)
diff --git a/VueWebApi/Properties/PublishProfiles/FolderProfile1.pubxml.user b/VueWebApi/Properties/PublishProfiles/FolderProfile1.pubxml.user
index 01e6123..bb3be2a 100644
--- a/VueWebApi/Properties/PublishProfiles/FolderProfile1.pubxml.user
+++ b/VueWebApi/Properties/PublishProfiles/FolderProfile1.pubxml.user
@@ -750,13 +750,13 @@
<publishTime>12/24/2021 15:38:29</publishTime>
</File>
<File Include="bin/VueWebApi.dll">
- <publishTime>08/07/2023 18:03:18</publishTime>
+ <publishTime>08/08/2023 10:17:11</publishTime>
</File>
<File Include="bin/VueWebApi.pdb">
- <publishTime>08/07/2023 18:03:18</publishTime>
+ <publishTime>08/08/2023 10:17:11</publishTime>
</File>
<File Include="bin/VueWebApi.xml">
- <publishTime>08/07/2023 18:03:18</publishTime>
+ <publishTime>08/08/2023 10:17:11</publishTime>
</File>
<File Include="bin/WebActivatorEx.dll">
<publishTime>02/08/2013 16:42:28</publishTime>
diff --git a/VueWebApi/bin/VueWebApi.pdb b/VueWebApi/bin/VueWebApi.pdb
index 9ebbc28..5348747 100644
--- a/VueWebApi/bin/VueWebApi.pdb
+++ b/VueWebApi/bin/VueWebApi.pdb
Binary files differ
diff --git a/VueWebApi/obj/Debug/VueWebApi.pdb b/VueWebApi/obj/Debug/VueWebApi.pdb
index 7a38f43..d1eaa4b 100644
--- a/VueWebApi/obj/Debug/VueWebApi.pdb
+++ b/VueWebApi/obj/Debug/VueWebApi.pdb
Binary files differ
diff --git a/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.pdb b/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.pdb
index 9ebbc28..5348747 100644
--- a/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.pdb
+++ b/VueWebApi/obj/Release/Package/PackageTmp/bin/VueWebApi.pdb
Binary files differ
diff --git a/VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache b/VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache
index 5c97c60..2c850c0 100644
--- a/VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache
+++ b/VueWebApi/obj/Release/VueWebApi.csproj.AssemblyReference.cache
Binary files differ
diff --git a/VueWebApi/obj/Release/VueWebApi.pdb b/VueWebApi/obj/Release/VueWebApi.pdb
index 9ebbc28..5348747 100644
--- a/VueWebApi/obj/Release/VueWebApi.pdb
+++ b/VueWebApi/obj/Release/VueWebApi.pdb
Binary files differ
--
Gitblit v1.9.3