/// <summary> /// 分页查询 /// </summary> /// <param name="CustomerSysNo">申请人</param> /// <param name="ProductSysNo">申请商品ID</param> /// <param name="type">通知方式</param> /// <param name="NoticeWay">发送方式</param> /// <param name="pager">分页对象</param> /// <returns>2016-03-30 周海鹏 创建</returns> public override IList <CBCrNotice> List(int CustomerSysNo, int ProductSysNo, CustomerStatus.通知类型 type, int NoticeWay, Pager <CBCrNotice> pager) { using (var content = Context.UseSharedConnection(true)) { string sql = ""; if (CustomerSysNo != 0) { sql += string.Format("and CustomerSysNo={0}", CustomerSysNo); } if (ProductSysNo != 0) { sql += string.Format("and ProductSysNo={0}", ProductSysNo); } if (NoticeWay != 0) { sql += string.Format("and NoticeWay={0}", NoticeWay); } pager.Rows = content.Select <CBCrNotice>("cr.*") .From("CrNotice cr") .Where("NoticeType=@NoticeType " + sql + "") .Parameter("NoticeType", (int)type) .OrderBy("cr.CreatedDate desc") .Paging(pager.CurrentPage, pager.PageSize) .QueryMany(); pager.TotalRows = content.Sql(@"select count(cr.sysno) from CrNotice cr where NoticeType=@NoticeType " + sql + "") .Parameter("NoticeType", (int)type) .QuerySingle <int>(); } return(pager.Rows); }
/// <summary> /// 分页查询 /// </summary> /// <param name="CustomerSysNo">申请人</param> /// <param name="ProductSysNo">申请商品ID</param> /// <param name="type">通知方式</param> /// <param name="NoticeWay">发送方式</param> /// <param name="pager">分页对象</param> /// <returns>2016-03-30 周海鹏创建</returns> public IList <CBCrNotice> List(int CustomerSysNo, int ProductSysNo, CustomerStatus.通知类型 type, int NoticeWay, PagedList <CBCrNotice> pager) { Pager <CBCrNotice> transPager = new Pager <CBCrNotice>(); transPager.CurrentPage = pager.CurrentPageIndex; transPager.PageSize = pager.PageSize; ICrNoticeDao.Instance.List(CustomerSysNo, ProductSysNo, type, NoticeWay, transPager); pager.TData = transPager.Rows; pager.TotalItemCount = transPager.TotalRows; return(pager.TData); }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageIndex">起始页</param> /// <param name="customerSysNo">商品信息通知类型</param> /// <param name="type">商品信息通知类型</param> /// <returns>商品信息通知列表</returns> /// <remarks>2013-08-09 杨晗 创建</remarks> public PagedList <CBCrNotice> Seach(int?pageIndex, int customerSysNo, CustomerStatus.通知类型 type) { pageIndex = pageIndex ?? 1; var model = new PagedList <CBCrNotice>(); var count = 0; var list = ICrNoticeDao.Instance.Seach((int)pageIndex, model.PageSize, customerSysNo, type, out count); model.TData = list; model.TotalItemCount = count; model.CurrentPageIndex = (int)pageIndex; model.Style = PagedList.StyleEnum.WebSmall; return(model); }
/// <summary> /// 分页查询 /// </summary> /// <param name="CustomerSysNo">申请人</param> /// <param name="ProductSysNo">申请商品ID</param> /// <param name="type">通知方式</param> /// <param name="NoticeWay">发送方式</param> /// <param name="pager">分页对象</param> /// <returns>2016-03-30 周海鹏创建</returns> public abstract IList <CBCrNotice> List(int CustomerSysNo, int ProductSysNo, CustomerStatus.通知类型 type, int NoticeWay, Pager <CBCrNotice> pager);
/// <summary> /// 分页查询 /// </summary> /// <param name="pageIndex">起始页</param> /// <param name="pageSize">每页数量</param> /// <param name="customerSysNo">商品信息通知类型</param> /// <param name="type">商品信息通知类型</param> /// <param name="count">抛出总条数</param> /// <returns>商品信息通知列表</returns> /// <remarks>2013-08-09 杨晗 创建</remarks> public abstract IList <CBCrNotice> Seach(int pageIndex, int pageSize, int customerSysNo, CustomerStatus.通知类型 type, out int count);
/// <summary> /// 分页查询 /// </summary> /// <param name="pageIndex">起始页</param> /// <param name="pageSize">每页数量</param> /// <param name="customerSysNo">商品信息通知类型</param> /// <param name="type">商品信息通知类型</param> /// <param name="count">抛出总条数</param> /// <returns>商品信息通知列表</returns> /// <remarks>2013-08-09 杨晗 创建</remarks> public override IList <CBCrNotice> Seach(int pageIndex, int pageSize, int customerSysNo, CustomerStatus.通知类型 type, out int count) { #region sql条件 string sql = @"cn.NoticeType =@NoticeType and cn.CustomerSysNo=@CustomerSysNo"; #endregion count = Context.Select <int>("count(1)") .From("CrNotice cn") .Where(sql) .Parameter("NoticeType", (int)type) .Parameter("CustomerSysNo", customerSysNo) .QuerySingle(); var countBuilder = Context.Select <CBCrNotice>("cn.*,pd.ProductName as ProductName,pd.Status as ProductStatus") .From("CrNotice cn,PdProduct pd") .Where("pd.sysno=cn.ProductSysNo and " + sql) .Parameter("NoticeType", (int)type) .Parameter("CustomerSysNo", customerSysNo) .Paging(pageIndex, pageSize).OrderBy("cn.CreatedDate desc").QueryMany(); return(countBuilder); }