/// <summary> /// 骑士提现申请单打款失败 /// danny-20150513 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool ClienterWithdrawPayFailed(ClienterWithdrawLogModel model) { string sql = string.Format(@" UPDATE ClienterWithdrawForm SET [Status] = @Status, Payer=@Operator, PayTime=getdate(), PayFailedReason=@PayFailedReason OUTPUT Inserted.Id, Inserted.[Status], @Remark, @Operator, getdate() INTO ClienterWithdrawLog ([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 WithdrawPayFailed(string withwardId, string payFailedReason) { var clienterWithdrawLog = new ClienterWithdrawLogModel() { Operator = UserContext.Current.Name, Remark = "骑士提款申请单打款失败-" + payFailedReason, Status = ClienterWithdrawFormStatus.Error.GetHashCode(), WithwardId = Convert.ToInt64(withwardId), PayFailedReason = payFailedReason }; var reg = iClienterFinanceProvider.ClienterWithdrawPayFailed(clienterWithdrawLog); return(Json(new ResultModel(reg, reg ? "打款失败操作提交成功!" : "打款失败操作提交失败!"), JsonRequestBehavior.DenyGet)); }
public JsonResult WithdrawAuditRefuse(string withwardId, string auditFailedReason) { var clienterWithdrawLog = new ClienterWithdrawLogModel() { Operator = UserContext.Current.Name, Remark = "骑士提款申请单审核拒绝-" + auditFailedReason, Status = ClienterWithdrawFormStatus.TurnDown.GetHashCode(), WithwardId = Convert.ToInt64(withwardId), AuditFailedReason = auditFailedReason }; var reg = iClienterFinanceProvider.ClienterWithdrawAuditRefuse(clienterWithdrawLog); return(Json(new ResultModel(reg, reg ? "审核拒绝成功!" : "审核拒绝失败!"), JsonRequestBehavior.DenyGet)); }
/// <summary> /// 骑士提现失败后返现 /// danny-20150513 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool ClienterWithdrawReturn(ClienterWithdrawLogModel model) { string sql = string.Format(@" insert into ClienterBalanceRecord ([ClienterId] ,[Amount] ,[Status] ,[Balance] ,[RecordType] ,[Operator] ,[OperateTime] ,[WithwardId] ,[RelationNo] ,[Remark]) select cbr.[ClienterId] ,-ISNULL(cbr.[Amount],0) Amount ,@NewStatus [Status] ,-ISNULL(cbr.[Amount],0)+ISNULL(c.AccountBalance,0) Balance ,@NewRecordType [RecordType] ,@Operator ,getdate() OperateTime ,cbr.[WithwardId] ,cbr.[RelationNo] ,@Remark from ClienterBalanceRecord cbr (nolock) join clienter c (nolock) on c.Id=cbr.ClienterId where cbr.WithwardId=@WithwardId and cbr.Status=@Status and cbr.RecordType=@RecordType;"); IDbParameters parm = DbHelper.CreateDbParameters(); parm.AddWithValue("@Operator", model.Operator); parm.AddWithValue("@Remark", model.Remark); parm.AddWithValue("@WithwardId", model.WithwardId); parm.AddWithValue("@Status", ClienterBalanceRecordStatus.Tradeing.GetHashCode()); parm.AddWithValue("@RecordType", ClienterBalanceRecordRecordType.WithdrawApply.GetHashCode()); parm.AddWithValue("@NewStatus", ClienterBalanceRecordStatus.Success.GetHashCode()); parm.AddWithValue("@NewRecordType", model.Status == ClienterWithdrawFormStatus.TurnDown.GetHashCode() ? ClienterBalanceRecordRecordType.WithdrawRefuse : ClienterBalanceRecordRecordType.PayFailure); return(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm) > 0); }
/// <summary> /// 骑士提现申请单打款失败 /// danny-20150513 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool ClienterWithdrawPayFailed(ClienterWithdrawLogModel model) { bool reg = false; using (IUnitOfWork tran = EdsUtilOfWorkFactory.GetUnitOfWorkOfEDS()) { if (clienterFinanceDao.ClienterWithdrawReturn(model)) { if (clienterFinanceDao.ClienterWithdrawPayFailed(model)) { if (clienterFinanceDao.ModifyClienterBalanceRecordStatus(model.WithwardId.ToString())) { if (clienterFinanceDao.ModifyClienterAmountInfo(model.WithwardId.ToString())) { reg = true; tran.Complete(); } } } } } return(reg); }