//同步组织架构的主方法 public void StartSynchDeptInfo() { string logSql = @" insert into S_D_ModifyLog (ID,ConnName,TableName,ModifyMode,EntityKey,CurrentValue,OriginalValue ,ModifyUserID,ModifyUserName,ModifyTime,ClientIP,UserHostAddress) Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')"; //获取组织架构根节点 var rootOrg_BE_Temp = orgDt.Select("ParentID is null or ParentID = ''"); if (rootOrg_BE_Temp == null || rootOrg_BE_Temp.Count() == 0) { logSql = string.Format(logSql, FormulaHelper.CreateGuid(), "Base", "", "Added", "获取组织架构根节点信息失败。" , "失败时间:" + DateTime.Now, "获取组织架构根节点信息失败:", "", DateTime.Now, "", ""); baseSqlHelper.ExecuteNonQuery(logSql); } deptManager = RootObj.DeptManager; if (deptManager == null) { //记录异常信息 logSql = string.Format(logSql, FormulaHelper.CreateGuid(), "Base", "", "Added", "获取RTX组织管理对象失败。" , "失败时间:" + DateTime.Now, "获取RTX组织管理对象失败:", "", DateTime.Now, "", ""); baseSqlHelper.ExecuteNonQuery(logSql); } DataRow rootOrg = rootOrg_BE_Temp[0]; DataRow parentNode_Root = null; var rootOrgID = rootOrg["ID"].ToString(); DataRow[] children = orgDt.Select(" ParentID='" + rootOrgID + "'"); var rootOrgName = rootOrg["Name"] == null ? "" : rootOrg["Name"].ToString(); AddDeptToRTX(rootOrg, parentNode_Root, children); //删除RTX中存在,金慧BE平台不存在的部门 string childOrgInfo = deptManager.GetChildDepts(rootOrgName); DeleteExistedRTXAndNotExistedBE(rootOrgName, rootOrgName, childOrgInfo); }
public void StartSynchUserInfo() { string logSql = @" insert into S_D_ModifyLog (ID,ConnName,TableName,ModifyMode,EntityKey,CurrentValue,OriginalValue ,ModifyUserID,ModifyUserName,ModifyTime,ClientIP,UserHostAddress) Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')"; userManager = RootObj.UserManager; if (userManager == null) { return; } deptManager = RootObj.DeptManager; if (deptManager == null) { return; } var userDt = baseSqlHelper.ExecuteDataTable(" select * from S_A_User "); // var userList = baseEntites.S_A_User.ToList(); //获取人员和部门的关系信息 string sql = @" select UserID,OrgID,Name as DeptName,ParentID from S_A__OrgUser left join S_A_Org on S_A__OrgUser.OrgID = S_A_Org.ID "; DataTable userOrgInfoDt = baseSqlHelper.ExecuteDataTable(sql); var userOrgInfoRows = userOrgInfoDt.Rows; var userRows = userDt.Rows; foreach (DataRow userItem in userRows) { var systemName = userItem["Code"] == null ? "" : userItem["Code"].ToString(); systemName = systemName.TrimStart(' ').TrimEnd(' '); var isDeleted = userItem["IsDeleted"] == null ? "" : userItem["IsDeleted"].ToString(); var deptName = userItem["DeptName"] == null ? "" : userItem["DeptName"].ToString(); var orgID = userItem["DeptID"] == null ? "" : userItem["DeptID"].ToString(); DataRow orgInfo = null; var orgInfo_Temp = orgDt.Select(" ID='" + orgID + "'"); if (orgInfo_Temp != null && orgInfo_Temp.Count() > 0) { orgInfo = orgInfo_Temp[0]; } absoluteFullDpetNameList.Clear(); if (orgInfo != null) { GetAbsoluteFullDpetName(orgInfo); var absoluteFullDpetName = string.Join("\\", absoluteFullDpetNameList); deptName = absoluteFullDpetName + "\\" + deptName; } if (isDeleted == "1") { //删除用户信息 if (userManager.IsUserExist(systemName)) { try { userManager.DeleteUser(systemName); } catch (Exception exp) { logSql = @" insert into S_D_ModifyLog (ID,ConnName,TableName,ModifyMode,EntityKey,CurrentValue,OriginalValue ,ModifyUserID,ModifyUserName,ModifyTime,ClientIP,UserHostAddress) Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')"; logSql = string.Format(logSql, FormulaHelper.CreateGuid(), "Base", "", "Added", "删除用户" + systemName + "失败" , "失败时间:" + DateTime.Now, "失败详细信息:" + exp.Message, "", "", DateTime.Now, "", ""); SQLHelper.CreateSqlHelper(ConnEnum.Base).ExecuteNonQuery(logSql); continue; } } } else { if (!userManager.IsUserExist(systemName)) { try { userManager.AddUser(systemName, 0); } catch (Exception exp) { logSql = @" insert into S_D_ModifyLog (ID,ConnName,TableName,ModifyMode,EntityKey,CurrentValue,OriginalValue ,ModifyUserID,ModifyUserName,ModifyTime,ClientIP,UserHostAddress) Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')"; logSql = string.Format(logSql, FormulaHelper.CreateGuid(), "Base", "", "Added", "添加用户" + systemName + "失败" , "失败时间:" + DateTime.Now, "失败详细信息:" + exp.Message, "", "", DateTime.Now, "", ""); SQLHelper.CreateSqlHelper(ConnEnum.Base).ExecuteNonQuery(logSql); continue; } if (!string.IsNullOrEmpty(deptName) && deptManager.IsDeptExist(deptName)) { try { deptManager.AddUserToDept(systemName, "", deptName, false); } catch (Exception exp) { logSql = @" insert into S_D_ModifyLog (ID,ConnName,TableName,ModifyMode,EntityKey,CurrentValue,OriginalValue ,ModifyUserID,ModifyUserName,ModifyTime,ClientIP,UserHostAddress) Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')"; logSql = string.Format(logSql, FormulaHelper.CreateGuid(), "Base", "", "Added", "添加用户部门之间的关联关系失败,用户(" + systemName + "),部门(" + deptName + ")" , "失败时间:" + DateTime.Now, "失败详细信息:" + exp.Message, "", "", DateTime.Now, "", ""); SQLHelper.CreateSqlHelper(ConnEnum.Base).ExecuteNonQuery(logSql); continue; } } } else { //设置用户部门信息 string UserDeptInfo = deptManager.GetUserDepts(systemName); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(BeforeLoadXML(UserDeptInfo)); XmlElement xmlEle = xmlDoc.DocumentElement; XmlNodeList nodelist = xmlEle.SelectNodes("//Department"); if (nodelist.Count > 0) { //删除RTX中人员的部门信息 foreach (XmlNode node in nodelist) { string name = ((XmlElement)node).GetAttribute("Name"); try { deptManager.DelUserFromDept(systemName, name); } catch (Exception exp) { logSql = @" insert into S_D_ModifyLog (ID,ConnName,TableName,ModifyMode,EntityKey,CurrentValue,OriginalValue ,ModifyUserID,ModifyUserName,ModifyTime,ClientIP,UserHostAddress) Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')"; logSql = string.Format(logSql, FormulaHelper.CreateGuid(), "Base", "", "Added", "删除用户部门之间的关联关系失败,用户(" + systemName + "),部门(" + name + ")" , "失败时间:" + DateTime.Now, "失败详细信息:" + exp.Message, "", "", DateTime.Now, "", ""); SQLHelper.CreateSqlHelper(ConnEnum.Base).ExecuteNonQuery(logSql); continue; } } } var userId = userItem["ID"]; var userOrgInfoRowsOfSingleUser = userOrgInfoDt.Select(" UserID='" + userId + "'"); foreach (DataRow row in userOrgInfoRowsOfSingleUser) { deptName = row["DeptName"] == null ? "" : row["DeptName"].ToString(); absoluteFullDpetNameList.Clear(); if (orgInfo != null) { GetAbsoluteFullDpetName(row); var absoluteFullDpetName = string.Join("\\", absoluteFullDpetNameList); if (!string.IsNullOrEmpty(absoluteFullDpetName)) { deptName = absoluteFullDpetName + "\\" + deptName; } } if (!string.IsNullOrEmpty(deptName) && deptManager.IsDeptExist(deptName)) { try { deptManager.AddUserToDept(systemName, "", deptName, false); } catch (Exception exp) { logSql = @" insert into S_D_ModifyLog (ID,ConnName,TableName,ModifyMode,EntityKey,CurrentValue,OriginalValue ,ModifyUserID,ModifyUserName,ModifyTime,ClientIP,UserHostAddress) Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')"; logSql = string.Format(logSql, FormulaHelper.CreateGuid(), "Base", "", "Added", "添加用户部门之间的关联关系失败,用户(" + systemName + "),部门(" + deptName + ")" , "失败时间:" + DateTime.Now, "失败详细信息:" + exp.Message, "", "", DateTime.Now, "", ""); SQLHelper.CreateSqlHelper(ConnEnum.Base).ExecuteNonQuery(logSql); continue; } } } } //设置用户的基本信息(用户姓名,用户性别,用户手机,用户电子邮件,用户电话,用户认证类型) string Name = userItem["Name"] == null ? "" : userItem["Name"].ToString(); string Sex = userItem["Sex"] == null ? "" : userItem["Sex"].ToString(); string MobilePhone = userItem["MobilePhone"] == null ? "" : userItem["MobilePhone"].ToString(); string Email = userItem["Email"] == null ? "" : userItem["Email"].ToString(); string Phone = userItem["Phone"] == null ? "" : userItem["Phone"].ToString(); try { userManager.SetUserBasicInfo(systemName, Name, GetSex(Sex), MobilePhone, Email, Phone, 0); } catch (Exception exp) { logSql = @" insert into S_D_ModifyLog (ID,ConnName,TableName,ModifyMode,EntityKey,CurrentValue,OriginalValue ,ModifyUserID,ModifyUserName,ModifyTime,ClientIP,UserHostAddress) Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')"; logSql = string.Format(logSql, FormulaHelper.CreateGuid(), "Base", "", "Added", "设置用户基本信息失败,用户(" + systemName + ")" , "失败时间:" + DateTime.Now, "失败详细信息:" + exp.Message, "", "", DateTime.Now, "", ""); SQLHelper.CreateSqlHelper(ConnEnum.Base).ExecuteNonQuery(logSql); continue; } //设置用户的详细信息(用户生日,用户血型,用户星座,用户毕业院校,用户主页,用户传真,用户地址,用户邮编,用户所在国家, 用户所在省份, 用户所在城市,用户所在街道,用户职务,用户权值 (用于排序) ) string strSortIndex = userItem["SortIndex"] == null || userItem["SortIndex"].ToString() == "" ? "0" : userItem["SortIndex"].ToString(); int sortIndex = Convert.ToInt32(strSortIndex); try { userManager.SetUserDetailInfo(systemName, -1, -1, -1, "RTX_NULL", "RTX_NULL", "RTX_NULL", "RTX_NULL", "RTX_NULL", "RTX_NULL", "RTX_NULL", "RTX_NULL", "RTX_NULL", "RTX_NULL", sortIndex); } catch (Exception exp) { logSql = @" insert into S_D_ModifyLog (ID,ConnName,TableName,ModifyMode,EntityKey,CurrentValue,OriginalValue ,ModifyUserID,ModifyUserName,ModifyTime,ClientIP,UserHostAddress) Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')"; logSql = string.Format(logSql, FormulaHelper.CreateGuid(), "Base", "", "Added", "设置用户详细信息失败,用户(" + systemName + ")" , "失败时间:" + DateTime.Now, "失败详细信息:" + exp.Message, "", "", DateTime.Now, "", ""); SQLHelper.CreateSqlHelper(ConnEnum.Base).ExecuteNonQuery(logSql); continue; } } } }