begin SQL,2025-12-11 11:38:20.923
 select JLBH,CUR_VAL from BFCONFIG where JLBH in (0,520000102,520000103,520000112,520000113,520000115,520000120,520000121,520000123,520000128,520000129,520000140,520000141,520000143)
 end 

 begin SQL,2025-12-11 11:38:20.923
 select CONTENT from XTXX where ID = 150 
 end 

 begin SQL,2025-12-11 11:38:20.986
 select USER_DM,USER_PSW,HTTPOK,WSOK,WCFOK from CRMUSER
 end 

 begin SQL,2025-12-11 11:38:20.986
 select IPADDR from CRMCLIENT where WSOK = 1 
 end 

 begin SQL,2025-12-11 11:38:21.001
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 11:38:21.017
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 11:38:21.079
 select a.HYID,a.HYKTYPE,a.HYK_NO,a.STATUS,a.PASSWORD,a.BJ_PSW,b.BJ_YHQZH,b.BJ_YZM,a.FXDW from HYK_HYXX a,HYKDEF b where a.HYKTYPE = b.HYKTYPE   and 1=2
 end 

 begin SQL,2025-12-11 11:43:21.033
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 11:43:21.033
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 11:46:28.418
 select SHDM,MDID from MDDY where MDDM = 'BG01'
 end 

 begin SQL,2025-12-11 11:46:28.418
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 11:46:28.418
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 11:46:28.418
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 11:46:28.418
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 11:46:28.418
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 11:46:28.418
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 11:46:28.418
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 11:46:28.418
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 11:46:34.021
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 11:46:34.021
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 11:46:34.021
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 11:46:34.036
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 11:46:34.246
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100065
 end 

 begin SQL,2025-12-11 11:46:34.246
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100065
 end 

 begin SQL,2025-12-11 11:46:34.246
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0008009'
 end 

 begin SQL,2025-12-11 11:46:34.246
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 67
 end 

 begin SQL,2025-12-11 11:46:34.246
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 345661
 end 

 begin SQL,2025-12-11 11:46:34.246
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 345661 and b.MDID = 1
 end 

 begin SQL,2025-12-11 11:46:34.246
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 11:46:34.246
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 11:46:34.309
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-11 11:46:34.309
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-11 11:46:34.309
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372288,'BG',1,'010010',100065,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,2.00,0.00,0.00,0,0,'','',0,0,1.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-11 11:46:34.309
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372288,0,-1,345661,'0008009','011201021009',1,0,1.0000,1.0000,2.00,0.00,0.00,0,0,0,0,0,0,1.0000,2.00,2.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,67,0)
 end 

 begin SQL,2025-12-11 11:46:38.651
 select a.STATUS,a.SHDM,a.MDID,a.SKTNO,a.JLBH,a.DJLX,a.HYID,a.HYID_FQ,a.HYID_TQ,a.XFJLID_OLD,a.JZRQ,a.SCSJ,a.XFRQ_FQ,a.SKYDM,a.JE,a.ZK_HY,a.JF,a.JFBS,a.BSFS,a.HYKNO,a.HYKNO_FQ,b.MDDM,a.VIPTYPE,a.JF_CZZ,a.ORDER_NO from HYK_XFJL a,MDDY b where a.XFJLID = 3372288  and a.MDID = b.MDID
 end 

 begin SQL,2025-12-11 11:46:38.651
 select SHZFFSID,ZFFSMC,BJ_JF,BJ_FQ,BJ_MBJZ,YHQID from SHZFFS where SHDM = 'BG' and ZFFSDM = '1'
 end 

 begin SQL,2025-12-11 11:46:38.651
 select count(*) from HYK_XFJL_ZKQDM a,YHQCODE b  where a.YHQCODE = b.YHQCODE   and a.XFJLID = 3372288 and b.STATUS <> 1 
 end 

 begin SQL,2025-12-11 11:46:38.666
 select INX,SHSPID,SPDM,BMDM,XSSL,XSJE,BJ_JF,BJ_BCJHD,JFJS,BJ_JFBS,BS,JFFBGZ,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ  from HYK_XFJL_SP where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.682
 select INX,MBJZJE from HYK_XFJL_SP_MBJZ where MBJZJE > 0 and XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.682
 select INX,YHQID,CXID,XFLJFQFS,YHQFFGZID from HYK_XFJL_SP_FQ where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.698
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 2    and :SJ1  between RQ1 and RQ2   and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 11:46:38.713
 update HYK_XFJL set STATUS = 2,CZJE = 0.00,JF = 0.0000,JF_CZZ = 0.0000 where XFJLID = 3372288   and STATUS in (0,2) 
 end 

 begin SQL,2025-12-11 11:46:38.713
 delete from HYK_XFJL_ZFFS where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.713
 insert into HYK_XFJL_ZFFS(XFJLID,INX,ZFFSID,ZFFSDM,BJ_JF,BJ_FQ,YHQID,JE,BJ_TQ ) values(3372288,0,1,'1',1,1,null,2.00,0)
 end 

 begin SQL,2025-12-11 11:46:38.713
 delete from HYK_XFJL_YHKZF where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.729
 delete from HYK_XFJL_SP_ZFFS where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.729
 delete from HYK_XFJL_SP_YQFT where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.729
 delete from HYK_XFJL_SP_ZFFS_FQ where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.729
 delete from HYK_XFJL_ZFFS_FQ where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.729
 delete from HYK_XFJL_ZSLP where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.745
 delete from HYK_XFJL_ZFFS_ZSLP where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.745
 delete from HYK_XFJL_FQ where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.745
 delete from HYK_XFJL_SP_ZFFS_YQHM where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.745
 delete from HYK_XFJL_SP_YQFT_BMQ where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.745
 delete from HYK_XFJL_FQ_MZGZ where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.760
 delete from HYK_XFJL_CJ where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.760
 insert into HYK_XFJL_SP_ZFFS(XFJLID,INX,SHZFFSID,BJ_JF,BJ_FQ,YHQID,JE) values(3372288,0,1,1,1,null,2.00)
 end 

 begin SQL,2025-12-11 11:46:38.760
 insert into HYK_XFJL_SP_YQFT(XFJLID, INX, YHQID, BMDM, SPDM, SHSPID, YHQSYDBH, CXID, YHQSYGZID, BJ_FQ, XSJE, XSJE_YQ, YQJE)  select a.XFJLID,a.INX,a.YHQID,b.BMDM,b.SPDM,b.SHSPID,null,null,null,0,b.XSJE,0,a.JE  from HYK_XFJL_SP_ZFFS a,HYK_XFJL_SP b,YHQDEF c  where a.XFJLID = 3372288  and a.XFJLID = b.XFJLID   and a.INX = b.INX   and a.YHQID = c.YHQID   and a.YHQID >= 0   and c.BJ_DZYHQ = 1 
 end 

 begin SQL,2025-12-11 11:46:38.760
 update HYK_XFJL_SP set  XSJE_FQ = 2.00 ,XSJE_JF = 2.00 ,JF = 0.0000 ,JF_CZZ = 0.0000 where XFJLID = 3372288   and INX = 0
 end 

 begin SQL,2025-12-11 11:46:38.760
 update HYK_XFJL_SP_FQ set FQJE = 0  ,XSJE_FQ = 2.00 where XFJLID = 3372288   and INX = 0
 end 

 begin SQL,2025-12-11 11:46:38.776
 delete from HYK_XFJFBS where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:38.776
 delete from HYK_XFCZZBS where XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:39.136
 select a.STATUS,a.SHDM,a.MDID,a.SKTNO,a.JLBH,a.DJLX,a.HYID,a.HYID_FQ,a.HYID_TQ,a.XFJLID_OLD,a.JZRQ,a.SCSJ,a.XFRQ_FQ,a.SKYDM,a.JE,a.ZK_HY,a.JF,a.JFBS,a.BSFS,a.HYKNO,a.HYKNO_FQ,b.MDDM,a.JF_CZZ,a.ORDER_NO from HYK_XFJL a,MDDY b where a.XFJLID = 3372288  and a.MDID = b.MDID
 end 

 begin SQL,2025-12-11 11:46:39.136
 select a.CXID,a.YHQID,a.CJGZID,a.SYXFJE,c.CXZT,a.CJCS from HYK_XFJL_CJ a,YHQDEF b,CXHDDEF c where a.YHQID=b.YHQID and a.CXID=c.CXID and a.XFJLID = 3372288 and b.BJ_DZYHQ = 0  and a.BJ_KCJ = 1 
 end 

 begin SQL,2025-12-11 11:46:39.152
 select a.CXID,a.YHQID,a.YHQFFGZID,a.XFLJFQFS,a.ZXFJE,a.SYXFJE,a.FQJE,a.BMDM,a.JSRQ,b.BJ_DZYHQ,b.BJ_TS from HYK_XFJL_FQ a, YHQDEF b where a.YHQID = b.YHQID   and a.XFJLID = 3372288  and a.DJLX = 0   and ((b.BJ_TS = 0 and b.BJ_DZYHQ = 0) or (b.BJ_TS in (1,2))) 
 end 

 begin SQL,2025-12-11 11:46:39.152
 select a.CXID,a.YHQID,a.YHQFFGZID,a.XFLJFQFS,a.BMDM,a.LPDM from HYK_XFJL_ZSLP a where a.XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:39.152
 select a.CXID,a.YHQID,a.YHQFFGZID,a.SHZFFSID,a.BANK_ZFINX,a.BANK_ID,a.BANK_KH,a.JSRQ,a.FQJE,b.BJ_DZYHQ,b.BJ_TS from HYK_XFJL_ZFFS_FQ a, YHQDEF b where a.YHQID = b.YHQID   and a.XFJLID = 3372288  and a.FQJE > 0   and b.BJ_DZYHQ = 0 
 end 

 begin SQL,2025-12-11 11:46:39.152
 select a.CXID,a.YHQID,a.YHQFFGZID,a.SHZFFSID,a.BANK_ZFINX,a.LPDM from HYK_XFJL_ZFFS_ZSLP a where a.XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:39.152
 select a.YHQCODE,b.BMQID from HYK_XFJL_ZKQDM a,YHQCODE b where a.YHQCODE = b.YHQCODE and a.XFJLID = 3372288
 end 

 begin SQL,2025-12-11 11:46:39.152
 update HYK_XFJL set STATUS = 1 where XFJLID = 3372288   and STATUS = 2
 end 

 begin SQL,2025-12-11 11:46:39.167
 update HYK_XFJL_SP set XSJE = XSJE - (select MBJZJE from HYK_XFJL_SP_MBJZ where HYK_XFJL_SP.XFJLID = HYK_XFJL_SP_MBJZ.XFJLID and HYK_XFJL_SP.INX = HYK_XFJL_SP_MBJZ.INX)  where exists(select * from HYK_XFJL_SP_MBJZ where HYK_XFJL_SP.XFJLID = HYK_XFJL_SP_MBJZ.XFJLID and HYK_XFJL_SP.INX = HYK_XFJL_SP_MBJZ.INX and HYK_XFJL_SP.XFJLID = 3372288)
 end 

 begin SQL,2025-12-11 11:46:39.167
 update YHQCODE a set MDID_YQ = 1,YQSJ=:YQSJ,STATUS = -1 where exists(select * from HYK_XFJL_ZKQDM b where a.YHQCODE = b.YHQCODE  and b.XFJLID = 3372288) and STATUS = 1
 end 

 begin SQL,2025-12-11 11:48:21.072
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 11:48:21.072
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 11:53:21.106
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 11:53:21.106
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 11:58:21.135
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 11:58:21.135
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 11:59:50.110
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 11:59:50.110
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 11:59:50.110
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 11:59:50.110
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 11:59:50.110
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 11:59:50.110
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 11:59:50.110
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 11:59:50.110
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 12:00:04.283
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 12:00:04.283
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 12:00:04.283
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 12:00:04.283
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 12:00:04.299
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100066
 end 

 begin SQL,2025-12-11 12:00:04.299
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100066
 end 

 begin SQL,2025-12-11 12:00:04.299
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0008009'
 end 

 begin SQL,2025-12-11 12:00:04.299
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 67
 end 

 begin SQL,2025-12-11 12:00:04.299
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 345661
 end 

 begin SQL,2025-12-11 12:00:04.299
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 345661 and b.MDID = 1
 end 

 begin SQL,2025-12-11 12:00:04.299
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 12:00:04.299
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 12:00:04.362
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-11 12:00:04.362
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-11 12:00:04.362
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372289,'BG',1,'010010',100066,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,2.00,0.00,0.00,0,0,'','',0,0,1.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-11 12:00:04.362
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372289,0,-1,345661,'0008009','011201021009',1,0,1.0000,1.0000,2.00,0.00,0.00,0,0,0,0,0,0,1.0000,2.00,2.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,67,0)
 end 

 begin SQL,2025-12-11 12:00:08.685
 select a.STATUS,a.SHDM,a.MDID,a.SKTNO,a.JLBH,a.DJLX,a.HYID,a.HYID_FQ,a.HYID_TQ,a.XFJLID_OLD,a.JZRQ,a.SCSJ,a.XFRQ_FQ,a.SKYDM,a.JE,a.ZK_HY,a.JF,a.JFBS,a.BSFS,a.HYKNO,a.HYKNO_FQ,b.MDDM,a.VIPTYPE,a.JF_CZZ,a.ORDER_NO from HYK_XFJL a,MDDY b where a.XFJLID = 3372289  and a.MDID = b.MDID
 end 

 begin SQL,2025-12-11 12:00:08.685
 select SHZFFSID,ZFFSMC,BJ_JF,BJ_FQ,BJ_MBJZ,YHQID from SHZFFS where SHDM = 'BG' and ZFFSDM = '1'
 end 

 begin SQL,2025-12-11 12:00:08.685
 select count(*) from HYK_XFJL_ZKQDM a,YHQCODE b  where a.YHQCODE = b.YHQCODE   and a.XFJLID = 3372289 and b.STATUS <> 1 
 end 

 begin SQL,2025-12-11 12:00:08.685
 select INX,SHSPID,SPDM,BMDM,XSSL,XSJE,BJ_JF,BJ_BCJHD,JFJS,BJ_JFBS,BS,JFFBGZ,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ  from HYK_XFJL_SP where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.685
 select INX,MBJZJE from HYK_XFJL_SP_MBJZ where MBJZJE > 0 and XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.685
 select INX,YHQID,CXID,XFLJFQFS,YHQFFGZID from HYK_XFJL_SP_FQ where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.685
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 2    and :SJ1  between RQ1 and RQ2   and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 12:00:08.685
 update HYK_XFJL set STATUS = 2,CZJE = 0.00,JF = 0.0000,JF_CZZ = 0.0000 where XFJLID = 3372289   and STATUS in (0,2) 
 end 

 begin SQL,2025-12-11 12:00:08.685
 delete from HYK_XFJL_ZFFS where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.685
 insert into HYK_XFJL_ZFFS(XFJLID,INX,ZFFSID,ZFFSDM,BJ_JF,BJ_FQ,YHQID,JE,BJ_TQ ) values(3372289,0,1,'1',1,1,null,2.00,0)
 end 

 begin SQL,2025-12-11 12:00:08.701
 delete from HYK_XFJL_YHKZF where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.701
 delete from HYK_XFJL_SP_ZFFS where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.701
 delete from HYK_XFJL_SP_YQFT where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.704
 delete from HYK_XFJL_SP_ZFFS_FQ where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.704
 delete from HYK_XFJL_ZFFS_FQ where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.704
 delete from HYK_XFJL_ZSLP where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.704
 delete from HYK_XFJL_ZFFS_ZSLP where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.704
 delete from HYK_XFJL_FQ where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.710
 delete from HYK_XFJL_SP_ZFFS_YQHM where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.710
 delete from HYK_XFJL_SP_YQFT_BMQ where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.710
 delete from HYK_XFJL_FQ_MZGZ where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.710
 delete from HYK_XFJL_CJ where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.710
 insert into HYK_XFJL_SP_ZFFS(XFJLID,INX,SHZFFSID,BJ_JF,BJ_FQ,YHQID,JE) values(3372289,0,1,1,1,null,2.00)
 end 

 begin SQL,2025-12-11 12:00:08.715
 insert into HYK_XFJL_SP_YQFT(XFJLID, INX, YHQID, BMDM, SPDM, SHSPID, YHQSYDBH, CXID, YHQSYGZID, BJ_FQ, XSJE, XSJE_YQ, YQJE)  select a.XFJLID,a.INX,a.YHQID,b.BMDM,b.SPDM,b.SHSPID,null,null,null,0,b.XSJE,0,a.JE  from HYK_XFJL_SP_ZFFS a,HYK_XFJL_SP b,YHQDEF c  where a.XFJLID = 3372289  and a.XFJLID = b.XFJLID   and a.INX = b.INX   and a.YHQID = c.YHQID   and a.YHQID >= 0   and c.BJ_DZYHQ = 1 
 end 

 begin SQL,2025-12-11 12:00:08.717
 update HYK_XFJL_SP set  XSJE_FQ = 2.00 ,XSJE_JF = 2.00 ,JF = 0.0000 ,JF_CZZ = 0.0000 where XFJLID = 3372289   and INX = 0
 end 

 begin SQL,2025-12-11 12:00:08.717
 update HYK_XFJL_SP_FQ set FQJE = 0  ,XSJE_FQ = 2.00 where XFJLID = 3372289   and INX = 0
 end 

 begin SQL,2025-12-11 12:00:08.717
 delete from HYK_XFJFBS where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.717
 delete from HYK_XFCZZBS where XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.732
 select a.STATUS,a.SHDM,a.MDID,a.SKTNO,a.JLBH,a.DJLX,a.HYID,a.HYID_FQ,a.HYID_TQ,a.XFJLID_OLD,a.JZRQ,a.SCSJ,a.XFRQ_FQ,a.SKYDM,a.JE,a.ZK_HY,a.JF,a.JFBS,a.BSFS,a.HYKNO,a.HYKNO_FQ,b.MDDM,a.JF_CZZ,a.ORDER_NO from HYK_XFJL a,MDDY b where a.XFJLID = 3372289  and a.MDID = b.MDID
 end 

 begin SQL,2025-12-11 12:00:08.936
 select a.CXID,a.YHQID,a.CJGZID,a.SYXFJE,c.CXZT,a.CJCS from HYK_XFJL_CJ a,YHQDEF b,CXHDDEF c where a.YHQID=b.YHQID and a.CXID=c.CXID and a.XFJLID = 3372289 and b.BJ_DZYHQ = 0  and a.BJ_KCJ = 1 
 end 

 begin SQL,2025-12-11 12:00:08.952
 select a.CXID,a.YHQID,a.YHQFFGZID,a.XFLJFQFS,a.ZXFJE,a.SYXFJE,a.FQJE,a.BMDM,a.JSRQ,b.BJ_DZYHQ,b.BJ_TS from HYK_XFJL_FQ a, YHQDEF b where a.YHQID = b.YHQID   and a.XFJLID = 3372289  and a.DJLX = 0   and ((b.BJ_TS = 0 and b.BJ_DZYHQ = 0) or (b.BJ_TS in (1,2))) 
 end 

 begin SQL,2025-12-11 12:00:08.952
 select a.CXID,a.YHQID,a.YHQFFGZID,a.XFLJFQFS,a.BMDM,a.LPDM from HYK_XFJL_ZSLP a where a.XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.952
 select a.CXID,a.YHQID,a.YHQFFGZID,a.SHZFFSID,a.BANK_ZFINX,a.BANK_ID,a.BANK_KH,a.JSRQ,a.FQJE,b.BJ_DZYHQ,b.BJ_TS from HYK_XFJL_ZFFS_FQ a, YHQDEF b where a.YHQID = b.YHQID   and a.XFJLID = 3372289  and a.FQJE > 0   and b.BJ_DZYHQ = 0 
 end 

 begin SQL,2025-12-11 12:00:08.952
 select a.CXID,a.YHQID,a.YHQFFGZID,a.SHZFFSID,a.BANK_ZFINX,a.LPDM from HYK_XFJL_ZFFS_ZSLP a where a.XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.952
 select a.YHQCODE,b.BMQID from HYK_XFJL_ZKQDM a,YHQCODE b where a.YHQCODE = b.YHQCODE and a.XFJLID = 3372289
 end 

 begin SQL,2025-12-11 12:00:08.952
 update HYK_XFJL set STATUS = 1 where XFJLID = 3372289   and STATUS = 2
 end 

 begin SQL,2025-12-11 12:00:08.952
 update HYK_XFJL_SP set XSJE = XSJE - (select MBJZJE from HYK_XFJL_SP_MBJZ where HYK_XFJL_SP.XFJLID = HYK_XFJL_SP_MBJZ.XFJLID and HYK_XFJL_SP.INX = HYK_XFJL_SP_MBJZ.INX)  where exists(select * from HYK_XFJL_SP_MBJZ where HYK_XFJL_SP.XFJLID = HYK_XFJL_SP_MBJZ.XFJLID and HYK_XFJL_SP.INX = HYK_XFJL_SP_MBJZ.INX and HYK_XFJL_SP.XFJLID = 3372289)
 end 

 begin SQL,2025-12-11 12:00:08.952
 update YHQCODE a set MDID_YQ = 1,YQSJ=:YQSJ,STATUS = -1 where exists(select * from HYK_XFJL_ZKQDM b where a.YHQCODE = b.YHQCODE  and b.XFJLID = 3372289) and STATUS = 1
 end 

 begin SQL,2025-12-11 12:03:21.324
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:03:21.356
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:08:21.215
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:08:21.215
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:13:21.285
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:13:21.285
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:18:21.291
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:18:21.291
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:26:44.765
 select JLBH,CUR_VAL from BFCONFIG where JLBH in (0,520000102,520000103,520000112,520000113,520000115,520000120,520000121,520000123,520000128,520000129,520000140,520000141,520000143)
 end 

 begin SQL,2025-12-11 12:26:44.797
 select CONTENT from XTXX where ID = 150 
 end 

 begin SQL,2025-12-11 12:26:44.860
 select USER_DM,USER_PSW,HTTPOK,WSOK,WCFOK from CRMUSER
 end 

 begin SQL,2025-12-11 12:26:44.875
 select IPADDR from CRMCLIENT where WSOK = 1 
 end 

 begin SQL,2025-12-11 12:26:44.875
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:26:44.891
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:26:44.891
 select SHDM,MDID from MDDY where MDDM = 'BG01'
 end 

 begin SQL,2025-12-11 12:26:45.158
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 12:26:45.158
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 12:26:45.158
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 12:26:45.158
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 12:26:45.173
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 12:26:45.173
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 12:26:45.173
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 12:26:45.173
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 12:27:01.286
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 12:27:01.286
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 12:27:01.286
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 12:27:01.286
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 12:27:01.301
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100067
 end 

 begin SQL,2025-12-11 12:27:01.317
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100067
 end 

 begin SQL,2025-12-11 12:27:01.317
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0008009'
 end 

 begin SQL,2025-12-11 12:27:01.317
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 67
 end 

 begin SQL,2025-12-11 12:27:01.317
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 345661
 end 

 begin SQL,2025-12-11 12:27:01.317
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 345661 and b.MDID = 1
 end 

 begin SQL,2025-12-11 12:27:01.317
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 12:27:01.317
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 12:27:01.317
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-11 12:27:01.317
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-11 12:27:01.317
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372290,'BG',1,'010010',100067,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,2.00,0.00,0.00,0,0,'','',0,0,1.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-11 12:27:01.317
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372290,0,-1,345661,'0008009','011201021009',1,0,1.0000,1.0000,2.00,0.00,0.00,0,0,0,0,0,0,1.0000,2.00,2.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,67,0)
 end 

 begin SQL,2025-12-11 12:27:07.344
 select a.STATUS,a.SHDM,a.MDID,a.SKTNO,a.JLBH,a.DJLX,a.HYID,a.HYID_FQ,a.HYID_TQ,a.XFJLID_OLD,a.JZRQ,a.SCSJ,a.XFRQ_FQ,a.SKYDM,a.JE,a.ZK_HY,a.JF,a.JFBS,a.BSFS,a.HYKNO,a.HYKNO_FQ,b.MDDM,a.VIPTYPE,a.JF_CZZ,a.ORDER_NO from HYK_XFJL a,MDDY b where a.XFJLID = 3372290  and a.MDID = b.MDID
 end 

 begin SQL,2025-12-11 12:27:07.359
 select SHZFFSID,ZFFSMC,BJ_JF,BJ_FQ,BJ_MBJZ,YHQID from SHZFFS where SHDM = 'BG' and ZFFSDM = '1'
 end 

 begin SQL,2025-12-11 12:27:07.359
 select count(*) from HYK_XFJL_ZKQDM a,YHQCODE b  where a.YHQCODE = b.YHQCODE   and a.XFJLID = 3372290 and b.STATUS <> 1 
 end 

 begin SQL,2025-12-11 12:27:07.359
 select INX,SHSPID,SPDM,BMDM,XSSL,XSJE,BJ_JF,BJ_BCJHD,JFJS,BJ_JFBS,BS,JFFBGZ,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ  from HYK_XFJL_SP where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.359
 select INX,MBJZJE from HYK_XFJL_SP_MBJZ where MBJZJE > 0 and XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.359
 select INX,YHQID,CXID,XFLJFQFS,YHQFFGZID from HYK_XFJL_SP_FQ where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.359
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 2    and :SJ1  between RQ1 and RQ2   and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 12:27:07.359
 update HYK_XFJL set STATUS = 2,CZJE = 0.00,JF = 0.0000,JF_CZZ = 0.0000 where XFJLID = 3372290   and STATUS in (0,2) 
 end 

 begin SQL,2025-12-11 12:27:07.359
 delete from HYK_XFJL_ZFFS where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.359
 insert into HYK_XFJL_ZFFS(XFJLID,INX,ZFFSID,ZFFSDM,BJ_JF,BJ_FQ,YHQID,JE,BJ_TQ ) values(3372290,0,1,'1',1,1,null,2.00,0)
 end 

 begin SQL,2025-12-11 12:27:07.375
 delete from HYK_XFJL_YHKZF where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.376
 delete from HYK_XFJL_SP_ZFFS where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.377
 delete from HYK_XFJL_SP_YQFT where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.378
 delete from HYK_XFJL_SP_ZFFS_FQ where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.380
 delete from HYK_XFJL_ZFFS_FQ where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.381
 delete from HYK_XFJL_ZSLP where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.383
 delete from HYK_XFJL_ZFFS_ZSLP where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.384
 delete from HYK_XFJL_FQ where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.385
 delete from HYK_XFJL_SP_ZFFS_YQHM where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.386
 delete from HYK_XFJL_SP_YQFT_BMQ where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.386
 delete from HYK_XFJL_FQ_MZGZ where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.386
 delete from HYK_XFJL_CJ where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.386
 insert into HYK_XFJL_SP_ZFFS(XFJLID,INX,SHZFFSID,BJ_JF,BJ_FQ,YHQID,JE) values(3372290,0,1,1,1,null,2.00)
 end 

 begin SQL,2025-12-11 12:27:07.391
 insert into HYK_XFJL_SP_YQFT(XFJLID, INX, YHQID, BMDM, SPDM, SHSPID, YHQSYDBH, CXID, YHQSYGZID, BJ_FQ, XSJE, XSJE_YQ, YQJE)  select a.XFJLID,a.INX,a.YHQID,b.BMDM,b.SPDM,b.SHSPID,null,null,null,0,b.XSJE,0,a.JE  from HYK_XFJL_SP_ZFFS a,HYK_XFJL_SP b,YHQDEF c  where a.XFJLID = 3372290  and a.XFJLID = b.XFJLID   and a.INX = b.INX   and a.YHQID = c.YHQID   and a.YHQID >= 0   and c.BJ_DZYHQ = 1 
 end 

 begin SQL,2025-12-11 12:27:07.391
 update HYK_XFJL_SP set  XSJE_FQ = 2.00 ,XSJE_JF = 2.00 ,JF = 0.0000 ,JF_CZZ = 0.0000 where XFJLID = 3372290   and INX = 0
 end 

 begin SQL,2025-12-11 12:27:07.391
 update HYK_XFJL_SP_FQ set FQJE = 0  ,XSJE_FQ = 2.00 where XFJLID = 3372290   and INX = 0
 end 

 begin SQL,2025-12-11 12:27:07.391
 delete from HYK_XFJFBS where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.391
 delete from HYK_XFCZZBS where XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.422
 select a.STATUS,a.SHDM,a.MDID,a.SKTNO,a.JLBH,a.DJLX,a.HYID,a.HYID_FQ,a.HYID_TQ,a.XFJLID_OLD,a.JZRQ,a.SCSJ,a.XFRQ_FQ,a.SKYDM,a.JE,a.ZK_HY,a.JF,a.JFBS,a.BSFS,a.HYKNO,a.HYKNO_FQ,b.MDDM,a.JF_CZZ,a.ORDER_NO from HYK_XFJL a,MDDY b where a.XFJLID = 3372290  and a.MDID = b.MDID
 end 

 begin SQL,2025-12-11 12:27:07.438
 select a.CXID,a.YHQID,a.CJGZID,a.SYXFJE,c.CXZT,a.CJCS from HYK_XFJL_CJ a,YHQDEF b,CXHDDEF c where a.YHQID=b.YHQID and a.CXID=c.CXID and a.XFJLID = 3372290 and b.BJ_DZYHQ = 0  and a.BJ_KCJ = 1 
 end 

 begin SQL,2025-12-11 12:27:07.438
 select a.CXID,a.YHQID,a.YHQFFGZID,a.XFLJFQFS,a.ZXFJE,a.SYXFJE,a.FQJE,a.BMDM,a.JSRQ,b.BJ_DZYHQ,b.BJ_TS from HYK_XFJL_FQ a, YHQDEF b where a.YHQID = b.YHQID   and a.XFJLID = 3372290  and a.DJLX = 0   and ((b.BJ_TS = 0 and b.BJ_DZYHQ = 0) or (b.BJ_TS in (1,2))) 
 end 

 begin SQL,2025-12-11 12:27:07.438
 select a.CXID,a.YHQID,a.YHQFFGZID,a.XFLJFQFS,a.BMDM,a.LPDM from HYK_XFJL_ZSLP a where a.XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.455
 select a.CXID,a.YHQID,a.YHQFFGZID,a.SHZFFSID,a.BANK_ZFINX,a.BANK_ID,a.BANK_KH,a.JSRQ,a.FQJE,b.BJ_DZYHQ,b.BJ_TS from HYK_XFJL_ZFFS_FQ a, YHQDEF b where a.YHQID = b.YHQID   and a.XFJLID = 3372290  and a.FQJE > 0   and b.BJ_DZYHQ = 0 
 end 

 begin SQL,2025-12-11 12:27:07.455
 select a.CXID,a.YHQID,a.YHQFFGZID,a.SHZFFSID,a.BANK_ZFINX,a.LPDM from HYK_XFJL_ZFFS_ZSLP a where a.XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.455
 select a.YHQCODE,b.BMQID from HYK_XFJL_ZKQDM a,YHQCODE b where a.YHQCODE = b.YHQCODE and a.XFJLID = 3372290
 end 

 begin SQL,2025-12-11 12:27:07.658
 update HYK_XFJL set STATUS = 1 where XFJLID = 3372290   and STATUS = 2
 end 

 begin SQL,2025-12-11 12:27:07.689
 update HYK_XFJL_SP set XSJE = XSJE - (select MBJZJE from HYK_XFJL_SP_MBJZ where HYK_XFJL_SP.XFJLID = HYK_XFJL_SP_MBJZ.XFJLID and HYK_XFJL_SP.INX = HYK_XFJL_SP_MBJZ.INX)  where exists(select * from HYK_XFJL_SP_MBJZ where HYK_XFJL_SP.XFJLID = HYK_XFJL_SP_MBJZ.XFJLID and HYK_XFJL_SP.INX = HYK_XFJL_SP_MBJZ.INX and HYK_XFJL_SP.XFJLID = 3372290)
 end 

 begin SQL,2025-12-11 12:27:07.689
 update YHQCODE a set MDID_YQ = 1,YQSJ=:YQSJ,STATUS = -1 where exists(select * from HYK_XFJL_ZKQDM b where a.YHQCODE = b.YHQCODE  and b.XFJLID = 3372290) and STATUS = 1
 end 

 begin SQL,2025-12-11 12:31:45.006
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:31:45.006
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:36:44.957
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:36:44.957
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:41:44.985
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:41:44.985
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:46:45.165
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 12:46:45.165
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 16:33:25.931
 select JLBH,CUR_VAL from BFCONFIG where JLBH in (0,520000102,520000103,520000112,520000113,520000115,520000120,520000121,520000123,520000128,520000129,520000140,520000141,520000143)
 end 

 begin SQL,2025-12-11 16:33:25.946
 select CONTENT from XTXX where ID = 150 
 end 

 begin SQL,2025-12-11 16:33:26.010
 select USER_DM,USER_PSW,HTTPOK,WSOK,WCFOK from CRMUSER
 end 

 begin SQL,2025-12-11 16:33:26.025
 select IPADDR from CRMCLIENT where WSOK = 1 
 end 

 begin SQL,2025-12-11 16:33:26.025
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 16:33:26.025
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 16:33:26.057
 select SHDM,MDID from MDDY where MDDM = 'BG01'
 end 

 begin SQL,2025-12-11 16:33:26.293
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 16:33:26.293
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 16:33:26.309
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 16:33:26.309
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 16:33:26.324
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 16:33:26.324
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 16:33:26.324
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 16:33:26.324
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 16:34:27.437
 select a.YHQID,a.YHQMZ,a.BEGINDATE,a.ENDDATE,a.STATUS,b.BMQSYGZID,a.BMQID,a.CXID,a.HYID,b.BMQMC,b.BJ_JEZH,b.TYPE,b.LPID  from YHQCODE a,BMQDEF b  where a.BMQID = b.BMQID  and a.YHQCODE = :YHQCODE
 end 

 begin SQL,2025-12-11 16:34:27.437
 select BJ_SP,LPDM from HYK_JFFHLPXX where LPID = 7751
 end 

 begin SQL,2025-12-11 16:34:27.437
 select a.HYID,a.HYKTYPE,a.HYK_NO,a.FXDW  from HYK_HYXX a where a.HYID = 6662
 end 

 begin SQL,2025-12-11 16:34:27.437
 select CSRQ,ZYID,ZJLXID,SEX,BJ_CLD,SFZBH,SQID,XZ from HYK_GRXX where HYID = 6662
 end 

 begin SQL,2025-12-11 16:34:27.453
 select FXDWDM from FXDWDEF where FXDWID = :FXDWID
 end 

 begin SQL,2025-12-11 16:34:27.485
 select LABELID from HYK_HYBQ where HYID = :HYID
 end 

 begin SQL,2025-12-11 16:34:27.485
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.BJ_FQ,a.DBYQSX,a.QDZKL from BMQYQDYD a  where a.SHDM = 'BG' and exists(select 1 from BMQYQDYD_BMQ where a.JLBH = JLBH and BMQID = 21)   and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1)) and a.STATUS = 2 order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 16:34:27.532
 select RQ1,RQ2 from BMQYQDYD where JLBH = 82
 end 

 begin SQL,2025-12-11 16:34:27.532
 select INX,SD from BMQYQDYD_FD where JLBH = 82 order by INX
 end 

 begin SQL,2025-12-11 16:34:27.532
 select GZBH,YQGZID,BJ_CJ,CLFS_BM,CLFS_SPFL,CLFS_SPSB,CLFS_HT,CLFS_SP,CLFS_SP2,CLFS_SEASON,CLFS_AGE,CLFS_STATION,CLFS_GENDER,CLFS_SPZ from BMQYQDYD_GZSD where JLBH = 82 and INX=:INX order by GZBH
 end 

 begin SQL,2025-12-11 16:34:27.532
 select b.BMDM from BMQYQDYD_GZITEM a, SHBM b where a.SJLX = 1 and a.SJNR = b.SHBMID and a.SJNR > 0 and a.JLBH = 82  and a.INX = 1  and a.GZBH = 1 order by b.BMDM
 end 

 begin SQL,2025-12-11 16:34:29.263
 select JYZT from HYK_JYCL where JYLX = 1   and MDID = 1  and SKTNO = '010010'  and ORDER_NO = :ORDER_NO  and BJ_YHQ = 3  and JYZT in (1,2)
 end 

 begin SQL,2025-12-11 16:34:29.278
 select a.PERSON_ID,b.PERSON_NAME,a.CZDD,b.RYDM from DEF_QTKGLY a,RYXX b where a.PERSON_ID = b.PERSON_ID and a.MDID = 1
 end 

 begin SQL,2025-12-11 16:34:29.278
 select a.YHQID,a.YHQMZ,a.BEGINDATE,a.ENDDATE,a.CXID,a.STATUS,a.BMQID,b.TYPE,b.LPID,a.HYID from YHQCODE a,BMQDEF b where a.BMQID = b.BMQID and a.YHQCODE = '90000153458135'
 end 

 begin SQL,2025-12-11 16:34:29.278
 select LPMC,BJ_WKC from HYK_JFFHLPXX where LPID = 7751
 end 

 begin SQL,2025-12-11 16:34:29.278
 select a.HYID,a.HYKTYPE,a.HYK_NO,a.FXDW  from HYK_HYXX a where a.HYID = 6662
 end 

 begin SQL,2025-12-11 16:34:29.278
 select CSRQ,ZYID,ZJLXID,SEX,BJ_CLD,SFZBH,SQID,XZ from HYK_GRXX where HYID = 6662
 end 

 begin SQL,2025-12-11 16:34:29.278
 select FXDWDM from FXDWDEF where FXDWID = :FXDWID
 end 

 begin SQL,2025-12-11 16:34:29.278
 select LABELID from HYK_HYBQ where HYID = :HYID
 end 

 begin SQL,2025-12-11 16:34:29.278
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.BJ_FQ,a.DBYQSX,a.QDZKL from BMQYQDYD a  where a.SHDM = 'BG' and exists(select 1 from BMQYQDYD_BMQ where a.JLBH = JLBH and BMQID = 21)   and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1)) and a.STATUS = 2 order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 16:34:29.294
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_JYCL'
 end 

 begin SQL,2025-12-11 16:34:29.294
 select REC_NUM from BHZT where TBLNAME = 'HYK_JYCL'
 end 

 begin SQL,2025-12-11 16:34:29.294
 insert into HYK_JYCL(JYID,JYLX,XFJLID,MDID,SKTNO,JLBH,SKYDM,BJ_YHQ,JYZT,JZRQ,ZBSJ,JYJE,BMDM,ORDER_NO) values(81345,1,0,1,'010010',81345,'999999',3,1,:JZRQ,:ZBSJ,0.00,:BMDM,:ORDER_NO)
 end 

 begin SQL,2025-12-11 16:34:29.310
 insert into HYK_JYCL_ZBZT(JYID,ZBSJ) values(81345,:ZBSJ)
 end 

 begin SQL,2025-12-11 16:34:29.310
 update YHQCODE set STATUS = 2,MDID_YQ = 1,YQSJ=:YQSJ where YHQCODE = '90000153458135'   and STATUS = 1 
 end 

 begin SQL,2025-12-11 16:34:29.310
 insert into HYK_JYCLITEM_YHQDM(JYID,YHQCODE,YHQID,YHQMZ,CXID,YQJE,BMQID,JSRQ) values(81345,:YHQCODE,1,20.00,0,0.00,21,:JSRQ)
 end 

 begin SQL,2025-12-11 16:34:29.563
 select XFJLID,JYLX,BJ_YHQ,JYJE,JYZT,MDID,SKTNO,JLBH,SKYDM,JZRQ from HYK_JYCL where JYID = 81345
 end 

 begin SQL,2025-12-11 16:34:29.563
 select a.YHQCODE,a.YHQID,a.YHQMZ,a.CXID,a.YQJE,a.BMQID,a.JSRQ,a.BJ_JEZH,c.TYPE,c.LPID from HYK_JYCLITEM_YHQDM a,BMQDEF c where a.BMQID = c.BMQID and a.JYID = 81345
 end 

 begin SQL,2025-12-11 16:34:29.563
 select a.PERSON_ID,b.PERSON_NAME,a.CZDD,b.RYDM from DEF_QTKGLY a,RYXX b where a.PERSON_ID = b.PERSON_ID and a.MDID = 1
 end 

 begin SQL,2025-12-11 16:34:29.563
 select LPMC,BJ_WKC,LPDJ,LPJJ,BJ_SP from HYK_JFFHLPXX where LPID = 7751
 end 

 begin SQL,2025-12-11 16:34:29.563
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_JFFLJL'
 end 

 begin SQL,2025-12-11 16:34:29.578
 select REC_NUM from BHZT where TBLNAME = 'HYK_JFFLJL'
 end 

 begin SQL,2025-12-11 16:34:29.578
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_LPKCBDJL'
 end 

 begin SQL,2025-12-11 16:34:29.578
 select REC_NUM from BHZT where TBLNAME = 'HYK_LPKCBDJL'
 end 

 begin SQL,2025-12-11 16:34:29.578
 update HYK_JYCL set JYZT = 2 ,TJSJ=:TJSJ where JYID = 81345   and JYZT = 1
 end 

 begin SQL,2025-12-11 16:34:29.578
 delete from HYK_JYCL_ZBZT where JYID = 81345
 end 

 begin SQL,2025-12-11 16:34:29.594
 update YHQCODE set STATUS = -1,SJYQJE =  0.00,YQSJ=:YQSJ where YHQCODE = :YHQCODE   and STATUS = 2 
 end 

 begin SQL,2025-12-11 16:34:29.594
 insert into YHQCODE_CLJL(CLLX,CLSJ,MDID,SKTNO,JLBH,SKYDM,YHQCODE,JFJE,DFJE,ZY,BMQID,YHQMZ,JZRQ,JYID,LMSHID,YE,BJ_JEZH) values(1,:CLSJ,1,'010010',81345,:SKYDM,:YHQCODE,0,0.00,:ZY,21,20.00,:JZRQ,81345,0,0.00,0)
 end 

 begin SQL,2025-12-11 16:34:29.612
 insert into HYK_JFFLJL_LP(JLBH,BGDDDM,LPID,SL,LPDJ,LPJJ,KCSL,LPJF,LPJE,BJ_WKC) values(149982,:BGDDDM,7751,1,0.00,0.00,0,0,0,1)
 end 

 begin SQL,2025-12-11 16:34:29.612
 insert into HYK_LPKCBDJL(JYBH,LPID,BGDDDM,JLBH,CLSJ,CLLX,BDSL,KCSL,CZYDM,CZYMC,ZY) values(56,7751,:BGDDDM,149982,:CLSJ,16,-1,0,:CZYDM,:CZYMC,:ZY)
 end 

 begin SQL,2025-12-11 16:37:04.431
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 16:37:04.431
 select USER_PSW from CRMUSER where USER_DM = 'BFCRM'
 end 

 begin SQL,2025-12-11 16:37:04.431
 select count(*) from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX in (0,2)    and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 16:37:04.431
 select count(*) from CXMBJZDYD a  where a.SHDM = 'BG'   and :SJ  between RQ1 and RQ2   and a.STATUS = 2 
 end 

 begin SQL,2025-12-11 16:37:04.462
 select XFJLID,STATUS,XFJLID_OLD from HYK_XFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100069
 end 

 begin SQL,2025-12-11 16:37:04.462
 select XFJLID from HYXFJL where MDID = 1  and SKTNO = '010010'  and JLBH = 100069
 end 

 begin SQL,2025-12-11 16:37:04.462
 select SHSPID from SHSPXX_DM where SHDM = 'BG' and SPDM = '0008009'
 end 

 begin SQL,2025-12-11 16:37:04.462
 select SHSHOPID,SHOPDM from SHWY_SHOPDEF where SHDM = 'BG' and SHOPID = 67
 end 

 begin SQL,2025-12-11 16:37:04.462
 select c.SPFLDM,b.SHSBID,b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM,b.SX_JJ,b.SX_NLD,b.SX_LW,b.SX_SEX  from SHSPXX b,SHSPFL c where b.SHSPFLID = c.SHSPFLID and b.SHSPID = 345661
 end 

 begin SQL,2025-12-11 16:37:04.462
 select b.SHHTID  ,(select GHSDM from SHHT d where b.SHHTID = d.SHHTID) as GHSDM  from SHSPXX_HT b where b.SHSPID = 345661 and b.MDID = 1
 end 

 begin SQL,2025-12-11 16:37:04.462
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 0    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 16:37:04.462
 select a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJMJFS,a.MJJQ,b.CXHDBH from CXMBJZDYD a,CXHDDEF b  where a.SHDM = 'BG' and a.CXID = b.CXID    and :SJ1  between RQ1 and RQ2   and ((a.SHBMDM = ' ') or (instr('011201021009',rtrim(a.SHBMDM)) = 1))  and a.STATUS = 2  order by a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 16:37:04.462
 update BHZT set REC_NUM = REC_NUM+1 where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-11 16:37:04.462
 select REC_NUM from BHZT where TBLNAME = 'HYK_XFJL'
 end 

 begin SQL,2025-12-11 16:37:04.478
 insert into HYK_XFJL(XFJLID, SHDM, MDID, SKTNO, JLBH, DJLX,XFJLID_OLD, HYID,HYID_FQ, SKYDM, JZRQ,XFSJ,XFRQ_FQ,SCSJ,STATUS,BJ_WZSP,JFBS,JF,JE,ZK,ZK_HY,PGRYID,VIPTYPE,HYKNO,HYKNO_FQ,FXDW,BSFS,XSSL,TDJFDYDBH,JF_CZZ,ORDER_NO,BJ_HTBSK) values(3372291,'BG',1,'010010',100069,0,0,0,0,'999999',:JZRQ,:XFSJ,:XFRQ_FQ,:SCSJ,0,0,0.00,0.0000,2.00,0.00,0.00,0,0,'','',0,0,1.0000,0,0.0000,:ORDER_NO,0)
 end 

 begin SQL,2025-12-11 16:37:04.478
 insert into HYK_XFJL_SP(XFJLID,INX,INX_OLD,SHSPID,SPDM,BMDM,BJ_JF,ZKDYDBH,ZKL,XSSL,XSJE,ZKJE,ZKJE_HY,BJ_BCJHD,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH,JFJS,BJ_JFBS,BS,XSJE_JF,XSJE_FQ,JF,FTBL,JFFBGZ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ,SHOP_ID,SHSHOPID) values(3372291,0,-1,345661,'0008009','011201021009',1,0,1.0000,1.0000,2.00,0.00,0.00,0,0,0,0,0,0,1.0000,2.00,2.00,0.0000,0.0000,0,0,0,0,1.0000,0.0000,0,67,0)
 end 

 begin SQL,2025-12-11 16:37:08.405
 select a.STATUS,a.SHDM,a.MDID,a.SKTNO,a.JLBH,a.DJLX,a.HYID,a.HYID_FQ,a.HYID_TQ,a.XFJLID_OLD,a.JZRQ,a.SCSJ,a.XFRQ_FQ,a.SKYDM,a.JE,a.ZK_HY,a.JF,a.JFBS,a.BSFS,a.HYKNO,a.HYKNO_FQ,b.MDDM,a.VIPTYPE,a.JF_CZZ,a.ORDER_NO from HYK_XFJL a,MDDY b where a.XFJLID = 3372291  and a.MDID = b.MDID
 end 

 begin SQL,2025-12-11 16:37:08.405
 select SHZFFSID,ZFFSMC,BJ_JF,BJ_FQ,BJ_MBJZ,YHQID from SHZFFS where SHDM = 'BG' and ZFFSDM = '1'
 end 

 begin SQL,2025-12-11 16:37:08.405
 select count(*) from HYK_XFJL_ZKQDM a,YHQCODE b  where a.YHQCODE = b.YHQCODE   and a.XFJLID = 3372291 and b.STATUS <> 1 
 end 

 begin SQL,2025-12-11 16:37:08.405
 select INX,SHSPID,SPDM,BMDM,XSSL,XSJE,BJ_JF,BJ_BCJHD,JFJS,BJ_JFBS,BS,JFFBGZ,BJ_BCJMJ,BJ_BCJYQ,JFDYDBH_CZZ,JFJS_CZZ,BJ_JFBS_CZZ,BS_CZZ,JF_CZZ,JFFBGZ_CZZ  from HYK_XFJL_SP where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.405
 select INX,MBJZJE from HYK_XFJL_SP_MBJZ where MBJZJE > 0 and XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.405
 select INX,YHQID,CXID,XFLJFQFS,YHQFFGZID from HYK_XFJL_SP_FQ where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.421
 select a.YHQID,a.SHBMDM,a.JLBH,a.YXCLBJ,a.RQ1,a.RQ2,a.CXID,a.XFLJFQFS,a.QDZKL from HYKFQDYD a  where a.SHDM = 'BG'  and ((a.BJ_HTFQ is null) or (a.BJ_HTFQ = 0))   and a.DJLX = 2    and :SJ1  between RQ1 and RQ2   and a.STATUS = 2  order by a.YHQID,a.SHBMDM desc,a.YXCLBJ desc,a.JLBH desc
 end 

 begin SQL,2025-12-11 16:37:08.422
 update HYK_XFJL set STATUS = 2,CZJE = 0.00,JF = 0.0000,JF_CZZ = 0.0000 where XFJLID = 3372291   and STATUS in (0,2) 
 end 

 begin SQL,2025-12-11 16:37:08.422
 delete from HYK_XFJL_ZFFS where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.422
 insert into HYK_XFJL_ZFFS(XFJLID,INX,ZFFSID,ZFFSDM,BJ_JF,BJ_FQ,YHQID,JE,BJ_TQ ) values(3372291,0,1,'1',1,1,null,2.00,0)
 end 

 begin SQL,2025-12-11 16:37:08.422
 delete from HYK_XFJL_YHKZF where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.422
 delete from HYK_XFJL_SP_ZFFS where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.422
 delete from HYK_XFJL_SP_YQFT where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.422
 delete from HYK_XFJL_SP_ZFFS_FQ where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.422
 delete from HYK_XFJL_ZFFS_FQ where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.422
 delete from HYK_XFJL_ZSLP where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.422
 delete from HYK_XFJL_ZFFS_ZSLP where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.422
 delete from HYK_XFJL_FQ where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.422
 delete from HYK_XFJL_SP_ZFFS_YQHM where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.422
 delete from HYK_XFJL_SP_YQFT_BMQ where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.437
 delete from HYK_XFJL_FQ_MZGZ where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.437
 delete from HYK_XFJL_CJ where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.437
 insert into HYK_XFJL_SP_ZFFS(XFJLID,INX,SHZFFSID,BJ_JF,BJ_FQ,YHQID,JE) values(3372291,0,1,1,1,null,2.00)
 end 

 begin SQL,2025-12-11 16:37:08.437
 insert into HYK_XFJL_SP_YQFT(XFJLID, INX, YHQID, BMDM, SPDM, SHSPID, YHQSYDBH, CXID, YHQSYGZID, BJ_FQ, XSJE, XSJE_YQ, YQJE)  select a.XFJLID,a.INX,a.YHQID,b.BMDM,b.SPDM,b.SHSPID,null,null,null,0,b.XSJE,0,a.JE  from HYK_XFJL_SP_ZFFS a,HYK_XFJL_SP b,YHQDEF c  where a.XFJLID = 3372291  and a.XFJLID = b.XFJLID   and a.INX = b.INX   and a.YHQID = c.YHQID   and a.YHQID >= 0   and c.BJ_DZYHQ = 1 
 end 

 begin SQL,2025-12-11 16:37:08.437
 update HYK_XFJL_SP set  XSJE_FQ = 2.00 ,XSJE_JF = 2.00 ,JF = 0.0000 ,JF_CZZ = 0.0000 where XFJLID = 3372291   and INX = 0
 end 

 begin SQL,2025-12-11 16:37:08.437
 update HYK_XFJL_SP_FQ set FQJE = 0  ,XSJE_FQ = 2.00 where XFJLID = 3372291   and INX = 0
 end 

 begin SQL,2025-12-11 16:37:08.437
 delete from HYK_XFJFBS where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.437
 delete from HYK_XFCZZBS where XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.531
 select a.STATUS,a.SHDM,a.MDID,a.SKTNO,a.JLBH,a.DJLX,a.HYID,a.HYID_FQ,a.HYID_TQ,a.XFJLID_OLD,a.JZRQ,a.SCSJ,a.XFRQ_FQ,a.SKYDM,a.JE,a.ZK_HY,a.JF,a.JFBS,a.BSFS,a.HYKNO,a.HYKNO_FQ,b.MDDM,a.JF_CZZ,a.ORDER_NO from HYK_XFJL a,MDDY b where a.XFJLID = 3372291  and a.MDID = b.MDID
 end 

 begin SQL,2025-12-11 16:37:08.531
 select a.CXID,a.YHQID,a.CJGZID,a.SYXFJE,c.CXZT,a.CJCS from HYK_XFJL_CJ a,YHQDEF b,CXHDDEF c where a.YHQID=b.YHQID and a.CXID=c.CXID and a.XFJLID = 3372291 and b.BJ_DZYHQ = 0  and a.BJ_KCJ = 1 
 end 

 begin SQL,2025-12-11 16:37:08.531
 select a.CXID,a.YHQID,a.YHQFFGZID,a.XFLJFQFS,a.ZXFJE,a.SYXFJE,a.FQJE,a.BMDM,a.JSRQ,b.BJ_DZYHQ,b.BJ_TS from HYK_XFJL_FQ a, YHQDEF b where a.YHQID = b.YHQID   and a.XFJLID = 3372291  and a.DJLX = 0   and ((b.BJ_TS = 0 and b.BJ_DZYHQ = 0) or (b.BJ_TS in (1,2))) 
 end 

 begin SQL,2025-12-11 16:37:08.547
 select a.CXID,a.YHQID,a.YHQFFGZID,a.XFLJFQFS,a.BMDM,a.LPDM from HYK_XFJL_ZSLP a where a.XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.547
 select a.CXID,a.YHQID,a.YHQFFGZID,a.SHZFFSID,a.BANK_ZFINX,a.BANK_ID,a.BANK_KH,a.JSRQ,a.FQJE,b.BJ_DZYHQ,b.BJ_TS from HYK_XFJL_ZFFS_FQ a, YHQDEF b where a.YHQID = b.YHQID   and a.XFJLID = 3372291  and a.FQJE > 0   and b.BJ_DZYHQ = 0 
 end 

 begin SQL,2025-12-11 16:37:08.547
 select a.CXID,a.YHQID,a.YHQFFGZID,a.SHZFFSID,a.BANK_ZFINX,a.LPDM from HYK_XFJL_ZFFS_ZSLP a where a.XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.547
 select a.YHQCODE,b.BMQID from HYK_XFJL_ZKQDM a,YHQCODE b where a.YHQCODE = b.YHQCODE and a.XFJLID = 3372291
 end 

 begin SQL,2025-12-11 16:37:08.547
 update HYK_XFJL set STATUS = 1 where XFJLID = 3372291   and STATUS = 2
 end 

 begin SQL,2025-12-11 16:37:08.547
 update HYK_XFJL_SP set XSJE = XSJE - (select MBJZJE from HYK_XFJL_SP_MBJZ where HYK_XFJL_SP.XFJLID = HYK_XFJL_SP_MBJZ.XFJLID and HYK_XFJL_SP.INX = HYK_XFJL_SP_MBJZ.INX)  where exists(select * from HYK_XFJL_SP_MBJZ where HYK_XFJL_SP.XFJLID = HYK_XFJL_SP_MBJZ.XFJLID and HYK_XFJL_SP.INX = HYK_XFJL_SP_MBJZ.INX and HYK_XFJL_SP.XFJLID = 3372291)
 end 

 begin SQL,2025-12-11 16:37:08.547
 update YHQCODE a set MDID_YQ = 1,YQSJ=:YQSJ,STATUS = -1 where exists(select * from HYK_XFJL_ZKQDM b where a.YHQCODE = b.YHQCODE  and b.XFJLID = 3372291) and STATUS = 1
 end 

 begin SQL,2025-12-11 16:38:26.233
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 16:38:26.233
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 16:43:26.103
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 16:43:26.103
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 16:48:26.136
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 16:48:26.136
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 16:53:26.176
 select JYID from MZK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end 

 begin SQL,2025-12-11 16:53:26.176
 select JYID from HYK_JYCL_ZBZT  where ZBSJ<:ZBSJ
 end