public int InsertAccessToken(DtWechatAccessToken dtWechatAccessToken) { string commandText = @"INSERT INTO [dbo].[WECHAT_ACCESS_TOKEN] ( [SYSTEM_INSERT_DATETIME], [SYSTEM_STATUS], [ACCESS_TOKEN], [EXPIRES_IN], [FK_WECHAT_BASIC_DATA_PK_ID] ) VALUES ( GETDATE(), 0, @ACCESS_TOKEN, @EXPIRES_IN, @FK_WECHAT_BASIC_DATA_PK_ID )"; return this.dbHelper.ExecuteNonQuery ( commandText, new { ACCESS_TOKEN = dtWechatAccessToken.AccessToken, EXPIRES_IN = dtWechatAccessToken.ExpiresIn, FK_WECHAT_BASIC_DATA_PK_ID = dtWechatAccessToken.BasicDataId, } ); }
private DtWechatAccessToken RenewAccessToken(string appId) { DtWechatAccessToken dtWechatAccessToken = null; var var_BasicData = this.bllWechat.GetBasicData(appId); if (var_BasicData == null) { throw new Exception("未配置微信开发的基础数据"); } string requstUri = string.Format(urlAccessToken, var_BasicData.AppId, var_BasicData.AppSecret); HttpClient client = new HttpClient(); AccessTokenModel model_AccessToken = client.GetAsync(requstUri).Result.Content.ReadAsAsync<AccessTokenModel>().Result; if (model_AccessToken != null && (model_AccessToken.ErrCode == null || model_AccessToken.ErrCode == 0)) { dtWechatAccessToken = new DtWechatAccessToken(); dtWechatAccessToken.AccessToken = model_AccessToken.AccessToken; dtWechatAccessToken.ExpiresIn = model_AccessToken.ExpiresIn; dtWechatAccessToken.BasicDataId = var_BasicData.Id; } return dtWechatAccessToken; }
public int UpdateAccessToken(DtWechatAccessToken dtWechatAccessToken) { string commandText = @"UPDATE [dbo].[WECHAT_ACCESS_TOKEN] SET [SYSTEM_UPDATE_DATETIME] = GETDATE(), [ACCESS_TOKEN] = @ACCESS_TOKEN, [EXPIRES_IN] = @EXPIRES_IN WHERE [PK_ID] = @PK_ID"; return this.dbHelper.ExecuteNonQuery ( commandText, new { ACCESS_TOKEN = dtWechatAccessToken.AccessToken, EXPIRES_IN = dtWechatAccessToken.ExpiresIn, PK_ID = dtWechatAccessToken.Id, } ); }
public int PutAccessToken(DtWechatAccessToken dtWechatAccessToken) { var var_Result = this.dalWechat.UpdateAccessToken(dtWechatAccessToken); return var_Result; }
public int PostAccessToken(DtWechatAccessToken dtWechatAccessToken) { var var_Result = this.dalWechat.InsertAccessToken(dtWechatAccessToken); return var_Result; }