Example #1
0
    protected string v_url; // 返回页地址

    #endregion Fields

    #region Methods

    public string Get_ChinaBank(string backvalue)
    {
        PageAdmin.Conn Myconn=new PageAdmin.Conn();
           string constr=Myconn.Constr();
           string sql="select * from onlinepay where onlinepay_type='chinabank'";
           OleDbConnection conn=new OleDbConnection(constr);
           conn.Open();
           string Val;
           OleDbCommand comm=new OleDbCommand(sql,conn);
           OleDbDataReader dr=comm.ExecuteReader();
           if(dr.Read())
        {
          switch(backvalue)
           {
             case "mid":
               Val=dr["onlinepay_mid"].ToString();
             break;
             case "key":
              Val=dr["onlinepay_key"].ToString();;
             break;

            default:
                Val="";
            break;
           }
        }
          else
        {
          Val="";
        }
           conn.Close();
           return  Val;
    }
Example #2
0
    private string  Get_ChinaBank_Key()
    {
        PageAdmin.Conn  Myconn = new PageAdmin.Conn();
        string          constr = Myconn.Constr();
        string          sql    = "select onlinepay_key from pa_onlinepay where onlinepay_type='chinabank'";
        OleDbConnection conn   = new OleDbConnection(constr);

        conn.Open();
        string          Val;
        OleDbCommand    comm = new OleDbCommand(sql, conn);
        OleDbDataReader dr   = comm.ExecuteReader();

        if (dr.Read())
        {
            Val = dr["onlinepay_key"].ToString();;
        }
        else
        {
            Val = "";
            Response.Write("error");
            Response.End();
        }
        conn.Close();
        return(Val);
    }
Example #3
0
    protected string v_pstring; //支付状态描述

    #endregion Fields

    #region Methods

    public string Get_ChinaBank_Key()
    {
        PageAdmin.Conn Myconn=new PageAdmin.Conn();
           string constr=Myconn.Constr();
           string sql="select * from onlinepay where onlinepay_type='chinabank'";
           OleDbConnection conn=new OleDbConnection(constr);
           conn.Open();
           string Val;
           OleDbCommand comm=new OleDbCommand(sql,conn);
           OleDbDataReader dr=comm.ExecuteReader();
           if(dr.Read())
        {
           Val=dr["onlinepay_key"].ToString();;
        }
          else
        {
          Val="";
          Response.Write("error");
          Response.End();
        }
           conn.Close();
           return Val;
    }
Example #4
0
    private string  Get_ChinaBank(string backvalue)
    {
        PageAdmin.Conn  Myconn = new PageAdmin.Conn();
        string          constr = Myconn.Constr();
        string          sql    = "select * from pa_onlinepay where onlinepay_type='chinabank'";
        OleDbConnection conn   = new OleDbConnection(constr);

        conn.Open();
        string          Val;
        OleDbCommand    comm = new OleDbCommand(sql, conn);
        OleDbDataReader dr   = comm.ExecuteReader();

        if (dr.Read())
        {
            switch (backvalue)
            {
            case "mid":
                Val = dr["onlinepay_mid"].ToString();
                break;

            case "key":
                Val = dr["onlinepay_key"].ToString();;
                break;

            default:
                Val = "";
                break;
            }
        }
        else
        {
            Val = "";
        }
        dr.Close();
        conn.Close();
        return(Val);
    }
Example #5
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.Cookies["site"] == null)
        {
            Response.Write("<script type='text/javascript'>alert('invalid siteid!');</script>");
            Response.End();
            return;
        }
        else if (!IsNum(Request.Cookies["site"].Value))
        {
            Response.Write("<script type='text/javascript'>alert('invalid siteid!');</script>");
            Response.End();
            return;
        }
        SiteId = Request.Cookies["site"].Value;
        PageAdmin.Member_Valicate MCheck = new PageAdmin.Member_Valicate();
        MCheck.Member_Check(true, SiteId);
        UserName = Request.Cookies["Member"].Values["UserName"].ToString();

        PageAdmin.Conn Myconn = new PageAdmin.Conn();
        string         constr = Myconn.Constr();

        conn = new OleDbConnection(constr);
        conn.Open();


        // MD5密钥要跟订单提交页相同,如Send.asp里的 key = "test" ,修改""号内 test 为您的密钥
        string key = Get_ChinaBank_Key();       // 如果您还没有设置MD5密钥请登陆我们为您提供商户后台,地址:https://merchant3.chinabank.com.cn/

        // 登陆后在上面的导航栏里可能找到“资料管理”,在资料管理的二级导航栏里有“MD5密钥设置”
        // 建议您设置一个16位以上的密钥或更高,密钥最多64位,但设置16位已经足够了

        v_oid       = Request["v_oid"];
        v_pstatus   = Request["v_pstatus"];
        v_pstring   = Request["v_pstring"];
        v_pmode     = Request["v_pmode"];
        v_md5str    = Request["v_md5str"];
        v_amount    = Request["v_amount"];
        v_moneytype = Request["v_moneytype"];
        remark1     = Request["remark1"];
        remark2     = Request["remark2"];

        string str = v_oid + v_pstatus + v_amount + v_moneytype + key;

        str = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(str, "md5").ToUpper();

        if (str == v_md5str)
        {
            if (v_pstatus.Equals("20"))
            {
                //支付成功
                //在这里商户可以写上自己的业务逻辑
                status_msg = "支付成功,金额已经转入您的会员名下";
                double Fnc_Amount = double.Parse(v_amount);
                if (!Fnc_rk(v_oid))
                {
                    Update_member_fnc(Fnc_Amount);
                    Update_fnc_list(Fnc_Amount, "网银在线", v_oid, "订单号:" + v_oid);
                    string M_body = "支付方式:网银在线<br>订单号:" + v_oid + "<br>支付金额:" + v_amount;
                    SendMail(M_body);
                    Response.Redirect("/e/member/index.aspx?type=payresult&s=" + SiteId + "&pay_no=" + v_oid + "&pay_amount=" + v_amount + "&pay_type=" + Server.UrlEncode("网银在线"));
                }
                else
                {
                    Response.Redirect("/e/member/index.aspx?type=payresult&s=" + SiteId + "&pay_no=" + v_oid + "&pay_amount=" + v_amount + "&pay_type=" + Server.UrlEncode("网银在线"));
                }
            }
        }
        else
        {
            Response.Write("校验失败,数据可疑!");
            Response.End();
        }
        conn.Close();
    }