/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>日志分页</returns>
/// <remarks>2017-11-1 杨浩 创建</remarks>
public PagedList <CBDsMallSyncLog> GetList(ParaDsMallSyncLogFilter filter)
{
if (filter != null)
{
var model = new PagedList <CBDsMallSyncLog>();
filter.PageSize = model.PageSize;
var pager = Hyt.DataAccess.MallSeller.IDsMallSyncLogDao.Instance.GetList(filter);
if (null != pager)
{
model.TData = pager.Rows;
model.TotalItemCount = pager.TotalRows;
model.CurrentPageIndex = filter.Id;
}
return(model);
}
return(null);
}
/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>日志分页</returns> /// <remarks>2017-11-1 杨浩 创建</remarks> public abstract Pager <CBDsMallSyncLog> GetList(ParaDsMallSyncLogFilter filter);
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>日志分页</returns>
/// <remarks>2017-11-1 杨浩 创建</remarks>
public override Pager <CBDsMallSyncLog> GetList(ParaDsMallSyncLogFilter filter)
{
#region 条件
string sql =
@"(select a.*
from DsMallSyncLog a
where 1=1 {0} ) tb ";
string where = string.Empty;
var paras = new List <string>();
if (filter.LastsyncBeginTime != null)
{
where += " and tb.LastSyncTime>=@" + paras.Count;
paras.Add(filter.LastsyncBeginTime.ToString());
}
if (filter.LastsyncEndDate != null)
{
where += " and a.LastSyncTime<=@" + paras.Count;
paras.Add(filter.LastsyncEndDate.ToString());
}
if (!string.IsNullOrWhiteSpace(filter.OrderId))
{
if (filter.Name == 10)
{
int orderSysno = 0;
if (int.TryParse(filter.OrderId, out orderSysno))
{
where += " and a.Data like '{\"TransactionSysNo\":\"T%" + int.Parse(filter.OrderId) + "\"%}'";
}
}
else
{
where += " and a.Data like @" + paras.Count;
paras.Add("%" + filter.OrderId + "%");
}
}
if (filter.Status != 0)
{
where += " and a.Status=@" + paras.Count;
paras.Add(filter.Status.ToString());
}
if (filter.Name > 0)
{
where += " and a.SyncType=@" + paras.Count;
paras.Add(filter.Name.ToString());
}
sql = string.Format(sql, where);
#endregion
var dataList = Context.Select <CBDsMallSyncLog>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(0)").From(sql);
dataList.Parameters(paras.ToArray());
dataCount.Parameters(paras.ToArray());
var pager = new Pager <CBDsMallSyncLog>
{
PageSize = filter.PageSize,
CurrentPage = filter.Id
};
pager.TotalRows = dataCount.QuerySingle();
pager.Rows = dataList.OrderBy(" tb.sysno asc")
.Paging(pager.CurrentPage, filter.PageSize)
.QueryMany();
return(pager);
}
