public List <ZoneArticleView> listByCategoryId(int platType, int categoryId, int pageIndex, int pageSize)
{
string sqlWhere = "CatId=" + categoryId + " and platType=" + platType;
//if (sqlWhere.Length > 0) sqlWhere = sqlWhere.Substring(4);
//初始化分页
PagingModel paging = new PagingModel()
{
PageIndex = pageIndex,
PageSize = pageSize,
RecordCount = 0,
PageCount = 0
};
PageQueryModel pageQuery = new PageQueryModel()
{
TableName = "HQ_ShareZone_Article with(nolock)",
Fields = "GoodsId as goodsId,'' as head,'' as name,ShareContent as content,ArticleType as type,ShareImgList as pictures,ShareImgList as smallPictures,VideoList as videos,CreateTime as time,ShareCount as turnAmount,PromotionAmount as reward,'' as linkUrl",
OrderField = "ShareId desc",
SqlWhere = sqlWhere
};
List <ZoneArticleView> list = new CommonPageDAL().GetPageData <ZoneArticleView>(ConfigHelper.MssqlDBConnectionString_Sync, pageQuery, paging);
return(list);
}
public List <UserFavoriteModel> list(int userId, int platType, int pageIndex, int pageSize)
{
String sqlWhere = "UserId=" + userId + " and PlatType=" + platType;
//初始化分页
PagingModel paging = new PagingModel()
{
PageIndex = pageIndex,
PageSize = pageSize,
RecordCount = 0,
PageCount = 0
};
PageQueryModel pageQuery = new PageQueryModel()
{
TableName = "HQ_User_Favorite with(nolock)",
Fields = "*",
OrderField = "CreateTime desc",
SqlWhere = sqlWhere
};
List <UserFavoriteModel> list = new CommonPageDAL().GetPageData <UserFavoriteModel>(ConfigHelper.MssqlDBConnectionString_Sync, pageQuery, paging);
return(list);
}
public List <UsersModel> listBelongOne(int userId, int pageIndex, int pageSize)
{
string sqlWhere = "BelongOneId=" + userId;
//if (sqlWhere.Length > 0) sqlWhere = sqlWhere.Substring(4);
//初始化分页
PagingModel paging = new PagingModel()
{
PageIndex = pageIndex,
PageSize = pageSize,
RecordCount = 0,
PageCount = 0
};
PageQueryModel pageQuery = new PageQueryModel()
{
TableName = "HQ_Users with(nolock)",
Fields = "*",
OrderField = "UserId desc",
SqlWhere = sqlWhere
};
List <UsersModel> list = new CommonPageDAL().GetPageData <UsersModel>(ConfigHelper.MssqlDBConnectionString_Sync, pageQuery, paging);
return(list);
}
