public IList <Varticleinfo> PaginationFindByTitle(VarticleinfoPagination obj)
{
String stmtId = "VarticleinfoPagination.FindByTitle";
IList <Varticleinfo> result = this.sqlMapper.QueryForList <Varticleinfo>(stmtId, obj);
return(result);
}
public IList <Varticleinfo> DescendOrderPaginationFindAll(VarticleinfoPagination obj)
{
String stmtId = "Varticleinfo.DescendOrderFindAllPagination";
IList <Varticleinfo> result = this.sqlMapper.QueryForList <Varticleinfo>(stmtId, obj);
return(result);
}
public string generateNotificationHtml(string pageNumber, string pageSize, string typeId)
{
VarticleinfoPagination pageNationPoco = new VarticleinfoPagination();
pageNationPoco.Limit = int.Parse(pageSize);
pageNationPoco.Offset = (int.Parse(pageNumber) - 1) * pageNationPoco.Limit;
logger.Info("Got offset:" + pageNationPoco.Offset.ToString());
pageNationPoco.Typeid = long.Parse(typeId);
IList <Varticleinfo> articleInfoList = this.vArticleInfoDao.DescendOrderPaginationFindByTypeid(pageNationPoco);
logger.Info("Got items:" + articleInfoList.Count.ToString());
string tableHtml = this.getTableHtml(this.getTableBodyHtml(articleInfoList), typeId);
logger.Info("table html:" + tableHtml);
return(tableHtml);
}
public void ProcessRequest(HttpContext context)
{
string pageNumber = context.Request.QueryString["pageNumber"].ToString();
logger.Info("Got page number:" + pageNumber);
string pageSize = context.Request.QueryString["pageSize"].ToString();
logger.Info("Got page size:" + pageSize);
string typeId = context.Request.QueryString["type"].ToString();
logger.Info("Got type ID:" + typeId);
VarticleinfoPagination pageNationPoco = new VarticleinfoPagination();
pageNationPoco.Limit = int.Parse(pageSize);
pageNationPoco.Offset = (int.Parse(pageNumber) - 1) * pageNationPoco.Limit;
logger.Info("Got offset:" + pageNationPoco.Offset.ToString());
pageNationPoco.Typeid = long.Parse(typeId);
IList <Varticleinfo> articleInfoList = this.articleInfoDao.DescendOrderPaginationFindByTypeid(pageNationPoco);
logger.Info("Got items:" + articleInfoList.Count.ToString());
context.Response.Write(this.getTableHtml(this.getTableBodyHtml(articleInfoList)));
}