select WSID00,A.ZYID00,BLXMBH,WSMC00,MBBH00,CJYSBH,CJYSXM,CJRQ00,CJSJ00,SFXYSH,YGBZ00,WSZT00,TJRQ00,TJSJ00,ZXRDJ0,SHRDJ0,XGZBH0,XGZXM0,XGZDJ0,XGRQ00,XGSJ00,XGZBH1,XGZXM1,XGZDJ1,XGRQ01,XGSJ01,DYRBH0,DYRXM0,DYRQ00,DYSJ00,ZHZBH0,ZHZXM0,ZHZDJ0,ZHRQ00,ZHSJ00, SYS.XMLTYPE.GETCLOBVAL(XMLNR0) XMLNR0,SYS.XMLTYPE.GETCLOBVAL(CDA000) CDA000,DQDKYS,WJMC00,JMHSJ0,GZRQ00,GZSJ00,B.RYRQ00,a.WSHBID,a.WSQYMC,SFHBWS,D.HBWJMC,D.HBWSMC,DKIP00,PXRQ00,PXSJ00,THYY00,THRQ00,THSJ00,JSRQ00,JSSJ00,(select QZZGDJ from ZS_BLZCXM where BLXZ00=A.BLXMBH and rownum=1) QZZGDJ  FROM ZS_BLWS00 A INNER JOIN ZY_BRXXB0 B ON A.ZYID00=B.ZYID00  LEFT JOIN ZS_WSHBXX  D on A.WSHBID=D.WSHBID WHERE WSZT00<>'3' AND WSID00=8166590

select a.ZYID00,a.WSID00,a.ZDQZYS,a.CXQZYS,a.ZT0000,a.QZTPMC,a.SJYZID,a.QZRQ00,a.QZSJ00,a.CXQZRQ,a.CXQZSJ from ZS_BLQZGL a,zs_blws00 b where  a.wsid00=b.wsid00 and b.wszt00<>'3' and a.ZT0000<>'1' and a.ZYID00=:ZYID00 and a.wsid00=:WSID00

parameters :ZYID00=6364434 :WSID00=8166590 

SELECT name00,value0,flag00,bz0000 FROM XT_XTCS00 WHERE name00='ZS_CARZLX'

insert into ZS_XTCWXX(CWID00,YGBH00,YGXM00,CWXX00,DXMC00,DZXX00,CWFF00,CWBZ00,CWTPMC) values(:CWID00,:UserId,:UserName,:ErrorMessage,:ErrorObject,:ErrorStack,:ErrorMethod,:Remark,:CWTPMC)

parameters :CWID00=27437226 :UserId=4960 :UserName=管理员 :ErrorMessage=未将对象引用设置到对象的实例。 :ErrorObject=ResidentQCCommon :ErrorStack=   在 Medical.Resident.RuntimeMonitor.CtrlCommentFeedbackDoc.dgvComment_MouseDoubleClick(Object sender, MouseEventArgs e) :ErrorMethod=dgvComment_MouseDoubleClick :Remark= :CWTPMC=27437226.jpg