protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (!string.IsNullOrEmpty(HotelCloud.Common.HCRequest.GetString("state").Trim()))
                {
                    state = HotelCloud.Common.HCRequest.GetString("state").Trim();
                    code  = HotelCloud.Common.HCRequest.GetString("code").Trim();
                    type  = state.Split('|')[1].ToString();                              //对应类型
                    hid   = Regex.Replace(state.Split('|')[0].ToUpper(), @"[^\d]*", ""); //对应酒店id
                    var dt = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 hotel.WeiXinID,SubName,hotelLog,hotel.address,hotel.id,appkey,appid,MCHID,iszhifu  from WeiXin..hotel with(nolock)  inner join WeiXin..WeiXinNO with(nolock)  on WeiXinNO.WeiXinID=hotel.WeiXinID  where hotel.id=@id and hotel.enabled=1", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                        { "id", new HotelCloud.SqlServer.DBParam {
                              ParamValue = hid.Trim()
                          } }
                    });
                    if (dt.Rows.Count > 0)
                    {
                        foreach (System.Data.DataRow dr in dt.Rows)
                        {
                            subname  = dr["SubName"].ToString().Trim();
                            WeiXinID = dr["WeiXinID"].ToString().Trim();
                        }
                    }
                }
                /** ================客人实时付款微信下单操作========= */
                if (HotelCloud.Common.HCRequest.GetString("state") != "" && !string.IsNullOrEmpty(HotelCloud.Common.HCRequest.GetString("price")))
                {
                    System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
                    string result = js.Serialize(new { status = false, msg = "非法操作" });
                    try
                    {
                        WeiXinID = HotelCloud.Common.HCRequest.GetString("weixinid");
                        hid      = HotelCloud.Common.HCRequest.GetString("hid");
                        if (HotelCloud.Common.HCRequest.GetString("type").Trim().ToString() == "0") //表示客房消费操作
                        {
                            var dty = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 appkey,appid,MCHID from WeiXin..WeiXinNO with(nolock)  where WeiXinID=@WeiXinID and iszhifu=1", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                                { "WeiXinID", new HotelCloud.SqlServer.DBParam {
                                      ParamValue = WeiXinID.Trim()
                                  } }
                            });
                            if (dty.Rows.Count > 0)
                            {
                                foreach (System.Data.DataRow dry in dty.Rows)
                                {
                                    appid  = dry["appid"].ToString().Trim();
                                    secret = dry["appkey"].ToString().Trim();
                                    mchid  = dry["MCHID"].ToString().Trim();
                                }
                            }
                        }
                        hotel3g.Models.Cookies.SetCookies("tb1", WxPayAPI.WxPayConfig.Encrypt(appid), 1, "wx");
                        hotel3g.Models.Cookies.SetCookies("tb2", WxPayAPI.WxPayConfig.Encrypt(secret), 1, "wx");
                        hotel3g.Models.Cookies.SetCookies("tb3", WxPayAPI.WxPayConfig.Encrypt(mchid), 1, "wx");
                        openid = "";

                        /** ================二次付款的相关问题==== */
                        if (string.IsNullOrEmpty(openid) && Session["openid"] != null)
                        {
                            openid = Session["openid"].ToString();
                        }

                        /** ================获取公众号对应的用户openid=====这里会存在多次获去openid的情况 但是实际上这个是不被允许的==== */
                        if (string.IsNullOrEmpty(openid))
                        {
                            var    checkTokenUrl = string.Format("https://api.weixin.qq.com/sns/oauth2/access_token?appid={0}&secret={1}&code={2}&grant_type=authorization_code", appid, secret, HotelCloud.Common.HCRequest.GetString("code"));
                            string CReturnJson   = HotelHotel.Utility.HttpWebResponseUtility.Get(checkTokenUrl);
                            WxPayAPI.Log.Debug("获取openid".ToString(), CReturnJson);
                            wxcheckTokenUrl m = Newtonsoft.Json.JsonConvert.DeserializeObject <wxcheckTokenUrl>(CReturnJson);
                            if (m != null)
                            {
                                openid = m.openid;
                            }
                            Session["openid"] = openid.Trim();
                        }
                        if (!string.IsNullOrEmpty(openid))
                        {
                            try
                            {
                                System.Net.ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls;
                                WebClient    Client = new WebClient();
                                string       json   = Client.DownloadString(string.Format("http://www.weikeniu.com/WeixinFeatures/getGetTokenResult.ashx?appid={0}", appid)).Replace("\\", "").Replace("\"{", "{").Replace("}\"", "}");
                                tAccessToken token  = Newtonsoft.Json.JsonConvert.DeserializeObject <tAccessToken>(json);
                                if (token.error == 1)
                                {
                                    string url     = string.Format("https://api.weixin.qq.com/cgi-bin/user/info?access_token={0}&openid={1}&lang=zh_CN", token.message.ToString(), openid);
                                    string result1 = HotelHotel.Utility.HttpWebResponseUtility.Get(url);
                                    WxPayAPI.Log.Debug("获取用户基本信息", result1.ToString());
                                    Newtonsoft.Json.Linq.JObject outputObj1 = Newtonsoft.Json.Linq.JObject.Parse(result1);
                                    if (outputObj1 != null)
                                    {
                                        /** ================微信收银台 记录对应的客人信息 便于收银台展示对应的客人信息========= */
                                        Nickname = outputObj1["nickname"].ToString();
                                        var dw = HotelCloud.SqlServer.SQLHelper.Get_DataTable(string.Format("select  * from  WeiXin..wkn_unionmember with(nolock) where openid='{0}'", outputObj1["openid"].ToString().Trim('"')), HotelCloud.SqlServer.SQLHelper.Open_Conn(System.Configuration.ConfigurationManager.ConnectionStrings["sqlserver"].ConnectionString.ToString()), null);
                                        if (dw.Rows.Count < 1)
                                        {
                                            HotelCloud.SqlServer.SQLHelper.Run_SQL("insert into WeiXin..wkn_unionmember(openid,nickname,city,province,headimgurl,subscribe_time) values (@openid,@nickname,@city,@province,@headimgurl,@subscribe_time)", HotelCloud.SqlServer.SQLHelper.Open_Conn(System.Configuration.ConfigurationManager.ConnectionStrings["sqlserver"].ConnectionString.ToString()), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                                                { "openid", new HotelCloud.SqlServer.DBParam {
                                                      ParamValue = outputObj1["openid"].ToString().Trim('"')
                                                  } },
                                                { "nickname", new HotelCloud.SqlServer.DBParam {
                                                      ParamValue = outputObj1["nickname"].ToString().Trim('"')
                                                  } },
                                                { "city", new HotelCloud.SqlServer.DBParam {
                                                      ParamValue = outputObj1["city"].ToString().Trim('"')
                                                  } },
                                                { "province", new HotelCloud.SqlServer.DBParam {
                                                      ParamValue = outputObj1["province"].ToString().Trim('"')
                                                  } },
                                                { "headimgurl", new HotelCloud.SqlServer.DBParam {
                                                      ParamValue = outputObj1["headimgurl"].ToString().Trim('"')
                                                  } },
                                                { "subscribe_time", new HotelCloud.SqlServer.DBParam {
                                                      ParamValue = outputObj1["subscribe_time"].ToString()
                                                  } }
                                            });
                                        }
                                    }
                                }
                            }
                            catch (Exception ex)
                            {
                                WxPayAPI.Log.Debug("获取用户基本信息", ex.Message.ToString());
                            }
                            finally
                            {
                            }
                        }
                        string pay_type = HotelCloud.Common.HCRequest.GetString("type");
                        if (string.IsNullOrEmpty(pay_type))
                        {
                            pay_type = "0";
                        }
                        int total_fee = Convert.ToInt32((Convert.ToDecimal(HotelCloud.Common.HCRequest.GetString("price")) * 100));

                        //主要是下单时需要openid>>静默获去到》》但是这样是需要code>>但是就是存在跳转的问题

                        string             OrderNo = "wx" + DateTime.Now.ToString("yyMMddHHmmss") + new Random().Next(100, 0x3e7);
                        WxPayAPI.WxPayData data    = new WxPayAPI.WxPayData();
                        data.SetValue("body", HotelCloud.Common.HCRequest.GetString("hname"));
                        data.SetValue("attach", hid + "|" + WeiXinID + "|" + pay_type);
                        data.SetValue("out_trade_no", OrderNo);
                        data.SetValue("total_fee", total_fee);
                        data.SetValue("time_start", DateTime.Now.ToString("yyyyMMddHHmmss"));
                        data.SetValue("time_expire", DateTime.Now.AddMinutes(10).ToString("yyyyMMddHHmmss"));
                        data.SetValue("goods_tag", "门店销售");
                        data.SetValue("trade_type", "JSAPI");
                        data.SetValue("openid", openid);
                        WxPayAPI.JsApiPay jsApiPay = new WxPayAPI.JsApiPay();
                        jsApiPay.openid    = openid;
                        jsApiPay.total_fee = total_fee;
                        WxPayAPI.WxPayData unifiedOrderResult = jsApiPay.GetUnifiedOrderResult(data);
                        result = js.Serialize(new { status = true, msg = "统一下单成功", signature = jsApiPay.GetJsApiParameters(), TradeNo = OrderNo });

                        //需要保留对应的表数据wkn_quickpayment相关数据
                        string sql = "insert into WeiXin..wkn_quickpayment (WeiXinID,OrderNo,ConsumptionType,ConsumptionContent,OtherRemarks,PaymentStatus,AliPayAmount) values(@WeiXinID,@OrderNo,@ConsumptionType,@ConsumptionContent,@OtherRemarks,'未支付',@AliPayAmount)";
                        int    drt = HotelCloud.SqlServer.SQLHelper.Run_SQL(sql, HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                            { "ConsumptionType", new HotelCloud.SqlServer.DBParam {
                                  ParamValue = pay_type.ToString()
                              } },
                            { "ConsumptionContent", new HotelCloud.SqlServer.DBParam {
                                  ParamValue = HotelCloud.Common.HCRequest.GetString("subContent")
                              } },
                            { "OtherRemarks", new HotelCloud.SqlServer.DBParam {
                                  ParamValue = ""
                              } },
                            { "WeiXinID", new HotelCloud.SqlServer.DBParam {
                                  ParamValue = WeiXinID.ToString()
                              } },
                            { "AliPayAmount", new HotelCloud.SqlServer.DBParam {
                                  ParamValue = total_fee.ToString()
                              } },
                            { "OrderNo", new HotelCloud.SqlServer.DBParam {
                                  ParamValue = OrderNo.ToString()
                              } }
                        });
                        WxPayAPI.Log.Debug("Fastcollection", result.ToString());
                    }
                    catch (Exception ex)
                    {
                        result = js.Serialize(new { status = false, msg = "支付失败" });
                        WxPayAPI.Log.Debug("Fastcollection", ex.Message.ToString());
                    }
                    finally
                    {
                        Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(result));
                        Response.End();
                    }
                }
            }
        }
        public void postweixin(string code, string state)
        {
            if (!string.IsNullOrEmpty(code) && !string.IsNullOrEmpty(state))
            {
                string openid = "", weixinstr = "";
                bool   boocuy = true;

                /** ================会员卡销售支付========= */
                if (state.Contains("K"))
                {
                    var dt = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 * from WeiXin..MemberCardBuyRecord where OrderNo=@OrderId", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                        { "OrderId", new HotelCloud.SqlServer.DBParam {
                              ParamValue = state
                          } }
                    });
                    if (dt.Rows.Count > 0)
                    {
                        foreach (System.Data.DataRow dr in dt.Rows)
                        {
                            openid = getopenid(dr["weixinId"].ToString().Trim(), code);
                            var weixinstrtable = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 weixintype,edition from  WeiXin..WeiXinNO where WeiXinID=@WeiXinID", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                                { "WeiXinID", new HotelCloud.SqlServer.DBParam {
                                      ParamValue = dr["weixinId"].ToString().Trim()
                                  } }
                            });
                            if (weixinstrtable != null)
                            {
                                if (weixinstrtable.Rows.Count > 0)
                                {
                                    foreach (System.Data.DataRow rd in weixinstrtable.Rows)
                                    {
                                        /** ================判断公众号认证情况========= */
                                        weixinstr = rd["weixintype"].ToString();
                                        edition   = rd["edition"].ToString();
                                    }
                                }
                            }
                            if ((string.IsNullOrEmpty(weixinstr) || (weixinstr != "2" && weixinstr != "4")) && dr["weixinId"].ToString().Trim() == "gh_def2f166ed9e")
                            {
                                /** ================未认证情况 进行调整到二维码扫描支付========= */
                                Response.Redirect("http://hotel.weikeniu.com/WeiXinZhiFu/qrcode.aspx?OrderNo=" + dr["OrderNo"].ToString().Trim(), false);
                            }
                            else
                            {
                                int total_fee = Convert.ToInt32(Convert.ToDecimal(dr["BuyMoney"].ToString()) * 100);

                                /** ================Ashbur微信号对应支付金额 0.01元========= */
                                if (openid == "oPfrcjmqyO33T8a8Dn21Kq-QMAcg")
                                {
                                    total_fee = 1;
                                }
                                if (openid == "oUM4bwdTr3DXhUkGf43lGiipmxMA")
                                {
                                    total_fee = 1;
                                }
                                if (openid == "oZLQzv-cg1KvGmrTnq0xdxhK-4kc")
                                {
                                    total_fee = 1;
                                }

                                if (string.IsNullOrEmpty(openid))
                                {
                                    WxPayAPI.Log.Error(this.GetType().ToString(), "wxOAuthRedirect|This page have not get params, cannot be inited, exit...");
                                }
                                else
                                {
                                    HotelID      = dr["HotelId"].ToString().Trim();
                                    UserWeiXinID = dr["userWeixinId"].ToString().Trim();
                                    WeiXinID     = dr["weixinId"].ToString().Trim();

                                    WxPayAPI.WxPayData data = new WxPayAPI.WxPayData();
                                    data.SetValue("body", "会员卡购买");
                                    data.SetValue("attach", "presale");
                                    data.SetValue("out_trade_no", dr["OrderNo"].ToString().Trim());
                                    data.SetValue("total_fee", total_fee);
                                    data.SetValue("time_start", DateTime.Now.ToString("yyyyMMddHHmmss"));
                                    data.SetValue("time_expire", DateTime.Now.AddMinutes(30).ToString("yyyyMMddHHmmss"));
                                    data.SetValue("goods_tag", "会员卡消费");
                                    data.SetValue("trade_type", "JSAPI");
                                    data.SetValue("openid", openid);
                                    WxPayAPI.JsApiPay jsApiPay = new WxPayAPI.JsApiPay();
                                    jsApiPay.openid    = openid;
                                    jsApiPay.total_fee = total_fee;
                                    WxPayAPI.WxPayData unifiedOrderResult = jsApiPay.GetUnifiedOrderResult(data);
                                    wxJsApiParam = jsApiPay.GetJsApiParameters();
                                    WxPayAPI.Log.Debug(this.GetType().ToString(), "wxJsApiParam : " + wxJsApiParam);
                                }
                            }
                        }
                    }
                    else
                    {
                        WxPayAPI.Log.Debug(this.GetType().ToString(), "无效订单或者非预订订单");
                    }
                    boocuy = false;
                    return;
                }

                /** ================酒店周边购物消费========= */
                if (state.Contains("D"))
                {
                    var dt = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 * from WeiXin..SupermarketOrder_Levi where OrderId=@OrderId", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                        { "OrderId", new HotelCloud.SqlServer.DBParam {
                              ParamValue = state
                          } }
                    });
                    if (dt.Rows.Count > 0)
                    {
                        foreach (System.Data.DataRow dr in dt.Rows)
                        {
                            openid = getopenid(dr["weixinID"].ToString().Trim(), code);
                            var weixinstrtable = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 weixintype,edition from  WeiXin..WeiXinNO where WeiXinID=@WeiXinID", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                                { "WeiXinID", new HotelCloud.SqlServer.DBParam {
                                      ParamValue = dr["weixinID"].ToString().Trim()
                                  } }
                            });
                            if (weixinstrtable != null)
                            {
                                if (weixinstrtable.Rows.Count > 0)
                                {
                                    foreach (System.Data.DataRow rd in weixinstrtable.Rows)
                                    {
                                        /** ================判断公众号认证情况========= */
                                        weixinstr = rd["weixintype"].ToString();
                                        edition   = rd["edition"].ToString();
                                    }
                                }
                            }
                            if ((string.IsNullOrEmpty(weixinstr) || (weixinstr != "2" && weixinstr != "4")) && dr["weixinID"].ToString().Trim() == "gh_def2f166ed9e")
                            {
                                Response.Redirect("http://hotel.weikeniu.com/WeiXinZhiFu/qrcode.aspx?OrderNo=" + dr["OrderId"].ToString().Trim(), false);
                            }
                            else
                            {
                                int total_fee = Convert.ToInt32(Convert.ToDecimal(dr["Money"].ToString()) * 100);

                                /** ================Ashbur微信号对应支付金额 0.01元========= */
                                if (openid == "oPfrcjmqyO33T8a8Dn21Kq-QMAcg")
                                {
                                    total_fee = 1;
                                }
                                if (openid == "oUM4bwdTr3DXhUkGf43lGiipmxMA")
                                {
                                    total_fee = 1;
                                }
                                if (openid == "oZLQzv-cg1KvGmrTnq0xdxhK-4kc")
                                {
                                    total_fee = 1;
                                }

                                if (string.IsNullOrEmpty(openid))
                                {
                                    WxPayAPI.Log.Error(this.GetType().ToString(), "wxOAuthRedirect|This page have not get params, cannot be inited, exit...");
                                }
                                else
                                {
                                    HotelID      = dr["HotelId"].ToString().Trim();
                                    UserWeiXinID = dr["userweixinID"].ToString().Trim();
                                    WeiXinID     = dr["weixinID"].ToString().Trim();

                                    WxPayAPI.WxPayData data = new WxPayAPI.WxPayData();
                                    data.SetValue("body", "酒店周边购物消费");
                                    data.SetValue("attach", "presale");
                                    data.SetValue("out_trade_no", dr["OrderId"].ToString().Trim());
                                    data.SetValue("total_fee", total_fee);
                                    data.SetValue("time_start", DateTime.Now.ToString("yyyyMMddHHmmss"));
                                    data.SetValue("time_expire", DateTime.Now.AddMinutes(30).ToString("yyyyMMddHHmmss"));
                                    data.SetValue("goods_tag", "酒店周边购物消费");
                                    data.SetValue("trade_type", "JSAPI");
                                    data.SetValue("openid", openid);
                                    WxPayAPI.JsApiPay jsApiPay = new WxPayAPI.JsApiPay();
                                    jsApiPay.openid    = openid;
                                    jsApiPay.total_fee = total_fee;
                                    WxPayAPI.WxPayData unifiedOrderResult = jsApiPay.GetUnifiedOrderResult(data);
                                    wxJsApiParam = jsApiPay.GetJsApiParameters();
                                    WxPayAPI.Log.Debug(this.GetType().ToString(), "wxJsApiParam : " + wxJsApiParam);
                                }
                            }
                        }
                    }
                    else
                    {
                        WxPayAPI.Log.Debug(this.GetType().ToString(), "无效订单或者非预订订单");
                    }
                    boocuy = false;
                    return;
                }

                /** ================充值卡消费========= */
                if (state.Contains("C"))
                {
                    var dt = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 * from WeiXin..RechargeUser where OrderNo=@OrderNo", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                        { "OrderNo", new HotelCloud.SqlServer.DBParam {
                              ParamValue = state
                          } }
                    });
                    if (dt.Rows.Count > 0)
                    {
                        foreach (System.Data.DataRow dr in dt.Rows)
                        {
                            openid = getopenid(dr["HotelWeiXinId"].ToString().Trim(), code);
                            var weixinstrtable = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 weixintype,edition from  WeiXin..WeiXinNO where WeiXinID=@WeiXinID", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                                { "WeiXinID", new HotelCloud.SqlServer.DBParam {
                                      ParamValue = dr["HotelWeiXinId"].ToString().Trim()
                                  } }
                            });
                            if (weixinstrtable != null)
                            {
                                if (weixinstrtable.Rows.Count > 0)
                                {
                                    foreach (System.Data.DataRow rd in weixinstrtable.Rows)
                                    {
                                        /** ================判断公众号认证情况========= */
                                        weixinstr = rd["weixintype"].ToString();
                                        edition   = rd["edition"].ToString();
                                    }
                                }
                            }
                            if ((string.IsNullOrEmpty(weixinstr) || (weixinstr != "2" && weixinstr != "4")) && dr["HotelWeiXinId"].ToString().Trim() == "gh_def2f166ed9e")
                            {
                                Response.Redirect("http://hotel.weikeniu.com/WeiXinZhiFu/qrcode.aspx?OrderNo=" + dr["OrderNo"].ToString().Trim(), false);
                            }
                            else
                            {
                                int total_fee = Convert.ToInt32(Convert.ToDecimal(dr["SPrice"].ToString()) * 100);

                                /** ================Ashbur微信号对应支付金额 0.01元========= */
                                if (openid == "oPfrcjmqyO33T8a8Dn21Kq-QMAcg")
                                {
                                    total_fee = 1;
                                }
                                if (openid == "oUM4bwdTr3DXhUkGf43lGiipmxMA")
                                {
                                    total_fee = 1;
                                }
                                if (openid == "oZLQzv-cg1KvGmrTnq0xdxhK-4kc")
                                {
                                    total_fee = 1;
                                }

                                if (string.IsNullOrEmpty(openid))
                                {
                                    WxPayAPI.Log.Error(this.GetType().ToString(), "wxOAuthRedirect|This page have not get params, cannot be inited, exit...");
                                }
                                else
                                {
                                    HotelID      = dr["HotelId"].ToString().Trim();
                                    UserWeiXinID = dr["UserWeiXinId"].ToString().Trim();
                                    WeiXinID     = dr["HotelWeiXinId"].ToString().Trim();

                                    WxPayAPI.WxPayData data = new WxPayAPI.WxPayData();
                                    data.SetValue("body", "充值卡消费");
                                    data.SetValue("attach", "presale");
                                    data.SetValue("out_trade_no", dr["OrderNo"].ToString().Trim());
                                    data.SetValue("total_fee", total_fee);
                                    data.SetValue("time_start", DateTime.Now.ToString("yyyyMMddHHmmss"));
                                    data.SetValue("time_expire", DateTime.Now.AddMinutes(30).ToString("yyyyMMddHHmmss"));
                                    data.SetValue("goods_tag", "充值卡消费");
                                    data.SetValue("trade_type", "JSAPI");
                                    data.SetValue("openid", openid);
                                    WxPayAPI.JsApiPay jsApiPay = new WxPayAPI.JsApiPay();
                                    jsApiPay.openid    = openid;
                                    jsApiPay.total_fee = total_fee;
                                    WxPayAPI.WxPayData unifiedOrderResult = jsApiPay.GetUnifiedOrderResult(data);
                                    wxJsApiParam = jsApiPay.GetJsApiParameters();
                                    WxPayAPI.Log.Debug(this.GetType().ToString(), "wxJsApiParam : " + wxJsApiParam);
                                }
                            }
                        }
                    }
                    else
                    {
                        WxPayAPI.Log.Debug(this.GetType().ToString(), "无效订单或者非预订订单");
                    }
                    boocuy = false;
                    return;
                }


                /** ================度假产品消费========= */
                if (state.Contains("P"))
                {
                    var dt = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 * from WeiXin..SaleProducts_Orders where OrderNo=@OrderNo", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                        { "OrderNo", new HotelCloud.SqlServer.DBParam {
                              ParamValue = state
                          } }
                    });
                    if (dt.Rows.Count > 0)
                    {
                        foreach (System.Data.DataRow dr in dt.Rows)
                        {
                            openid = getopenid(dr["HotelWeiXinId"].ToString().Trim(), code);
                            var weixinstrtable = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 weixintype,edition from  WeiXin..WeiXinNO where WeiXinID=@WeiXinID", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                                { "WeiXinID", new HotelCloud.SqlServer.DBParam {
                                      ParamValue = dr["HotelWeiXinId"].ToString().Trim()
                                  } }
                            });
                            if (weixinstrtable != null)
                            {
                                if (weixinstrtable.Rows.Count > 0)
                                {
                                    foreach (System.Data.DataRow rd in weixinstrtable.Rows)
                                    {
                                        /** ================判断公众号认证情况========= */
                                        weixinstr = rd["weixintype"].ToString();
                                        edition   = rd["edition"].ToString();
                                    }
                                }
                            }
                            if ((string.IsNullOrEmpty(weixinstr) || (weixinstr != "2" && weixinstr != "4")) && dr["HotelWeiXinId"].ToString().Trim() == "gh_def2f166ed9e")
                            {
                                /** ================未认证情况 进行调整到二维码扫描支付  目前这个方式也不OK========= */
                                Response.Redirect("http://hotel.weikeniu.com/WeiXinZhiFu/qrcode.aspx?OrderNo=" + dr["OrderNo"].ToString().Trim(), false);
                            }
                            else
                            {
                                int total_fee = Convert.ToInt32(Convert.ToDecimal(dr["OrderMoney"].ToString()) * 100);

                                /** ================Ashbur微信号对应支付金额 0.01元========= */
                                if (openid == "oPfrcjmqyO33T8a8Dn21Kq-QMAcg")
                                {
                                    total_fee = 1;
                                }
                                if (openid == "oUM4bwdTr3DXhUkGf43lGiipmxMA")
                                {
                                    total_fee = 1;
                                }
                                if (openid == "oZLQzv-cg1KvGmrTnq0xdxhK-4kc")
                                {
                                    total_fee = 1;
                                }

                                if (string.IsNullOrEmpty(openid))
                                {
                                    WxPayAPI.Log.Error(this.GetType().ToString(), "wxOAuthRedirect|This page have not get params, cannot be inited, exit...");
                                }
                                else
                                {
                                    HotelID      = dr["HotelId"].ToString().Trim();
                                    UserWeiXinID = dr["UserWeiXinId"].ToString().Trim();
                                    WeiXinID     = dr["HotelWeiXinId"].ToString().Trim();

                                    WxPayAPI.WxPayData data = new WxPayAPI.WxPayData();
                                    data.SetValue("body", dr["ProductName"].ToString().Trim());
                                    data.SetValue("attach", "presale");
                                    data.SetValue("out_trade_no", dr["OrderNo"].ToString().Trim());
                                    data.SetValue("total_fee", total_fee);
                                    data.SetValue("time_start", DateTime.Now.ToString("yyyyMMddHHmmss"));
                                    data.SetValue("time_expire", DateTime.Now.AddMinutes(30).ToString("yyyyMMddHHmmss"));
                                    data.SetValue("goods_tag", dr["ProductName"].ToString().Trim() + "[" + dr["TcName"].ToString().Trim() + "]");
                                    data.SetValue("trade_type", "JSAPI");
                                    data.SetValue("openid", openid);
                                    WxPayAPI.JsApiPay jsApiPay = new WxPayAPI.JsApiPay();
                                    jsApiPay.openid    = openid;
                                    jsApiPay.total_fee = total_fee;
                                    WxPayAPI.WxPayData unifiedOrderResult = jsApiPay.GetUnifiedOrderResult(data);
                                    wxJsApiParam = jsApiPay.GetJsApiParameters();
                                    WxPayAPI.Log.Debug(this.GetType().ToString(), "wxJsApiParam : " + wxJsApiParam);
                                }
                            }
                        }
                    }
                    else
                    {
                        WxPayAPI.Log.Debug(this.GetType().ToString(), "无效订单或者非预订订单");
                    }
                    boocuy = false;
                    return;
                }

                /** ================ 酒店周边餐饮消费========= */
                if (state.Contains("L"))
                {
                    var dt = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 bagging,amount,youhuiamount,ISNULL(CouponMoney,0) as CouponMoney,hotelid,userweixinid,hotelWeixinId,orderCode,(select sum(AliPayAmount) from  WeiXin..wkn_payrecords where OrderNO=orderCode and Channel='微信支付回调') as zhifu,storeID  from WeiXin..T_OrderInfo where orderCode=@orderCode", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                        { "orderCode", new HotelCloud.SqlServer.DBParam {
                              ParamValue = state
                          } }
                    });
                    if (dt.Rows.Count > 0)
                    {
                        foreach (System.Data.DataRow dr in dt.Rows)
                        {
                            openid = getopenid(dr["hotelWeixinId"].ToString().Trim(), code);
                            var weixinstrtable = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 weixintype,edition from  WeiXin..WeiXinNO where WeiXinID=@WeiXinID", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                                { "WeiXinID", new HotelCloud.SqlServer.DBParam {
                                      ParamValue = dr["hotelWeixinId"].ToString().Trim()
                                  } }
                            });
                            if (weixinstrtable != null)
                            {
                                if (weixinstrtable.Rows.Count > 0)
                                {
                                    foreach (System.Data.DataRow rd in weixinstrtable.Rows)
                                    {
                                        /** ================判断公众号认证情况========= */
                                        weixinstr = rd["weixintype"].ToString();
                                        edition   = rd["edition"].ToString();
                                    }
                                }
                            }
                            if ((string.IsNullOrEmpty(weixinstr) || (weixinstr != "2" && weixinstr != "4")) && dr["hotelWeixinId"].ToString() == "gh_def2f166ed9e")
                            {
                                /** ================未认证情况 进行调整到二维码扫描支付========= */
                                Response.Redirect("http://hotel.weikeniu.com/WeiXinZhiFu/qrcode.aspx?OrderNo=" + dr["orderCode"].ToString().Trim(), false);
                            }
                            else
                            {
                                string bagging      = dr["bagging"].ToString();
                                string youhuiamount = dr["youhuiamount"].ToString();
                                if (string.IsNullOrEmpty(bagging))
                                {
                                    bagging = "0";
                                }
                                if (string.IsNullOrEmpty(youhuiamount))
                                {
                                    youhuiamount = "0";
                                }
                                Zhifu = dr["zhifu"].ToString();;
                                if (string.IsNullOrEmpty(Zhifu))
                                {
                                    Zhifu = "0";
                                }
                                int total_fee = Convert.ToInt32((Convert.ToDecimal(dr["amount"].ToString()) - Convert.ToDecimal(youhuiamount) + Convert.ToDecimal(bagging) - Convert.ToDecimal(dr["CouponMoney"].ToString())) * 100);

                                /** ================Ashbur微信号对应支付金额 0.01元========= */
                                if (openid == "oPfrcjmqyO33T8a8Dn21Kq-QMAcg")
                                {
                                    total_fee = 1;
                                }
                                if (openid == "oUM4bwdTr3DXhUkGf43lGiipmxMA")
                                {
                                    total_fee = 1;
                                }
                                if (openid == "oZLQzv-cg1KvGmrTnq0xdxhK-4kc")
                                {
                                    total_fee = 1;
                                }

                                if (string.IsNullOrEmpty(openid))
                                {
                                    WxPayAPI.Log.Error(this.GetType().ToString(), "wxOAuthRedirect|This page have not get params, cannot be inited, exit...");
                                }
                                else
                                {
                                    HotelID      = dr["hotelid"].ToString().Trim();
                                    UserWeiXinID = dr["userweixinid"].ToString().Trim();
                                    WeiXinID     = dr["hotelWeixinId"].ToString().Trim();
                                    storeId      = dr["storeId"].ToString().Trim();

                                    WxPayAPI.WxPayData data = new WxPayAPI.WxPayData();
                                    data.SetValue("body", "酒店周边餐饮消费");
                                    data.SetValue("attach", "consumption");
                                    data.SetValue("out_trade_no", dr["orderCode"].ToString().Trim());
                                    data.SetValue("total_fee", total_fee);
                                    data.SetValue("time_start", DateTime.Now.ToString("yyyyMMddHHmmss"));
                                    data.SetValue("time_expire", DateTime.Now.AddMinutes(30).ToString("yyyyMMddHHmmss"));
                                    data.SetValue("goods_tag", "酒店周边餐饮消费");
                                    data.SetValue("trade_type", "JSAPI");
                                    data.SetValue("openid", openid);
                                    WxPayAPI.JsApiPay jsApiPay = new WxPayAPI.JsApiPay();
                                    jsApiPay.openid    = openid;
                                    jsApiPay.total_fee = total_fee;
                                    WxPayAPI.WxPayData unifiedOrderResult = jsApiPay.GetUnifiedOrderResult(data);
                                    wxJsApiParam = jsApiPay.GetJsApiParameters();
                                    WxPayAPI.Log.Debug(this.GetType().ToString(), "wxJsApiParam : " + wxJsApiParam);
                                }
                            }
                        }
                    }
                    else
                    {
                        WxPayAPI.Log.Debug(this.GetType().ToString(), "无效订单或者非预订订单");
                    }
                    boocuy = false;
                    return;
                }
                /** ================ 酒店客房销售========= */
                if (boocuy)
                {
                    hotel3g.Repository.Order order = hotel3g.Repository.OrderRepository.GetOrderInfo(state);
                    var weixinstrtable             = HotelCloud.SqlServer.SQLHelper.Get_DataTable(@"select top 1 weixintype,edition from  WeiXin..WeiXinNO where WeiXinID=@WeiXinID", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> {
                        { "WeiXinID", new HotelCloud.SqlServer.DBParam {
                              ParamValue = order.WeiXinID.Trim()
                          } }
                    });
                    if (weixinstrtable != null)
                    {
                        if (weixinstrtable.Rows.Count > 0)
                        {
                            foreach (System.Data.DataRow rd in weixinstrtable.Rows)
                            {
                                /** ================判断公众号认证情况========= */
                                weixinstr = rd["weixintype"].ToString();
                                edition   = rd["edition"].ToString();
                            }
                        }
                    }
                    if ((string.IsNullOrEmpty(weixinstr) || (weixinstr != "2" && weixinstr != "4")) && order.WeiXinID.Trim() == "gh_def2f166ed9e")
                    {
                        /** ================未认证情况 进行调整到二维码扫描支付========= */
                        Response.Redirect("http://hotel.weikeniu.com/WeiXinZhiFu/qrcode.aspx?OrderNo=" + order.OrderNo.ToString(), false);
                    }
                    else
                    {
                        if (order == null || order.PayType != "0")
                        {
                            WxPayAPI.Log.Debug(this.GetType().ToString(), "无效订单或者非预订订单");
                        }
                        else
                        {
                            openid = getopenid(order.WeiXinID.Trim(), code);
                            int total_fee = order.OrderAmount * 100;

                            /** ================Ashbur微信号对应支付金额 0.01元========= */
                            if (openid == "oPfrcjmqyO33T8a8Dn21Kq-QMAcg")
                            {
                                total_fee = 1;
                            }
                            if (openid == "oUM4bwdTr3DXhUkGf43lGiipmxMA")
                            {
                                total_fee = 1;
                            }
                            if (openid == "oZLQzv-cg1KvGmrTnq0xdxhK-4kc")
                            {
                                total_fee = 1;
                            }

                            if (string.IsNullOrEmpty(openid))
                            {
                                WxPayAPI.Log.Error(this.GetType().ToString(), "wxOAuthRedirect|This page have not get params, cannot be inited, exit...");
                            }
                            else
                            {
                                HotelID      = order.HotelID.ToString().Trim();
                                UserWeiXinID = order.UserWeiXinID.Trim();
                                WeiXinID     = order.WeiXinID.Trim();
                                if (edition == "1")
                                {
                                    orderid = order.Id.ToString();
                                }
                                orderid = order.Id.ToString();

                                WxPayAPI.WxPayData data = new WxPayAPI.WxPayData();
                                data.SetValue("body", order.HotelName.Trim());
                                data.SetValue("attach", "weikeniuwx");
                                data.SetValue("out_trade_no", order.OrderNo);
                                data.SetValue("total_fee", total_fee);
                                data.SetValue("time_start", DateTime.Now.ToString("yyyyMMddHHmmss"));
                                data.SetValue("time_expire", DateTime.Now.AddMinutes(30).ToString("yyyyMMddHHmmss"));
                                data.SetValue("goods_tag", order.RoomName + "[" + order.RatePlanName + "]");
                                data.SetValue("trade_type", "JSAPI");
                                data.SetValue("openid", openid);
                                WxPayAPI.JsApiPay jsApiPay = new WxPayAPI.JsApiPay();
                                jsApiPay.openid    = openid;
                                jsApiPay.total_fee = total_fee;
                                WxPayAPI.WxPayData unifiedOrderResult = jsApiPay.GetUnifiedOrderResult(data);
                                wxJsApiParam = jsApiPay.GetJsApiParameters();
                                WxPayAPI.Log.Debug(this.GetType().ToString(), "wxJsApiParam : " + wxJsApiParam);
                            }
                        }
                    }
                }
            }
        }