文档
测试

根据表头信息分页查询对应结果

websocket测试
GET
http://192.168.3.96:8111/dataSearch/getSearchResult?tableCode=g_bd_tallbuildinfo&columnName=FAddress&searchStr=南京

接口描述

/dataSearch/getSearchResult

请求参数

参数名
类型
描述
必填
tableCode
str
表名 例：g_bd_tallbuildinfo
必填
columnName
str
查询字段 例：FAddress
必填
searchStr
str
查询内容 例：南京
必填
pageNumber
int
当前页数 1
必填
pageSize
int
一页展示条数 10
必填

响应参数

参数名
类型
描述
必填
status
int
示例：200
必填
data
object
数据字典
必填
total
int
示例：3
必填
list
array
数据列表
必填
Fcorps_name
string
示例：贵州省公安消防总队
必填
Ftallbuild_Code
string
示例：
必填
Fis_secmanager
string
示例：0
必填
Fis_maint
string
示例：
必填
Fis_finish
string
示例：1
必填
Fis_Active
string
示例：1
必填
Ffiredepart_UUID
string
示例：2ce78c840c4641749f9d0ab34a34d276
必填
Flast_Editor_Name
string
示例：杨跃军
必填
FSP_name
string
示例：
必填
Faudit_uuid
string
示例：38A720B4887646489C4936951D13FBC3
必填
FLevel
int
示例：3
必填
Ftallbuild_up_Area
int
示例：8108
必填
Fprovince_Code
string
示例：520000
必填
Fbuild_class
string
示例：020101
必填
Flast_Editor_ID
string
示例：ce9f93d39f6d48fe997a2e7d0a1e0b27
必填
Fprovince_ID
string
示例：520000
必填
Fcomplete_Date
string
示例：20110624
必填
Faudit_time
string
示例：20170901121056
必填
Ftallbuild_height
int
示例：77
必填
Fsocial_UUID
string
示例：638d65395ba911e79500a4dcbef7597f
必填
Ftallbuild_Up_floor
int
示例：24
必填
Fis_Singleproperty
string
示例：1
必填
MerchantCount
int
示例：2
必填
FAddress
string
示例：上海路街道南京路城上城3信合大厦(厦门路)
必填
Faudit_status
string
示例：09
必填
Fcreator_Name
string
示例：杨跃军
必填
Flast_Edit_Time
string
示例：20170831144958
必填
Fis_tall
string
示例：1
必填
Ffire_Elevator
int
示例：1
必填
FFireSafetyCheckIsNomal
string
示例：1
必填
FManagerType
string
示例：1
必填
FFire_Rating
string
示例：G4201
必填
Ffiredepart_Name
string
示例：汇川区公安消防大队
必填
Fcorps_uuid
string
示例：e289775cdcde495e9120e2fd5fbddb09
必填
Fhomefire_UUID
string
示例：2ce78c840c4641749f9d0ab34a34d276
必填
FLongitude
float
示例：106.92337
必填
Fsecmanager_tel
string
示例：
必填
Fhomefire_name
string
示例：汇川区公安消防大队
必填
Ftallbuild_down_Area
int
示例：2332
必填
Fbranch_uuid
string
示例：b4c6f8b88f8940e7b3a9305db9af1754
必填
Fis_check
string
示例：
必填
Fcounty_Code
string
示例：520303
必填
Fsquadron_name
string
示例：遵义市公安消防支队汇川区大队长沙路中队
必填
Faudit_name
string
示例：张锐
必填
Flink_Man
string
示例：谢友刚
必填
Fcity_Code
string
示例：520300
必填
Fsocial_Name
string
示例：遵义上城会物业服务有限公司
必填
err_flag
int
示例：0
必填
Fis_autofire
string
示例：1
必填
Faudit_desc
string
示例：
必填
Fis_social
string
示例：1
必填
Ffactory_Rating
string
示例：G4201
必填
Funit
int
示例：1
必填
Fsquadron_uuid
string
示例：9c79df3cbf464615b55f925722f2f839
必填
Ftallbuild_Area
int
示例：10440
必填
Fsecmanager
string
示例：
必填
Ftel_No
string
示例：13639243339
必填
FDescription
string
示例：test001
必填
Finput_type
string
示例：2
必填
Ftallbuild_UUID
string
示例：373023CF6C1A4D3A88029D1D4D477252
必填
Fpower_load
string
示例：G4501
必填
Fbuild_class_name
string
示例：有商业服务网点
必填
Fcreator_ID
string
示例：ce9f93d39f6d48fe997a2e7d0a1e0b27
必填
FLatitude
float
示例：27.717129
必填
Fbranch_name
string
示例：遵义市公安消防支队
必填
Fstore_Rating
string
示例：G4201
必填
Fcreat_Time
string
示例：20170628104227
必填
Ftallbuild_Name
string
示例：遵义市信合大厦1座
必填
Flogo
string
示例：B84F68E4235546F89D6E18823E069EAB
必填
Ftallbuild_down_floor
int
示例：2
必填
pageNum
int
示例：1
必填
pageSize
int
示例：10
必填
size
int
示例：3
必填
startRow
int
示例：1
必填
endRow
int
示例：3
必填
pages
int
示例：1
必填
prePage
int
示例：0
必填
nextPage
int
示例：0
必填
isFirstPage
boolean
示例：true
必填
isLastPage
boolean
示例：true
必填
hasPreviousPage
boolean
示例：false
必填
hasNextPage
boolean
示例：false
必填
navigatePages
int
示例：8
必填
navigatepageNums
array
数据列表
必填
navigateFirstPage
int
示例：1
必填
navigateLastPage
int
示例：1
必填

说明 / 示例

请求示例 ```json http://192.168.3.96:8111/dataSearch/getSearchResult?tableCode=g_bd_tallbuildinfo&columnName=FAddress&searchStr=南京 ``` 返回示例 ```json { "status": 200, "data": { "total": 3, "list": [ { "Fcorps_name": "贵州省公安消防总队", "Ftallbuild_Code": "", "Fis_secmanager": "0", "Fis_maint": "", "Fis_finish": "1", "Fis_Active": "1", "Ffiredepart_UUID": "2ce78c840c4641749f9d0ab34a34d276", "Flast_Editor_Name": "杨跃军", "FSP_name": "", "Faudit_uuid": "38A720B4887646489C4936951D13FBC3", "FLevel": 3, "Ftallbuild_up_Area": 8108.00, "Fprovince_Code": "520000", "Fbuild_class": "020101", "Flast_Editor_ID": "ce9f93d39f6d48fe997a2e7d0a1e0b27", "Fprovince_ID": "520000", "Fcomplete_Date": "20110624", "Faudit_time": "20170901121056", "Ftallbuild_height": 77.00, "Fsocial_UUID": "638d65395ba911e79500a4dcbef7597f", "Ftallbuild_Up_floor": 24.00, "Fis_Singleproperty": "1", "MerchantCount": 2, "FAddress": "上海路街道南京路城上城3信合大厦(厦门路)", "Faudit_status": "09", "Fcreator_Name": "杨跃军", "Flast_Edit_Time": "20170831144958", "Fis_tall": "1", "Ffire_Elevator": 1, "FFireSafetyCheckIsNomal": "1", "FManagerType": "1", "FFire_Rating": "G4201", "Ffiredepart_Name": "汇川区公安消防大队", "Fcorps_uuid": "e289775cdcde495e9120e2fd5fbddb09", "Fhomefire_UUID": "2ce78c840c4641749f9d0ab34a34d276", "FLongitude": 106.923370, "Fsecmanager_tel": "", "Fhomefire_name": "汇川区公安消防大队", "Ftallbuild_down_Area": 2332.00, "Fbranch_uuid": "b4c6f8b88f8940e7b3a9305db9af1754", "Fis_check": "", "Fcounty_Code": "520303", "Fsquadron_name": "遵义市公安消防支队汇川区大队长沙路中队", "Faudit_name": "张锐", "Flink_Man": "谢友刚", "Fcity_Code": "520300", "Fsocial_Name": "遵义上城会物业服务有限公司", "err_flag": 0, "Fis_autofire": "1", "Faudit_desc": "", "Fis_social": "1", "Ffactory_Rating": "G4201", "Funit": 1, "Fsquadron_uuid": "9c79df3cbf464615b55f925722f2f839", "Ftallbuild_Area": 10440.00, "Fsecmanager": "", "Ftel_No": "13639243339", "FDescription": "test001", "Finput_type": "2", "Ftallbuild_UUID": "373023CF6C1A4D3A88029D1D4D477252", "Fpower_load": "G4501", "Fbuild_class_name": "有商业服务网点", "Fcreator_ID": "ce9f93d39f6d48fe997a2e7d0a1e0b27", "FLatitude": 27.717129, "Fbranch_name": "遵义市公安消防支队", "Fstore_Rating": "G4201", "Fcreat_Time": "20170628104227", "Ftallbuild_Name": "遵义市信合大厦1座", "Flogo": "B84F68E4235546F89D6E18823E069EAB", "Ftallbuild_down_floor": 2.00 }, { "Fcorps_name": "贵州省公安消防总队", "Ftallbuild_Code": "", "Fis_secmanager": "1", "Fis_maint": "", "Fis_finish": "1", "Fis_Active": "1", "Ffiredepart_UUID": "2ce78c840c4641749f9d0ab34a34d276", "Flast_Editor_Name": "商增文", "FSP_name": "", "Faudit_uuid": "38A720B4887646489C4936951D13FBC3", "FLevel": 3, "Ftallbuild_up_Area": 20000.00, "Fprovince_Code": "520000", "Fbuild_class": "02030101", "Flast_Editor_ID": "70c52bcc7d754f1eb8f011a6ede6da06", "Fprovince_ID": "520000", "Fcomplete_Date": "20140629", "Faudit_time": "20170829204124", "Ftallbuild_height": 84.00, "Fsocial_UUID": "fe331e588cb311e79500a4dcbef7597f", "Ftallbuild_Up_floor": 24.00, "Fis_Singleproperty": "1", "MerchantCount": 0, "FAddress": "南京路与珠海路交叉口北200米0曼哈顿时代大厦", "Faudit_status": "09", "Fcreator_Name": "商增文", "Flast_Edit_Time": "20170911151832", "Fis_tall": "1", "Ffire_Elevator": 1, "FFireSafetyCheckIsNomal": "0", "FManagerType": "1", "FFire_Rating": "G4201", "Ffiredepart_Name": "汇川区公安消防大队", "Fcorps_uuid": "e289775cdcde495e9120e2fd5fbddb09", "Fhomefire_UUID": "2ce78c840c4641749f9d0ab34a34d276", "FLongitude": 106.931220, "Fsecmanager_tel": "15085529766", "Fhomefire_name": "汇川区公安消防大队", "Ftallbuild_down_Area": 14000.00, "Fbranch_uuid": "b4c6f8b88f8940e7b3a9305db9af1754", "Fis_check": "", "Fcounty_Code": "520303", "Fsquadron_name": "", "Faudit_name": "张锐", "Flink_Man": "罗宗美", "Fcity_Code": "520300", "Fsocial_Name": "曼哈顿时代广场一期", "err_flag": 0, "Fis_autofire": "1", "Faudit_desc": "", "Fis_social": "1", "Ffactory_Rating": "", "Funit": 1, "Fsquadron_uuid": "", "Ftallbuild_Area": 34000.00, "Fsecmanager": "罗宗美", "Ftel_No": "15085529766", "FDescription": "test001", "Finput_type": "2", "Ftallbuild_UUID": "90AD5AA6DD7844698711E4247B7FFCE1", "Fpower_load": "G4501", "Fbuild_class_name": "商用楼", "Fcreator_ID": "70c52bcc7d754f1eb8f011a6ede6da06", "FLatitude": 27.717579, "Fbranch_name": "遵义市公安消防支队", "Fstore_Rating": "", "Fcreat_Time": "20170829202316", "Ftallbuild_Name": "曼哈顿时代广场一期商业楼", "Flogo": "", "Ftallbuild_down_floor": 3.00 }, { "Fcorps_name": "贵州省公安消防总队", "Ftallbuild_Code": "", "Fis_secmanager": "1", "Fis_maint": "", "Fis_finish": "1", "Fis_Active": "1", "Ffiredepart_UUID": "2ce78c840c4641749f9d0ab34a34d276", "Flast_Editor_Name": "萧娟", "FSP_name": "", "Faudit_uuid": "38A720B4887646489C4936951D13FBC3", "FLevel": 3, "Ftallbuild_up_Area": 44033.00, "Fprovince_Code": "520000", "Fbuild_class": "02030101", "Flast_Editor_ID": "F422D3C4BD564D809BF998218D6CE025", "Fprovince_ID": "520000", "Fcomplete_Date": "20110626", "Faudit_time": "20170901121101", "Ftallbuild_height": 98.00, "Fsocial_UUID": "638d65395ba911e79500a4dcbef7597f", "Ftallbuild_Up_floor": 26.00, "Fis_Singleproperty": "1", "MerchantCount": 84, "FAddress": "上海路街道南京路城上城12信合大厦(厦门路)", "Faudit_status": "09", "Fcreator_Name": "萧娟", "Flast_Edit_Time": "20170831190803", "Fis_tall": "1", "Ffire_Elevator": 1, "FFireSafetyCheckIsNomal": "0", "FManagerType": "1", "FFire_Rating": "G4201", "Ffiredepart_Name": "汇川区公安消防大队", "Fcorps_uuid": "e289775cdcde495e9120e2fd5fbddb09", "Fhomefire_UUID": "2ce78c840c4641749f9d0ab34a34d276", "FLongitude": 106.923480, "Fsecmanager_tel": "13639243339", "Fhomefire_name": "汇川区公安消防大队", "Ftallbuild_down_Area": 3387.00, "Fbranch_uuid": "b4c6f8b88f8940e7b3a9305db9af1754", "Fis_check": "", "Fcounty_Code": "520303", "Fsquadron_name": "遵义市公安消防支队特勤中队", "Faudit_name": "张锐", "Flink_Man": "谢友刚", "Fcity_Code": "520300", "Fsocial_Name": "遵义上城会物业服务有限公司", "err_flag": 0, "Fis_autofire": "1", "Faudit_desc": "", "Fis_social": "1", "Ffactory_Rating": "G4201", "Funit": 1, "Fsquadron_uuid": "a8274e5f04464cf6be4766dc7120d8c6", "Ftallbuild_Area": 47421.00, "Fsecmanager": "谢友刚", "Ftel_No": "13639243339", "FDescription": "test001", "Finput_type": "2", "Ftallbuild_UUID": "CB953E9F2A4C4440A20BE5F27E09EC09", "Fpower_load": "G4502", "Fbuild_class_name": "商用楼", "Fcreator_ID": "F422D3C4BD564D809BF998218D6CE025", "FLatitude": 27.717140, "Fbranch_name": "遵义市公安消防支队", "Fstore_Rating": "G4201", "Fcreat_Time": "20170628102458", "Ftallbuild_Name": "信合大厦（城上城）", "Flogo": "", "Ftallbuild_down_floor": 2.00 } ], "pageNum": 1, "pageSize": 10, "size": 3, "startRow": 1, "endRow": 3, "pages": 1, "prePage": 0, "nextPage": 0, "isFirstPage": true, "isLastPage": true, "hasPreviousPage": false, "hasNextPage": false, "navigatePages": 8, "navigatepageNums": [ 1 ], "navigateFirstPage": 1, "navigateLastPage": 1 } } ```
上一篇 查询数据列表页的表头信息
nextDoc 根据表名查询字段和注释信息
本文档使用易文档编写, 更新时间: 2021-05-24 15:20