/// <summary>
/// 构造查询条件
/// <param name="clienterWithdrawFormPm"> 参数实体</param>
/// </summary>
public static string BindQueryCriteria(ClienterWithdrawFormPM clienterWithdrawFormPm)
{
var stringBuilder = new StringBuilder(" where 1=1 ");
if (clienterWithdrawFormPm == null)
{
return(stringBuilder.ToString());
}
//TODO:在此加入查询条件构建代码
return(stringBuilder.ToString());
}
/// <summary>
/// 查询对象
/// <param name="clienterWithdrawFormPm"> 参数实体</param>
/// </summary>
public IList <ClienterWithdrawForm> Query(ClienterWithdrawFormPM clienterWithdrawFormPm)
{
IList <ClienterWithdrawForm> models = new List <ClienterWithdrawForm>();
string condition = BindQueryCriteria(clienterWithdrawFormPm);
string querysql = @"
select Id,WithwardNo,ClienterId,BalancePrice,AllowWithdrawPrice,Status,Amount,Balance,WithdrawTime,Auditor,AuditTime,AuditFailedReason,Payer,PayTime,PayFailedReason
from ClienterWithdrawForm (nolock)" + condition;
DataTable dt = DataTableHelper.GetTable(DbHelper.ExecuteDataset(SuperMan_Read, querysql));
if (DataTableHelper.CheckDt(dt))
{
models = DataTableHelper.ConvertDataTableList <ClienterWithdrawForm>(dt);
}
return(models);
}
/// <summary>
/// 查询方法
/// </summary>
/// <param name="clienterWithdrawFormPm">参数实体</param>
/// <returns></returns>
public IList <ClienterWithdrawForm> Query(ClienterWithdrawFormPM clienterWithdrawFormPm)
{
return(_clienterWithdrawFormDao.Query(clienterWithdrawFormPm));
}
