From a667d4159bb3f1ba909b94d5b5dd7c6eb28e7197 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 07 四月 2023 09:48:30 +0800
Subject: [PATCH] 1.添加质检方案基础资料 2.采购到货接口调整 3.入厂检验扫描标签添加标签判断 4.ERP订单下达生成工单接口修改 5.编码规则接口修改 6.采购退货查询采购订单接口开发、订单查找物料接口开发

---
 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