-
Notifications
You must be signed in to change notification settings - Fork 0
/
chlmes.sql
3094 lines (3004 loc) · 396 KB
/
chlmes.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/*
Navicat Premium Data Transfer
Source Server : test
Source Server Type : MySQL
Source Server Version : 50714
Source Host : localhost:3306
Source Schema : chlmes
Target Server Type : MySQL
Target Server Version : 50714
File Encoding : 65001
Date: 18/01/2019 11:34:40
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_art
-- ----------------------------
DROP TABLE IF EXISTS `t_art`;
CREATE TABLE `t_art` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Art_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编码',
`Art_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
`Art_used` tinyint(1) NULL DEFAULT NULL COMMENT '有效状态',
`Art_explain` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '说明',
`Art_date` datetime(0) NULL DEFAULT NULL,
`Art_manager` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工艺管理员',
`company_id` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 48 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_art
-- ----------------------------
INSERT INTO `t_art` VALUES (21, '202', '189131.4作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (13, '101', 'A858.859作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (5, '004', 'PA001作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (6, '005', 'PA002作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (7, '006', 'PA003作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (8, '007', 'PA004作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (9, '008', 'PA005作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (10, '009', 'PA006作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (11, '010', 'PA007作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (12, '011', 'PA008作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (15, '103', 'A73.74.75.76作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (20, '102', '877、878作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (39, '106', 'A0056455作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (22, '201', '192376.4作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (24, 'SPA004', '800039.0 作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (29, 'SPA003', '325835.0 作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (28, 'SPA003', '325835.0 作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (30, 'SPA005', '306720.2 作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (31, 'SPA006', '192303.1 作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (32, 'SPA007', '325842.0 作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (33, 'SPA008', 'HMN4720552505 作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (34, 'SPA009', '325808.0 作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (35, '105', 'A00433、434作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (36, 'SPA010', '325908.0 作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (37, 'SPA011', '306721.3 作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (40, '107', 'A0051045、46作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (41, '108', 'A0037984、85作业指导书', 1, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (42, '109', 'A0041460作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (43, '104', 'A00287、288作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (44, 'SPA001', '189131.4、192376.4 作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (45, 'SPA002', '192478.2、192568.3 作业指导书', 1, '', NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (46, 'SPA001_1', '复制_189131.4、192376.4 作业指导书', 0, NULL, NULL, NULL, NULL);
INSERT INTO `t_art` VALUES (47, 'THK001', 'THK作业指导书(HOY)', 1, '', NULL, NULL, NULL);
-- ----------------------------
-- Table structure for t_artdetail
-- ----------------------------
DROP TABLE IF EXISTS `t_artdetail`;
CREATE TABLE `t_artdetail` (
`det_id` int(11) NOT NULL AUTO_INCREMENT,
`Art_id` int(11) NOT NULL COMMENT '工艺编号',
`Work_order` int(11) NOT NULL COMMENT '顺序',
`Work_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工序名称',
`Work_add` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地点',
`person_liable` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人',
`Unt_NameCn` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位',
`Stat_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '计件计时',
`show_num` tinyint(1) NULL DEFAULT 0 COMMENT '客户端是否显示数量1显示0不显示',
`isproduce` tinyint(4) NULL DEFAULT 0 COMMENT '是否生产用工序0不是,1是生产用',
`isquality` tinyint(1) NULL DEFAULT 1 COMMENT '是否质检工序0非质检,1质检',
`isattachment` tinyint(1) NULL DEFAULT 0 COMMENT '附加项',
`attachvalue` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '附加项值',
`pstate` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '状态',
`workcenter` int(11) NULL DEFAULT NULL,
`Work_sumcost` decimal(10, 2) NULL DEFAULT NULL COMMENT '标准工序总成本',
`work_number` int(10) NULL DEFAULT NULL COMMENT '计件计时起算数量',
`work_pretime` decimal(10, 2) NULL DEFAULT NULL COMMENT '准备时数(小时)',
`work_explain` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '工序说明',
`work_filename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名',
PRIMARY KEY (`det_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 557 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_artdetail
-- ----------------------------
INSERT INTO `t_artdetail` VALUES (114, 17, 3, '加热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1100~1200°C。使用设备:中频加热炉。加热节拍:6-11S。每天必须用高温计校对炉温,看测温仪和高温计数是否保持一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (112, 17, 1, '下料', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:GB45钢,下料符合产品下料作业指导书。', NULL);
INSERT INTO `t_artdetail` VALUES (113, 17, 2, '模具预热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '每班班前用热模铁对模具进行加热,模具温度为200~300°C,用手提测温枪检测模具球头为标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (12, 4, 1, '下料', '', '', '', '', 0, 0, 1, 0, NULL, '1', 6, 0.00, 0, 0.00, '材质:45钢,下料负荷产品下料作业指导书.', NULL);
INSERT INTO `t_artdetail` VALUES (13, 4, 2, '磨具预热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 6, 0.00, 0, 0.00, '磨具预热:', NULL);
INSERT INTO `t_artdetail` VALUES (14, 5, 1, '下料', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:GB45钢,下料符合产品下料作业指导书。', NULL);
INSERT INTO `t_artdetail` VALUES (15, 5, 2, '模具预热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '每班班前用热模铁对模具进行加热,模具温度为200~300°C,用手提测温枪检测模具球头为标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (16, 5, 3, '加热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1100~1200°C。使用设备:中频加热炉。加热节拍:6-11S。每天必须用高温计校对炉温,看测温仪和高温计数是否保持一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (17, 5, 5, '制坯', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '制坯使用设备:150kg空气锤。检测:自己标准样坯放置锤砧作为后续坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (18, 5, 6, '成型', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具:PA12359.00成型压模;使用设备:300T摩擦压力机。每班锻打试棒一根,尺寸Φ20×180。;', NULL);
INSERT INTO `t_artdetail` VALUES (19, 5, 7, '热冲孔', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具PA12359.00热冲孔模;使用设备63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (20, 5, 8, '切边', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用模具:PA12359.00切边模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (21, 5, 9, '检验', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '锻坯表面不能有毛刺、裂纹、冷隔、折叠、氧化皮等缺陷;尺寸按产品图检测。', NULL);
INSERT INTO `t_artdetail` VALUES (22, 5, 10, '选别、修磨', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹、氧化皮、折叠、毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (23, 5, 11, '热处理', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '正火:抗拉强度545-850N/MM²', NULL);
INSERT INTO `t_artdetail` VALUES (24, 5, 12, '抛丸', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (25, 5, 13, '冷精压', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:冷精压模;使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (26, 5, 14, '选别', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹、氧化皮、折叠、毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (27, 5, 15, '磁粉探伤', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (28, 5, 16, '清洗、浸油', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '专用设备,使用油基防锈液清洗1-2分钟,产品无漏禁油。', NULL);
INSERT INTO `t_artdetail` VALUES (29, 5, 17, '包装', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '包装入库。', NULL);
INSERT INTO `t_artdetail` VALUES (30, 6, 1, '下料', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:45钢,下料符合产品下料作业指导书。', NULL);
INSERT INTO `t_artdetail` VALUES (31, 6, 2, '模具预热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '每班班前用产品棒料加热后对模具进行加热,温度为150~300°C,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (32, 6, 3, '加热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1100~1200°C。使用设备:中频加热炉。加热节拍:6-11S。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (33, 6, 4, '制坯', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯使用设备:250kg空气锤;检测:自制标准样坯放置锤砧作为后序坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (34, 6, 5, '成型', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清楚干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具:PA12109.00切边模;使用设备:400T摩擦压力机。每班锻打试棒一根,尺寸Φ20×180。', NULL);
INSERT INTO `t_artdetail` VALUES (35, 6, 6, '切边', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用模具:PA12A109.00切边模;使用设备:400T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (36, 6, 7, '检验', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '锻坯表面不能有毛刺、裂纹、冷隔、折叠、氧化皮等缺陷;尺寸按产品图检测。', NULL);
INSERT INTO `t_artdetail` VALUES (37, 6, 8, '选别丶修磨', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹,氧化皮,折叠,毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (38, 6, 9, '热处理', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '正火:抗拉强度545-890N/mm²。', NULL);
INSERT INTO `t_artdetail` VALUES (39, 6, 10, '抛丸', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (40, 6, 11, '冷冲孔', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具PA12A109.00冷冲孔模;使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (41, 6, 12, '精压', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:精压模;使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (42, 6, 13, '选别', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹,氧化皮,折叠,毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (43, 6, 14, '磁粉探伤', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。使用设备:磁粉探伤机。', NULL);
INSERT INTO `t_artdetail` VALUES (44, 6, 15, '清洗、浸油', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '专用设备,使用油机防锈液清洗1-2分钟,产品无漏浸油。', NULL);
INSERT INTO `t_artdetail` VALUES (45, 6, 16, '包装', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '包装入库', NULL);
INSERT INTO `t_artdetail` VALUES (46, 7, 1, '下料', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:45#,下料根据下料作业指导书。', NULL);
INSERT INTO `t_artdetail` VALUES (47, 7, 2, '模具预热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '每班班前用产品棒料加热后对模具进行加热,温度为150~300°C,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (48, 7, 3, '棒料加热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1100~1200°C,加热节拍:9-18S。100%按照《电炉加热工艺》和《烧制监控记录》。每天必须用高温计较对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (49, 7, 4, '制坯', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯使用设备:空气锤与63吨冲床;使用模具:PA12276.00(PA12277.00)折弯模。检测:自制标准样坯放置工序旁,作为后序坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (50, 7, 5, '成型', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具:PA12276.00(PA12277.00)成型压模;使用设备:400T压力机。每班班前用产品棒料锻打Φ20*L试棒。', NULL);
INSERT INTO `t_artdetail` VALUES (51, 7, 6, '切边', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用模具:PA12276.00(PA12277.00)切边模,使用设备63吨冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (52, 7, 7, '检验', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '锻坯表面不能有毛刺、裂纹、冷隔、折叠、氧化皮等缺陷。尺寸按产品图检测。', NULL);
INSERT INTO `t_artdetail` VALUES (53, 7, 8, '修磨', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '修磨锻件存在外观缺陷和切边毛刺。', NULL);
INSERT INTO `t_artdetail` VALUES (54, 7, 9, '热处理', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '正火:抗拉强度545-850N/mm²。', NULL);
INSERT INTO `t_artdetail` VALUES (55, 7, 10, '抛丸', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (56, 7, 11, '冲孔', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用冲孔模,使用设备:63吨冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (57, 7, 12, '精压', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用精压模,使用设备160吨压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (58, 7, 13, '选别', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹,氧化皮,折叠,毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (59, 7, 14, '磁粉探伤', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%探伤。', NULL);
INSERT INTO `t_artdetail` VALUES (60, 7, 15, '清洗、浸油', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '专用设备,用煤油清洗1-2分钟,油机防锈液浸泡。', NULL);
INSERT INTO `t_artdetail` VALUES (61, 7, 16, '包装', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '按客户要求。', NULL);
INSERT INTO `t_artdetail` VALUES (62, 8, 1, '下料', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:45钢,下料符合产品下料作业指导书。', NULL);
INSERT INTO `t_artdetail` VALUES (63, 8, 2, '模具预热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '每班班前用产品棒料加热后对模具进行加热,温度为150~300℃,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (64, 8, 3, '加热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1100~1200℃。使用设备:中频加热炉。加热节拍:6-11S。每天必须用高温计校对炉温,看测温仪和高温计读数是否一只,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (65, 8, 4, '制坯', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯使用设备:150kg空气锤;检测:自制标准坯放置锤砧作为后续坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (66, 8, 5, '成型', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用成型模具。使用设备:300T摩擦压力机。每班锻打试棒一根,尺寸Φ20×180。', NULL);
INSERT INTO `t_artdetail` VALUES (67, 8, 6, '切边', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用切边模具,使用设备:60T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (68, 8, 7, '检验', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '锻坯表面不能有毛刺、裂纹、冷隔、折叠、氧化皮等缺陷;尺寸按产品图检测。', NULL);
INSERT INTO `t_artdetail` VALUES (69, 8, 8, '选别丶修磨', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹、氧化皮、折叠、毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (70, 8, 9, '热处理', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '正火:抗拉强度 545-850N/mm²。', NULL);
INSERT INTO `t_artdetail` VALUES (71, 8, 10, '抛丸', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (72, 8, 11, '冷冲孔', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用冲孔模具冷冲孔,使用设备63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (73, 8, 12, '精压', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:精压模。使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (74, 8, 13, '选别', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹、氧化皮、折叠、毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (75, 8, 14, '磁粉探伤', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。使用设备:磁粉探伤机。', NULL);
INSERT INTO `t_artdetail` VALUES (76, 8, 15, '清洗丶浸油', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '专用设备,使用油基防锈液清洗1-2分钟,产品无漏禁油。', NULL);
INSERT INTO `t_artdetail` VALUES (77, 8, 16, '包装', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '包装入库。', NULL);
INSERT INTO `t_artdetail` VALUES (78, 9, 1, '下料', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:45#。 下料根据下料作业指导书。', NULL);
INSERT INTO `t_artdetail` VALUES (79, 9, 2, '模具预热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '每班班前用产品棒料加热后对模具进行加热,温度为150~300℃,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (80, 9, 3, '棒料加热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1100~1200℃,加热节拍:15-30S。100%按照《电炉加热工艺》。做好《烧制监控记录》。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (81, 9, 4, '制坯', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯使用设备:空气锤与63吨冲床。使用折弯模折弯。检测:自制标准样坯放置工序旁,作为后序坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (82, 9, 5, '成型', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用成型压模,使用设备630T压力机。每班班前用产品棒料锻打φ20*L试棒。', NULL);
INSERT INTO `t_artdetail` VALUES (83, 9, 6, '切边', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用切边模具切模,使用设备,63吨冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (84, 9, 7, '检验', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '锻坯表面不能有毛刺、裂纹、冷隔、折叠、氧化皮等缺陷;尺寸按产品图检测。', NULL);
INSERT INTO `t_artdetail` VALUES (85, 9, 8, '修磨', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '修磨锻件存在外观缺陷和切边毛刺。', NULL);
INSERT INTO `t_artdetail` VALUES (86, 9, 9, '热处理', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '正火,抗拉强度545-850N/mm²。', NULL);
INSERT INTO `t_artdetail` VALUES (87, 9, 10, '抛丸', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (88, 9, 11, '冲孔', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用冲孔模冲孔,使用设备:63吨冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (89, 9, 12, '精压', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用精压模精压;使用设备:160吨压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (90, 9, 13, '选别', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹、氧化皮、折叠、毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (91, 9, 14, '磁粉探伤', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%探伤。', NULL);
INSERT INTO `t_artdetail` VALUES (92, 9, 15, '清洗、浸油', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '专用设备,用煤油清洗1-2分钟,油基防锈液浸泡。', NULL);
INSERT INTO `t_artdetail` VALUES (93, 9, 16, '包装', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '按客户要求。', NULL);
INSERT INTO `t_artdetail` VALUES (94, 10, 1, '下料', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:45#,下料根据下料作业指导书。', NULL);
INSERT INTO `t_artdetail` VALUES (95, 10, 2, '模具预热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '每班班前用产品棒料加热后对模具进行加热,温度为200~300℃,手提测温仪以模腔最深处为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具的预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (96, 11, 1, '下料', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:45#,下料根据下料作业指导书。', NULL);
INSERT INTO `t_artdetail` VALUES (97, 11, 2, '模具预热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '模具预热:每班班前用产品棒料加热后对模具进行加热,温度为200~300℃,手提测温仪以模腔最深处为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (98, 11, 3, '棒料加热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1100~1200℃,加热节拍:15-30S。100%按照《电炉加热工艺》。做好《烧制监控记录》。每天必须用高温计较对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (99, 11, 4, '制坯', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯使用设备:空气锤与63吨冲床;使用折弯模折弯。检测:自制标准样坯放置工序旁,作为后续坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (100, 11, 5, '成型', '', '成型', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用成型压模;使用设备:400T压力机。每班班前用产品棒料锻打Φ20×L棒料。', NULL);
INSERT INTO `t_artdetail` VALUES (101, 11, 6, '切边', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用切边模切切边。使用设备:63吨冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (102, 11, 7, '检测', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '锻坯表面不能有毛刺、裂纹、冷隔、折叠、氧化皮等缺陷;尺寸按产品图检测', NULL);
INSERT INTO `t_artdetail` VALUES (103, 11, 8, '修磨', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '修磨锻件存在外观缺陷和切边毛刺。', NULL);
INSERT INTO `t_artdetail` VALUES (104, 11, 9, '热处理', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '正火,抗拉强度545-850N/mm²。', NULL);
INSERT INTO `t_artdetail` VALUES (105, 11, 10, '抛丸', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (106, 11, 11, '冲孔', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用冲孔模冲孔。使用设备:63吨冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (107, 11, 12, '精压', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用精压模精压,使用设备:160吨压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (108, 11, 13, '选别', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹、氧化皮、折叠、毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (109, 11, 14, '磁粉探伤', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%探伤。', NULL);
INSERT INTO `t_artdetail` VALUES (110, 11, 15, '磷化', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '专用设备。', NULL);
INSERT INTO `t_artdetail` VALUES (111, 11, 16, '包装', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '按客户要求。', NULL);
INSERT INTO `t_artdetail` VALUES (115, 17, 4, '制坯', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '制坯使用设备:150kg空气锤。检测:自己标准样坯放置锤砧作为后续坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (116, 17, 5, '成型', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具:PA12359.00成型压模;使用设备:300T摩擦压力机。每班锻打试棒一根,尺寸Φ20×180。;', NULL);
INSERT INTO `t_artdetail` VALUES (117, 17, 6, '热冲孔', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具PA12359.00热冲孔模;使用设备63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (118, 17, 7, '切边', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用模具:PA12359.00切边模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (119, 17, 8, '检验', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '锻坯表面不能有毛刺、裂纹、冷隔、折叠、氧化皮等缺陷;尺寸按产品图检测。', NULL);
INSERT INTO `t_artdetail` VALUES (120, 17, 9, '选别、修磨', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹、氧化皮、折叠、毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (121, 17, 10, '热处理', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '正火:抗拉强度545-850N/MM²', NULL);
INSERT INTO `t_artdetail` VALUES (122, 17, 11, '抛丸', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (123, 17, 12, '冷精压', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:冷精压模;使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (124, 17, 13, '选别', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹、氧化皮、折叠、毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (125, 17, 14, '磁粉探伤', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (126, 17, 15, '清洗、浸油', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '专用设备,使用油基防锈液清洗1-2分钟,产品无漏禁油。', NULL);
INSERT INTO `t_artdetail` VALUES (127, 17, 16, '包装', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '包装入库。', NULL);
INSERT INTO `t_artdetail` VALUES (181, 13, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '63T冲床和A0048858/A0048859切边模。切边模每三个班次需要对模具返修一次。', NULL);
INSERT INTO `t_artdetail` VALUES (182, 13, 7, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品上线温度范围严格控制在750-900℃,下线温度<500℃抗拉强度:Rm600-800N/mm²。', NULL);
INSERT INTO `t_artdetail` VALUES (183, 13, 8, '研磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备:角磨机/砂轮机。修磨锻件存在外观缺陷和切边毛刺。', NULL);
INSERT INTO `t_artdetail` VALUES (184, 13, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备:抛丸机。产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (185, 13, 10, '冷精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备:160T摩压机和A0048858/A0048859精压模。', NULL);
INSERT INTO `t_artdetail` VALUES (186, 13, 11, '选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹、氧化皮、折叠、毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (187, 13, 12, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%探伤。', NULL);
INSERT INTO `t_artdetail` VALUES (188, 13, 13, '材料分选', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备:分选机。无混料、无漏热处理工序、无错热处理工艺产品。', NULL);
INSERT INTO `t_artdetail` VALUES (189, 13, 14, '磷化', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '盐雾试验最少10分钟产品无变色。', NULL);
INSERT INTO `t_artdetail` VALUES (190, 13, 15, '选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '字迹清晰,无裂纹、毛刺、折叠等锻造缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (191, 13, 16, '防锈丶包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '防锈油全部覆盖在产品表面。包装按客户要求。', NULL);
INSERT INTO `t_artdetail` VALUES (157, 20, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (141, 15, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (142, 15, 10, '冲孔', '', '', '', '', 1, 1, 0, 1, '01', '1', 0, 0.00, 0, 0.00, '使用冲孔模冲孔,使用设备63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (143, 15, 11, '冷精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备160吨摩压机;使用模具精压模。', NULL);
INSERT INTO `t_artdetail` VALUES (144, 15, 12, '铣平面', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备:铣床', NULL);
INSERT INTO `t_artdetail` VALUES (145, 15, 13, '选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹、毛刺、氧化皮、折叠等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (146, 15, 14, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%探伤', NULL);
INSERT INTO `t_artdetail` VALUES (147, 15, 15, '硬度分选', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备:硬度分选仪。', NULL);
INSERT INTO `t_artdetail` VALUES (148, 15, 16, '选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件无裂纹、毛刺、折叠等锻造缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (149, 15, 17, '浸油包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '油基防锈液浸泡1~2分钟。按客户要求包装。', NULL);
INSERT INTO `t_artdetail` VALUES (175, 20, 7, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, 'HB160-220.', NULL);
INSERT INTO `t_artdetail` VALUES (308, 31, 10, '检验', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '锻坯表面不能有裂纹、氧化皮、折叠、毛刺、冷隔等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (179, 13, 3, '制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备:空气锤。', NULL);
INSERT INTO `t_artdetail` VALUES (180, 13, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '300T压力机和A0048858/A0048859成形模。班前用加热后的棒料预热模具,温度为250-400℃。检验标准为滴油冒白烟。成形模具需每两个班次需要对模具返修一次。连续作业时,喷石墨乳冷却润滑。', NULL);
INSERT INTO `t_artdetail` VALUES (133, 15, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质C35,根据下料作业指导书。', NULL);
INSERT INTO `t_artdetail` VALUES (134, 15, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '节拍5S~9S,温度1000~1080°,加热棒料:温度超过上差的棒料,给予报废处理,严禁使用。温度低于下差的棒料,只允许抛丸后重复加热使用一次。每班用高温计校对炉温,对比测温仪和高温计是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (135, 15, 3, '制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '150Kg空气锤。', NULL);
INSERT INTO `t_artdetail` VALUES (136, 15, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用300T摩擦压力机和成型模具,班前用加热后的棒料预热模具,温度为250-400℃,检验标准为滴油或喷石墨乳冒白烟,成型模具需每两个班次需要对模具返修一次。连续作业喷石墨乳冷却润滑。', NULL);
INSERT INTO `t_artdetail` VALUES (137, 15, 6, '锻压', '', '', '', '', 1, 1, 0, 1, '02', '1', 0, 0.00, 0, 0.00, '', NULL);
INSERT INTO `t_artdetail` VALUES (138, 15, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边落实,方可冲切。使用设备63T冲床;使用模具切边模。', NULL);
INSERT INTO `t_artdetail` VALUES (140, 15, 8, '修磨', '', '', '', '', 1, 1, 1, 1, '02', '1', 0, 0.00, 0, 0.00, '修磨锻件存在的外观缺陷和切边毛刺。', NULL);
INSERT INTO `t_artdetail` VALUES (132, 5, 4, '锻造', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (158, 20, 10, '冷冲孔', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用冲孔模冲孔,使用设备63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (159, 20, 11, '冷精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备160吨冲床;使用模具:精压模。', NULL);
INSERT INTO `t_artdetail` VALUES (160, 20, 15, '硬度分选', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '硬度分选仪', NULL);
INSERT INTO `t_artdetail` VALUES (161, 20, 13, '选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹、毛刺、氧化皮、折叠等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (162, 20, 14, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%探伤', NULL);
INSERT INTO `t_artdetail` VALUES (163, 20, 12, '铣平面', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '铣床', NULL);
INSERT INTO `t_artdetail` VALUES (176, 13, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质C45,下料根据下料作业指导书。', NULL);
INSERT INTO `t_artdetail` VALUES (165, 20, 18, '浸油丶包装', '', '', '', '', 1, 1, 0, 0, NULL, '-1', 0, 0.00, 0, 0.00, '油基防锈液浸泡1~2分钟。按客户要求发货。', NULL);
INSERT INTO `t_artdetail` VALUES (166, 20, 19, '包装发货', '', '', '', '', 0, 0, 0, 0, NULL, '-1', 0, 0.00, 0, 0.00, '外包装用免熏蒸木箱,内包装为VCI粗料袋,木箱尺寸800mm×600mm×550mm,装入量数量1400件/箱。根据TRW要求发货。', NULL);
INSERT INTO `t_artdetail` VALUES (167, 20, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '根据下料作业指导书。', NULL);
INSERT INTO `t_artdetail` VALUES (168, 0, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '节拍9S~15S,温度1100~1180°,加热棒料:温度超过上差的棒料,给予报废处理,严禁使用。温度低于下差的棒料,只允许抛丸后重复加热使用一次。每班用高温计校对炉温,对比测温仪和高温计是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (169, 20, 3, '制坯', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '150Kg空气锤。', NULL);
INSERT INTO `t_artdetail` VALUES (170, 20, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用300T电动螺旋和成型模具,班前用加热后的棒料预热模具,温度为250-400℃,检验标准为滴油或喷石墨乳冒白烟,成型模具需每两个班次需要对模具返修一次。连续作业喷石墨乳冷却润滑。', NULL);
INSERT INTO `t_artdetail` VALUES (171, 20, 6, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '', NULL);
INSERT INTO `t_artdetail` VALUES (172, 20, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边落实,方可冲切。使用设备63T冲床;使用模具切边模。', NULL);
INSERT INTO `t_artdetail` VALUES (177, 13, 6, '锻压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (178, 13, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备:中频电炉。加热节拍:5S~9S。温度:1000~1080℃。温度超过上差的棒料,给予报废处理,严禁使用。温度低于下差的棒料,只允许抛丸后重复加热使用一次。', NULL);
INSERT INTO `t_artdetail` VALUES (174, 20, 8, '修磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '修磨锻件存在的外观缺陷和切边毛刺。', NULL);
INSERT INTO `t_artdetail` VALUES (193, 15, 7, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, 'HV170~230(Rm540-750N/mm²)', NULL);
INSERT INTO `t_artdetail` VALUES (194, 22, 1, '下料', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '根据下料作业指导书下料', NULL);
INSERT INTO `t_artdetail` VALUES (195, 22, 2, '模具预热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '每班班前用产品棒料加热后对模具进行加热,温度为150~300℃,以滴废机油为检验标准,生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (196, 22, 3, '加热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1000~1100℃。使用设备:中频加热炉。加热节拍:7-13S100%通过温度分选仪分选。做好《烧制监控记录》。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%', NULL);
INSERT INTO `t_artdetail` VALUES (197, 22, 4, '预制坯', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备:150T空气锤。检测:自制标准样坯放置锤砧作为后续坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (469, 20, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '设备:中频电炉节拍:5S-9S温度:1000℃-1080℃', NULL);
INSERT INTO `t_artdetail` VALUES (198, 20, 16, '选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '无裂纹、毛刺、折叠等锻造缺陷(符合TRW S0000302标准)', NULL);
INSERT INTO `t_artdetail` VALUES (200, 24, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:16MnCr5 符合标准DIN 17210', NULL);
INSERT INTO `t_artdetail` VALUES (201, 24, 2, '模具预热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '模具预热:每班班前用产品棒料加热后对模具进行加热,温度为150~350°C,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (202, 24, 3, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1000~1100℃。使用设备:中频加热炉。 ;加热节拍:7-13s 。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。 ; ; ;;', NULL);
INSERT INTO `t_artdetail` VALUES (203, 24, 4, '预制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯使用设备:150T空气锤;;检测:自制标准样坯放置锤砧作为后序坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (204, 24, 5, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具成型压模;使用设备:300T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (205, 24, 6, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。 ;;使用模具切边模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (206, 24, 7, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (207, 24, 8, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '热处理硬度140-187HBW。', NULL);
INSERT INTO `t_artdetail` VALUES (208, 24, 9, '修磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品修磨 无毛刺折叠等缺陷', NULL);
INSERT INTO `t_artdetail` VALUES (209, 24, 10, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (210, 24, 11, '选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在裂纹、氧化皮、折叠、毛刺、冷隔等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (211, 24, 12, '精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:精压模;使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (212, 24, 13, '厚度选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '检测厚度尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (213, 24, 14, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。使用设备:磁粉探伤机。', NULL);
INSERT INTO `t_artdetail` VALUES (214, 24, 15, '产品喷码', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '探伤后对产品100%喷码', NULL);
INSERT INTO `t_artdetail` VALUES (215, 24, 16, '清洗,包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '清洗,浸油按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (216, 0, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:16MnCr5 符合标准 DIN 17210', NULL);
INSERT INTO `t_artdetail` VALUES (217, 25, 2, '模具预热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '模具预热:每班班前用产品棒料加热后对模具进行加热,温度为150~350°C,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (218, 25, 3, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1000~1100℃。使用设备:中频加热炉。 ;加热节拍:7-13s 。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。 ; ; ;;', NULL);
INSERT INTO `t_artdetail` VALUES (219, 25, 4, '预制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯使用设备:150T空气锤;;检测:自制标准样坯放置锤砧作为后序坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (220, 25, 5, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具成型压模;使用设备:300T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (221, 25, 6, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。 ;;使用模具切边模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (222, 25, 7, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (223, 25, 8, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '热处理硬度140-187HBW。', NULL);
INSERT INTO `t_artdetail` VALUES (224, 25, 9, '修磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品修磨 无毛刺折叠等缺陷', NULL);
INSERT INTO `t_artdetail` VALUES (225, 25, 10, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (226, 25, 11, '选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在裂纹、氧化皮、折叠、毛刺、冷隔等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (227, 25, 12, '精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:精压模;使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (228, 25, 13, '厚度选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '检测厚度尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (229, 25, 14, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。使用设备:磁粉探伤机。', NULL);
INSERT INTO `t_artdetail` VALUES (230, 25, 15, '产品喷码', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '探伤后对产品100%喷码', NULL);
INSERT INTO `t_artdetail` VALUES (231, 25, 16, '清洗,包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '清洗,浸油按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (233, 27, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (234, 27, 7, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品上线温度范围严格控制在750-900℃,下线温度<500℃。HB160-220(Rm540-750N/mm²)。', NULL);
INSERT INTO `t_artdetail` VALUES (235, 27, 10, '冲孔', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用冲孔模冲孔,使用设备63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (236, 27, 11, '冷精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备160吨摩压机;使用模具精压模。', NULL);
INSERT INTO `t_artdetail` VALUES (237, 27, 12, '铣平面', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备:铣床', NULL);
INSERT INTO `t_artdetail` VALUES (238, 27, 13, '选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别锻件是否存在裂纹、毛刺、氧化皮、折叠等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (239, 27, 14, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%探伤', NULL);
INSERT INTO `t_artdetail` VALUES (240, 27, 15, '硬度分选', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备:硬度分选仪。', NULL);
INSERT INTO `t_artdetail` VALUES (241, 27, 17, '浸油丶包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '油基防锈液浸泡1~2分钟。按客户要求发货。', NULL);
INSERT INTO `t_artdetail` VALUES (470, 20, 17, '浸油丶包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '油基防锈液浸泡按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (243, 27, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质C35R,根据下料作业指导书。', NULL);
INSERT INTO `t_artdetail` VALUES (244, 27, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '节拍5S~9S,温度1000~1080°,加热棒料:温度超过上差的棒料,给予报废处理,严禁使用。温度低于下差的棒料,只允许抛丸后重复加热使用一次。每班用高温计校对炉温,对比测温仪和高温计是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (245, 27, 3, '制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '150Kg空气锤。', NULL);
INSERT INTO `t_artdetail` VALUES (246, 27, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用300T摩擦压力机和成型模具,班前用加热后的棒料预热模具,温度为250-400℃,检验标准为滴油或喷石墨乳冒白烟,成型模具需每两个班次需要对模具返修一次。连续作业喷石墨乳冷却润滑。', NULL);
INSERT INTO `t_artdetail` VALUES (247, 27, 6, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '', NULL);
INSERT INTO `t_artdetail` VALUES (248, 27, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边落实,方可冲切。使用设备63T冲床;使用模具切边模。', NULL);
INSERT INTO `t_artdetail` VALUES (249, 27, 8, '修磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '修磨锻件存在的外观缺陷和切边毛刺。', NULL);
INSERT INTO `t_artdetail` VALUES (250, 27, 16, '选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '字迹清晰,表面无缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (252, 28, 1, '下料', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:16MnCr5 符合标准EN 10084', NULL);
INSERT INTO `t_artdetail` VALUES (253, 28, 2, '模具预热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '模具预热:每班班前用产品棒料加热后对模具进行加热,温度为200~300°C,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (254, 28, 3, '加热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1000~1100℃。使用设备:中频加热炉。 ;加热节拍:7-13s 。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。 ; ; ;;', NULL);
INSERT INTO `t_artdetail` VALUES (255, 28, 4, '预制坯', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯使用设备:150T空气锤;;检测:自制标准样坯放置锤砧作为后序坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (256, 28, 5, '成型', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具成型压模;使用设备:300T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (257, 28, 6, '切边', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。 ;;使用模具切边模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (258, 28, 7, '锻压', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (259, 28, 8, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '热处理硬度140-187HBW。组织为铁素体+珠光体', NULL);
INSERT INTO `t_artdetail` VALUES (260, 28, 9, '修磨', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品修磨 无毛刺折叠等缺陷', NULL);
INSERT INTO `t_artdetail` VALUES (261, 28, 10, '抛丸', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (262, 28, 11, '选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在裂纹、氧化皮、折叠、毛刺等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (263, 28, 12, '精压', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:精压模;使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (264, 28, 13, '厚度选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '检测厚度尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (265, 28, 14, '磁粉探伤', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。使用设备:磁粉探伤机。', NULL);
INSERT INTO `t_artdetail` VALUES (266, 28, 15, '产品喷码', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '探伤后对产品100%喷码', NULL);
INSERT INTO `t_artdetail` VALUES (267, 28, 16, '清洗,包装', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '清洗,浸油按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (268, 25, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:16MnCr5 符合标准DIN 17210', NULL);
INSERT INTO `t_artdetail` VALUES (269, 29, 1, '下料', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:16MnCr5 符合标准EN 10084', NULL);
INSERT INTO `t_artdetail` VALUES (270, 29, 2, '模具预热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '模具预热:每班班前用产品棒料加热后对模具进行加热,温度为200~300°C,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (271, 29, 3, '加热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1000~1100℃。使用设备:中频加热炉。 ;加热节拍:7-13s 。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。 ; ; ;;', NULL);
INSERT INTO `t_artdetail` VALUES (272, 29, 4, '预制坯', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯使用设备:150T空气锤;;检测:自制标准样坯放置锤砧作为后序坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (273, 29, 5, '成型', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具成型压模;使用设备:300T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (274, 29, 6, '切边', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。 ;;使用模具切边模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (275, 29, 7, '锻压', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (276, 29, 8, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '热处理硬度140-187HBW。组织为铁素体+珠光体', NULL);
INSERT INTO `t_artdetail` VALUES (277, 29, 9, '修磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品修磨 无毛刺折叠等缺陷', NULL);
INSERT INTO `t_artdetail` VALUES (278, 29, 10, '抛丸', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (279, 29, 11, '选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在裂纹、氧化皮、折叠、毛刺等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (280, 29, 12, '精压', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:精压模;使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (281, 29, 13, '厚度选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '检测厚度尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (282, 29, 14, '磁粉探伤', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。使用设备:磁粉探伤机。', NULL);
INSERT INTO `t_artdetail` VALUES (283, 29, 15, '产品喷码', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '探伤后对产品100%喷码', NULL);
INSERT INTO `t_artdetail` VALUES (284, 29, 16, '清洗,包装', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '清洗,浸油按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (285, 30, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:16MnCr5; 产地江阴兴澄(SPA专用料);', NULL);
INSERT INTO `t_artdetail` VALUES (286, 30, 2, '模具预热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '模具预热:每班班前用产品棒料加热后对模具进行加热,温度为150~350°C,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (287, 30, 3, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1000~1100℃。使用设备:中频加热炉。 加热节拍:6-11s 。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (288, 30, 4, '预制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯使用设备:63T冲床;压扁去除氧化皮;检测:自制标准样坯放置锤砧作为后序坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (289, 30, 5, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。;使用模具成型压模;使用设备:400T电动螺旋。', NULL);
INSERT INTO `t_artdetail` VALUES (290, 30, 6, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。;使用模具切边模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (291, 30, 7, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (292, 30, 8, '修磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '去除产品上的毛刺等外观缺陷', NULL);
INSERT INTO `t_artdetail` VALUES (293, 30, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '抛丸;使用设备:抛丸机', NULL);
INSERT INTO `t_artdetail` VALUES (294, 30, 10, '选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在裂纹、氧化皮、折叠、毛刺、等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (295, 30, 11, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤,选别;', NULL);
INSERT INTO `t_artdetail` VALUES (296, 30, 12, '精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:精压模;使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (297, 30, 13, '厚度选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100% 厚度选别', NULL);
INSERT INTO `t_artdetail` VALUES (298, 30, 14, '清洗、包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '清洗,浸油按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (299, 31, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:C45/GB', NULL);
INSERT INTO `t_artdetail` VALUES (300, 31, 2, '模具预热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '模具预热:每班班前用产品棒料加热后对模具进行加热,温度为150~350°C,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (301, 31, 3, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1000~1100℃。使用设备:中频加热炉。 加热节拍:7-13s 。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (302, 31, 4, '预制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯使用设备:63T冲床;;检测:自制标准样坯放置锤砧作为后序坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (303, 31, 5, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具成型压模;使用设备:400T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (304, 31, 6, '冲孔', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用模具冲孔模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (305, 31, 7, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用模具切边模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (306, 31, 8, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (307, 31, 9, '热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, 'BY热处理:HB206-252', NULL);
INSERT INTO `t_artdetail` VALUES (309, 31, 11, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (310, 31, 12, '精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:精压模;使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (471, 43, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '根据下料作业指导书下料。', NULL);
INSERT INTO `t_artdetail` VALUES (312, 31, 13, '磁粉探伤/选别', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤,选别;', NULL);
INSERT INTO `t_artdetail` VALUES (313, 31, 14, '清洗、包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '清洗,浸油按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (472, 43, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '节拍:9S-15S温度:1100-1180℃设备:中频电炉', NULL);
INSERT INTO `t_artdetail` VALUES (316, 32, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:42CrMo4 ; 符合标准 EN 10083-2006', NULL);
INSERT INTO `t_artdetail` VALUES (317, 32, 2, '模具预热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '模具预热:每班班前用产品棒料加热后对模具进行加热,温度为200~300°C,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (318, 32, 3, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1100~1200℃。使用设备:中频加热炉。 加热节拍:11-18s 。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (319, 32, 4, '预制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯使用设备:750T空气锤; 检测:自制标准样坯放置锤砧作为后序坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (320, 32, 5, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。产品字多 需注意字迹清晰产品;使用模具成型压模;使用设备:630T摩擦压力机。锻造重点控制尺寸:编号11:;; 2±0.3编号9:; 44+0.6/+0.3编号12:;46+0.6/+0.3', NULL);
INSERT INTO `t_artdetail` VALUES (321, 32, 6, '冲孔', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用模具冲孔模;使用设备:160T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (322, 32, 7, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。冲孔与切边方向相反注意方向使用模具切边模;使用设备:160T冲床', NULL);
INSERT INTO `t_artdetail` VALUES (323, 32, 8, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '', NULL);
INSERT INTO `t_artdetail` VALUES (324, 32, 9, '热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '调质热处理:Rm1000-1200N/mm2, Rp≥750N/mm2; 本体取样;', NULL);
INSERT INTO `t_artdetail` VALUES (325, 32, 10, '热精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '热处理后热压。 使用模具:精压模;使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (326, 32, 11, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (327, 32, 12, '选别检验', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在裂纹、氧化皮、折叠、毛刺、冷隔等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (328, 32, 13, '过卡板', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品厚度100%过卡板', NULL);
INSERT INTO `t_artdetail` VALUES (329, 32, 14, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。', NULL);
INSERT INTO `t_artdetail` VALUES (330, 32, 15, '清洗、包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '清洗,浸油按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (331, 33, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:C45,下料根据《SPA下料作业指导书》', NULL);
INSERT INTO `t_artdetail` VALUES (332, 33, 2, '模具预热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '模具预热:每班班前用产品棒料加热后对模具进行加热,温度为150~350°C,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (333, 33, 3, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1100~1200℃。100%按照《电炉加热工艺》。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (334, 33, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具成型压模;使用设备:630T压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (335, 33, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用模具切边模;使用设备:100T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (336, 33, 6, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '', NULL);
INSERT INTO `t_artdetail` VALUES (337, 33, 7, '检验', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '锻坯表面不能有裂纹、氧化皮、折叠、毛刺、冷隔等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (338, 33, 8, '选别、修磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别;修磨去除残余飞边和毛刺', NULL);
INSERT INTO `t_artdetail` VALUES (339, 33, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (340, 33, 10, '选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在裂纹、氧化皮、折叠、毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (341, 33, 11, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。', NULL);
INSERT INTO `t_artdetail` VALUES (342, 33, 12, '清洗、浸油、包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '专用设备,用煤油清洗1-2分钟,油基防锈液浸泡。按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (343, 35, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '根据下料作业指导书下料', NULL);
INSERT INTO `t_artdetail` VALUES (344, 35, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用设备:中频电炉;加热棒料:温度超过上差的棒料,给予报废处理,严禁使用。温度低于下差的棒料,进行抛丸后可以重复加热使用一次,棒料加热不得做多两次。每班用高温计校对炉温,对比测温仪和高温计是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (345, 34, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:根据《SPA下料作业指导书》', NULL);
INSERT INTO `t_artdetail` VALUES (346, 35, 3, '制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '400Kg空气锤', NULL);
INSERT INTO `t_artdetail` VALUES (347, 35, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '400T摩擦压力机和成型模。', NULL);
INSERT INTO `t_artdetail` VALUES (348, 34, 2, '模具预热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '模具预热:每班班前用产品棒料加热后对模具进行加热,温度为150~350°C,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (349, 35, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '63T冲床和切边模。', NULL);
INSERT INTO `t_artdetail` VALUES (350, 35, 6, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (351, 35, 7, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, 'HV187-233(600-750N/mm2)', NULL);
INSERT INTO `t_artdetail` VALUES (352, 34, 3, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:950~1050℃。100%按照《电炉加热工艺》。 每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (353, 35, 8, '研磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%无毛刺、飞边、折叠等锻打缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (354, 34, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具成型压模;使用设备:400T电动螺旋压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (355, 35, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (356, 34, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用模具冲孔模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (357, 34, 6, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (358, 35, 10, '选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '无裂纹、毛刺、折叠等锻造缺陷', NULL);
INSERT INTO `t_artdetail` VALUES (359, 35, 11, '冷冲孔', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '63T冲床和冲孔模', NULL);
INSERT INTO `t_artdetail` VALUES (360, 35, 12, '冷精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '160T摩擦压力机和精压模', NULL);
INSERT INTO `t_artdetail` VALUES (361, 35, 13, '二次选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '字迹清晰,无裂纹、毛刺、折叠等锻造缺陷(符合S3000302/C标准)', NULL);
INSERT INTO `t_artdetail` VALUES (362, 35, 14, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%磁粉探伤', NULL);
INSERT INTO `t_artdetail` VALUES (363, 35, 15, '硬度分选', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用硬度分选仪。', NULL);
INSERT INTO `t_artdetail` VALUES (364, 34, 7, '余温处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '余温处理,硬度HB160-240。', NULL);
INSERT INTO `t_artdetail` VALUES (365, 35, 16, '浸油丶包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%浸油,按客户要求包装发货。', NULL);
INSERT INTO `t_artdetail` VALUES (366, 34, 8, '检验', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在裂纹、氧化皮、折叠、毛刺、冷隔等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (367, 34, 9, '选别、修磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别,修磨去除残余飞边和毛刺。', NULL);
INSERT INTO `t_artdetail` VALUES (368, 34, 10, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (369, 34, 11, '打字', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '字迹清晰。使用模具打字模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (370, 34, 12, '精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:精压模;使用设备:160T压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (371, 34, 13, '选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在裂纹、氧化皮、折叠、毛刺等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (372, 34, 14, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。', NULL);
INSERT INTO `t_artdetail` VALUES (373, 34, 15, '清洗、浸油、包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '专用设备,用煤油清洗1-2分钟,油基防锈液浸泡。按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (374, 36, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:16MnCr5/DBL4027 产地江阴兴澄', NULL);
INSERT INTO `t_artdetail` VALUES (375, 36, 2, '模具预热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '模具预热:每班班前用产品棒料加热后对模具进行加热,温度为150~350°C,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (376, 36, 3, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:900~1000℃。使用设备:中频加热炉。 加热节拍:6-11s 。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (377, 36, 4, '预制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯使用设备:63T冲床;检测:自制标准样坯放置锤砧作为后序坯样目视对比。', NULL);
INSERT INTO `t_artdetail` VALUES (378, 36, 5, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具成型压模;使用设备:400T电动螺旋。', NULL);
INSERT INTO `t_artdetail` VALUES (379, 36, 6, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用模具切边模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (380, 36, 7, '锻压', '', '', '', '', 0, 1, 0, 1, '01', '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (381, 36, 8, '热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '空冷热处理:硬度〈250HB。组织为铁素体与珠光体结构,无贝氏体。', NULL);
INSERT INTO `t_artdetail` VALUES (382, 36, 9, '检验', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在毛刺、裂纹、冷隔、折叠、氧化皮等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (383, 36, 10, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (384, 36, 11, '精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:精压模;使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (385, 36, 12, '磁粉探伤/选别', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤,选别;', NULL);
INSERT INTO `t_artdetail` VALUES (386, 36, 13, '清洗、包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '清洗,浸油按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (387, 37, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '材质:下料根据《SPA下料作业指导书》。', NULL);
INSERT INTO `t_artdetail` VALUES (388, 37, 2, '模具预热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '模具预热:每班班前用产品棒料加热后对模具进行加热,温度为150~350°C,以滴废机油冒烟为检验标准。生产过程中停机后应及时对模具进行加热,冬季因室温较低应相应延长对模具预热时间。', NULL);
INSERT INTO `t_artdetail` VALUES (389, 37, 3, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:950~1050℃。100%按照《电炉加热工艺》。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (390, 37, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具成型压模;使用设备:400T电动螺旋压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (391, 37, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用模具切边模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (392, 37, 6, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (393, 37, 7, '检验', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在毛刺、裂纹、冷隔、折叠、氧化皮等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (394, 37, 8, '选别、修磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%选别,修磨去除残余飞边和毛刺。', NULL);
INSERT INTO `t_artdetail` VALUES (395, 37, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (396, 37, 10, '选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在毛刺、裂纹、折叠、氧化皮等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (397, 37, 11, '打字', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '字迹清晰。使用模具打字模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (398, 37, 12, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。', NULL);
INSERT INTO `t_artdetail` VALUES (399, 37, 13, '精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:精压模;使用设备:160T压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (400, 37, 14, '选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在毛刺、裂纹、折叠、氧化皮等外观缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (401, 37, 15, '清洗、浸油、包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '专用设备,用煤油清洗1-2分钟,油基防锈液浸泡。按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (402, 38, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '根据下料作业指导书下料。', NULL);
INSERT INTO `t_artdetail` VALUES (403, 38, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '中频加热炉。节拍5S~9S,加热温度1000℃~1080℃。每班用高温计校对炉温,对比测温仪和高温计是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (404, 38, 3, '制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '150kg空气锤', NULL);
INSERT INTO `t_artdetail` VALUES (405, 38, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '300T摩压机和A0036877/A0036878-中心距2mm成形模', NULL);
INSERT INTO `t_artdetail` VALUES (406, 38, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '冲床和A0036877/A0036878-中心距2mm切边模', NULL);
INSERT INTO `t_artdetail` VALUES (407, 38, 6, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (408, 38, 7, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, 'HB160-220', NULL);
INSERT INTO `t_artdetail` VALUES (409, 38, 8, '修磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%去除毛刺,折叠,飞边等。', NULL);
INSERT INTO `t_artdetail` VALUES (410, 38, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面100%无氧化皮', NULL);
INSERT INTO `t_artdetail` VALUES (411, 38, 10, '冷冲孔', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '冲床和A0036877/A0036878-中心距2mm冲孔模', NULL);
INSERT INTO `t_artdetail` VALUES (412, 38, 11, '冷精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '160T摩压机和A0036877/A0036878-中心距2mm精压模', NULL);
INSERT INTO `t_artdetail` VALUES (413, 38, 12, '铣平面', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '铣床', NULL);
INSERT INTO `t_artdetail` VALUES (414, 38, 13, '选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '字迹清晰,产品表面100%无裂纹、毛刺、折叠等锻造缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (415, 38, 14, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%磁粉探伤。', NULL);
INSERT INTO `t_artdetail` VALUES (416, 38, 15, '硬度分选', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, 'HB160-220', NULL);
INSERT INTO `t_artdetail` VALUES (417, 38, 16, '二次选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '无裂纹、毛刺、折叠等锻造缺陷(符合TRW S0000302标准)', NULL);
INSERT INTO `t_artdetail` VALUES (418, 38, 17, '浸油包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '浸油1-2min按客户要求包装发货', NULL);
INSERT INTO `t_artdetail` VALUES (419, 39, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '按照下料作业指导书下料', NULL);
INSERT INTO `t_artdetail` VALUES (420, 39, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '节拍10S~18S;加热温度:1100~1180℃;使用设备;中频电炉。', NULL);
INSERT INTO `t_artdetail` VALUES (421, 39, 3, '制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '空气锤', NULL);
INSERT INTO `t_artdetail` VALUES (422, 39, 4, '成型', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '630电动螺旋和成型模具。', NULL);
INSERT INTO `t_artdetail` VALUES (423, 39, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '63T冲床和切边模具。', NULL);
INSERT INTO `t_artdetail` VALUES (424, 39, 6, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (425, 39, 7, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, 'HB209~252', NULL);
INSERT INTO `t_artdetail` VALUES (426, 39, 8, '研磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面100%无毛刺折叠等缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (427, 39, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (428, 39, 10, '冲大孔(Φ20)', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '冲床和冲孔模。', NULL);
INSERT INTO `t_artdetail` VALUES (429, 39, 11, '打字', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '冲床和打字模', NULL);
INSERT INTO `t_artdetail` VALUES (430, 39, 12, '冷精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '160T摩擦压力机和精压模。', NULL);
INSERT INTO `t_artdetail` VALUES (431, 39, 13, '冷冲三个小孔', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '冲床和冲孔模', NULL);
INSERT INTO `t_artdetail` VALUES (432, 39, 14, '倒角', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '冲床', NULL);
INSERT INTO `t_artdetail` VALUES (433, 39, 15, '选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '字迹清晰,无裂纹、毛刺、折叠等锻造缺陷(符合S3000302标准)', NULL);
INSERT INTO `t_artdetail` VALUES (434, 39, 16, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%磁粉探伤', NULL);
INSERT INTO `t_artdetail` VALUES (435, 39, 17, '浸油包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%浸油,按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (436, 41, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '按照下料作业指导书下料。', NULL);
INSERT INTO `t_artdetail` VALUES (437, 41, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '中频电炉。节拍10S-18S。温度1100-1200℃。', NULL);
INSERT INTO `t_artdetail` VALUES (438, 41, 3, '制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '400kg空气锤。', NULL);
INSERT INTO `t_artdetail` VALUES (439, 41, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '400T摩擦压力机和成型模具。', NULL);
INSERT INTO `t_artdetail` VALUES (440, 41, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '63T冲床和切边模具', NULL);
INSERT INTO `t_artdetail` VALUES (441, 41, 6, '锻压', '', '', '', '', 0, 1, 0, 1, '02', '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (442, 41, 7, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, 'HB187-233', NULL);
INSERT INTO `t_artdetail` VALUES (443, 41, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面100%无氧化层。', NULL);
INSERT INTO `t_artdetail` VALUES (444, 41, 11, '冷冲孔', '', '冷精压', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '63T冲床和冲孔模具', NULL);
INSERT INTO `t_artdetail` VALUES (445, 41, 12, '冷精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '160T摩压机和精压模', NULL);
INSERT INTO `t_artdetail` VALUES (446, 41, 8, '研磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无毛刺折叠等缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (447, 41, 10, '选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无毛刺氧化皮等缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (448, 41, 13, '头部整形', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '', NULL);
INSERT INTO `t_artdetail` VALUES (449, 41, 14, '二次选别', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '字迹清晰,无裂纹、毛刺、折叠等锻造缺陷(符合S3000302标准)', NULL);
INSERT INTO `t_artdetail` VALUES (450, 41, 15, '磁粉探伤', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%磁粉探伤', NULL);
INSERT INTO `t_artdetail` VALUES (451, 41, 16, '硬度分选', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '硬度分选仪', NULL);
INSERT INTO `t_artdetail` VALUES (452, 41, 17, '浸油包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '油基防锈液浸泡按客户要求包装。', NULL);
INSERT INTO `t_artdetail` VALUES (453, 42, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '根据下料作业指导书下料。', NULL);
INSERT INTO `t_artdetail` VALUES (454, 42, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '中频电炉节拍:11S~18S加热温度:1100℃~1200℃。', NULL);
INSERT INTO `t_artdetail` VALUES (455, 42, 3, '制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '150kg空气锤', NULL);
INSERT INTO `t_artdetail` VALUES (456, 42, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '300T摩擦压力机和成型模具。', NULL);
INSERT INTO `t_artdetail` VALUES (457, 42, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '63T冲床和切边模具', NULL);
INSERT INTO `t_artdetail` VALUES (458, 42, 6, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '', NULL);
INSERT INTO `t_artdetail` VALUES (459, 42, 7, '空冷', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, 'HB238-280', NULL);
INSERT INTO `t_artdetail` VALUES (460, 42, 8, '研磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '去除残余飞边、毛刺、折叠等锻造缺陷', NULL);
INSERT INTO `t_artdetail` VALUES (461, 42, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮', NULL);
INSERT INTO `t_artdetail` VALUES (462, 42, 10, '冲孔', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '125T冲床和冲孔模', NULL);
INSERT INTO `t_artdetail` VALUES (463, 42, 11, '精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '160T摩压机和精压模', NULL);
INSERT INTO `t_artdetail` VALUES (464, 42, 12, '探伤', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%探伤', NULL);
INSERT INTO `t_artdetail` VALUES (465, 42, 13, '硬度分选', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '硬度分选仪', NULL);
INSERT INTO `t_artdetail` VALUES (466, 42, 14, '铣平面', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '铣床', NULL);
INSERT INTO `t_artdetail` VALUES (467, 42, 15, '选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '无裂纹、毛刺、折叠等锻造缺陷(符合TRW S0000302/C版 标准)', NULL);
INSERT INTO `t_artdetail` VALUES (468, 42, 16, '浸油包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '油基防锈液浸泡按客户要求包装', NULL);
INSERT INTO `t_artdetail` VALUES (473, 43, 3, '制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '空气锤', NULL);
INSERT INTO `t_artdetail` VALUES (474, 43, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '630T电动螺旋和A0038287/A0038288 成形模;', NULL);
INSERT INTO `t_artdetail` VALUES (475, 43, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '冲床和切边模具', NULL);
INSERT INTO `t_artdetail` VALUES (476, 43, 6, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (477, 43, 7, '热精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '160T冲床和A0038287/A0038288 精压模', NULL);
INSERT INTO `t_artdetail` VALUES (478, 43, 8, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, 'HB190-233', NULL);
INSERT INTO `t_artdetail` VALUES (479, 43, 9, '研磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '残余飞边小于0.7mm,无明显闪筋,无毛刺', NULL);
INSERT INTO `t_artdetail` VALUES (480, 43, 10, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (481, 43, 11, '冲大孔(Φ20)', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '63T冲床和A0038287/A0038288冲孔模', NULL);
INSERT INTO `t_artdetail` VALUES (482, 43, 12, '选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%无毛刺,裂纹,折叠等缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (483, 43, 13, '打字', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '冲床和A0038287/A0038288打字模', NULL);
INSERT INTO `t_artdetail` VALUES (484, 43, 14, '冷精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '160T摩压机和A0038287/A0038288 精压模', NULL);
INSERT INTO `t_artdetail` VALUES (485, 43, 15, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '磁粉探伤仪100%磁粉探伤', NULL);
INSERT INTO `t_artdetail` VALUES (486, 43, 16, '冷冲3个小孔', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '冲床和A0038287/A0038288 冲孔模', NULL);
INSERT INTO `t_artdetail` VALUES (487, 43, 17, '倒角', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '冲床去毛刺', NULL);
INSERT INTO `t_artdetail` VALUES (488, 43, 18, '二次选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '字迹清晰,无裂纹、毛刺、折叠等锻造缺陷(符合S3000302标准)', NULL);
INSERT INTO `t_artdetail` VALUES (489, 43, 19, '浸油包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '表面防锈油按客户要求包装。', NULL);
INSERT INTO `t_artdetail` VALUES (490, 44, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '根据《下料作业指导书》。', NULL);
INSERT INTO `t_artdetail` VALUES (491, 44, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1100~1200℃。使用设备:中频加热炉。 加热节拍:300T生产线为8-13s,400T生产线为9-15s 。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (492, 44, 3, '制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯尺寸根据图纸要求。使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (493, 44, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具成型压模;使用设备:400T电动螺旋压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (494, 44, 5, '冲切', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型后的产品,放入冲孔、切边附和凹模中,周边实落后,方可冲切。使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (495, 44, 6, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (496, 44, 7, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '热处理硬度HB201-252,锻造珠光体结构符合DBL4532。', NULL);
INSERT INTO `t_artdetail` VALUES (497, 44, 8, '研磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品研磨,无毛刺折叠等缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (498, 44, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (499, 44, 10, '一次选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在毛刺、裂纹、冷隔、折叠、氧化皮等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (500, 44, 11, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。使用设备:磁粉探伤机。', NULL);
INSERT INTO `t_artdetail` VALUES (501, 44, 12, '冷精压', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:精压模;使用设备:160T压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (502, 44, 13, '厚度选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '检测厚度尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (503, 44, 14, '二次选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在毛刺、裂纹、冷隔、折叠、氧化皮等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (504, 44, 15, '包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '按客户要求包装。', NULL);
INSERT INTO `t_artdetail` VALUES (505, 46, 1, '下料', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '根据《下料作业指导书》。', NULL);
INSERT INTO `t_artdetail` VALUES (506, 46, 2, '加热', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:1100~1200℃。使用设备:中频加热炉。 加热节拍:300T生产线为7-13s,400T生产线为9-15s 。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (507, 46, 3, '制坯', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯尺寸根据图纸要求。使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (508, 46, 4, '成型', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具成型压模;使用设备:400T电动螺旋压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (509, 46, 5, '冲切', '', '', '', '', 0, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型后的产品,放入冲孔、切边附和凹模中,周边实落后,方可冲切。使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (510, 46, 6, '锻压', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (511, 46, 7, '余温热处理', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '热处理硬度HB201-252,锻造珠光体结构符合DBL4532。', NULL);
INSERT INTO `t_artdetail` VALUES (512, 46, 8, '研磨', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品研磨,无毛刺折叠等缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (513, 46, 9, '抛丸', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (514, 46, 10, '一次选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在毛刺、裂纹、冷隔、折叠、氧化皮等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (515, 46, 11, '磁粉探伤', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。使用设备:磁粉探伤机。', NULL);
INSERT INTO `t_artdetail` VALUES (516, 46, 12, '冷精压', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '使用模具:精压模;使用设备:160T摩擦压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (517, 46, 13, '厚度选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '检测厚度尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (518, 46, 14, '二次选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在毛刺、裂纹、冷隔、折叠、氧化皮等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (519, 46, 15, '包装', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '按客户要求包装。', NULL);
INSERT INTO `t_artdetail` VALUES (520, 45, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '根据《下料作业指导书》。', NULL);
INSERT INTO `t_artdetail` VALUES (521, 45, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度:900~1000℃。使用设备:中频加热炉。 加热节拍:300T生产线为8-13s,400T生产线为9-15s 。每天必须用高温计校对炉温,看测温仪和高温计读数是否一致,误差≤1%。', NULL);
INSERT INTO `t_artdetail` VALUES (522, 45, 3, '制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '预制坯尺寸根据图纸要求。使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (523, 45, 4, '成型', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '用钢丝刷清除干净氧化皮,速放入模腔成型,连续作业需保持模腔干净,并用石墨乳冷却润滑。使用模具成型压模;使用设备:400T电动螺旋压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (524, 45, 5, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '将成型件放入切边凹模,周边实落,方可冲切。使用模具切边模;使用设备:63T冲床。', NULL);
INSERT INTO `t_artdetail` VALUES (525, 45, 6, '锻压', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (526, 45, 7, '余温热处理', '', '', '', '', 0, 1, 1, 0, '', '1', 0, 0.00, 0, 0.00, '硬度250HB,珠光体+铁素体,无贝氏体', NULL);
INSERT INTO `t_artdetail` VALUES (527, 45, 8, '研磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品研磨,无毛刺折叠等缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (528, 45, 9, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品表面无氧化皮。', NULL);
INSERT INTO `t_artdetail` VALUES (529, 45, 10, '一次选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在毛刺、裂纹、冷隔、折叠、氧化皮等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (530, 45, 11, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '产品100%磁粉探伤。使用设备:磁粉探伤机。', NULL);
INSERT INTO `t_artdetail` VALUES (531, 45, 12, '冷精压', '', '', '', '', 1, 1, 0, 0, '', '1', 0, 0.00, 0, 0.00, '使用模具:精压模;使用设备:160T压力机。', NULL);
INSERT INTO `t_artdetail` VALUES (532, 45, 13, '厚度选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '检测厚度尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (533, 45, 14, '二次选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '选别锻件是否存在毛刺、裂纹、冷隔、折叠、氧化皮等外观缺陷。检测尺寸 按图纸检测', NULL);
INSERT INTO `t_artdetail` VALUES (534, 45, 15, '包装', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '按客户要求包装。', NULL);
INSERT INTO `t_artdetail` VALUES (535, 47, 1, '下料', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '根据下料作业指导书下料。', NULL);
INSERT INTO `t_artdetail` VALUES (536, 47, 2, '加热', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '加热温度1100-1200℃300T摩擦压力机8S-13S400T摩擦压力机9S-18S', NULL);
INSERT INTO `t_artdetail` VALUES (537, 47, 31, '制坯', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '<p><img src=\"/ueditor/php/upload/image/20180424/1524555371872168.jpg\" alt=\"1524555371872168.jpg\"/><img src=\"/ueditor/php/upload/image/20180424/1524555391830513.jpg\" alt=\"1524555391830513.jpg\"/></p>', NULL);
INSERT INTO `t_artdetail` VALUES (538, 47, 4, '锻造', '', '', '', '', 1, 0, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '<p><img src=\"/ueditor/php/upload/image/20180424/1524555565816743.jpg\" alt=\"1524555565816743.jpg\"/></p>', NULL);
INSERT INTO `t_artdetail` VALUES (539, 47, 51, '切边', '', '', '', '', 0, 0, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '63T冲床', NULL);
INSERT INTO `t_artdetail` VALUES (540, 47, 6, '锻压', '', '', '', '', 1, 1, 1, 1, '01', '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (541, 47, 7, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%无氧化皮', NULL);
INSERT INTO `t_artdetail` VALUES (542, 47, 8, '研磨', '', '', '', '', 1, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%无毛刺裂纹飞边等。', NULL);
INSERT INTO `t_artdetail` VALUES (543, 47, 9, '热处理', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '正火', NULL);
INSERT INTO `t_artdetail` VALUES (544, 47, 10, '抛丸', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%无氧化皮', NULL);
INSERT INTO `t_artdetail` VALUES (545, 47, 11, '冷精压', '', '', '', '', 1, 1, 0, 0, '', '1', 0, 0.00, 0, 0.00, '160T压力机和精压模', NULL);
INSERT INTO `t_artdetail` VALUES (546, 47, 12, '一次选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%无裂纹,毛刺,折叠等缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (547, 47, 13, '磁粉探伤', '', '', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%磁粉探伤', NULL);
INSERT INTO `t_artdetail` VALUES (548, 47, 14, '厚度选别', '', '', '', '', 0, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '按产品图检测', NULL);
INSERT INTO `t_artdetail` VALUES (549, 47, 15, '二次选别', '', '', '', '', 0, 1, 1, 0, NULL, '1', 0, 0.00, 0, 0.00, '100%无毛刺氧化皮,裂纹等缺陷。', NULL);
INSERT INTO `t_artdetail` VALUES (550, 47, 16, '包装', '', 'df', '', '', 1, 1, 0, 0, NULL, '1', 0, 0.00, 0, 0.00, '按客户要求包装。', NULL);
INSERT INTO `t_artdetail` VALUES (551, 21, 31, 'testtest', '', '', '', '', 1, 1, 1, 0, '01', '1', 2, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (552, 21, 32, '121112', '', '', '', '', 0, 1, 1, 0, '02', '1', 0, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (553, 47, 3, 'test123', '', '', '', '', 1, 1, 1, 1, '01', '1', 2, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (554, 47, 5, '打印批次', '', '', '', '', 1, 1, 0, 1, '01', '1', 2, 0.00, 0, 0.00, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (555, 47, 3, 'test', NULL, NULL, NULL, NULL, 0, 0, 1, 0, '', '1', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_artdetail` VALUES (556, 7, 1, 'test', NULL, '123', '个', '321', 1, 1, 1, 0, '', '1', NULL, 123.00, 123, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for t_bas_producebom
-- ----------------------------
DROP TABLE IF EXISTS `t_bas_producebom`;
CREATE TABLE `t_bas_producebom` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
`Pd_Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '物料编码',
`Pb_ChildCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '子物料编码',
`Pb_ChildGross` decimal(18, 4) NOT NULL COMMENT '子物料毛数量',
`Pb_ChildNet` decimal(18, 4) NOT NULL COMMENT '子物料净数量',
`Pb_ChildPer` decimal(10, 4) NOT NULL COMMENT '子物料出成率',
`Pb_ChildMay` bit(1) NOT NULL COMMENT '是否可选',
`Pb_Per` decimal(10, 4) NOT NULL COMMENT '出成率',
`modman` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`moddate` int(11) NOT NULL,
`Pb_Note` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 54 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_bas_producebom
-- ----------------------------
INSERT INTO `t_bas_producebom` VALUES (45, 'D1290001', 'D1290024', 2.0000, 2.0000, 3.0000, b'1', 3.0000, 'admin', 1547177264, '1');
INSERT INTO `t_bas_producebom` VALUES (44, 'D1290001', 'D1030014', 2.0000, 2.0000, 3.0000, b'1', 3.0000, 'admin', 1547177264, '3');
INSERT INTO `t_bas_producebom` VALUES (14, 'PA002', '0', 0.0000, 0.0000, 0.0000, b'0', 99.5555, 'admin', 1524548152, NULL);
INSERT INTO `t_bas_producebom` VALUES (13, 'PA001', '0', 0.0000, 0.0000, 0.0000, b'0', 99.5555, 'admin', 1524548152, NULL);
INSERT INTO `t_bas_producebom` VALUES (47, 'D1290024', '3323', 3.0000, 3.0000, 3.0000, b'1', 1.0000, 'admin', 1547426232, '2');
INSERT INTO `t_bas_producebom` VALUES (48, 'D1290024', 'PA009', 1.0000, 1.0000, 1.0000, b'1', 1.0000, 'admin', 1547426232, '1');
INSERT INTO `t_bas_producebom` VALUES (49, 'D1030014', 'PA004', 5.0000, 5.0000, 5.0000, b'1', 4.0000, 'admin', 1547427829, '5');
INSERT INTO `t_bas_producebom` VALUES (50, 'D1030014', 'D1290023', 5.0000, 5.0000, 5.0000, b'1', 4.0000, 'admin', 1547427829, '4');
INSERT INTO `t_bas_producebom` VALUES (51, 'PA009', 'PA008', 8.0000, 5.0000, 5.0000, b'0', 55.0000, 'admin', 1547428451, '5');
INSERT INTO `t_bas_producebom` VALUES (52, 'D1290035', 'PA001', 5.0000, 5.0000, 5.0000, b'1', 99.0000, 'admin', 1547617270, '5');
INSERT INTO `t_bas_producebom` VALUES (53, 'D1290035', 'PA002', 2.0000, 2.0000, 2.0000, b'1', 99.0000, 'admin', 1547617270, '2');
-- ----------------------------
-- Table structure for t_box_basic_info
-- ----------------------------
DROP TABLE IF EXISTS `t_box_basic_info`;
CREATE TABLE `t_box_basic_info` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`box_identify` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '箱子识别号',
`inspection_interval` int(11) NULL DEFAULT NULL COMMENT '检验周期',
`depart_id` int(11) NULL DEFAULT NULL COMMENT '所属部门',
`material` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '箱子材质',
`box_L` int(11) NULL DEFAULT NULL COMMENT '箱子长度',
`box_W` int(11) NULL DEFAULT NULL COMMENT '箱子宽度',
`box_H` int(11) NULL DEFAULT NULL COMMENT '箱子高度',
`use_state` int(11) NULL DEFAULT NULL COMMENT '0使用中,-1不使用中',
`box_tare` float(11, 3) NULL DEFAULT NULL COMMENT '箱子皮重',
`weight_date` int(11) NULL DEFAULT NULL COMMENT '箱子称重日期',
`stock_state` int(11) NULL DEFAULT NULL COMMENT '库存状态 1:在库,-1出库',
`modman` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经办人',
`moddate` int(11) NULL DEFAULT NULL COMMENT '经办日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 12 CHARACTER SET = utf8 CHECKSUM = 1 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_box_basic_info
-- ----------------------------
INSERT INTO `t_box_basic_info` VALUES (8, '20003', 6666, 4, '1', 1, 1, 1, 0, 3.000, NULL, 1, 'admin', 1546399698);
INSERT INTO `t_box_basic_info` VALUES (9, '20002', 33, 4, 't', 2, 2, 2, NULL, 2.000, NULL, -1, 'admin', 1546397572);
INSERT INTO `t_box_basic_info` VALUES (10, '20004', 888, 4, '7', 7, 7, 7, NULL, 999.000, NULL, NULL, 'admin', 1547003668);
INSERT INTO `t_box_basic_info` VALUES (11, '10001', 50, 3, '213', 2, 2, 2, NULL, 2222.000, NULL, NULL, 'admin', 1547003675);
-- ----------------------------
-- Table structure for t_box_inspection
-- ----------------------------
DROP TABLE IF EXISTS `t_box_inspection`;
CREATE TABLE `t_box_inspection` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`box_identify` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`weight_tare` float(10, 3) NULL DEFAULT NULL,
`modman` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`moddate` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_box_inspection
-- ----------------------------
INSERT INTO `t_box_inspection` VALUES (17, '20003', 1.000, 'admin', 1546399557);
INSERT INTO `t_box_inspection` VALUES (11, '10001', 2.000, 'admin', 1546397481);
INSERT INTO `t_box_inspection` VALUES (12, '20001', 1.000, 'admin', 1546397544);
INSERT INTO `t_box_inspection` VALUES (13, '20002', 2.000, 'admin', 1546397572);
INSERT INTO `t_box_inspection` VALUES (14, '20003', 1.000, 'admin', 1546398598);
INSERT INTO `t_box_inspection` VALUES (19, '20004', 7.000, 'admin', 1546399579);
INSERT INTO `t_box_inspection` VALUES (18, '20004', 7.000, 'admin', 1546399572);
INSERT INTO `t_box_inspection` VALUES (20, '20004', 999.000, 'admin', 1546399615);
INSERT INTO `t_box_inspection` VALUES (21, '20003', 3.000, 'admin', 1546399698);
INSERT INTO `t_box_inspection` VALUES (22, '10001', 2222.000, 'admin', 1546399816);
INSERT INTO `t_box_inspection` VALUES (23, '20004', 999.000, 'admin', 1547003668);
INSERT INTO `t_box_inspection` VALUES (24, '10001', 2222.000, 'admin', 1547003675);
-- ----------------------------
-- Table structure for t_box_stock_out_or_in
-- ----------------------------
DROP TABLE IF EXISTS `t_box_stock_out_or_in`;
CREATE TABLE `t_box_stock_out_or_in` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '1:入库 -1出库',
`box_identify` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`stock_state` int(11) NULL DEFAULT NULL,
`recipients` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '领用人/归还人',
`modman` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经办人',
`moddate` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 56 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_category
-- ----------------------------
DROP TABLE IF EXISTS `t_category`;
CREATE TABLE `t_category` (
`cate_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`cate_title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '1级分类',
`cate_order` int(11) NULL DEFAULT NULL COMMENT '排序',
`cate_parentid` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`cate_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_category
-- ----------------------------
INSERT INTO `t_category` VALUES (1, '汽车配件', 1, 0);
INSERT INTO `t_category` VALUES (2, '建筑配件', 2, 0);
INSERT INTO `t_category` VALUES (3, '机加工', 3, 0);
INSERT INTO `t_category` VALUES (4, '机械配件', 4, 0);
INSERT INTO `t_category` VALUES (24, '球碗', 1, 1);
INSERT INTO `t_category` VALUES (25, '胶套', 3, 1);
INSERT INTO `t_category` VALUES (26, 'test', 3, 1);
-- ----------------------------
-- Table structure for t_company
-- ----------------------------
DROP TABLE IF EXISTS `t_company`;
CREATE TABLE `t_company` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`company_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`industry` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`reg_asset` decimal(10, 2) NULL DEFAULT NULL,
`c_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`c_tel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`c_web` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`c_contact` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`c_note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`pstate` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_company
-- ----------------------------
INSERT INTO `t_company` VALUES (2, '天赢公司', NULL, NULL, '城阳', '123', NULL, NULL, NULL, '1');
INSERT INTO `t_company` VALUES (3, '重庆公司', NULL, NULL, '重庆', '456', NULL, NULL, NULL, '1');
INSERT INTO `t_company` VALUES (6, '控股公司', '房地产', 922112.00, '青岛市崂山区檀香湾2号楼2106', '0532-81923355', 'www.qdmds.com', '单某某', '控股', '1');
-- ----------------------------
-- Table structure for t_cust_customer
-- ----------------------------
DROP TABLE IF EXISTS `t_cust_customer`;
CREATE TABLE `t_cust_customer` (
`cust_id` int(10) NOT NULL AUTO_INCREMENT,
`cust_code` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '�����',
`cust_iscust` tinyint(4) NULL DEFAULT 1 COMMENT '客户标志',
`cust_isprov` tinyint(4) NULL DEFAULT NULL COMMENT '供应商',
`cust_isshiper` tinyint(4) NULL DEFAULT NULL COMMENT '是否货代',
`cust_isexport` tinyint(4) NULL DEFAULT NULL COMMENT '是否出口商',
`cust_isassist` tinyint(4) NULL DEFAULT NULL COMMENT '外协厂商标记',
`Ctt_id` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '单位类别',
`cust_hpcode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '助记码',
`cust_nameCn` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
`cust_shortname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称',
`cust_NameEn` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '英文名',
`ccl_code` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业类别编码',
`cec_code` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经济类型编码',
`cust_LinkMan` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
`cust_Manger` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人代表',
`cust_addrCn` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中文地址',
`cust_addrEn` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '英文地址',
`cust_zip` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮编',
`cust_tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '�绰',
`cust_fax` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '����',
`cust_mail` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '�����ʼ�',
`cust_web` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '��վ',
`cust_bank1` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '������1',
`cust_bankno1` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '�ʺ�1',
`cust_bank2` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '������2',
`cust_Bankno2` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '�ʺ�2',
`cust_Taxno` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '˰��',
`cust_Enabled` tinyint(4) NOT NULL DEFAULT 0 COMMENT '可用状态',
`cust_credit` int(11) NULL DEFAULT NULL COMMENT '信誉度',
`cust_note` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`cust_Man` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人',
`Cust_Delivery` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '交/送货地点',
`cust_FinDest` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目的地',
`Cp_PortId` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相关港口',
`Cust_RegDate` int(11) NULL DEFAULT NULL COMMENT '登记日期',
`ModMan` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '����',
`ModDate` int(11) NOT NULL COMMENT '������',
`Ord_Interior` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否本公司',
PRIMARY KEY (`cust_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_cust_customer
-- ----------------------------
INSERT INTO `t_cust_customer` VALUES (1, '2018070300', 1, 0, 1, 1, 0, '03', '211', '测试', 'CS', 'ceshi', '03', '11', '周杰伦', '李宗盛', '台湾', 'taiwan', '4454121@qq', '18363958512', '052654845', '54512654', 'www.baudic.com', 'zhonghang', '4454115', '招商', '321321323', '554', 1, 1, '3213', '测试', '33', '11', '333', 0, 'admin', 1530378436, 1);
INSERT INTO `t_cust_customer` VALUES (6, '6', 1, 1, 1, 1, 0, '01', '4', '测试4433', '43', '55', '01', NULL, '4', '443', '9', '4', '2', '8', '4', '21', '7', '4', '2', '4', '222', '5', 1, -1, '324234234324', '44', '2', '5', '4', 0, 'admin', 1531723288, 0);
INSERT INTO `t_cust_customer` VALUES (7, '99', 0, 1, 0, 1, 1, '02', '789', '98', '89', 'yty', '01', NULL, '789', '897', '8', '87', '8', '8', '789', '8', '8', '78', '8', '8', '8', '8', 0, 0, '878987987', '8', '8', '8', '8', 1530778467, 'admin', 1530778467, 0);
INSERT INTO `t_cust_customer` VALUES (8, '2018070500', 1, 0, 1, 1, 0, '03', 'CS11', '测试11', 'cs11', 'ceshi11', '02', NULL, '李某1', '王某1', '青岛崂山', 'qingdaolaoshan1', '266000', '18363970368', '053254211', '[email protected]', 'www.baidu.com', '中国银行', '370986589854562157', '招商银行', '845623587468542668', '15264325894521', 1, -1, '测试测试测试锤石是回复此誓师大会四大行上帝之手21212', '孙某某', '青岛', '上海', '青岛港', 0, 'admin', 1531096838, 1);
INSERT INTO `t_cust_customer` VALUES (5, '32121', 1, 1, 1, 1, 0, '01', 'DSGDFG', '测试321', '23', '123', '01', NULL, '123', '443', '6', '321', '4656', '5', '23', '3454', '4', '54', '3432', '54', '234', '4', 0, 0, '65654654324', '45', '342', '2', '54', 0, 'admin', 1531723272, 0);
INSERT INTO `t_cust_customer` VALUES (9, '22222', 1, 1, 1, 1, 0, '02', 'cs12344', '测试12344', 'ces', 'ceshi12344', '02', NULL, '赵某', '李某', '北京', 'beijing', '256222', '183639720368', '025462132', '[email protected]', 'www.ndhd.com', '中银', '45652154497445541', '招银', '656464648979641631634164', '', 1, 0, '问问群二无群二群二群二', '单某某某', '巴黎', '法国', '青岛港q1', 0, 'admin', 1531721553, 0);
INSERT INTO `t_cust_customer` VALUES (15, '123', 1, 0, 0, 1, 0, '02', 'DSGDFG', '第三个电饭锅', '', '', '02', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 1, '', '', '', '', '', 1531447819, 'admin', 1531447819, 0);
INSERT INTO `t_cust_customer` VALUES (17, '2018337445', 1, 1, 1, 1, 0, '03', 'SSFJCCX', '市司法局常出现', 'shd', 'dddfd', '01', NULL, '张三', '李四', '青岛崂山', 'qingdao', '266000', '18365951265', '053256842564', '[email protected]', 'www.gdyns.com', '招商', '1225441223554212363', '光大', '1445115484565241445', '5452145d5e5sw5s544', 1, 0, '圣诞节金额现场最下面炒鸡蛋放放假倒计时法新材料是龙卷风的金额将额外企鹅地方吗', '王五', '青岛港口', '广州', '广州港', 0, 'admin', 1531796737, 0);
INSERT INTO `t_cust_customer` VALUES (18, 'test', 1, 1, NULL, NULL, NULL, '01', 'LXM', '李晓明', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, 1536293009, 'admin', 1536293009, 0);
INSERT INTO `t_cust_customer` VALUES (19, 'cy911', 0, 1, 1, 0, 0, '01', 'CSYX', '城市印象', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, 1536299893, 'admin', 1536299893, 0);
INSERT INTO `t_cust_customer` VALUES (20, '0001', 1, 0, 0, 0, 0, '01', 'QDMDS', '青岛麦迪绅', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1536300115, 'admin', 1536300115, 1);
INSERT INTO `t_cust_customer` VALUES (21, '0002', 0, 0, 0, 0, 0, '01', 'ZXCGV', '自行车GV', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, 1536300809, 'admin', 1536300809, 0);
INSERT INTO `t_cust_customer` VALUES (22, '900878', 0, 0, 0, 0, 1, '01', '123123', '123123', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 1537240007, 'admin', 1537240007, 0);
INSERT INTO `t_cust_customer` VALUES (23, '1231233333', 0, 0, 0, 0, 1, '01', '123', '123', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 1537240463, 'admin', 1537240463, 1);
INSERT INTO `t_cust_customer` VALUES (24, '3453454', 0, 0, 0, 0, 1, '01', 'ttttttt', 'ttttttt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 1537240481, 'admin', 1537240481, 0);
INSERT INTO `t_cust_customer` VALUES (25, '55555', 0, 0, 0, 0, 1, '01', '555555', '555555', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, 1537240497, 'admin', 1537240497, 0);
-- ----------------------------
-- Table structure for t_dat_storage
-- ----------------------------
DROP TABLE IF EXISTS `t_dat_storage`;
CREATE TABLE `t_dat_storage` (
`Stor_id` int(11) NOT NULL AUTO_INCREMENT,
`Stor_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '仓库编号',
`Stor_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '仓库名称',
`Sp_ParentNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '父仓库编号',
`Sp_GetNo` int(11) NULL DEFAULT NULL COMMENT '物流取货号',
`st_code` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型编码',
`ss_code` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态编码',
`Stor_L` int(11) NULL DEFAULT NULL COMMENT '长',
`Stor_W` int(11) NULL DEFAULT NULL COMMENT '宽',
`Stor_H` int(11) NULL DEFAULT NULL COMMENT '高',
`Stor_capability` int(11) NULL DEFAULT NULL COMMENT '容量',
`Stor_unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位',
`Stor_tempe` int(11) NULL DEFAULT NULL COMMENT '温度',
`Stor_humidity` int(11) NULL DEFAULT NULL COMMENT '湿度',
`Stor_position` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '位置',
`Stor_depart` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门',
`Stor_tel` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Stor_fax` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Stor_usable` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否可用',
`Stor_manager` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '库管员',
`Stor_description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`Stor_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 301 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_dat_storage
-- ----------------------------
INSERT INTO `t_dat_storage` VALUES (1, '01', '1号库', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (2, '02', '2号库', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (8, '010013', '3号', '01001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'0', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (9, '010015', '5号', '01001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'0', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (245, '02001016', '02001016号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (13, '010038', '45647号', '01003', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'0', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (236, '02001007', '02001007号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (235, '02001006', '02001006号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (18, '04', '4号库', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (23, '04003', '04003架', '04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (165, '01006', '01006架', '01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'0', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (231, '02001002', '02001002号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (232, '02001003', '02001003号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (233, '02001004', '02001004号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (40, '04003001', '04003001号', '04003', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (246, '02001017', '02001017号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (42, '04003003', '04003003号', '04003', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (43, '04003004', '04003004号', '04003', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (44, '04003005', '04003005号', '04003', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (237, '02001008', '02001008号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (238, '02001009', '02001009号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (239, '02001010', '02001010号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (240, '02001011', '02001011号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (241, '02001012', '02001012号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (242, '02001013', '02001013号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (243, '02001014', '02001014号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (244, '02001015', '02001015号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (248, '02001019', '02001019号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (247, '02001018', '02001018号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (230, '02001001', '02001001号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (160, '01010', '01010架', '01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'0', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (161, '01011', '01011架', '01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (234, '02001005', '02001005号', '02001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (227, '02001', '02001架', '02', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (290, '04003006', '04003006号', '04003', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (291, '04003007', '04003007号', '04003', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (292, '04003008', '04003008号', '04003', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (293, '04003009', '04003009号', '04003', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (294, '04003010', '04003010号', '04003', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (298, '04002', '04002', '04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (297, '04001', '04001', '04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (299, '04001001', '04001001', '04001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
INSERT INTO `t_dat_storage` VALUES (300, '04001002', '04001002', '04001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, b'1', NULL, NULL);
-- ----------------------------
-- Table structure for t_depart
-- ----------------------------
DROP TABLE IF EXISTS `t_depart`;
CREATE TABLE `t_depart` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Parentid` int(11) NULL DEFAULT NULL COMMENT '父id',
`Dpt_Name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称',
`Dpt_MainMan` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主要负责人',
`Dpt_Persons` int(11) NULL DEFAULT NULL COMMENT '人数',
`Dpt_Tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
`Dpt_Describe` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
`Dpt_Order` int(11) NULL DEFAULT NULL,
`pstate` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
`ModMan` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`ModDate` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_depart
-- ----------------------------
INSERT INTO `t_depart` VALUES (1, 0, '青岛天赢工业', '', NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `t_depart` VALUES (2, 1, '生产管理部', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `t_depart` VALUES (9, 1, '贸易部', '', NULL, '', '', NULL, '1', '', '2017-11-08 10:46:30');
INSERT INTO `t_depart` VALUES (4, 2, '铸锻车间', '刘国喜', NULL, NULL, NULL, NULL, '1', NULL, NULL);
INSERT INTO `t_depart` VALUES (5, 2, '机加工车间', '刘琦', 0, '', '', 7, '1', NULL, NULL);
INSERT INTO `t_depart` VALUES (6, 2, '管件车间', '王思', 0, '', '', 6, '1', NULL, NULL);
INSERT INTO `t_depart` VALUES (7, 9, '内贸', NULL, NULL, NULL, NULL, 1, '1', NULL, NULL);
INSERT INTO `t_depart` VALUES (10, 9, '外贸', '', 0, '', '', 0, '1', NULL, NULL);
INSERT INTO `t_depart` VALUES (13, 2, '模具车间', 'dd', 5, '', '', 8, '1', NULL, NULL);
INSERT INTO `t_depart` VALUES (3, 2, '下料车间', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL);
-- ----------------------------
-- Table structure for t_device
-- ----------------------------
DROP TABLE IF EXISTS `t_device`;
CREATE TABLE `t_device` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sect_id` int(11) NULL DEFAULT NULL COMMENT ' 所属分区ID',
`device_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编号',
`device_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
`vender` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '厂家名称',
`tech_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '技术文档编号',
`contactman` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
`contactphone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
`device_state` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备状态',
`modman` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
`moddate` int(11) NULL DEFAULT NULL COMMENT '修改日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_device
-- ----------------------------
INSERT INTO `t_device` VALUES (1, 1, '0001', '1号压力机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (2, 1, '0002', '2号压力机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (3, 1, '0003', '1号电热炉', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (4, 1, '0004', '3号机器人', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (5, 1, '0005', '2号精压机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (6, 2, '0006', '3号压力机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (7, 2, '0007', '4号压力机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (8, 2, '0008', '2号电热炉', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (9, 2, '0009', '4号机器人', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (22, 2, 't', 't222', '测试321', 't', '123', '5', NULL, 'admin', 1544167786);
INSERT INTO `t_device` VALUES (12, 4, '0012', '5号精压机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (13, 4, '0013 ', '6号精压机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (14, 5, '0014', '7号精压机', '测试321', 't', '123', '5', NULL, 'admin', 1543824868);
INSERT INTO `t_device` VALUES (15, 6, '0015', '7号精压机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (16, 7, '0016', '8号精压机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (17, 7, '0017', '9号精压机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (18, 8, '0018', '10号精压机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (19, 8, '0019', '11号精压机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (20, 9, '0020', '12号精压机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `t_device` VALUES (21, 9, '0021', '13号精压机', NULL, NULL, NULL, NULL, NULL, NULL, NULL);