用户清单上传用户组字段

yl

2023-03-21 b40929d90432d53352633a98a70c83d2cbdaf443

 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()
                        }
                    });
                }