/// <summary> /// 获取易宝返回记录实体 /// </summary> /// <param name="detailID"></param> /// <returns></returns> public ReturnYPDetailInfo GetYPDetailInfo(int detailID) { string sqlQuery = string.Format("(NOLOCK) WHERE DetailID= {0}", detailID); ReturnYPDetailInfo detailInfo = aideYPDetailProvider.GetObject <ReturnYPDetailInfo>(sqlQuery); return(detailInfo); }
public Message WriteReturnYBDetail(ReturnYPDetailInfo returnYB) { System.Collections.Generic.List <System.Data.Common.DbParameter> list = new System.Collections.Generic.List <System.Data.Common.DbParameter>(); list.Add(base.Database.MakeInParam("p1_MerId", returnYB.P1_MerId)); list.Add(base.Database.MakeInParam("r0_Cmd", returnYB.R0_Cmd)); list.Add(base.Database.MakeInParam("r1_Code", returnYB.R1_Code)); list.Add(base.Database.MakeInParam("r2_TrxId", returnYB.R2_TrxId)); list.Add(base.Database.MakeInParam("r3_Amt", returnYB.R3_Amt)); list.Add(base.Database.MakeInParam("r4_Cur", returnYB.R4_Cur)); list.Add(base.Database.MakeInParam("r5_Pid", returnYB.R5_Pid)); list.Add(base.Database.MakeInParam("r6_Order", returnYB.R6_Order)); list.Add(base.Database.MakeInParam("r7_Uid", returnYB.R7_Uid)); list.Add(base.Database.MakeInParam("r8_MP", returnYB.R8_MP)); list.Add(base.Database.MakeInParam("r9_BType", returnYB.R9_BType)); list.Add(base.Database.MakeInParam("rb_BankId", returnYB.Rb_BankId)); list.Add(base.Database.MakeInParam("ro_BankOrderId", returnYB.Ro_BankOrderId)); list.Add(base.Database.MakeInParam("rp_PayDate", returnYB.Rp_PayDate)); list.Add(base.Database.MakeInParam("rq_CardNo", returnYB.Rq_CardNo)); list.Add(base.Database.MakeInParam("ru_Trxtime", returnYB.Ru_Trxtime)); list.Add(base.Database.MakeInParam("hmac", returnYB.Hmac)); return(MessageHelper.GetMessage(base.Database, "NET_PW_AddReturnYBInfo", list)); }
private void DetailDataBind() { if (id <= 0) { return; } //获取站点信息 ReturnYPDetailInfo YBDetailInfo = FacadeManage.aideTreasureFacade.GetYPDetailInfo(id); if (YBDetailInfo == null) { ShowError("信息不存在"); return; } CtrlHelper.SetText(litR6_Order, "<a class='l' href='javascript:void(0)' onclick=\"javascript:openWindowOwn('OnLineOrderInfo.aspx?OrderID=" + YBDetailInfo.R6_Order + "','online_" + YBDetailInfo.R6_Order + "',600,465)\">" + YBDetailInfo.R6_Order + "</a>"); if (YBDetailInfo.R1_Code == "1") { CtrlHelper.SetText(litR1_Code, "<span class='lan'>成功</span>"); } else { CtrlHelper.SetText(litR1_Code, "<span class='hong'>失败</span>"); } CtrlHelper.SetText(litR2_TrxId, YBDetailInfo.R2_TrxId.Trim()); CtrlHelper.SetText(litR3_Amt, YBDetailInfo.R3_Amt.ToString("N")); CtrlHelper.SetText(litR5_Pid, YBDetailInfo.R5_Pid.Trim()); CtrlHelper.SetText(litR8_MP, YBDetailInfo.R8_MP.Trim()); CtrlHelper.SetText(litR9_BType, YBDetailInfo.R9_BType.Trim() == "1" ? "浏览器重定向" : "服务器点对点通讯"); CtrlHelper.SetText(litRb_BankId, GetBankName(YBDetailInfo.Rb_BankId.Trim())); CtrlHelper.SetText(litRo_BankOrderId, YBDetailInfo.Ro_BankOrderId.Trim()); CtrlHelper.SetText(litRp_PayDate, GetYbTime(YBDetailInfo.Rp_PayDate.Trim())); CtrlHelper.SetText(litRq_CardNo, YBDetailInfo.Rq_CardNo.Trim()); CtrlHelper.SetText(litRu_Trxtime, GetYbTime(YBDetailInfo.Ru_Trxtime.Trim())); CtrlHelper.SetText(litHmac, YBDetailInfo.Hmac.Trim()); CtrlHelper.SetText(litCollectDate, YBDetailInfo.CollectDate.ToString("yyyy-MM-dd HH:mm:ss")); }
/// <summary> /// 写易宝返回记录 /// </summary> /// <param name="returnYB"></param> public Message WriteReturnYBDetail(ReturnYPDetailInfo returnYB) { var parms = new List <DbParameter>(); parms.Add(Database.MakeInParam("p1_MerId", returnYB.P1_MerId)); parms.Add(Database.MakeInParam("r0_Cmd", returnYB.R0_Cmd)); parms.Add(Database.MakeInParam("r1_Code", returnYB.R1_Code)); parms.Add(Database.MakeInParam("r2_TrxId", returnYB.R2_TrxId)); parms.Add(Database.MakeInParam("r3_Amt", returnYB.R3_Amt)); parms.Add(Database.MakeInParam("r4_Cur", returnYB.R4_Cur)); parms.Add(Database.MakeInParam("r5_Pid", returnYB.R5_Pid)); parms.Add(Database.MakeInParam("r6_Order", returnYB.R6_Order)); parms.Add(Database.MakeInParam("r7_Uid", returnYB.R7_Uid)); parms.Add(Database.MakeInParam("r8_MP", returnYB.R8_MP)); parms.Add(Database.MakeInParam("r9_BType", returnYB.R9_BType)); parms.Add(Database.MakeInParam("rb_BankId", returnYB.Rb_BankId)); parms.Add(Database.MakeInParam("ro_BankOrderId", returnYB.Ro_BankOrderId)); parms.Add(Database.MakeInParam("rp_PayDate", returnYB.Rp_PayDate)); parms.Add(Database.MakeInParam("rq_CardNo", returnYB.Rq_CardNo)); parms.Add(Database.MakeInParam("ru_Trxtime", returnYB.Ru_Trxtime)); parms.Add(Database.MakeInParam("hmac", returnYB.Hmac)); return(MessageHelper.GetMessage(Database, "NET_PW_AddReturnYBInfo", parms)); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // 校验返回数据包 BuyCallbackResult result = Buy.VerifyCallback(FormatQueryString.GetQueryString("p1_MerId"), FormatQueryString.GetQueryString("r0_Cmd"), FormatQueryString.GetQueryString("r1_Code"), FormatQueryString.GetQueryString("r2_TrxId"), FormatQueryString.GetQueryString("r3_Amt"), FormatQueryString.GetQueryString("r4_Cur"), FormatQueryString.GetQueryString("r5_Pid"), FormatQueryString.GetQueryString("r6_Order"), FormatQueryString.GetQueryString("r7_Uid"), FormatQueryString.GetQueryString("r8_MP"), FormatQueryString.GetQueryString("r9_BType"), FormatQueryString.GetQueryString("rp_PayDate"), FormatQueryString.GetQueryString("hmac")); if (string.IsNullOrEmpty(result.ErrMsg)) { //写易宝记录 ReturnYPDetailInfo resultYB = new ReturnYPDetailInfo(); resultYB.P1_MerId = FormatQueryString.GetQueryString("p1_MerId"); resultYB.R0_Cmd = FormatQueryString.GetQueryString("r0_Cmd"); resultYB.R1_Code = FormatQueryString.GetQueryString("r1_Code"); resultYB.R2_TrxId = FormatQueryString.GetQueryString("r2_TrxId"); resultYB.R3_Amt = Convert.ToDecimal(FormatQueryString.GetQueryString("r3_Amt")); resultYB.R4_Cur = FormatQueryString.GetQueryString("r4_Cur"); resultYB.R5_Pid = FormatQueryString.GetQueryString("r5_Pid"); resultYB.R6_Order = FormatQueryString.GetQueryString("r6_Order"); resultYB.R7_Uid = FormatQueryString.GetQueryString("r7_Uid"); resultYB.R8_MP = FormatQueryString.GetQueryString("r8_MP"); resultYB.R9_BType = FormatQueryString.GetQueryString("r9_BType"); resultYB.Rb_BankId = FormatQueryString.GetQueryString("rb_BankId"); resultYB.Ro_BankOrderId = FormatQueryString.GetQueryString("ro_BankOrderId"); resultYB.Rp_PayDate = FormatQueryString.GetQueryString("rp_PayDate"); resultYB.Rq_CardNo = FormatQueryString.GetQueryString("rq_CardNo"); resultYB.Ru_Trxtime = FormatQueryString.GetQueryString("ru_Trxtime"); resultYB.Hmac = FormatQueryString.GetQueryString("hmac"); treasureFacade.WriteReturnYBDetail(resultYB); if (result.R1_Code == "1") { if (result.R9_BType == "1") { // 写充值记录 ShareDetialInfo detailInfo = new ShareDetialInfo(); detailInfo.OrderID = resultYB.R6_Order; detailInfo.IPAddress = Utility.UserIP; detailInfo.PayAmount = resultYB.R3_Amt; treasureFacade.FilliedOnline(detailInfo, 0); // callback方式:浏览器重定向 Response.Write("支付成功!<br>商品ID:" + result.R5_Pid + "<br>商户订单号:" + result.R6_Order + "<br>支付金额:" + result.R3_Amt + "<br>易宝支付交易流水号:" + result.R2_TrxId + "<BR>"); } else if (result.R9_BType == "2") { // * 如果是服务器返回则需要回应一个特定字符串'SUCCESS',且在'SUCCESS'之前不可以有任何其他字符输出,保证首先输出的是'SUCCESS'字符串 Response.Write("SUCCESS"); } } else { Response.Write("支付失败!"); } } else { Response.Write("交易签名无效!"); } } }
/// <summary> /// 写易宝返回记录 /// </summary> /// <param name="returnYB"></param> public Message WriteReturnYBDetail(ReturnYPDetailInfo returnYB) { return(treasureData.WriteReturnYBDetail(returnYB)); }