inst_goods_site.sql

用VC编写的立体仓库的管理软件源程序和设计说明书。

--LGV任务表
insert into T_LGV (TaskID) values(1)

--颜色管理表
INSERT INTO T_Colors (F_Color) VALUES('黄色')
INSERT INTO T_Colors (F_Color) VALUES('红色')
INSERT INTO T_Colors (F_Color) VALUES('青色')
INSERT INTO T_Colors (F_Color) VALUES('黑色')
INSERT INTO T_Colors (F_Color) VALUES('白色')
INSERT INTO T_Colors (F_Color) VALUES('紫色')
INSERT INTO T_Colors (F_Color) VALUES('蓝色')
INSERT INTO T_Colors (F_Color) VALUES('绿色')

--计量单位表
INSERT INTO T_Units (F_Unit) VALUES('个')
INSERT INTO T_Units (F_Unit) VALUES('只')
INSERT INTO T_Units (F_Unit) VALUES('台')
INSERT INTO T_Units (F_Unit) VALUES('套')
INSERT INTO T_Units (F_Unit) VALUES('件')
INSERT INTO T_Units (F_Unit) VALUES('米')
INSERT INTO T_Units (F_Unit) VALUES('吨')

--仓库设备表
INSERT INTO T_Device(F_Index, F_Name)	VALUES(1,  '堆垛机')
INSERT INTO T_Device(F_Index, F_Name)	VALUES(2,  'LGV')
INSERT INTO T_Device(F_Index, F_Name)	VALUES(3,  '输送线')
INSERT INTO T_Device(F_Index, F_Name)	VALUES(4,  '码垛机器人')
INSERT INTO T_Device(F_Index, F_Name)	VALUES(5,  '搬箱机器人')
INSERT INTO T_Device(F_Index, F_Name)	VALUES(6,  '拆叠盘一体机')

--货位状态信息表
INSERT INTO T_Site_State(F_Index, F_Name)VALUES(0, '空')
INSERT INTO T_Site_State(F_Index, F_Name)VALUES(1, '有货')
INSERT INTO T_Site_State(F_Index, F_Name)VALUES(2, '有货占用')
INSERT INTO T_Site_State(F_Index, F_Name)VALUES(3, '无货占用')
INSERT INTO T_Site_State(F_Index, F_Name)VALUES(4, '禁用')

--任务状态信息表
INSERT INTO T_Task_State(F_Index, F_Name)VALUES(0,'等待')
INSERT INTO T_Task_State(F_Index, F_Name)VALUES(1,'执行')
INSERT INTO T_Task_State(F_Index, F_Name)VALUES(10,'任务非法')
INSERT INTO T_Task_State(F_Index, F_Name)VALUES(990,'取消')
INSERT INTO T_Task_State(F_Index, F_Name)VALUES(991,'手工完成')
INSERT INTO T_Task_State(F_Index, F_Name)VALUES(998,'批次完成')
INSERT INTO T_Task_State(F_Index, F_Name)VALUES(999,'完成')

--任务种类信息表
insert into T_Task_Kind(F_Index, F_Name)values(1,'整盘入库')
insert into T_Task_Kind(F_Index, F_Name)values(2,'整盘出库')
insert into T_Task_Kind(F_Index, F_Name)values(3,'分拣出库')
insert into T_Task_Kind(F_Index, F_Name)values(4,'分拣入库')
insert into T_Task_Kind(F_Index, F_Name)values(5,'导库任务')
insert into T_Task_Kind(F_Index, F_Name)values(6,'取托盘垛')
insert into T_Task_Kind(F_Index, F_Name)values(7,'取空货箱')

--任务优先级信息表
INSERT INTO T_Task_Level(F_Index, F_Name)VALUES(1, '一级优先')
INSERT INTO T_Task_Level(F_Index, F_Name)VALUES(2, '二级优先')
INSERT INTO T_Task_Level(F_Index, F_Name)VALUES(3, '三级优先')
INSERT INTO T_Task_Level(F_Index, F_Name)VALUES(4, '四级优先')
INSERT INTO T_Task_Level(F_Index, F_Name)VALUES(5, '五级优先')
INSERT INTO T_Task_Level(F_Index, F_Name)VALUES(6, '六级优先')

--分拣线上位置坐标、状态		
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(1,0.35,0.44,0.38,0.47,1)	--木块1
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(2,0.38,0.44,0.41,0.47,1)	--木块2
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(3,0.41,0.44,0.44,0.47,1)	--木块3
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(4,0.35,0.47,0.38,0.5,1)	--木块4
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(5,0.38,0.47,0.41,0.5,1)	--木块5
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(6,0.41,0.47,0.44,0.5,1)	--木块6
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(7,0.35,0.5,0.38,0.53,1)	--木块7
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(8,0.38,0.5,0.41,0.53,1)	--木块8
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(9,0.41,0.5,0.44,0.53,1)	--木块9
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(10,0.47,0.44,0.5,0.47,1)	--木块10
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(11,0.5,0.44,0.53,0.47,1)	--木块11
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(12,0.53,0.44,0.56,0.47,1)	--木块12

INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(13,0.119,0.44,0.149,0.485,2)	--箱子1
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(14,0.164,0.44,0.194,0.485,2)	--箱子2
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(15,0.209,0.44,0.239,0.485,2)	--箱子3
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(16,0.209,0.205,0.239,0.25,2)	--箱子4
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(17,0.239,0.205,0.269,0.25,2)	--箱子5
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(18,0.239,0.485,0.269,0.53,2)	--箱子6
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(19,0.164,0.485,0.194,0.53,2)	--箱子7
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(20,0.119,0.485,0.149,0.53,2)	--箱子8

INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(21,0.013,0.44,0.063,0.55,3)	--托盘1
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(22,0.013,0.61,0.063,0.72,3)	--托盘2
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(23,0.068,0.44,0.118,0.55,3)	--托盘3
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(24,0.068,0.61,0.118,0.72,3)	--托盘4
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(25,0.29,0.44,0.34,0.55,3)	--托盘5
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(26,0.29,0.61,0.34,0.72,3)	--托盘6
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(27,0.58,0.44,0.63,0.55,3)	--托盘7
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(28,0.58,0.61,0.63,0.72,3)	--托盘8
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(29,0.41,0.545,0.48,0.615,3)	--托盘9
INSERT INTO T_Device_Site_State(F_Index,F_Point_x1,F_Point_y1,F_Point_x2,F_Point_y2,F_Kind)VALUES(30,0.0,0.0,0.0,0.0,4)		--堆垛机

INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(5,'LGV控制台停车')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(6,'LGV发生碰撞')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(7,'LGV地标丢失')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(9,'LGV导航带丢失')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(10,'LGV电池电压过低')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(11,'LGV伺服轴超差')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(12,'LGV伺服驱动故障')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(13,'LGV伺服电源故障')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(14,'LGV移载过程中断')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(101,'堆垛机货物超限')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(102,'堆垛机满货位入库')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(103,'堆垛机空货位出库')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(104,'堆垛机运行超时')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(105,'堆垛机变频器报警')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(106,'堆垛机传送地址错')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(107,'堆垛机通信故障')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(108,'堆垛机水平前端超限')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(109,'堆垛机水平后端超限')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(110,'堆垛机垂直上端超限')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(111,'堆垛机垂直下端超限')
INSERT INTO T_Device_Fault_Show(F_Index, F_Remark) VALUES(112,'堆垛机叉不在原位')