| | |
|---|
| | | |
|---|
| | | <!--自定义分页查询--> |
|---|
| | | <select id="selectAttachPage" resultType="org.sxkj.resource.vo.AttachVO"> |
|---|
| | | select ba.*,bd.dept_name, ifnull(ba.nick_name,ba.original_name) nickName |
|---|
| | | from blade_attach ba |
|---|
| | | left join blade_dept bd on ba.create_dept = bd.id where ba.is_deleted = 0 |
|---|
| | | select |
|---|
| | | ba.*, |
|---|
| | | bd.dept_name, |
|---|
| | | ifnull(ba.nick_name,ba.original_name) nickName |
|---|
| | | from |
|---|
| | | blade_attach ba |
|---|
| | | left join |
|---|
| | | blade_dept bd on ba.create_dept = bd.id |
|---|
| | | where |
|---|
| | | ba.is_deleted = 0 |
|---|
| | | <if test="attach.originalName!=null and attach.originalName!=''"> |
|---|
| | | and original_name like concat('%',#{attach.originalName},'%') |
|---|
| | | </if> |
|---|
