protected void Page_Load(object sender, EventArgs e)
{
string merchant_id = Request.Params["merchant_id"];
string request_time = Request.Params["request_time"];
string pay_time = Request.Params["pay_time"];
string status = Request.Params["status"];
string order_amount = Request.Params["order_amount"];
string pay_amount = Request.Params["pay_amount"];
string out_trade_no = Request.Params["out_trade_no"];
if (out_trade_no == null)
{
out_trade_no = "";
}
string trade_no = Request.Params["trade_no"];
string fees = Request.Params["fees"];
string pay_type = Request.Params["pay_type"];
string nonce_str = Request.Params["nonce_str"];
string sign = Request.Params["sign"];
string MD5Sign = SimonUtils.EnCodeMD5("fees=" + fees + "&" + "merchant_id=" + merchant_id + "&" + "nonce_str=" + nonce_str + "&" + "order_amount=" + order_amount + "&" + "out_trade_no=" + out_trade_no + "&" + "pay_amount=" + pay_amount + "&" + "pay_time=" + pay_time + "&" + "pay_type=" + pay_type + "&" + "request_time=" + request_time + "&" + "status=" + status + "&" + "trade_no=" + trade_no + s_key).ToUpper();
//记录日志
StringBuilder sb = new StringBuilder();
sb.Append("\r\n 暴风雪 异步通知 返回日志-----------------------------------------------------------------------------------");
sb.Append("\r\n merchant_id=" + merchant_id);
sb.Append("\r\n request_time=" + request_time);
sb.Append("\r\n pay_time=" + pay_time);
sb.Append("\r\n status=" + status);
sb.Append("\r\n order_amount=" + order_amount);
sb.Append("\r\n pay_amount=" + pay_amount);
sb.Append("\r\n out_trade_no=" + out_trade_no);
sb.Append("\r\n trade_no=" + trade_no);
sb.Append("\r\n fees=" + fees);
sb.Append("\r\n pay_type=" + pay_type);
sb.Append("\r\n nonce_str=" + nonce_str);
sb.Append("\r\n sign=" + sign);
sb.Append("\r\n MD5Sign=" + MD5Sign);
sb.Append("\r\n--------------------------------------------------------------------------------------------------");
SimonLog.WriteLog(sb.ToString(), "/Log/", "log_paywap_error_" + DateTime.Now.ToString("yyyyMMdd"));
if (MD5Sign.Equals(sign, StringComparison.OrdinalIgnoreCase) && status == "success")
{
//交易成功
DataTable RMBCostDT = SimonDB.DataTable(@"select * from Web_RMBCost where OrderID=@OrderID", new DbParameter[] {
SimonDB.CreDbPar("@OrderID", out_trade_no)
});
if (RMBCostDT.Rows.Count <= 0)
{
Response.Write("订单不存在");
return;
}
DataRow RMBCostDR = RMBCostDT.Rows[0];
if (RMBCostDR["UpdateFlag"].ToString() == "1")
{
Response.Write("订单已处理");
return;
}
if (Convert.ToInt32(decimal.Parse(RMBCostDR["PayMoney"].ToString())) != Convert.ToInt32(decimal.Parse(order_amount)))
{
Response.Write("充值金额不符");
return;
}
//判断玩家账号是否存在
DbParameter[] userparms = new DbParameter[] { SimonDB.CreDbPar("@userid", RMBCostDR["Users_ids"]) };
DataTable UserDT = SimonDB.DataTable(@"select * from TUsers as a inner join TUserInfo as b on a.userid=b.userid where a.userid=@userid", userparms);
if (UserDT.Rows.Count <= 0)
{
Response.Write("用户不存在");
return;
}
DataRow UserDR = UserDT.Rows[0];
//判断充值兑换率
DataTable RechargeRateDT = SimonDB.DataTable(@"select * from RechargeRate where RechargeRMB=@RechargeRMB", new DbParameter[] {
SimonDB.CreDbPar("@RechargeRMB", RMBCostDR["PayMoney"].ToString())
});
if (RechargeRateDT.Rows.Count <= 0)
{
Response.Write("此充值金额的金币兑换率不存在");
return;
}
DataRow RechargeRateDR = RechargeRateDT.Rows[0];
//更新订单
List <DbParameter> rmbcost_lpar = new List <DbParameter>();
rmbcost_lpar.Add(SimonDB.CreDbPar("@OrderID", out_trade_no)); //订单号
rmbcost_lpar.Add(SimonDB.CreDbPar("@InMoney", Convert.ToInt32(decimal.Parse(order_amount))));
rmbcost_lpar.Add(SimonDB.CreDbPar("@InSuccess", true));
rmbcost_lpar.Add(SimonDB.CreDbPar("@PaySuccess", true));
rmbcost_lpar.Add(SimonDB.CreDbPar("@UpdateFlag", "1")); //更新状态
SimonDB.ExecuteNonQuery(@"update Web_RMBCost set InMoney=@InMoney,InSuccess=@InSuccess,
PaySuccess=@PaySuccess,UpdateFlag=@UpdateFlag
where OrderID=@OrderID", rmbcost_lpar.ToArray());
//充值动作
SimonDB.ExecuteNonQuery(@"update TUserInfo set WalletMoney=WalletMoney+@ChangeMoney where UserID=@UserID", new DbParameter[] {
SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RechargeGold"].ToString()),
SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString())
});
//金币日志
SimonDB.ExecuteNonQuery(@"insert into Web_MoneyChangeLog (UserID,UserName,StartMoney,ChangeMoney,ChangeType,DateTime,Remark)
values (@UserID,@UserName,@StartMoney,@ChangeMoney,2,getdate(),@Remark)", new DbParameter[] {
SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString()),
SimonDB.CreDbPar("@UserName", UserDR["UserName"].ToString()),
SimonDB.CreDbPar("@StartMoney", UserDR["WalletMoney"].ToString()),
SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RechargeGold"].ToString()),
SimonDB.CreDbPar("@Remark", "暴风雪充值，订单号：" + order_amount)
});
//充值赠送金币
SimonDB.ExecuteNonQuery(@"update TUserInfo set WalletMoney=WalletMoney+@ChangeMoney where UserID=@UserID", new DbParameter[] {
SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RegiveGold"].ToString()),
SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString())
});
//充值赠送金币日志
SimonDB.ExecuteNonQuery(@"insert into Web_MoneyChangeLog (UserID,UserName,StartMoney,ChangeMoney,ChangeType,DateTime,Remark)
values (@UserID,@UserName,@StartMoney,@ChangeMoney,2,getdate(),@Remark)", new DbParameter[] {
SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString()),
SimonDB.CreDbPar("@UserName", UserDR["UserName"].ToString()),
SimonDB.CreDbPar("@StartMoney", UserDR["WalletMoney"].ToString()),
SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RegiveGold"].ToString()),
SimonDB.CreDbPar("@Remark", "充值赠送金币,关联暴风雪订单号：" + trade_no)
});
SimonUtils.RespW("支付成功");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string p1_usercode = Request.Params["p1_usercode"];
string p2_order = Request.Params["p2_order"];
string p3_money = Request.Params["p3_money"];
string p4_status = Request.Params["p4_status"];
string p5_payorder = Request.Params["p5_payorder"];
string p6_paymethod = Request.Params["p6_paymethod"];
string p7_paychannelnum = Request.Params["p7_paychannelnum"];
if (p7_paychannelnum == null)
{
p7_paychannelnum = "";
}
string p8_charset = Request.Params["p8_charset"];
string p9_signtype = Request.Params["p9_signtype"];
string p10_sign = Request.Params["p10_sign"];
string p11_remark = Request.Params["p11_remark"];
string MD5Sign = SimonUtils.EnCodeMD5(p1_usercode + "&" + p2_order + "&" + p3_money + "&" + p4_status + "&" + p5_payorder + "&" + p6_paymethod + "&" + p7_paychannelnum + "&" + p8_charset + "&" + p9_signtype + "&" + comp_key);
//记录日志
StringBuilder sb = new StringBuilder();
sb.Append("\r\n 旺实付 异步通知 日志-----------------------------------------------------------------------------------");
sb.Append("\r\n p1_usercode=" + p1_usercode);
sb.Append("\r\n p2_order=" + p2_order);
sb.Append("\r\n p3_money=" + p3_money);
sb.Append("\r\n p4_status=" + p4_status);
sb.Append("\r\n p5_payorder=" + p5_payorder);
sb.Append("\r\n p6_paymethod=" + p6_paymethod);
sb.Append("\r\n p7_paychannelnum=" + p7_paychannelnum);
sb.Append("\r\n p8_charset=" + p8_charset);
sb.Append("\r\n p9_signtype=" + p9_signtype);
sb.Append("\r\n p10_sign=" + p10_sign);
sb.Append("\r\n p11_remark=" + p11_remark);
sb.Append("\r\n MD5Sign=" + MD5Sign);
sb.Append("\r\n--------------------------------------------------------------------------------------------------");
SimonLog.WriteLog(sb.ToString(), "/Log/", "log_paywap_error_" + DateTime.Now.ToString("yyyyMMdd"));
if (MD5Sign.Equals(p10_sign, StringComparison.OrdinalIgnoreCase) && p4_status == "1")
{
//交易成功
DataTable RMBCostDT = SimonDB.DataTable(@"select * from Web_RMBCost where OrderID=@OrderID", new DbParameter[] {
SimonDB.CreDbPar("@OrderID", p2_order)
});
if (RMBCostDT.Rows.Count <= 0)
{
Response.Write("订单不存在");
return;
}
DataRow RMBCostDR = RMBCostDT.Rows[0];
if (RMBCostDR["UpdateFlag"].ToString() == "1")
{
Response.Write("订单已处理");
return;
}
if (Convert.ToInt32(decimal.Parse(RMBCostDR["PayMoney"].ToString())) != Convert.ToInt32(decimal.Parse(p3_money)))
{
Response.Write("充值金额不符");
return;
}
//判断玩家账号是否存在
DbParameter[] userparms = new DbParameter[] { SimonDB.CreDbPar("@userid", RMBCostDR["Users_ids"]) };
DataTable UserDT = SimonDB.DataTable(@"select * from TUsers as a inner join TUserInfo as b on a.userid=b.userid where a.userid=@userid", userparms);
if (UserDT.Rows.Count <= 0)
{
Response.Write("用户不存在");
return;
}
DataRow UserDR = UserDT.Rows[0];
//判断充值兑换率
DataTable RechargeRateDT = SimonDB.DataTable(@"select * from RechargeRate where RechargeRMB=@RechargeRMB", new DbParameter[] {
SimonDB.CreDbPar("@RechargeRMB", RMBCostDR["PayMoney"].ToString())
});
if (RechargeRateDT.Rows.Count <= 0)
{
Response.Write("此充值金额的金币兑换率不存在");
return;
}
DataRow RechargeRateDR = RechargeRateDT.Rows[0];
//更新订单
List <DbParameter> rmbcost_lpar = new List <DbParameter>();
rmbcost_lpar.Add(SimonDB.CreDbPar("@OrderID", p2_order)); //订单号
rmbcost_lpar.Add(SimonDB.CreDbPar("@InMoney", Convert.ToInt32(decimal.Parse(p3_money))));
rmbcost_lpar.Add(SimonDB.CreDbPar("@InSuccess", true));
rmbcost_lpar.Add(SimonDB.CreDbPar("@PaySuccess", true));
rmbcost_lpar.Add(SimonDB.CreDbPar("@UpdateFlag", "1")); //更新状态
SimonDB.ExecuteNonQuery(@"update Web_RMBCost set InMoney=@InMoney,InSuccess=@InSuccess,
PaySuccess=@PaySuccess,UpdateFlag=@UpdateFlag
where OrderID=@OrderID", rmbcost_lpar.ToArray());
//充值动作
SimonDB.ExecuteNonQuery(@"update TUserInfo set WalletMoney=WalletMoney+@ChangeMoney where UserID=@UserID", new DbParameter[] {
SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RechargeGold"].ToString()),
SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString())
});
//金币日志
SimonDB.ExecuteNonQuery(@"insert into Web_MoneyChangeLog (UserID,UserName,StartMoney,ChangeMoney,ChangeType,DateTime,Remark)
values (@UserID,@UserName,@StartMoney,@ChangeMoney,2,getdate(),@Remark)", new DbParameter[] {
SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString()),
SimonDB.CreDbPar("@UserName", UserDR["UserName"].ToString()),
SimonDB.CreDbPar("@StartMoney", UserDR["WalletMoney"].ToString()),
SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RechargeGold"].ToString()),
SimonDB.CreDbPar("@Remark", "旺实富充值，订单号：" + p3_money)
});
//充值赠送金币
SimonDB.ExecuteNonQuery(@"update TUserInfo set WalletMoney=WalletMoney+@ChangeMoney where UserID=@UserID", new DbParameter[] {
SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RegiveGold"].ToString()),
SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString())
});
//充值赠送金币日志
SimonDB.ExecuteNonQuery(@"insert into Web_MoneyChangeLog (UserID,UserName,StartMoney,ChangeMoney,ChangeType,DateTime,Remark)
values (@UserID,@UserName,@StartMoney,@ChangeMoney,2,getdate(),@Remark)", new DbParameter[] {
SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString()),
SimonDB.CreDbPar("@UserName", UserDR["UserName"].ToString()),
SimonDB.CreDbPar("@StartMoney", UserDR["WalletMoney"].ToString()),
SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RegiveGold"].ToString()),
SimonDB.CreDbPar("@Remark", "充值赠送金币,关联旺实富订单号：" + p5_payorder)
});
SimonUtils.RespW("支付成功");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Stream receive_str = Request.InputStream;
StreamReader sr = new StreamReader(receive_str);
string requestMes = sr.ReadToEnd();
JsonData receive_jd = null;
try
{
receive_jd = JsonMapper.ToObject(requestMes);
}
catch { SimonUtils.RespWNC(CurrSite.GetErrJson("-1", "Json异常")); }
string merchant_id = receive_jd["merchant_id"].ToString();
string request_time = receive_jd["request_time"].ToString();
string pay_time = receive_jd["pay_time"].ToString();
string status = receive_jd["status"].ToString();
string order_amount = receive_jd["order_amount"].ToString();
string pay_amount = receive_jd["pay_amount"].ToString();
string out_trade_no = receive_jd["out_trade_no"].ToString();
//if (out_trade_no == null) out_trade_no = "";
string trade_no = receive_jd["trade_no"].ToString();
string fees = receive_jd["fees"].ToString();
string pay_type = receive_jd["pay_type"].ToString();
string nonce_str = receive_jd["nonce_str"].ToString();
string sign = receive_jd["sign"].ToString();
string MD5Sign = SimonUtils.EnCodeMD5("fees=" + fees + "&" + "merchant_id=" + merchant_id + "&" + "nonce_str=" + nonce_str + "&" + "order_amount=" + order_amount + "&" + "out_trade_no=" + out_trade_no + "&" + "pay_amount=" + pay_amount + "&" + "pay_time=" + pay_time + "&" + "pay_type=" + pay_type + "&" + "request_time=" + request_time + "&" + "status=" + status + "&" + "trade_no=" + trade_no + s_key).ToUpper();
//记录日志
StringBuilder sb = new StringBuilder();
sb.Append("\r\n 暴风雪 异步通知 回调日志-----------------------------------------------------------------------------------");
sb.Append("\r\n requestMes=" + requestMes);
sb.Append("\r\n merchant_id=" + merchant_id);
sb.Append("\r\n request_time=" + request_time);
sb.Append("\r\n pay_time=" + pay_time);
sb.Append("\r\n status=" + status);
sb.Append("\r\n order_amount=" + order_amount);
sb.Append("\r\n pay_amount=" + pay_amount);
sb.Append("\r\n out_trade_no=" + out_trade_no);
sb.Append("\r\n trade_no=" + trade_no);
sb.Append("\r\n fees=" + fees);
sb.Append("\r\n pay_type=" + pay_type);
sb.Append("\r\n nonce_str=" + nonce_str);
sb.Append("\r\n sign=" + sign);
sb.Append("\r\n MD5Sign=" + MD5Sign);
sb.Append("\r\n--------------------------------------------------------------------------------------------------");
SimonLog.WriteLog(sb.ToString(), "/Log/", "log_paywap_error_" + DateTime.Now.ToString("yyyyMMdd"));
if (MD5Sign.Equals(sign, StringComparison.OrdinalIgnoreCase) && status == "success")
{
//交易成功
DataTable RMBCostDT = SimonDB.DataTable(@"select * from Web_RMBCost where OrderID=@OrderID", new DbParameter[] {
SimonDB.CreDbPar("@OrderID", out_trade_no)
});
if (RMBCostDT.Rows.Count <= 0)
{
Response.Write("订单不存在");
return;
}
DataRow RMBCostDR = RMBCostDT.Rows[0];
if (RMBCostDR["UpdateFlag"].ToString() == "1")
{
Response.Write("订单已处理");
return;
}
if (Convert.ToInt32(decimal.Parse(RMBCostDR["PayMoney"].ToString())) != Convert.ToInt32(decimal.Parse(order_amount)))
{
Response.Write("充值金额不符");
return;
}
//获取充值货币类型
string PurchaseType = RMBCostDT.Rows[0]["PurchaseType"].ToString();
//判断玩家账号是否存在
DbParameter[] userparms = new DbParameter[] { SimonDB.CreDbPar("@userid", RMBCostDR["Users_ids"]) };
DataTable UserDT = SimonDB.DataTable(@"select * from TUsers as a inner join TUserInfo as b on a.userid=b.userid where a.userid=@userid", userparms);
if (UserDT.Rows.Count <= 0)
{
Response.Write("用户不存在");
return;
}
DataRow UserDR = UserDT.Rows[0];
//判断充值兑换率
DataTable RechargeRateDT = SimonDB.DataTable(@"select * from RechargeRate where RechargeRMB=@RechargeRMB", new DbParameter[] {
SimonDB.CreDbPar("@RechargeRMB", RMBCostDR["PayMoney"].ToString())
});
if (RechargeRateDT.Rows.Count <= 0)
{
Response.Write("此充值金额的金币兑换率不存在");
return;
}
DataRow RechargeRateDR = RechargeRateDT.Rows[0];
//更新订单
List <DbParameter> rmbcost_lpar = new List <DbParameter>();
rmbcost_lpar.Add(SimonDB.CreDbPar("@OrderID", out_trade_no)); //订单号
rmbcost_lpar.Add(SimonDB.CreDbPar("@InMoney", Convert.ToInt32(decimal.Parse(order_amount))));
rmbcost_lpar.Add(SimonDB.CreDbPar("@InSuccess", true));
rmbcost_lpar.Add(SimonDB.CreDbPar("@PaySuccess", true));
rmbcost_lpar.Add(SimonDB.CreDbPar("@UpdateFlag", "1")); //更新状态
SimonDB.ExecuteNonQuery(@"update Web_RMBCost set InMoney=@InMoney,InSuccess=@InSuccess,
PaySuccess=@PaySuccess,UpdateFlag=@UpdateFlag
where OrderID=@OrderID", rmbcost_lpar.ToArray());
if (PurchaseType == "1")
{
//充值金币动作
SimonDB.ExecuteNonQuery(@"update TUserInfo set WalletMoney=WalletMoney+@ChangeMoney where UserID=@UserID", new DbParameter[] {
SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RechargeGold"].ToString()),
SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString())
});
//金币日志
SimonDB.ExecuteNonQuery(@"insert into Web_MoneyChangeLog (UserID,UserName,StartMoney,ChangeMoney,ChangeType,DateTime,Remark)
values (@UserID,@UserName,@StartMoney,@ChangeMoney,2,getdate(),@Remark)", new DbParameter[] {
SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString()),
SimonDB.CreDbPar("@UserName", UserDR["UserName"].ToString()),
SimonDB.CreDbPar("@StartMoney", UserDR["WalletMoney"].ToString()),
SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RechargeGold"].ToString()),
SimonDB.CreDbPar("@Remark", "暴风雪充值，订单号：" + trade_no)
});
//充值赠送金币
//SimonDB.ExecuteNonQuery(@"update TUserInfo set WalletMoney=WalletMoney+@ChangeMoney where UserID=@UserID", new DbParameter[] {
// SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RegiveGold"].ToString()),
// SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString())
// });
//充值赠送金币日志
//SimonDB.ExecuteNonQuery(@"insert into Web_MoneyChangeLog (UserID,UserName,StartMoney,ChangeMoney,ChangeType,DateTime,Remark)
// values (@UserID,@UserName,@StartMoney,@ChangeMoney,2,getdate(),@Remark)", new DbParameter[] {
// SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString()),
// SimonDB.CreDbPar("@UserName", UserDR["UserName"].ToString()),
// SimonDB.CreDbPar("@StartMoney", UserDR["WalletMoney"].ToString()),
// SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RegiveGold"].ToString()),
// SimonDB.CreDbPar("@Remark", "赠送金币,关联暴风雪订单号：" + trade_no)
// });
}
if (PurchaseType == "2")
{
//充值房卡动作
SimonDB.ExecuteNonQuery(@"update TUserInfo set RoomCard=RoomCard+@ChangeMoney where UserID=@UserID", new DbParameter[] {
SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RegiveGold"].ToString()),
SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString())
});
string RecordNum = DateTime.Now.ToString("yyyyMMddHHmmssfff");
//房卡日志
SimonDB.ExecuteNonQuery(@"insert into FangkaRecord (UserID,RecordNum,CurrencyType,StartCount,Count,DeductType,DeductTime,Remark)
values (@UserID,@RecordNum,1,@StartMoney,@ChangeMoney,2,getdate(),@Remark)", new DbParameter[] {
SimonDB.CreDbPar("@UserID", UserDR["UserID"].ToString()),
SimonDB.CreDbPar("@RecordNum", RecordNum),
SimonDB.CreDbPar("@StartMoney", UserDR["RoomCard"].ToString()),
SimonDB.CreDbPar("@ChangeMoney", RechargeRateDR["RegiveGold"].ToString()),
SimonDB.CreDbPar("@Remark", "暴风雪充值房卡，订单号：" + trade_no)
});
}
SimonUtils.RespW("success");
}
}
