From ce43535d56152482c1f12e6b13ba3377bd268009 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 13 八月 2024 13:42:28 +0800
Subject: [PATCH] 期初入库扫码，接受erp发送的用户数据时，在写入MES用户表时增加部分默认字段
---
MES.Service/service/BasicData/MesStaffManager.cs | 16 ++++++++++++++--
1 files changed, 14 insertions(+), 2 deletions(-)
diff --git a/MES.Service/service/BasicData/MesStaffManager.cs b/MES.Service/service/BasicData/MesStaffManager.cs
index 34eafdf..5dc3db7 100644
--- a/MES.Service/service/BasicData/MesStaffManager.cs
+++ b/MES.Service/service/BasicData/MesStaffManager.cs
@@ -64,7 +64,11 @@
var exists = db.Queryable<SysUser>().Any(u => u.Sid == sysUser.Sid);
if (exists)
{
- var updateUser = db.Updateable(sysUser).ExecuteCommand();
+ var updateUser = db.Updateable<SysUser>()
+ .SetColumns(s => s.Fcode == sysUser.Fcode)
+ .SetColumns(s => s.Fname == sysUser.Fname)
+ .Where(s => s.Sid == sysUser.Sid)
+ .ExecuteCommand();
if (updateUser > 0)
{
var updateStaff = db.Updateable(entity).ExecuteCommand();
@@ -137,7 +141,15 @@
Lever = 0,
Fcompany = "1000",
Ffactory = "1000",
- DelFlag = 0
+ DelFlag = 0,
+ Ismanager = 0,
+ Isacq = 0,
+ ExpField9 = "1020",
+ QmUser = 0,
+ Status = 0,
+ Isdeparture = 0,
+ CheckFlag = 0,
+ ExpFiel12 = 0,
};
}
--
Gitblit v1.9.3