【Begin】 2025-06-08 15:30:27 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:30:27 192.168.109.222 请求信息： mn:TKT cn:PageCommon mn2:GetXmlBySimpleCondition 对应参数： data:{"Version":"Base_GetStockTypeData_C","TableName":"SYS_PARAM","SelectFields":"PARAMVALUE ","Condition":{"PARAMCODE":"0025"}} 【Debugger】 2025-06-08 15:30:27 192.168.109.222 SQL语句：select * from WEB_TKT_TABLEMAPPING SQL语句参数：无。 【Debugger】 2025-06-08 15:30:28 192.168.109.222 SQL语句：select PARAMVALUE from SYS_PARAM where PARAMCODE=:PARAMCODE SQL语句参数(共1个)： {"ParameterName:"PARAMCODE","Value":"0025","DbType":"String"} 【Info】 2025-06-08 15:30:28 192.168.109.222 返回结果TwiReturn对象，序列化后为： {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2025-06-08 15:30:28 192.168.109.222 TwiAjaxHelper.GetResult执行完成！ ================================================================= 【Begin】 2025-06-08 15:30:28 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:30:28 192.168.109.222 请求信息： mn:TKT cn:PageCommon mn2:GetXmlBySimpleCondition 对应参数： data:{"Version":"Base_GetIsRetBoatTicket_C","TableName":"SYS_PARAM","SelectFields":"PARAMVALUE,PARAMCODE","Condition":{"PARAMCODE":"5026"}} 【Debugger】 2025-06-08 15:30:28 192.168.109.222 SQL语句：select * from WEB_TKT_TABLEMAPPING SQL语句参数：无。 【Debugger】 2025-06-08 15:30:28 192.168.109.222 SQL语句：select PARAMVALUE,PARAMCODE from SYS_PARAM where PARAMCODE=:PARAMCODE SQL语句参数(共1个)： {"ParameterName:"PARAMCODE","Value":"5026","DbType":"String"} 【Info】 2025-06-08 15:30:28 192.168.109.222 返回结果TwiReturn对象，序列化后为： {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2025-06-08 15:30:28 192.168.109.222 TwiAjaxHelper.GetResult执行完成！ ================================================================= 【Begin】 2025-06-08 15:30:28 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:30:28 192.168.109.222 请求信息： mn:TKT cn:PageCommon mn2:GetXmlBySimpleCondition 对应参数： data:{"Version":"Base_GetIsRetBoatTicket_C","TableName":"SYS_PARAM","SelectFields":"PARAMVALUE,PARAMCODE","Condition":{"PARAMCODE":"5027"}} 【Debugger】 2025-06-08 15:30:28 192.168.109.222 SQL语句：select * from WEB_TKT_TABLEMAPPING SQL语句参数：无。 【Debugger】 2025-06-08 15:30:28 192.168.109.222 SQL语句：select PARAMVALUE,PARAMCODE from SYS_PARAM where PARAMCODE=:PARAMCODE SQL语句参数(共1个)： {"ParameterName:"PARAMCODE","Value":"5027","DbType":"String"} 【Info】 2025-06-08 15:30:28 192.168.109.222 返回结果TwiReturn对象，序列化后为： {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2025-06-08 15:30:28 192.168.109.222 TwiAjaxHelper.GetResult执行完成！ ================================================================= 【Begin】 2025-06-08 15:31:13 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:31:14 192.168.109.222 请求信息： mn:TKT cn:TicketReturn mn2:QueryTicketForReturn 对应参数： data:{"Condition":{"BEGINCODE":"ET25060813510500177694","ENDCODE":"ET25060813510500177694","TRADEID":"-1","OPTORID":"177FFEDC45E3490E9F149C711CECB3E1","OPTORCODE":"HSSP001"}} 【Debugger】 2025-06-08 15:31:14 192.168.109.222 SQL语句：select fid from web_sys_plug where plugcode = 'TKT0203' SQL语句参数：无。 【Debugger】 2025-06-08 15:31:14 192.168.109.222 SQL语句：select dataauthority,orgid from ( select ro.operatorid,ro.roleid,rp.plugid,rp.dataauthority ,case when rp.dataauthority = 1 then (select wm_concat(rpe.fdeptid) from web_sys_roleplugext rpe where rpe.roleplugid = rp.fid) else '0' end as orgid from web_sys_roleoperator ro left join web_sys_roleplug rp on rp.roleid = ro.roleid ) where operatorid = '177FFEDC45E3490E9F149C711CECB3E1' and plugid = '91FF3ECFA8234F76AA92F2AF5D8C302D' SQL语句参数：无。 【Debugger】 2025-06-08 15:31:14 192.168.109.222 SQL语句： with BarCodeTicketModelCode as ( select distinct a.barcode,case when s.ftickettype='游艇' then 1 else a.fticketCount end as TICKETCOUNT,a.FTRADEID as tradeId,A.FENDDATE AS INVALIDATE,A.FBEGINDATE AS BEGINDATE ,a.fticketmodelcode ,p.postfixlen,nvl(a.constractpricecode,0) as constractpricecode ,case when c.checkcount is not null then '已检票' else '未检票' end as checkflagName from (select * from TKT_tradebarcode where FRETRADEID is null and create_optorcode = 'HSSP001' ) a left join TKT_CHECKDETAIL c on a.barcode = c.barcode and a.ftradeid = c.tradeid left join sys_ticketmodel s on a.fticketmodelcode=s.ticketmodelcode left join sto_tickettype p on p.tickettypecode=a.ftickettypecode and p.barcodetype=a.fbarcodetype and p.tickettypeflag=a.tickettypeflag where a.fuseflag = 0 and a.tradeType <> '04' and ( a.ftradeid = '-1' or '-1'='-1') and ( a.barcode between 'ET25060813510500177694' and 'ET25060813510500177694' or 'ET25060813510500177694' ='-1' ) group by a.ftradeid, a.fticketmodelcode, fticketCount, a.barcode, c.checkcount,a.fBarcodetype,A.FENDDATE, A.FBEGINDATE,a.fTicketTypeCode,p.postfixlen,a.constractpricecode,s.ftickettype ) SELECT TD.Printtempmodel,M.TRADEDATE,M.MAKETIME,M.PARKCODE AS SELLPARKCODE,M.BILLTYPE,M.BILLNO,M.GUIDECODE ,M.SRCCLIENTCODE,M.AREACODE,M.SALEMODEL,M.PERFORMCODE,M.CLIENTCODE,M.CLIENTTYPE,M.TRADEID,M.PAYTYPECODE , M.create_OPTORName, L.CLIENTFULLNAME AS CLIENTNAME,TD.Constractpricecode ,TD.TICKETMODELPRICE,TD.TICKETMODELCODE,TD.FTICKETMODELKINDNAME,TD.FTICKETTYPE,TD.FTICKETMODELNAME,TD.FSHIPPLANID ,TD.FUSERCOUNT* C.Ticketcount as USERCOUNT,C.BARCODE,TM.Usercount as FUsercount ,TD.FTICKETMODELNAME as TICKETMODELNAME,C.TICKETCOUNT,C.TICKETCOUNT as TICKETCOUNT1 ,1 AS TICKETNOCOUNT, td.ticketmodelprice* c.TICKETCOUNT AS TICKETSUM ,td.Differenceprice,td.DIFFERENCEPRICE* c.ticketcount as ticketpayprice,(td.ticketmodelprice + td.differenceprice) * c.TICKETCOUNT as PaySum ,m.tradetype AS TRADETYPE, case m.tradetype when '01' then '正常售票' when '02' then '退票' else '其它' end AS TRADETYPENAME , null as INVALIDATE2 ,TM.RETTKTFLAG ,CASE m.CLIENTTYPE WHEN '01' THEN '散客' WHEN '02' THEN '团队' ELSE '其他' END AS CLIENTTYPENAME ,(SELECT P.PARKFULLNAME FROM SYS_PARK P WHERE P.PARKCODE = M.LOCATIONCODE) AS SELLPARKNAME ,(SELECT T.CLIENTTYPENAME FROM CLT_CLIENTTYPE T WHERE T.CLIENTTYPECODE = M.CLIENTTYPE) AS CLIENTTYPENAME , O.OPERATORNAME AS OPTORNAME,o.storagecode,SH.FSHIPNAME as SIFSHIPNAME ,SH.FSTARTTIME as SIFSTARTTIME ,TD.PARKCOUNT,TD.TICKETMODELKIND,TD.TICKETTYPECODE,td.fbelongcode ,1 AS ISSELECT ,c.postfixlen,c.INVALIDATE,c.BEGINDATE , S.TICKETTYPEFLAG,(select to_char(wm_concat(tr.paytypename || ':' || tr.paysum)) from tkt_tradepaytype tr where tr.tradeid = c.tradeid) as paytypenames,c.checkflagName FROM BarCodeTicketModelCode c INNER JOIN TKT_TRADEMAIN M ON M.TRADEID = C.TRADEID LEFT JOIN SYS_TICKETMODEL TM ON TM.TICKETMODELCODE = C.fticketmodelcode LEFT JOIN TKT_TRADEDETAIL TD ON TD.TRADEID = C.TRADEID AND TD.TICKETMODELCODE = C.fticketmodelcode LEFT JOIN atp_plan SH ON TD.fshipplanid=SH.Fid LEFT JOIN STO_TICKETTYPE S ON TD.TICKETTYPECODE = S.TICKETTYPECODE LEFT JOIN CLT_CLIENTINFO L ON L.CLIENTCODE = M.Clientcode Left Join SYS_OPERATOR o on O.OPERATORCODE = M.create_OPTORCODE where not exists( select * from TKT_CHECKDETAIL CD LEFT join Tkt_Trademain m on cd.tradeid = m.tradeid where cd.barcode = c.barcode and cd.tradeid = c.tradeid and (m.tradetype = '04' or m.tradetype = '07')) order by barcode SQL语句参数： 【Info】 2025-06-08 15:31:15 192.168.109.222 返回结果TwiReturn对象，序列化后为： {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2025-06-08 15:31:15 192.168.109.222 TwiAjaxHelper.GetResult执行完成！ ================================================================= 【Begin】 2025-06-08 15:31:21 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:31:21 192.168.109.222 请求信息： mn:TKT cn:PageCommon mn2:GetXMLBySQLMap 对应参数： data:{"Version":"Base_QueryDetail_C_cmd2_009","Code":"Base_QueryDetail_C_cmd2_009","SQLMapFile":"CmdSQLMap2.config","Parameters":{"TRADEID":"250608135105100085745","TICKETMODELCODE":"1051015"}} 【Debugger】 2025-06-08 15:31:21 192.168.109.222 SQL语句： select t.fTicketModelCode ,t.fTicketModelName ,t.tradeId ,t.fbegbarcode ,t.fendbarcode ,ticket_state ,barcode ,print_count ,(select min(d.begindate) from view_ticket_validdate_range d where d.tradeid=t.tradeid and d.fticketmodelcode=t.fTicketModelCode) as beginDate ,(select max(d.invaliDate) from view_ticket_validdate_range d where d.tradeid=t.tradeid and d.fticketmodelcode=t.fTicketModelCode) as invaliDate , decode(t.total_check_count,0,'未检票','已检票') as ticket_check_state ,t.total_check_count ,fbegincode,fendCode ,fReTradeId from ( select fTradeId as tradeId,t.fTicketModelCode,t.fticketmodelname,fbegincode,fendCode ,t.fReTradeId ,t.fbegbarcode,t.fendbarcode,print_count,t.barcode ,case when t.fuseFlag=0 then '正常' else '已退票' end as ticket_state ,nvl(( select sum(d.checkcount) from tkt_checkdetail d where d.tradeid=t.ftradeId and d.barcode =t.barcode),0) as total_check_count from tkt_tradebarcode t where (freTradeId=:TRADEID or fTradeId=:TRADEID) and t.fticketmodelcode=:TICKETMODELCODE ) t SQL语句参数(共3个)： {"ParameterName:"TRADEID","Value":"250608135105100085745","DbType":"String"}, {"ParameterName:"TRADEID","Value":"250608135105100085745","DbType":"String"}, {"ParameterName:"TICKETMODELCODE","Value":"1051015","DbType":"String"} 【Info】 2025-06-08 15:31:26 192.168.109.222 返回结果TwiReturn对象，序列化后为： {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2025-06-08 15:31:26 192.168.109.222 TwiAjaxHelper.GetResult执行完成！ ================================================================= 【Begin】 2025-06-08 15:31:26 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:31:26 192.168.109.222 请求信息： mn:TKT cn:PageCommon mn2:GetXmlBySimpleCondition 对应参数： data:{"Version":"Base_GetIsRetBoatTicket_C","TableName":"SYS_PARAM","SelectFields":"PARAMVALUE,PARAMCODE","Condition":{"PARAMCODE":"5029"}} 【Debugger】 2025-06-08 15:31:26 192.168.109.222 SQL语句：select * from WEB_TKT_TABLEMAPPING SQL语句参数：无。 【Debugger】 2025-06-08 15:31:37 192.168.109.222 SQL语句：select PARAMVALUE,PARAMCODE from SYS_PARAM where PARAMCODE=:PARAMCODE SQL语句参数(共1个)： {"ParameterName:"PARAMCODE","Value":"5029","DbType":"String"} 【Info】 2025-06-08 15:31:37 192.168.109.222 返回结果TwiReturn对象，序列化后为： {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2025-06-08 15:31:37 192.168.109.222 TwiAjaxHelper.GetResult执行完成！ ================================================================= 【Begin】 2025-06-08 15:31:37 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:31:37 192.168.109.222 请求信息： mn:TKT cn:PageCommon mn2:GetXMLBySQLMap 对应参数： data:{"Version":"Base_GetSysParam_C","Code":"Base_GetSysParam_C_whd_001","SQLMapFile":"WhdSQLMap.config"} 【Debugger】 2025-06-08 15:31:37 192.168.109.222 SQL语句： SELECT PARAMCODE,PARAMVALUE FROM SYS_PARAM ORDER BY PARAMCODE SQL语句参数：无。 【Info】 2025-06-08 15:31:37 192.168.109.222 返回结果TwiReturn对象，序列化后为： {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2025-06-08 15:31:37 192.168.109.222 TwiAjaxHelper.GetResult执行完成！ ================================================================= 【Begin】 2025-06-08 15:32:02 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:32:02 192.168.109.222 请求信息： mn:TKT cn:TicketReturn mn2:ReturnTikcetForGroup 对应参数： data: 2025/6/8 13:51:07 ET25060813510500177694 0 01 2025/6/8 13:51:07 0129002 01 01 250608135105100085745 1 1 0 1051015 花山、天池山成人票 01 2 60 0 1 散客 1001 101039 60 60 0 0129002 0129002 全价 门票 花山、天池山成人票 ET25060813510500177694 1051015 散客 01 60 58E03E673C7747FF825A9F66F4FA4F32 250608135105100085745 授权人： 原因： HSSP001 HSSP001 0129002 0 -60 0 40-8D-5C-C6-63-16 0 01 现金 60 0129002 HSSP001 60 0 【Debugger】 2025-06-08 15:32:02 192.168.109.222 SQL语句：SELECT * FROM SYS_PARAM SQL语句参数：无。 【Debugger】 2025-06-08 15:32:05 192.168.109.222 SQL语句：SELECT SEQ_TKT_TRADEID.NEXTVAL FROM DUAL SQL语句参数：无。 【Debugger】 2025-06-08 15:32:05 192.168.109.222 SQL语句：SELECT * FROM USER_SEQUENCES SQL语句参数：无。 【Debugger】 2025-06-08 15:32:05 192.168.109.222 SQL语句：select TABLE_NAME as "表名", column_id as "字段序号", column_name as "字段名", case when column_name in (select cu.column_name from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'P' and au.table_name =user_tab_columns.TABLE_NAME) then '1' else '0' end as "主键", DATA_TYPE as "类型", DATA_LENGTH as "长度", case when NULLABLE='Y'then '1'else '0'end as "允许空", DATA_DEFAULT as "默认值" from user_tab_columns where TABLE_NAME='TKT_TRADEMAIN' SQL语句参数：无。 【Debugger】 2025-06-08 15:32:06 192.168.109.222 SQL语句：INSERT INTO TKT_TRADEMAIN (BILLTYPE, GUIDECODE, SRCCLIENTCODE, SALEMODEL, AREACODE, CLIENTTYPE, CLIENTCODE, LOCATIONCODE, REMARK, TRADEDATE, TRADETYPE, MAKETIME, PAYSUM, TICKETCOUNT, REBATE, REBATESUM, TICKETSUM, DIFFERENCESUM, PAYTYPECODE, PAYTYPENAME, PERFORMCODE, MODIFIED_OPTORCODE, MODIFIED_OPTORNAME, BILLSUM, CREATE_OPTORCODE, FID, CREATE_OPTORNAME, USEFLAG, ORGID, STAMP, TRADEID, PARKCODE) VALUES(:BILLTYPE, :GUIDECODE, :SRCCLIENTCODE, :SALEMODEL, :AREACODE, :CLIENTTYPE, :CLIENTCODE, :LOCATIONCODE, :REMARK, :TRADEDATE, :TRADETYPE, :MAKETIME, :PAYSUM, :TICKETCOUNT, :REBATE, :REBATESUM, :TICKETSUM, :DIFFERENCESUM, :PAYTYPECODE, :PAYTYPENAME, :PERFORMCODE, :MODIFIED_OPTORCODE, :MODIFIED_OPTORNAME, :BILLSUM, :CREATE_OPTORCODE, :FID, :CREATE_OPTORNAME, :USEFLAG, :ORGID, :STAMP, :TRADEID, :PARKCODE) SQL语句参数： 参数名：BILLTYPE000 参数值：01 参数类型：String 参数名：GUIDECODE001 参数值： 参数类型：String ---------- 参数名：SRCCLIENTCODE002 参数值： 参数类型：String ---------- 参数名：SALEMODEL003 参数值：01 参数类型：String ---------- 参数名：AREACODE004 参数值： 参数类型：String ---------- 参数名：CLIENTTYPE005 参数值：01 参数类型：String ---------- 参数名：CLIENTCODE006 参数值：散客 参数类型：String ---------- 参数名：LOCATIONCODE007 参数值：0129002 参数类型：String ---------- 参数名：REMARK008 参数值：授权人： 原因： 参数类型：String ---------- 参数名：TRADEDATE009 参数值：2025/6/8 15:32:07 参数类型：Date ---------- 参数名：TRADETYPE010 参数值：02 参数类型：String ---------- 参数名：MAKETIME011 参数值：2025/6/8 15:32:07 参数类型：Date ---------- 参数名：PAYSUM012 参数值：-60 参数类型：String ---------- 参数名：TICKETCOUNT013 参数值：-1 参数类型：String ---------- 参数名：REBATE014 参数值：100 参数类型：String ---------- 参数名：REBATESUM015 参数值：-60 参数类型：String ---------- 参数名：TICKETSUM016 参数值：-60 参数类型：String ---------- 参数名：DIFFERENCESUM017 参数值：0 参数类型：String ---------- 参数名：PAYTYPECODE018 参数值：01 参数类型：String ---------- 参数名：PAYTYPENAME019 参数值：现金 参数类型：String ---------- 参数名：PERFORMCODE020 参数值： 参数类型：String ---------- 参数名：MODIFIED_OPTORCODE021 参数值：HSSP001 参数类型：String ---------- 参数名：MODIFIED_OPTORNAME022 参数值：HSSP001 参数类型：String ---------- 参数名：BILLSUM023 参数值：-60 参数类型：String ---------- 参数名：CREATE_OPTORCODE024 参数值：HSSP001 参数类型：String ---------- 参数名：FID025 参数值：33CD76EDC9AA402EA7E9F256A1F119B2 参数类型：String ---------- 参数名：CREATE_OPTORNAME026 参数值：HSSP001 参数类型：String ---------- 参数名：USEFLAG027 参数值：0 参数类型：String ---------- 参数名：ORGID028 参数值：58E03E673C7747FF825A9F66F4FA4F32 参数类型：String ---------- 参数名：STAMP029 参数值：01832BFA609C422E93FBBDD155FA3B0A 参数类型：String ---------- 参数名：TRADEID030 参数值：250608153205100085746 参数类型：String ---------- 参数名：PARKCODE031 参数值：0129002 参数类型：String ---------- 【Debugger】 2025-06-08 15:32:06 192.168.109.222 SQL语句：SELECT COUNT(1) AS IfExitst FROM USER_TABLES WHERE TABLE_NAME = UPPER('SYS_SEQUENCESKEY') SQL语句参数：无。 【Debugger】 2025-06-08 15:32:06 192.168.109.222 SQL语句：select cu.* from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'P' and au.table_name = 'TKT_TRADEPAYTYPE' SQL语句参数：无。 【Debugger】 2025-06-08 15:32:06 192.168.109.222 SQL语句：select TABLE_NAME as "表名", column_id as "字段序号", column_name as "字段名", case when column_name in (select cu.column_name from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'P' and au.table_name =user_tab_columns.TABLE_NAME) then '1' else '0' end as "主键", DATA_TYPE as "类型", DATA_LENGTH as "长度", case when NULLABLE='Y'then '1'else '0'end as "允许空", DATA_DEFAULT as "默认值" from user_tab_columns where TABLE_NAME='TKT_TRADEPAYTYPE' SQL语句参数：无。 【Debugger】 2025-06-08 15:32:07 192.168.109.222 SQL语句：INSERT INTO TKT_TRADEPAYTYPE (PAYTYPECODE, PAYTYPENAME, PAYSUM, PARKCODE, FOPTOR, TICKETSUM, DIFFERENCESUM, TRADEID, CREATE_OPTORCODE, CREATE_OPTORNAME, MODIFIED_OPTORCODE, MODIFIED_OPTORNAME, USEFLAG, ORGID, STAMP, BILLTYPE, SALEMODEL, CLIENTTYPE, CLIENTCODE, LOCATIONCODE, REMARK, TRADEDATE, TRADETYPE, FID) VALUES(:PAYTYPECODE, :PAYTYPENAME, :PAYSUM, :PARKCODE, :FOPTOR, :TICKETSUM, :DIFFERENCESUM, :TRADEID, :CREATE_OPTORCODE, :CREATE_OPTORNAME, :MODIFIED_OPTORCODE, :MODIFIED_OPTORNAME, :USEFLAG, :ORGID, :STAMP, :BILLTYPE, :SALEMODEL, :CLIENTTYPE, :CLIENTCODE, :LOCATIONCODE, :REMARK, :TRADEDATE, :TRADETYPE, :FID) SQL语句参数： 参数名：PAYTYPECODE000 参数值：01 参数类型：String 参数名：PAYTYPENAME001 参数值：现金 参数类型：String ---------- 参数名：PAYSUM002 参数值：-60 参数类型：String ---------- 参数名：PARKCODE003 参数值：0129002 参数类型：String ---------- 参数名：FOPTOR004 参数值：HSSP001 参数类型：String ---------- 参数名：TICKETSUM005 参数值：60 参数类型：String ---------- 参数名：DIFFERENCESUM006 参数值：0 参数类型：String ---------- 参数名：TRADEID007 参数值：250608153205100085746 参数类型：String ---------- 参数名：CREATE_OPTORCODE008 参数值：HSSP001 参数类型：String ---------- 参数名：CREATE_OPTORNAME009 参数值：HSSP001 参数类型：String ---------- 参数名：MODIFIED_OPTORCODE010 参数值：HSSP001 参数类型：String ---------- 参数名：MODIFIED_OPTORNAME011 参数值：HSSP001 参数类型：String ---------- 参数名：USEFLAG012 参数值：0 参数类型：String ---------- 参数名：ORGID013 参数值：58E03E673C7747FF825A9F66F4FA4F32 参数类型：String ---------- 参数名：STAMP014 参数值：F225CA92E91F47C1B2F785EC32C0F309 参数类型：String ---------- 参数名：BILLTYPE015 参数值：01 参数类型：String ---------- 参数名：SALEMODEL016 参数值：01 参数类型：String ---------- 参数名：CLIENTTYPE017 参数值：01 参数类型：String ---------- 参数名：CLIENTCODE018 参数值：散客 参数类型：String ---------- 参数名：LOCATIONCODE019 参数值：0129002 参数类型：String ---------- 参数名：REMARK020 参数值：授权人： 原因： 参数类型：String ---------- 参数名：TRADEDATE021 参数值：2025/6/8 15:32:07 参数类型：Date ---------- 参数名：TRADETYPE022 参数值：02 参数类型：String ---------- 参数名：FID023 参数值：A408C7FFFBB1489D80EC0431098C6BE9 参数类型：String ---------- 【Debugger】 2025-06-08 15:32:07 192.168.109.222 SQL语句： update TKT_TRADEBARCODE set FRETRADEID='250608153205100085746',RETTIME=sysdate,tradeType='02',FISENABLED=0,FUSEFLAG=1,USEFLAG=1,ISSYNC=decode(issync,1,2,1),MODIFIED_TIME=sysdate where ftradeid='250608135105100085745' and ( barcode between 'ET25060813510500177694' and 'ET25060813510500177694') SQL语句参数：无。 【Debugger】 2025-06-08 15:32:07 192.168.109.222 SQL语句： SELECT TRADEID, TRADEDATE, TRADETYPE, CONSTRACTPRICECODE, TICKETMODELCODE, TICKETMODELKIND, TICKETMODELPRICE, TAXPRICE, TAXPRINTFLAG, TICKETNOCOUNT, TICKETCOUNT , PAYSUM, PARKCOUNT, PERFORMCODE, SEATAREACODE, TICKETTYPECODE, PRINTCOUNT , CREATE_OPTORNAME, REMARK, MODIFIED_TIME, TRANSREMARK, TRANSFLAG, FTICKETTYPE, FTICKETMODELNAME, FTICKETMODELKINDNAME, FUSERCOUNT, CREATE_OPTORCODE , FBELONGCODE, SIGNTYPE, SIGNPAYTIME, PRINTTEMPNAME, PRINTTEMPMODEL, TICKETPAYPRICE, DIFFERENCEPRICE, DIFFERENCESUM, FID, CREATE_TIME, MODIFIED_OPTORCODE, MODIFIED_OPTORNAME, USEFLAG, DELETED, ORGID , STAMP,FSHIPPLANID FROM TKT_TRADEDETAIL WHERE TRADEID='250608135105100085745' AND TICKETMODELCODE='1051015' SQL语句参数：无。 【Debugger】 2025-06-08 15:32:07 192.168.109.222 SQL语句：SELECT COUNT(1) AS IfExitst FROM USER_TABLES WHERE TABLE_NAME = UPPER('SYS_SEQUENCESKEY') SQL语句参数：无。 【Debugger】 2025-06-08 15:32:07 192.168.109.222 SQL语句：select cu.* from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'P' and au.table_name = 'TKT_TRADEDETAIL' SQL语句参数：无。 【Debugger】 2025-06-08 15:32:07 192.168.109.222 SQL语句：select TABLE_NAME as "表名", column_id as "字段序号", column_name as "字段名", case when column_name in (select cu.column_name from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'P' and au.table_name =user_tab_columns.TABLE_NAME) then '1' else '0' end as "主键", DATA_TYPE as "类型", DATA_LENGTH as "长度", case when NULLABLE='Y'then '1'else '0'end as "允许空", DATA_DEFAULT as "默认值" from user_tab_columns where TABLE_NAME='TKT_TRADEDETAIL' SQL语句参数：无。 【Debugger】 2025-06-08 15:32:08 192.168.109.222 SQL语句：INSERT INTO TKT_TRADEDETAIL (TRADEID, TRADEDATE, TRADETYPE, CONSTRACTPRICECODE, TICKETMODELCODE, TICKETMODELKIND, TICKETMODELPRICE, TAXPRICE, TAXPRINTFLAG, TICKETNOCOUNT, TICKETCOUNT, PAYSUM, PARKCOUNT, PERFORMCODE, SEATAREACODE, TICKETTYPECODE, PRINTCOUNT, CREATE_OPTORNAME, REMARK, MODIFIED_TIME, TRANSREMARK, TRANSFLAG, FTICKETTYPE, FTICKETMODELNAME, FTICKETMODELKINDNAME, FUSERCOUNT, CREATE_OPTORCODE, FBELONGCODE, SIGNTYPE, SIGNPAYTIME, PRINTTEMPNAME, PRINTTEMPMODEL, TICKETPAYPRICE, DIFFERENCEPRICE, DIFFERENCESUM, CREATE_TIME, MODIFIED_OPTORCODE, MODIFIED_OPTORNAME, USEFLAG, DELETED, ORGID, STAMP, FSHIPPLANID, FID) VALUES(:TRADEID, :TRADEDATE, :TRADETYPE, :CONSTRACTPRICECODE, :TICKETMODELCODE, :TICKETMODELKIND, :TICKETMODELPRICE, :TAXPRICE, :TAXPRINTFLAG, :TICKETNOCOUNT, :TICKETCOUNT, :PAYSUM, :PARKCOUNT, :PERFORMCODE, :SEATAREACODE, :TICKETTYPECODE, :PRINTCOUNT, :CREATE_OPTORNAME, :REMARK, :MODIFIED_TIME, :TRANSREMARK, :TRANSFLAG, :FTICKETTYPE, :FTICKETMODELNAME, :FTICKETMODELKINDNAME, :FUSERCOUNT, :CREATE_OPTORCODE, :FBELONGCODE, :SIGNTYPE, :SIGNPAYTIME, :PRINTTEMPNAME, :PRINTTEMPMODEL, :TICKETPAYPRICE, :DIFFERENCEPRICE, :DIFFERENCESUM, :CREATE_TIME, :MODIFIED_OPTORCODE, :MODIFIED_OPTORNAME, :USEFLAG, :DELETED, :ORGID, :STAMP, :FSHIPPLANID, :FID) SQL语句参数： 参数名：TRADEID000 参数值：250608153205100085746 参数类型：String 参数名：TRADEDATE001 参数值：2025/6/8 15:32:07 参数类型：Date ---------- 参数名：TRADETYPE002 参数值：02 参数类型：String ---------- 参数名：CONSTRACTPRICECODE003 参数值： 参数类型：String ---------- 参数名：TICKETMODELCODE004 参数值：1051015 参数类型：String ---------- 参数名：TICKETMODELKIND005 参数值：101039 参数类型：String ---------- 参数名：TICKETMODELPRICE006 参数值：60 参数类型：String ---------- 参数名：TAXPRICE007 参数值：60 参数类型：String ---------- 参数名：TAXPRINTFLAG008 参数值：1 参数类型：String ---------- 参数名：TICKETNOCOUNT009 参数值：-1 参数类型：String ---------- 参数名：TICKETCOUNT010 参数值：-1 参数类型：String ---------- 参数名：PAYSUM011 参数值：-60 参数类型：String ---------- 参数名：PARKCOUNT012 参数值：0 参数类型：String ---------- 参数名：PERFORMCODE013 参数值： 参数类型：String ---------- 参数名：SEATAREACODE014 参数值： 参数类型：String ---------- 参数名：TICKETTYPECODE015 参数值：1001 参数类型：String ---------- 参数名：PRINTCOUNT016 参数值：1 参数类型：String ---------- 参数名：CREATE_OPTORNAME017 参数值：HSSP001 参数类型：String ---------- 参数名：REMARK018 参数值： 参数类型：String ---------- 参数名：MODIFIED_TIME019 参数值：2025/6/8 3:32:09 参数类型：Date ---------- 参数名：TRANSREMARK020 参数值： 参数类型：String ---------- 参数名：TRANSFLAG021 参数值：0 参数类型：String ---------- 参数名：FTICKETTYPE022 参数值：门票 参数类型：String ---------- 参数名：FTICKETMODELNAME023 参数值：花山、天池山成人票 参数类型：String ---------- 参数名：FTICKETMODELKINDNAME024 参数值：全价 参数类型：String ---------- 参数名：FUSERCOUNT025 参数值：-1 参数类型：String ---------- 参数名：CREATE_OPTORCODE026 参数值：HSSP001 参数类型：String ---------- 参数名：FBELONGCODE027 参数值：0129002 参数类型：String ---------- 参数名：SIGNTYPE028 参数值：0 参数类型：String ---------- 参数名：SIGNPAYTIME029 参数值： 参数类型：String ---------- 参数名：PRINTTEMPNAME030 参数值：PrintTicketMP.frx 参数类型：String ---------- 参数名：PRINTTEMPMODEL031 参数值：0 参数类型：String ---------- 参数名：TICKETPAYPRICE032 参数值：-60 参数类型：String ---------- 参数名：DIFFERENCEPRICE033 参数值：0 参数类型：String ---------- 参数名：DIFFERENCESUM034 参数值：0 参数类型：String ---------- 参数名：CREATE_TIME035 参数值：2025/6/8 3:32:09 参数类型：Date ---------- 参数名：MODIFIED_OPTORCODE036 参数值：HSSP001 参数类型：String ---------- 参数名：MODIFIED_OPTORNAME037 参数值：HSSP001 参数类型：String ---------- 参数名：USEFLAG038 参数值：0 参数类型：String ---------- 参数名：DELETED039 参数值：0 参数类型：String ---------- 参数名：ORGID040 参数值：58E03E673C7747FF825A9F66F4FA4F32 参数类型：String ---------- 参数名：STAMP041 参数值：F2048AB303BB444F8B75BBF115C4C743 参数类型：String ---------- 参数名：FSHIPPLANID042 参数值： 参数类型：String ---------- 参数名：FID043 参数值：5B44E4CF00054815BAC13434FD924F89 参数类型：String ---------- 【Debugger】 2025-06-08 15:32:08 192.168.109.222 SQL语句：insert into STO_INVALIDTICKET ( FID,TICKETTYPECODE,TICKETCOUNT,CREATE_OPTORCODE,RECMODTIME,RECSTATUS,BALANCEFLAG,REMARK,PARKCODE,BARCODE,TICKETMODELCODE ,TRADEID,ORGID,CREATE_OPTORNAME,STAMP) values ('068BC0821A5B4A2EBD0706A67A4EE6D8','1001','1','HSSP001',sysdate,'2','0','【退票作废】【自动登记】','0129002','ET25060813510500177694','1051015','250608135105100085745','58E03E673C7747FF825A9F66F4FA4F32','HSSP001','A8F478C7BE7448D0898324E0B501ED02') SQL语句参数： 【Info】 2025-06-08 15:32:08 192.168.109.222 返回结果TwiReturn对象，序列化后为： {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2025-06-08 15:32:08 192.168.109.222 TwiAjaxHelper.GetResult执行完成！ ================================================================= 【Begin】 2025-06-08 15:32:08 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:32:08 192.168.109.222 请求信息： mn:TKT cn:PageCommon mn2:GetXmlBySQLMap 对应参数： data:{"Code":"FS_GetLockData","SQLMapFile":"LclSQLMap.config","Parameters":{"TRADEID":"250608135105100085745"}} 【Info】 2025-06-08 15:32:08 192.168.109.222 返回结果TwiReturn对象，序列化后为： {"id":null,"code":null,"success":false,"hasRight":true,"rightName":null,"knowError":100,"errors":"SQLMap中未找到Code为：【FS_GetLockData】的配置","message":"系统发生异常：SQLMap中未找到Code为：【FS_GetLockData】的配置","data":null,"totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2025-06-08 15:32:08 192.168.109.222 TwiAjaxHelper.GetResult执行完成！ ================================================================= 【Begin】 2025-06-08 15:32:14 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:32:14 192.168.109.222 请求信息： mn:TKT cn:PageCommon mn2:GetXMLBySQLMap 对应参数： data:{"Code":"Base_GetRDMData_C_cmd_02701","SQLMapFile":"CmdSQLMap.config","Parameters":{"OPTORCODE":"HSSP001","CREATETIME":"2025-06-08","EndTimeValue":"2025-06-08"}} 【Debugger】 2025-06-08 15:32:14 192.168.109.222 SQL语句： select case when T.TradeType ='01'then'正常售票' when T.TradeType='02'then'退票' when T.TradeType='04'then'预售票' else'其它'end as TRADETYPENAME, case when T.ClientType='01'then'散客'when T.ClientType='02'then'团队' when T.ClientType='03'then'政府部门'when T.ClientType='04'then'企事业单位'else''end as CLIENTTYPENAME, V.TICKETMODELGROUPNAME,K.TICKETMODELKINDNAME,V.TICKETMODELNAME||'（'||V.BARCODETYPE||'）' as TICKETMODELNAME,T.TICKETCOUNT,T.TICKETNOCOUNT,T.TICKETMODELPRICE,T.differenceprice,T.PAYSUM from( select A.ClientType,A.Billtype,B.TicketModelCode,B.TicketModelKind,B.TradeType, B.TicketModelPrice,b.differenceprice,sum(TicketCount)as TicketCount, sum(TICKETNOCOUNT) as TICKETNOCOUNT,sum(PaySum)as PaySum from (select TradeID,ClientType,billtype from tkt_trademain where tradetype <>'04' and tradetype<>'07' and create_optorcode=:OPTORCODE AND tradedate>to_date(:CREATETIME,'yyyy-MM-dd HH24:Mi:ss') AND tradedate<=to_date(:EndTimeValue,'yyyy-MM-dd HH24:Mi:ss')+1 ) A left join tkt_tradedetail B on A.TradeID=B.TradeID group by A.ClientType,A.Billtype,B.TicketModelCode,B.TicketModelKind, B.TradeType,B.TicketModelPrice,b.differenceprice)T left join view_xzh_TicketModelAndGroup V on T.TicketModelCode = V.TicketModelCode left join view_xzh_TicketModelKind K on T.TicketModelKind = K.TicketModelKind order by T.TradeType SQL语句参数(共3个)： {"ParameterName:"OPTORCODE","Value":"HSSP001","DbType":"String"}, {"ParameterName:"CREATETIME","Value":"2025-06-08","DbType":"String"}, {"ParameterName:"EndTimeValue","Value":"2025-06-08","DbType":"String"} 【Info】 2025-06-08 15:32:15 192.168.109.222 返回结果TwiReturn对象，序列化后为： {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2025-06-08 15:32:15 192.168.109.222 TwiAjaxHelper.GetResult执行完成！ ================================================================= 【Begin】 2025-06-08 15:32:15 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:32:15 192.168.109.222 请求信息： mn:TKT cn:PageCommon mn2:GetXMLBySQLMap 对应参数： data:{"Code":"Base_GetRDMData_C_cmd_037","SQLMapFile":"CmdSQLMap.config","Parameters":{"OPTORCODE":"HSSP001","CREATETIME":"2025-06-08","EndTimeValue":"2025-06-08"}} 【Debugger】 2025-06-08 15:32:15 192.168.109.222 SQL语句： select a.PAYTYPENAME,a.PAYTYPECODE,sum(a.paysum) as PAYSUM from ( select b.PAYTYPENAME,b.PAYTYPECODE,b.paysum from tkt_tradepaytype b left join tkt_trademain c on b.tradeid=c.tradeid where c.tradetype <>'04' and c.tradetype<>'07' and c.create_optorcode=:OPTORCODE AND c.TRADEDATE>=to_date(:CREATETIME,'yyyy-MM-dd HH24:Mi:ss') AND c.TRADEDATE<=to_date(:EndTimeValue,'yyyy-MM-dd HH24:Mi:ss')+1 ) a group by a.PAYTYPENAME,a.PAYTYPECODE SQL语句参数(共3个)： {"ParameterName:"OPTORCODE","Value":"HSSP001","DbType":"String"}, {"ParameterName:"CREATETIME","Value":"2025-06-08","DbType":"String"}, {"ParameterName:"EndTimeValue","Value":"2025-06-08","DbType":"String"} 【Info】 2025-06-08 15:32:20 192.168.109.222 返回结果TwiReturn对象，序列化后为： {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2025-06-08 15:32:20 192.168.109.222 TwiAjaxHelper.GetResult执行完成！ ================================================================= 【Begin】 2025-06-08 15:32:20 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:32:20 192.168.109.222 请求信息： mn:TKT cn:PageCommon mn2:GetXMLBySQLMap 对应参数： data:{"Code":"Base_GetRDMData_C_cmd_03602","SQLMapFile":"CmdSQLMap.config","Parameters":{"OPTORCODE":"HSSP001","CREATETIME":"2025-06-08","EndTimeValue":"2025-06-08"}} 【Debugger】 2025-06-08 15:32:20 192.168.109.222 SQL语句： SELECT D.*,t.tickettypename FROM( SELECT CASE WHEN MIN(BARCODE)<>MAX(BARCODE) THEN MIN(BARCODE)||'-'||MAX(BARCODE) ELSE MIN(BARCODE) END AS BARCODES ,Count(barcode) as BARCODECOUNT,flag,barcodetype,FCOUNT, Count(barcode)*FLAG*FCOUNT as SELLCOUNT,case flag when 1 then '销售条码' when -1 then '退票条码' when 0 then '销售后退票条码' else '其它' end as FLAGNAME FROM ( SELECT D.BARCODE,d.FCOUNT,flag,barcodetype,REGEXP_SUBSTR(replace(D.BARCODE,d.barcodetype,''),'[0-9]+') - ROW_NUMBER() OVER(ORDER BY D.flag,d.barcodetype,d.FCOUNT,D.BARCODE)+1 AS GROUPNO FROM ( select d.barcode,barcodetype,d.flag,d.FCOUNT from ( select barcode,ticketmodel,FLAG,count(1) FCOUNT from ( select ftradeid as tradeid ,barcode,fticketmodelcode as ticketmodel,1 as FLAG from tkt_tradebarcode d1 where exists(select 1 from tkt_trademain m where m.tradetype <>'04' and m.tradetype<>'07' and m.tradetype <>'02' and m.create_optorcode=:OPTORCODE AND m.tradedate>to_date(:CREATETIME,'yyyy-MM-dd HH24:Mi:ss') AND m.tradedateto_date(:CREATETIME,'yyyy-MM-dd HH24:Mi:ss') AND m.tradedate'04' and tradetype<>'07' and create_optorcode=:OPTORCODE AND tradedate>to_date(:CREATETIME,'yyyy-MM-dd HH24:Mi:ss') AND tradedate<=to_date(:EndTimeValue,'yyyy-MM-dd HH24:Mi:ss')+1 ) A left join tkt_tradedetail B on A.TradeID=B.TradeID group by A.ClientType,A.Billtype,B.TicketModelCode,B.TicketModelKind, B.TradeType,B.TicketModelPrice,b.differenceprice)T left join view_xzh_TicketModelAndGroup V on T.TicketModelCode = V.TicketModelCode left join view_xzh_TicketModelKind K on T.TicketModelKind = K.TicketModelKind order by T.TradeType SQL语句参数(共3个)： {"ParameterName:"OPTORCODE","Value":"HSSP001","DbType":"String"}, {"ParameterName:"CREATETIME","Value":"2025-06-08","DbType":"String"}, {"ParameterName:"EndTimeValue","Value":"2025-06-08","DbType":"String"} 【Info】 2025-06-08 15:32:53 192.168.109.222 返回结果TwiReturn对象，序列化后为： {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2025-06-08 15:32:53 192.168.109.222 TwiAjaxHelper.GetResult执行完成！ ================================================================= 【Begin】 2025-06-08 15:32:53 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:32:53 192.168.109.222 请求信息： mn:TKT cn:PageCommon mn2:GetXMLBySQLMap 对应参数： data:{"Code":"Base_GetRDMData_C_cmd_037","SQLMapFile":"CmdSQLMap.config","Parameters":{"OPTORCODE":"HSSP001","CREATETIME":"2025-06-08","EndTimeValue":"2025-06-08"}} 【Debugger】 2025-06-08 15:32:53 192.168.109.222 SQL语句： select a.PAYTYPENAME,a.PAYTYPECODE,sum(a.paysum) as PAYSUM from ( select b.PAYTYPENAME,b.PAYTYPECODE,b.paysum from tkt_tradepaytype b left join tkt_trademain c on b.tradeid=c.tradeid where c.tradetype <>'04' and c.tradetype<>'07' and c.create_optorcode=:OPTORCODE AND c.TRADEDATE>=to_date(:CREATETIME,'yyyy-MM-dd HH24:Mi:ss') AND c.TRADEDATE<=to_date(:EndTimeValue,'yyyy-MM-dd HH24:Mi:ss')+1 ) a group by a.PAYTYPENAME,a.PAYTYPECODE SQL语句参数(共3个)： {"ParameterName:"OPTORCODE","Value":"HSSP001","DbType":"String"}, {"ParameterName:"CREATETIME","Value":"2025-06-08","DbType":"String"}, {"ParameterName:"EndTimeValue","Value":"2025-06-08","DbType":"String"} 【Info】 2025-06-08 15:32:53 192.168.109.222 返回结果TwiReturn对象，序列化后为： {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":"序列化类型为“System.Xml.Linq.XElement”的对象时检测到循环引用。","totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2025-06-08 15:32:53 192.168.109.222 TwiAjaxHelper.GetResult执行完成！ ================================================================= 【Begin】 2025-06-08 15:32:53 192.168.109.222 TwiAjaxHelper.GetResult开始调用... 【Info】 2025-06-08 15:32:53 192.168.109.222 请求信息： mn:TKT cn:PageCommon mn2:GetXMLBySQLMap 对应参数： data:{"Code":"Base_GetRDMData_C_cmd_03602","SQLMapFile":"CmdSQLMap.config","Parameters":{"OPTORCODE":"HSSP001","CREATETIME":"2025-06-08","EndTimeValue":"2025-06-08"}} 【Debugger】 2025-06-08 15:32:53 192.168.109.222 SQL语句： SELECT D.*,t.tickettypename FROM( SELECT CASE WHEN MIN(BARCODE)<>MAX(BARCODE) THEN MIN(BARCODE)||'-'||MAX(BARCODE) ELSE MIN(BARCODE) END AS BARCODES ,Count(barcode) as BARCODECOUNT,flag,barcodetype,FCOUNT, Count(barcode)*FLAG*FCOUNT as SELLCOUNT,case flag when 1 then '销售条码' when -1 then '退票条码' when 0 then '销售后退票条码' else '其它' end as FLAGNAME FROM ( SELECT D.BARCODE,d.FCOUNT,flag,barcodetype,REGEXP_SUBSTR(replace(D.BARCODE,d.barcodetype,''),'[0-9]+') - ROW_NUMBER() OVER(ORDER BY D.flag,d.barcodetype,d.FCOUNT,D.BARCODE)+1 AS GROUPNO FROM ( select d.barcode,barcodetype,d.flag,d.FCOUNT from ( select barcode,ticketmodel,FLAG,count(1) FCOUNT from ( select ftradeid as tradeid ,barcode,fticketmodelcode as ticketmodel,1 as FLAG from tkt_tradebarcode d1 where exists(select 1 from tkt_trademain m where m.tradetype <>'04' and m.tradetype<>'07' and m.tradetype <>'02' and m.create_optorcode=:OPTORCODE AND m.tradedate>to_date(:CREATETIME,'yyyy-MM-dd HH24:Mi:ss') AND m.tradedateto_date(:CREATETIME,'yyyy-MM-dd HH24:Mi:ss') AND m.tradedateMAX(BARCODE) THEN MIN(BARCODE)||'-'||MAX(BARCODE) ELSE MIN(BARCODE) END AS BARCODES ,Count(barcode) as BARCODECOUNT,flag,barcodetype,FCOUNT, Count(barcode)*FLAG*FCOUNT as SELLCOUNT,case flag when 1 then '销售条码' when -1 then '退票条码' when 0 then '销售后退票条码' else '其它' end as FLAGNAME FROM ( SELECT D.BARCODE,d.FCOUNT,flag,barcodetype,REGEXP_SUBSTR(replace(D.BARCODE,d.barcodetype,''),'[0-9]+') - ROW_NUMBER() OVER(ORDER BY D.flag,d.barcodetype,d.FCOUNT,D.BARCODE)+1 AS GROUPNO FROM ( select d.barcode,barcodetype,d.flag,d.FCOUNT from ( select barcode,ticketmodel,FCOUNT,case when FCOUNT<0 then -1 else 1 end as FLag from ( select barcode,ticketmodel,sum(FLAG*FCOUNT) as FCOUNT from （ select barcode,ticketmodel,FLAG,count(1) FCOUNT from ( select ftradeid as tradeid,barcode,fticketmodelcode as ticketmodel,1 as FLAG from tkt_tradebarcode d1 where exists(select 1 from tkt_trademain m where m.tradetype <>'04' and m.tradetype<>'07' and m.tradetype <>'02' and m.create_optorcode=:OPTORCODE AND m.tradedate>to_date(:CREATETIME,'yyyy-MM-dd HH24:Mi:ss') AND m.tradedateto_date(:CREATETIME,'yyyy-MM-dd HH24:Mi:ss') AND m.tradedate