public IList <Speciallineinfo> PaginationFindByUserid(SpeciallineinfoPagination obj)
{
String stmtId = "SpeciallineinfoPagination.FindByUserid";
IList <Speciallineinfo> result = this.sqlMapper.QueryForList <Speciallineinfo>(stmtId, obj);
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <param name="userId"></param>
/// <returns></returns>
private string buildTableHTML(string pageNumber, string pageSize, string userId)
{
logger.Info("Build table html with pageNumber:" + pageNumber);
logger.Info("Build table html with pageSize:" + pageSize);
logger.Info("Build table html with userID:" + userId);
SpeciallineinfoPagination lineInfoPoco = new SpeciallineinfoPagination();
try
{
lineInfoPoco.Limit = int.Parse(pageSize);
lineInfoPoco.Offset = (int.Parse(pageNumber) - 1) * lineInfoPoco.Limit;
lineInfoPoco.Userid = long.Parse(userId);
}
catch (Exception ex)
{
logger.Error("Parameter invalid:" + ex.Message);
return("参数错误：" + ex.Message);
}
IList <Speciallineinfo> lineInfoPocoList = this.speciallineDao.DescendOrderPaginationFindByUserid(lineInfoPoco);
logger.Info("Got items:" + lineInfoPocoList.Count.ToString());
string tableHTML = this.tableGenerator.getTableHTML(this.getTableHeader(), this.getTableData(lineInfoPocoList), this.getOperate());
logger.Info("Build table HTML done:" + tableHTML);
return(tableHTML);
}
public IList <Speciallineinfo> DescendOrderPaginationFindAll(SpeciallineinfoPagination obj)
{
String stmtId = "Speciallineinfo.DescendOrderFindAllPagination";
IList <Speciallineinfo> result = this.sqlMapper.QueryForList <Speciallineinfo>(stmtId, obj);
return(result);
}
