/// <summary>
/// 推送返回信息
/// </summary>
/// <param name="filter">推送返回信息</param>
/// <returns>返回推送返回信息</returns>
/// <remarks>2015-09-05 王耀发 创建</remarks>
public override Pager <SendOrderReturn> GetSendOrderReturnList(ParaSendOrderReturnFilter filter)
{
const string sql = @"(select a.* from SendOrderReturn a
where
(@0 is null or charindex(a.OrderNo,@1)>0) and
(@2 is null or charindex(a.Msg,@3)>0)
) tb";
var dataList = Context.Select <SendOrderReturn>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
var paras = new object[]
{
filter.OrderNo, filter.OrderNo,
filter.Msg, filter.Msg
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <SendOrderReturn>
{
CurrentPage = filter.Id,
PageSize = filter.PageSize
};
var totalRows = dataCount.QuerySingle();
var rows = dataList.OrderBy("tb.LastUpdateDate desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany();
pager.TotalRows = totalRows;
pager.Rows = rows;
return(pager);
}
/// <summary> /// 推送返回信息 /// </summary> /// <param name="filter">推送返回信息</param> /// <returns>返回推送返回信息</returns> /// <remarks>2015-09-05 王耀发 创建</remarks> public abstract Pager <SendOrderReturn> GetSendOrderReturnList(ParaSendOrderReturnFilter filter);
/// <summary>
/// 推送返回信息
/// </summary>
/// <param name="filter">推送返回信息</param>
/// <returns>返回推送返回信息</returns>
/// <remarks>2015-09-05 王耀发 创建</remarks>
public Pager <SendOrderReturn> GetSendOrderReturnList(ParaSendOrderReturnFilter filter)
{
return(ISendOrderReturnDao.Instance.GetSendOrderReturnList(filter));
}
