Ejemplo n.º 1
0
        /// <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);
        }
Ejemplo n.º 2
0
        /// <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);
        }