select ZRZYLS,LSZYBZ,* from zy_brxxb0  where XM0000 LIKE '%张三六%'
select sfzrzy,* from sf_brxxb0  where XM0000 LIKE '%张三六%'
--------------------------------------------------------------------------
select zt0000,* from ic_yhxx00 where ickh00='0221889600079550' and zt0000=
select * from ic_yhxx00 where brid00=16291562
select * from ic_yhxx00 where BRID00=118846
select * from sf_brxxb0 
select * from zy_brxxb0 where xm0000='戈义言'
select * from bm_brxxb0  where  brid00=16291562
select * from bm_brxxb0  where   brxm00 like '%滋滋%'


--门诊病人：select * from ic_yhxx00 a , sf_brxxb0 b where a.brid00=b.brid00 and a.zt0000=1
--住院病人：select * from ic_yhxx00 a , zy_brxxb0 b where a.brid00=b.brid00 and a.zt0000=1
--员工编号与部门编号：select b.BMMC00,a.* ,b.* from bm_ygbm00 a,bm_bmbm00 b and a.bmbh00=b.bmbh00


-----------------------医疗费用智慧管控系统---------------------------------
select   TQSJ00,yzzt00,* from bq_ypyz00  where  zyid00='2526' --病区药品医嘱执行状态  检验本科室-大肝功 检验非本科室-血清C肽测定(餐后2小时) ；检查本科室-鼻部特殊治疗（电灼法） 检查非本科室-床边心电图 
select QLZT00,* from YF_YZYPSQ  where  BRXM00='庄生'        --病区药品申请执行状态
select XMZT00,* from yj_yw0000  where BRXM00='庄生' and ZLXMJC='血清C肽测定(餐后2小时)' --病区项目执行状态
select XMZT00,* from yj_yw0000  where BRXM00='庄生' and ZLXMJC='床边心电图'
select XMZT00,* from yj_yw0000  where BRXM00='庄生' and ZLXMJC like '%鼻部特殊治疗%'
select XMZT00,* from yj_yw0000  where BRXM00='庄生' and ZLXMJC like '%大肝功%'
select * from zy_fymx00 where djh000='9915245' --对应医技收费单据号
select * from zy_brfy00  where djh000='9915245' 
select * from zy_fymx00 where zyid00='2526' and xmmc00 like '%鼻部特殊%'
select * from zy_brxxb0 where zyh000='20220004'
select  JGZT00,txm000,* from jy_yw0000 where BRXM00='庄生'
select  JGZT00,txm000, * from VW_JY_YW0000  where BRXM00='庄生'
SELECT yzzt00,* FROM bq_yjyz00 where ZLXMJC like '%血清C肽%'
select * from view_expense_new
VW_ZY_RQDMX8_FK
sf_bq_zxzt00

alter trigger TR_YF_YZYPSQ_LIMIT disable; --停用触发器
alter trigger TR_YF_YZYPSQ_LIMIT enable; --启用触发器