| | |
| | | } |
| | | |
| | | // 插入或更新员工的方法 |
| | | private bool InsertOrUpdateStaff(SqlSugarScope db, SysUser sysUser, |
| | | MesStaff entity) |
| | | private bool InsertOrUpdateStaff(SqlSugarScope db, SysUser sysUser,MesStaff entity) |
| | | { |
| | | var exists = db.Queryable<SysUser>().Any(u => u.Sid == sysUser.Sid); |
| | | if (exists) |
| | |
| | | { |
| | | var updateStaff = db.Updateable(entity).ExecuteCommand(); |
| | | if (updateStaff > 0) |
| | | { |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | var insertStaff = db.Insertable(entity).ExecuteCommand(); |
| | | if (insertStaff > 0) |
| | | { |
| | | return true; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | else |
| | |
| | | Id = Convert.ToDecimal(staff.Id), |
| | | StaffNo = staff.FStaffNumber, |
| | | StaffName = staff.FName, |
| | | DepartmentName = staff.FPostDept, |
| | | PositionName = staff.FPost, |
| | | DepartmentNo = staff.FPostDept, |
| | | PositionCode = staff.FPostId, |
| | | PhoneNumber = staff.FMobile, |
| | | CreateOrg = Convert.ToDecimal(staff.FCreateOrgId), |
| | | UseOrg = Convert.ToDecimal(staff.FUseOrgId), |
| | | CreateDate = DateTime.Now, |
| | | Remark = staff.FDescription, |
| | | FforbidStatus = staff.FForbidStatus |
| | | }; |
| | |
| | | Fcode = staff.FStaffNumber, |
| | | Fname = staff.FName, |
| | | Fpassword = "8+()./,", // 初始密码 |
| | | Fsystem = "上格", |
| | | Fsystem = "煜昌", |
| | | Lever = 0, |
| | | Fcompany = "1000", |
| | | Ffactory = "1000", |
| | | DelFlag = 0, |
| | | Dev=0, |
| | | Tet=0, |
| | | Prd=1, |
| | | Ismanager = 0, |
| | | Isacq = 0, |
| | | ExpField9 = "1020", |
| | |
| | | Status = 0, |
| | | Isdeparture = 0, |
| | | CheckFlag = 0, |
| | | ExpFiel12 = 0 |
| | | ExpFiel12 = 0, |
| | | FirstLogin = 0, |
| | | CreateDate = DateTime.Now, |
| | | PswEditTime = DateTime.Now |
| | | }; |
| | | } |
| | | |