device_out.java

库存管理子系统帮助企业的仓库管理人员对库存物品的入库

							while(rs.next())
							{
								total=rs.getInt(1);
							}
						}
						catch(SQLException e)
						{
							JOptionPane.showMessageDialog(null,"数据库操作失败！");
						}
						if(total<Integer.parseInt(s4))
						{
							JOptionPane.showMessageDialog(null,"本次出库原材料的数量超出仓库中的总数量！");
							closeDB();
						}
						else
						{
							String s=getTime();
							query="insert into log(device_name,time,kind,reason,numbers,price,id) values(?,?,?,?,?,?,?);";
							try
							{
								pstmt=con.prepareStatement(query);
								pstmt.setString(1,s3);//原材料名称
								pstmt.setString(2,s);//出库时间
								pstmt.setString(3,s1);//类别
								pstmt.setString(4,s2);//原因
								pstmt.setString(5,s4);//数目
								pstmt.setString(6,s5);//单价
								pstmt.setInt(7,id);
								pstmt.execute();
							}
							catch(SQLException e)
							{
								JOptionPane.showMessageDialog(null,"数据库操作失败！");
							}
							query="update yuancailiao_total set total_number=total_number-?,total_money=total_money-? where device_name=?;";
							try
							{
								pstm=con.prepareStatement(query);
								pstm.setInt(1,Integer.parseInt(s4));
								pstm.setFloat(2,Integer.parseInt(s4)*Float.parseFloat(s5));
								pstm.setString(3,s3);
								pstm.execute();								
							}
							catch(SQLException e)
							{
								JOptionPane.showMessageDialog(null,"数据库操作失败！");
							}
							JOptionPane.showMessageDialog(null,"原材料已成功出库！");	
							closeDB1();
						}
					}
				}
			}
			else if(id==5)
			{
				if(s3.length()==0)
				{
					JOptionPane.showMessageDialog(null,"请输入出库半成品的名称！");
					tf3.requestFocus();//获得焦点
				}
				else if(s4.length()==0)
				{
					JOptionPane.showMessageDialog(null,"请输入出库半成品的数目！");
					tf4.requestFocus();//获得焦点
				}
				else if(isInt(s4))
				{
					JOptionPane.showMessageDialog(null,"请输入正确的整数！");
					tf4.setText("");
					tf4.requestFocus();
				}
				else
				{
					connDB();
					String query="select * from banchengping_total where device_name='"+s3+"';";
					try
					{
						rs=st.executeQuery(query);
						while (rs.next())
						{
							suc=true;
						}
					}
					catch(SQLException e)
					{
						JOptionPane.showMessageDialog(null,"数据库操作失败！");
					}
					if(suc==false)
					{
						JOptionPane.showMessageDialog(null,"仓库中不存在这种半成品");
						closeDB();
					}
					else
					{
						query="select total_number from banchengping_total where device_name='"+s3+"';";
						try
						{
							rs=st.executeQuery(query);
							while(rs.next())
							{
								total=rs.getInt(1);
							}
						}
						catch(SQLException e)
						{
							JOptionPane.showMessageDialog(null,"数据库操作失败！");
						}
						if(total<Integer.parseInt(s4))
						{
							JOptionPane.showMessageDialog(null,"本次出库半成品的数量超出仓库中的总数量！");
							closeDB();
						}
						else
						{
							String s=getTime();
							query="insert into log(device_name,time,kind,numbers,id) values(?,?,?,?,?);";
							try
							{
								pstmt=con.prepareStatement(query);
								pstmt.setString(1,s3);//原材料名称
								pstmt.setString(2,s);//出库时间
								pstmt.setString(3,s1);//类别
								pstmt.setString(4,s4);//数目
								pstmt.setInt(5,id);
								pstmt.execute();
							}
							catch(SQLException e)
							{
								JOptionPane.showMessageDialog(null,"数据库操作失败！");
							}
							query="update banchengping_total set total_number=total_number-? where device_name=?;";
							try
							{
								pstm=con.prepareStatement(query);
								pstm.setInt(1,Integer.parseInt(s4));
								pstm.setString(2,s3);
								pstm.execute();								
							}
							catch(SQLException e)
							{
								JOptionPane.showMessageDialog(null,"数据库操作失败！");
							}
							JOptionPane.showMessageDialog(null,"半成品已成功出库！");	
							closeDB1();
						}
					}
				}
			}
			else if(id==6)
			{
				if(s3.length()==0)
				{
					JOptionPane.showMessageDialog(null,"请输入出库成品的名称！");
					tf3.requestFocus();//获得焦点
				}
				else if(s4.length()==0)
				{
					JOptionPane.showMessageDialog(null,"请输入出库成品的数目！");
					tf4.requestFocus();//获得焦点
				}
				else if(isInt(s4))
				{
					JOptionPane.showMessageDialog(null,"请输入正确的整数！");
					tf4.setText("");
					tf4.requestFocus();
				}
				else
				{
					connDB();
					String query="select * from chengping_total where device_name='"+s3+"';";
					try
					{
						rs=st.executeQuery(query);
						while (rs.next())
						{
							suc=true;
						}
					}
					catch(SQLException e)
					{
						JOptionPane.showMessageDialog(null,"数据库操作失败！");
					}
					if(suc==false)
					{
						JOptionPane.showMessageDialog(null,"仓库中不存在这种成品");
						closeDB();
					}
					else
					{
						query="select total_number from chengping_total where device_name='"+s3+"';";
						try
						{
							rs=st.executeQuery(query);
							while(rs.next())
							{
								total=rs.getInt(1);
							}
						}
						catch(SQLException e)
						{
							JOptionPane.showMessageDialog(null,"数据库操作失败！");
						}
						if(total<Integer.parseInt(s4))
						{
							JOptionPane.showMessageDialog(null,"本次出库成品的数量超出仓库中的总数量！");
							closeDB();
						}
						else
						{
							String s=getTime();
							query="insert into log(device_name,time,kind,reason,numbers,id) values(?,?,?,?,?,?);";
							try
							{
								pstmt=con.prepareStatement(query);
								pstmt.setString(1,s3);//原材料名称
								pstmt.setString(2,s);//出库时间
								pstmt.setString(3,s1);//类别
								pstmt.setString(4,s2);//原因
								pstmt.setString(5,s4);//数目
								pstmt.setInt(6,id);
								pstmt.execute();
							}
							catch(SQLException e)
							{
								JOptionPane.showMessageDialog(null,"数据库操作失败！");
							}
							query="update chengping_total set total_number=total_number-? where device_name=?;";
							try
							{
								pstm=con.prepareStatement(query);
								pstm.setInt(1,Integer.parseInt(s4));
								pstm.setString(2,s3);
								pstm.execute();								
							}
							catch(SQLException e)
							{
								JOptionPane.showMessageDialog(null,"数据库操作失败！");
							}
							JOptionPane.showMessageDialog(null,"成品已成功出库！");	
							closeDB1();
						}
					}
				}
			}

		}
	};
	Font f=new Font("Monospaced", Font.PLAIN,12);
	private JLabel deviceout=new JLabel("出库管理",SwingConstants.CENTER);

	private String[] cailiao={"原材料出库","半成品出库","成品出库"};
	private String[] yuancailiao={"不合格原材料(退货)出库","外借出原材料(其他企业)出库","合格原材料(生产)出库","呆滞原材料(处理)出库"};
	private String[] chengping={"不合格成品(再生产)出库","外借成品(其他企业)出库","合格成品(销售)出库","呆滞成品(处理)出库"};
	DefaultComboBoxModel model1=new DefaultComboBoxModel(cailiao);
	DefaultComboBoxModel model2=new DefaultComboBoxModel(yuancailiao);
	DefaultComboBoxModel model3=new DefaultComboBoxModel(chengping);
	JComboBox cai_liao=new JComboBox(model1);
	JComboBox yuancailiao_chengping=new JComboBox(model2);

	private JLabel l0=new JLabel("请选择出库材料类别：",SwingConstants.CENTER);
	private JLabel l2=new JLabel("请选择出库原因：",SwingConstants.CENTER);
	private JLabel l3=new JLabel("请输入出库材料名称：",SwingConstants.CENTER);
	private JTextField tf3=new JTextField(20);
	private JLabel l4=new JLabel("请输入出库材料数目：",SwingConstants.CENTER);
	private JTextField tf4=new JTextField(20);
	private JLabel l5=new JLabel("请输入出库材料单价：",SwingConstants.CENTER);
	private JTextField tf5=new JTextField(20);
	
	private JLabel description0=new JLabel("出库管理：记录每一种原材料，半成品，成品出库的情况",SwingConstants.CENTER);

	private Connection con=null; 
	private Statement st=null;
	private ResultSet rs=null;
	private PreparedStatement pstmt=null;
	private PreparedStatement pstm=null;
}