| | |
|---|
| | | |
|---|
| | | |
|---|
| | | //根据题名拿到最大的pageOrder |
|---|
| | | @Select("select count(*) from document_materials where title=#{title} and page_number<#{pageNumber} and stage=#{stage}") |
|---|
| | | Long getMaxPageOrder(@Param("title")String title,@Param("pageNumber") Long pageNumber,@Param("stage") String stage); |
|---|
| | | @Select("select count(*) from document_materials where title=#{title} and page_number<#{pageNumber} and stage=#{stage} and record_id=#{recordId}") |
|---|
| | | Long getMaxPageOrder(@Param("title")String title,@Param("pageNumber") Long pageNumber,@Param("stage") String stage, @Param("recordId") Long recordId); |
|---|
| | | |
|---|
| | | //计算文件的序号 |
|---|
| | | @Select("select count(distinct(title))-1 from document_materials where page_number<=#{pageNumber}") |
|---|
| | | Long getFileNumber(@Param("pageNumber") Long pageNumber); |
|---|
| | | @Select("select count(distinct(title))-1 from document_materials where page_number<=#{pageNumber} and record_id=#{recordId}") |
|---|
| | | Long getFileNumber(@Param("pageNumber") Long pageNumber, @Param("recordId") Long recordId); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | //查询卷内目录 |
|---|
| | | @Select( |
|---|
| | |
|---|
| | | " is_canceled, format, size_type, horizontal_resolution, vertical_resolution, width,\n" + |
|---|
| | | " height, file_size, attachment_history_numbers,url, dm.remarks\n" + |
|---|
| | | " from document_materials as dm, archive_records as ar WHERE dm.record_id=ar.id \n" + |
|---|
| | | "and dm.record_id=#{recordId}") |
|---|
| | | "and dm.record_id=#{recordId} and file_style!='其它材料' ") |
|---|
| | | List<DocumentMaterialsVoLarge> getDocumentMaterialsvoLarge(@Param("recordId") int recordId); |
|---|
| | | |
|---|
| | | @Select("select count(*) as cnt, file_style from document_materials " + |
|---|
