【Begin】 2023-08-09 12:07:57 120757 TwiAjaxHelper.GetResult开始调用... 【Info】 2023-08-09 12:07:57 120757 请求信息: mn:TKT cn:PageCommon mn2:GetXMLBySQLMap 对应参数: data:{"Version":"Base_QueryDetail_C_cmd2_009","Code":"Base_QueryDetail_C_cmd2_009","SQLMapFile":"CmdSQLMap2.config","Parameters":{"TRADEID":"230805135907100057052","TICKETMODELCODE":"1045010"}} 【Debugger】 2023-08-09 12:07:57 120757 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":"230805135907100057052","DbType":"String"}, {"ParameterName:"TRADEID","Value":"230805135907100057052","DbType":"String"}, {"ParameterName:"TICKETMODELCODE","Value":"1045010","DbType":"String"} 【Info】 2023-08-09 12:07:57 120757 返回结果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】 2023-08-09 12:07:57 120757 TwiAjaxHelper.GetResult执行完成! =================================================================