public JsonResult BatchAddSubmit(List <UserInfo> list) { var jsonm = new ResultJson(); try { if (list.Count > 0) { var userList = new List <UserInfo>(); foreach (var item in list) { if (!string.IsNullOrEmpty(item.UserPassword)) { item.UserPassword = SHACryptHelper.SHA256Encrypt(item.UserPassword); } var umodel = new UserInfo(); umodel.UserAccount = item.UserAccount; umodel.Mobile = item.Mobile; umodel.Email = item.Email; umodel.CreateTime = DateTime.Now; item.UserID = umodel.UserID; item.CreateTime = umodel.CreateTime; userList.Add(umodel); } using (var db = SugarBase.GetIntance()) { db.Insertable(userList).ExecuteCommand(); } } } catch (Exception ex) { jsonm.status = 500; jsonm.msg = ex.Message; LogProvider.Error("批量添加用户", ex.StackTrace, ex.Message); } jsonm.data = list; return(Json(jsonm)); }
/// <summary> /// 修改密码 /// </summary> /// <param name="UserID"></param> /// <param name="UserPassword"></param> /// <returns></returns> public JsonResult ChangePassSubmit(string QuotaID, string UserID, string UserPassword) { var jsonm = new ResultJson(); UserInfo model = new UserInfo(); try { using (var db = SugarBase.GetIntance()) { if (!string.IsNullOrEmpty(UserID)) { model = db.Queryable <UserInfo>().Where(m => m.UserID == UserID).First(); if (model != null) { if (model.UserID == UserID) { if (!string.IsNullOrEmpty(UserPassword)) { model.UserPassword = SHACryptHelper.SHA256Encrypt(UserPassword); db.Updateable(model).ExecuteCommand(); jsonm.status = 200; } else { jsonm.status = 300; jsonm.msg = "请填写密码"; } } } } } } catch (Exception ex) { LogProvider.Error("修改密码", ex.StackTrace, ex.Message); jsonm.status = 500; jsonm.msg = "保存失败"; } return(Json(jsonm)); }
public JsonResult LoginSubmit(string username, string password, string vercode = "") { var jsonm = new ResultJson(); try { ; var sessionid = CookieHelper.GetCookie("sessionid"); var result = false; if (RedisHelper.KeyExists("imgcode:" + sessionid)) { var code = RedisHelper.StringGet("imgcode:" + sessionid); if (code.Trim().ToUpper() == vercode.Trim().ToUpper()) { result = true; } else { jsonm.status = 500; jsonm.msg = "验证码错误"; } } if (result) { using (var db = SugarBase.GetIntance()) { if (!string.IsNullOrEmpty(username) && !string.IsNullOrEmpty(password)) { var model = db.Queryable <SysUser>().Where(m => m.Status == 1 && m.SysUserName.Equals(username.Trim()) && m.SysUserPwd.Equals(SHACryptHelper.SHA256Encrypt(password))).First(); if (model != null) { var userModel = new AccountToken(); userModel.UserID = model.SysUserID; userModel.UserName = model.SysNickName; var menu_list = db.Queryable <SysModule, SysRoleModule, SysRole, SysUserRole>((sm, srm, sr, sur) => new object[] { JoinType.Left, sm.ID == srm.ModuleID, JoinType.Left, srm.RoleID == sr.RoleID, JoinType.Left, sr.RoleID == sur.RoleID, }) .Where((sm, srm, sr, sur) => sur.UserID == model.SysUserID && sm.Status) .OrderBy((sm, srm, sr, sur) => sm.Sort, OrderByType.Desc) .OrderBy((sm, srm, sr, sur) => sm.CreateTime, OrderByType.Asc) .Select(sm => new SysModule { ID = sm.ID, Href = sm.Href, Business = sm.Business, Icon = sm.Icon, Name = sm.Name, Sort = sm.Sort, Type = sm.Type, ParentID = sm.ParentID }).ToList(); CookieHelper.WriteCookie("systoken", MD5CryptHelper.Encrypt(JsonConvert.Serialize(userModel)), 30); var claims = new[] { new Claim("UserID", model.SysUserID), new Claim("UserName", model.SysNickName) }; var claimsIdentity = new ClaimsIdentity(claims, CookieAuthenticationDefaults.AuthenticationScheme); ClaimsPrincipal user = new ClaimsPrincipal(claimsIdentity); //var identity = new ClaimsIdentity(); //identity.AddClaim(new Claim(ClaimTypes.Sid, userModel.UserID)); //identity.AddClaim(new Claim(ClaimTypes.Name, userModel.UserName)); HttpContextHelper.Current.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, user); userModel.MenuList = menu_list; var daySpan = TimeSpan.FromMinutes(30); RedisHelper.StringSet("system:SysToken:" + userModel.UserID, MD5CryptHelper.Encrypt(JsonConvert.Serialize(userModel)), daySpan); setMenuCache(); SetSysLog("【系统登录】" + userModel.UserName, 1, 1); //HttpContext.Session.SetString("SysToken", MD5CryptHelper.Encrypt(JsonConvert.Serialize(userModel))); jsonm.status = 200; jsonm.msg = "登录成功"; } else { jsonm.status = 500; jsonm.msg = "账号或密码错误"; } } else { jsonm.status = 500; jsonm.msg = "请填写账号信息"; } } } } catch (Exception ex) { jsonm.status = 500; jsonm.msg = "登录失败"; LogProvider.Error("登录", ex.StackTrace, ex.Message); } return(Json(jsonm)); }
/// <summary> /// 添加/编辑 操作 /// </summary> /// <param name="Model"></param> /// <returns></returns> public JsonResult ChangeSubmit(SysUser Model) { var jsonm = new ResultJson(); jsonm.data = Model; var model = new SysUser(); try { using (var db = SugarBase.GetIntance()) { if (!string.IsNullOrEmpty(Model.SysUserID)) { model = db.Queryable <SysUser>().Where(m => m.SysUserID == Model.SysUserID).First(); } model.SysNickName = Model.SysNickName; model.SysUserName = Model.SysUserName; if (!string.IsNullOrEmpty(Model.SysUserPwd)) { model.SysUserPwd = SHACryptHelper.SHA256Encrypt(Model.SysUserPwd);; } if (string.IsNullOrEmpty(Model.SysUserID)) { db.Insertable(model).ExecuteCommand(); jsonm.status = 200; } else { db.Updateable(model).ExecuteCommand(); jsonm.status = 200; } db.Deleteable <SysUserRole>().Where(m => m.UserID == model.SysUserID).ExecuteCommand(); if (Model.RoleList != null) { List <SysUserRole> rel_list = new List <SysUserRole>(); foreach (var item in Model.RoleList) { if (!string.IsNullOrEmpty(item.RoleID)) { var SysUserRoleModel = new SysUserRole(); SysUserRoleModel.RoleID = item.RoleID; SysUserRoleModel.UserID = model.SysUserID; rel_list.Add(SysUserRoleModel); } } if (rel_list.Count > 0) { db.Insertable(rel_list).ExecuteCommand(); } } } } catch (Exception ex) { LogProvider.Error("编辑系统用户", ex.StackTrace, ex.Message); jsonm.status = 500; jsonm.msg = "保存失败"; } return(Json(jsonm)); }
/// <summary> /// 编辑 /// </summary> /// <param name="UserID"></param> /// <param name="NickName"></param> /// <param name="FullName"></param> /// <param name="UserAccount"></param> /// <param name="UserPassword"></param> /// <param name="Email"></param> /// <param name="Mobile"></param> /// <param name="Remark"></param> /// <param name="Status"></param> /// <param name="State"></param> /// <param name="Gender"></param> /// <returns></returns> public JsonResult ChangeSubmit(UserInfo Model) { var jsonm = new ResultJson(); UserInfo umodel = new UserInfo(); UserInfo rmodel = new UserInfo(); try { using (var db = SugarBase.GetIntance()) { if (!string.IsNullOrEmpty(Model.UserID)) { umodel = db.Queryable <UserInfo>().Where(m => m.UserID == Model.UserID).First(); } if (umodel == null) { umodel = new UserInfo(); } if (!string.IsNullOrEmpty(umodel.UserAccount)) { if (string.IsNullOrEmpty(Model.UserAccount)) { Model.UserAccount = umodel.UserAccount; } if (umodel.UserAccount != Model.UserAccount) { Model.UserAccount = umodel.UserAccount; } } var UserAccount2 = ""; if (string.IsNullOrEmpty(Model.UserAccount)) { UserAccount2 = GetUserAccount(9, true, false, false); Model.UserAccount = "zkey" + UserAccount2; } umodel.UserAccount = Model.UserAccount; rmodel.UserAccount = Model.UserAccount; if (!string.IsNullOrEmpty(Model.UserPassword)) { rmodel.UserPassword = SHACryptHelper.SHA256Encrypt(Model.UserPassword); } else if (string.IsNullOrEmpty(rmodel.UserID)) { jsonm.status = 500; jsonm.msg = "新添加用户,密码不能为空"; return(Json(jsonm)); } umodel.FullName = Model.FullName; umodel.Email = Model.Email; umodel.Mobile = Model.Mobile; umodel.Gender = Model.Gender; umodel.Remark = Model.Remark; umodel.Status = Model.Status; //每个站点对应的用户信息 var userCount = 0; if (string.IsNullOrEmpty(Model.UserID)) { userCount = db.Queryable <UserInfo>().Where(m => m.Mobile == rmodel.Mobile || m.Email == rmodel.Email).Count(); if (userCount <= 0) { umodel.CreateTime = DateTime.Now; db.Insertable(umodel).ExecuteCommand(); jsonm.status = 200; } else { jsonm.status = 500; jsonm.msg = "手机号或邮箱已存在"; } } else { userCount = db.Queryable <UserInfo>().Where(m => (m.Mobile == rmodel.Mobile || m.Email == rmodel.Email) && m.UserID == rmodel.UserID).Count(); if (userCount > 1) { jsonm.status = 500; jsonm.msg = "用户已存在"; } else { db.Updateable(umodel).ExecuteCommand(); jsonm.status = 200; } } } } catch (Exception ex) { LogProvider.Error("编辑用户", ex.StackTrace, ex.Message); jsonm.status = 500; jsonm.msg = ex.Message; } return(Json(jsonm)); }