/// <summary> /// 添加新SystemUserRoleMapping记录 /// </summary> /// <param name="model">SystemUserRoleMapping实体对象</param> /// <returns>新插入数据的id</returns> public static int Insert(SystemUserRoleMapping model, SqlConnection conn = null, SqlTransaction transaction = null) { var sql = new StringBuilder(); sql.Append("INSERT INTO [SystemUserRoleMapping]([SystemUserId], [RoleId], [CreatedTime])"); sql.Append(" OUTPUT INSERTED.[Id] "); sql.Append("VALUES(@SystemUserId, @RoleId, @CreatedTime)"); var ret = 0; if (conn != null) { if (transaction == null) { throw new ArgumentNullException("transaction"); } ret = conn.ExecuteScalar <int>(sql.ToString(), model, transaction); } else { using (var conn1 = GetOpenConnection()) { ret = conn1.ExecuteScalar <int>(sql.ToString(), model); } } return(ret); }
public ActionResult UserRole(int userId, int roleId) { var userModel = SystemUserRoleMappingHelper.GetUserRoleBy(userId); if (userModel == null) { return(new JsonResult(ResponseHelper.Error("用户不存在"))); } if (roleId == userModel.RoleId) { return(new JsonResult(ResponseHelper.Success("ok"))); } var roleModel = SystemRoleHelper.GetModel(p => p.Id == roleId); if (roleModel == null) { return(new JsonResult(ResponseHelper.Error("该角色不存在!"))); } var userRoleMapping = SystemUserRoleMappingHelper.GetModel(p => p.SystemUserId == userId); if (userRoleMapping == null) { userRoleMapping = new SystemUserRoleMapping { CreatedTime = DateTime.Now, RoleId = roleId, SystemUserId = userId }; SystemUserRoleMappingHelper.Insert(userRoleMapping); return(new JsonResult(ResponseHelper.Success("ok"))); } if (SystemUserRoleMappingHelper.Update(userRoleMapping, p => p.SystemUserId == userId, SystemUserRoleMappingHelper.Columns.RoleId)) { return(new JsonResult(ResponseHelper.Success("ok"))); } return(new JsonResult(ResponseHelper.Error("修改失败!"))); }
/// <summary> /// 更新SystemUserRoleMapping数据记录 /// </summary> /// <param name="model">SystemUserRoleMapping实体对象</param> /// <param name="fields">需要更新的字段名字</param> /// <param name="reverse">反转给定的更新字段</param> /// <returns>是否成功,true为成功</returns> public static bool Update(SystemUserRoleMapping model, Expression <Func <SystemUserRoleMapping, bool> > predicate, bool reverse, params SystemUserRoleMappingColumn[] fields) { return(Update( model: model, predicate: predicate, reverse: reverse, conn: null, transaction: null, fields: fields)); }
/// <summary> /// 更新SystemUserRoleMapping数据记录 /// </summary> /// <param name="model">SystemUserRoleMapping实体对象</param> /// <param name="fields">需要更新的字段名字</param> /// <param name="reverse">反转给定的更新字段</param> /// <returns>是否成功,true为成功</returns> public static bool Update(SystemUserRoleMapping model, bool reverse, SqlConnection conn, SqlTransaction transaction, params SystemUserRoleMappingColumn[] fields) { return(Update( model: model, predicate: null, reverse: reverse, conn: conn, transaction: transaction, fields: fields)); }
/// <summary> /// 更新SystemUserRoleMapping数据记录 /// </summary> /// <param name="model">SystemUserRoleMapping实体对象</param> /// <param name="fields">需要更新的字段名字</param> /// <param name="reverse">反转给定的更新字段</param> /// <returns>是否成功,true为成功</returns> public static bool Update(SystemUserRoleMapping model, params SystemUserRoleMappingColumn[] fields) { return(Update( model: model, predicate: null, reverse: false, conn: null, transaction: null, fields: fields)); }
/// <summary> /// 更新SystemUserRoleMapping数据记录 /// </summary> /// <param name="model">SystemUserRoleMapping实体对象</param> /// <param name="fields">需要更新的字段名字</param> /// <param name="reverse">反转给定的更新字段</param> /// <returns>是否成功,true为成功</returns> public static bool Update(SystemUserRoleMapping model, Expression <Func <SystemUserRoleMapping, bool> > predicate, SqlConnection conn, SqlTransaction transaction, params SystemUserRoleMappingColumn[] fields) { return(Update( model: model, predicate: predicate, reverse: false, conn: conn, transaction: transaction, fields: fields)); }
/// <summary> /// 获取指定的SystemUserRoleMapping实体对象 /// </summary> /// <param name="Id">Id</param> /// <returns>SystemUserRoleMapping实体</returns> public static SystemUserRoleMapping GetModel(int Id) { var sql = new StringBuilder(); sql.Append("SELECT TOP 1 [Id], [SystemUserId], [RoleId], [CreatedTime] FROM [SystemUserRoleMapping] "); sql.Append(" WHERE [Id]=@Id "); SystemUserRoleMapping ret = null; using (var conn = GetOpenConnection()) { ret = conn.QueryFirstOrDefault <SystemUserRoleMapping>(sql.ToString(), new { @Id = Id }); } return(ret); }
/// <summary> /// 获取指定的SystemUserRoleMapping实体对象 /// </summary> public static SystemUserRoleMapping GetModel(Expression <Func <SystemUserRoleMapping, bool> > predicate) { var parser = new PredicateParser(); var where_str = parser.Parse(predicate); var sql = new StringBuilder(); sql.Append("SELECT TOP 1 * FROM [SystemUserRoleMapping] "); sql.Append(" WHERE " + where_str); SystemUserRoleMapping ret = null; using (var conn = GetOpenConnection()) { ret = conn.QueryFirstOrDefault <SystemUserRoleMapping>(sql.ToString()); } return(ret); }
public IActionResult Getuserinfo(string strlist) { var response = ResponseModelFactory.CreateResultInstance; using (_dbContext) { var code = strlist; //TODO:钉钉相关的配置信息都要放到配置文件中 string suiteKey = "dinga7xg5vjb2lwwvicu"; string suiteSecret = "pUiI0xvN0ZEbsFavSbuaLqctwHL2p9cIRlQ4HU5GS7y-TmYngcTjJGuI309ZLR_h"; string timestamp = ((DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000).ToString(); string suiteTicket = "TestSuiteTicket"; string signature1 = timestamp + "\n" + suiteTicket; string signature2 = HmacSHA256(signature1, suiteSecret); string signature = System.Web.HttpUtility.UrlEncode(signature2, System.Text.Encoding.UTF8); string auth_corpid = strlist; string url = "https://oapi.dingtalk.com/gettoken?appkey=" + suiteKey + "&appsecret=" + suiteSecret; try { var response11 = Haikan3.Utils.DingDingHelper.HttpGet(url); var result = Newtonsoft.Json.JsonConvert.DeserializeObject <HaikanCRM.Api.ViewModels.DIngDing.PersistentCodeResult>(response11); if (result != null && result.errcode == "0") { string url11 = "https://oapi.dingtalk.com/user/getuserinfo?access_token=" + result.access_token + "&code=" + code; var response12 = Haikan3.Utils.DingDingHelper.HttpGet(url11); var result12 = Newtonsoft.Json.JsonConvert.DeserializeObject <HaikanCRM.Api.ViewModels.DIngDing.PersistentCodeResult12>(response12); if (result12 != null && result12.errcode == 0) { //获取人员信息 //var results = Haikan3.Utils.DingDingHelper.GetUserDetail(result.access_token, result12.userid); var roiduuid = _dbContext.SystemRole.FirstOrDefault(x => x.RoleName == "客户经理"); var userdata = _dbContext.SystemUser.Where(x => x.Streets == result12.userid).ToList().Count; if (userdata == 0) { UserEditViewModel model = new UserEditViewModel(); string pas = "******"; var entity = new HaikanCRM.Api.Entities.SystemUser(); entity.SystemUserUuid = Guid.NewGuid(); entity.Streets = result12.userid; entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); entity.RealName = result12.name; entity.LoginName = result12.name; //entity.PassWord = Haikan3.Utils.DesEncrypt.Encrypt(pas.Trim(), MdDesEncrypt.SecretKey); entity.PassWord = Security.GenerateMD5(pas.Trim()); entity.SystemRoleUuid = roiduuid.SystemRoleUuid.ToString(); entity.IsDeleted = 0; entity.ZaiGang = "在岗"; entity.UserType = 2; _dbContext.SystemUser.Add(entity); _dbContext.SaveChanges(); _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUserRoleMapping WHERE SystemUserUUID={0}", entity.SystemUserUuid); var success = true; ////循环加权限 //for (int i = 0; i < model.SystemRoleUuid.Count; i++) //{ if (entity.SystemRoleUuid != null) { var roles = new SystemUserRoleMapping(); roles.SystemUserUuid = entity.SystemUserUuid; roles.SystemRoleUuid = Guid.Parse(entity.SystemRoleUuid); roles.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); roles.AddPeople = AuthContextService.CurrentUser.DisplayName; _dbContext.SystemUserRoleMapping.Add(roles); } //} success = _dbContext.SaveChanges() > 0; if (success) { response.SetSuccess(); } else { _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUser WHERE SystemUserUUID={0}", entity.SystemUserUuid); response.SetFailed("保存用户角色数据失败"); } } var user = _dbContext.SystemUser.FirstOrDefault(x => x.IsDeleted == 0 && x.Streets == result12.userid); var role = _dbContext.SystemRole.FirstOrDefault(x => x.SystemRoleUuid == Guid.Parse(user.SystemRoleUuid)); var claimsIdentity = new ClaimsIdentity(new Claim[] { new Claim(ClaimTypes.Name, result12.userid), new Claim("guid", user.SystemUserUuid.ToString()), new Claim("avatar", ""), new Claim("displayName", user.RealName), new Claim("loginName", user.LoginName), new Claim("emailAddress", ""), //new Claim("guid",user.SystemUserUuid.ToString()), //new Claim("userType",usertype.ToString()), new Claim("userType", user.UserType.Value.ToString()), new Claim("roleid", user.SystemRoleUuid.TrimEnd(',')), new Claim("roleName", role.RoleName.TrimEnd(',')), new Claim("ZYZ", ""), new Claim("YH", ""), new Claim("DDY", ""), new Claim("SJ", "") }); var token = JwtBearerAuthenticationExtension.GetJwtAccessToken(_appSettings, claimsIdentity); response.SetData(new { user, token }); return(Ok(response)); } } } catch (Exception ex) { throw new Exception(ex.Message); } } return(Ok(response)); }
public IActionResult Getalluseranddep() { //1、获取access_token string access_token = Haikan3.Utils.DingDingHelper.GetAccessToken0().access_token; var response = ResponseModelFactory.CreateResultInstance; using (_dbContext) { try { UserEditViewModel model = new UserEditViewModel(); string pas = "******"; var code = access_token; string suiteKey = "dinga7xg5vjb2lwwvicu"; string suiteSecret = "pUiI0xvN0ZEbsFavSbuaLqctwHL2p9cIRlQ4HU5GS7y-TmYngcTjJGuI309ZLR_h"; string timestamp = ((DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000).ToString(); string suiteTicket = "TestSuiteTicket"; string signature1 = timestamp + "\n" + suiteTicket; string signature2 = HmacSHA256(signature1, suiteSecret); string signature = System.Web.HttpUtility.UrlEncode(signature2, System.Text.Encoding.UTF8); string auth_corpid = access_token; //string url = "https://oapi.dingtalk.com/service/get_corp_token?signature=" + signature + "×tamp=" + timestamp + "&suiteTicket=" + suiteTicket + "&accessKey=" + suiteKey; string url = "https://oapi.dingtalk.com/gettoken?appkey=" + suiteKey + "&appsecret=" + suiteSecret; //string param = "{ \"auth_corpid\": \"ding5998aa137739c847bc961a6cb783455b\"}"; //var response11 = Haikan3.Utils.DingDingHelper.HttpPost(url, param); var response11 = Haikan3.Utils.DingDingHelper.HttpGet(url); var result = Newtonsoft.Json.JsonConvert.DeserializeObject <HaikanCRM.Api.ViewModels.DIngDing.PersistentCodeResult>(response11); if (result != null && result.errcode == "0") { //获取部门列表 string urldep = "https://oapi.dingtalk.com/department/list?access_token=" + result.access_token; var responseldep = Haikan3.Utils.DingDingHelper.HttpGet(urldep); var resultdep = Newtonsoft.Json.JsonConvert.DeserializeObject <HaikanCRM.Api.ViewModels.DIngDing.departmentAlldata>(responseldep); //将获取的部门信息保存到数据库 //if (resultdep.department == null) //{ // response.SetFailed(resultdep.errmsg); // return Ok(response); //} for (int i = 0; i < resultdep.department.Count; i++) { var depid = _dbContext.SystemDepartment.Count(x => x.Dingid == resultdep.department[i].id); //数据库中没有查到此部门--将数据添加到数据库中 if (depid == 0) { var entity = new SystemDepartment(); entity.Name = resultdep.department[i].name; //部门名称 entity.Dingid = resultdep.department[i].id; //部门钉钉id entity.IsDeleted = 0; //未删除 entity.EstablishTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //添加时间 entity.EstablishName = "钉钉同步"; //添加人 entity.Remark = ""; //备注 entity.DepartmentUuid = Guid.NewGuid(); //部门guid _dbContext.SystemDepartment.Add(entity); //添加 _dbContext.SaveChanges(); } else//此部门已存在---更新部门数据 { var entity = _dbContext.SystemDepartment.FirstOrDefault(x => x.Dingid == resultdep.department[i].id); entity.Name = resultdep.department[i].name;//更新部门名称 _dbContext.SaveChanges(); } //获取该部门的所有用户 string urldepuser = "******" + result.access_token + "&department_id=" + resultdep.department[i].id; //获取部门uuid var depuuid = _dbContext.SystemDepartment.FirstOrDefault(x => x.Dingid == resultdep.department[i].id).DepartmentUuid; var responsedepuser = Haikan3.Utils.DingDingHelper.HttpGet(urldepuser); var resdepuser = Newtonsoft.Json.JsonConvert.DeserializeObject <HaikanCRM.Api.ViewModels.DIngDing.depauser>(responsedepuser); //将获取到的人员信息保存到数据库中 for (int j = 0; j < resdepuser.userlist.Count; j++) { var userid = _dbContext.SystemUser.Count(x => x.Streets == resdepuser.userlist[j].userid); //获取人员信息 var results = Haikan3.Utils.DingDingHelper.HttpGet("https://oapi.dingtalk.com/user/get?access_token=" + result.access_token + "&userid=" + resdepuser.userlist[j].userid); var usersxinxi = Newtonsoft.Json.JsonConvert.DeserializeObject <HaikanCRM.Api.ViewModels.DIngDing.usersdata>(results); var roiduuid = _dbContext.SystemRole.FirstOrDefault(x => x.RoleName == "客户经理"); //数据库中没有该人员信息--添加到数据库中 if (userid == 0) { var entity = new SystemUser(); entity.SystemUserUuid = Guid.NewGuid(); entity.LoginName = resdepuser.userlist[j].name; entity.RealName = resdepuser.userlist[j].name; entity.Streets = resdepuser.userlist[j].userid; entity.DepartmentUuid = depuuid;//部门uuid entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //entity.PassWord = Haikan3.Utils.DesEncrypt.Encrypt(pas.Trim(), MdDesEncrypt.SecretKey); entity.PassWord = Security.GenerateMD5(pas.Trim());; entity.SystemRoleUuid = roiduuid.SystemRoleUuid.ToString(); entity.IsDeleted = 0; entity.ZaiGang = "在岗"; entity.UserType = 2; _dbContext.SystemUser.Add(entity); _dbContext.SaveChanges(); _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUserRoleMapping WHERE SystemUserUUID={0}", entity.SystemUserUuid); var success = true; ////循环加权限 //for (int i = 0; i < model.SystemRoleUuid.Count; i++) //{ if (entity.SystemRoleUuid != null) { var roles = new SystemUserRoleMapping(); roles.SystemUserUuid = entity.SystemUserUuid; roles.SystemRoleUuid = Guid.Parse(entity.SystemRoleUuid); roles.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); roles.AddPeople = AuthContextService.CurrentUser.DisplayName; _dbContext.SystemUserRoleMapping.Add(roles); } //} success = _dbContext.SaveChanges() > 0; if (success) { response.SetSuccess(); } else { _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUser WHERE SystemUserUUID={0}", entity.SystemUserUuid); response.SetFailed("保存用户角色数据失败"); } } else { //数据库中存在该人员--修改信息 var entity = _dbContext.SystemUser.FirstOrDefault(x => x.Streets == resdepuser.userlist[j].userid); entity.RealName = resdepuser.userlist[j].name; entity.LoginName = resdepuser.userlist[j].name; entity.DepartmentUuid = depuuid;//部门uuid _dbContext.SaveChanges(); } } ////获取子部门id列表 //string urlzidep = "https://oapi.dingtalk.com/department/list_ids?access_token=" + result.access_token + "&id=" + resultdep.department[i].id; // var responselzidep = Haikan3.Utils.DingDingHelper.HttpGet(urlzidep); } } //var response = ResponseModelFactory.CreateInstance; return(Ok(response)); } catch (Exception ex) { response.SetFailed(ex.Message); return(Ok(response)); } } }
public IActionResult Create(UserCreateViewModel model) { var response = ResponseModelFactory.CreateInstance; if (model.LoginName.Trim().Length <= 0) { response.SetFailed("请输入登录名称"); return(Ok(response)); } using (_dbContext) { if (_dbContext.SystemUser.Count(x => x.LoginName == model.LoginName) > 0) { response.SetFailed("登录名已存在"); return(Ok(response)); } //if ((!string.IsNullOrEmpty(model.UserIdCard))&& _dbContext.SystemUser.Count(x => x.UserIdCard == model.UserIdCard) > 0) //{ // response.SetFailed("身份证号已存在"); // return Ok(response); //} if (string.IsNullOrEmpty(model.SystemRoleUuid)) { response.SetFailed("请选择角色"); return(Ok(response)); } var entity = _mapper.Map <UserCreateViewModel, SystemUser>(model); entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); entity.SystemUserUuid = Guid.NewGuid(); var rolename = _dbContext.SystemRole.FirstOrDefault(x => x.RoleName == "超级管理员"); if (model.SystemRoleUuid.Contains(rolename.SystemRoleUuid.ToString())) { entity.UserType = 0; } else { entity.UserType = 2; } entity.SystemRoleUuid = ""; entity.PassWord = Haikan3.Utils.DesEncrypt.Encrypt(model.PassWord.Trim(), MdDesEncrypt.SecretKey); //for (int i = 0; i < model.SystemRoleUuid.Count; i++) //{ // entity.SystemRoleUuid += model.SystemRoleUuid[i] + ","; //} entity.SystemRoleUuid = model.SystemRoleUuid; entity.SystemRoleUuid = entity.SystemRoleUuid.TrimEnd(','); //entity.OldCard = model.OldCard; entity.Phone = model.Phone; entity.Sex = model.Sex; entity.Placeofresidence = model.Placeofresidence; entity.Age = model.Age; entity.Nickname = model.Nickname; _dbContext.SystemUser.Add(entity); int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("添加", "成功:添加:系统用户管理列表数据", _dbContext); } _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUserRoleMapping WHERE SystemUserUUID={0}", entity.SystemUserUuid); var success = true; //循环加权限 //for (int i = 0; i < model.SystemRoleUuid.Count; i++) //{ // if (model.SystemRoleUuid[i] != "") // { // var roles = new SystemUserRoleMapping(); // roles.SystemUserUuid = entity.SystemUserUuid; // roles.SystemRoleUuid = Guid.Parse(model.SystemRoleUuid[i]); // roles.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); // roles.AddPeople = AuthContextService.CurrentUser.DisplayName; // _dbContext.SystemUserRoleMapping.Add(roles); // } //} //非循环加权 var roles = new SystemUserRoleMapping(); roles.SystemUserUuid = entity.SystemUserUuid; roles.SystemRoleUuid = Guid.Parse(model.SystemRoleUuid); roles.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); roles.AddPeople = AuthContextService.CurrentUser.DisplayName; _dbContext.SystemUserRoleMapping.Add(roles); success = _dbContext.SaveChanges() > 0; if (success) { response.SetSuccess(); } else { _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUser WHERE SystemUserUUID={0}", entity.SystemUserUuid); response.SetFailed("保存用户角色数据失败"); } return(Ok(response)); } }
/// <summary> /// 更新SystemUserRoleMapping数据记录 /// </summary> /// <param name="model">SystemUserRoleMapping实体对象</param> /// <param name="fields">需要更新的字段名字</param> /// <param name="reverse">反转给定的更新字段</param> /// <returns>是否成功,true为成功</returns> public static bool Update(SystemUserRoleMapping model, Expression <Func <SystemUserRoleMapping, bool> > predicate, bool reverse, SqlConnection conn, SqlTransaction transaction, params SystemUserRoleMappingColumn[] fields) { var where_str = string.Empty; if (predicate != null) { var parser = new PredicateParser(); where_str = parser.Parse(predicate); } else { where_str = "[Id] = @Id"; } var sql = new StringBuilder(); sql.Append("UPDATE [SystemUserRoleMapping]"); if (fields == null || fields.Length == 0) { sql.Append(" SET [SystemUserId] = @SystemUserId, [RoleId] = @RoleId, [CreatedTime] = @CreatedTime"); } else { if (reverse == true) { fields = (SystemUserRoleMappingColumn[])Columns.All.Except(fields); } sql.Append(" SET "); for (int i = 0; i < fields.Length; i++) { if (fields[i].IsAddEqual) { sql.Append("[" + fields[i].Name + "] += @" + fields[i].Name + ""); fields[i].SetAddEqual(); } else { sql.Append("[" + fields[i].Name + "] = @" + fields[i].Name + ""); } if (i != fields.Length - 1) { sql.Append(","); } } } sql.Append(" WHERE " + where_str); var ret = false; if (conn != null) { if (transaction == null) { throw new ArgumentNullException("transaction"); } ret = conn.Execute(sql.ToString(), model, transaction) > 0; } else { using (var conn1 = GetOpenConnection()) { ret = conn1.Execute(sql.ToString(), model) > 0; } } return(ret); }
public IActionResult Edit(UserEditViewModel model) { var response = ResponseModelFactory.CreateInstance; if (ConfigurationManager.AppSettings.IsTrialVersion) { response.SetIsTrial(); return(Ok(response)); } using (_dbContext) { var entity = _dbContext.SystemUser.FirstOrDefault(x => x.SystemUserUuid == model.SystemUserUuid); if (entity == null) { response.SetFailed("用户不存在"); return(Ok(response)); } if (entity.LoginName != model.LoginName) { response.SetFailed("用户民不可修改"); return(Ok(response)); } //if (_dbContext.SystemUser.Count(x => x.LoginName == model.LoginName && x.SystemUserUuid != model.SystemUserUuid) > 0) //{ // response.SetFailed("登录名已存在"); // return Ok(response); //} if (model.UserIdCard != null && model.UserIdCard != "") { if (entity.UserIdCard != model.UserIdCard) { if (_dbContext.SystemUser.Count(x => x.UserIdCard == model.UserIdCard) > 0) { response.SetFailed("身份证号已存在"); return(Ok(response)); } } } if (model.SystemRoleUuid == null && model.SystemRoleUuid == "") { response.SetFailed("请选择角色"); return(Ok(response)); } if (entity.LoginName == model.LoginName && ConfigurationManager.HaikanPassport_IfUse) { var uu = SyncInformation.UpdateUser(model.LoginName, model.PassWord.Trim(), model.OldCard); if (!(int.Parse(uu) > 0)) { response.SetFailed("修改统一身份信息失败"); return(Ok(response)); } } entity.LoginName = model.LoginName; entity.RealName = model.RealName; entity.UserIdCard = model.UserIdCard; entity.SystemRoleUuid = model.SystemRoleUuid; entity.OldCard = model.OldCard; if (Security.GenerateMD5(model.PassWord.Trim()) != entity.PassWord) { //entity.PassWord = Haikan3.Utils.DesEncrypt.Encrypt(model.PassWord.Trim(), MdDesEncrypt.SecretKey); entity.PassWord = Security.GenerateMD5(model.PassWord.Trim()); } var rolename = _dbContext.SystemRole.FirstOrDefault(x => x.RoleName == "超级管理员"); if (model.SystemRoleUuid.ToString().Contains(rolename.SystemRoleUuid.ToString())) { entity.UserType = 0; } else { entity.UserType = 2; } _dbContext.SaveChanges(); //entity.UserType = model.UserType; //entity.ShopUuid = model.ShopUuid; //entity.VillageId = model.VillageId; //string temp = ""; //for (int i = 0; i < model.SystemRoleUuid.Count; i++) //{ // temp += model.SystemRoleUuid[i] +","; //} //entity.SystemRoleUuid = temp.TrimEnd(','); //entity.IsDeleted = model.IsDeleted; //entity.OldCard = model.OldCard; //entity.Phone = model.Phone; _dbContext.Database.ExecuteSqlCommand("DELETE FROM SystemUserRoleMapping WHERE SystemUserUUID={0}", entity.SystemUserUuid); var success = true; ////循环加权限 //for (int i = 0; i < model.SystemRoleUuid.Count; i++) //{ if (!string.IsNullOrEmpty(model.SystemRoleUuid)) { var roles = new SystemUserRoleMapping(); roles.SystemUserUuid = entity.SystemUserUuid; roles.SystemRoleUuid = Guid.Parse(model.SystemRoleUuid); roles.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); roles.AddPeople = AuthContextService.CurrentUser.DisplayName; _dbContext.SystemUserRoleMapping.Add(roles); } //} success = _dbContext.SaveChanges() > 0; if (success) { response.SetSuccess(); } else { _dbContext.Database.ExecuteSqlCommand("DELETE FROM SystemUser WHERE SystemUserUUID={0}", entity.SystemUserUuid); response.SetFailed("保存用户角色数据失败"); } response = ResponseModelFactory.CreateInstance; return(Ok(response)); } }
public IActionResult Edit(UserEditViewModel model) { var response = ResponseModelFactory.CreateInstance; if (ConfigurationManager.AppSettings.IsTrialVersion) { response.SetIsTrial(); return(Ok(response)); } using (_dbContext) { var entity = _dbContext.SystemUser.FirstOrDefault(x => x.SystemUserUuid == model.SystemUserUuid); if (entity == null) { response.SetFailed("用户不存在"); return(Ok(response)); } if (_dbContext.SystemUser.Count(x => x.LoginName == model.LoginName && x.SystemUserUuid != model.SystemUserUuid) > 0) { response.SetFailed("登录名已存在"); return(Ok(response)); } if (_dbContext.SystemUser.Count(x => x.UserIdCard == model.UserIdCard && x.SystemUserUuid != model.SystemUserUuid) > 0) { response.SetFailed("身份证号已存在"); return(Ok(response)); } entity.LoginName = model.LoginName; entity.RealName = model.RealName; entity.UserIdCard = model.UserIdCard; entity.PassWord = Haikan3.Utils.DesEncrypt.Encrypt(model.PassWord.Trim(), MdDesEncrypt.SecretKey); entity.UserType = model.UserType; entity.SystemRoleUuid = model.SystemRoleUuid; entity.IsDeleted = model.IsDeleted; entity.DepartmentUuid = model.DepartmentUuid; int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("编辑", "成功:编辑:系统用户信息一条数据", _dbContext); } _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUserRoleMapping WHERE SystemUserUUID={0}", entity.SystemUserUuid); var roles = new SystemUserRoleMapping(); roles.SystemUserUuid = entity.SystemUserUuid; roles.SystemRoleUuid = Guid.Parse(entity.SystemRoleUuid); roles.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); roles.AddPeople = AuthContextService.CurrentUser.DisplayName; var success = true; _dbContext.SystemUserRoleMapping.AddRange(roles); success = _dbContext.SaveChanges() > 0; if (success) { response.SetSuccess(); } else { _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUser WHERE SystemUserUUID={0}", entity.SystemUserUuid); response.SetFailed("保存用户角色数据失败"); } response = ResponseModelFactory.CreateInstance; return(Ok(response)); } }
public IActionResult Create(UserCreateViewModel model) { var response = ResponseModelFactory.CreateInstance; if (model.LoginName.Trim().Length <= 0) { response.SetFailed("请输入登录名称"); return(Ok(response)); } using (_dbContext) { if (_dbContext.SystemUser.Count(x => x.LoginName == model.LoginName) > 0) { response.SetFailed("登录名已存在"); return(Ok(response)); } if (_dbContext.SystemUser.Count(x => x.UserIdCard == model.UserIdCard) > 0) { response.SetFailed("身份证号已存在"); return(Ok(response)); } var entity = _mapper.Map <UserCreateViewModel, SystemUser>(model); entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); entity.SystemUserUuid = Guid.NewGuid(); var rolename = _dbContext.SystemRole.FirstOrDefault(x => x.SystemRoleUuid == model.SystemRoleUuid); entity.SystemRoleUuid = rolename.SystemRoleUuid.ToString();//用户角色uuid if (rolename.RoleName == "超级管理员") { entity.UserType = 0; } else { entity.UserType = 1; } entity.PassWord = Haikan3.Utils.DesEncrypt.Encrypt(model.PassWord.Trim(), MdDesEncrypt.SecretKey); _dbContext.SystemUser.Add(entity); int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("添加", "成功:添加:系统用户信息一条数据", _dbContext); } _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUserRoleMapping WHERE SystemUserUUID={0}", entity.SystemUserUuid); var roles = new SystemUserRoleMapping(); roles.SystemUserUuid = entity.SystemUserUuid; roles.SystemRoleUuid = (Guid)model.SystemRoleUuid; roles.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); roles.AddPeople = AuthContextService.CurrentUser.DisplayName; var success = true; _dbContext.SystemUserRoleMapping.AddRange(roles); success = _dbContext.SaveChanges() > 0; if (success) { response.SetSuccess(); } else { _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUser WHERE SystemUserUUID={0}", entity.SystemUserUuid); response.SetFailed("保存用户角色数据失败"); } response.SetSuccess(); return(Ok(response)); } }
public IActionResult Create(UserCreateViewModel model) { var response = ResponseModelFactory.CreateInstance; if (model.LoginName.Trim().Length <= 0) { response.SetFailed("请输入登录名称"); return(Ok(response)); } using (_dbContext) { if (_dbContext.SystemUser.Count(x => x.LoginName == model.LoginName) > 0) { response.SetFailed("登录名已存在"); return(Ok(response)); } if (_dbContext.SystemUser.Count(x => x.UserIdCard == model.UserIdCard) > 0 && model.UserIdCard != "") { response.SetFailed("身份证号已存在"); return(Ok(response)); } if (model.SystemRoleUuid.Count <= 0) { response.SetFailed("请选择角色"); return(Ok(response)); } var entity = _mapper.Map <UserCreateViewModel, SystemUser>(model); entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); entity.SystemUserUuid = Guid.NewGuid(); var rolename = _dbContext.SystemRole.FirstOrDefault(x => x.RoleName == "超级管理员"); if (model.SystemRoleUuid.Contains(rolename.SystemRoleUuid.ToString())) { entity.UserType = 0; } else { entity.UserType = 2; } entity.SystemRoleUuid = ""; entity.PassWord = Haikan3.Utils.DesEncrypt.Encrypt(model.PassWord.Trim(), MdDesEncrypt.SecretKey); for (int i = 0; i < model.SystemRoleUuid.Count; i++) { entity.SystemRoleUuid += model.SystemRoleUuid[i] + ","; } entity.SystemRoleUuid = entity.SystemRoleUuid.TrimEnd(','); entity.OldCard = model.OldCard; entity.Phone = model.Phone; entity.Streets = model.Streets; entity.Community = model.Community; entity.Biotope = model.Biotope; _dbContext.SystemUser.Add(entity); _dbContext.SaveChanges(); _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUserRoleMapping WHERE SystemUserUUID={0}", entity.SystemUserUuid); var success = true; //循环加权限 for (int i = 0; i < model.SystemRoleUuid.Count; i++) { if (model.SystemRoleUuid[i] != "") { var roles = new SystemUserRoleMapping(); roles.SystemUserUuid = entity.SystemUserUuid; roles.SystemRoleUuid = Guid.Parse(model.SystemRoleUuid[i]); roles.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); roles.AddPeople = AuthContextService.CurrentUser.DisplayName; _dbContext.SystemUserRoleMapping.Add(roles); } } success = _dbContext.SaveChanges() > 0; if (success) { response.SetSuccess(); } else { _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUser WHERE SystemUserUUID={0}", entity.SystemUserUuid); response.SetFailed("保存用户角色数据失败"); } return(Ok(response)); } }
public IActionResult Edit(UserEditViewModel model) { var response = ResponseModelFactory.CreateInstance; if (ConfigurationManager.AppSettings.IsTrialVersion) { response.SetIsTrial(); return(Ok(response)); } using (_dbContext) { var entity = _dbContext.SystemUser.FirstOrDefault(x => x.SystemUserUuid == model.SystemUserUuid); if (entity == null) { response.SetFailed("用户不存在"); return(Ok(response)); } if (_dbContext.SystemUser.Count(x => x.LoginName == model.LoginName && x.SystemUserUuid != model.SystemUserUuid) > 0) { response.SetFailed("登录名已存在"); return(Ok(response)); } if (_dbContext.SystemUser.Count(x => x.UserIdCard == model.UserIdCard && x.SystemUserUuid != model.SystemUserUuid) > 0) { response.SetFailed("身份证号已存在"); return(Ok(response)); } if (model.SystemRoleUuid.Count <= 0) { response.SetFailed("请选择角色"); return(Ok(response)); } entity.LoginName = model.LoginName; entity.RealName = model.RealName; entity.UserIdCard = model.UserIdCard; entity.PassWord = Haikan3.Utils.DesEncrypt.Encrypt(model.PassWord.Trim(), MdDesEncrypt.SecretKey); entity.UserType = model.UserType; entity.ShopUuid = model.ShopUuid; entity.VillageId = model.VillageId; string temp = ""; for (int i = 0; i < model.SystemRoleUuid.Count; i++) { temp += model.SystemRoleUuid[i] + ","; } entity.SystemRoleUuid = temp.TrimEnd(','); entity.IsDeleted = model.IsDeleted; entity.OldCard = model.OldCard; entity.Phone = model.Phone; entity.Streets = model.Streets; entity.Community = model.Community; entity.Biotope = model.Biotope; _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUserRoleMapping WHERE SystemUserUUID={0}", entity.SystemUserUuid); var success = true; //循环加权限 for (int i = 0; i < model.SystemRoleUuid.Count; i++) { if (!string.IsNullOrEmpty(model.SystemRoleUuid[i])) { var roles = new SystemUserRoleMapping(); roles.SystemUserUuid = entity.SystemUserUuid; roles.SystemRoleUuid = Guid.Parse(model.SystemRoleUuid[i]); roles.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); roles.AddPeople = AuthContextService.CurrentUser.DisplayName; _dbContext.SystemUserRoleMapping.Add(roles); } } success = _dbContext.SaveChanges() > 0; if (success) { response.SetSuccess(); } else { _dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUser WHERE SystemUserUUID={0}", entity.SystemUserUuid); response.SetFailed("保存用户角色数据失败"); } response = ResponseModelFactory.CreateInstance; return(Ok(response)); } }
public IActionResult Create(UserCreateViewModel model) { var response = ResponseModelFactory.CreateInstance; if (model.LoginName.Trim().Length <= 0) { response.SetFailed("请输入登录名称"); return(Ok(response)); } using (_dbContext) { //if (_dbContext.SystemUser.Count(x => x.LoginName == model.LoginName) > 0) //{ // response.SetFailed("登录名已存在"); // return Ok(response); //} if (model.UserIdCard != null && model.UserIdCard != "") { if (_dbContext.SystemUser.Count(x => x.UserIdCard == model.UserIdCard) > 0) { response.SetFailed("身份证号已存在"); return(Ok(response)); } } if (model.SystemRoleUuid == null && model.SystemRoleUuid.ToString() == "") { response.SetFailed("请选择角色"); return(Ok(response)); } if (ConfigurationManager.HaikanPassport_IfUse) { bool checkregister = false; var obj = SyncInformation.CheckUserName(model.LoginName); if (int.Parse(obj) > 0) { var cum = SyncInformation.CheckUserMail(model.OldCard); if (int.Parse(cum) > 0) { //var cur = SyncInformation.CheckUserRegister(model.LoginName, model.OldCard); var ru = SyncInformation.RegisterUser(model.LoginName, model.PassWord.Trim(), model.OldCard); if (ru == "999") { checkregister = true; } else { if (ru == "-888") { response.SetFailed("系统禁止注册中文用户名"); return(Ok(response)); } if (ru == "-999") { response.SetFailed("当前禁止注册新用户"); return(Ok(response)); } } } else { if (cum == "-4") { response.SetFailed("Email 格式有误"); return(Ok(response)); } if (cum == "-5") { response.SetFailed("Email 不允许注册"); return(Ok(response)); } if (cum == "-6") { response.SetFailed("Email 已经被注册"); return(Ok(response)); } } } else { if (obj == "-1") { response.SetFailed("用户名不合法"); return(Ok(response)); } if (obj == "-2") { response.SetFailed("用户名包含不允许注册的词语"); return(Ok(response)); } if (obj == "-3") { response.SetFailed("用户名已经存在"); return(Ok(response)); } } if (!checkregister) { response.SetFailed("用户统一身份注册失败"); return(Ok(response)); } } var entity = _mapper.Map <UserCreateViewModel, SystemUser>(model); entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); entity.SystemUserUuid = Guid.NewGuid(); entity.IsDeleted = 0; entity.LoginName = model.LoginName; entity.RealName = model.RealName; //entity.PassWord = Haikan3.Utils.DesEncrypt.Encrypt(model.PassWord.Trim(), MdDesEncrypt.SecretKey); entity.PassWord = Security.GenerateMD5(model.PassWord.Trim()); entity.SystemRoleUuid = model.SystemRoleUuid.ToString(); entity.UserIdCard = model.UserIdCard; entity.OldCard = model.OldCard; var rolename = _dbContext.SystemRole.FirstOrDefault(x => x.RoleName == "超级管理员"); if (model.SystemRoleUuid.ToString().Contains(rolename.SystemRoleUuid.ToString())) { entity.UserType = 0; } else { entity.UserType = 2; } _dbContext.SystemUser.Add(entity); _dbContext.SaveChanges(); //entity.SystemRoleUuid = ""; //entity.PassWord = Haikan3.Utils.DesEncrypt.Encrypt(model.PassWord.Trim(), MdDesEncrypt.SecretKey); //for (int i = 0; i < model.SystemRoleUuid.Count; i++) //{ // entity.SystemRoleUuid += model.SystemRoleUuid[i] + ","; //} //entity.SystemRoleUuid = entity.SystemRoleUuid.TrimEnd(','); //entity.OldCard = model.OldCard; //entity.Phone = model.Phone; //_dbContext.SystemUser.Add(entity); //_dbContext.SaveChanges(); _dbContext.Database.ExecuteSqlCommand("DELETE FROM SystemUserRoleMapping WHERE SystemUserUUID={0}", entity.SystemUserUuid); var success = true; if (model.SystemRoleUuid != null) { var roles = new SystemUserRoleMapping(); roles.SystemUserUuid = entity.SystemUserUuid; roles.SystemRoleUuid = model.SystemRoleUuid.Value; roles.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); roles.AddPeople = AuthContextService.CurrentUser.DisplayName; _dbContext.SystemUserRoleMapping.Add(roles); } success = _dbContext.SaveChanges() > 0; if (success) { response.SetSuccess(); } else { _dbContext.Database.ExecuteSqlCommand("DELETE FROM SystemUser WHERE SystemUserUUID={0}", entity.SystemUserUuid); response.SetFailed("保存用户角色数据失败"); } return(Ok(response)); } }