//根据组合条件查询新闻列表 @Select("<script>"+"select N_ID AS id,N_indexNum AS indexNum,N_fileNum AS fileNum,N_Title AS title,N_Content AS content,N_aID AS aId,N_mID AS mId,N_pic AS pic,N_file AS newsFile,N_url AS url,N_from AS newsFrom,N_author AS author,N_addTime AS addTime,N_isTop AS isTop,N_topic AS topic,N_hitCount AS hitCount,N_keyWords AS keyWords,N_isPublish AS isPublish,N_rejectReason AS rejectReason,N_CheckName AS checkName,N_CName AS cName,N_CPosition AS cPosition,N_valid AS valid,N_isHeadlineNews AS isHeadlineNews from Article_News where 1=1" + " <if test='N_author != null and N_author.trim() != ""'>" + // " AND N_author LIKE CONCAT('%',#{N_author},'%')" + "AND N_author LIKE '%'+#{N_author}+'%'"+ " </if>" + " <if test='N_Title != null and N_Title.trim() != ""'>" + // " AND N_Title LIKE CONCAT('%',#{N_Title},'%')" + " AND N_Title LIKE '%'+#{N_Title}+'%'" + " </if>"+ " <if test='N_mID != null '>" + " AND N_mID=#{N_mID} " + " </if>" +"ORDER BY N_isPublish asc, N_addTime DESC"+"</script>") List<ArticleNewsVO> selectZuHe(Page<ArticleNewsVO> page, ZuHeNews zuHeNews);
@Select("<script>"+"select N_ID AS id, N_indexNum AS indexNum,N_fileNum AS fileNum,N_Title AS title,N_Content AS content,N_aID AS aId,N_mID AS mId,N_pic AS pic,N_file AS newsFile,N_url AS url,N_from AS newsFrom,N_author AS author,N_addTime AS addTime,N_isTop AS isTop,N_topic AS topic,N_hitCount AS hitCount,N_keyWords AS keyWords,N_isPublish AS isPublish,N_rejectReason AS rejectReason,N_CheckName AS checkName,N_CName AS cName,N_CPosition AS cPosition,N_valid AS valid,N_isHeadlineNews AS isHeadlineNews from Article_News where 1=1" +
" <if test='zuHeNews.N_author != null and zuHeNews.N_author.trim() != ""'>" +
// " AND N_author LIKE CONCAT('%',#{N_author},'%')" +
"AND N_author LIKE '%'+#{N_author}+'%'"+
"AND N_author LIKE '%'+#{zuHeNews.N_author}+'%'"+
" </if>" +
" <if test='N_Title != null and N_Title.trim() != ""'>" +
" <if test='zuHeNews.N_Title != null and zuHeNews.N_Title.trim() != ""'>" +
// " AND N_Title LIKE CONCAT('%',#{N_Title},'%')" +
" AND N_Title LIKE '%'+#{N_Title}+'%'" +
" AND N_Title LIKE '%'+#{zuHeNews.N_Title}+'%'" +
" </if>"+
" <if test='N_mID != null '>" +
" AND N_mID=#{N_mID} " +
" </if>" +"ORDER BY N_isPublish asc, N_addTime DESC"+"</script>")
List<ArticleNewsVO> selectZuHeByCommon(Page<ArticleNewsVO> page, ZuHeNews zuHeNews, Integer aId);
" <if test='zuHeNews.N_mID != null '>" +
" AND N_mID=#{zuHeNews.N_mID} " +
" </if>" +" and N_aID = #{adminId} ORDER BY N_isPublish asc, N_addTime DESC"+"</script>")
List<ArticleNewsVO> selectZuHeByCommon(Page<ArticleNewsVO> page,
@Param("zuHeNews") ZuHeNews zuHeNews,
Integer adminId);