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