From 15c6d7dec741a03bd7a84c3948fdc2a89e036395 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 10 十一月 2023 13:24:24 +0800
Subject: [PATCH] 1.生产加工单打印次数接口 2.工艺路线批量关联产品接口 3.修复用户所属班组绑定关系写入关系表
---
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 102 ++++++++++++++++++++++++++++++++++++--------------
1 files changed, 73 insertions(+), 29 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index f00d215..7ecfbc5 100644
--- a/VueWebApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
@@ -540,6 +540,8 @@
public static ToMessage AddUpdateUser(string UserId, string UserCode, string UserName, string Password, string Enable, string StuOrg, string groupcode, string wagetype, string Mobile, string Email, string Operator, string OperType)
{
var dynamicParams = new DynamicParameters();
+ List<object> list = new List<object>();
+ var sql = "";
try
{
if (OperType == "Add")
@@ -555,22 +557,41 @@
mes.data = null;
return mes;
}
-
- var sql = @"insert into TUser(usercode,username,password,enable,mobile,lm_date,email,lm_user,stu_torgcode,wagetype,usergroup_code)
+ //鍐欏叆鐢ㄦ埛琛�
+ sql = @"insert into TUser(usercode,username,password,enable,mobile,lm_date,email,lm_user,stu_torgcode,wagetype,usergroup_code)
values(@UserCode,@UserName,@password,@Enable,@Mobile,@CreateDate,@Email,@Operator,@StuOrg,@wagetype,@groupcode)";
- dynamicParams.Add("@UserCode", UserCode);
- dynamicParams.Add("@UserName", UserName);
- dynamicParams.Add("@password", Password);
- dynamicParams.Add("@Enable", Enable);
- dynamicParams.Add("@Mobile", Mobile);
- dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
- dynamicParams.Add("@Email", Email);
- dynamicParams.Add("@Operator", Operator);
- dynamicParams.Add("@StuOrg", StuOrg);
- dynamicParams.Add("@wagetype", wagetype);
- dynamicParams.Add("@groupcode", groupcode);
- int cont = DapperHelper.SQL(sql, dynamicParams);
- if (cont > 0)
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ UserCode = UserCode,
+ UserName = UserName,
+ password = Password,
+ Enable = Enable,
+ Mobile = Mobile,
+ CreateDate = DateTime.Now.ToString(),
+ Email = Email,
+ Operator = Operator,
+ StuOrg = StuOrg,
+ wagetype = wagetype,
+ groupcode = groupcode
+ }
+ });
+ //鍐欏叆鐢ㄦ埛鐝粍鍏宠仈琛�
+ sql = @"insert into TGroupUser(group_code,user_code)
+ values(@groupcode,@usercode)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ usercode = UserCode,
+ groupcode = groupcode
+ }
+ });
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
{
mes.code = "200";
mes.count = 0;
@@ -587,20 +608,39 @@
}
if (OperType == "Update")
{
- var sql = @"update TUser set username=@UserName,password=@password,enable=@Enable,mobile=@Mobile,lm_user=@Operator,email=@Email,stu_torgcode=@StuOrg,wagetype=@wagetype,usergroup_code=@groupcode,lm_date=@CreateDate where id=@UserId";
- dynamicParams.Add("@UserId", UserId);
- dynamicParams.Add("@UserName", UserName);
- dynamicParams.Add("@password", Password);
- dynamicParams.Add("@Enable", Enable);
- dynamicParams.Add("@Mobile", Mobile);
- dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
- dynamicParams.Add("@Email", Email);
- dynamicParams.Add("@Operator", Operator);
- dynamicParams.Add("@StuOrg", StuOrg);
- dynamicParams.Add("@wagetype", wagetype);
- dynamicParams.Add("@groupcode", groupcode);
- int cont = DapperHelper.SQL(sql, dynamicParams);
- if (cont > 0)
+ //淇敼鐢ㄦ埛琛�
+ sql = @"update TUser set username=@UserName,password=@password,enable=@Enable,mobile=@Mobile,lm_user=@Operator,email=@Email,stu_torgcode=@StuOrg,wagetype=@wagetype,usergroup_code=@groupcode,lm_date=@CreateDate where id=@UserId";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ UserId = UserId,
+ UserName = UserName,
+ password = Password,
+ Enable = Enable,
+ Mobile = Mobile,
+ CreateDate = DateTime.Now.ToString(),
+ Email = Email,
+ Operator = Operator,
+ StuOrg = StuOrg,
+ wagetype = wagetype,
+ groupcode = groupcode
+ }
+ });
+ //鏇存柊鐢ㄦ埛鐝粍鍏宠仈琛�
+ sql = @"update TGroupUser set group_code=@groupcode where user_code=@usercode";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ usercode = UserCode,
+ groupcode = groupcode
+ }
+ });
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
{
mes.code = "200";
mes.count = 0;
@@ -640,6 +680,10 @@
dynamicParams.Add("@userid", userid);
var data = DapperHelper.selectdata(sql, dynamicParams);
+ //鍒犻櫎鐢ㄦ埛鐝粍鍏宠仈琛�
+ sql = @"delete TGroupUser where user_code=@usercode";
+ list.Add(new { str = sql, parm = new { usercode = data.Rows[0]["USERCODE"].ToString() } });
+ //鍒犻櫎鐢ㄦ埛瑙掕壊鍏宠仈琛�
sql = @"delete TUserRoleRelation where user_code=@usercode";
list.Add(new { str = sql, parm = new { usercode = data.Rows[0]["USERCODE"].ToString() } });
--
Gitblit v1.9.3