用户清单导入班组字段

yl

2023-03-21 ebd3c081279d7f9059bf3dd7590e998357d41ea1

用户清单导入班组字段

 .vs/VueWebApi/v16/.suo

Binary files differ

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