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