联动设置

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

 

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