获取家装公司列表
开发中
POST
/getCompanyList
请求参数
Body 参数application/json
formname
string
必需
tkey
string
必需
ttype
string
必需
pageIndex
integer
必需
pagesize
integer
必需
示例
{
"formname": "XSDDTYLIU.ASPX",
"tkey": "",
"ttype": "TABLENAME",
"pageIndex": 1,
"pagesize": 50
}示例代码
Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request POST '/getCompanyList' \
--header 'Content-Type: application/json' \
--data-raw '{
"formname": "XSDDTYLIU.ASPX",
"tkey": "",
"ttype": "TABLENAME",
"pageIndex": 1,
"pagesize": 50
}'返回响应
🟢200成功
application/json
Body
msg
string
必需
data
object
必需
sql
string
必需
count
string
必需
pageIndex
integer
必需
pageSize
integer
必需
list
array [object {5}]
必需
columns
array [object {3}]
必需
code
integer
必需
time
integer
必需
示例
{
"msg": "加载成功",
"data": {
"sql": "SELECT TABLENAME AS MAINTABLE,LOGIN_ID FROM (SELECT tablename,login_id FROM gridoption WITH(NOLOCK) WHERE tablename LIKE '%%' OR login_id LIKE '%%' GROUP BY tablename,login_id ) A ORDER BY TABLENAME",
"count": "2563",
"pageIndex": 0,
"pageSize": 50,
"list": [
{
"TCMINI": 0,
"rn": 1,
"MAINTABLE": "",
"TTempCount": 2563,
"LOGIN_ID": "功能推广设置"
},
{
"TCMINI": 0,
"rn": 2,
"MAINTABLE": "AI_CHATMSG",
"TTempCount": 2563,
"LOGIN_ID": "AI聊天记录表"
},
{
"TCMINI": 0,
"rn": 3,
"MAINTABLE": "AI_CHATMSG_KEYWORD",
"TTempCount": 2563,
"LOGIN_ID": "AI关键词"
},
{
"TCMINI": 0,
"rn": 4,
"MAINTABLE": "AI_CHATMSG_KEYWORD_MAPPING",
"TTempCount": 2563,
"LOGIN_ID": "AI关键词对"
},
{
"TCMINI": 0,
"rn": 5,
"MAINTABLE": "AI_CHATMSG_REMARK",
"TTempCount": 2563,
"LOGIN_ID": "AI聊天记录评论表"
},
{
"TCMINI": 0,
"rn": 6,
"MAINTABLE": "AI_CHATMSG_SUG",
"TTempCount": 2563,
"LOGIN_ID": "AI聊天翻译纠正表"
},
{
"TCMINI": 0,
"rn": 7,
"MAINTABLE": "AI_CHATMSG_SYS_UPLOADFILE",
"TTempCount": 2563,
"LOGIN_ID": "AI聊天录音表"
},
{
"TCMINI": 0,
"rn": 8,
"MAINTABLE": "AI_DCDPZJLB",
"TTempCount": 2563,
"LOGIN_ID": "待重导凭证记录表"
},
{
"TCMINI": 0,
"rn": 9,
"MAINTABLE": "AI_DJZJLB",
"TTempCount": 2563,
"LOGIN_ID": "待结账记录表"
},
{
"TCMINI": 0,
"rn": 10,
"MAINTABLE": "AI_DJZJLB_OA",
"TTempCount": 2563,
"LOGIN_ID": "结账记录主表"
},
{
"TCMINI": 0,
"rn": 11,
"MAINTABLE": "AI_GRIDOPTION",
"TTempCount": 2563,
"LOGIN_ID": "AI_数据字典"
},
{
"TCMINI": 0,
"rn": 12,
"MAINTABLE": "AI_GRIDOPTION_CS",
"TTempCount": 2563,
"LOGIN_ID": "AI_数据字典_测试"
},
{
"TCMINI": 0,
"rn": 13,
"MAINTABLE": "AI_JZJDB",
"TTempCount": 2563,
"LOGIN_ID": "自动结账进度表"
},
{
"TCMINI": 0,
"rn": 14,
"MAINTABLE": "AI_JZJDB_OA",
"TTempCount": 2563,
"LOGIN_ID": "结账过程明细表"
},
{
"TCMINI": 0,
"rn": 15,
"MAINTABLE": "AI_JZJDMX_WH",
"TTempCount": 2563,
"LOGIN_ID": "自动结账进度明细_维护"
},
{
"TCMINI": 0,
"rn": 16,
"MAINTABLE": "AI_JZJDZB_WH",
"TTempCount": 2563,
"LOGIN_ID": "自动结账进度主表_维护"
},
{
"TCMINI": 0,
"rn": 17,
"MAINTABLE": "AI_JZPZSC",
"TTempCount": 2563,
"LOGIN_ID": "待产生凭证记录表"
},
{
"TCMINI": 0,
"rn": 18,
"MAINTABLE": "AI_JZPZSC_HIS",
"TTempCount": 2563,
"LOGIN_ID": "待产生凭证记录表_历史"
},
{
"TCMINI": 0,
"rn": 19,
"MAINTABLE": "AI_JZPZSC_RE",
"TTempCount": 2563,
"LOGIN_ID": "待重导凭证记录表"
},
{
"TCMINI": 0,
"rn": 20,
"MAINTABLE": "AI_JZPZSC_YWC",
"TTempCount": 2563,
"LOGIN_ID": "自动结账_凭证生成_已完成"
},
{
"TCMINI": 0,
"rn": 21,
"MAINTABLE": "AI_JZSZB",
"TTempCount": 2563,
"LOGIN_ID": "智能结账设置表"
},
{
"TCMINI": 0,
"rn": 22,
"MAINTABLE": "AI_KEYWORDS",
"TTempCount": 2563,
"LOGIN_ID": "AI小助手提示词"
},
{
"TCMINI": 0,
"rn": 23,
"MAINTABLE": "AI_SYS_UPLOADFILE",
"TTempCount": 2563,
"LOGIN_ID": "AI_系统表_文件上传"
},
{
"TCMINI": 0,
"rn": 24,
"MAINTABLE": "AI_TABLELIST",
"TTempCount": 2563,
"LOGIN_ID": "AI_中间表清单"
},
{
"TCMINI": 0,
"rn": 25,
"MAINTABLE": "AIOT_WORKFLOW",
"TTempCount": 2563,
"LOGIN_ID": "AIOT_业务流程"
},
{
"TCMINI": 0,
"rn": 26,
"MAINTABLE": "AIOT_WORKFLOW_HIS",
"TTempCount": 2563,
"LOGIN_ID": "AIOT_业务流程_历史版本"
},
{
"TCMINI": 0,
"rn": 27,
"MAINTABLE": "AIOT_WORKFLOW_KHXQSZ",
"TTempCount": 2563,
"LOGIN_ID": "AIOT_业务流程_客户详情设置表"
},
{
"TCMINI": 0,
"rn": 28,
"MAINTABLE": "AIOT_WORKFLOW_SAVE",
"TTempCount": 2563,
"LOGIN_ID": "AIOT_业务流程_保存"
},
{
"TCMINI": 0,
"rn": 29,
"MAINTABLE": "AIOT_WORKFLOW_VERSION",
"TTempCount": 2563,
"LOGIN_ID": "AIOT_业务流程_版本管理"
},
{
"TCMINI": 0,
"rn": 30,
"MAINTABLE": "AIOTHSSRY",
"TTempCount": 2563,
"LOGIN_ID": "AIOT函数输入源"
},
{
"TCMINI": 0,
"rn": 31,
"MAINTABLE": "AIOTHSSRYMX",
"TTempCount": 2563,
"LOGIN_ID": "AIOT函数输入源明细"
},
{
"TCMINI": 0,
"rn": 32,
"MAINTABLE": "Alipay_ZF_LOG",
"TTempCount": 2563,
"LOGIN_ID": "支付宝转账日志"
},
{
"TCMINI": 0,
"rn": 33,
"MAINTABLE": "AMBBBDDLXSZ",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴报备订单类型设置"
},
{
"TCMINI": 0,
"rn": 34,
"MAINTABLE": "AMBBBDDLXSZ_MX",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴报备订单类型设置_明细"
},
{
"TCMINI": 0,
"rn": 35,
"MAINTABLE": "AMBBBDDLXTZB",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴报备订单类型调整表"
},
{
"TCMINI": 0,
"rn": 36,
"MAINTABLE": "AMBBMLRYSB",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴部门年度预算表"
},
{
"TCMINI": 0,
"rn": 37,
"MAINTABLE": "AMBBMLRYSBMX",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴部门年度预算明细表"
},
{
"TCMINI": 0,
"rn": 38,
"MAINTABLE": "AMBBMYDYSB",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴部门月度预算表"
},
{
"TCMINI": 0,
"rn": 39,
"MAINTABLE": "AMBBMYDYSBMX",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴部门月度预算明细表"
},
{
"TCMINI": 0,
"rn": 40,
"MAINTABLE": "AMBCBJSMC",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴成本结算名称"
},
{
"TCMINI": 0,
"rn": 41,
"MAINTABLE": "AMBCBJSSZ",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴成本结算设置"
},
{
"TCMINI": 0,
"rn": 42,
"MAINTABLE": "AMBCBJSSZ_MX",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴成本结算设置_明细"
},
{
"TCMINI": 0,
"rn": 43,
"MAINTABLE": "AMBJYMXB",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴交易明细表"
},
{
"TCMINI": 0,
"rn": 44,
"MAINTABLE": "AMBLY_WH",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴利益_维护"
},
{
"TCMINI": 0,
"rn": 45,
"MAINTABLE": "AMBLY_WHMX",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴利益_维护明细"
},
{
"TCMINI": 0,
"rn": 46,
"MAINTABLE": "AMBLYLSCK_WH",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴利益历史参考_维护"
},
{
"TCMINI": 0,
"rn": 47,
"MAINTABLE": "AMBLYLSCK_WHMX",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴利益历史参考_维护明细"
},
{
"TCMINI": 0,
"rn": 48,
"MAINTABLE": "AMBLYYS_WH",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴利益预算_维护"
},
{
"TCMINI": 0,
"rn": 49,
"MAINTABLE": "AMBLYYS_WHMX",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴利益预算_维护明细"
},
{
"TCMINI": 0,
"rn": 50,
"MAINTABLE": "AMBQCCQTZ",
"TTempCount": 2563,
"LOGIN_ID": "阿米巴期初长期投资"
}
],
"columns": [
{
"text": "表名",
"field": "MAINTABLE",
"name": "MAINTABLE"
},
{
"text": "表中文名称",
"field": "LOGIN_ID",
"name": "LOGIN_ID"
}
]
},
"code": 200,
"time": 447
}修改于 2025-04-22 09:24:22