Time: 2023/2/5 7:08:49 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2023/2/5 7:08:49 Type: 单身数据保存取数2 Message: yfcopi09_b ----------------------------------------------------------- Time: 2023/2/5 7:08:49 Type: 单身数据保存SQL语句 Message: insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','1',null,null,null,null,null,null,'0001','101264027004A','LOWER_CASE','LITEON/SM9069/注塑成型/BLACK',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'168',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'2',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','报废','谢坑',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','2',null,null,null,null,null,null,'0002','101264027005A','TOP_CASE_ASS Y','LITEON/SM9069/组装/BLACK',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'333',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'4',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','报废','谢坑',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','3',null,null,null,null,null,null,'0003','101142033012A','TOP_CASE_ASS/Y','旭丽/SM2022/组装/JACKY_BLACK',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'300',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'5',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','退厂商','顶勤',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','4',null,null,null,null,null,null,'0004','101142033013C','BOTTOM_CASE','旭丽/SM2022/印刷/PANTONE_877C',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'300',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'3',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','退厂商','顶勤',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','5',null,null,null,null,null,null,'0005','101307027014A','UPPER_CASE_ASSEMBLY','旭麗/SK2075/印刷/BLACK(105K)',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'130',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199002',null,null,null,null,null,'7',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','报废','装配',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','6',null,null,null,null,null,null,'0006','102328027015A','KEYCAP_ASSEMBLY(105UK)','旭丽/SK3320/组装散KEY 印刷灰白/BLACK',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'30',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'3',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','报废','装配',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','7',null,null,null,null,null,null,'0007','102328027006A','KEY_FRAME_L_ASSEMBLY','旭丽/SK3320/粘油 插KEY/BLACK',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'160',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'2',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','报废','谢坑',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','8',null,null,null,null,null,null,'0008','101218027012D','LOWER_CASE','旭丽/SM8123/注塑成型/BLACK',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'940',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'9',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','退厂商','顶勤',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','9',null,null,null,null,null,null,'0009','101106033001A','UPPER_CASE_ASSEMBLY','旭麗/SM9020/組裝/COAL_BALCK',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'96',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'1',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','报废','谢坑',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','10',null,null,null,null,null,null,'0010','101106033002','LOWER_CASE','旭丽/SM9020/注塑成型/COAL_BLACK',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'96',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'1',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','报废','谢坑',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','11',null,null,null,null,null,null,'0011','101302027011A','TOP_KEY_RED','旭丽/SM3360/注塑成型/RED',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'80',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'1',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','报废','谢坑',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','12',null,null,null,null,null,null,'0012','101307027015A','LOWER_CASE_ASSEMBLY','旭麗/SK2075/注塑成型/BLACK',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'200',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199002',null,null,null,null,null,'10',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','报废','谢坑',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','13',null,null,null,null,null,null,'0013','101339027001A','TOP_KEY_GRAY','旭丽/SM3371/印刷/GRAY',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'224',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'2',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','报废','装配',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','14',null,null,null,null,null,null,'0014','101339027002B','SKIRT_BLACK','旭丽/SM3371/注塑成型/BLACK',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'112',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'1',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','报废','臻泽',null,null,null,null);insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '591179','15',null,null,null,null,null,null,'0015','101339027003B','BOTTOM_CASE_ASSEMBLY_BLACK','旭丽/SM3371/注塑成型/BLACK',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'160',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'2',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'刮伤','退厂商','祥舜',null,null,null,null); ----------------------------------------------------------- Time: 2023/2/5 7:09:12 Type: 单身数据保存取数1 Message: False ----------------------------------------------------------- Time: 2023/2/5 7:09:12 Type: 单身数据保存取数2 Message: yfcopi09_b ----------------------------------------------------------- Time: 2023/2/5 7:09:12 Type: 单身数据保存SQL语句 Message: insert into yfcopi09_b (TaskId,GridOrder,createuser,createdate,modiuser,modidate,tj001,tj002,tj003,tj004,tj005,tj006,tj007,tj008,tj009,tj010,tj011,tj012,tj013,tj014,tj015,tj016,tj017,tj018,tj019,tj020,tj021,tj022,tj023,tj024,tj025,tj026,tj027,tj028,tj029,tj030,tj031,tj032,tj033,tj034,tj035,tj036,tj037,tj038,tj039,tj040,tj041,tj042,tj043,tj044,tj045,tj046,tj047,tj048,tj049,tj050,tj051,tj052,tj053,tj054,tj055,tj056,tj057,tj058,tj059,tj060,tj061,tj062,tj063,tj064,tj065,tj066,tj067,tj068,tj069,tj070,tj071,tj072,tj073,tj074,tj075,tj076,tj077,bodyudf01,bodyudf02,bodyudf03,bodyudf04,bodyudf05,bodyudf06,bodyudf51,bodyudf52,bodyudf53,bodyudf54,bodyudf55,bodyudf56,bodyudf07,bodyudf08,bodyudf09,bodyudf10,bodyudf11,bodyudf12,bodyudf57,bodyudf58,bodyudf59,bodyudf60,bodyudf61,bodyudf62,tb001,tb002,tb003,tb004,tb005,tb005c,tb006 ) values( '590445','1',null,null,null,null,null,null,'0001','102328027005A','PALM_REST','旭丽/SK3320/注塑成型/BLACK',null,'PCS',null,null,null,null,'1101销退仓',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'191',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'31110199001',null,null,null,null,null,'11',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,'缺胶','退厂商','均强',null,null,null,null); -----------------------------------------------------------