crpm-proj-code-set/qysczyjhxt/sql/data/crpm_bf21f2_92933a.sql
2025-06-30 15:17:54 +08:00

10 lines
2.9 KiB
SQL

INSERT INTO `crpm_bf21f2_92933a` (`ddbh`,`cpmc`,`scsl`,`jhkssj`,`jhjssj`,`sjkssj`,`sjjssj`,`scx`,`fzr`,`zt`,`bz`) VALUES ('ORD-202405001','智能温控器','5000','2024-05-01 08:00:00','2024-05-10 17:00:00','2024-05-01 08:30:00','2024-05-09 16:30:00','S-01','张明','已完成','提前1天交付');
INSERT INTO `crpm_bf21f2_92933a` (`ddbh`,`cpmc`,`scsl`,`jhkssj`,`jhjssj`,`sjkssj`,`sjjssj`,`scx`,`fzr`,`zt`,`bz`) VALUES ('ORD-202405002','工业传感器','2000','2024-05-05 09:30:00','2024-05-20 16:30:00','2024-05-06 10:15:00','2024-05-22 17:45:00','S-03','李华','已完成','设备调试延迟2天');
INSERT INTO `crpm_bf21f2_92933a` (`ddbh`,`cpmc`,`scsl`,`jhkssj`,`jhjssj`,`sjkssj`,`sjjssj`,`scx`,`fzr`,`zt`,`bz`) VALUES ('ORD-202405003','液压阀组','800','2024-05-10 08:00:00','2024-05-25 17:00:00','2024-05-10 08:00:00','2024-05-28 18:30:00','S-02','王强','已完成','质检返工3天');
INSERT INTO `crpm_bf21f2_92933a` (`ddbh`,`cpmc`,`scsl`,`jhkssj`,`jhjssj`,`sjkssj`,`sjjssj`,`scx`,`fzr`,`zt`,`bz`) VALUES ('ORD-202405004','新能源电池组','300','2024-05-15 09:00:00','2024-05-30 16:00:00','2024-05-16 13:00:00','2024-05-29 15:00:00','S-05','赵刚','已完成','物料短缺延迟1天');
INSERT INTO `crpm_bf21f2_92933a` (`ddbh`,`cpmc`,`scsl`,`jhkssj`,`jhjssj`,`sjkssj`,`sjjssj`,`scx`,`fzr`,`zt`,`bz`) VALUES ('ORD-202405005','精密齿轮箱','150','2024-05-20 08:30:00','2024-06-04 17:30:00','2024-05-20 08:30:00','2024-06-05 18:00:00','S-04','陈杰','已完成','工艺优化提前1天');
INSERT INTO `crpm_bf21f2_92933a` (`ddbh`,`cpmc`,`scsl`,`jhkssj`,`jhjssj`,`sjkssj`,`sjjssj`,`scx`,`fzr`,`zt`,`bz`) VALUES ('ORD-202405006','伺服电机','1000','2024-05-25 09:15:00','2024-06-09 16:45:00','2024-05-26 11:00:00','2024-06-10 17:15:00','S-01','刘芳','进行中','缺料等待3天');
INSERT INTO `crpm_bf21f2_92933a` (`ddbh`,`cpmc`,`scsl`,`jhkssj`,`jhjssj`,`sjkssj`,`sjjssj`,`scx`,`fzr`,`zt`,`bz`) VALUES ('ORD-202405007','自动化控制器','600','2024-05-30 08:00:00','2024-06-14 17:00:00','2024-05-30 08:00:00','2024-06-12 16:30:00','S-03','周明','已完成','按计划交付');
INSERT INTO `crpm_bf21f2_92933a` (`ddbh`,`cpmc`,`scsl`,`jhkssj`,`jhjssj`,`sjkssj`,`sjjssj`,`scx`,`fzr`,`zt`,`bz`) VALUES ('ORD-202405008','高速轴承','2500','2024-06-01 09:30:00','2024-06-15 16:30:00','2024-06-02 10:00:00','2024-06-16 17:45:00','S-02','吴敏','进行中','模具故障延迟1天');
INSERT INTO `crpm_bf21f2_92933a` (`ddbh`,`cpmc`,`scsl`,`jhkssj`,`jhjssj`,`sjkssj`,`sjjssj`,`scx`,`fzr`,`zt`,`bz`) VALUES ('ORD-202405009','智能配电箱','400','2024-06-05 08:00:00','2024-06-20 17:00:00','2024-06-05 08:00:00','2024-06-20 17:00:00','S-04','郑伟','计划中','待物料到位');
INSERT INTO `crpm_bf21f2_92933a` (`ddbh`,`cpmc`,`scsl`,`jhkssj`,`jhjssj`,`sjkssj`,`sjjssj`,`scx`,`fzr`,`zt`,`bz`) VALUES ('ORD-202405010','光伏逆变器','200','2024-06-10 09:00:00','2024-06-25 16:00:00','2024-06-10 09:00:00','2024-06-25 16:00:00','S-05','孙鹏','计划中','等待设计确认');