Time: 2021/12/31 8:57:01 Type: 单头数据保存SQL语句 Message: insert into YFPURI05 (taskId,TA001,TA002,TA003,TA004,TA005,TA006,TA007,TA008,TA009,TA010,TA011,TA012,TA013,TA014,TA015,TA016,TA017,TA018,TA019,TA020,TA021,TA022,TA023,TA024,TA025,HeadUDF01,HeadUDF02,HeadUDF03,HeadUDF04,HeadUDF05,HeadUDF06,HeadUDF07,HeadUDF08,HeadUDF09,HeadUDF10,HeadUDF11,HeadUDF12,HeadUDF51,HeadUDF52,HeadUDF53 ) values('409557','311请购单','21120294','20211231','0603','','','N','0','9','101','24','','20211231','','0','S','0','','','','0','0','0','0','','','25517','王小艳','','','','','','','','','','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 8:57:01 Type: 单身数据保存取数1 Message: True ----------------------------------------------------------- Time: 2021/12/31 8:57:01 Type: 单身数据保存取数2 Message: YFPURI05_B ----------------------------------------------------------- Time: 2021/12/31 8:57:01 Type: 单身数据保存SQL语句 Message: insert into YFPURI05_B (TaskId,GridOrder,TB001,TB002,TB003,TB004,TB005,TB006,TB007,TB008,TB009,TB010,TB011,TB012,TB013,TB014,TB015,TB016,TB017,TB018,TB019,TB020,TB021,TB022,TB023,TB024,TB025,TB026,TB027,TB028,TB029,TB030,TB031,TB032,TB033,TB034,TB035,TB036,TB037,TB038,TB039,TB040 ) values( '409557','1','311','21120294','0001','40001400766','初效(G2板式)','595*595*46T','PCS','106产品辅料仓','6',null,'20211231','涂装课',null,'6','PCS',null,'0','0','20211231','N','N',null,null,'涂装课','N','1',null,null,null,null,null,'N',null,'0','0',null,null,null,'N','0');insert into YFPURI05_B (TaskId,GridOrder,TB001,TB002,TB003,TB004,TB005,TB006,TB007,TB008,TB009,TB010,TB011,TB012,TB013,TB014,TB015,TB016,TB017,TB018,TB019,TB020,TB021,TB022,TB023,TB024,TB025,TB026,TB027,TB028,TB029,TB030,TB031,TB032,TB033,TB034,TB035,TB036,TB037,TB038,TB039,TB040 ) values( '409557','2','311','21120294','0002','40001400767','初效(G2板式)','290*595*46T','PCS','106产品辅料仓','2',null,'20211231','涂装课',null,'2','PCS',null,'0','0','20211231','N','N',null,null,'涂装课','N','1',null,null,null,null,null,'N',null,'0','0',null,null,null,'N','0');insert into YFPURI05_B (TaskId,GridOrder,TB001,TB002,TB003,TB004,TB005,TB006,TB007,TB008,TB009,TB010,TB011,TB012,TB013,TB014,TB015,TB016,TB017,TB018,TB019,TB020,TB021,TB022,TB023,TB024,TB025,TB026,TB027,TB028,TB029,TB030,TB031,TB032,TB033,TB034,TB035,TB036,TB037,TB038,TB039,TB040 ) values( '409557','3','311','21120294','0003','40001400768','初效(G4板式)','595*595*46T','PCS','106产品辅料仓','6',null,'20211231','涂装课',null,'6','PCS',null,'0','0','20211231','N','N',null,null,'涂装课','N','1',null,null,null,null,null,'N',null,'0','0',null,null,null,'N','0');insert into YFPURI05_B (TaskId,GridOrder,TB001,TB002,TB003,TB004,TB005,TB006,TB007,TB008,TB009,TB010,TB011,TB012,TB013,TB014,TB015,TB016,TB017,TB018,TB019,TB020,TB021,TB022,TB023,TB024,TB025,TB026,TB027,TB028,TB029,TB030,TB031,TB032,TB033,TB034,TB035,TB036,TB037,TB038,TB039,TB040 ) values( '409557','4','311','21120294','0004','40001400769','初效(G4板式)','290*595*46T','PCS','106产品辅料仓','2',null,'20211231','涂装课',null,'2','PCS',null,'0','0','20211231','N','N',null,null,'涂装课','N','1',null,null,null,null,null,'N',null,'0','0',null,null,null,'N','0');insert into YFPURI05_B (TaskId,GridOrder,TB001,TB002,TB003,TB004,TB005,TB006,TB007,TB008,TB009,TB010,TB011,TB012,TB013,TB014,TB015,TB016,TB017,TB018,TB019,TB020,TB021,TB022,TB023,TB024,TB025,TB026,TB027,TB028,TB029,TB030,TB031,TB032,TB033,TB034,TB035,TB036,TB037,TB038,TB039,TB040 ) values( '409557','5','311','21120294','0005','40001400770','中效(F8袋式)','592*592*381T','PCS','106产品辅料仓','6',null,'20211231','涂装课',null,'6','PCS',null,'0','0','20211231','N','N',null,null,'涂装课','N','1',null,null,null,null,null,'N',null,'0','0',null,null,null,'N','0');insert into YFPURI05_B (TaskId,GridOrder,TB001,TB002,TB003,TB004,TB005,TB006,TB007,TB008,TB009,TB010,TB011,TB012,TB013,TB014,TB015,TB016,TB017,TB018,TB019,TB020,TB021,TB022,TB023,TB024,TB025,TB026,TB027,TB028,TB029,TB030,TB031,TB032,TB033,TB034,TB035,TB036,TB037,TB038,TB039,TB040 ) values( '409557','6','311','21120294','0006','40001400771','中效(F8袋式)','287*592*381T','PCS','106产品辅料仓','2',null,'20211231','涂装课',null,'2','PCS',null,'0','0','20211231','N','N',null,null,'涂装课','N','1',null,null,null,null,null,'N',null,'0','0',null,null,null,'N','0'); ----------------------------------------------------------- Time: 2021/12/31 8:57:01 Type: StartNode Message: 1 ----------------------------------------------------------- Time: 2021/12/31 8:57:01 Type: StartNode Message: 2 ----------------------------------------------------------- Time: 2021/12/31 8:57:01 Type: StartNode Message: 3 ----------------------------------------------------------- Time: 2021/12/31 10:27:27 Type: 单头数据保存SQL语句 Message: insert into YFPURI05 (taskId,TA001,TA002,TA003,TA004,TA005,TA006,TA007,TA008,TA009,TA010,TA011,TA012,TA013,TA014,TA015,TA016,TA017,TA018,TA019,TA020,TA021,TA022,TA023,TA024,TA025,HeadUDF01,HeadUDF02,HeadUDF03,HeadUDF04,HeadUDF05,HeadUDF06,HeadUDF07,HeadUDF08,HeadUDF09,HeadUDF10,HeadUDF11,HeadUDF12,HeadUDF51,HeadUDF52,HeadUDF53 ) values('409558','311请购单','21120295','20211231','1004','','','N','0','9','101','10','','20211231','','0','S','0','','','','0','0','0','0','','','1321','唐彩霞','','','','','','','','','','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 10:27:27 Type: 单身数据保存取数1 Message: True ----------------------------------------------------------- Time: 2021/12/31 10:27:27 Type: 单身数据保存取数2 Message: YFPURI05_B ----------------------------------------------------------- Time: 2021/12/31 10:27:27 Type: 单身数据保存SQL语句 Message: insert into YFPURI05_B (TaskId,GridOrder,TB001,TB002,TB003,TB004,TB005,TB006,TB007,TB008,TB009,TB010,TB011,TB012,TB013,TB014,TB015,TB016,TB017,TB018,TB019,TB020,TB021,TB022,TB023,TB024,TB025,TB026,TB027,TB028,TB029,TB030,TB031,TB032,TB033,TB034,TB035,TB036,TB037,TB038,TB039,TB040 ) values( '409558','1','311','21120295','0001','40001603747','CNC铣刀','6毫米单刃刀','PCS','148生产耗材仓','10','RX2158','20211231','李建飞',null,'10','PCS','RMB','0','0','20211231','N','N',null,null,'李建飞','N','1',null,null,null,null,null,'N',null,'0','0',null,null,null,'N','0'); ----------------------------------------------------------- Time: 2021/12/31 10:27:27 Type: StartNode Message: 1 ----------------------------------------------------------- Time: 2021/12/31 10:27:27 Type: StartNode Message: 2 ----------------------------------------------------------- Time: 2021/12/31 10:27:27 Type: StartNode Message: 3 ----------------------------------------------------------- Time: 2021/12/31 10:33:22 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 10:33:23 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 10:33:44 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 10:33:44 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 10:41:32 Type: 单头数据保存SQL语句 Message: insert into YFASTI23 (taskId,TO001,TO002,TO003,TO004,TO005,TO006,TO007,TO008,TO009,TO010,TO011,TO012,TO013,TO014,TO015,TO016,TO017,TO018,TO019,TO020,TO021,TO022,TO023,TO024,TO025,TO026,TO027,TO028,TO029,TO030,TO031,TO032,TO033,TO034,TO035,TO036,TO037,TO038,TO039,TO040,TO041,TO042,TO043,TO044,TO045,TO046,HeadUDF01,HeadUDF02,HeadUDF03,HeadUDF04,HeadUDF05,HeadUDF06,HeadUDF07,HeadUDF08,HeadUDF09,HeadUDF10,HeadUDF11,HeadUDF12,HeadUDF51,HeadUDF52,HeadUDF53,HeadUDF54,HeadUDF55,HeadUDF56,HeadUDF57,HeadUDF58,HeadUDF59,HeadUDF60,HeadUDF61,HeadUDF62 ) values('409559','CC01资产进货','21120008','20211231','20211231','HZ2021海之星','101','','RMB','1','','0','107','N','N','S','0','441900L30187219','S','0.13','1','','2','','202112','','','5880','0','5203.54','676.46','5203.54','676.46','0','1','','','0','0','0','0400','','','','0','0','0','列管','','','','','','','','','','','','0','0','0','0','0','0','0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 10:41:32 Type: 单身数据保存取数1 Message: True ----------------------------------------------------------- Time: 2021/12/31 10:41:32 Type: 单身数据保存取数2 Message: YFASTI23_B ----------------------------------------------------------- Time: 2021/12/31 10:41:32 Type: 单身数据保存SQL语句 Message: insert into YFASTI23_B (TaskId,GridOrder,TP001,TP002,TP003,TP004,TP005,TP006,TP007,TP008,TP009,TP010,TP011,TP012,TP013,TP014,TP015,TP016,TP017,TP018,TP019,TP020,TP021,TP022,TP023,TP024,TP025,TP026,TP027,TP028,TP029,TP030,TP031,TP032,TP033,TP034,TP035,TP036,TP037,TP038,TP039,TP040,TP041,TP042,TP043,TP044,TP045,TP046,TP047,BodyUDF01,BodyUDF02,BodyUDF03,BodyUDF04,BodyUDF05,BodyUDF06,BodyUDF07,BodyUDF08,BodyUDF09,BodyUDF10,BodyUDF11,BodyUDF12,BodyUDF51,BodyUDF52,BodyUDF53,BodyUDF54,BodyUDF55,BodyUDF56,BodyUDF57,BodyUDF58,BodyUDF59,BodyUDF60,BodyUDF61,BodyUDF62 ) values( '409559','1','CC01','21120008','0001',null,'笔记本电脑',null,'1','台','CB01','21120007','0001','20211231','1','1','0','5880','5880','0','0',null,'N','N','0','N','Y','N','N','品保部梁小红',null,null,null,null,null,'N','5203.54','676.46','5203.54','676.46',null,'0','0',null,null,null,'0','0','0',null,null,null,null,null,null,null,null,null,null,null,null,'0','0','0','0','0','0','0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 10:41:32 Type: StartNode Message: 1 ----------------------------------------------------------- Time: 2021/12/31 10:41:32 Type: StartNode Message: 2 ----------------------------------------------------------- Time: 2021/12/31 10:41:32 Type: StartNode Message: 3 ----------------------------------------------------------- Time: 2021/12/31 10:42:17 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 10:42:17 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 10:42:24 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 10:42:24 Type: 单身数据保存取数2 Message: yfasti23_b ----------------------------------------------------------- Time: 2021/12/31 10:42:24 Type: 单身数据保存SQL语句 Message: insert into yfasti23_b (TaskId,GridOrder,tp005,tp001,tp002,tp007,tp008,tp013,tp028 ) values( '409559','1','笔记本电脑','CC01','21120008','1','台','1','品保部梁小红'); ----------------------------------------------------------- Time: 2021/12/31 10:42:24 Type: 调用接口返回成功 Message: 409559,调用流程Guid：8b1daf8f-b3d8-41f1-900b-f433b832b7b8 ----------------------------------------------------------- Time: 2021/12/31 10:42:26 Type: 调用接口返回成功 Message: 409559,调用易飞ERP审核源审核成功！ ----------------------------------------------------------- Time: 2021/12/31 13:42:16 Type: 单头数据保存SQL语句 Message: insert into YFPURI05 (taskId,TA001,TA002,TA003,TA004,TA005,TA006,TA007,TA008,TA009,TA010,TA011,TA012,TA013,TA014,TA015,TA016,TA017,TA018,TA019,TA020,TA021,TA022,TA023,TA024,TA025,HeadUDF01,HeadUDF02,HeadUDF03,HeadUDF04,HeadUDF05,HeadUDF06,HeadUDF07,HeadUDF08,HeadUDF09,HeadUDF10,HeadUDF11,HeadUDF12,HeadUDF51,HeadUDF52,HeadUDF53 ) values('409560','311请购单','21120296','20211231','0200','','','N','0','9','101','3000','','20211231','','0','S','0','','','','0','0','0','0','','','1321','唐彩霞','','','','','','','','','','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 13:42:16 Type: 单身数据保存取数1 Message: True ----------------------------------------------------------- Time: 2021/12/31 13:42:16 Type: 单身数据保存取数2 Message: YFPURI05_B ----------------------------------------------------------- Time: 2021/12/31 13:42:16 Type: 单身数据保存SQL语句 Message: insert into YFPURI05_B (TaskId,GridOrder,TB001,TB002,TB003,TB004,TB005,TB006,TB007,TB008,TB009,TB010,TB011,TB012,TB013,TB014,TB015,TB016,TB017,TB018,TB019,TB020,TB021,TB022,TB023,TB024,TB025,TB026,TB027,TB028,TB029,TB030,TB031,TB032,TB033,TB034,TB035,TB036,TB037,TB038,TB039,TB040 ) values( '409560','1','311','21120296','0001','31050160035','珍珠棉袋','珍珠棉袋340*230*0.5MM(340边开口)','PCS','115包材仓','3000',null,'20220105','SK3371 TOP_CASE工程吴云翔12/30邮件通知请购(库存0在途0)',null,'3000','PCS',null,'0','0','20220105','N','N',null,null,'SK3371 TOP_CASE工程吴云翔12/30邮件通知请购(库存0在途0)','N','1',null,null,null,null,null,'N',null,'0','0',null,null,null,'N','0'); ----------------------------------------------------------- Time: 2021/12/31 13:42:16 Type: StartNode Message: 1 ----------------------------------------------------------- Time: 2021/12/31 13:42:16 Type: StartNode Message: 2 ----------------------------------------------------------- Time: 2021/12/31 13:42:16 Type: StartNode Message: 3 ----------------------------------------------------------- Time: 2021/12/31 13:49:12 Type: 单头数据保存SQL语句 Message: insert into YFPURI05 (taskId,TA001,TA002,TA003,TA004,TA005,TA006,TA007,TA008,TA009,TA010,TA011,TA012,TA013,TA014,TA015,TA016,TA017,TA018,TA019,TA020,TA021,TA022,TA023,TA024,TA025,HeadUDF01,HeadUDF02,HeadUDF03,HeadUDF04,HeadUDF05,HeadUDF06,HeadUDF07,HeadUDF08,HeadUDF09,HeadUDF10,HeadUDF11,HeadUDF12,HeadUDF51,HeadUDF52,HeadUDF53 ) values('409561','311请购单','21120297','20211231','0200','','','N','0','9','101','10000','','20211231','','0','S','0','','','','0','0','0','0','','','1321','唐彩霞','','','','','','','','','','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 13:49:12 Type: 单身数据保存取数1 Message: True ----------------------------------------------------------- Time: 2021/12/31 13:49:12 Type: 单身数据保存取数2 Message: YFPURI05_B ----------------------------------------------------------- Time: 2021/12/31 13:49:12 Type: 单身数据保存SQL语句 Message: insert into YFPURI05_B (TaskId,GridOrder,TB001,TB002,TB003,TB004,TB005,TB006,TB007,TB008,TB009,TB010,TB011,TB012,TB013,TB014,TB015,TB016,TB017,TB018,TB019,TB020,TB021,TB022,TB023,TB024,TB025,TB026,TB027,TB028,TB029,TB030,TB031,TB032,TB033,TB034,TB035,TB036,TB037,TB038,TB039,TB040 ) values( '409561','1','311','21120297','0001','31030100069','PE袋','PE袋300*100*0.02MM(100边开口)','PCS','115包材仓','10000',null,'20220105','TEXAS/FINTOPL2212112004590(库存26800在途48000)',null,'10000','PCS',null,'0','0','20220105','N','N',null,null,'TEXAS/FINTOPL2212112004590(库存26800在途48000)','N','1',null,null,null,null,null,'N',null,'0','0',null,null,null,'N','0'); ----------------------------------------------------------- Time: 2021/12/31 13:49:12 Type: StartNode Message: 1 ----------------------------------------------------------- Time: 2021/12/31 13:49:12 Type: StartNode Message: 2 ----------------------------------------------------------- Time: 2021/12/31 13:49:12 Type: StartNode Message: 3 ----------------------------------------------------------- Time: 2021/12/31 14:08:59 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 14:09:00 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 14:09:05 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 14:09:05 Type: 单身数据保存取数2 Message: yfpuri05_b ----------------------------------------------------------- Time: 2021/12/31 14:09:05 Type: 单身数据保存SQL语句 Message: insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409560','1','31050160035','311','21120296','珍珠棉袋','珍珠棉袋340*230*0.5MM(340边开口)','PCS','115包材仓','3000','20220105','SK3371 TOP_CASE工程吴云翔12/30邮件通知请购(库存0在途0)'); ----------------------------------------------------------- Time: 2021/12/31 14:09:10 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 14:09:10 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 14:09:14 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 14:09:14 Type: 单身数据保存取数2 Message: yfpuri05_b ----------------------------------------------------------- Time: 2021/12/31 14:09:14 Type: 单身数据保存SQL语句 Message: insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409561','1','31030100069','311','21120297','PE袋','PE袋300*100*0.02MM(100边开口)','PCS','115包材仓','10000','20220105','TEXAS/FINTOPL2212112004590(库存26800在途48000)'); ----------------------------------------------------------- Time: 2021/12/31 14:58:32 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 14:58:32 Type: 单身数据保存取数2 Message: yfpuri05_b ----------------------------------------------------------- Time: 2021/12/31 14:58:32 Type: 单身数据保存SQL语句 Message: insert into yfpuri05_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb008,tb009,tb010,tb011,tb012,tb013,tb014,tb015,tb016,tb017,tb018,tb019,tb020,tb021,tb022,tb023,tb024,tb025,tb026,tb027,tb028,tb029,tb030,tb031,tb032,tb033,tb034,tb035,tb036,tb037,tb038,tb039,tb040,tb041,tb042,tb043,tb044,tb045,tb046,tb047,tb048,tb049,tb050,tb051,tb052,tb053,tb054,tb055,tb056,tbc01,tb057,tb058,tb059,tb060,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62 ) values( '409561','1',null,null,null,null,'311','21120297',null,'31030100069','PE袋','PE袋300*100*0.02MM(100边开口)','PCS','115包材仓','10000',null,'20220105',null,null,'0',null,null,'0','0',null,null,null,null,null,'TEXAS/FINTOPL2212112004590(库存26800在途48000)',null,null,null,null,null,null,null,null,null,'0','0',null,null,null,null,'0','0',null,null,'0','0','0','0','0',null,null,null,'0','0','0',null,'0',null,null,null,null,null,null,null,null,null,null,null,'0','0','0','0','0','0',null,null,null,null,null,null,'0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 14:58:32 Type: 调用接口返回成功 Message: 409561,调用流程Guid：8a11e072-9b81-48f8-a657-f50245ccedad ----------------------------------------------------------- Time: 2021/12/31 14:58:34 Type: 调用接口返回成功 Message: 409561,调用易飞ERP审核源审核成功！ ----------------------------------------------------------- Time: 2021/12/31 14:58:43 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 14:58:43 Type: 单身数据保存取数2 Message: yfpuri05_b ----------------------------------------------------------- Time: 2021/12/31 14:58:43 Type: 单身数据保存SQL语句 Message: insert into yfpuri05_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb008,tb009,tb010,tb011,tb012,tb013,tb014,tb015,tb016,tb017,tb018,tb019,tb020,tb021,tb022,tb023,tb024,tb025,tb026,tb027,tb028,tb029,tb030,tb031,tb032,tb033,tb034,tb035,tb036,tb037,tb038,tb039,tb040,tb041,tb042,tb043,tb044,tb045,tb046,tb047,tb048,tb049,tb050,tb051,tb052,tb053,tb054,tb055,tb056,tbc01,tb057,tb058,tb059,tb060,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62 ) values( '409560','1',null,null,null,null,'311','21120296',null,'31050160035','珍珠棉袋','珍珠棉袋340*230*0.5MM(340边开口)','PCS','115包材仓','3000',null,'20220105',null,null,'0',null,null,'0','0',null,null,null,null,null,'SK3371 TOP_CASE工程吴云翔12/30邮件通知请购(库存0在途0)',null,null,null,null,null,null,null,null,null,'0','0',null,null,null,null,'0','0',null,null,'0','0','0','0','0',null,null,null,'0','0','0',null,'0',null,null,null,null,null,null,null,null,null,null,null,'0','0','0','0','0','0',null,null,null,null,null,null,'0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 14:58:43 Type: 调用接口返回成功 Message: 409560,调用流程Guid：8a11e072-9b81-48f8-a657-f50245ccedad ----------------------------------------------------------- Time: 2021/12/31 14:58:45 Type: 调用接口返回成功 Message: 409560,调用易飞ERP审核源审核成功！ ----------------------------------------------------------- Time: 2021/12/31 15:03:24 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 15:03:24 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 15:09:45 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 15:09:46 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 15:12:32 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 15:12:32 Type: 单身数据保存取数2 Message: purab ----------------------------------------------------------- Time: 2021/12/31 15:12:33 Type: 单身数据保存SQL语句 Message: insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409343','1','1','40001603721','机械手治具','模号3655/KEY_PLATE/SM8123','PCS','1.00','2000.0000','2000.00','1','BZ4232','邦众','月结120天','可抵扣专票','Y','RMB','5-7天','2021-12-28','2022-06-28','注塑部','N','N','BZ4232','邦众','0.13','2000.0000','YY4412','毅优','0.13','2650.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409343','2','2','40001603722','机械手治具','模号3656/TOP_CASE/SM8123','PCS','1.00','2000.0000','2000.00','1','BZ4232','邦众','月结120天','可抵扣专票','Y','RMB','5-7天','2021-12-28','2022-06-28','注塑部','N','N','BZ4232','邦众','0.13','2000.0000','YY4412','毅优','0.13','2950.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409343','3','3','40001601660','连接线','杂项/天行机械手手控器含连接头/2米','米','5.00','1200.0000','6000.00','1','BZ4232','邦众','月结120天','可抵扣专票','Y','RMB','2-3天','2021-12-28','2022-06-28','注塑部，维修机械手,机械手专用','N','N','BZ4232','邦众','0.13','1200.0000','0.00','0.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409343','4','4','40001601625','转盘夹','杂项/双色FCS260T用','套','1.00','3000.0000','3000.00','1','FZ4254','福澤','月结120天','可抵扣专票','Y','RMB','2-3天','2021-12-28','2022-06-28','注塑部 B厂','N','N','FZ4254','福澤','0.13','3000.0000','SF4389','森丰','0.13','4350.0000','0.00','0.0000','0.00','0.0000'); ----------------------------------------------------------- Time: 2021/12/31 15:12:43 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 15:12:43 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 15:13:03 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 15:13:03 Type: 单身数据保存取数2 Message: purab ----------------------------------------------------------- Time: 2021/12/31 15:13:03 Type: 单身数据保存SQL语句 Message: insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409344','1','1','40001602702','手环喷咀','机械手全自动喷脱膜系统','PCS','5.00','3600.0000','18000.00','1','BZ4232','邦众','月结120天','可抵扣专票','Y','RMB','2-3天','2021-12-28','2022-06-28','注塑部 D03/3430机械手上使用,19年有购买','N','N','BZ4232','邦众','0.13','3600.0000','0.00','0.0000','0.00','0.0000','0.00','0.0000'); ----------------------------------------------------------- Time: 2021/12/31 15:13:08 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 15:13:09 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 15:19:53 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 15:19:53 Type: 单身数据保存取数2 Message: purab ----------------------------------------------------------- Time: 2021/12/31 15:19:53 Type: 单身数据保存SQL语句 Message: insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409363','1','1','40001400226','条码打印机碳带','消耗品/G-2108/宽110MM','个','1.00','39.0000','39.00','1','RX2158','荣信','月结120天','可抵扣专票','Y','RMB','2-3天','2021-12-28','2022-06-28','注塑部 打印二维码， 生产急用，已安排厂商送，按之前单价购买','N','N','RX2158','荣信','0.13','39.0000','0.00','0.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb036c,tb036,tb037,tb038,tb040,tb041 ) values( '409363','2','2','40001600142','硬胶剪钳','杂项/','把','20.00','32.0000','640.00','1','DX4325','东鑫','月结120天','可抵扣专票','Y','RMB','2-3天','2021-12-28','2022-06-28','谢坑注塑，消耗品','N','N','DX4325','东鑫','0.01','32.0000','KL4127','科隆','0.13','36.0000','RX2158','荣信','0.13','36.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb036c,tb036,tb037,tb038,tb040,tb041 ) values( '409363','3','3','40001500219','话筒','先科/无线/U段话筒一拖二无线麦克风/OK66黑色-双手持话筒','个','1.00','850.0000','850.00','1','KL4127','科隆','月结120天','可抵扣专票','Y','RMB','2-3天','2021-12-28','2022-06-28','谢坑注塑，消耗品','N','N','KL4127','科隆','0.13','850.0000','DX4325','东鑫','0.01','950.0000','RX2158','荣信','0.13','1080.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb036c,tb036,tb037,tb038,tb040,tb041 ) values( '409363','4','4','40001400716','洗洁精','瓶/1KG','瓶','10.00','13.5000','135.00','1','DX4325','东鑫','月结120天','可抵扣专票','Y','RMB','2-3天','2021-12-28','2022-06-28','谢坑注塑，消耗品','N','N','DX4325','东鑫','0.01','13.5000','KL4127','科隆','0.13','15.0000','RX2158','荣信','0.13','16.5000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb036c,tb036,tb037,tb038,tb040,tb041 ) values( '409363','5','5','40001200043','发热圈','机械设备/机器配件/44*35 380V','个','10.00','8.5000','85.00','1','DX4325','东鑫','月结120天','可抵扣专票','Y','RMB','2-3天','2021-12-28','2022-06-28','谢坑注塑，消耗品','N','N','DX4325','东鑫','0.01','8.5000','KL4127','科隆','0.13','11.0000','RX2158','荣信','0.13','10.5000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb036c,tb036,tb037,tb038,tb040,tb041 ) values( '409363','6','6','40001600143','水口钳','杂项/MTC-22 150mm','把','3.00','16.4200','49.26','1','KL4127','科隆','月结120天','可抵扣专票','Y','RMB','2-3天','2021-12-28','2022-06-28','谢坑注塑，消耗品','N','N','KL4127','科隆','0.13','16.4200','KL4127','科隆','0.13','20.0000','RX2158','荣信','0.13','21.7000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb036c,tb036,tb037,tb038,tb040,tb041 ) values( '409363','7','7','40001603725','高压水枪头','短枪/外丝22*内孔15MM','PCS','1.00','69.0000','69.00','1','DX4325','东鑫','月结120天','可抵扣专票','Y','RMB','2-3天','2021-12-28','2022-06-28','谢坑注塑，消耗品','N','N','DX4325','东鑫','0.01','69.0000','KL4127','科隆','0.13','90.0000','RX2158','荣信','0.13','88.0000','0.00','0.0000'); ----------------------------------------------------------- Time: 2021/12/31 15:20:10 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 15:20:10 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 15:27:39 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 15:27:39 Type: 单身数据保存取数2 Message: purab ----------------------------------------------------------- Time: 2021/12/31 15:27:40 Type: 单身数据保存SQL语句 Message: insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409361','1','1','40001603463','射嘴','56*130MM/子母式/伊之密机台专用','PCS','2.00','560.0000','1120.00','1','SF4389','森丰','月结90天','可抵扣专票','Y','RMB','7-10天','2021-12-28','2022-06-28','注塑部','N','N','SF4389','森丰','0.13','560.0000','FZ4254','福澤','0.13','800.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409361','2','2','40001603718','火箭头组','直径68*180MM/PC+ABS进口材质','PCS','1.00','1700.0000','1700.00','1','SF4389','森丰','月结90天','可抵扣专票','Y','RMB','7-10天','2021-12-28','2022-06-28','注塑部','N','N','SF4389','森丰','0.13','1700.0000','FZ4254','福澤','0.13','1800.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409361','3','3','40001603719','火箭头组','直径76*180MM/PC+ABS进口材质','PCS','1.00','1800.0000','1800.00','1','SF4389','森丰','月结90天','可抵扣专票','Y','RMB','7-10天','2021-12-28','2022-06-28','注塑部','N','N','SF4389','森丰','0.13','1800.0000','FZ4254','福澤','0.13','2000.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409361','4','4','40001603728','射嘴','30*60MM/加硬电镀进口材质生产PC透明','PCS','1.00','650.0000','650.00','1','SF4389','森丰','月结90天','可抵扣专票','Y','RMB','7-10天','2021-12-28','2022-06-28','谢坑注塑，消耗品','N','N','SF4389','森丰','0.13','650.0000','FZ4254','福澤','0.13','700.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409361','5','5','40001603474','发热圈','40*100MM/FNK/200V/400W','PCS','5.00','300.0000','1500.00','1','SF4389','森丰','月结90天','可抵扣专票','Y','RMB','2-3天','2021-12-28','2022-06-28','注塑部 FUNAC机台专用','N','N','SF4389','森丰','0.13','300.0000','BK4294','必凯','0.01','430.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409361','6','6','40001601399','同步带','杂项/长1450*宽16*厚6MM','条','3.00','130.0000','390.00','1','BK4294','必凯','月结120天','可抵扣专票','Y','RMB','2-3天','2021-12-28','2022-06-28','注塑部 机械手','N','N','BK4294','必凯','0.01','130.0000','SF4389','森丰','0.13','185.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409361','7','7','40001603443','磁力架','5管强磁','PCS','2.00','160.0000','320.00','1','SF4389','森丰','月结90天','可抵扣专票','Y','RMB','2-3天','2021-12-28','2022-06-28','谢坑注塑，消耗品','N','N','SF4389','森丰','0.13','160.0000','BK4294','必凯','0.01','185.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb000,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb015,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb033c,tb033,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409361','8','8','40001603351','自动吸料电眼小料斗','220V/容量6L','台','1.00','2100.0000','2100.00','1','FZ4254','福澤','月结120天','可抵扣专票','Y','RMB','7-10天','2021-12-28','2022-06-28','谢坑注塑，H1','N','N','FZ4254','福澤','0.13','2100.0000','BZ4232','邦众','0.13','2600.0000','0.00','0.0000','0.00','0.0000'); ----------------------------------------------------------- Time: 2021/12/31 15:27:48 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 15:27:48 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 15:27:54 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 15:27:54 Type: 单身数据保存取数2 Message: yfpuri05_b ----------------------------------------------------------- Time: 2021/12/31 15:27:55 Type: 单身数据保存SQL语句 Message: insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409454','1','40001603476','311','21120270','探温线','K型/长2M/含接头/FNK','PCS','148生产耗材仓','5','20220110','注塑部,机台接信号线');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409454','2','40001601462','311','21120270','电缆线','杂项/2芯*0.75平方','米','148生产耗材仓','100','20220110','注塑部,机台接信号线');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409454','3','40001701106','311','21120270','电缆线','工务用品/1.5MM2/3芯/100米','卷','148生产耗材仓','1','20220110','注塑部，模温机使用');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409454','4','40001600140','311','21120270','软胶剪钳','杂项/（黄色）TR-25-P','把','148生产耗材仓','20','20220110','注塑部');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409454','5','40001600141','311','21120270','90度弯剪胶','杂项/（白色）SP-22','把','148生产耗材仓','30','20220110','注塑部');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409454','6','40001600148','311','21120270','美工刀架','杂项/小号','把','148生产耗材仓','50','20220110','注塑部');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409454','7','40001400192','311','21120270','吸盘二层','消耗品/ψ15MM','PCS','148生产耗材仓','200','20220110','注塑，二层/三层各100个');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409454','8','40001400193','311','21120270','吸盘二层','消耗品/ψ20MM','PCS','148生产耗材仓','100','20220110','注塑部，蒲勇全');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409454','9','40001400198','311','21120270','吸盘三层','消耗品/ψ5MM','PCS','148生产耗材仓','50','20220110','注塑部，二层');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409454','10','40001400199','311','21120270','吸盘三层','消耗品/ψ10MM','PCS','148生产耗材仓','100','20220110','注塑部，蒲勇全');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409454','11','40001603385','311','21120270','吸盘','6MM/两层/附样','PCS','148生产耗材仓','100','20220110','注塑部，蒲勇全'); ----------------------------------------------------------- Time: 2021/12/31 15:28:00 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 15:28:00 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 15:28:04 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 15:28:04 Type: 单身数据保存取数2 Message: yfpuri05_b ----------------------------------------------------------- Time: 2021/12/31 15:28:04 Type: 单身数据保存SQL语句 Message: insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409539','1','40001603738','311','21120265','接水口料滑槽','不锈钢/1400mm*1200mm*500mm','个','148生产耗材仓','1','20220105','注塑部');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409539','2','40001603739','311','21120265','接水口料箱','塑胶/500mm*400mm*200mm','个','148生产耗材仓','1','20220105','注塑部');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409539','3','40001400719','311','21120265','海绵头','SK2075海棉头/6.40*6.40MM(R0-R4区键孔使用）','PCS','148生产耗材仓','100','20220105','注塑部');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409539','4','40001400720','311','21120265','海绵头','SK2075海棉头/11.70*3.30MM(FN区键孔使用）','PCS','148生产耗材仓','50','20220105','注塑部'); ----------------------------------------------------------- Time: 2021/12/31 15:29:00 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 15:29:00 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 15:42:30 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 15:42:31 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 15:44:13 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 15:44:13 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 15:45:41 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 15:45:41 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 15:49:47 Type: 单头数据保存SQL语句 Message: insert into guraa (taskId,ta001,ta001c,ta003,ta002,ta002c,ta004,ta005,ta006,ta007,ta008 ) values('409562','王小艳','220','2021-12-31','采购课','1006','','SK9590NB 字键组装机','[]','1.00','190000.00'); ----------------------------------------------------------- Time: 2021/12/31 15:49:47 Type: 单身数据保存取数1 Message: True ----------------------------------------------------------- Time: 2021/12/31 15:49:47 Type: 单身数据保存取数2 Message: gurab ----------------------------------------------------------- Time: 2021/12/31 15:49:47 Type: 单身数据保存SQL语句 Message: insert into gurab (TaskId,GridOrder,tb002,tb003,tb004,tb005,tb006,tb008c,tb008,tb009,tb0010,tb0011,tb0012,tb0013,tb0014,tb0017a,tb0017,tb0017b,tb0017c,tb018a,tb018,tb018b,tb0018c,tb019b,tb019c,tb020b,tb020c ) values( '409562','1','SK9590NB 字键组装机','/','台','1.00','190000.000','HY4448','鸿耀','2月25日付30%，尾款70%验收OK后月结30天','可抵扣专票','Y','RMB','45天','2021-12-31','HY4448','鸿耀','0.13','190000.000','DJ4444','大江','0.13','310000.000','0.00','0.000','0.00','0.000'); ----------------------------------------------------------- Time: 2021/12/31 15:49:47 Type: StartNode Message: 1 ----------------------------------------------------------- Time: 2021/12/31 15:49:47 Type: StartNode Message: 2 ----------------------------------------------------------- Time: 2021/12/31 15:49:47 Type: StartNode Message: 3 ----------------------------------------------------------- Time: 2021/12/31 15:55:57 Type: 单头数据保存SQL语句 Message: insert into YFASTI22 (taskId,TM001,TM002,TM003,TM004,TM005,TM006,TM007,TM008,TM009,TM010,TM011,TM012,TM013,TM014,TM015,TM016,TM017,TM018,TM019,TM020,TM021,TM022,TM023,TM024,TM025,TM026,TM027,TM028,TM029,TM030,TM031,TM032,HeadUDF01,HeadUDF02,HeadUDF03,HeadUDF04,HeadUDF05,HeadUDF06,HeadUDF07,HeadUDF08,HeadUDF09,HeadUDF10,HeadUDF11,HeadUDF12,HeadUDF51,HeadUDF52,HeadUDF53,HeadUDF54,HeadUDF55,HeadUDF56,HeadUDF57,HeadUDF58,HeadUDF59,HeadUDF60,HeadUDF61,HeadUDF62 ) values('409563','CB01资产采购单','21120008','20211231','20211231','HY4448鸿耀','RMB','1','','108依合同','','101','25517王小艳','1','0','N','1','0.13','168141.59','21858.41','0','0','1','','S','0','0','','','','0','0','0','','','','','','','','','','','','','0','0','0','0','0','0','0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 15:55:57 Type: 单身数据保存取数1 Message: True ----------------------------------------------------------- Time: 2021/12/31 15:55:57 Type: 单身数据保存取数2 Message: YFASTI22_B ----------------------------------------------------------- Time: 2021/12/31 15:55:58 Type: 单身数据保存SQL语句 Message: insert into YFASTI22_B (TaskId,GridOrder,TN001,TN002,TN003,TN004,TN005,TN006,TN007,TN008,TN009,TN010,TN011,TN012,TN013,TN014,TN015,TN016,TN017,TN018,TN019,TN020,TN021,TN022,TN023,TN024,TN025,TN026,BodyUDF01,BodyUDF02,BodyUDF03,BodyUDF04,BodyUDF05,BodyUDF06,BodyUDF07,BodyUDF08,BodyUDF09,BodyUDF10,BodyUDF11,BodyUDF12,BodyUDF51,BodyUDF52,BodyUDF53,BodyUDF54,BodyUDF55,BodyUDF56,BodyUDF57,BodyUDF58,BodyUDF59,BodyUDF60,BodyUDF61,BodyUDF62 ) values( '409563','1','CB01','21120008','0001','SK9590NB字鍵組裝機','SK9590NB字鍵組裝機(含治具自動)','1','工程','190000','190000','叶宝林SK9590','0','N','N',null,'20220214','CA01','21120003','0001','1004',null,null,null,null,'0','0','0',null,null,null,null,null,null,null,null,null,null,null,null,'0','0','0','0','0','0','0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 15:55:58 Type: StartNode Message: 1 ----------------------------------------------------------- Time: 2021/12/31 15:55:58 Type: StartNode Message: 2 ----------------------------------------------------------- Time: 2021/12/31 15:55:58 Type: StartNode Message: 3 ----------------------------------------------------------- Time: 2021/12/31 16:13:50 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 16:13:51 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 16:13:55 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 16:13:55 Type: 单身数据保存取数2 Message: yfpuri05_b ----------------------------------------------------------- Time: 2021/12/31 16:13:55 Type: 单身数据保存SQL语句 Message: insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409545','1','31010220094','311','21120287','纸箱','K=K/730*450*440MM有字纸箱','PCS','115包材仓','700','20220104','RUGBY/REARCABINET21921120083库存460在途(1450)');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409545','2','31020100033','311','21120287','吸塑盒','吸塑盒/PVC/KB-11','PCS','115包材仓','300','20220104','SM3371/SM3372/WHEELGRAY/WHEELTEAL22121120232库存1061在途0');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409545','3','31090200114','311','21120287','保护膜','PE中粘保护膜/121MM*0.05MM*200M','卷','115包材仓','24','20220104','SM3360/SKIRTBLACK22121120232库存44在途(131)');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409545','4','31020100322','311','21120287','吸塑盒','吸塑盒/FC-04','PCS','115包材仓','1000','20220104','CALAMARI/BATTERYHOUSING22121120230库存1072 在途0');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409545','5','31100100001','311','21120287','拉伸膜','拉伸膜/PE/50CM*150M','卷','115包材仓','2000','20220104','通用(库存156在途300)');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409545','6','31030100069','311','21120287','PE袋','PE袋300*100*0.02MM(100边开口)','PCS','115包材仓','10000','20220104','TEXAS/FINTOPL22121120045(库存26800在途48000)');insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409545','7','31020100680','311','21120287','吸塑盒','吸塑盒_TP-08','PCS','115包材仓','100','20220104','PUFFERFISH/BUTTONACTION512-22010334(库存272在途400)'); ----------------------------------------------------------- Time: 2021/12/31 16:14:00 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 16:14:00 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 16:14:03 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 16:14:03 Type: 单身数据保存取数2 Message: yfpuri05_b ----------------------------------------------------------- Time: 2021/12/31 16:14:03 Type: 单身数据保存SQL语句 Message: insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409546','1','30250240001','311','21120292','塑胶原料PBT','PBT/CCP/1100-200A/BLACK','KG','103原料仓','1000','20220107','22121120217'); ----------------------------------------------------------- Time: 2021/12/31 16:14:36 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 16:14:36 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 16:14:40 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 16:14:40 Type: 单身数据保存取数2 Message: yfpuri05_b ----------------------------------------------------------- Time: 2021/12/31 16:14:40 Type: 单身数据保存SQL语句 Message: insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409561','1','31030100069','311','21120297','PE袋','PE袋300*100*0.02MM(100边开口)','PCS','115包材仓','10000','20220105','TEXAS/FINTOPL2212112004590(库存26800在途48000)'); ----------------------------------------------------------- Time: 2021/12/31 16:14:47 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 16:14:48 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 16:14:51 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2021/12/31 16:14:51 Type: 单身数据保存取数2 Message: yfpuri05_b ----------------------------------------------------------- Time: 2021/12/31 16:14:51 Type: 单身数据保存SQL语句 Message: insert into yfpuri05_b (TaskId,GridOrder,tb004,tb001,tb002,tb005,tb006,tb007,tb008,tb009,tb011,tb024 ) values( '409560','1','31050160035','311','21120296','珍珠棉袋','珍珠棉袋340*230*0.5MM(340边开口)','PCS','115包材仓','3000','20220105','SK3371 TOP_CASE工程吴云翔12/30邮件通知请购(库存0在途0)'); ----------------------------------------------------------- Time: 2021/12/31 16:17:24 Type: 单头数据保存SQL语句 Message: insert into YFPURI07 (taskId,TC001,TC002,TC003,TC004,TC005,TC006,TC007,TC008,TC009,TC010,TC011,TC012,TC013,TC014,TC015,TC016,TC017,TC018,TC019,TC020,TC021,TC022,TC023,TC024,TC025,TC026,TC027,TC028,TC029,TC030,TC031,TC032,TC033,TC034,TC035,TC036,TC037,TC038,TC039,TC040,TC041,TC042,TC043,TC044,TC045,TC046,TC047,TC299,TCD01,HeadUDF01,HeadUDF02,HeadUDF03,HeadUDF04,HeadUDF05,HeadUDF06,HeadUDF07,HeadUDF08,HeadUDF09,HeadUDF10,HeadUDF11,HeadUDF12,HeadUDF51,HeadUDF52,HeadUDF53,HeadUDF54,HeadUDF55,HeadUDF56,HeadUDF57,HeadUDF58,HeadUDF59,HeadUDF60,HeadUDF61,HeadUDF62 ) values('409564','331采购单','21120497','20211231','HZ1377合芝富','RMB','1','','','','101','1321唐彩霞','1','0','N','','','','1','238.94','31.06','','','10000','20211231','','0.13','105','0','0','S','0','','N','','N','','','0','0','0','','','0','0','0','','','','N','','','','','','','','','','','','','0','0','0','0','0','0','0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 16:17:24 Type: 单身数据保存取数1 Message: True ----------------------------------------------------------- Time: 2021/12/31 16:17:24 Type: 单身数据保存取数2 Message: YFPURI07_B ----------------------------------------------------------- Time: 2021/12/31 16:17:24 Type: 单身数据保存SQL语句 Message: insert into YFPURI07_B (TaskId,GridOrder,TD001,TD002,TD003,TD004,TD005,TD006,TD007,TD008,TD009,TD010,TD011,TD012,TD013,TD014,TD015,TD016,TD017,TD018,TD019,TD020,TD021,TD022,TD023,TD024,TD025,TD026,TD027,TD028,TD029,TD030,TD031,TD032,TD033,TD034,TD035,TD036,TD037,TD038,TD039,TD040,TD041,TD042,TD043,TD044,TD045,TD046,TD047,TD048,TD049,TD050,TD051,TD299,TDC01,TDC02,TDC03,TDC04,TDC05,TDC06,BodyUDF01,BodyUDF02,BodyUDF03,BodyUDF04,BodyUDF05,BodyUDF06,BodyUDF07,BodyUDF08,BodyUDF09,BodyUDF10,BodyUDF11,BodyUDF12,BodyUDF51,BodyUDF52,BodyUDF53,BodyUDF54,BodyUDF55,BodyUDF56,BodyUDF57,BodyUDF58,BodyUDF59,BodyUDF60,BodyUDF61,BodyUDF62 ) values( '409564','1','331','21120497','0001','31030100069','PE袋','PE袋300*100*0.02MM(100边开口)','115包材仓','10000','PCS','0.027','270','20220105',null,'TEXAS/FINTOPL2212112004590(库存26800在途48000)','0','N',null,'N','0',null,null,null,null,null,'N','311','21120297','0001',null,'0','0',null,'0.13','238.94','31.06','0','0','PCS','10000',null,null,null,null,null,'0','0','0','0','0',null,null,null,'0','0','2','0','0','0',null,null,null,null,null,null,null,null,null,null,null,null,'0','0','0','0','0','0','0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 16:17:24 Type: StartNode Message: 1 ----------------------------------------------------------- Time: 2021/12/31 16:17:24 Type: StartNode Message: 2 ----------------------------------------------------------- Time: 2021/12/31 16:17:24 Type: StartNode Message: 3 ----------------------------------------------------------- Time: 2021/12/31 16:17:59 Type: 单头数据保存SQL语句 Message: insert into YFPURI07 (taskId,TC001,TC002,TC003,TC004,TC005,TC006,TC007,TC008,TC009,TC010,TC011,TC012,TC013,TC014,TC015,TC016,TC017,TC018,TC019,TC020,TC021,TC022,TC023,TC024,TC025,TC026,TC027,TC028,TC029,TC030,TC031,TC032,TC033,TC034,TC035,TC036,TC037,TC038,TC039,TC040,TC041,TC042,TC043,TC044,TC045,TC046,TC047,TC299,TCD01,HeadUDF01,HeadUDF02,HeadUDF03,HeadUDF04,HeadUDF05,HeadUDF06,HeadUDF07,HeadUDF08,HeadUDF09,HeadUDF10,HeadUDF11,HeadUDF12,HeadUDF51,HeadUDF52,HeadUDF53,HeadUDF54,HeadUDF55,HeadUDF56,HeadUDF57,HeadUDF58,HeadUDF59,HeadUDF60,HeadUDF61,HeadUDF62 ) values('409565','331采购单','21120414','20211225','BR1426BRIGHT','USD','6.3693','','','','101','1321唐彩霞','1','1','N','','','','3','16920','0','','','3000','20211225','','0','105','0','0','S','0','','N','','N','','','0','0','0','','','0','0','0','','','','N','','','','','','','','','','','','','0','0','0','0','0','0','0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 16:17:59 Type: 单身数据保存取数1 Message: True ----------------------------------------------------------- Time: 2021/12/31 16:17:59 Type: 单身数据保存取数2 Message: YFPURI07_B ----------------------------------------------------------- Time: 2021/12/31 16:17:59 Type: 单身数据保存SQL语句 Message: insert into YFPURI07_B (TaskId,GridOrder,TD001,TD002,TD003,TD004,TD005,TD006,TD007,TD008,TD009,TD010,TD011,TD012,TD013,TD014,TD015,TD016,TD017,TD018,TD019,TD020,TD021,TD022,TD023,TD024,TD025,TD026,TD027,TD028,TD029,TD030,TD031,TD032,TD033,TD034,TD035,TD036,TD037,TD038,TD039,TD040,TD041,TD042,TD043,TD044,TD045,TD046,TD047,TD048,TD049,TD050,TD051,TD299,TDC01,TDC02,TDC03,TDC04,TDC05,TDC06,BodyUDF01,BodyUDF02,BodyUDF03,BodyUDF04,BodyUDF05,BodyUDF06,BodyUDF07,BodyUDF08,BodyUDF09,BodyUDF10,BodyUDF11,BodyUDF12,BodyUDF51,BodyUDF52,BodyUDF53,BodyUDF54,BodyUDF55,BodyUDF56,BodyUDF57,BodyUDF58,BodyUDF59,BodyUDF60,BodyUDF61,BodyUDF62 ) values( '409565','1','331','21120414','0001','30030840004','塑胶原料PC ABS','PC ABS/LG/GN5001RFL/KA02_BLACK','103原料仓','3000','KG','5.64','16920','20220114',null,'22121120194/rumble','0','N',null,'N','0',null,null,null,null,null,'N','311','21120243','0001',null,'0','0',null,'0','16920','0','0','0','KG','3000',null,null,null,null,null,'0','0','0','0','0',null,null,null,'0','0','2','0','0','0',null,null,null,null,null,null,null,null,null,null,null,null,'0','0','0','0','0','0','0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 16:17:59 Type: StartNode Message: 1 ----------------------------------------------------------- Time: 2021/12/31 16:17:59 Type: StartNode Message: 2 ----------------------------------------------------------- Time: 2021/12/31 16:17:59 Type: StartNode Message: 3 ----------------------------------------------------------- Time: 2021/12/31 16:18:34 Type: 单头数据保存SQL语句 Message: insert into YFPURI07 (taskId,TC001,TC002,TC003,TC004,TC005,TC006,TC007,TC008,TC009,TC010,TC011,TC012,TC013,TC014,TC015,TC016,TC017,TC018,TC019,TC020,TC021,TC022,TC023,TC024,TC025,TC026,TC027,TC028,TC029,TC030,TC031,TC032,TC033,TC034,TC035,TC036,TC037,TC038,TC039,TC040,TC041,TC042,TC043,TC044,TC045,TC046,TC047,TC299,TCD01,HeadUDF01,HeadUDF02,HeadUDF03,HeadUDF04,HeadUDF05,HeadUDF06,HeadUDF07,HeadUDF08,HeadUDF09,HeadUDF10,HeadUDF11,HeadUDF12,HeadUDF51,HeadUDF52,HeadUDF53,HeadUDF54,HeadUDF55,HeadUDF56,HeadUDF57,HeadUDF58,HeadUDF59,HeadUDF60,HeadUDF61,HeadUDF62 ) values('409566','331采购单','21120489','20211230','BR1426BRIGHT','USD','6.3693','','','','101','1321唐彩霞','1','1','N','','','','3','52440','0','','','19000','20211230','','0','105','0','0','S','0','','N','','N','','','0','0','0','','','0','0','0','','','','N','','','','','','','','','','','','','0','0','0','0','0','0','0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 16:18:34 Type: 单身数据保存取数1 Message: True ----------------------------------------------------------- Time: 2021/12/31 16:18:34 Type: 单身数据保存取数2 Message: YFPURI07_B ----------------------------------------------------------- Time: 2021/12/31 16:18:34 Type: 单身数据保存SQL语句 Message: insert into YFPURI07_B (TaskId,GridOrder,TD001,TD002,TD003,TD004,TD005,TD006,TD007,TD008,TD009,TD010,TD011,TD012,TD013,TD014,TD015,TD016,TD017,TD018,TD019,TD020,TD021,TD022,TD023,TD024,TD025,TD026,TD027,TD028,TD029,TD030,TD031,TD032,TD033,TD034,TD035,TD036,TD037,TD038,TD039,TD040,TD041,TD042,TD043,TD044,TD045,TD046,TD047,TD048,TD049,TD050,TD051,TD299,TDC01,TDC02,TDC03,TDC04,TDC05,TDC06,BodyUDF01,BodyUDF02,BodyUDF03,BodyUDF04,BodyUDF05,BodyUDF06,BodyUDF07,BodyUDF08,BodyUDF09,BodyUDF10,BodyUDF11,BodyUDF12,BodyUDF51,BodyUDF52,BodyUDF53,BodyUDF54,BodyUDF55,BodyUDF56,BodyUDF57,BodyUDF58,BodyUDF59,BodyUDF60,BodyUDF61,BodyUDF62 ) values( '409566','1','331','21120489','0001','30010160009','塑胶原料ABS','ABS/BASF/GP22/NATURAL_RICE_WHITE','103原料仓','19000','KG','2.76','52440','20220110',null,'依照业务12/3F/C需求，全厂通用，整柜请购','0','N',null,'N','0',null,null,null,null,null,'N','311','21120060','0001',null,'0','0',null,'0','52440','0','0','0','KG','19000',null,null,null,null,null,'0','0','0','0','0',null,null,null,'0','0','2','0','0','0',null,null,null,null,null,null,null,null,null,null,null,null,'0','0','0','0','0','0','0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 16:18:34 Type: StartNode Message: 1 ----------------------------------------------------------- Time: 2021/12/31 16:18:34 Type: StartNode Message: 2 ----------------------------------------------------------- Time: 2021/12/31 16:18:34 Type: StartNode Message: 3 ----------------------------------------------------------- Time: 2021/12/31 16:28:07 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 16:28:07 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 16:32:36 Type: 单头数据保存SQL语句 Message: insert into puraa (taskId,ta001,ta001c,ta002,ta003,ta003c,ta004,tb009,ta010,ta013,ta013c,ta011,ta007,ta005,ta006 ) values('409567','周禕','623','2021-12-31','工程课','1004','','采购比价','B5B1','唐彩霞','206','采购件：嘉昌SK3371珍珠棉袋31050160035','[]','1.00','0.13'); ----------------------------------------------------------- Time: 2021/12/31 16:32:36 Type: 单身数据保存取数1 Message: True ----------------------------------------------------------- Time: 2021/12/31 16:32:36 Type: 单身数据保存取数2 Message: purab ----------------------------------------------------------- Time: 2021/12/31 16:32:36 Type: 单身数据保存SQL语句 Message: insert into purab (TaskId,GridOrder,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409567','1','31050160035','珍珠棉袋','珍珠棉袋340*230*0.5MM(340边开口)','PCS','1.00','0.1300','0.13','1000','JC1211','嘉昌','月结120天','可抵扣专票','Y','RMB','5天','2021-12-31','样品检测报告W-STR-01841','N','N','JC1211','嘉昌','0.13','0.1300','0.00','0.0000','0.00','0.0000','0.00','0.0000'); ----------------------------------------------------------- Time: 2021/12/31 16:32:36 Type: StartNode Message: 1 ----------------------------------------------------------- Time: 2021/12/31 16:32:36 Type: StartNode Message: 2 ----------------------------------------------------------- Time: 2021/12/31 16:32:36 Type: StartNode Message: 3 ----------------------------------------------------------- Time: 2021/12/31 16:33:33 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 16:33:33 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 16:39:18 Type: 开始 Message: 第一步:1 ----------------------------------------------------------- Time: 2021/12/31 16:39:18 Type: 执行 Message: Success ----------------------------------------------------------- Time: 2021/12/31 16:51:10 Type: 单头数据保存SQL语句 Message: insert into puraa (taskId,ta001,ta001c,ta002,ta003,ta003c,ta004,tb009,ta010,ta013,ta013c,ta011,ta007,ta005,ta006 ) values('409568','周禕','623','2021-12-31','工程课','1004','','委外比价','B5B1','唐彩霞','206','委外件：众鹰SK3872抽粒30010421001/30010451009/30010411013/30010451010/30010411012/30010461012','[]','7.00','20.80'); ----------------------------------------------------------- Time: 2021/12/31 16:51:10 Type: 单身数据保存取数1 Message: True ----------------------------------------------------------- Time: 2021/12/31 16:51:10 Type: 单身数据保存取数2 Message: purab ----------------------------------------------------------- Time: 2021/12/31 16:51:10 Type: 单身数据保存SQL语句 Message: insert into purab (TaskId,GridOrder,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409568','1','30010421001','塑胶原料ABS','ABS/CHIMEI/PA757/605C_YELLOW（加0.6%UV剂）','KG','1.00','3.2000','3.20','25','ZY1339','众鹰','月结120天','可抵扣专票','Y','RMB','5天','2021-12-31','样品检测报告W-STR-01734','N','N','ZY1339','众鹰','0.13','3.2000','0.00','0.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409568','2','30010451009','塑胶原料ABS','ABS/CHIMEI/PA757/BLUE（加0.6%UV剂）','KG','1.00','2.6000','2.60','25','ZY1339','众鹰','月结120天','可抵扣专票','Y','RMB','5天','2021-12-31','样品检测报告W-STR-01734','N','N','ZY1339','众鹰','0.13','2.6000','0.00','0.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409568','3','30010411013','塑胶原料ABS','ABS/CHIMEI/PA757/186C_RED（加0.6%UV剂）','KG','1.00','3.2000','3.20','25','ZY1339','众鹰','月结120天','可抵扣专票','Y','RMB','5天','2021-12-31','样品检测报告W-STR-01734','N','N','ZY1339','众鹰','0.13','3.2000','0.00','0.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409568','4','30010451010','塑胶原料ABS','ABS/CHIMEI/PA757/DARK_BLUE（加0.6%UV剂）','KG','1.00','2.6000','2.60','25','ZY1339','众鹰','月结120天','可抵扣专票','Y','RMB','5天','2021-12-31','样品检测报告W-STR-01734','N','N','ZY1339','众鹰','0.13','2.6000','0.00','0.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409568','5','30010411012','塑胶原料ABS','ABS/CHIMEI/PA757/ROSE（加0.6%UV剂）','KG','1.00','3.2000','3.20','25','ZY1339','众鹰','月结120天','可抵扣专票','Y','RMB','5天','2021-12-31','样品检测报告W-STR-01713','N','N','ZY1339','众鹰','0.13','3.2000','0.00','0.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409568','6','30010461012','塑胶原料ABS','ABS/CHIMEI/PA757/WHITE（加0.6%UV剂）','KG','1.00','2.8000','2.80','25','ZY1339','众鹰','月结120天','可抵扣专票','Y','RMB','5天','2021-12-31','样品检测报告W-STR-01713','N','N','ZY1339','众鹰','0.13','2.8000','0.00','0.0000','0.00','0.0000','0.00','0.0000');insert into purab (TaskId,GridOrder,tb001,tb002,tb003,tb004,tb005,tb006,tb007,tb042,tb008c,tb008,tb009,tb010,tb020,tb012,tb013,tb014,tb016,tb019,tb021,tb030c,tb030,tb031,tb032,tb034,tb035,tb037,tb038,tb040,tb041 ) values( '409568','7','30010411014','塑胶原料ABS','ABS/CHIMEI/PA757/DARK_RED（加0.6%UV剂）','KG','1.00','3.2000','3.20','25','ZY1339','众鹰','月结120天','可抵扣专票','Y','RMB','5天','2021-12-31','样品检测报告W-STR-01734','N','N','ZY1339','众鹰','0.13','3.2000','0.00','0.0000','0.00','0.0000','0.00','0.0000'); ----------------------------------------------------------- Time: 2021/12/31 16:51:10 Type: StartNode Message: 1 ----------------------------------------------------------- Time: 2021/12/31 16:51:10 Type: StartNode Message: 2 ----------------------------------------------------------- Time: 2021/12/31 16:51:10 Type: StartNode Message: 3 ----------------------------------------------------------- Time: 2021/12/31 17:17:51 Type: 单头数据保存SQL语句 Message: insert into YFPURI07 (taskId,TC001,TC002,TC003,TC004,TC005,TC006,TC007,TC008,TC009,TC010,TC011,TC012,TC013,TC014,TC015,TC016,TC017,TC018,TC019,TC020,TC021,TC022,TC023,TC024,TC025,TC026,TC027,TC028,TC029,TC030,TC031,TC032,TC033,TC034,TC035,TC036,TC037,TC038,TC039,TC040,TC041,TC042,TC043,TC044,TC045,TC046,TC047,TC299,TCD01,HeadUDF01,HeadUDF02,HeadUDF03,HeadUDF04,HeadUDF05,HeadUDF06,HeadUDF07,HeadUDF08,HeadUDF09,HeadUDF10,HeadUDF11,HeadUDF12,HeadUDF51,HeadUDF52,HeadUDF53,HeadUDF54,HeadUDF55,HeadUDF56,HeadUDF57,HeadUDF58,HeadUDF59,HeadUDF60,HeadUDF61,HeadUDF62 ) values('409569','331采购单','21120498','20211231','JC1211嘉昌','RMB','1','','','','101','1321唐彩霞','1','0','N','','','','1','345.13','44.87','','','3000','20211231','','0.13','107','0','0','S','0','','N','','N','','','0','0','0','','','0','0','0','','','','N','','','','','','','','','','','','','0','0','0','0','0','0','0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 17:17:51 Type: 单身数据保存取数1 Message: True ----------------------------------------------------------- Time: 2021/12/31 17:17:51 Type: 单身数据保存取数2 Message: YFPURI07_B ----------------------------------------------------------- Time: 2021/12/31 17:17:51 Type: 单身数据保存SQL语句 Message: insert into YFPURI07_B (TaskId,GridOrder,TD001,TD002,TD003,TD004,TD005,TD006,TD007,TD008,TD009,TD010,TD011,TD012,TD013,TD014,TD015,TD016,TD017,TD018,TD019,TD020,TD021,TD022,TD023,TD024,TD025,TD026,TD027,TD028,TD029,TD030,TD031,TD032,TD033,TD034,TD035,TD036,TD037,TD038,TD039,TD040,TD041,TD042,TD043,TD044,TD045,TD046,TD047,TD048,TD049,TD050,TD051,TD299,TDC01,TDC02,TDC03,TDC04,TDC05,TDC06,BodyUDF01,BodyUDF02,BodyUDF03,BodyUDF04,BodyUDF05,BodyUDF06,BodyUDF07,BodyUDF08,BodyUDF09,BodyUDF10,BodyUDF11,BodyUDF12,BodyUDF51,BodyUDF52,BodyUDF53,BodyUDF54,BodyUDF55,BodyUDF56,BodyUDF57,BodyUDF58,BodyUDF59,BodyUDF60,BodyUDF61,BodyUDF62 ) values( '409569','1','331','21120498','0001','31050160035','珍珠棉袋','珍珠棉袋340*230*0.5MM(340边开口)','115包材仓','3000','PCS','0.13','390','20220105',null,'SK3371 TOP_CASE工程吴云翔12/30邮件通知请购(库存0在途0)','0','N',null,'N','0',null,null,null,null,null,'N','311','21120296','0001',null,'0','0',null,'0.13','345.13','44.87','0','0','PCS','3000',null,null,null,null,null,'0','0','0','0','0',null,null,null,'0','0','2','0','0','0',null,null,null,null,null,null,null,null,null,null,null,null,'0','0','0','0','0','0','0','0','0','0','0','0'); ----------------------------------------------------------- Time: 2021/12/31 17:17:51 Type: StartNode Message: 1 ----------------------------------------------------------- Time: 2021/12/31 17:17:51 Type: StartNode Message: 2 ----------------------------------------------------------- Time: 2021/12/31 17:17:51 Type: StartNode Message: 3 -----------------------------------------------------------