package?com.yu.control;

import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.sql.ResultSet;
import?java.sql.SQLException;

import?javax.swing.Jframe;
import?javax.swing.JOptionPane;
import?javax.swing.JTable;

import?com.yu.domain.Goods;
import?com.yu.domain.WarehouseMain;
import?com.yu.model.Model;
import?com.yu.model.TableTableModel;
import?com.yu.model.TableTableModel2;
import?com.yu.util.SqlHelper;

/**
?*?@author:Administrator于航
?*?@date:?2013-2-5
?*?@description:商品退貨控制層
?*/
public?class?BackGoodsDeal?{

	SqlHelper?sh?=?new?SqlHelper（）;
	JTable?jtable;

	public?BackGoodsDeal（）?{
	}

	public?BackGoodsDeal（JTable?jtable）?{
		this.jtable?=?jtable;

	}

	/*
	?*?查詢庫存并且返回庫存編號
	?*/
	public?WarehouseMain?getGnoIsExist（String?gno）?{
		String?sw?=?“select?*?from?WarehouseMain??where?1=?“;
		object[]?ow?=?{?1?};
		ResultSet?rs?=?sh.Query（sw?ow）;
		try?{
			while?（rs.next（））?{
				if?（rs.getString（“gno“）.equals（gno））?{
					WarehouseMain?wm=new?WarehouseMain（）;
					wm.setWmno（rs.getString（1））;
					wm.setGno（rs.getString（2））;
					wm.setWmAll（rs.getInt（3））;
					return?wm;
				}
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?null;
	}

	//?從商品基本信息列表中選擇商品
	public?class?SelectGoods?implements?ActionListener?{
		Jframe?jf;
		Model?model;
		//?第一個jTable是從選擇商品界面傳過的，第二個是商品進貨界面傳過來的
		JTable?jt1?jt2;
		String[]?s;

		public?SelectGoods（Jframe?jf?Model?model?JTable?jt1?JTable?jt2
				String[]?s）?{
			this.jf?=?jf;
			this.model?=?model;
			this.jt1?=?jt1;
			this.jt2?=?jt2;
			this.s?=?s;
		}

		@Override
		public?void?actionPerformed（ActionEvent?e）?{

			int?rownum?=?jt1.getSelectedRow（）;
			if?（rownum?==?-1）?{
				JOptionPane.showMessageDialog（null?“請選擇一行！“）;
			}?else?{
				GoodsDeal?gd?=?new?GoodsDeal（）;
				Goods?g?=?gd.findGoods（（String）?model.getValueAt（rownum?0））;
				if?（g?!=?null）?{
					if（getGnoIsExist（g.getgNo（））!=null）
					{
					（（TableTableModel2）?this.jt2.getModel（））
							.addRow（new?String[]?{?s[0]?g.getgNo（）
									g.getgCode（）?g.getgName（）?g.geteNo（）
									0?+?““getGnoIsExist（g.getgNo（））.getWmAll（）+““?g.getgBuy（）?+?““?“0“?s[1]?s[2]
									s[3]?}）;
					jf.dispose（）;
					}
					else
					{
						JOptionPane.showMessageDialog（null“對不起，庫存中沒有此商品！“）;
					}
				}
			}

		}

	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????3387392??2013-07-10?22:23??論文.doc

?????文件????????138??2013-07-10?22:26??說明.txt

?????文件????????683??2013-02-16?11:05??AccountManagement\.classpath

?????文件????????393??2013-02-07?23:15??AccountManagement\.project

?????文件????????629??2013-02-07?23:15??AccountManagement\.settings\org.eclipse.jdt.core.prefs

?????文件???????2606??2013-02-17?09:13??AccountManagement\bin\com\yu\control\BackGoodsDeal$SelectGoods.class

?????文件???????1866??2013-02-17?09:13??AccountManagement\bin\com\yu\control\BackGoodsDeal.class

?????文件???????2120??2013-02-17?09:13??AccountManagement\bin\com\yu\control\ClerkDeal.class

?????文件????????981??2013-02-17?09:13??AccountManagement\bin\com\yu\control\CompanyDeal$Add.class

?????文件???????1784??2013-02-17?09:13??AccountManagement\bin\com\yu\control\CompanyDeal$Del.class

?????文件???????1102??2013-02-17?09:13??AccountManagement\bin\com\yu\control\CompanyDeal$FindAll.class

?????文件???????1608??2013-02-17?09:13??AccountManagement\bin\com\yu\control\CompanyDeal$Modify.class

?????文件???????4269??2013-02-17?09:13??AccountManagement\bin\com\yu\control\CompanyDeal.class

?????文件????????949??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsDeal$addNewGoods.class

?????文件???????2143??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsDeal$DelGoods.class

?????文件???????2220??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsDeal$findyByInfo.class

?????文件???????1459??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsDeal$ModifyGoods.class

?????文件???????3617??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsDeal.class

?????文件???????1029??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsTypesDeal$AddTypes.class

?????文件???????2519??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsTypesDeal$DelTypes.class

?????文件???????2431??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsTypesDeal$Input$1.class

?????文件????????973??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsTypesDeal$Input$2.class

?????文件???????3418??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsTypesDeal$Input.class

?????文件???????2070??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsTypesDeal$List.class

?????文件???????2438??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsTypesDeal$Modify.class

?????文件????????829??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsTypesDeal$OutTypes.class

?????文件????????780??2013-02-17?09:13??AccountManagement\bin\com\yu\control\GoodsTypesDeal.class

?????文件???????2337??2013-02-17?09:13??AccountManagement\bin\com\yu\control\InputGoodsDeal$SelectGoods.class

?????文件???????1512??2013-02-17?09:13??AccountManagement\bin\com\yu\control\InputGoodsDeal.class

?????文件????????963??2013-02-17?17:01??AccountManagement\bin\com\yu\control\LoginDeal.class

............此處省略372個文件信息