From f3779c3cbca0d737c7ef7eaf47c1330b355c2f00 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 31 八月 2023 17:30:23 +0800
Subject: [PATCH] ERP订单删除功能
---
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 14 +++++++++-----
1 files changed, 9 insertions(+), 5 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index 6433422..f00d215 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 set 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
}
});
}
@@ -1133,6 +1133,8 @@
}
sql = @"delete TGroup where group_code=@UserGrupCode";
list.Add(new { str = sql, parm = new { UserGrupCode = UserGrupCode } });
+ sql = @"delete TGroupUser where group_code=@UserGrupCode";
+ list.Add(new { str = sql, parm = new { UserGrupCode = UserGrupCode } });
bool aa = DapperHelper.DoTransaction(list);
if (aa)
@@ -1168,7 +1170,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