From d49f55ea970c2b2c778c07b1f928415f9f76deb0 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 21 三月 2023 15:00:28 +0800
Subject: [PATCH] 用户清单导入班组字段
---
VueWebApi/Tools/ImportExcelData.cs | 7 ++++---
.vs/VueWebApi/v16/.suo | 0
2 files changed, 4 insertions(+), 3 deletions(-)
diff --git a/.vs/VueWebApi/v16/.suo b/.vs/VueWebApi/v16/.suo
index 52b17f6..3d19da8 100644
--- a/.vs/VueWebApi/v16/.suo
+++ b/.vs/VueWebApi/v16/.suo
Binary files differ
diff --git a/VueWebApi/Tools/ImportExcelData.cs b/VueWebApi/Tools/ImportExcelData.cs
index 3b7ffe1..4403b14 100644
--- a/VueWebApi/Tools/ImportExcelData.cs
+++ b/VueWebApi/Tools/ImportExcelData.cs
@@ -2835,8 +2835,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,
@@ -2851,7 +2851,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