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; }
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); }
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; }
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); }
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(); }