public ReturnResult <OauthToken> CreateAccessToken(TdMemberDataContract memberInfo)
{
if (null == memberInfo || memberInfo.UserKeyId < 1)
{
return(new ReturnResult <OauthToken>(101, null, "参数memberInfo错误"));
}
OauthToken accessToken = new OauthToken();
accessToken.ClientID = 10001; //目前默认为10001
accessToken.UserKeyId = memberInfo.UserKeyId;
accessToken.AccessToken = CreateToken();
accessToken.Expires = DateTime.Now.Epoch() + ACCESS_TOKEN_EXPIRES;
accessToken.Scope = "all"; //权限默认
accessToken.User = memberInfo;
RefreshTokenDataContract refreshToken = new RefreshTokenDataContract();
refreshToken.ClientID = accessToken.ClientID;
refreshToken.UserKeyID = accessToken.UserKeyId;
refreshToken.RefreshToken = CreateToken();
refreshToken.Expires = DateTime.Now.Epoch() + REFRESH_TOKEN_EXPIRES;
accessToken.RefreshToken = refreshToken.RefreshToken;
TokenRepository.Instance.InsertAccessToken(accessToken);
TokenRepository.Instance.InsertRefreshToken(refreshToken);
return(new ReturnResult <OauthToken>(accessToken));
}
public RefreshTokenDataContract GetRefreshToken(string refreshToken)
{
string sql = "SELECT RefreshToken,ClientId,UserKeyId,Expires FROM refresh_tokens WHERE RefreshToken = @refreshToken";
RefreshTokenDataContract model = null;
using (var dr = SqlHelper.ExecuteReader(SqlHelper.GetConnSting(), CommandType.Text, sql, new SqlParameter("refreshToken", refreshToken)))
{
model = EntityHelper.GetEntity <RefreshTokenDataContract>(dr);
}
return(model);
}
public bool InsertRefreshToken(RefreshTokenDataContract refreshToken)
{
string sql = @"INSERT INTO refresh_tokens(RefreshToken,ClientId,UserKeyId,Expires)
VALUES(@RefreshToken,@ClientId,@UserKeyId,@Expires)" ;
var _parm = new SqlParameter[] {
new SqlParameter("@RefreshToken", refreshToken.RefreshToken),
new SqlParameter("@ClientId", refreshToken.ClientID),
new SqlParameter("@UserKeyId", refreshToken.UserKeyID),
new SqlParameter("@Expires", refreshToken.Expires)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(), CommandType.Text, sql, _parm) > 0);
}
