public QyJsonResult WX_CreateTag(JH_Auth_Role Model) { QyJsonResult Ret = new QyJsonResult(); if (Qyinfo.IsUseWX == "Y") { Ret = MailListApi.CreateTag(GetToken(), Model.RoleName, Model.WXBQCode); } return(Ret); }
public QyJsonResult WX_UpdateTag(JH_Auth_Role Model) { QyJsonResult Ret = new QyJsonResult(); if (Qyinfo.IsUseWX == "Y") { int bqid = Int32.Parse(Model.WXBQCode.ToString()); Ret = MailListApi.UpdateTag(GetToken(), bqid, Model.RoleName); } return(Ret); }
/// <summary> /// 从企业微信同步到系统里 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void TBTXL(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { try { int bmcount = 0; int rycount = 0; if (P1 == "") { msg.ErrorMsg = "请输入初始密码"; return; } WXHelp wx = new WXHelp(UserInfo.QYinfo); #region 更新部门 GetDepartmentListResult bmlist = wx.WX_GetBranchList(""); foreach (var wxbm in bmlist.department.OrderBy(d => d.parentid)) { var bm = new JH_Auth_BranchB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.WXBMCode == wxbm.id); if (bm == null) { #region 新增部门 JH_Auth_Branch jab = new JH_Auth_Branch(); jab.WXBMCode = int.Parse(wxbm.id.ToString()); jab.ComId = UserInfo.User.ComId; jab.DeptName = wxbm.name; jab.DeptDesc = wxbm.name; jab.DeptShort = int.Parse(wxbm.order.ToString()); if (wxbm.parentid == 0)//如果是跟部门,设置其跟部门为-1 { jab.DeptRoot = -1; } else { var bm1 = new JH_Auth_BranchB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.WXBMCode == wxbm.parentid); jab.DeptRoot = bm1.DeptCode; jab.Remark1 = new JH_Auth_BranchB().GetBranchNo(UserInfo.User.ComId.Value, jab.DeptRoot); } new JH_Auth_BranchB().Insert(jab); jab.Remark1 = new JH_Auth_BranchB().GetBranchNo(UserInfo.User.ComId.Value, jab.DeptRoot) + jab.DeptCode; new JH_Auth_BranchB().Update(jab); bmcount = bmcount + 1; #endregion } else { //同步部门时放弃更新现有部门 } } #endregion #region 更新人员 JH_Auth_Branch branchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptRoot == -1 && d.ComId == UserInfo.User.ComId); GetDepartmentMemberInfoResult yg = wx.WX_GetDepartmentMemberInfo(branchModel.WXBMCode.Value); foreach (var u in yg.userlist) { var user = new JH_Auth_UserB().GetUserByUserName(UserInfo.QYinfo.ComId, u.userid); if (user == null) { #region 新增人员 JH_Auth_User jau = new JH_Auth_User(); jau.ComId = UserInfo.User.ComId; jau.UserName = u.userid; jau.UserPass = CommonHelp.GetMD5(P1); jau.UserRealName = u.name; jau.Sex = u.gender == 1 ? "男" : "女"; if (u.department.Length > 0) { int id = int.Parse(u.department[0].ToString()); var bm1 = new JH_Auth_BranchB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.WXBMCode == id); jau.BranchCode = bm1.DeptCode; jau.remark = bm1.Remark1.Split('-')[0];//用户得部门路径 } jau.mailbox = u.email; jau.mobphone = u.mobile; jau.zhiwu = string.IsNullOrEmpty(u.position) ? "员工" : u.position; jau.IsUse = "Y"; if (u.status == 1 || u.status == 4) { jau.isgz = u.status.ToString(); } jau.txurl = u.avatar; new JH_Auth_UserB().Insert(jau); rycount = rycount + 1; #endregion //为所有人增加普通员工的权限 JH_Auth_Role rdefault = new JH_Auth_RoleB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.isSysRole == "Y" && p.RoleName == "员工");//找到默认角色 if (rdefault != null) { JH_Auth_UserRole jaurdefault = new JH_Auth_UserRole(); jaurdefault.ComId = UserInfo.User.ComId; jaurdefault.RoleCode = rdefault.RoleCode; jaurdefault.UserName = jau.UserName; new JH_Auth_UserRoleB().Insert(jaurdefault); } } else { //同步人员时放弃更新现有人员 #region 更新人员 user.UserRealName = u.name; if (u.department.Length > 0) { int id = int.Parse(u.department[0].ToString()); var bm1 = new JH_Auth_BranchB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.WXBMCode == id); user.BranchCode = bm1.DeptCode; } user.mailbox = u.email; user.mobphone = u.mobile; user.zhiwu = string.IsNullOrEmpty(u.position) ? "员工" : u.position; user.Sex = u.gender == 1 ? "男" : "女"; if (u.status == 1 || u.status == 4) { user.IsUse = "Y"; user.isgz = u.status.ToString(); } else if (u.status == 2) { user.IsUse = "N"; } user.txurl = u.avatar; new JH_Auth_UserB().Update(user); #endregion } #region 更新角色(职务) if (!string.IsNullOrEmpty(u.position)) { var r = new JH_Auth_RoleB().GetEntity(p => p.ComId == UserInfo.User.ComId && p.RoleName == u.position); if (r == null) { JH_Auth_Role jar = new JH_Auth_Role(); jar.ComId = UserInfo.User.ComId; jar.RoleName = u.position; jar.RoleDec = u.position; jar.PRoleCode = 0; jar.isSysRole = "N"; jar.IsUse = "Y"; jar.leve = 0; jar.DisplayOrder = 0; new JH_Auth_RoleB().Insert(jar); JH_Auth_UserRole jaur = new JH_Auth_UserRole(); jaur.ComId = UserInfo.User.ComId; jaur.RoleCode = jar.RoleCode; jaur.UserName = u.userid; new JH_Auth_UserRoleB().Insert(jaur); } else { } } #endregion } #endregion msg.Result1 = bmcount; msg.Result2 = rycount; } catch (Exception ex) { msg.ErrorMsg = ex.ToString(); } }
public void SAVEIMPORTUSER(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { string branchMsg = "", branchErrorMsg = "", userMsg = ""; int i = 0, j = 0; DataTable dt = new DataTable(); dt = JsonConvert.DeserializeObject <DataTable>(P1); dt.Columns.Add("BranchCode"); JH_Auth_Branch branchroot = new JH_Auth_BranchB().GetEntity(d => d.ComId == UserInfo.User.ComId && d.DeptRoot == -1); foreach (DataRow row in dt.Rows) { int bRootid = branchroot.DeptCode; string branchName = row[4].ToString(); if (branchName != "") { string[] branchNames = branchName.Split('/'); string strBranch = branchNames[0]; JH_Auth_Branch branchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptName == strBranch && d.ComId == UserInfo.User.ComId); if (branchModel == null) { branchModel = new JH_Auth_Branch(); branchModel.DeptName = branchNames[0]; branchModel.DeptDesc = branchNames[0]; branchModel.ComId = UserInfo.User.ComId; branchModel.DeptRoot = bRootid; branchModel.CRDate = DateTime.Now; branchModel.CRUser = UserInfo.User.UserName; new JH_Auth_BranchB().Insert(branchModel); branchModel.Remark1 = new JH_Auth_BranchB().GetBranchNo(UserInfo.User.ComId.Value, branchModel.DeptRoot) + branchModel.DeptCode; new JH_Auth_BranchB().Update(branchModel); } } } int rowIndex = 0; foreach (DataRow row in dt.Rows) { rowIndex++; string branchName = row[4].ToString(); if (branchName != "") { string[] branchNames = branchName.Split('/'); string strPBranch = branchNames[0]; JH_Auth_Branch PbranchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptName == strPBranch && d.ComId == UserInfo.User.ComId); int bRootid = PbranchModel.DeptCode; for (int l = 1; l < branchNames.Length; l++) { string strBranch = branchNames[1]; JH_Auth_Branch branchModel = new JH_Auth_BranchB().GetEntity(d => d.DeptName == strBranch && d.DeptRoot == PbranchModel.DeptCode && d.ComId == UserInfo.User.ComId); if (branchModel != null) { bRootid = branchModel.DeptCode; if (l == branchNames.Length - 1) { row["BranchCode"] = branchModel.DeptCode; } } else { branchModel = new JH_Auth_Branch(); branchModel.DeptName = strBranch; branchModel.DeptDesc = strBranch; branchModel.ComId = UserInfo.User.ComId; branchModel.DeptRoot = bRootid; branchModel.CRDate = DateTime.Now; branchModel.CRUser = UserInfo.User.UserName; new JH_Auth_BranchB().Insert(branchModel); branchModel.Remark1 = new JH_Auth_BranchB().GetBranchNo(UserInfo.User.ComId.Value, branchModel.DeptRoot) + branchModel.DeptCode; new JH_Auth_BranchB().Update(branchModel); try { bRootid = branchModel.DeptCode; if (l == branchNames.Length - 1) { row["BranchCode"] = branchModel.DeptCode; } i++; branchMsg += "新增部门“" + strBranch + "”成功<br/>"; } catch (Exception ex) { branchErrorMsg += "部门:" + strBranch + "失败 " + msg.ErrorMsg + "<br/>"; } } } string userName = row[2].ToString(); JH_Auth_User userModel = new JH_Auth_UserB().GetEntity(d => d.UserName == userName && d.ComId == UserInfo.User.ComId); if (userModel == null) { JH_Auth_User userNew = new JH_Auth_User(); if (row["BranchCode"].ToString() != "") { int tempcode = int.Parse(row["BranchCode"].ToString()); JH_Auth_Branch branchTemp = new JH_Auth_BranchB().GetEntity(d => d.DeptCode == tempcode && d.ComId == UserInfo.User.ComId); userNew.BranchCode = branchTemp.DeptCode; userNew.remark = branchTemp.Remark1.Split('-')[0]; } else { userNew.BranchCode = bRootid; } userNew.ComId = UserInfo.User.ComId; userNew.IsUse = "Y"; userNew.mailbox = row[3].ToString(); userNew.mobphone = row[2].ToString(); userNew.RoomCode = row[7].ToString(); userNew.Sex = row[1].ToString(); userNew.telphone = row[9].ToString(); DateTime result; if (DateTime.TryParse(row[10].ToString(), out result)) { userNew.Birthday = result; } userNew.UserGW = row[6].ToString(); userNew.UserName = row[2].ToString(); userNew.UserRealName = row[0].ToString(); userNew.zhiwu = row[5].ToString() == "" ? "员工" : row[5].ToString(); userNew.UserPass = CommonHelp.GetMD5(P2); userNew.CRDate = DateTime.Now; userNew.CRUser = UserInfo.User.UserName; if (!string.IsNullOrEmpty(row[8].ToString())) { int orderNum = 0; int.TryParse(row[8].ToString(), out orderNum); userNew.UserOrder = orderNum; } try { msg.ErrorMsg = ""; if (string.IsNullOrEmpty(userNew.UserName)) { msg.ErrorMsg = "用户名必填"; } //Regex regexPhone = new Regex("^0?1[3|4|5|8|7][0-9]\\d{8}$"); //if (!regexPhone.IsMatch(userNew.UserName)) //{ // msg.ErrorMsg = "用户名必须为手机号"; //} if (string.IsNullOrEmpty(userNew.mobphone)) { msg.ErrorMsg = "手机号必填"; } //if (!regexPhone.IsMatch(userNew.mobphone)) //{ // msg.ErrorMsg = "手机号填写不正确"; //} Regex regexOrder = new Regex("^[0-9]*$"); if (userNew.UserOrder != null && !regexOrder.IsMatch(userNew.UserOrder.ToString())) { msg.ErrorMsg = "序号必须是数字"; } if (msg.ErrorMsg != "") { userMsg += "第" + rowIndex + "行" + msg.ErrorMsg + "<br/>"; } if (msg.ErrorMsg == "") { new JH_Auth_UserB().Insert(userNew); JH_Auth_Role role = new JH_Auth_RoleB().GetEntity(d => d.RoleName == userNew.zhiwu && d.ComId == UserInfo.User.ComId); if (role == null) { role = new JH_Auth_Role(); role.PRoleCode = 0; role.RoleName = userNew.zhiwu; role.RoleDec = userNew.zhiwu; role.IsUse = "Y"; role.isSysRole = "N"; role.leve = 0; role.ComId = UserInfo.User.ComId; role.DisplayOrder = 0; new JH_Auth_RoleB().Insert(role); } string strSql = string.Format("INSERT into JH_Auth_UserRole (UserName,RoleCode,ComId) Values('{0}',{1},{2})", userNew.UserName, role.RoleCode, UserInfo.User.ComId); new JH_Auth_RoleB().ExsSql(strSql); string isFS = context.Request["issend"] ?? ""; if (isFS.ToLower() == "true") { string content = string.Format("尊敬的" + userNew.UserName + "用户您好:你已被添加到" + UserInfo.QYinfo.QYName + ",账号:" + userNew.mobphone + ",密码" + P2 + ",登录请访问" + UserInfo.QYinfo.WXUrl); new SZHL_DXGLB().SendSMS(userNew.mobphone, content, userNew.ComId.Value); } j++; } } catch (Exception ex) { userMsg += "第" + rowIndex + "行" + msg.ErrorMsg + "<br/>"; } } else { userMsg += "第" + rowIndex + "行" + "用户“" + row[2].ToString() + "”已存在<br/>"; } } else { branchErrorMsg += "第" + rowIndex + "行所在部门必填<br/>"; } } msg.Result = branchErrorMsg + "<br/>" + userMsg; msg.Result1 = "新增部门" + i + "个,新增用户" + j + "个<br/>" + branchMsg + (branchMsg == "" ? "" : "<br/>"); }