/// <summary>
/// 获取指定会员订单列表
/// </summary>
/// <param name="pageIndex">分页索引</param>
/// <param name="customersysno">会员编号</param>
/// <param name="beginTime">开始时间</param>
/// <param name="endTime">结束时间</param>
/// <returns>会员订单列表</returns>
/// <remarks>2013-08-06 苟治国 创建</remarks>
public PagedList <SoOrder> GetOrder(int pageIndex, int customersysno, DateTime beginTime, DateTime endTime)
{
var list = new PagedList <SoOrder>();
var pager = new Pager <SoOrder>();
var orderFilter = new ParaOrderFilter();
orderFilter.BeginDate = beginTime;
orderFilter.EndDate = endTime;
pager.CurrentPage = pageIndex;
pager.PageFilter = new SoOrder
{
Status = 100,
CustomerSysNo = (int)customersysno
};
pager.PageSize = list.PageSize;
pager = IComplaintDao.Instance.GetOrder(pager, orderFilter);
list = new PagedList <SoOrder>
{
Data = pager.Rows,
CurrentPageIndex = pager.CurrentPage,
TotalItemCount = pager.TotalRows,
IsLoading = false,
Style = PagedList.StyleEnum.WebSmall
};
return(list);
}
/// <summary>
/// 获取指定会员订单列表
/// </summary>
/// <param name="pager">订单查询条件</param>
/// <returns>会员订单列表</returns>
/// <remarks>2013-08-06 苟治国 创建</remarks>
public override Pager <SoOrder> GetOrder(Pager <SoOrder> pager, ParaOrderFilter orderFilter)
{
#region sql条件
string sqlWhere = @"(:customersysnos=-1 or customersysno =:customersysno) and (:Status=0 or Status =:Status) and (:beginTime is null or createDate>=:beginTime) and (:endTime is null or createDate<=:endTime)";
#endregion
using (var _context = Context.UseSharedConnection(true))
{
pager.Rows = _context.Select <SoOrder>("s.*")
.From("soorder s")
.Where(sqlWhere)
.Parameter("customersysno", pager.PageFilter.CustomerSysNo)
.Parameter("Status", pager.PageFilter.Status)
.Parameter("beginTime", orderFilter.BeginDate)
.Parameter("endTime", orderFilter.EndDate)
.Paging(pager.CurrentPage, pager.PageSize).OrderBy("s.createdate desc").QueryMany();
pager.TotalRows = _context.Select <int>("count(1)")
.From("soorder s")
.Where(sqlWhere)
.Parameter("customersysno", pager.PageFilter.CustomerSysNo)
.Parameter("Status", pager.PageFilter.Status)
.Parameter("beginTime", orderFilter.BeginDate)
.Parameter("endTime", orderFilter.EndDate)
.QuerySingle();
}
return(pager);
}
/// <summary> /// 获取指定会员订单列表 /// </summary> /// <param name="pager">订单查询条件</param> /// <returns>会员订单列表</returns> /// <remarks>2013-08-06 苟治国 创建</remarks> public abstract Pager <SoOrder> GetOrder(Pager <SoOrder> pager, ParaOrderFilter orderFilter);
/// <summary> /// 订单分页查询 /// </summary> /// <param name="pager">分页数据</param> /// <param name="filter">查询条件</param> /// <returns></returns> /// <remarks>2013-06-13 朱家宏 创建</remarks> public abstract void GetSoOrders(ref Pager <CBSoOrder> pager, ParaOrderFilter filter);
/// <summary> /// 查询导出订单列表 /// </summary> /// <param name="sysNos"></param> /// <returns></returns> /// <remarks>2016-8-4 罗远康 复制添加导出图片</remarks> public abstract void GetXXExportOrderListByDoComplexSearch(ref Pager <CBXXOutputSoOrders> pager, ParaOrderFilter filter);
/// <summary> /// 查询导出订单列表 /// </summary> /// <param name="sysNos"></param> /// <returns></returns> /// <remarks>2016-1-19 王耀发 创建</remarks> public abstract List <CBOutputSoOrders> GetExportOrderListByDoComplexSearch(ParaOrderFilter filter);
