public ActionResult AddRecharge(tb_Recharge model)
{
try
{
//检查数据库中是否存在该用户信息
var thisuser = db.tb_userinfos.Where(s => s.UserID == model.UserID).FirstOrDefault();
//检验话术分类是否存在
if (thisuser == null)
{
return(Json(Comm.ToJsonResult("Error", "用户不存在"), JsonRequestBehavior.AllowGet));
}
else
{
var addmodel = new tb_Recharge
{
CreateDateTime = DateTime.Now,
give = 0,
paytype = model.paytype,
R_Money = model.RechargeType.GetHashCode(),
U_ID = thisuser.ID,
RechargeType = model.RechargeType,
UserID = model.UserID
};
db.tb_Recharges.Add(addmodel);
db.SaveChanges();
return(Json(Comm.ToJsonResult("Success", "新增成功"), JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(Comm.ToJsonResult("Error", ex.Message), JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 接收返回的结果，根据结果处理订单状态
/// </summary>
public override void ProcessNotify()
{
WxPayData notifyData = GetNotifyData();
//检查支付结果中transaction_id是否存在
if (!notifyData.IsSet("transaction_id"))
{
Log.Debug("notifyData", $"notifyData:完成");
//若transaction_id不存在，则立即返回结果给微信支付后台
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "支付结果中微信订单号不存在");
Log.Error(this.GetType().ToString(), "The Pay result is error : " + res.ToXml());
page.Response.Write(res.ToXml());
page.Response.End();
}
string transaction_id = notifyData.GetValue("transaction_id").ToString();
string out_trade_no = notifyData.GetValue("out_trade_no").ToString();
//查询订单，判断订单真实性
if (!QueryOrder(transaction_id))
{
//若订单查询失败，则立即返回结果给微信支付后台
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "订单查询失败");
Log.Error(this.GetType().ToString(), "Order query failure : " + res.ToXml());
page.Response.Write(res.ToXml());
page.Response.End();
}
//查询订单成功
else
{
int row = 0;
#region 更改订单状态，保存支付结果
if (!string.IsNullOrEmpty(out_trade_no))
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
PayOrder order = db.PayOrders.FirstOrDefault(p => p.out_trade_no == out_trade_no && p.OrderState == Enums.Enums.OrderState.UnHandle);
if (order != null)
{
order.cash_fee = Convert.ToDecimal(notifyData.GetValue("total_fee").ToString()) / 100m;
order.transaction_id = transaction_id;
order.PayResult = notifyData.ToJson();
order.OrderState = notifyData.GetValue("result_code").ToString() == "SUCCESS" ? Enums.Enums.OrderState.Success : Enums.Enums.OrderState.Failed;
order.PayTime = DateTime.Now.ToString();
row = db.SaveChanges();
if (row > 0 && order.OrderState == Enums.Enums.OrderState.Success && order.OrderType == Enums.Enums.OrderType.Recharge)
{
//进行充值数据保存
tb_userinfo user = db.tb_userinfos.FirstOrDefault(s => s.UserID == order.User_ID);
var tempisfirstcharge = user.FirstCharge;
var tempbalance = user.Balance;
var addmodel = new tb_Recharge
{
CreateDateTime = DateTime.Now,
give = 0,
paytype = Enums.Enums.PayType.wx,
R_Money = order.cash_fee,
U_ID = user.ID,
RechargeType = ((Enums.Enums.RechargeType)order.cash_fee),
UserID = user.UserID,
PayOrderID = order.ID
};
user.Balance = tempbalance + order.cash_fee;
db.tb_Recharges.Add(addmodel);
db.SaveChanges();
}
}
}
}
#endregion
if (row > 0)
{
WxPayData res = new WxPayData();
res.SetValue("return_code", "SUCCESS");
res.SetValue("return_msg", "OK");
Log.Info(this.GetType().ToString(), "order query success : " + res.ToXml());
page.Response.Write(res.ToXml());
page.Response.End();
}
else
{//如果没更新成功，就继续接收通知
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", "未接收成功");
Log.Error(this.GetType().ToString(), "The recieve result is error : " + res.ToXml());
page.Response.Write(res.ToXml());
page.Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//try
//{
//Log.WriteLog("支付宝回调", "支付宝回调", "sdf");
string charset = "utf-8";
IDictionary <string, string> sArray = new Dictionary <string, string>();
NameValueCollection coll;
//Load Form variables into NameValueCollection variable.
coll = Request.Form;
String[] requestItem = coll.AllKeys;
for (int i = 0; i < requestItem.Length; i++)
{
sArray.Add(requestItem[i], Request.Form[requestItem[i]]);
}
string out_trade_no = Request.Form["out_trade_no"]; //订单号
string strPrice = Request.Form["receipt_amount"]; //金额 receipt_amount
string trade_status = Request.Form["trade_status"]; //交易状态
string gmt_payment = Request.Form["gmt_payment"]; //交易付款时间
//验证
bool flag = AlipaySignature.RSACheckV1(sArray, AliPayConfig.alipaypublickey, charset, "RSA2", false);
//验证成功
if (flag && (trade_status.Equals("TRADE_FINISHED") || trade_status.Equals("TRADE_SUCCESS")))
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
PayOrder order = db.PayOrders.FirstOrDefault(p => p.out_trade_no == out_trade_no && p.OrderState == Enums.Enums.OrderState.UnHandle);
if (order != null)
{
order.cash_fee = Decimal.Parse(strPrice);
order.transaction_id = string.Empty;
order.PayResult = string.Empty;
order.OrderState = trade_status == "TRADE_FINISHED" ? Enums.Enums.OrderState.Success : trade_status == "TRADE_SUCCESS" ? Enums.Enums.OrderState.Success : Enums.Enums.OrderState.Failed;
order.PayTime = gmt_payment;
int row = db.SaveChanges();
if (row > 0 && order.OrderState == Enums.Enums.OrderState.Success && order.OrderType == Enums.Enums.OrderType.Recharge)
{
//进行充值数据保存
tb_userinfo user = db.tb_userinfos.FirstOrDefault(s => s.UserID == order.User_ID);
var tempisfirstcharge = user.FirstCharge;
var tempbalance = user.Balance;
var addmodel = new tb_Recharge
{
CreateDateTime = DateTime.Now,
give = 0,
paytype = Enums.Enums.PayType.ali,
R_Money = order.cash_fee,
U_ID = user.ID,
RechargeType = ((Enums.Enums.RechargeType)order.cash_fee),
UserID = user.UserID,
PayOrderID = order.ID
};
user.Balance = tempbalance + order.cash_fee;
db.tb_Recharges.Add(addmodel);
db.SaveChanges();
Response.Write("success");
Response.End();
}
}
}
}
else
{
Response.Write("fail");
Response.End();
}
//}
//catch (Exception ex)
//{
// Log.WriteLog("支付宝支付回调错误", "支付宝回调", ex.Message);
//}
}