拣项目分拣项目F:\分拣项目F:\

2024-07-18 09:30:33.8831 | INFO | | | 【db0 SQL语句】SELECT [ID],[Name],[JobGroup],[Cron],[AssemblyName],[ClassName],[Remark],[RunTimes],[BeginTime],[EndTime],[TriggerType],[IntervalSecond],[IsStart],[JobParams],[Create_by],[Create_time],[Update_by],[Update_time],[LastRunTime],[ApiUrl],[TaskType],[SqlText],[RequestMethod] FROM [sys_tasks] WHERE ( [IsStart]=1 ) 2024-07-18 09:31:03.2168 | INFO | 127.0.0.1 | | http://127.0.0.1/login 【db0 SQL语句】SELECT TOP 1 [ConfigId],[ConfigName],[ConfigKey],[ConfigValue],[ConfigType],[Create_by],[Create_time],[Update_by],[Update_time],[Remark] FROM [sys_config] WHERE ( [ConfigKey] = N'sys.account.captchaOnOff' ) 2024-07-18 09:31:03.4105 | INFO | 127.0.0.1 | | http://127.0.0.1/login 【db0 SQL语句】SELECT TOP 1 [UserId],[UserName],[NickName],[Avatar],[Email],[Password],[Phonenumber],[UserJobID],[Sex],[Status],[DelFlag],[LoginIP],[LoginDate],[Create_by],[Create_time],[Update_by],[Update_time],[Remark] FROM [sys_user] WHERE (( [UserName] = N'hang' ) AND ( [Password] = N'E10ADC3949BA59ABBE56E057F20F883E' )) 2024-07-18 09:31:03.4467 | WARN | 127.0.0.1 | | http://127.0.0.1/login 【db0 SQL语句】INSERT INTO [sys_logininfor] ([UserName],[Status],[Ipaddr],[LoginLocation],[Browser],[Os],[Msg],[LoginTime]) VALUES (N'hang',N'0',N'127.0.0.1',N'0-内网IP',N'Windows 7 Other Chrome 23.0.1271',N'Windows 7',N'登录成功','2024-07-18 09:31:03.419') ; 2024-07-18 09:31:03.4743 | WARN | 127.0.0.1 | | http://127.0.0.1/login 【db0 SQL语句】UPDATE [sys_user] SET [LoginIP]=N'127.0.0.1',[LoginDate]='2024-07-18 09:31:03.447' WHERE [UserId]=13 2024-07-18 09:31:03.4911 | INFO | 127.0.0.1 | | http://127.0.0.1/login 【db0 SQL语句】SELECT r.* FROM [sys_user_role] [ur] Left JOIN [sys_role] [r] ON ( [ur].[role_id] = [r].[RoleId] ) WHERE (( [ur].[user_id] = 13 ) AND ( [r].[RoleId] > 0 )) 2024-07-18 09:31:03.4911 | INFO | 127.0.0.1 | | http://127.0.0.1/login 【db0 SQL语句】SELECT r.* FROM [sys_user_role] [ur] Left JOIN [sys_role] [r] ON ( [ur].[role_id] = [r].[RoleId] ) WHERE (( [ur].[user_id] = 13 ) AND ( [r].[RoleId] > 0 )) 2024-07-18 09:31:03.6432 | WARN | 127.0.0.1 | | http://127.0.0.1/login 【db0 SQL语句】INSERT INTO [sys_oper_log] ([Title],[BusinessType],[Method],[RequestMethod],[OperatorType],[OperUrl],[OperIp],[OperLocation],[OperParam],[JsonResult],[Status],[OperTime],[Elapsed]) VALUES (N'登录',0,N'SysLogin.Login()',N'POST',0,N'/login',N'127.0.0.1',N'0 内网IP',N'{"username":"hang","password":"123456"}',N'{ "code": 200, "msg": "SUCCESS", "data": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkJlYXJlciJ9.eyJwcmltYXJ5c2lkIjoiMTMiLCJ1bmlxdWVfbmFtZSI6ImhhbmciLCJodHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL3dzLzIwMDgvMDYvaWRlbnRpdHkvY2xhaW1zL3VzZXJkYXRhIjoie1wiVXNlcklkXCI6MTMsXCJVc2VyTmFtZVwiOlwiaGFuZ1wiLFwiUm9sZUlkc1wiOltcImFkbWluXCJdLFwiUm9sZXNcIjpbe1wiUm9sZUlkXCI6MSxcIlJvbGVOYW1lXCI6XCLotoXnuqfnrqHnkIblkZhcIixcIlJvbGVLZXlcIjpcImFkbWluXCIsXCJSb2xlU29ydFwiOjEsXCJTdGF0dXNcIjpcIjBcIixcIkRlbEZsYWdcIjpcIjBcIixcIkRhdGFTY29wZVwiOlwiMVwiLFwiTWVudUNoZWNrU3RyaWN0bHlcIjp0cnVlLFwiRGVwdENoZWNrU3RyaWN0bHlcIjpmYWxzZSxcIk1lbnVJZHNcIjpudWxsLFwiVXNlck51bVwiOjAsXCJDcmVhdGVCeVwiOlwiYWRtaW5cIixcIkNyZWF0ZVRpbWVcIjpcIjIwMjQtMDctMDJUMTY6NTc6NDMuMjI3XCIsXCJVcGRhdGVUaW1lXCI6bnVsbCxcIlJlbWFya1wiOlwi6LaF57qn566h55CG5ZGYXCJ9XSxcIlBlcm1pc3Npb25zXCI6W1wiKjoqOipcIl19IiwiQXVkaWVuY2UiOiJaUkFkbWluLk5FVCIsIklzc3VlciI6IlpSQWRtaW4uTkVUIiwibmJmIjoxNzIxMjY2MjYzLCJleHAiOjE3MjEzNTI2NjMsImlhdCI6MTcyMTI2NjI2MywiaXNzIjoiWlJBZG1pbi5ORVQiLCJhdWQiOiJaUkFkbWluLk5FVCJ9.oqyerfALX-BcTCl2oH7BnVR7n9oUE4qRtvx6WZkEudE"}',0,'2024-07-18 09:31:03.651',0) ; 2024-07-18 09:31:05.2321 | INFO | 127.0.0.1 | | http://127.0.0.1/business/AgvBitManager/list 【db0 SQL语句】SELECT [Id],[agvBitNo],[agvType],[status],[agvBarCode],[currentCardboard],[currentMaterialCode],[currentCallMaterialNo],[agvPosition] FROM [ele_agvbitmanager] 2024-07-18 09:31:06.1371 | INFO | 127.0.0.1 | | http://127.0.0.1/business/AgvBitManager/list 【db0 SQL语句】SELECT [Id],[agvBitNo],[agvType],[status],[agvBarCode],[currentCardboard],[currentMaterialCode],[currentCallMaterialNo],[agvPosition] FROM [ele_agvbitmanager] 2024-07-18 09:31:06.8558 | INFO | ::1 | | http://127.0.0.1/business/BydFeedingDetails/list 【db0 SQL语句】 SELECT COUNT(1) FROM (SELECT DISTINCT [r].*, [m].[MaterialName] AS [materialName] , [m].[Unit] AS [Unit] , [r].[feedingMaterial_No] AS [feedingMaterialNo] , [r].[sortingTask_No] AS [sortingTaskNo] FROM [byd_feedingDetails] [r] Left JOIN [byd_material] [m] ON ( [r].[MaterialCode] = [m].[MaterialCode] ) WHERE ( [r].[State] = 0 )) CountTable 2024-07-18 09:31:06.8558 | INFO | ::1 | | http://127.0.0.1/business/BydFeedingDetails/list 【db0 SQL语句】SELECT * FROM (SELECT t.*,ROW_NUMBER() OVER( ORDER BY GetDate() ) AS RowIndex FROM (SELECT DISTINCT [r].*, [m].[MaterialName] AS [materialName] , [m].[Unit] AS [Unit] , [r].[feedingMaterial_No] AS [feedingMaterialNo] , [r].[sortingTask_No] AS [sortingTaskNo] FROM [byd_feedingDetails] [r] Left JOIN [byd_material] [m] ON ( [r].[MaterialCode] = [m].[MaterialCode] ) WHERE ( [r].[State] = 0 )) t ) T WHERE RowIndex BETWEEN 1 AND 20 2024-07-18 09:31:07.1513 | INFO | 127.0.0.1 | | http://127.0.0.1/business/AgvBitManager/list 【db0 SQL语句】SELECT [Id],[agvBitNo],[agvType],[status],[agvBarCode],[currentCardboard],[currentMaterialCode],[currentCallMaterialNo],[agvPosition] FROM [ele_agvbitmanager] 2024-07-18 09:31:08.1655 | INFO | 127.0.0.1 | | http://127.0.0.1/business/AgvBitManager/list 【db0 SQL语句】SELECT [Id],[agvBitNo],[agvType],[status],[agvBarCode],[currentCardboard],[currentMaterialCode],[currentCallMaterialNo],[agvPosition] FROM [ele_agvbitmanager] 2024-07-18 09:31:09.1810 | INFO | 127.0.0.1 | | http://127.0.0.1/business/AgvBitManager/list 【db0 SQL语句】SELECT [Id],[agvBitNo],[agvType],[status],[agvBarCode],[currentCardboard],[currentMaterialCode],[currentCallMaterialNo],[agvPosition] FROM [ele_agvbitmanager] 2024-07-18 09:31:10.1696 | INFO | 127.0.0.1 | | http://127.0.0.1/business/AgvBitManager/list 【db0 SQL语句】SELECT [Id],[agvBitNo],[agvType],[status],[agvBarCode],[currentCardboard],[currentMaterialCode],[currentCallMaterialNo],[agvPosition] FROM [ele_agvbitmanager] 2024-07-18 09:31:11.1837 | INFO | 127.0.0.1 | | http://127.0.0.1/business/AgvBitManager/list 【db0 SQL语句】SELECT [Id],[agvBitNo],[agvType],[status],[agvBarCode],[currentCardboard],[currentMaterialCode],[currentCallMaterialNo],[agvPosition] FROM [ele_agvbitmanager] 2024-07-18 09:31:12.1989 | INFO | 127.0.0.1 | | http://127.0.0.1/business/AgvBitManager/list 【db0 SQL语句】SELECT [Id],[agvBitNo],[agvType],[status],[agvBarCode],[currentCardboard],[currentMaterialCode],[currentCallMaterialNo],[agvPosition] FROM [ele_agvbitmanager] 2024-07-18 09:31:13.2020 | INFO | 127.0.0.1 | | http://127.0.0.1/business/AgvBitManager/list 【db0 SQL语句】SELECT [Id],[agvBitNo],[agvType],[status],[agvBarCode],[currentCardboard],[currentMaterialCode],[currentCallMaterialNo],[agvPosition] FROM [ele_agvbitmanager] 2024-07-18 09:31:14.2154 | INFO | 127.0.0.1 | | http://127.0.0.1/business/AgvBitManager/list 【db0 SQL语句】SELECT [Id],[agvBitNo],[agvType],[status],[agvBarCode],[currentCardboard],[currentMaterialCode],[currentCallMaterialNo],[agvPosition] FROM [ele_agvbitmanager] 2024-07-18 09:31:15.2149 | INFO | 127.0.0.1 | | http://127.0.0.1/business/AgvBitManager/list 【db0 SQL语句】SELECT [Id],[agvBitNo],[agvType],[status],[agvBarCode],[currentCardboard],[currentMaterialCode],[currentCallMaterialNo],[agvPosition] FROM [ele_agvbitmanager] 2024-07-18 09:31:16.2192 | INFO | 127.0.0.1 | | http://127.0.0.1/business/AgvBitManager/list 【db0 SQL语句】SELECT [Id],[agvBitNo],[agvType],[status],[agvBarCode],[currentCardboard],[currentMaterialCode],[currentCallMate