文档
测试

分页筛选表(已弃用!!)

GET
http://192.168.1.118:8111/dataDir/getAllTables?dataBaseName=tbuild&ifSearchFlag=1&ifClassifyFlag=1&pageNumber=1&pageSize=50

接口描述

获取当前数据库所有表名

请求参数

参数名
类型
描述
必填
dataBaseName
String
数据库名称
必填
ifSearchFlag
Integer
是否被搜索 0未被搜索 1被搜索
必填
ifClassifyFlag
Integer
是否归类标记 未标记 1已标记
必填
pageNumber
Integer
当前页数
必填
pageSize
Integer
一页展示数量
必填

请求示例

```json http://192.168.1.118:8111/dataDir/getAllTables?dataBaseName=tbuild&ifSearchFlag=1&ifClassifyFlag=1&pageNumber=1&pageSize=50 ```

返回示例

```json { "status": 200, "data": { "total": 13, "list": [ { "id": 4, "status": 1, "pDirId": 1, "dirCode": "g_bd_tallbuildcheckresult", "dirName": "高层建筑消防安全检查实时表", "dataBaseName": "tbuild", "dirLevel": 2, "dirSort": 1, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 9 }, { "id": 5, "status": 1, "pDirId": 1, "dirCode": "g_bd_tallbuildinfo", "dirName": "高层建筑信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "", "dirSort": 2, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 70 }, { "id": 6, "status": 1, "pDirId": 1, "dirCode": "g_bd_keypartsinfo", "dirName": "重点部位信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirSort": 3, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 17 }, { "id": 7, "status": 1, "pDirId": 1, "dirCode": "g_bd_tallbuildfloorinfo", "dirName": "高层建筑各层信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirSort": 4, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 17 }, { "id": 8, "status": 1, "pDirId": 1, "dirCode": "f_bs_firesafetycheckresultmaster", "dirName": "消防安全检查结果表", "dataBaseName": "tbuild", "dirLevel": 2, "dirSort": 5, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 19 }, { "id": 9, "status": 1, "pDirId": 1, "dirCode": "g_bd_waterinfo", "dirName": "水源信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirSort": 6, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 44 }, { "id": 10, "status": 1, "pDirId": 1, "dirCode": "g_bd_socialinfo", "dirName": "社会单位信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirSort": 7, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 30 }, { "id": 11, "status": 1, "pDirId": 1, "dirCode": "g_bd_firebrigadeinfo", "dirName": "专职消防队信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirSort": 8, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 19 }, { "id": 12, "status": 1, "pDirId": 1, "dirCode": "g_bd_fireperson", "dirName": "消防机关人员表", "dataBaseName": "tbuild", "dirLevel": 2, "dirSort": 9, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 21 }, { "id": 13, "status": 1, "pDirId": 1, "dirCode": "g_bd_tallbuildabnormalsys", "dirName": "高层建筑异常信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirSort": 10, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 6 }, { "id": 14, "status": 1, "pDirId": 1, "dirCode": "f_bs_waterauditdtl", "dirName": "水源审核信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirSort": 11, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 7 }, { "id": 15, "status": 1, "pDirId": 1, "dirCode": "g_bd_firedepart", "dirName": "消防机构组织机构", "dataBaseName": "tbuild", "dirLevel": 2, "dirSort": 12, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 23 }, { "id": 16, "status": 1, "pDirId": 1, "dirCode": "g_bd_firepersonattach", "dirName": "消防机关人员附件表", "dataBaseName": "tbuild", "dirLevel": 2, "dirSort": 13, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 6 } ], "pageNum": 1, "pageSize": 13, "size": 13, "startRow": 0, "endRow": 12, "pages": 1, "prePage": 0, "nextPage": 0, "isFirstPage": true, "isLastPage": true, "hasPreviousPage": false, "hasNextPage": false, "navigatePages": 8, "navigatepageNums": [ 1 ], "navigateFirstPage": 1, "navigateLastPage": 1 } } ```