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));
}
