联动设置

简介: ShequId 主键 请选择街道 {"itemType":"sql","width":"120","sql":"SELECT ShequId AS id, ShequName AS txtFROM xq_dic_shequ WHERE (AreaId = 1) AND (TypeId ...

ShequId 主键 请选择街道 {"itemType":"sql","width":"120","sql":"SELECT ShequId AS id, ShequName AS txt
FROM xq_dic_shequ WHERE (AreaId = 1) AND (TypeId = 0) AND (IsDel=0)","isChange":"","union":"area","index":2,"size":20,"para":{"mdid":324, "mpvid":32405, "fpvid":32402, "columnKey":"32405", "cacheKey":"no", "colID":"5103040", "query":["c5103030"]} }
CityId 城市 请填写城市 {"itemType":"sql","width":"0","sql":"SELECT CityId AS id, CASE isdel WHEN 1 THEN CityName + '(已删)' ELSE CityName END AS txt FROM pub_City where CityId <> -1 ORDER BY CityId","isChange":"-1","union":"area","index":0}
AreaId 行政区 请填写区域 {"itemType":"1","width":"0","sql":"SELECT  AreaId AS id,   AreaName  AS txt FROM V_N_List_Lt_PubArea WHERE (CityId = 1)","isChange":"-1","union":"area","index":1,"para":{"mdid":335, "mpvid":33505, "fpvid":33502, "columnKey":"33505", "cacheKey":"no", "colID":"5006020", "query":["c5006050"]} }
TypeId 所属街道 请填写类型ID {"itemType":"sql","width":"120","sql":"SELECT ShequId AS id, ShequName AS txt
FROM xq_dic_shequ WHERE (AreaId = 1) AND (TypeId = 0) AND (IsDel=0)","isChange":"","union":"area","index":2,"para":{"mdid":324, "mpvid":32405, "fpvid":32402, "columnKey":"32405", "cacheKey":"no", "colID":"5103040", "query":["c5103030"]} }
NULL NULL NULL NULL

 

纯粹是给自己用的。每次都要找好久,所以记在这里了。

相关文章
|
安全 数据库管理
DMS安全协同模式半脱敏要怎么设置
DMS安全协同模式半脱敏要怎么设置啊?
498 3
|
3月前
|
数据可视化 定位技术 API
云解析地图作业问题之通过saveEffect实现组件联动如何解决
云解析地图作业问题之通过saveEffect实现组件联动如何解决
50 14
|
6月前
DataphinV4.0来啦 | 自定义全局角色 ,实时研发全场景覆盖
DataphinV4.0来啦 | 自定义全局角色 ,实时研发全场景覆盖
52 0
|
数据可视化 机器人 物联网
通过场景联动实现设备上下线通知
场景联动是规则引擎中,一种开发自动化业务逻辑的可视化编程方式,您可以通过可视化的方式定义设备之间联动规则,并部署规则至物联网平台云端或者边缘端。
164 0
通过场景联动实现设备上下线通知
|
安全 开发者
如何进行云资产的安全告警设置|学习笔记
快速学习如何进行云资产的安全告警设置
108 0
uiu
|
Web App开发 编解码 前端开发
HTML+CSS各类布局模式介绍
HTML+CSS各类布局模式介绍
uiu
187 0
html+css实战189-侧导航布局
html+css实战189-侧导航布局
124 0
html+css实战189-侧导航布局
html+css实战188-侧导航布局
html+css实战188-侧导航布局
136 0
html+css实战188-侧导航布局