--------------------
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')
--------------------
