/// <summary>
/// 取得每页记录
/// </summary>
/// <param name="p_pageIndex">当前页</param>
/// <param name="p_pageSize">分页大小</param>
/// <param name="p_recordCount">返回总记录数</param>
/// <param name="strWhere">查询条件</param>
/// <returns>IList Navigation</returns>
public IList <Book.Model.Navigation> GetNavigations(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount)
{
IList <Book.Model.Navigation> listNavigations = new List <Book.Model.Navigation>();
string sTable = "Navigation";
string sPkey = "id";
string sField = "id,pid,Name";
string sCondition = strWhere;
string sOrder = "pid asc";
int iSCounts = 0;
using (SqlDataReader reader = SqlHelperBook.RunProcedureMe(sTable, sPkey, sField, p_pageIndex, p_pageSize, sCondition, sOrder, iSCounts, out p_recordCount))
{
//计算总页数
if (p_recordCount > 0)
{
int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex);
}
else
{
return(listNavigations);
}
while (reader.Read())
{
Book.Model.Navigation objNavigation = new Book.Model.Navigation();
objNavigation.id = reader.GetInt32(0);
objNavigation.pid = reader.GetInt32(1);
objNavigation.Name = reader.GetString(2);
listNavigations.Add(objNavigation);
}
}
return(listNavigations);
}
/// <summary>
/// 取得每页记录
/// </summary>
/// <param name="p_pageIndex">当前页</param>
/// <param name="p_pageSize">分页大小</param>
/// <param name="p_recordCount">返回总记录数</param>
/// <param name="strWhere">查询条件</param>
/// <returns>IList ShuFav</returns>
public IList <Book.Model.ShuFav> GetShuFavs(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount)
{
IList <Book.Model.ShuFav> listShuFavs = new List <Book.Model.ShuFav>();
string sTable = "ShuFav";
string sPkey = "id";
string sField = "id,name,usid";
string sCondition = strWhere;
string sOrder = "ID Desc";
int iSCounts = 0;
using (SqlDataReader reader = SqlHelperBook.RunProcedureMe(sTable, sPkey, sField, p_pageIndex, p_pageSize, sCondition, sOrder, iSCounts, out p_recordCount))
{
//计算总页数
if (p_recordCount > 0)
{
int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex);
}
else
{
return(listShuFavs);
}
while (reader.Read())
{
Book.Model.ShuFav objShuFav = new Book.Model.ShuFav();
objShuFav.id = reader.GetInt32(0);
objShuFav.name = reader.GetString(1);
objShuFav.usid = reader.GetInt32(2);
listShuFavs.Add(objShuFav);
}
}
return(listShuFavs);
}
/// <summary>
/// 取得每页记录
/// </summary>
/// <param name="p_pageIndex">当前页</param>
/// <param name="p_pageSize">分页大小</param>
/// <param name="p_recordCount">返回总记录数</param>
/// <param name="strWhere">查询条件</param>
/// <returns>IList ShuMu</returns>
public IList <Book.Model.ShuMu> GetShuMusTop(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount)
{
IList <Book.Model.ShuMu> listShuMus = new List <Book.Model.ShuMu>();
string sTable = "ShuMu";
string sPkey = "id";
string sField = "id,nid,title,click";
string sCondition = strWhere;
string sOrder = "click Desc";
int iSCounts = 0;
using (SqlDataReader reader = SqlHelperBook.RunProcedureMe(sTable, sPkey, sField, p_pageIndex, p_pageSize, sCondition, sOrder, iSCounts, out p_recordCount))
{
//计算总页数
if (p_recordCount > 0)
{
int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex);
}
else
{
return(listShuMus);
}
while (reader.Read())
{
Book.Model.ShuMu objShuMu = new Book.Model.ShuMu();
objShuMu.id = reader.GetInt32(0);
objShuMu.nid = reader.GetInt32(1);
objShuMu.title = reader.GetString(2);
objShuMu.click = reader.GetInt32(3);
listShuMus.Add(objShuMu);
}
}
return(listShuMus);
}
/// <summary>
/// 取得每页记录
/// </summary>
/// <param name="p_pageIndex">当前页</param>
/// <param name="p_pageSize">分页大小</param>
/// <param name="p_recordCount">返回总记录数</param>
/// <param name="strWhere">查询条件</param>
/// <param name="strOrder">排序条件</param>
/// <returns>IList Contents</returns>
public IList <Book.Model.Contents> GetContentss(int p_pageIndex, int p_pageSize, string strWhere, string strOrder, out int p_recordCount)
{
IList <Book.Model.Contents> listContentss = new List <Book.Model.Contents>();
string sTable = "Contents";
string sPkey = "id";
string sField = "id,shi,title,summary,contents,addtime,state,jid,tags,aid,pid";
string sCondition = strWhere;
string sOrder = strOrder;
int iSCounts = 0;
using (SqlDataReader reader = SqlHelperBook.RunProcedureMe(sTable, sPkey, sField, p_pageIndex, p_pageSize, sCondition, sOrder, iSCounts, out p_recordCount))
{
//计算总页数
if (p_recordCount > 0)
{
int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex);
}
else
{
return(listContentss);
}
while (reader.Read())
{
Book.Model.Contents objContents = new Book.Model.Contents();
objContents.id = reader.GetInt32(0);
objContents.shi = reader.GetInt32(1);
objContents.title = reader.GetString(2);
if (!reader.IsDBNull(3))
{
objContents.summary = reader.GetString(3);
}
if (!reader.IsDBNull(4))
{
objContents.contents = reader.GetString(4);
}
if (!reader.IsDBNull(5))
{
objContents.addtime = reader.GetDateTime(5);
}
if (!reader.IsDBNull(6))
{
objContents.state = reader.GetInt32(6);
}
if (!reader.IsDBNull(7))
{
objContents.jid = reader.GetInt32(7);
}
if (!reader.IsDBNull(8))
{
objContents.tags = reader.GetString(8);
}
objContents.aid = reader.GetInt32(9);
objContents.pid = reader.GetInt32(10);
listContentss.Add(objContents);
}
}
return(listContentss);
}
/// <summary>
/// 取得每页记录
/// </summary>
/// <param name="p_pageIndex">当前页</param>
/// <param name="p_pageSize">分页大小</param>
/// <param name="p_recordCount">返回总记录数</param>
/// <param name="strWhere">查询条件</param>
/// <returns>IList ShuSelf</returns>
public IList <Book.Model.ShuSelf> GetShuSelfs(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount)
{
IList <Book.Model.ShuSelf> listShuSelfs = new List <Book.Model.ShuSelf>();
string sTable = "ShuSelf";
string sPkey = "id";
string sField = "id,aid,name,sex,city,pagenum,gxids";
string sCondition = strWhere;
string sOrder = "ID Desc";
int iSCounts = 0;
using (SqlDataReader reader = SqlHelperBook.RunProcedureMe(sTable, sPkey, sField, p_pageIndex, p_pageSize, sCondition, sOrder, iSCounts, out p_recordCount))
{
//计算总页数
if (p_recordCount > 0)
{
int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex);
}
else
{
return(listShuSelfs);
}
while (reader.Read())
{
Book.Model.ShuSelf objShuSelf = new Book.Model.ShuSelf();
objShuSelf.id = reader.GetInt32(0);
objShuSelf.aid = reader.GetInt32(1);
objShuSelf.name = reader.GetString(2);
objShuSelf.sex = reader.GetString(3);
objShuSelf.city = reader.GetString(4);
objShuSelf.pagenum = reader.GetInt32(5);
if (!reader.IsDBNull(6))
{
objShuSelf.gxids = reader.GetString(6);
}
listShuSelfs.Add(objShuSelf);
}
}
return(listShuSelfs);
}
/// <summary>
/// 取得每页记录
/// </summary>
/// <param name="p_pageIndex">当前页</param>
/// <param name="p_pageSize">分页大小</param>
/// <param name="p_recordCount">返回总记录数</param>
/// <param name="strWhere">查询条件</param>
/// <returns>IList Favorites</returns>
public IList <Book.Model.Favorites> GetFavoritess(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount)
{
IList <Book.Model.Favorites> listFavoritess = new List <Book.Model.Favorites>();
string sTable = "Favorites";
string sPkey = "id";
string sField = "id,favid,types,title,nid,sid,purl,usid,addtime";
string sCondition = strWhere;
string sOrder = "ID Desc";
int iSCounts = 0;
using (SqlDataReader reader = SqlHelperBook.RunProcedureMe(sTable, sPkey, sField, p_pageIndex, p_pageSize, sCondition, sOrder, iSCounts, out p_recordCount))
{
//计算总页数
if (p_recordCount > 0)
{
int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex);
}
else
{
return(listFavoritess);
}
while (reader.Read())
{
Book.Model.Favorites objFavorites = new Book.Model.Favorites();
objFavorites.id = reader.GetInt32(0);
objFavorites.favid = reader.GetInt32(1);
objFavorites.types = reader.GetInt32(2);
objFavorites.title = reader.GetString(3);
objFavorites.nid = reader.GetInt32(4);
objFavorites.sid = reader.GetInt32(5);
objFavorites.purl = reader.GetString(6);
objFavorites.usid = reader.GetInt32(7);
objFavorites.addtime = reader.GetDateTime(8);
listFavoritess.Add(objFavorites);
}
}
return(listFavoritess);
}
