/// <summary>
/// 骑士提现申请单确认打款
/// danny-20150513
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool ClienterWithdrawPayOk(ClienterWithdrawLog model)
{
string sql = string.Format(@"
UPDATE ClienterWithdrawForm
SET [Status] = @Status,
Payer=@Operator,
PayTime=getdate()
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("@Id", model.WithwardId);
return(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm) > 0);
}
/// <summary>
/// 骑士批量审核通过（只审核待审核状态的数据）
/// </summary>
/// <UpdateBy>zhaohailong</UpdateBy>
/// <UpdateTime>20150625</UpdateTime>
/// <param name="withwardIds"></param>
/// <returns></returns>
public JsonResult BatchWithdrawAuditOk(string withwardIds)
{
bool hasError = false;
bool hasSuccess = false;
string totalMsg = "审核成功";
if (!string.IsNullOrEmpty(withwardIds))
{
string[] ids = withwardIds.Split('#');
Dictionary <string, string> errorResult = new Dictionary <string, string>();
foreach (string item in ids)
{
string[] realids = item.Split(',');
var businessWithdrawLog = new ClienterWithdrawLog()
{
Operator = UserContext.Current.Name,
Remark = "商户提款申请单审核通过",
Status = ClienterWithdrawFormStatus.Allow.GetHashCode(),
WithwardId = Convert.ToInt64(realids[0])
};
try
{
bool reg = iClienterFinanceProvider.ClienterWithdrawAudit(businessWithdrawLog);
if (reg == false)
{
hasError = true;
errorResult.Add(realids[1], "");
}
else
{
hasSuccess = true;
}
}
catch (Exception ex)
{
hasError = true;
errorResult.Add(realids[1], ex.Message);
}
}
if (hasError)
{
totalMsg = "";
string[] error = errorResult.Where(p => p.Value == "").Select(p => p.Key).ToArray();
if (error != null && error.Length > 0)
{
totalMsg = "以下单号审核失败,请重试！\n" + string.Join("\n", error);
}
string excepptionMsg = errorResult.Where(p => p.Value != "").Select(p => p.Value).FirstOrDefault();
if (!string.IsNullOrEmpty(excepptionMsg))
{
string[] exceptionIDs = errorResult.Where(p => p.Value != "").Select(p => p.Key).ToArray();
totalMsg += string.Format("\n以下单号审核失败:{0}！\n{1}\n", excepptionMsg, string.Join("\n", exceptionIDs));
}
}
}
return(Json(new ResultModel(hasSuccess, totalMsg), JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 审核骑士提现申请单
/// danny-20150513
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool ClienterWithdrawAudit(ClienterWithdrawLog model)
{
bool isClienterIDValid = _clienterDao.IsBussinessOrClienterValidByID(1, model.WithwardId);
if (isClienterIDValid)
{
return(clienterFinanceDao.ClienterWithdrawAudit(model));
}
throw new Exception("提款单对应的骑士已经被取消资格，请联系客服");
}
public JsonResult WithdrawPayOk(string withwardId)
{
var clienterWithdrawLog = new ClienterWithdrawLog()
{
Operator = UserContext.Current.Name,
Remark = "骑士提款申请单确认打款",
Status = ClienterWithdrawFormStatus.Success.GetHashCode(),
WithwardId = Convert.ToInt64(withwardId)
};
var reg = iClienterFinanceProvider.ClienterWithdrawPayOk(clienterWithdrawLog);
return(Json(new ResultModel(reg, reg ? "确认打款成功！" : "确认打款失败！"), JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="clienterWithdrawLog">参数实体</param>
/// <returns></returns>
public long Insert(ClienterWithdrawLog clienterWithdrawLog)
{
const string insertSql = @"
insert into ClienterWithdrawLog(WithwardId,Status,Remark,Operator)
values(@WithwardId,@Status,@Remark,@Operator)
select @@IDENTITY";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.AddWithValue("WithwardId", clienterWithdrawLog.WithwardId); //提现单ID
dbParameters.AddWithValue("Status", clienterWithdrawLog.Status); //操作后状态
dbParameters.AddWithValue("Remark", clienterWithdrawLog.Remark); //备注
dbParameters.AddWithValue("Operator", clienterWithdrawLog.Operator); //操作人
object result = DbHelper.ExecuteScalar(SuperMan_Write, insertSql, dbParameters);
return(ParseHelper.ToLong(result));
}
/// <summary>
/// 根据ID获取对象
/// </summary>
public ClienterWithdrawLog GetById(long id)
{
ClienterWithdrawLog model = new ClienterWithdrawLog();
const string querysql = @"
select Id,WithwardId,Status,Remark,Operator,OperatTime
from ClienterWithdrawLog (nolock)
where Id=@Id ";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.AddWithValue("Id", id);
DataTable dt = DataTableHelper.GetTable(DbHelper.ExecuteDataset(SuperMan_Read, querysql, dbParameters));
if (DataTableHelper.CheckDt(dt))
{
model = DataTableHelper.ConvertDataTableList <ClienterWithdrawLog>(dt)[0];
}
return(model);
}
public JsonResult WithdrawAuditOk(string withwardId, string withwardNo)
{
var clienterWithdrawLog = new ClienterWithdrawLog()
{
Operator = UserContext.Current.Name,
Remark = "骑士提款申请单审核通过",
Status = ClienterWithdrawFormStatus.Allow.GetHashCode(),
WithwardId = Convert.ToInt64(withwardId)
};
try
{
var reg = iClienterFinanceProvider.ClienterWithdrawAudit(clienterWithdrawLog);
return(Json(new ResultModel(true, reg ? "审核通过！" : "以下单号审核失败,请重试！\n" + withwardNo), JsonRequestBehavior.DenyGet));
}
catch (Exception ex)
{
return(Json(new ResultModel(false, "以下单号审核失败:" + ex.Message + "！\n" + withwardNo), JsonRequestBehavior.DenyGet));
}
}
/// <summary>
/// 骑士提现申请单确认打款
/// danny-20150513
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool ClienterWithdrawPayOk(ClienterWithdrawLog model)
{
bool reg = false;
using (IUnitOfWork tran = EdsUtilOfWorkFactory.GetUnitOfWorkOfEDS())
{
if (clienterFinanceDao.ClienterWithdrawPayOk(model))
{
if (clienterFinanceDao.ModifyClienterBalanceRecordStatus(model.WithwardId.ToString()))
{
if (clienterFinanceDao.ModifyClienterTotalAmount(model.WithwardId.ToString()))
{
reg = true;
tran.Complete();
}
}
}
}
return(reg);
}
/// <summary>
/// 修改一条记录
///<param name="clienterWithdrawLog">要修改的对象</param>
/// </summary>
public void Modify(ClienterWithdrawLog clienterWithdrawLog)
{
_clienterWithdrawLogDao.Update(clienterWithdrawLog);
}
/// <summary>
/// 新增一条记录
///<param name="clienterWithdrawLog">要新增的对象</param>
/// </summary>
public long Create(ClienterWithdrawLog clienterWithdrawLog)
{
return(_clienterWithdrawLogDao.Insert(clienterWithdrawLog));
}
/// <summary>
/// 更新一条记录
/// </summary>
/// <param name="clienterWithdrawLog">参数实体</param>
public void Update(ClienterWithdrawLog clienterWithdrawLog)
{
}
