/// <summary> /// 配置支付请求参数,根据当前小区获取 /// </summary> /// <param name="Row"></param> public WxPayConfig GenerateConfig(string CommunityId) { WxPayConfig wxPayConfig = null; IDbConnection conn = new SqlConnection(PubConstant.UnifiedContionString.ToString()); string query = "SELECT * FROM Tb_WeiXinPayCertificate WHERE CommunityId=@CommunityId"; Tb_WeiXinPayCertificate T = conn.Query <Tb_WeiXinPayCertificate>(query, new { CommunityId = CommunityId }).SingleOrDefault(); if (T != null) { wxPayConfig = new WxPayConfig(); wxPayConfig.APPID = T.appid.ToString(); wxPayConfig.MCHID = T.mch_id.ToString(); wxPayConfig.KEY = T.appkey.ToString(); wxPayConfig.APPSECRET = T.appsecret.ToString(); wxPayConfig.SSLCERT_PATH = T.SSLCERT_PATH; wxPayConfig.SSLCERT_PASSWORD = T.SSLCERT_PASSWORD; wxPayConfig.NOTIFY_URL = Global_Fun.AppWebSettings("WechatPay_Notify_Url").ToString(); } return(wxPayConfig); }
/// <summary> /// 配置支付请求参数,根据当前小区获取 /// </summary> /// <param name="Row"></param> public WxPayConfig GenerateConfig(string CommunityId) { WxPayConfig wxPayConfig = null; string strcon = PubConstant.GetConnectionString("APPConnection"); IDbConnection conn = new SqlConnection(strcon); string query = "SELECT * FROM Tb_WeiXinPayCertificate WHERE CommunityId=@CommunityId"; Tb_WeiXinPayCertificate T = conn.Query <Tb_WeiXinPayCertificate>(query, new { CommunityId = CommunityId }).SingleOrDefault(); if (T != null) { wxPayConfig = new WxPayConfig(); wxPayConfig.APPID = T.appid.ToString(); wxPayConfig.MCHID = T.mch_id.ToString(); wxPayConfig.KEY = T.appkey.ToString(); wxPayConfig.APPSECRET = T.appsecret.ToString(); wxPayConfig.SSLCERT_PATH = T.SSLCERT_PATH; wxPayConfig.SSLCERT_PASSWORD = T.SSLCERT_PASSWORD; wxPayConfig.NOTIFY_URL = PubConstant.GetConnectionString("WeiXinPayBackURL"); } return(wxPayConfig); }