/// <summary>
/// 获取要导出的骑士提现申请单
/// danny-20150513
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public IList <ClienterWithdrawFormModel> GetClienterWithdrawForExport(ClienterWithdrawSearchCriteria criteria)
{
string sql = @"
select c.[TrueName] ClienterName,
c.PhoneNo ClienterPhoneNo,
cwf.OpenBank ,
cwf.TrueName ,
cwf.AccountNo ,
cwf.Amount,
cwf.WithdrawTime WithdrawDateStart
from ClienterWithdrawForm cwf with(nolock)
join clienter c with(nolock) on cwf.ClienterId=c.Id
where 1=1";
if (!string.IsNullOrWhiteSpace(criteria.ClienterName))
{
sql += " AND c.[TrueName]=@ClienterName";
}
if (!string.IsNullOrWhiteSpace(criteria.ClienterPhoneNo))
{
sql += " AND c.PhoneNo=@ClienterPhoneNo";
}
if (criteria.WithdrawStatus != 0)
{
sql += " AND cwf.Status=@WithdrawStatus";
}
if (!string.IsNullOrWhiteSpace(criteria.WithwardNo))
{
sql += " AND cwf.WithwardNo=@WithwardNo";
}
if (!string.IsNullOrWhiteSpace(criteria.WithdrawDateStart))
{
sql += " AND CONVERT(CHAR(10),cwf.WithdrawTime,120)>=CONVERT(CHAR(10),@WithdrawDateStart,120)";
}
if (!string.IsNullOrWhiteSpace(criteria.WithdrawDateEnd))
{
sql += " AND CONVERT(CHAR(10),cwf.WithdrawTime,120)<=CONVERT(CHAR(10),@WithdrawDateEnd,120)";
}
IDbParameters parm = DbHelper.CreateDbParameters();
parm.AddWithValue("@ClienterName", criteria.ClienterName);
parm.AddWithValue("@ClienterPhoneNo", criteria.ClienterPhoneNo);
parm.AddWithValue("@WithwardNo", criteria.WithwardNo);
parm.AddWithValue("@WithdrawDateStart", criteria.WithdrawDateStart);
parm.AddWithValue("@WithdrawDateEnd", criteria.WithdrawDateEnd);
parm.AddWithValue("@WithdrawStatus", criteria.WithdrawStatus);
DataTable dt = DbHelper.ExecuteDataTable(SuperMan_Read, sql, parm);
return(MapRows <ClienterWithdrawFormModel>(dt));
}
/// <summary>
/// 根据参数获取骑士提现申请单列表
/// danny-20150513
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public PageInfo <T> GetClienterWithdrawList <T>(ClienterWithdrawSearchCriteria criteria)
{
string columnList = @" cwf.Id,
cwf.WithwardNo,
c.[TrueName] ClienterName,
c.PhoneNo ClienterPhoneNo,
cwf.BalancePrice,
cwf.AllowWithdrawPrice,
cwf.Amount,
cwf.Balance,
cwf.Status,
cwf.WithdrawTime,
cwf.Auditor,
cwf.AuditTime,
cwf.Payer,
cwf.PayTime,
cwf.AuditFailedReason,
cwf.PayFailedReason ";
var sbSqlWhere = new StringBuilder(" 1=1 ");
if (!string.IsNullOrWhiteSpace(criteria.ClienterName))
{
sbSqlWhere.AppendFormat(" AND c.[TrueName]='{0}' ", criteria.ClienterName.Trim());
}
if (!string.IsNullOrWhiteSpace(criteria.ClienterPhoneNo))
{
sbSqlWhere.AppendFormat(" AND c.PhoneNo='{0}' ", criteria.ClienterPhoneNo.Trim());
}
if (criteria.WithdrawStatus != 0)
{
sbSqlWhere.AppendFormat(" AND cwf.Status={0} ", criteria.WithdrawStatus);
}
if (!string.IsNullOrWhiteSpace(criteria.WithwardNo))
{
sbSqlWhere.AppendFormat(" AND cwf.WithwardNo='{0}' ", criteria.WithwardNo.Trim());
}
if (!string.IsNullOrWhiteSpace(criteria.WithdrawDateStart))
{
sbSqlWhere.AppendFormat(" AND CONVERT(CHAR(10),cwf.WithdrawTime,120)>=CONVERT(CHAR(10),'{0}',120) ", criteria.WithdrawDateStart.Trim());
}
if (!string.IsNullOrWhiteSpace(criteria.WithdrawDateEnd))
{
sbSqlWhere.AppendFormat(" AND CONVERT(CHAR(10),cwf.WithdrawTime,120)<=CONVERT(CHAR(10),'{0}',120) ", criteria.WithdrawDateEnd.Trim());
}
string tableList = @" ClienterWithdrawForm cwf with(nolock)
join clienter c with(nolock) on cwf.ClienterId=c.Id";
string orderByColumn = " cwf.Id DESC ";
return(new PageHelper().GetPages <T>(SuperMan_Read, criteria.PageIndex, sbSqlWhere.ToString(), orderByColumn, columnList, tableList, criteria.PageSize, true));
}
/// <summary>
/// 获取要导出的骑士提现申请单
/// danny-20150513
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public IList <ClienterWithdrawFormModel> GetClienterWithdrawForExport(ClienterWithdrawSearchCriteria criteria)
{
return(clienterFinanceDao.GetClienterWithdrawForExport(criteria));
}
/// <summary>
/// 根据参数获取骑士提现申请单列表
/// danny-20150513
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public PageInfo <ClienterWithdrawFormModel> GetClienterWithdrawList(ClienterWithdrawSearchCriteria criteria)
{
return(clienterFinanceDao.GetClienterWithdrawList <ClienterWithdrawFormModel>(criteria));
}
