public FinanceResponse ChangePassword(UserChangePasswordRequest request) { service.ChagePassword(request.Id, CryptInfoHelper.MD5Encode(CryptInfoHelper.GetDecrypte(request.OldPwd)), CryptInfoHelper.MD5Encode(CryptInfoHelper.GetDecrypte(request.NewPwd))); return(CreateResponse(FinanceResult.SUCCESS)); }
public static bool Verification(string no, string pwd) { pwd = CryptInfoHelper.MD5Encode(pwd); if (DBHelper.DefaultInstance.Exist(string.Format("select 1 from _AccountUser where _no = '{0}' and _pwd = '{1}'", no, pwd))) { return(true); } return(false); }
public IdResponse Save(UserSaveRequest request) { var id = request.Id; var userName = request.UserName; var password = CryptInfoHelper.GetDecrypte(request.PassWord); password = CryptInfoHelper.MD5Encode(password); if (id == 0) { service.AddUser(userName, password); } else { service.ModifyUser(id, userName, password); } return(new IdResponse { id = id }); }
public static void AddUser(string no, string name, string pwd) { if (DBHelper.DefaultInstance.Exist(string.Format("select 1 from _AccountUser where _no = '{0}'", no))) { throw new FinanceException(FinanceResult.RECORD_EXIST); } pwd = CryptInfoHelper.MD5Encode(pwd); long id = 1; var maxId = DBHelper.DefaultInstance.ExecuteScalar("select max(_id) from _AccountUser"); if (maxId != null) { if (long.TryParse(maxId.ToString(), out id)) { id++; } } DBHelper.DefaultInstance.ExecuteSql(string.Format(@"INSERT INTO [_AccountUser]([_id],[_no],[_name],[_pwd],[_lastLoginTime]) VALUES({0},'{1}','{2}','{3}', GETDATE())", id, no, name, pwd)); }
public FinanceResponse Login(UserRequest request) { long userId = 0; var userName = request.UserName; var password = CryptInfoHelper.GetDecrypte(request.PassWord); password = CryptInfoHelper.MD5Encode(password); userId = service.UserVerification(userName, password); if (userId == 0) { throw new FinanceException(FinanceResult.AUTHENTICATION_ERROR); } var tid = request.Tid; var token = OAuth2Handler.CreateToken(userId, userName, tid, DateTime.Now); return(new UserResponse { UserId = userId, UserName = userName, Token = token }); }
public static void ChagePwd(string no, string pwd) { pwd = CryptInfoHelper.MD5Encode(pwd); DBHelper.DefaultInstance.ExecuteSql(string.Format("update _AccountUser set _pwd = '{1}' where _no = '{0}'", no, pwd)); }