From b40929d90432d53352633a98a70c83d2cbdaf443 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 21 三月 2023 14:48:24 +0800
Subject: [PATCH] 用户清单上传用户组字段
---
VueWebApi/Tools/ImportExcelData.cs | 7 ++++---
1 files changed, 4 insertions(+), 3 deletions(-)
diff --git a/VueWebApi/Tools/ImportExcelData.cs b/VueWebApi/Tools/ImportExcelData.cs
index ce03a64..7785234 100644
--- a/VueWebApi/Tools/ImportExcelData.cs
+++ b/VueWebApi/Tools/ImportExcelData.cs
@@ -3293,8 +3293,8 @@
break;
}
- sql = @"insert into TUser(usercode,username,password,enable,mobile,lm_date,email,lm_user,stu_torgcode,wagetype)
- values(@UserCode,@UserName,@password,@Enable,@Mobile,@CreateDate,@Email,@Operator,@StuOrg,@wagetype)";
+ 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,@usergroup_code)";
list.Add(new
{
str = sql,
@@ -3309,7 +3309,8 @@
Email = excelTable[1].Rows[i][6].ToString().Trim(),
Operator = User,
StuOrg = excelTable[1].Rows[i][7].ToString().Trim(),
- wagetype = WageType
+ wagetype = WageType,
+ usergroup_code= excelTable[1].Rows[i][9].ToString().Trim()
}
});
}
--
Gitblit v1.9.3