| | |
| | | @Mapper |
| | | public interface ComActWorkGuideDAO extends BaseMapper<ComActWorkGuideDO> { |
| | | @Select("<script> " + |
| | | "select id ,title,content,time_at,address,phone from com_act_work_guide order " + |
| | | "select id ,title,content,time_at,address,phone from com_act_work_guide " + |
| | | " <where>" + |
| | | "<if test='pageActWorkGuideDTO.title != null and pageActWorkGuideDTO.title.trim() != ""'>" + |
| | | "title like concat('%',#{pageActWorkGuideDTO.title},'%')"+ |
| | | " </if> " + |
| | | " </where>" + |
| | | "by create_by desc"+ |
| | | "order by create_at desc"+ |
| | | "</script>") |
| | | IPage<ComActWorkGuideVO> pageWorkGuide(Page page, @Param("pageActWorkGuideDTO") PageActWorkGuideDTO pageActWorkGuideDTO); |
| | | } |