/// <summary>
/// 增加一条记录
/// <param name="clienterWithdrawForm">参数实体</param>
/// </summary>
public long Insert(ClienterWithdrawForm clienterWithdrawForm)
{
const string insertSql = @"
insert into ClienterWithdrawForm(WithwardNo,ClienterId,BalancePrice,AllowWithdrawPrice,Status,Amount,Balance,
TrueName,AccountNo,AccountType,BelongType,OpenBank,OpenSubBank)
values(@WithwardNo,@ClienterId,@BalancePrice,@AllowWithdrawPrice,@Status,@Amount,@Balance,
@TrueName,@AccountNo,@AccountType,@BelongType,@OpenBank,@OpenSubBank)
select @@IDENTITY";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.AddWithValue("WithwardNo", clienterWithdrawForm.WithwardNo); //提现单号
dbParameters.AddWithValue("ClienterId", clienterWithdrawForm.ClienterId); //骑士ID(clienter表)
dbParameters.AddWithValue("BalancePrice", clienterWithdrawForm.BalancePrice); //提现前骑士余额
dbParameters.AddWithValue("AllowWithdrawPrice", clienterWithdrawForm.AllowWithdrawPrice); //提现前骑士可提现金额
dbParameters.AddWithValue("Status", clienterWithdrawForm.Status); //提现状态(1待审核 2 审核通过 3打款完成 -1审核拒绝 -2 打款失败)
dbParameters.AddWithValue("Amount", clienterWithdrawForm.Amount); //提现金额
dbParameters.AddWithValue("Balance", clienterWithdrawForm.Balance); //提现后余额
dbParameters.AddWithValue("TrueName", clienterWithdrawForm.TrueName); //骑士收款户名
dbParameters.AddWithValue("AccountNo", clienterWithdrawForm.AccountNo); //卡号(DES加密)
dbParameters.AddWithValue("AccountType", clienterWithdrawForm.AccountType); //账号类型：(1网银 2支付宝 3微信 4财付通 5百度钱包）
dbParameters.AddWithValue("BelongType", clienterWithdrawForm.BelongType); //账号类别 0 个人账户 1 公司账户
dbParameters.AddWithValue("OpenBank", clienterWithdrawForm.OpenBank); //开户行
dbParameters.AddWithValue("OpenSubBank", clienterWithdrawForm.OpenSubBank); //开户支行
object result = DbHelper.ExecuteScalar(SuperMan_Write, insertSql, dbParameters); //提现单号
return(ParseHelper.ToLong(result));
}
/// <summary>
/// 根据ID获取对象
/// <param name="id">id</param>
/// </summary>
public ClienterWithdrawForm GetById(long id)
{
ClienterWithdrawForm model = new ClienterWithdrawForm();
const string querysql = @"
select Id,WithwardNo,ClienterId,BalancePrice,AllowWithdrawPrice,Status,Amount,Balance,WithdrawTime,Auditor,AuditTime,AuditFailedReason,Payer,PayTime,PayFailedReason
from ClienterWithdrawForm (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 <ClienterWithdrawForm>(dt)[0];
}
return(model);
}
/// <summary>
/// 更新一条记录
/// <param name="clienterWithdrawForm">参数实体</param>
/// </summary>
public void Update(ClienterWithdrawForm clienterWithdrawForm)
{
const string updateSql = @"
update ClienterWithdrawForm
set Status=@Status,Auditor=@Auditor,AuditTime=@AuditTime,AuditFailedReason=@AuditFailedReason,Payer=@Payer,PayTime=@PayTime,PayFailedReason=@PayFailedReason
where Id=@Id ";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.AddWithValue("Id", clienterWithdrawForm.Id);
dbParameters.AddWithValue("Status", clienterWithdrawForm.Status);
dbParameters.AddWithValue("Auditor", clienterWithdrawForm.Auditor);
dbParameters.AddWithValue("AuditTime", clienterWithdrawForm.AuditTime);
dbParameters.AddWithValue("AuditFailedReason", clienterWithdrawForm.AuditFailedReason);
dbParameters.AddWithValue("Payer", clienterWithdrawForm.Payer);
dbParameters.AddWithValue("PayTime", clienterWithdrawForm.PayTime);
dbParameters.AddWithValue("PayFailedReason", clienterWithdrawForm.PayFailedReason);
DbHelper.ExecuteNonQuery(SuperMan_Write, updateSql, dbParameters);
}
/// <summary>
/// 修改一条记录
///<param name="clienterWithdrawForm">要修改的对象</param>
/// </summary>
public void Modify(ClienterWithdrawForm clienterWithdrawForm)
{
_clienterWithdrawFormDao.Update(clienterWithdrawForm);
}
/// <summary>
/// 新增一条记录
///<param name="clienterWithdrawForm">要新增的对象</param>
/// </summary>
public long Create(ClienterWithdrawForm clienterWithdrawForm)
{
return(_clienterWithdrawFormDao.Insert(clienterWithdrawForm));
}
