/// <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);
}
