/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TransactionsEntity model)
{
try
{
return(TransactionsDb.Instance.Add(model));
}
catch (Exception ex)
{
WriteLog.WriteError(ex);
throw ex;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TransactionsEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sns_transactions(");
strSql.Append("UserId,NotifyTime,NotifyType,NotifyId,SignType,Sign,OutTradeNo,Subject,PaymentType,TradeNo,TradeStatus,GmtCreate,GmtPayment,GmtClose,SellerEmail,SellerId,BuyerEmail,BuyerId,TotalFee,Body,Discount,BusinessScene,ExtraCommonParam,Status)");
strSql.Append(" values (");
strSql.Append("@UserId,@NotifyTime,@NotifyType,@NotifyId,@SignType,@Sign,@OutTradeNo,@Subject,@PaymentType,@TradeNo,@TradeStatus,@GmtCreate,@GmtPayment,@GmtClose,@SellerEmail,@SellerId,@BuyerEmail,@BuyerId,@TotalFee,@Body,@Discount,@BusinessScene,@ExtraCommonParam,@Status)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserId", SqlDbType.VarChar, 50),
new SqlParameter("@NotifyTime", SqlDbType.DateTime),
new SqlParameter("@NotifyType", SqlDbType.VarChar, 50),
new SqlParameter("@NotifyId", SqlDbType.VarChar, 50),
new SqlParameter("@SignType", SqlDbType.VarChar, 50),
new SqlParameter("@Sign", SqlDbType.VarChar, 50),
new SqlParameter("@OutTradeNo", SqlDbType.VarChar, 64),
new SqlParameter("@Subject", SqlDbType.VarChar, 256),
new SqlParameter("@PaymentType", SqlDbType.VarChar, 4),
new SqlParameter("@TradeNo", SqlDbType.VarChar, 64),
new SqlParameter("@TradeStatus", SqlDbType.VarChar, 50),
new SqlParameter("@GmtCreate", SqlDbType.DateTime),
new SqlParameter("@GmtPayment", SqlDbType.DateTime),
new SqlParameter("@GmtClose", SqlDbType.DateTime),
new SqlParameter("@SellerEmail", SqlDbType.VarChar, 100),
new SqlParameter("@SellerId", SqlDbType.VarChar, 30),
new SqlParameter("@BuyerEmail", SqlDbType.VarChar, 100),
new SqlParameter("@BuyerId", SqlDbType.VarChar, 30),
new SqlParameter("@TotalFee", SqlDbType.VarChar, 50),
new SqlParameter("@Body", SqlDbType.VarChar, 1000),
new SqlParameter("@Discount", SqlDbType.VarChar, 50),
new SqlParameter("@BusinessScene", SqlDbType.VarChar, 50),
new SqlParameter("@ExtraCommonParam", SqlDbType.Text),
new SqlParameter("@Status", SqlDbType.Int, 4)
};
parameters[0].Value = UtilityHelper.SqlNull(model.UserId);
parameters[1].Value = UtilityHelper.SqlNull(model.NotifyTime);
parameters[2].Value = UtilityHelper.SqlNull(model.NotifyType);
parameters[3].Value = UtilityHelper.SqlNull(model.NotifyId);
parameters[4].Value = UtilityHelper.SqlNull(model.SignType);
parameters[5].Value = UtilityHelper.SqlNull(model.Sign);
parameters[6].Value = UtilityHelper.SqlNull(model.OutTradeNo);
parameters[7].Value = UtilityHelper.SqlNull(model.Subject);
parameters[8].Value = UtilityHelper.SqlNull(model.PaymentType);
parameters[9].Value = UtilityHelper.SqlNull(model.TradeNo);
parameters[10].Value = UtilityHelper.SqlNull(model.TradeStatus);
parameters[11].Value = UtilityHelper.SqlNull(model.GmtCreate);
parameters[12].Value = UtilityHelper.SqlNull(model.GmtPayment);
parameters[13].Value = UtilityHelper.SqlNull(model.GmtClose);
parameters[14].Value = UtilityHelper.SqlNull(model.SellerEmail);
parameters[15].Value = UtilityHelper.SqlNull(model.SellerId);
parameters[16].Value = UtilityHelper.SqlNull(model.BuyerEmail);
parameters[17].Value = UtilityHelper.SqlNull(model.BuyerId);
parameters[18].Value = UtilityHelper.SqlNull(model.TotalFee);
parameters[19].Value = UtilityHelper.SqlNull(model.Body);
parameters[20].Value = UtilityHelper.SqlNull(model.Discount);
parameters[21].Value = UtilityHelper.SqlNull(model.BusinessScene);
parameters[22].Value = UtilityHelper.SqlNull(model.ExtraCommonParam);
parameters[23].Value = UtilityHelper.SqlNull(model.Status);
object obj = SqlHelper.Instance.ExecSqlScalar(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
/////////////////////////////////////////////////////////////////////////////////////////////////////////////
//请在这里加上商户的业务逻辑程序代码
//——请根据您的业务逻辑来编写程序（以下代码仅作参考）——
//获取支付宝的通知返回参数，可参考技术文档中服务器异步通知参数列表
string user_id = Request.Form["extra_common_param"];
string notify_time = DateTime.Now.ToString(); //Request.Form["notify_time"]; //通知时间
string notify_type = ""; //Request.Form["notify_type"]; //通知类型
string notify_id = Request.Form["notify_id"]; //通知校验ID
string sign_type = Request.Form["sign_type"]; //签名方式
string sign = Request.Form["sign"]; //签名
string out_trade_no = Request.Form["out_trade_no"]; //商户订单号
string subject = Request.Form["subject"]; //商品名称
string payment_type = Request.Form["payment_type"]; //支付类型
string trade_no = Request.Form["trade_no"]; //支付宝交易号
string trade_status = Request.Form["trade_status"]; //交易状态
string gmt_create = DateTime.Now.ToString(); //交易创建时间
string gmt_payment = DateTime.Now.ToString(); //交易付款时间
string gmt_close = DateTime.Now.ToString(); //交易关闭时间
string seller_email = Request.Form["seller_email"]; //卖家支付宝账号
string seller_id = Request.Form["seller_id"]; //卖家支付宝账户号
string buyer_email = Request.Form["buyer_email"]; //买家支付宝账号
string buyer_id = Request.Form["buyer_id"]; //买家支付宝账户号
string total_fee = Request.Form["total_fee"]; //交易金额
string body = Request.Form["body"]; //商品描述
string discount = Request.Form["discount"]; //折扣
string business_scene = Request.Form["business_scene"]; //是否扫码支付
string extra_common_param = Request.Form["extra_common_param"]; //公用回传参数
TransactionsEntity transactionsEntity = new TransactionsEntity();
transactionsEntity.UserId = user_id;
transactionsEntity.NotifyTime = Convert.ToDateTime(notify_time);
transactionsEntity.NotifyType = notify_type;
transactionsEntity.NotifyId = notify_id;
transactionsEntity.SignType = sign_type;
transactionsEntity.Sign = sign;
transactionsEntity.OutTradeNo = out_trade_no;
transactionsEntity.Subject = subject;
transactionsEntity.PaymentType = payment_type;
transactionsEntity.TradeNo = trade_no;
transactionsEntity.TradeStatus = trade_status;
transactionsEntity.GmtCreate = Convert.ToDateTime(gmt_create);
transactionsEntity.GmtPayment = Convert.ToDateTime(gmt_payment);
transactionsEntity.GmtClose = Convert.ToDateTime(gmt_close);
transactionsEntity.SellerEmail = seller_email;
transactionsEntity.SellerId = seller_id;
transactionsEntity.BuyerEmail = buyer_email;
transactionsEntity.BuyerId = buyer_id;
transactionsEntity.TotalFee = total_fee;
transactionsEntity.Body = body;
transactionsEntity.Discount = discount;
transactionsEntity.BusinessScene = business_scene;
transactionsEntity.ExtraCommonParam = extra_common_param;
transactionsEntity.Status = 1;
TransactionsBll.Instance.Add(transactionsEntity);
//保存到充值记录表
RechargeRecordEntity rechargeRecordEntity = new RechargeRecordEntity();
rechargeRecordEntity.UserId = user_id;
rechargeRecordEntity.RMB = double.Parse(total_fee).ToString();
if (subject.IndexOf("身家", StringComparison.Ordinal) > -1)
{
rechargeRecordEntity.source = "ShenJiaRecharge";
rechargeRecordEntity.Cnbi = "0";
}
else if (subject.IndexOf("会员", StringComparison.Ordinal) > -1)
{
rechargeRecordEntity.source = "PurchaseVip";
rechargeRecordEntity.Cnbi = "0";
}
else if (subject.IndexOf("押金", StringComparison.Ordinal) > -1)
{
rechargeRecordEntity.source = "Deposit";
rechargeRecordEntity.Cnbi = "0";
}
else
{
rechargeRecordEntity.source = "";
rechargeRecordEntity.Cnbi = (double.Parse(total_fee) * 100).ToString();
}
rechargeRecordEntity.addTime = DateTime.Now;
rechargeRecordEntity.OrderNo = out_trade_no;
rechargeRecordEntity.OrderName = subject;
rechargeRecordEntity.wareDesc = body;
rechargeRecordEntity.Status = 1;
RechargeRecordBll.Instance.Add(rechargeRecordEntity);
//保存到积分变更表
IntegralChangeEntity integralChangeEntity = new IntegralChangeEntity();
integralChangeEntity.UserId = user_id;
integralChangeEntity.source = "ShenJiaRecharge";
integralChangeEntity.ShenJia = decimal.Parse(total_fee);
integralChangeEntity.Bean = "0";
integralChangeEntity.Cnbi = rechargeRecordEntity.Cnbi;
integralChangeEntity.integral = 0;
integralChangeEntity.Growth = 0;
integralChangeEntity.Status = 1;
integralChangeEntity.ardent = 0;
integralChangeEntity.AddTime = DateTime.Now;
IntegralChangeBll.Instance.Add(integralChangeEntity);
//更新会员表
if (subject.IndexOf("身家", StringComparison.Ordinal) > -1)
{
MemberBll.Instance.UpdateIntegral(user_id, "ShenJia", integralChangeEntity.ShenJia.ToString());
}
else if (subject.IndexOf("会员", StringComparison.Ordinal) > -1)
{
//string month = (double.Parse(total_fee)/0.01).ToString();
MemberBll.Instance.UpdateVip(user_id, total_fee);
}
else if (subject.IndexOf("押金", StringComparison.Ordinal) > -1)
{
MemberBll.Instance.UpdateIntegral(user_id, "Deposit", total_fee);
}
else
{
MemberBll.Instance.UpdateIntegral(user_id, "Cnbi", integralChangeEntity.Cnbi);
}
//——请根据您的业务逻辑来编写程序（以上代码仅作参考）——
Response.Write("success"); //请不要修改或删除
/////////////////////////////////////////////////////////////////////////////////////////////////////////////
}
catch (Exception ex)
{
Response.Write("错误：" + ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
SortedDictionary <string, string> sPara = GetRequestPost();
if (sPara.Count > 0)//判断是否有带返回参数
{
Notify aliNotify = new Notify();
bool verifyResult = aliNotify.Verify(sPara, Request.Form["notify_id"], Request.Form["sign"]);
try
{
if (verifyResult)//验证成功
{
/////////////////////////////////////////////////////////////////////////////////////////////////////////////
//请在这里加上商户的业务逻辑程序代码
//——请根据您的业务逻辑来编写程序（以下代码仅作参考）——
//获取支付宝的通知返回参数，可参考技术文档中服务器异步通知参数列表
string user_id = Request.Form["extra_common_param"];
string notify_time = DateTime.Now.ToString(); //Request.Form["notify_time"]; //通知时间
string notify_type = ""; //Request.Form["notify_type"]; //通知类型
string notify_id = Request.Form["notify_id"]; //通知校验ID
string sign_type = Request.Form["sign_type"]; //签名方式
string sign = Request.Form["sign"]; //签名
string out_trade_no = Request.Form["out_trade_no"]; //商户订单号
string subject = Request.Form["subject"]; //商品名称
string payment_type = Request.Form["payment_type"]; //支付类型
string trade_no = Request.Form["trade_no"]; //支付宝交易号
string trade_status = Request.Form["trade_status"]; //交易状态
string gmt_create = DateTime.Now.ToString(); //交易创建时间
string gmt_payment = DateTime.Now.ToString(); //交易付款时间
string gmt_close = DateTime.Now.ToString(); //交易关闭时间
string seller_email = Request.Form["seller_email"]; //卖家支付宝账号
string seller_id = Request.Form["seller_id"]; //卖家支付宝账户号
string buyer_email = Request.Form["buyer_email"]; //买家支付宝账号
string buyer_id = Request.Form["buyer_id"]; //买家支付宝账户号
string total_fee = Request.Form["total_fee"]; //交易金额
string body = Request.Form["body"]; //商品描述
string discount = Request.Form["discount"]; //折扣
string business_scene = Request.Form["business_scene"]; //是否扫码支付
string extra_common_param = Request.Form["extra_common_param"]; //公用回传参数
TransactionsEntity transactionsEntity = new TransactionsEntity();
transactionsEntity.UserId = user_id;
transactionsEntity.NotifyTime = Convert.ToDateTime(notify_time);
transactionsEntity.NotifyType = notify_type;
transactionsEntity.NotifyId = notify_id;
transactionsEntity.SignType = sign_type;
transactionsEntity.Sign = sign;
transactionsEntity.OutTradeNo = out_trade_no;
transactionsEntity.Subject = subject;
transactionsEntity.PaymentType = payment_type;
transactionsEntity.TradeNo = trade_no;
transactionsEntity.TradeStatus = trade_status;
transactionsEntity.GmtCreate = Convert.ToDateTime(gmt_create);
transactionsEntity.GmtPayment = Convert.ToDateTime(gmt_payment);
transactionsEntity.GmtClose = Convert.ToDateTime(gmt_close);
transactionsEntity.SellerEmail = seller_email;
transactionsEntity.SellerId = seller_id;
transactionsEntity.BuyerEmail = buyer_email;
transactionsEntity.BuyerId = buyer_id;
transactionsEntity.TotalFee = total_fee;
transactionsEntity.Body = body;
transactionsEntity.Discount = discount;
transactionsEntity.BusinessScene = business_scene;
transactionsEntity.ExtraCommonParam = extra_common_param;
transactionsEntity.Status = 1;
TransactionsBll.Instance.Add(transactionsEntity);
if (Request.Form["trade_status"] == "TRADE_FINISHED") //在指定时间段内未支付时关闭的交易；在交易完成全额退款成功时关闭的交易。
{
// //判断该笔订单是否在商户网站中已经做过处理
// //如果没有做过处理，根据订单号（out_trade_no）在商户网站的订单系统中查到该笔订单的详细，并执行商户的业务程序
// //请务必判断请求时的total_fee、seller_id与通知时获取的total_fee、seller_id为一致的
// //如果有做过处理，不执行商户的业务程序
// //注意：
// //退款日期超过可退款期限后（如三个月可退款），支付宝系统发送该交易状态通知
}
else if (Request.Form["trade_status"] == "TRADE_SUCCESS") //交易成功，且可对该交易做操作，如：多级分润、退款等。
{
//保存到充值记录表
RechargeRecordEntity rechargeRecordEntity = new RechargeRecordEntity();
rechargeRecordEntity.UserId = user_id;
rechargeRecordEntity.RMB = double.Parse(total_fee).ToString();
if (subject.IndexOf("身家", StringComparison.Ordinal) > -1)
{
rechargeRecordEntity.source = "ShenJiaRecharge";
rechargeRecordEntity.Cnbi = "0";
}
else if (subject.IndexOf("会员", StringComparison.Ordinal) > -1)
{
rechargeRecordEntity.source = "PurchaseVip";
rechargeRecordEntity.Cnbi = "0";
}
else if (subject.IndexOf("押金", StringComparison.Ordinal) > -1)
{
rechargeRecordEntity.source = "Deposit";
rechargeRecordEntity.Cnbi = "0";
}
else
{
rechargeRecordEntity.source = "";
rechargeRecordEntity.Cnbi = (double.Parse(total_fee) * 100).ToString();
}
rechargeRecordEntity.addTime = DateTime.Now;
rechargeRecordEntity.OrderNo = out_trade_no;
rechargeRecordEntity.OrderName = subject;
rechargeRecordEntity.wareDesc = body;
rechargeRecordEntity.Status = 1;
RechargeRecordBll.Instance.Add(rechargeRecordEntity);
//保存到积分变更表
IntegralChangeEntity integralChangeEntity = new IntegralChangeEntity();
integralChangeEntity.UserId = user_id;
integralChangeEntity.source = "ShenJiaRecharge";
integralChangeEntity.ShenJia = decimal.Parse(total_fee);
integralChangeEntity.Bean = "0";
integralChangeEntity.Cnbi = rechargeRecordEntity.Cnbi;
integralChangeEntity.integral = 0;
integralChangeEntity.Growth = 0;
integralChangeEntity.Status = 1;
integralChangeEntity.ardent = 0;
integralChangeEntity.AddTime = DateTime.Now;
IntegralChangeBll.Instance.Add(integralChangeEntity);
//更新会员表
if (subject.IndexOf("身家", StringComparison.Ordinal) > -1)
{
MemberBll.Instance.UpdateIntegral(user_id, "ShenJia", integralChangeEntity.ShenJia.ToString());
}
else if (subject.IndexOf("会员", StringComparison.Ordinal) > -1)
{
//string month = (double.Parse(total_fee)/0.01).ToString();
MemberBll.Instance.UpdateVip(user_id, total_fee);
}
else if (subject.IndexOf("押金", StringComparison.Ordinal) > -1)
{
MemberBll.Instance.UpdateIntegral(user_id, "Deposit", total_fee);
}
else
{
MemberBll.Instance.UpdateIntegral(user_id, "Cnbi", integralChangeEntity.Cnbi);
}
}
else
{
}
//——请根据您的业务逻辑来编写程序（以上代码仅作参考）——
Response.Write("success"); //请不要修改或删除
/////////////////////////////////////////////////////////////////////////////////////////////////////////////
}
else//验证失败
{
Core.LogResult("验证失败");
Response.Write("fail");
}
}
catch (Exception ex)
{
Core.LogResult("错误：" + ex.Message);
}
}
else
{
Response.Write("无通知参数");
}
}
