/// <summary>
/// 插入支付退款记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static int Insert(PayRefundInfo info)
{
string sql = @"
INSERT INTO Pay_Refund
(OrderId,TradeNo,PaymentAmt,RefundOrderId,RefundAmt,RefundNo,PayType,RequestData,ExecuteResult,ResultDesc,RequestSystemId,CreateTime)
VALUES (@OrderId,@TradeNo,@PaymentAmt,@RefundOrderId,@RefundAmt,@RefundNo,@PayType,@RequestData,@ExecuteResult,@ResultDesc,@RequestSystemId,@CreateTime);
SELECT SCOPE_IDENTITY();";
info.SysNo = DbHelper.QueryScalar <int>(sql, info);
return(info.SysNo);
}
/// <summary>
/// 保存退款请求记录
/// </summary>
/// <param name="data"></param>
/// <param name="payType"></param>
/// <returns></returns>
public static PayRefundInfo SavePayRefund(string data, AppEnum.PayType payType)
{
var payRefund = new PayRefundInfo()
{
PayType = (int)payType,
RequestData = data,
ExecuteResult = (int)ResultStatus.None,
CreateTime = DateTime.Now,
};
payRefund.SysNo = PayRefundDAL.Insert(payRefund);
return(payRefund);
}
/// <summary>
/// 更新支付退款记录（不更新RequestData字段）
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static bool Update(PayRefundInfo info)
{
string sql = @"
UPDATE Pay_Refund
SET OrderId=@OrderId,
TradeNo=@TradeNo,
PaymentAmt=@PaymentAmt,
RefundOrderId=@RefundOrderId,
RefundAmt=@RefundAmt,
RefundNo=@RefundNo,
PayType=@PayType,
ExecuteResult=@ExecuteResult,
ResultDesc=@ResultDesc,
RequestSystemId=@RequestSystemId
WHERE SysNo=@SysNo";
int count = DbHelper.Execute(sql, info);
return(count > 0);
}
/// <summary>
/// 获取退款请求的基本信息
/// </summary>
/// <param name="payRefund"></param>
/// <param name="data"></param>
/// <returns></returns>
public static PayRefundInfo GetPayRefundInfo(PayRefundInfo payRefund, string data)
{
var info = JsonHelper.Deserialize <RefundOrderInfo>(data);
if (info != null)
{
payRefund.OrderId = info.OrderId;
payRefund.TradeNo = info.TradeNo;
decimal paymentAmt = 0;
decimal.TryParse(info.PaymentAmt, out paymentAmt);
payRefund.PaymentAmt = paymentAmt;
payRefund.RefundOrderId = info.RefundOrderId;
decimal refundAmt = 0;
decimal.TryParse(info.RefundAmt, out refundAmt);
payRefund.RefundAmt = refundAmt;
int systemId = 0;
int.TryParse(info.SystemId, out systemId);
payRefund.RequestSystemId = systemId;
}
return(payRefund);
}