/// <summary>
/// 分页查询
/// </summary>
/// <param name="pager">分页实体</param>
/// <param name="filter">查询条件</param>
/// <remarks> 2016-04-18 刘伟豪 创建</remarks>
public override void Search(ref Pager <CBDsAgentPrePaymentItem> pager, ParaDsAgentPrePaymentItemFilter filter)
{
string sqlWhere = "1=1";
string sql = @"(Select
A.*, C.Name AgentName
FROM
DsAgentPrePaymentItem A
Inner Join DsAgentPrePayment B On A.AgentPrePaymentSysNo = B.SysNo
Inner Join DsAgent C On B.AgentSysNo = C.SysNo
WHERE
(@0=-1 Or A.Status = @0)
And (@1=-1 Or A.Source = @1)
And (@2 Is Null Or A.CreatedDate >= @2)
And (@3 Is Null Or A.CreatedDate <= @3)
And (@4 Is Null Or C.SysNo=@4)
And " + sqlWhere + ") tb";
var dataList = Context.Select <CBDsAgentPrePaymentItem>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
if (filter.EndTime.HasValue)
{
var date = Convert.ToDateTime(filter.EndTime.Value);
filter.EndTime = date.AddDays(1);
}
var paras = new object[]
{
filter.Status,
filter.Source,
filter.StartTime,
filter.EndTime,
filter.SysNo,
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
pager.Rows = dataList.OrderBy(@"tb.CreatedDate Desc,tb.SysNo Desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany();
pager.TotalRows = dataCount.QuerySingle();
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="pager">分页实体</param>
/// <param name="filter">查询条件</param>
/// <remarks> 2016-04-18 刘伟豪 创建</remarks>
public void Search(ref Pager <CBDsAgentPrePaymentItem> pager, ParaDsAgentPrePaymentItemFilter filter)
{
IDsAgentPrePaymentItemDao.Instance.Search(ref pager, filter);
}
/// <summary> /// 分页查询 /// </summary> /// <param name="pager">分页实体</param> /// <param name="filter">查询条件</param> /// <remarks> 2016-04-18 刘伟豪 创建</remarks> public abstract void Search(ref Pager <CBDsAgentPrePaymentItem> pager, ParaDsAgentPrePaymentItemFilter filter);
