界面显示sql
select * from vw_bq_yjyzzxd_qxcf where 1=1 and (yznr00 like '%手术名称%' or yznr00 like '%备皮%' or yznr00 like '%备血%' or yznr00 like '%导尿%'
or yznr00 like '%灌肠%' or yznr00 like '%阴道冲洗%' or yznr00 like '%置胃管%' or yznr00 like '%禁食%' or yznr00 like '%禁水%'
or yznr00 like '%术前耳穴埋豆%' or yznr00 like '%睡前用药%' or yznr00 like '%术前用药%' or yznr00 like '%手术带药%' or yznr00 like '%备红细胞%')

打印主sql
select * from vw_bq_yjyzzxd_qxcf where 1=1 and (yznr00 like '%手术名称%' or yznr00 like '%备皮%' or yznr00 like '%备血%' or yznr00 like '%导尿%'
or yznr00 like '%灌肠%' or yznr00 like '%阴道冲洗%' or yznr00 like '%置胃管%' or yznr00 like '%禁食%' or yznr00 like '%禁水%'
or yznr00 like '%术前耳穴埋豆%' or yznr00 like '%睡前用药%' or yznr00 like '%术前用药%' or yznr00 like '%手术带药%' or yznr00 like '%备红细胞%')

明细sql
select * from vw_bq_yjyzzxd_qxcf where 1=1 and (yznr00 like '%手术名称%' or yznr00 like '%备皮%' or yznr00 like '%备血%' or yznr00 like '%导尿%'
or yznr00 like '%灌肠%' or yznr00 like '%阴道冲洗%' or yznr00 like '%置胃管%' or yznr00 like '%禁食%' or yznr00 like '%禁水%'
or yznr00 like '%术前耳穴埋豆%' or yznr00 like '%睡前用药%' or yznr00 like '%术前用药%' or yznr00 like '%手术带药%' or yznr00 like '%备红细胞%')

打印主sql分组字段
BQH000,KSH000,ZYID00,XM0000,ZYH000,CH0000,YZID00,ZXRQ01,PCMC00

排序
CH0000, CLBZ00,ZXRQ01,YZID00,YZMXID