shangpinxiaoshou.java

企业进销存管理 包括了基本的企业管理的基本功能

		getContentPane().add(label_3, gridBagConstraints_8);
		label_3.setFont(new Font("", Font.PLAIN, 14));
		label_3.setText("结算方式：");

		jsMode = new JComboBox();
		jsMode.setMaximumRowCount(9);
		final GridBagConstraints gridBagConstraints_9 = new GridBagConstraints();
		gridBagConstraints_9.ipadx = 10;
		gridBagConstraints_9.insets = new Insets(0, 0, 5, 0);
		gridBagConstraints_9.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_9.gridy = 4;
		gridBagConstraints_9.gridx = 12;
		getContentPane().add(jsMode, gridBagConstraints_9);
		jsMode.setModel(new DefaultComboBoxModel(new String[]{"现金", "支票"}));
		jsMode.setFont(new Font("", Font.PLAIN, 14));

		final JLabel label_11 = new JLabel();
		label_11.setFont(new Font("", Font.PLAIN, 14));
		label_11.setText("规格：");
		final GridBagConstraints gridBagConstraints_19 = new GridBagConstraints();
		gridBagConstraints_19.gridy = 4;
		gridBagConstraints_19.gridx = 13;
		getContentPane().add(label_11, gridBagConstraints_19);

		guige = new JComboBox();
		guige.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				if(guige.getSelectedItem()!=null)
					updateDanjia();
			}
		});
		guige.setMaximumRowCount(9);
		final GridBagConstraints gridBagConstraints_20 = new GridBagConstraints();
		gridBagConstraints_20.ipadx = 35;
		gridBagConstraints_20.insets = new Insets(0, 0, 5, 5);
		gridBagConstraints_20.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_20.gridy = 4;
		gridBagConstraints_20.gridx = 15;
		getContentPane().add(guige, gridBagConstraints_20);

		final JSeparator separator = new JSeparator();
		final GridBagConstraints gridBagConstraints_21 = new GridBagConstraints();
		gridBagConstraints_21.ipady = 5;
		gridBagConstraints_21.gridwidth = 16;
		gridBagConstraints_21.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_21.gridy = 8;
		gridBagConstraints_21.gridx = 0;
		getContentPane().add(separator, gridBagConstraints_21);

		final JLabel label_4 = new JLabel();
		label_4.setFont(new Font("", Font.PLAIN, 14));
		label_4.setText("应收：");
		final GridBagConstraints gridBagConstraints_10 = new GridBagConstraints();
		gridBagConstraints_10.insets = new Insets(5, 5, 5, 0);
		gridBagConstraints_10.gridy = 9;
		gridBagConstraints_10.gridx = 0;
		getContentPane().add(label_4, gridBagConstraints_10);

		yingshou = new JTextField();
		yingshou.setEditable(false);
		final GridBagConstraints gridBagConstraints_11 = new GridBagConstraints();
		gridBagConstraints_11.weightx = 1.0;
		gridBagConstraints_11.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_11.insets = new Insets(5, 0, 5, 5);
		gridBagConstraints_11.ipadx = 80;
		gridBagConstraints_11.gridy = 9;
		gridBagConstraints_11.gridx = 2;
		getContentPane().add(yingshou, gridBagConstraints_11);

		final JLabel label_6 = new JLabel();
		label_6.setFont(new Font("", Font.PLAIN, 14));
		label_6.setText("实收：");
		final GridBagConstraints gridBagConstraints_5 = new GridBagConstraints();
		gridBagConstraints_5.ipadx = 5;
		gridBagConstraints_5.insets = new Insets(5, 0, 5, 0);
		gridBagConstraints_5.gridy = 9;
		gridBagConstraints_5.gridx = 5;
		getContentPane().add(label_6, gridBagConstraints_5);

		shishou = new JTextField();
		shuliang.addKeyListener(new InputKeyListener());
		shishou.addKeyListener(new KeyAdapter() {
			public void keyReleased(final KeyEvent e) {
				double ys=Double.parseDouble(yingshou.getText());
				double ss=Double.parseDouble(shishou.getText());
				weishou.setText((ys-ss)+"");
			}
		});
		final GridBagConstraints gridBagConstraints_14 = new GridBagConstraints();
		gridBagConstraints_14.ipadx = -125;
		gridBagConstraints_14.insets = new Insets(0, 0, 0, 5);
		gridBagConstraints_14.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_14.gridy = 9;
		gridBagConstraints_14.gridx = 6;
		getContentPane().add(shishou, gridBagConstraints_14);

		final JLabel label_5 = new JLabel();
		final GridBagConstraints gridBagConstraints_12 = new GridBagConstraints();
		gridBagConstraints_12.gridy = 9;
		gridBagConstraints_12.gridx = 10;
		getContentPane().add(label_5, gridBagConstraints_12);
		label_5.setFont(new Font("", Font.PLAIN, 14));
		label_5.setText("未收：");

		weishou = new JTextField();
		weishou.setEditable(false);
		final GridBagConstraints gridBagConstraints_13 = new GridBagConstraints();
		gridBagConstraints_13.insets = new Insets(0, 0, 0, 5);
		gridBagConstraints_13.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_13.gridy = 9;
		gridBagConstraints_13.gridx = 12;
		getContentPane().add(weishou, gridBagConstraints_13);

		final JLabel label_7 = new JLabel();
		final GridBagConstraints gridBagConstraints_15 = new GridBagConstraints();
		gridBagConstraints_15.insets = new Insets(5, 0, 5, 0);
		gridBagConstraints_15.gridy = 9;
		gridBagConstraints_15.gridx = 13;
		getContentPane().add(label_7, gridBagConstraints_15);
		label_7.setFont(new Font("", Font.PLAIN, 14));
		label_7.setText("经手人：");

		jsr = new JTextField();
		jsr.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_16 = new GridBagConstraints();
		gridBagConstraints_16.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_16.ipadx = 95;
		gridBagConstraints_16.weightx = 1.0;
		gridBagConstraints_16.insets = new Insets(0, 0, 0, 10);
		gridBagConstraints_16.gridy = 9;
		gridBagConstraints_16.gridx = 15;
		getContentPane().add(jsr, gridBagConstraints_16);

		final JButton cellButton = new JButton();
		cellButton.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				if (danjia.getText().equals("")) {
					JOptionPane.showMessageDialog(getContentPane(), "请填写单价！");
					return;
				}
				if (shuliang.getText().equals("")) {
					JOptionPane.showMessageDialog(getContentPane(), "请填写数量！");
					return;
				}
				Vector vector = new Vector();
				vector.add(spName.getSelectedItem() + "");
				vector.add(guige.getSelectedItem() + "");
				vector.add(Double.valueOf(danjia.getText().trim()));
				vector.add(Integer.valueOf(shuliang.getText().trim()));
				dtm.addRow(vector);
				TabSellDetail sellDetail=new TabSellDetail();
				int rowNum = dtm.getRowCount();
				Double ys = new Double(0);
				sellDetail.setDj(Double.parseDouble(danjia.getText()));
				sellDetail.setSl(Float.parseFloat(shuliang.getText()));
				List list = dao.queryObject("select id from TabKucun where spname='"
						+ spName.getSelectedItem() + "' and gg='"
						+guige.getSelectedItem() + "'");
//				sellDetail.setSpid(list.get(0)+"");
				sellDetail.setTabSellMain(sellMain);
				sellDetail.setTabSpinfo(new TabSpinfo(list.get(0) + ""));
				tabSellDetails.add(sellDetail);
				for (int i = 0; i < rowNum; i++) {
					ys = ys	+ Double.parseDouble(dtm.getValueAt(i, 2)
									.toString())
							* Double.parseDouble(dtm.getValueAt(i, 3)
									.toString());
				}
				yingshou.setText(ys + "");
				shuliang.setText("");
			}
		});
		cellButton.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_26 = new GridBagConstraints();
		gridBagConstraints_26.ipady = -10;
		gridBagConstraints_26.insets = new Insets(5, 0, 5, 0);
		gridBagConstraints_26.gridy = 10;
		gridBagConstraints_26.gridx = 6;
		getContentPane().add(cellButton, gridBagConstraints_26);
		cellButton.setText("销售");

		final JButton jiezhangButton = new JButton();
		jiezhangButton.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				if(table.getRowCount()<1) {
					JOptionPane.showMessageDialog(getContentPane(), "请填写销售信息！");
					return;
				}
				if(shishou.getText().equals("")) {
					JOptionPane.showMessageDialog(getContentPane(), "请填写实收金额！");
					return;
				}
				if(jsr.getText().equals("")) {
					JOptionPane.showMessageDialog(getContentPane(), "请填写销售经手人！");
					return;
				}
				try {
					Double num=Double.valueOf(weishou.getText());
					System.out.println(num);
					if(num!=0){
						JOptionPane.showMessageDialog(getContentPane(), "请结清帐款！");
						return;
					}
				} catch (NumberFormatException e1) {
					e1.printStackTrace();
				}
				Iterator iterator = tabSellDetails.iterator();
				while(iterator.hasNext()){
					TabSellDetail sd=(TabSellDetail) iterator.next();
					TabSpinfo tabSpinfo = sd.getTabSpinfo();
					TabSpinfo spinfo = (TabSpinfo) dao.getObject(TabSpinfo.class,tabSpinfo.getId());
					List list = dao.queryObject("from TabKucun where spname='"
							+ spinfo.getSpname()+ "' and gg='"
							+spinfo.getGg()+ "'");
					if(list!=null&&list.size()>0){
						TabKucun kcsp= (TabKucun) list.get(0);
						kcsp.setKcsl(kcsp.getKcsl()-sd.getSl().intValue());
						dao.insertOrUpdate(kcsp);
					}
					
				}
				String date=new java.sql.Date(System.currentTimeMillis())+"";
				date=date.replace("-", "");
				List list = dao.queryObject("select max(id) from TabSellMain"
						+ " where id like '%" + date + "%'");
				String suffix;
				if(list.get(0)==null) {
					suffix="000";
				}else
				{
					suffix=list.get(0).toString();
					suffix=suffix.substring(suffix.length()-3);
					int suf = Integer.parseInt(suffix)+1;
					suffix=suf<10?"00"+suf:suf<100?"0"+suf:suf+"";
				}
				String maxId="XS"+date+suffix;
				
				sellMain.setSellId(maxId);
				sellMain.setCzy(user.getId().getName());
				sellMain.setJe(Double.valueOf(yingshou.getText()));
				sellMain.setJsfs(jsMode.getSelectedItem()+"");
				sellMain.setJsr(jsr.getText());
				sellMain.setKhname(clientName.getSelectedItem()+"");
				sellMain.setPzs(Float.valueOf(table.getRowCount()));
				sellMain.setSs(Double.valueOf(shishou.getText()));
				sellMain.setXsdate(new Date());
				dao.insertOrUpdate(sellMain);
				JOptionPane.showMessageDialog(getContentPane(), "商品销售完毕！");
				int rowCount=dtm.getRowCount();
				for(int i=0;i<rowCount;i++)
					//table.removeAll()
					dtm.removeRow(0);
				tabSellDetails.clear();
				yingshou.setText("");
				shishou.setText("");
				weishou.setText("");
				jsr.setText("");
			}
		});
		final GridBagConstraints gridBagConstraints_27 = new GridBagConstraints();
		gridBagConstraints_27.ipady = -10;
		gridBagConstraints_27.gridy = 10;
		gridBagConstraints_27.gridx = 12;
		getContentPane().add(jiezhangButton, gridBagConstraints_27);
		jiezhangButton.setFont(new Font("", Font.PLAIN, 14));
		jiezhangButton.setText("结帐");
	}

	private void updateDanjia() {
		List list;
		if(guige.getSelectedItem()!=null) {
			list = dao.queryObject("from TabKucun where spname='"
					+ spName.getSelectedItem() + "' and gg='"
					+ guige.getSelectedItem() + "'");
			if (list.size()>0&&list.get(0) != null)
				danjia.setText(((TabKucun) list.get(0)).getDj() + "");
			else
				danjia.setText("");
		}
	}
}