# \u5904\u7406233\u7684\u6CBB\u7597\u6570\u636E,\u5B58\u5165232
# \u7B2C\u4E00\u6B65,\u75BE\u75C5\u5230\u7C7B,\u7C7B\u5305\u542B\u836F
diseaseDrugsMedication=\
  match(d:Disease{name:'diseaseName'})-[r:\u63A8\u8350]->(h)-[r1:\u5305\u542B]->(l:Medicine) \
  return d.name,h.name as drug,labels(h)[0] as label,r.p as p,collect(l.name) as collectName
# \u7B2C\u4E8C\u6B65,\u75BE\u75C5\u548C\u836F\u7684\u5173\u7CFB
diseaseMedication=match(d:Disease{name:"diseaseName"})-[r:\u63A8\u8350]->(l:Medicine) return d.name,r.rate as p,l.name as collectName
# \u7B2C\u4E09\u6B65,\u5927\u7C7B\u548C\u5B50\u7C7B\u7684\u5173\u7CFB
bigDrugAndSubDrugs=match(d:Disease)-[r:\u63A8\u8350]->(s:Drugs)-[r1:\u5305\u542B]->(j:Drugs)where d.name="diseaseName" return s.name as big,j.name as sub

# \u5904\u7406232\u7684\u6307\u6807\u6570\u636E\u5B58\u5165112\u4E2D
allStruct=match(d:Indicators{name:'idn'})-[r2:\u5185\u5BB9]->(n:Content) where r2.p=1 \
return r2.p as sort1 ,n.name as conten,null as sort2,null as item,null as controlType,null as state,null as value,null as uint,null as details \
union \
match(d:Indicators{name:'idn'})-[r2:\u5185\u5BB9]->(n:Content)-[r3:\u9879\u76EE]->(i:Item) \
return r2.p as sort1 ,n.name as conten,r3.p as sort2,i.name as item,i.controlType as controlType,i.state as state,i.value as value,i.uint as uint,i.details as details order by sort1,sort2

# \u5904\u7406232\u7684\u7BA1\u7406\u8BC4\u4F30\u6570\u636E\u5B58\u5165112\u4E2D
allMange=match(d:Disease)-[r1:\u7BA1\u7406\u8BC4\u4F30]-(m:Management)-[r2:\u7597\u6548\u8BC4\u4F30]->(e:Effect)-[r3:\u7ED3\u679C]-(u:Result) \
where d.name='dis' \
return m.name as ma,r2.p as p1,e.name as eff,r3.p as p2,u.name as res,u.state as st order by p1,p2
xuezhi=match(e:Effect)-[r:\u6307\u6807]->(l:LIS)-[r1:\u8BA1\u7B97\u7ED3\u679C]->(k:Result) where e.name='\u8840\u8102\u63A7\u5236\u60C5\u51B5' \
return l.name as name,r1.between as between ,k.name as res