-------------------- 2022年9月12日 12:26:43 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:26:53 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:27:43 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:27:51 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:28:00 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:52:01 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:52:03 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:52:13 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:52:23 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:52:33 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:52:43 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:53:05 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:53:13 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:53:23 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:53:33 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:53:43 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:53:53 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:54:03 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:54:13 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 12:54:23 WCSSql语句 SELECT [equipment_id],[equipment_code],[equipment_name],[equipment_state],[equipment_type],[equipment_ip],[equipment_createtime],[equipment_remark] FROM [dt_equipmentinfo] WHERE ( 1 = 1 ) -------------------- -------------------- 2022年9月12日 17:15:20 WCSSql语句 INSERT INTO [container] ([containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime]) VALUES (N'0e7195db-210a-45f7-9354-d0105602e8b3',N'C.G.000017014',N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}',N'有货',1,N'超级管理员','2022-09-12 17:15:19.161') ; -------------------- -------------------- 2022年9月12日 17:19:15 WCSSql语句 INSERT INTO [container] ([containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime]) VALUES (N'dd1eb2bb-cd18-46b8-b2f7-a8fbb0fc9277',N'C.G.000017014',N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}',N'有货',null,N'超级管理员','2022-09-12 17:19:10.525') ; -------------------- -------------------- 2022年9月12日 17:23:10 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 17:30:00 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE (( [containerdtl_materielid] = N'C.G.000017014' ) AND (null = [containerdtl_cacheNo] )) -------------------- -------------------- 2022年9月12日 17:31:23 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE (( [containerdtl_materielid] = N'C.G.000017014' ) AND (1 = [containerdtl_cacheNo] )) -------------------- -------------------- 2022年9月12日 17:31:38 WCSSql语句 DELETE FROM [container] WHERE [containerdtl_id] IN ('0e7195db-210a-45f7-9354-d0105602e8b3') -------------------- -------------------- 2022年9月12日 17:33:52 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE (( [containerdtl_materielid] = N'C.G.000017014' ) AND (( CASE WHEN ( N'' = N'' ) THEN 0 ELSE null END ) = [containerdtl_cacheNo] )) -------------------- -------------------- 2022年9月12日 17:35:57 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE (( [containerdtl_materielid] = N'C.G.000017014' ) AND ( N'' = [containerdtl_cacheNo] )) -------------------- -------------------- 2022年9月12日 17:37:04 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE (( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) AND ( N'' = [containerdtl_cacheNo] )) -------------------- -------------------- 2022年9月12日 17:37:36 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 17:38:22 WCSSql语句 DELETE FROM [container] WHERE [containerdtl_id] IN ('dd1eb2bb-cd18-46b8-b2f7-a8fbb0fc9277') -------------------- -------------------- 2022年9月12日 17:38:26 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 17:38:26 WCSSql语句 INSERT INTO [container] ([containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime]) VALUES (N'18bb22cb-0ec6-443a-b5d6-7d79d874fb4a',N'C.G.000017014',N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}',N'有货',N'',N'超级管理员','2022-09-12 17:38:26.322') ; -------------------- -------------------- 2022年9月12日 17:38:55 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE ( [containerdtl_sn] = N'' ) -------------------- -------------------- 2022年9月12日 17:39:22 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE ( [containerdtl_sn] = N'' ) -------------------- -------------------- 2022年9月12日 17:39:57 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 17:40:03 WCSSql语句 DELETE FROM [container] WHERE [containerdtl_id] IN ('18bb22cb-0ec6-443a-b5d6-7d79d874fb4a') -------------------- -------------------- 2022年9月12日 17:41:09 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 17:41:09 WCSSql语句 INSERT INTO [container] ([containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime]) VALUES (N'5c18833c-8c47-4b2a-b83a-60d584aaa497',N'C.G.000017014',N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}',N'有货',N'',N'超级管理员','2022-09-12 17:41:09.497') ; -------------------- -------------------- 2022年9月12日 17:41:12 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE (( [containerdtl_sn] = N'' ) AND ( N'' = [containerdtl_cacheNo] )) -------------------- -------------------- 2022年9月12日 17:41:46 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE (( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) AND ( N'' = [containerdtl_cacheNo] )) -------------------- -------------------- 2022年9月12日 17:42:03 WCSSql语句 DELETE FROM [container] WHERE [containerdtl_id] IN ('5c18833c-8c47-4b2a-b83a-60d584aaa497') -------------------- -------------------- 2022年9月12日 17:45:03 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 17:45:03 WCSSql语句 INSERT INTO [container] ([containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime]) VALUES (N'71272ef1-10b6-4a41-b8e4-62c7615e8dcf',N'C.G.000017014',N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}',N'有货',N'',N'超级管理员','2022-09-12 17:45:03.402') ; -------------------- -------------------- 2022年9月12日 17:48:18 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 17:48:18 WCSSql语句 INSERT INTO [container] ([containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime]) VALUES (N'7d876d82-4b18-4c79-beb0-06be20453cc1',N'C.G.000017014',N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}',N'有货',N'',N'超级管理员','2022-09-12 17:48:18.569') ; -------------------- -------------------- 2022年9月12日 17:51:20 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 17:51:20 WCSSql语句 INSERT INTO [container] ([containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime]) VALUES (N'f368f237-6576-4f56-9d82-4ccedc6395e6',N'C.G.000017014',N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}',N'有货',N'',N'超级管理员','2022-09-12 17:51:20.202') ; -------------------- -------------------- 2022年9月12日 17:56:06 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 17:56:06 WCSSql语句 INSERT INTO [container] ([containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime]) VALUES (N'2703f3f8-7c37-466d-add0-ad549f2fb15e',N'C.G.000017014',N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}',N'有货',N'',N'超级管理员','2022-09-12 17:56:06.850') ; -------------------- -------------------- 2022年9月12日 17:56:55 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE (( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) AND ( N'' = [containerdtl_cacheNo] )) -------------------- -------------------- 2022年9月12日 17:57:01 WCSSql语句 DELETE FROM [container] WHERE [containerdtl_id] IN ('2703f3f8-7c37-466d-add0-ad549f2fb15e') -------------------- -------------------- 2022年9月12日 18:02:03 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:02:24 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:02:24 WCSSql语句 INSERT INTO [container] ([containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime]) VALUES (N'0653fb7d-acbd-4823-93cb-caf727c1a91e',N'C.G.000017014',N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}',N'有货',N'',N'超级管理员','2022-09-12 18:02:24.301') ; -------------------- -------------------- 2022年9月12日 18:02:55 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:05:00 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:05:07 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:05:10 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:05:12 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:05:13 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:05:14 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:06:19 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:06:26 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:06:27 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:06:28 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:06:29 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:06:30 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:06:35 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE (( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) AND ( N'' = [containerdtl_cacheNo] )) -------------------- -------------------- 2022年9月12日 18:06:35 WCSSql语句 DELETE FROM [container] WHERE [containerdtl_id] IN ('0653fb7d-acbd-4823-93cb-caf727c1a91e') -------------------- -------------------- 2022年9月12日 18:06:58 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:07:02 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:07:02 WCSSql语句 INSERT INTO [container] ([containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime]) VALUES (N'c18011a8-524e-4529-9e90-b02bce026ed4',N'C.G.000017014',N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}',N'有货',N'',N'超级管理员','2022-09-12 18:07:02.796') ; -------------------- -------------------- 2022年9月12日 18:07:29 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:07:38 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE (( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) AND ( N'' = [containerdtl_cacheNo] )) -------------------- -------------------- 2022年9月12日 18:07:38 WCSSql语句 DELETE FROM [container] WHERE [containerdtl_id] IN ('c18011a8-524e-4529-9e90-b02bce026ed4') -------------------- -------------------- 2022年9月12日 18:07:41 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:07:43 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE (( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) AND ( N'' = [containerdtl_cacheNo] )) -------------------- -------------------- 2022年9月12日 18:25:01 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:25:02 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:25:02 WCSSql语句 INSERT INTO [container] ([containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime]) VALUES (N'76aaef01-5bc6-4f5a-997b-965d6217c072',N'C.G.000017014',N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}',N'有货',N'',N'超级管理员','2022-09-12 18:25:02.874') ; -------------------- -------------------- 2022年9月12日 18:51:10 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:51:40 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:51:41 WCSSql语句 SELECT 1 FROM [container] WHERE ( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) -------------------- -------------------- 2022年9月12日 18:51:44 WCSSql语句 SELECT TOP 1 [containerdtl_id],[containerdtl_materielid],[containerdtl_sn],[containerdtl_state],[containerdtl_cacheNo],[containerdtl_creator],[containerdtl_createtime] FROM [container] WHERE (( [containerdtl_sn] = N'{"batchNum":8000,"materialBatch":"C.G.000017014.2022022706C19.20220227","materialCode":"C.G.000017014","productDate":"2022-02-27","serialNumber":"001"}' ) AND ( N'' = [containerdtl_cacheNo] )) -------------------- -------------------- 2022年9月12日 18:51:44 WCSSql语句 DELETE FROM [container] WHERE [containerdtl_id] IN ('76aaef01-5bc6-4f5a-997b-965d6217c072') --------------------