联动设置
ShequId | 主键 | 请选择街道 | {"itemType":"sql","width":"120","sql":"SELECT ShequId AS id, ShequName AS txtFROM 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 txtFROM 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 |
纯粹是给自己用的。每次都要找好久，所以记在这里了。