代码改变世界

联动设置

2017-09-10 13:31  金色海洋（jyk）  阅读(1272)  评论(1)  编辑  收藏  举报

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

 

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

2