From 6e1231595e0e72b0fa421711d34bc77d3b406a4b Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 21 四月 2023 10:14:37 +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..4053ec4 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