public int Insert(RefundPointInfo info)
{
DataCommand command = DataCommandManager.GetDataCommand("InsertNetPayExtension");
command.SetParameterValue("@OrderType", info.OrderType);
command.SetParameterValue("@OrderSysNo", info.OrderSysNo);
command.SetParameterValue("@SOSysNo", info.SOSysNo);
command.SetParameterValue("@OrderAmt", info.OrderAmt);
command.SetParameterValue("@PayAmt", info.PayAmt);
command.SetParameterValue("@InUser", info.InUser);
command.SetParameterValue("@EditUser", info.EditUser);
command.SetParameterValue("@PayTypeSysNo", info.PayTypeSysNo);
command.SetParameterValue("@ReferenceID", info.ReferenceID);
command.SetParameterValue("@ExternalKey", info.ExternalKey);
command.SetParameterValue("@Note", info.Note);
command.SetParameterValue("@Status", info.RefundStatus);
command.SetParameterValue("@ResponseContent", info.ResponseContent);
command.SetParameterValue("@CompanyCode", info.CompanyCode);
command.SetParameterValue("@LanguageCode", "zh-CN");
command.SetParameterValue("@CurrencySysNo", info.CurrencySysNo);
command.SetParameterValue("@StoreCompanyCode", "8601");
command.SetParameterValue("@RefundLogSysNo", info.RefundLogSysNo);
return(Convert.ToInt32(command.ExecuteScalar()));
}
public void Update(RefundPointInfo info)
{
DataCommand command = DataCommandManager.GetDataCommand("UpdateNetPayExtension");
command.SetParameterValue("@SysNo", info.SysNo);
command.SetParameterValue("@EditDate", info.EditDate);
command.SetParameterValue("@EditUser", info.EditUser);
command.SetParameterValue("@Status", info.RefundStatus);
command.SetParameterValue("@ResponseContent", info.ResponseContent);
command.ExecuteNonQuery();
}
/// <summary>
/// 更新收款单
/// </summary>
/// <param name="info"></param>
public void UpdateSOIncome(RefundPointInfo info)
{
DataCommand command = DataCommandManager.GetDataCommand("UpdateSoIncome");
command.SetParameterValue("@ConfirmTime", info.EditDate);
command.SetParameterValue("@ConfirmUserSysNo", info.CreateUserSysNo);
command.SetParameterValue("@Status", 1);
command.SetParameterValue("@OrderSysNo", info.OrderSysNo);
command.SetParameterValue("@OrderType", (int)info.OrderType);
command.SetParameterValue("@CompanyCode", info.CompanyCode);
command.ExecuteNonQuery();
}
public virtual int RefundPrepayCard(RefundPrepayCardInfo info)
{
SOIncomeRefundInfo entity = m_SOIncomeRefundDA.GetSOIncomeRefundByID(info.SOIncomeBankInfoSysNo.Value, info.CompanyCode);
string tNumber = string.Empty;
decimal refundAmt = 0M, payAmt = 0M;
int soSysNo = entity.SOSysNo.Value;
string message = string.Empty;
int result = 0;
#region 业务验证
if (entity == null)
{
ThrowBizException("SOIncomeRefund_NoRefundAudit", info.SOIncomeBankInfoSysNo.Value);
}
if (entity.Status != RefundStatus.Audit)
{
ThrowBizException("SOIncomeRefund_RefundStatusError", entity.OrderSysNo);
}
NetPayInfo netPay = null;
SOBaseInfo so = ExternalDomainBroker.GetSOBaseInfo(entity.SOSysNo.Value);
//如果是子单，则需要查询母单对应的NetPay信息
if (so.SOSplitMaster.HasValue)
{
soSysNo = so.SOSplitMaster.Value;
netPay = m_NetPayDA.GetValidBySOSysNo(soSysNo);
if (netPay == null)
{
ThrowBizException("SOIncomeRefund_NoMasterNetPay", entity.SOSysNo, soSysNo);
}
if (string.IsNullOrEmpty(netPay.ExternalKey))
{
ThrowBizException("SOIncomeRefund_NoMasterExternalKey", entity.SOSysNo, soSysNo);
}
if (netPay.ExternalKey.Trim().Length == 0)
{
ThrowBizException("SOIncomeRefund_MasterExternalKeyLengthError", entity.SOSysNo, soSysNo);
}
}
//获取子单的NetPay信息
netPay = m_NetPayDA.GetValidBySOSysNo(entity.SOSysNo.Value);
if (netPay == null)
{
ThrowBizException("SOIncomeRefund_NoNetPay", entity.SOSysNo.Value);
}
//如果不是子单，则需要验证支付流水号
if (!so.SOSplitMaster.HasValue)
{
if (string.IsNullOrEmpty(netPay.ExternalKey))
{
ThrowBizException("SOIncomeRefund_NoExternalKey", entity.SOSysNo.Value);
}
if (netPay.ExternalKey.Trim().Length == 0)
{
ThrowBizException("SOIncomeRefund_ExternalKeyLengthError", entity.SOSysNo.Value);
}
}
tNumber = netPay.ExternalKey.Trim();
List <SOIncomeInfo> list = m_SOIncomeDA.GetListByCriteria(null, entity.OrderSysNo, (SOIncomeOrderType)entity.OrderType, new List <SOIncomeStatus>());
if (list == null || list.Count == 0)
{
ThrowBizException("SOIncomeRefund_NoIncomeInfo", entity.OrderSysNo);
}
SOIncomeInfo soIncome = list.Find(e => e.Status != SOIncomeStatus.Abandon);
if (soIncome == null)
{
ThrowBizException("SOIncomeRefund_NoIncomeInfo", entity.OrderSysNo);
}
if (soIncome.Status == SOIncomeStatus.Confirmed)
{
ThrowBizException("SOIncomeRefund_HasConfirmed", entity.OrderSysNo);
}
#endregion
refundAmt = entity.HaveAutoRMA.Value ? soIncome.IncomeAmt.Value : entity.RefundCashAmt.Value;
payAmt = netPay.PayAmount.Value;
//如果存在多笔退款，则payamt应该取最后一次退款时的payamt
if (m_SOIncomeRefundDA.GetRefundOrder(entity.SOSysNo.Value, entity.CompanyCode) > 1)
{
payAmt = m_SOIncomeRefundDA.GetPayAmountBeHis(entity.SOSysNo.Value, entity.CompanyCode);
}
payAmt = payAmt - refundAmt;
#region 写请求日志
RefundPointInfo log = new RefundPointInfo
{
RefundStatus = RefundPointStatus.Origin,
OrderType = entity.OrderType,
ReferenceID = string.Format("{0}.{1}", entity.SysNo.Value, soIncome.SysNo.Value),
PayAmt = payAmt,
InUser = ExternalDomainBroker.GetUserInfoBySysNo(ServiceContext.Current.UserSysNo).UserDisplayName,
EditDate = DateTime.Now,
CurrencySysNo = 1,
SOSysNo = entity.SOSysNo,
OrderAmt = so.SOTotalAmount,
ExternalKey = netPay.ExternalKey,
CompanyCode = entity.CompanyCode,
PayTypeSysNo = so.PayTypeSysNo.Value,
CreateUserSysNo = info.UserSysNo,
OrderSysNo = entity.OrderSysNo
};
int logSysNo = m_RefundPointDA.Insert(log);
log.SysNo = logSysNo;
log.EditDate = DateTime.Now;
log.EditUser = ExternalDomainBroker.GetUserInfoBySysNo(ServiceContext.Current.UserSysNo).UserDisplayName;
#endregion
#region 请求ThirdPartService，代理访问神州运通退款服务
try
{
//退款状态：1.退款成功 2.退款失败（会直接抛出异常，不作特殊处理）3.神州运通需要进行人工处理
result = ExternalDomainBroker.RefundPrepayCard(refundAmt, soSysNo, tNumber, log.ReferenceID);
//退款成功
if (result == 1)
{
log.RefundStatus = RefundPointStatus.Success;
log.ResponseContent = string.Empty;
}
//神州运运通需要进行人工处理，处理完成后调用Newegg的OPenAPI进行状态回写
else if (result == 3)
{
log.RefundStatus = RefundPointStatus.Processing;
message = log.ResponseContent = "神州运通需要进行人工处理";
}
m_RefundPointDA.Update(log);
if (result == 1)
{
//更新收款单
m_RefundPointDA.UpdateSOIncome(log);
}
}
catch (Exception ex)
{
result = -1;
ExceptionHelper.HandleException(ex);
log.RefundStatus = RefundPointStatus.Failure;
log.ResponseContent = string.Format("{0}|{1}", ex.Message, ex.StackTrace);
//string errorInfo = string.Format("订单{0}远程异常:{1}", entity.OrderSysNo, ex.Message);
string errorInfo = GetMessageString("SOIncomeRefund_OrderRemoteError", entity.OrderSysNo, ex.Message);
throw new BizException(errorInfo);
}
#endregion
return(result);
}
