public void WriteReturnDayDetail(ReturnDayDetailInfo returnDay)
{
System.Collections.Generic.List <System.Data.Common.DbParameter> list = new System.Collections.Generic.List <System.Data.Common.DbParameter>();
list.Add(base.Database.MakeInParam("@OrderID", returnDay.OrderID));
list.Add(base.Database.MakeInParam("@MerID", returnDay.MerID));
list.Add(base.Database.MakeInParam("@PayMoney", returnDay.PayMoney));
list.Add(base.Database.MakeInParam("@UserName", returnDay.UserName));
list.Add(base.Database.MakeInParam("@Sign", returnDay.Sign));
list.Add(base.Database.MakeInParam("@PayType", returnDay.PayType));
list.Add(base.Database.MakeInParam("@Status", returnDay.Status));
base.Database.RunProc("NET_PW_AddReturnDayInfo", list);
}
/// <summary>
/// 写天天付返回记录
/// </summary>
/// <param name="returnKQ"></param>
public void WriteReturnDayDetail(ReturnDayDetailInfo returnDay)
{
var parms = new List <DbParameter>();
parms.Add(Database.MakeInParam("@OrderID", returnDay.OrderID));
parms.Add(Database.MakeInParam("@MerID", returnDay.MerID));
parms.Add(Database.MakeInParam("@PayMoney", returnDay.PayMoney));
parms.Add(Database.MakeInParam("@UserName", returnDay.UserName));
parms.Add(Database.MakeInParam("@Sign", returnDay.Sign));
parms.Add(Database.MakeInParam("@PayType", returnDay.PayType));
parms.Add(Database.MakeInParam("@Status", returnDay.Status));
Database.RunProc("NET_PW_AddReturnDayInfo", parms);
}
protected void Page_Load(object sender, EventArgs e)
{
string key = System.Configuration.ConfigurationSettings.AppSettings["DayKey"]; //密钥
string merId = System.Configuration.ConfigurationSettings.AppSettings["DayMerId"]; //商户ID
string status = GameRequest.GetFormString("status"); //交易状态
string sign = GameRequest.GetFormString("sign"); //签名
string orderId = GameRequest.GetFormString("orderId"); //订单号
float payMoney = GameRequest.GetFormFloat("payMoney", 0); //金额
string operDate = GameRequest.GetFormString("operDate"); //订单日期
string userName = GameRequest.GetFormString("userName"); //用户名
string showUrl = "http://" + HttpContext.Current.Request.Url.Authority + "/Pay/PayShow.aspx"; //交易完成后提示地址
string signStr = merId + "|" + orderId + "|" + status + "|" + payMoney + "|" + operDate + "|" + userName + "|" + key;
string testSign = EncryptMD5(signStr, false, 32); //计算签名
ReturnDayDetailInfo result = new ReturnDayDetailInfo( );
result.OrderID = orderId;
result.PayMoney = Convert.ToDecimal(payMoney);
result.Sign = sign;
result.UserName = userName;
result.PayType = 1;
result.Status = status;
//天天付支付结果入库
treasureFacade.WriteReturnDayDetail(result);
if (signStr == testSign)
{
//交易状态为005时表示交易完成
if (status == "055")
{
ShareDetialInfo detailInfo = new ShareDetialInfo( );
detailInfo.OrderID = orderId;
detailInfo.IPAddress = Utility.UserIP;
Message umsg = treasureFacade.FilliedOnline(detailInfo, 0);
if (umsg.Success)
{
rtnUrl = showUrl + "?msg=1";//在线充值成功
}
else
{
rtnUrl = showUrl + "?msg=2";//在线充值成功,数据正在更新中
}
}
else
{
rtnOk = 1;
rtnUrl = showUrl + "?msg=3"; //在线充值失败!
}
}
}
/// <summary>
/// 写天天付返回记录
/// </summary>
/// <param name="returnKQ"></param>
public void WriteReturnDayDetail(ReturnDayDetailInfo returnDay)
{
treasureData.WriteReturnDayDetail(returnDay);
}
/// <summary>
/// 获取天天付返回记录实体
/// </summary>
/// <param name="detailID"></param>
/// <returns></returns>
public ReturnDayDetailInfo GetDayDetailInfo(int detailID)
{
ReturnDayDetailInfo info = new ReturnDayDetailInfo( );
return(info);
}