【Begin】 2023-08-04 08:16:15 192.168.109.11 TwiAjaxHelper.GetResult开始调用... 【Info】 2023-08-04 08:16:15 192.168.109.11 请求信息: mn:TKT cn:PageCommon mn2:GetXMLBySQLMap 对应参数: data:{"Code":"Base_LoadWindowCom_C_cmd3_010","SQLMapFile":"CmdSQLMap3.config"} 【Debugger】 2023-08-04 08:16:15 192.168.109.11 SQL语句: select c.*,k.parkfullname from sys_computer c left join sys_park k on c.fparkcode=k.parkcode where k.deleted=0 SQL语句参数:无。 【Info】 2023-08-04 08:16:15 192.168.109.11 返回结果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-04 08:16:15 192.168.109.11 TwiAjaxHelper.GetResult执行完成! ================================================================= 【Begin】 2023-08-04 08:16:15 192.168.109.11 TwiAjaxHelper.GetResult开始调用... 【Info】 2023-08-04 08:16:15 192.168.109.11 请求信息: mn:TKT cn:Authority mn2:Base_GetVerificationCode 对应参数: data: 【Debugger】 2023-08-04 08:16:15 192.168.109.11 SQL语句:select PARAMCODE,PARAMVALUE from sys_param where PARAMCODE='0002' or PARAMCODE='0003' SQL语句参数: 【Info】 2023-08-04 08:16:15 192.168.109.11 返回结果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-04 08:16:15 192.168.109.11 TwiAjaxHelper.GetResult执行完成! ================================================================= 【Begin】 2023-08-04 08:16:15 192.168.109.11 TwiAjaxHelper.GetResult开始调用... 【Info】 2023-08-04 08:16:15 192.168.109.11 请求信息: mn:TKT cn:Authority mn2:GetVerificationLogin 对应参数: data: 【Debugger】 2023-08-04 08:16:15 192.168.109.11 SQL语句:select PARAMCODE,PARAMVALUE from sys_param where PARAMCODE=3001 or PARAMCODE=3002 or PARAMCODE=3003 or PARAMCODE=3004 or PARAMCODE=3005 SQL语句参数: 【Info】 2023-08-04 08:16:15 192.168.109.11 返回结果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-04 08:16:15 192.168.109.11 TwiAjaxHelper.GetResult执行完成! ================================================================= 【Begin】 2023-08-04 08:16:15 192.168.109.11 TwiAjaxHelper.GetResult开始调用... 【Info】 2023-08-04 08:16:15 192.168.109.11 请求信息: mn:TKT cn:Authority mn2:GetUserPwdModifiedTime 对应参数: data: tcssp001 0 【Debugger】 2023-08-04 08:16:15 192.168.109.11 SQL语句:SELECT * FROM SYS_OPERATOR WHERE MODIFIED_TIME>to_date('2023-08-04 08:16:15','yyyy-MM-dd HH24:Mi:ss') AND (OPERATORCODE='TCSSP001' OR OPERATORCODE='tcssp001') SQL语句参数: 【Info】 2023-08-04 08:16:15 192.168.109.11 返回结果TwiReturn对象,序列化后为: {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":{"FirstAttribute":null,"HasAttributes":false,"HasElements":false,"IsEmpty":true,"LastAttribute":null,"Name":{"LocalName":"Root","Namespace":{"NamespaceName":""},"NamespaceName":""},"NodeType":1,"Value":"","FirstNode":null,"LastNode":null,"NextNode":null,"PreviousNode":null,"BaseUri":"","Document":null,"Parent":null},"totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2023-08-04 08:16:15 192.168.109.11 TwiAjaxHelper.GetResult执行完成! ================================================================= 【Begin】 2023-08-04 08:16:15 192.168.109.11 TwiAjaxHelper.GetResult开始调用... 【Info】 2023-08-04 08:16:15 192.168.109.11 请求信息: mn:TKT cn:Authority mn2:Base_LoginWithOutValidateCodeXml 对应参数: userName:tcssp001 pwd:C4CA4238A0B923820DCC509A6F75849B Version: ip:192.168.109.11 mac:44-8A-5B-C9-4C-11 【Debugger】 2023-08-04 08:16:15 192.168.109.11 SQL语句:select * from SYS_OPERATOR where OPERATORCODE=:OPERATORCODE and OPERATORPASS=:OPERATORPASS SQL语句参数(共2个): {"ParameterName:"OPERATORCODE","Value":"TCSSP001","DbType":"String"}, {"ParameterName:"OPERATORPASS","Value":"C4CA4238A0B923820DCC509A6F75849B","DbType":"String"} 【Debugger】 2023-08-04 08:16:15 192.168.109.11 SQL语句:select identify from sys_dept where fid = '58E03E673C7747FF825A9F66F4FA4F32' SQL语句参数:无。 【Debugger】 2023-08-04 08:16:15 192.168.109.11 SQL语句:insert into WEB_SYS_OPERATORLOGIN(FID,OPERATORCODE,OPERATORNAME,LASTLOGINIP,FTYPE,FMAC) values ('263E42579DB940208AA15B4415857350','TCSSP001','TCSSP001','192.168.109.11',1,'44-8A-5B-C9-4C-11') SQL语句参数:无。 【Debugger】 2023-08-04 08:16:15 192.168.109.11 SQL语句: select * from ( with X as ( select distinct B.FID,B.PlugCode,B.PlugName,B.ParentID,B.PlugType,B.WPFUrl,B.PlugUrl,B.ImpOnWPF,A.SysCode, A.SubSystemSort,A.PlugSort,b.PICNAME,c.btn from view_BIM_OperatorSubSystemPlug A join web_sys_plug B on A.PlugCode = B.PlugCode left join ( select fplugid,to_char(wm_concat(fbuttoncode)) btn from ( select rpb.fplugid,pb.fbuttoncode from web_sys_roleplugbutton rpb left join web_sys_plugbutton pb on rpb.fbuttonid = pb.fid and rpb.froleid in (select t.roleid from web_sys_roleoperator t where t.operatorid = :OperatorID) ) group by fplugid ) c on c.fplugid = b.fid where operatorID=:OperatorID and WPFUrl is not null and imponwpf>0 and state=1 and deleted = 0 ) select * from X union select distinct B.FID,B.PlugCode,B.PlugName,B.ParentID,B.PlugType,B.WPFUrl,B.PlugUrl,B.ImpOnWPF,A.SysCode, A.SubSystemSort,A.PlugSort,b.PICNAME,c.btn from view_BIM_OperatorSubSystemPlug A join web_sys_plug B on A.PlugCode = B.PlugCode left join ( select fplugid,to_char(wm_concat(fbuttoncode)) btn from ( select rpb.fplugid,pb.fbuttoncode from web_sys_roleplugbutton rpb left join web_sys_plugbutton pb on rpb.fbuttonid = pb.fid and rpb.froleid in (select t.roleid from web_sys_roleoperator t where t.operatorid = :OperatorID) ) group by fplugid ) c on c.fplugid = b.fid where operatorID=:OperatorID and WPFUrl is not null and state=1 and deleted = 0 and B.FID in (select ParentID from X) ) order by SubSystemSort,PlugSort SQL语句参数(共4个): {"ParameterName:"OperatorID","Value":"DB36B31DDCBC4093BF1E97D8C4F2D8C2","DbType":"String"}, {"ParameterName:"OperatorID","Value":"DB36B31DDCBC4093BF1E97D8C4F2D8C2","DbType":"String"}, {"ParameterName:"OperatorID","Value":"DB36B31DDCBC4093BF1E97D8C4F2D8C2","DbType":"String"}, {"ParameterName:"OperatorID","Value":"DB36B31DDCBC4093BF1E97D8C4F2D8C2","DbType":"String"} 【Info】 2023-08-04 08:16:16 192.168.109.11 返回结果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-04 08:16:16 192.168.109.11 TwiAjaxHelper.GetResult执行完成! ================================================================= 【Begin】 2023-08-04 08:16:16 192.168.109.11 TwiAjaxHelper.GetResult开始调用... 【Info】 2023-08-04 08:16:16 192.168.109.11 请求信息: mn:TKT cn:Authority mn2:Base_GetUserDetail 对应参数: operatorid:DB36B31DDCBC4093BF1E97D8C4F2D8C2 【Debugger】 2023-08-04 08:16:16 192.168.109.11 SQL语句:SELECT P.PARKCODE,P.PARKSHORTNAME,S.STORAGECODE,S.STORAGENAME,T.ISTICKETSELLER,T.TDTICKETFLAG,T.SKTICKETFLAG,T.CONTICKETFLAG,T.PARKPOWERFLAG,O.FID AS SETTLE FROM SYS_OPERATOR T LEFT JOIN SYS_PARK P ON P.PARKCODE = T.PARKCODE LEFT JOIN STO_STORAGE S ON S.STORAGECODE = T.STORAGECODE LEFT JOIN (SELECT FID,CREATE_OPTORCODE AS OPTORCODE FROM TKT_OPTORBALANCE WHERE BALANCEDATE=:BALANCEDATE) O ON O.OPTORCODE = T.OPERATORCODE WHERE T.FID=:OPERATORID SQL语句参数: 参数名:BALANCEDATE000 参数值:2023/8/4 0:00:00 参数类型:Date 参数名:OPERATORID001 参数值:DB36B31DDCBC4093BF1E97D8C4F2D8C2 参数类型:String ---------- 【Info】 2023-08-04 08:16:16 192.168.109.11 返回结果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-04 08:16:16 192.168.109.11 TwiAjaxHelper.GetResult执行完成! ================================================================= 【Begin】 2023-08-04 08:16:17 192.168.109.11 TwiAjaxHelper.GetResult开始调用... 【Info】 2023-08-04 08:16:17 192.168.109.11 请求信息: mn:TKT cn:PageCommon mn2:Base_GetDefaultDBTip 对应参数: 【Info】 2023-08-04 08:16:17 192.168.109.11 返回结果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-04 08:16:17 192.168.109.11 TwiAjaxHelper.GetResult执行完成! ================================================================= 【Begin】 2023-08-04 08:16:18 192.168.109.11 TwiAjaxHelper.GetResult开始调用... 【Info】 2023-08-04 08:16:18 192.168.109.11 请求信息: mn:TKT cn:PageCommon mn2:GetXMLBySQLMap 对应参数: data:{"Code":"Base_GetOptorStockData_C_cxk_002","SQLMapFile":"XzhSQLMap.config","Parameters":{"OptorCode":"TCSSP001"}} 【Debugger】 2023-08-04 08:16:18 192.168.109.11 SQL语句: SELECT * FROM ( --数量库存 SELECT (B.TICKETTYPENAME ||'(' ||B.BARCODETYPE||')') AS TICKETTYPENAME,B.BARCODETYPE,A.OBJECTCODE AS HANDLEMAN,'/' AS BEGINBARCODE, '/' AS ENDBARCODE,A.LEFTCOUNT ,A.LEFTCOUNT AS AMOUNT,0 AS TICKETTYPEFLAG , '数量库存' as ticketTypeFlagName FROM STO_STOCKCOUNT A INNER JOIN STO_TICKETTYPE B ON A.TICKETTYPECODE = B.TICKETTYPECODE WHERE B.USEFLAG=0 AND A.OBJECTCODE=:OptorCode AND B.TICKETTYPEFLAG=0 UNION --明细库存 SELECT (B.TICKETTYPENAME ||'(' ||B.BARCODETYPE||')') AS TICKETTYPENAME,B.BARCODETYPE, T.STORAGECODE AS HANDLEMAN, T.BEGINTICKETCODE AS BEGINBARCODE, T.ENDTICKETCODE AS ENDBARCODE,T.TICKETAMOUNT AS LEFTCOUNT, T.TICKETAMOUNT AS AMOUNT,1 AS TICKETTYPEFLAG ,'明细库存' FROM STO_STOCKDETAIL T INNER JOIN STO_TICKETTYPE B ON T.TICKETTYPECODE=B.TICKETTYPECODE WHERE T.TICKETSTATUS = 0 AND T.STORAGECODE=:OptorCode ) T ORDER BY T.TICKETTYPEFLAG ASC SQL语句参数(共2个): {"ParameterName:"OptorCode","Value":"TCSSP001","DbType":"String"}, {"ParameterName:"OptorCode","Value":"TCSSP001","DbType":"String"} 【Info】 2023-08-04 08:16:18 192.168.109.11 返回结果TwiReturn对象,序列化后为: {"id":null,"code":null,"success":true,"hasRight":true,"rightName":null,"knowError":100,"errors":null,"message":"操作成功!","data":{"FirstAttribute":null,"HasAttributes":false,"HasElements":false,"IsEmpty":true,"LastAttribute":null,"Name":{"LocalName":"ItemList","Namespace":{"NamespaceName":""},"NamespaceName":""},"NodeType":1,"Value":"","FirstNode":null,"LastNode":null,"NextNode":null,"PreviousNode":null,"BaseUri":"","Document":null,"Parent":null},"totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2023-08-04 08:16:18 192.168.109.11 TwiAjaxHelper.GetResult执行完成! ================================================================= 【Begin】 2023-08-04 08:16:18 192.168.109.11 TwiAjaxHelper.GetResult开始调用... 【Info】 2023-08-04 08:16:18 192.168.109.11 请求信息: mn:TKT cn:PageCommon mn2:GetXmlBySimpleCondition 对应参数: data:{"Version":"Base_ShowStockModel_C","TableName":"SYS_PARAM","SelectFields":"PARAMVALUE","Condition":{"PARAMCODE":"0025"}} 【Debugger】 2023-08-04 08:16:18 192.168.109.11 SQL语句:select * from WEB_TKT_TABLEMAPPING SQL语句参数:无。 【Debugger】 2023-08-04 08:16:18 192.168.109.11 SQL语句:select PARAMVALUE from SYS_PARAM where PARAMCODE=:PARAMCODE SQL语句参数(共1个): {"ParameterName:"PARAMCODE","Value":"0025","DbType":"String"} 【Info】 2023-08-04 08:16:18 192.168.109.11 返回结果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-04 08:16:18 192.168.109.11 TwiAjaxHelper.GetResult执行完成! ================================================================= 【Begin】 2023-08-04 16:08:32 192.168.109.11 TwiAjaxHelper.GetResult开始调用... 【Info】 2023-08-04 16:08:32 192.168.109.11 请求信息: mn:TKT cn:PageCommon mn2:SimpleNew 对应参数: data:{"TableName":"SYS008","IDField":"FID","Fields":{"Version":"Base_LogoutLog_C","FID":"FCB29EDA1F2649179238ABC53E2C197F","OPERATORCODE":"TCSSP001","OPERATORNAME":"TCSSP001","LASTLOGINIP":"192.168.109.11","FTYPE":"2","FMAC":"44-8A-5B-C9-4C-11"},"MaxCodeFields":"FID"} 【Debugger】 2023-08-04 16:08:32 192.168.109.11 SQL语句:select * from WEB_TKT_TABLEMAPPING SQL语句参数:无。 【Debugger】 2023-08-04 16:08:32 192.168.109.11 SQL语句:insert into WEB_SYS_OPERATORLOGIN (Version,OPERATORCODE,OPERATORNAME,LASTLOGINIP,FTYPE,FMAC,FID) values (:Version,:OPERATORCODE,:OPERATORNAME,:LASTLOGINIP,:FTYPE,:FMAC,'0') SQL语句参数(共6个): {"ParameterName:"Version","Value":"Base_LogoutLog_C","DbType":"String"}, {"ParameterName:"OPERATORCODE","Value":"TCSSP001","DbType":"String"}, {"ParameterName:"OPERATORNAME","Value":"TCSSP001","DbType":"String"}, {"ParameterName:"LASTLOGINIP","Value":"192.168.109.11","DbType":"String"}, {"ParameterName:"FTYPE","Value":"2","DbType":"String"}, {"ParameterName:"FMAC","Value":"44-8A-5B-C9-4C-11","DbType":"String"} 【Info】 2023-08-04 16:08:32 192.168.109.11 返回结果TwiReturn对象,序列化后为: {"id":null,"code":null,"success":false,"hasRight":true,"rightName":null,"knowError":100,"errors":"ORA-00904: \"VERSION\": 标识符无效","message":"系统发生异常:ORA-00904: \"VERSION\": 标识符无效","data":null,"totalCount":0,"affRows":0,"stamp":null,"list":[]} 【End】 2023-08-04 16:08:32 192.168.109.11 TwiAjaxHelper.GetResult执行完成! =================================================================