/// <summary>
/// 商户提现申请单打款失败
/// danny-20150511
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool BusinessWithdrawPayFailed(BusinessWithdrawLogModel model)
{
string sql = string.Format(@"
UPDATE BusinessWithdrawForm
SET [Status] = @Status,
Payer=@Operator,
PayTime=getdate(),
PayFailedReason=@PayFailedReason
OUTPUT
Inserted.Id,
Inserted.[Status],
@Remark,
@Operator,
getdate()
INTO BusinessWithdrawLog
([WithwardId],
[Status],
[Remark],
[Operator],
[OperatTime])
WHERE Id = @Id");
IDbParameters parm = DbHelper.CreateDbParameters();
parm.AddWithValue("@Status", model.Status);
parm.AddWithValue("@Operator", model.Operator);
parm.AddWithValue("@Remark", model.Remark);
parm.AddWithValue("@PayFailedReason", model.PayFailedReason);
parm.AddWithValue("@Id", model.WithwardId);
return(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm) > 0);
}
public JsonResult WithdrawAuditRefuse(string withwardId, string auditFailedReason)
{
var businessWithdrawLog = new BusinessWithdrawLogModel()
{
Operator = UserContext.Current.Name,
Remark = "商户提款申请单审核拒绝-" + auditFailedReason,
Status = BusinessWithdrawFormStatus.TurnDown.GetHashCode(),
WithwardId = Convert.ToInt64(withwardId),
AuditFailedReason = auditFailedReason
};
bool reg = iBusinessFinanceProvider.BusinessWithdrawAuditRefuse(businessWithdrawLog);
return(Json(new ResultModel(reg, reg ? "审核拒绝成功！" : "审核拒绝失败！"), JsonRequestBehavior.DenyGet));
}
public JsonResult WithdrawPayFailed(string withwardId, string payFailedReason)
{
var businessWithdrawLog = new BusinessWithdrawLogModel()
{
Operator = UserContext.Current.Name,
Remark = "商户提款申请单打款失败-" + payFailedReason,
Status = BusinessWithdrawFormStatus.Error.GetHashCode(),
WithwardId = Convert.ToInt64(withwardId),
PayFailedReason = payFailedReason
};
bool reg = iBusinessFinanceProvider.BusinessWithdrawPayFailed(businessWithdrawLog);
return(Json(new ResultModel(reg, reg ? "打款失败操作提交成功！" : "打款失败操作提交失败！"), JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 商户提现失败后返现
/// danny-20150511
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool BusinessWithdrawReturn(BusinessWithdrawLogModel model)
{
string sql = string.Format(@"
insert into BusinessBalanceRecord
([BusinessId]
,[Amount]
,[Status]
,[Balance]
,[RecordType]
,[Operator]
,[OperateTime]
,[WithwardId]
,[RelationNo]
,[Remark])
select bbr.[BusinessId]
,-ISNULL(bbr.[Amount],0) Amount
,@NewStatus [Status]
,-ISNULL(bbr.[Amount],0)+ISNULL(b.BalancePrice,0) Balance
,@NewRecordType [RecordType]
,@Operator
,getdate() OperateTime
,bbr.[WithwardId]
,bbr.[RelationNo]
,@Remark
from BusinessBalanceRecord bbr (nolock)
join business b (nolock) on b.Id=bbr.BusinessId
where bbr.WithwardId=@WithwardId and bbr.Status=@Status and bbr.RecordType=@RecordType;");
IDbParameters parm = DbHelper.CreateDbParameters();
parm.AddWithValue("@Operator", model.Operator);
parm.AddWithValue("@Remark", model.Remark);
parm.AddWithValue("@WithwardId", model.WithwardId);
parm.AddWithValue("@Status", BusinessBalanceRecordStatus.Tradeing);
parm.AddWithValue("@RecordType", BusinessBalanceRecordRecordType.WithdrawApply);
parm.AddWithValue("@NewStatus", BusinessBalanceRecordStatus.Success);
parm.AddWithValue("@NewRecordType", model.Status == BusinessWithdrawFormStatus.TurnDown.GetHashCode() ?BusinessBalanceRecordRecordType.WithdrawRefuse :BusinessBalanceRecordRecordType.PayFailure);
return(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm) > 0);
}
/// <summary>
/// 商户提现申请单打款失败
/// danny-20150511
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool BusinessWithdrawPayFailed(BusinessWithdrawLogModel model)
{
bool reg = false;
using (IUnitOfWork tran = EdsUtilOfWorkFactory.GetUnitOfWorkOfEDS())
{
if (businessFinanceDao.BusinessWithdrawReturn(model))
{
if (businessFinanceDao.BusinessWithdrawPayFailed(model))
{
if (businessFinanceDao.ModifyBusinessBalanceRecordStatus(model.WithwardId.ToString()))
{
if (businessFinanceDao.ModifyBusinessAmountInfo(model.WithwardId.ToString()))
{
reg = true;
tran.Complete();
}
}
}
}
}
return(reg);
}