public void EncryptTest() { string toEncrypt = "123456"; string encrypted = EncryptUtils.Encrypt(toEncrypt); Assert.AreNotEqual(toEncrypt, encrypted); }
public bool register(AuthClientDetails clientDetails) { // 客户端的名称和回调地址不能为空 if (!string.IsNullOrEmpty(clientDetails.getClientName()) && !string.IsNullOrEmpty(clientDetails.getRedirectUri())) { // 生成24位随机的clientId string clientId = EncryptUtils.getRandomStr1(24); AuthClientDetails savedClientDetails = authClientDetailsMapper.selectByClientId(clientId); //生成的clientId必须是唯一的 for (int i = 0; i < 10; i++) { if (savedClientDetails == null) { break; } else { clientId = EncryptUtils.getRandomStr1(24); savedClientDetails = authClientDetailsMapper.selectByClientId(clientId); } } // 生成32位随机的clientSecret string clientSecret = EncryptUtils.getRandomStr1(32); DateTime current = new DateTime(); HttpSessionState session = HttpContextUtils.getSession(); User user = (User)session[Constants.SESSION_USER]; // continuing... } }
private void btnSubmit_Click(object sender, EventArgs e) { if (formValid.IsValid) { string loginName = txtLoginName.Text.Trim(); string loginPwd = EncryptUtils.EncryptFromInputString(txtLoginPwd.Text.Trim()); TBUserEntity entity = userManager.GetUserByLoginName(loginName); if (null == entity) { ZMessageBox.Show(this, "用户不存在,请联系管理员!", "提示", ZMessageBoxIcon.Information, ZMessageBoxButtons.OK); this.DialogResult = DialogResult.None; } else { if (entity.UserPassword.Equals(loginPwd)) { ZMessageBox.Show(this, "登录成功!", "提示", ZMessageBoxIcon.Information, ZMessageBoxButtons.OK); this.CurrentLoginUser = entity; this.DialogResult = DialogResult.OK; this.Close(); } else { ZMessageBox.Show(this, "密码错误,请重新输入!", "提示", ZMessageBoxIcon.Information, ZMessageBoxButtons.OK); this.DialogResult = DialogResult.None; } } } }
public ActionResult UpdateUser(User user) { try { if (user != null) { user.UserPassword = EncryptUtils.Base64Encrypt(user.UserPassword); if (UserRepository.Update(user)) { return(Json(new { Success = true })); } } return(Json(new { Success = false })); } catch (Exception ex) { LogRepository.Add(new EventLog() { Name = Session["LoginedUser"].ToString(), Date = DateTime.Now.ToLocalTime(), Event = "修改用户资料失败" + ex.Message }); return(Json(new { Success = false })); } }
public ActionResult CheckUserLogin(string username, string password) { string msg = string.Empty; COM_User user; username = HttpUtility.UrlEncode(username.Trim()); password = password.Trim(); HttpCookie cookie = new HttpCookie("user"); user = icom_userbll.GetEntity(username); if (user == null) { msg = "1"; } else if (user.Password == EncryptUtils.MD5Encrypt(password)) { msg = "2"; cookie.Values.Add("Username", HttpUtility.UrlEncode(user.Username)); cookie.Values.Add("Code", user.Code); cookie.Values.Add("Name", HttpUtility.UrlEncode(user.Name)); cookie.Values.Add("Tel", user.Tel); cookie.Values.Add("Role", HttpUtility.UrlEncode(user.Role)); cookie.Values.Add("Address", HttpUtility.UrlEncode(user.Address)); cookie.Values.Add("Department", HttpUtility.UrlEncode(user.Department)); cookie.Values.Add("IP", user.IP); cookie.Expires = DateTime.Now.AddDays(7); Response.SetCookie(cookie); } else { msg = "3"; } return(Content(msg)); }
private static void SaveObjToPersistant(int index) { if (DataCashe.objectsToPersist[index] == null) { Debug.LogWarning($"[PS] Saving failed. Object[{index}] is null"); return; } string json = JsonUtility.ToJson(DataCashe.objectsToPersist[index]); SaveFile(GetPersistantPath(DataCashe.objectsToPersist[index]), json); SaveFile(GetPersistantPathHash(DataCashe.objectsToPersist[index]), (json.GetHashCode() ^ DataCashe.hashSalt).ToString()); Debug.Log("[PS] Save:\n " + DataCashe.objectsToPersist[index].name); void SaveFile(string path, string data) { BinaryFormatter bf = new BinaryFormatter(); FileStream file = File.Create(path); data = EncryptUtils.EncryptString(data, DataCashe.key); bf.Serialize(file, data); file.Close(); } }
public ActionResult Edit(int id) { ViewBag.CurrentUser = CurrentUser; ViewBag.Department = DepartmentBO.GetAll(); var user = UserBO.GetById(id); if (user == null) { return(RedirectToAction("NotFound", "Home")); } var model = new UserModel() { Id = user.Id, UserName = user.UserName, FirstName = user.FirstName, LastName = user.LastName, Password = EncryptUtils.Decrypt(user.Password), Address = user.Address, Avatar = user.Avatar, DateOfBirth = user.DateOfBirth.ToString("dd/MM/yyyy"), DepartmentId = user.DepartmentId, Gender = user.Gender, Email = user.Email, Mission = user.Mission, IsActive = user.IsActive, IsAdmin = user.IsAdmin }; return(View("Create", model)); }
public override void Add(Sys_User item) { //item.UserId = User.GenerateNewGuid(); //item.UserId = EntityBase.GenerateNewGuid(); item.CreateBy = !CUtils.IsNullOrEmpty(item.CreateBy) ? CUtils.StrTrim(item.CreateBy) : "SYS"; var salt = EncryptUtils.GenerateSalt(); var password = EncryptUtils.EncryptPassword(item.Password, salt); item.Password = password.Trim(); item.PasswordSalt = salt.Trim(); string userCode = null; bool isSysAdmin = false; if (!CUtils.IsNullOrEmpty(item.UserCode)) { userCode = CUtils.StrToUpper(item.UserCode); // chỉ tồn tại duy nhất 1 SysAdmin => set = false (mặc định nếu tài khoản tạo mới có usercode là SYSADMIN thì set = true) if (userCode.Equals("SYSADMIN")) { isSysAdmin = true; } } item.FlagActive = true; // mặc định khi tạo mới tài khoản đc Active luôn item.IsSysAdmin = isSysAdmin; base.Add(item); }
public static void SetChildCookies(View_Simple_StuInfo child) { if (HttpContext.Current.Request.Cookies["ChildInfo"] != null) { HttpCookie cookie = HttpContext.Current.Request.Cookies["ChildInfo"]; cookie.Values["childareacode"] = EncryptUtils.Base64Encrypt(child.XZQHM ?? ""); cookie.Values["childxxid"] = EncryptUtils.Base64Encrypt(child.xxid.ToString()); cookie.Values["childxxmc"] = EncryptUtils.Base64Encrypt(child.XXMC ?? ""); cookie.Values["childbjid"] = EncryptUtils.Base64Encrypt(child.BJID.ToString()); cookie.Values["childbjmc"] = EncryptUtils.Base64Encrypt(child.bjmc ?? ""); cookie.Values["childuserid"] = EncryptUtils.Base64Encrypt(child.xsid.ToString()); cookie.Values["childusername"] = EncryptUtils.Base64Encrypt(child.XM); HttpContext.Current.Response.AppendCookie(cookie); } else { HttpCookie cookie = new HttpCookie("ChildInfo"); cookie.Values.Add("childareacode", EncryptUtils.Base64Encrypt(child.XZQHM ?? "")); cookie.Values.Add("childxxid", EncryptUtils.Base64Encrypt(child.xxid.ToString())); cookie.Values.Add("childxxmc", EncryptUtils.Base64Encrypt(child.XXMC ?? "")); cookie.Values.Add("childbjid", EncryptUtils.Base64Encrypt(child.BJID.ToString())); cookie.Values.Add("childbjmc", EncryptUtils.Base64Encrypt(child.bjmc ?? "")); cookie.Values.Add("childuserid", EncryptUtils.Base64Encrypt(child.xsid.ToString())); cookie.Values.Add("childusername", EncryptUtils.Base64Encrypt(child.XM)); HttpContext.Current.Response.AppendCookie(cookie); } }
public async Task <IHttpActionResult> Login([FromBody] LoginModel model) { try { var message = await AccountService.CheckAccountVilidate(model.UserName, model.Password); if (message.ResulType == ValidateType.None) { #if DEBUG string header = JsonConvert.SerializeObject(message.Cookie); #else string header = AesEncryptHelper.EncryptAes(EncryptUtils.Base64Encrypt(JsonConvert.SerializeObject(message.Cookie))); #endif var result = new TokenModel() { AuthHeader = header, RespMessage = message.ResulType.ToString() }; return(Json(result)); } return(BadRequest(message.Message)); } catch (Exception e) { var errorId = Guid.NewGuid().Str(); LogHelper.Error(errorId, e); return(Json(new { message = $@"发生未知错误,请联系管理员,错误代码:{errorId}" })); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Session_End(object sender, EventArgs e) { try { var a = sender.ToJson(); string LoginProvider = GrobalConfig.LoginProvider; string LoginUserKey = GrobalConfig.LoginUserKey; if (Session[LoginUserKey] != null) { //清理redis中的用户数据 UserModel user = UserUtils.Provider.Current(); if (user != null) { List <ClientEntity> clients = ClientUtils.Provider.getAllAuthClient(user.UserId).ToList(); ClientUtils.Provider.LogoutAllAction(user, clients, ""); //清理redis UserUtils.Provider.EmptyCurrentRedis(); } //清理session中的用户数据 user = EncryptUtils.doDecrypt(Session[LoginUserKey].ToString()).ToObject <UserModel>(); if (user != null) { UserUtils.Provider.EmptyCurrentSession(); } } } catch (Exception ex) { LogUtils.myError(log, ex); } }
private void btnSave_Click(object sender, EventArgs e) { if (formValid.IsValid) { DASP.Domain.Entitys.TBUserEntity curUser = Global.UserInfoInstance.CurrentLoginUser; string oldPwd = EncryptUtils.EncryptFromInputString(txtProtoPwd.Text.Trim()); if (!curUser.UserPassword.Equals(oldPwd)) { ZMessageBox.Show(this, "旧密码输入错误!", "提示", ZMessageBoxIcon.Information, ZMessageBoxButtons.OK); this.DialogResult = DialogResult.None; return; } curUser.UserPassword = EncryptUtils.EncryptFromInputString(txtNewPwd.Text.Trim()); try { userManager.Update(curUser); ZMessageBox.Show(this, "修改密码成功!", "提示", ZMessageBoxIcon.Information, ZMessageBoxButtons.OK); this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { throw ex; } } }
/// <summary> /// Json方式 查询订单物流轨迹 /// </summary> /// <param name="expressNo">快递单号</param> /// <param name="expressCode">快递编码</param> /// <returns></returns> public bool IsGetOrderTraces(string expressNo, string expressCode) { var requestData = "{" + string.Format("'OrderCode':'','ShipperCode':'{0}','LogisticCode':'{1}'", expressCode, expressNo) + "}"; var param = new Dictionary <string, string>(); param.Add("RequestData", HttpUtility.UrlEncode(requestData, Encoding.UTF8)); param.Add("EBusinessID", ApiKeyUtils.EBusinessID); param.Add("RequestType", "1002"); var dataSign = EncryptUtils.encrypt(requestData, ApiKeyUtils.AppKey, "UTF-8"); param.Add("DataSign", HttpUtility.UrlEncode(dataSign, Encoding.UTF8)); param.Add("DataType", "2"); var result = HttpUtils.SendPost(ApiKeyUtils.ReqURL, param); //根据公司业务处理返回的信息...... var expressInfo = JsonUtils.JsonToObj <ExpressInfo.ExpresssTraces>(result); //站点轨迹不为空,则该快递编号对应有数据 if (expressInfo != null && expressInfo.State != "0") { return(true); } else { return(false); } }
/// <summary> /// 获取上传数据。 /// </summary> /// <returns></returns> protected override IEnumerable <WorkerAttendance> GetData(object parm) { Worker worker = parm as Worker; // 此处必须固定 1条 const int size = 1; var filtered = cache.Select($"worker_id = { worker.associated.worker_id }"); double d = filtered.Length * 1d / size; int total = (int)Math.Ceiling(d); for (int i = 0; i < total; i++) { yield return(new WorkerAttendance { projectCode = this.workers.projectCode, teamSysNo = this.workers.teamSysNo, dataList = from row in filtered.Skip(i * size).Take(size) select new Attendance { id = Convert.ToInt32(row["record_id"]), idcard = EncryptUtils.Encrypt(worker.associated.id_card, HjApiCaller.Appsecret), date = Convert.ToDateTime(row["record_time"]).ToString("yyyy-MM-dd HH:mm:ss"), direction = Attendance.ConvertDirection(Convert.ToInt32(row["type"])) } }); } }
public bool ChangePassword(string applicationId, string userName, string oldPassword, string newPassword) { if (ValidateUser(applicationId, userName, oldPassword) == false) { return(false); } var user = Get(new User() { UserName = userName }); var salt = EncryptUtils.GenerateSalt(); var password = EncryptUtils.EncryptPassword(newPassword, salt); var comm = this.GetCommand("acc_UserChangePassword"); if (comm == null) { return(false); } comm.AddParameter <string>(this.Factory, "ApplicationId", applicationId); comm.AddParameter <string>(this.Factory, "UserId", user.UserId); comm.AddParameter <string>(this.Factory, "Password", password); comm.AddParameter <string>(this.Factory, "PasswordSalt", salt); return(comm.SafeExecuteNonQuery() != 0); //throw new NotImplementedException(); }
private bool LoadConfig() { try { var fullText = File.ReadAllText(Path); #if !DEBUG if (_requireEncrypt) { fullText = EncryptUtils.Decrypt(fullText); } #endif JSON.Parameters = new JSONParameters() { UsingGlobalTypes = false, //khong con toi uu hoa phan thuc hien chuyen du lieu UseExtensions = _useExtensions, //Set gia tri nay cho da thua ke (mặc định true) UseUTCDateTime = false, //mac dinh thoi gian dang set la UTC nen neu set lan nua thi se mat gia tri SerializeNullValues = false, //khong serialize gia tri = null de giam thieu kich thuoc bo nho }; Config = JSON.ToObject(fullText, ConfigType) as IConfig; if (Config != null) { return(true); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } return(false); }
public bool ResetPassword(string applicationId, string userName) { var user = Get(new User() { UserName = userName }); if (user == null) { return(false); } var salt = EncryptUtils.GenerateSalt(); var rd = new RandomPassword(); var password = rd.Generate(8, 10); password = EncryptUtils.EncryptPassword(password, salt); var comm = GetCommand("acc_UserChangePassword"); if (comm == null) { return(false); } comm.AddParameter <string>(this.Factory, "ApplicationId", applicationId); comm.AddParameter <string>(this.Factory, "UserId", user.UserId); comm.AddParameter <string>(this.Factory, "Password", password); comm.AddParameter <string>(this.Factory, "PasswordSalt", salt); return(comm.SafeExecuteNonQuery() != 0); }
public ActionResult UpdateInfo(FormCollection form) { UCHomeEntities uc = new UCHomeEntities(); UCHome_BaseInfo space = uc.UCHome_BaseInfo.SingleOrDefault(u => u.UserID == loginId); JsonResult jsonResult; if (space != null) { space.NickName = form["NickName"]; space.Section = form["Section"]; space.Subject = form["Subject"]; try { uc.SaveChanges(); HttpCookie cookie = Request.Cookies["SpaceInfo"]; if (cookie != null) { cookie.Values["Subject"] = EncryptUtils.Base64Encrypt(form["Subject"]); Response.AppendCookie(cookie); } else { cookie = new HttpCookie("SpaceInfo"); cookie.Values.Add("Subject", EncryptUtils.Base64Encrypt(form["Subject"])); Response.AppendCookie(cookie); } jsonResult = new JsonResult { Data = new { result = "success", uctype = user.usertype, subject = form["Subject"] } }; return(Json(jsonResult, JsonRequestBehavior.AllowGet)); } catch (Exception) { jsonResult = new JsonResult { Data = new { result = "fail", uctype = "X" } }; return(Json(jsonResult, JsonRequestBehavior.AllowGet)); } } jsonResult = new JsonResult { Data = new { result = "noexist", uctype = "X" } }; return(Json(jsonResult, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 把文件分割为行项目 /// </summary> private void LoadAndSplit() { this.splitContianer = new List <string>(); DirectoryInfo dirInfo = new DirectoryInfo(this.sceneDirectory); foreach (FileInfo finfo in dirInfo.GetFiles()) { if (finfo.Extension != ".sil") { LogUtils.LogLine(String.Format("Ignored file: {0}", finfo.FullName), "YuriIL Convertor", LogLevel.Warning); continue; } // 分割文件为行 LogUtils.LogLine(String.Format("Spliting file: {0}", finfo.FullName), "YuriIL Convertor", LogLevel.Normal); var fs = new FileStream(finfo.FullName, FileMode.Open); var sr = new StreamReader(fs); // 跳过头部 sr.ReadLine(); while (!sr.EndOfStream) { string body; if ((body = sr.ReadLine()) != ">>>YuriEOF" && body != String.Empty) { var deb = EncryptUtils.DecryptString(body, GlobalConfigContext.GAME_KEY); this.splitContianer.Add(deb); } } sr.Close(); fs.Close(); } }
public string GetToken(int userId, string userName) { var now = DateTime.UtcNow; var existingToken = this.GetQueryable().AsNoTracking().FirstOrDefault(x => x.UserId == userId); if (existingToken != null) { if (existingToken.ExpiredTime > now) { return(existingToken.Value); } this.Delete(existingToken.ID); } var randomToken = EncryptUtils.GenerateAccessToken(); var token = new ApplicationUserToken() { StartedTime = now, UserId = userId, Value = randomToken, ExpiredTime = now.AddMinutes(TokenDurationInMinutes) }; this.Insert(token); this.SaveChanges(); return(randomToken); }
public ActionResult ChangePassword(ChangePassword model) { if (ModelState.IsValid) { if (CurrentUser.Password != EncryptUtils.Encrypt(model.OldPassword).Trim()) { ModelState.AddModelError("", "Current password not correct"); return(View()); } if (string.IsNullOrEmpty(model.NewPassword)) { ModelState.AddModelError("", "You must enter your new password"); return(View()); } else { if (model.NewPassword != model.ConfirmPassword) { ModelState.AddModelError("", "Confirm password not correct"); return(View()); } else { UserBO.ChangePassword(CurrentUser.Id, EncryptUtils.Encrypt(model.NewPassword)); CurrentUser.Password = EncryptUtils.Encrypt(model.NewPassword); FormsAuthentication.SetAuthCookie(JsonConvert.SerializeObject(CurrentUser, Formatting.None), false); return(RedirectToAction("MyProfile", "User")); } } } return(View()); }
public async Task <SignInResult> PasswordSignInAsync(string username, string password) { var result = new SignInResult(); var userEntity = await _userRepository.FindByUsernameAsync(username); if (userEntity == null) { result.Message = Constants.Messages.INVALID_LOGIN; return(result); } if (!userEntity.IsActive) { result.Message = Constants.Messages.USER_INACTIVE; return(result); } var salt = userEntity.PasswordSalt; var passwordHash = EncryptUtils.SHA256Encrypt(password, salt); if (passwordHash != userEntity.PasswordHash) { result.Message = Constants.Messages.INVALID_LOGIN; return(result); } result.User = userEntity.ToModel(); result.Success = true; return(result); }
private async ValueTask <string> GenerateInvitationCode(SqlSugarClient context, long senderId, UserAuthority authority) { try { context.BeginTran(); var invitationService = new InvitationService(context); var invitation = new Invitation() { ObjectId = IdGenerator.CreateId(), Authority = authority, CreateTime = DateTime.UtcNow, InvitationCode = EncryptUtils.GenerateRandomString(32), ReceiverId = -1, SenderId = senderId, UsedTime = DateTime.MinValue }; var success = await invitationService.InsertAsync(invitation); context.CommitTran(); return(success ? invitation.InvitationCode : null); } catch (Exception e) { context.RollbackTran(); throw; } }
private void btnLogin_Click(object sender, EventArgs e) { btnLogin.Enabled = false; btnLogin.Text = "登录中..."; string user_name = txtLoginUserName.Text.Trim(); string pwd = EncryptUtils.EncryptString(txtLoginPwd.Text.Trim()); CPUInfo cpuInfo = new CPUInfo(); cpuInfo.GetCPUInfo(); string cpu = cpuInfo.CPUName; string osname = OSVersionInfo.SystemName; Computer cp = Computer.Instance(); string mem = cp.TotalPhysicalMemory; DianCheWebService.EntityUser user = ws.UserLogin(user_name, pwd, cpu, mem, osname); if (user != null) { this.Hide(); FrmMain.CurrentUser = user; FrmMain frmMain = new FrmMain(); frmMain.Show(); } else { MessageBox.Show("登录失败,请检查用户名密码!"); btnLogin.Enabled = true; btnLogin.Text = "登录"; } }
public virtual LoginInfoDto Login(LoginParamDto vm) { LoginInfoDto result = null; if (vm != null && !string.IsNullOrEmpty(vm.Account) && !string.IsNullOrEmpty(vm.Password)) { var repository = this.GetRepository <IUserRepository>(); var id = repository.GetId(vm.Account); if (id > 0) { var m = repository.Get(id); if (m != null) { if (string.IsNullOrEmpty(m.Password)) { if (string.Compare(m.Account, "admin", true) == 0) { m.Password = EncryptUtils.Encrypt("admin"); repository.UpdatePassword(m.Id, m.Password); } else if (string.Compare(m.Account, "sync", true) == 0) { m.Password = EncryptUtils.Encrypt("sync"); repository.UpdatePassword(m.Id, m.Password); } } string pwd = EncryptUtils.Decrypt(m.Password); if (pwd == vm.Password) { result = new LoginInfoDto() { Id = m.Id, Account = m.Account, Name = m.Name, RoleId = m.RoleId, RoleName = "" }; var roleRepository = this.GetRepository <IRoleRepository>(); var role = roleRepository.Get(m.RoleId); if (role != null) { result.RoleName = role.Name; } var roleAuthRepository = this.GetRepository <IRoleAuthRepository>(); result.RoleAuth = roleAuthRepository.GetList(m.RoleId); var user = SessionUtils.UserInfo; user.Id = result.Id; user.Account = result.Account; user.Name = result.Name; user.RoleId = result.RoleId; result.SessionId = user.SessionId; OptionLogService.Instance.Add(OptionLogType.Login, "登录!"); } } } } return(result); }
public async void SetSacnnerResult(string text) { ConfigureLanguage(); if (text != null) { try { //var info = JsonConvert.DeserializeObject<QRInfo>(text); var encripted = EncryptUtils.Desencriptar(text); var values = encripted.Split(';'); var info = new QRInfo() { IdEmpleado = Convert.ToInt32(values[0]), PasaporteColor = values[1], }; long date = Convert.ToInt64(values[2]); if (date >= 0) { info.FechaExpiracion = new DateTime(date); } Locator.Current.GetService <AppSession>().QRInfo = info; navigator.GoResult(); }catch (Exception e) { await Task.Delay(500); View.ShowDialog("qr_no_valid", "msg_ok", null); } } }
const string Private_key = "8673fdd3ea8654b5690c0a501effa328"; // 开发者秘钥 static void Main008(string[] args) { string sData = "siwei"; var result = EncryptUtils.EncryptPm(sData, Private_key); Console.WriteLine(result); }
public bool ValidateUser(string applicationId, string userName, string password) { var user = Get(new User() { UserName = userName }); if (user == null) { return(false); } var enPassword = EncryptUtils.EncryptPassword(password, user.PasswordSalt); var comm = this.GetCommand("acc_UserGetByValidation"); if (comm == null) { return(false); } comm.AddParameter <string>(this.Factory, "ApplicationId", applicationId); comm.AddParameter <string>(this.Factory, "UserName", userName); comm.AddParameter <string>(this.Factory, "Password", enPassword); comm.AddParameter <string>(this.Factory, "PasswordSalt", user.PasswordSalt); var dt = this.GetTable(comm); var list = EntityBase.ParseListFromTable <User>(dt); return(list != null && list.Count == 1); }
/// <summary> /// Authentificate a user /// </summary> /// <param name="name">Name to check</param> /// <param name="password">Password to check</param> /// <returns>A new user or null</returns> public User Authentification(string name, string password) { string sql = "SELECT u.id, u.name, u.password, i.picture, l.lastConnection " + "FROM users AS u " + "JOIN images AS i on i.userId = u.id " + "JOIN logs AS l on u.id = l.userId " + "WHERE u.name = @name AND u.password = @password"; MySqlCommand command = new MySqlCommand(sql, connection); User user = null; string encrypted = EncryptUtils.Encrypt(password.Trim()); command.Parameters.AddWithValue("@name", name.Trim()); command.Parameters.AddWithValue("@password", encrypted); MySqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { user = HydrateUtils.HydrateNewUser(ref reader); } } reader.Close(); return(user); }
public Result RegisterAccount([FromBody] RegisterDTO dto) { Result result = new Result() { code = 1 }; try { #region 验证 if (string.IsNullOrEmpty(dto.FAccount) || string.IsNullOrEmpty(dto.FPwd)) { result.code = 0; result.message = "用户名或密码不可为空"; return(result); } if (string.IsNullOrEmpty(dto.FMobile)) { result.code = 0; result.message = "手机号码不可为空"; return(result); } //用户名是否已存在 if (RegisterBll.CheckAccount(dto.FAccount)) { result.code = 0; result.message = "该用户名已存在"; return(result); } //判断昵称是否已存在 if (RegisterBll.CheckNickName(dto.FNickName)) { result.code = 0; result.message = "该昵称已存在"; return(result); } if (RegisterBll.CheckMobile(dto.FMobile)) { result.code = 0; result.message = "该手机号已存在"; return(result); } #endregion EMobileUser registerInfo = Mapper.Map <RegisterDTO, EMobileUser>(dto); registerInfo.FPwd = EncryptUtils.MD5(registerInfo.FPwd.Trim().ToLower()).ToLower(); registerInfo.FAddTime = DateTime.Now; registerInfo.SaveOnSubmit(); } catch (Exception ex) { LogService.Default.Fatal("提交注册申请报错:" + ex.Message); result.code = 0; result.message = "提交申请失败!请联系客服"; } return(result); }