package?Action;

import?java.sql.SQLException;
import?java.util.List;
import?java.util.Map;
import?java.util.Vector;

import?Dao.BookInfo;
import?Dao.Borrow;
import?Dao.Manager;
import?Dao.Stock;
import?Dao.Type;
import?Dao.User;
import?Model.BookInfo_model;
import?Model.Borrow_model;
import?Model.Manager_model;
import?Model.Stock_model;
import?Model.Type_model;
import?Model.User_model;
import?Util.Change;

public?class?Control?{
	/**
	?*?添加圖書
	?*?
	?*?@param?bookModel
	?*?@throws?Exception
	?*/
	public?void?addBook（BookInfo_model?bookModel）?throws?Exception?{
		BookInfo_model?model?=?bookModel;
		BookInfo?book?=?new?BookInfo（）;
		model.setType（String.valueOf（this.getType（model.getType（））.getIdtype（）））;
		book.addBook（model）;
	}

	/**
	?*?修改圖書信息
	?*?
	?*?@param?bookModel
	?*?@throws?SQLException
	?*/
	public?void?editBook（BookInfo_model?bookModel）?throws?SQLException?{
		BookInfo_model?model?=?bookModel;
		BookInfo?book?=?new?BookInfo（）;
		model.setType（String.valueOf（this.getType（model.getType（））.getIdtype（）））;
		book.updateBook（model）;
	}

	/**
	?*?刪除圖書
	?*?
	?*?@param?idbook
	?*?@throws?SQLException
	?*/
	public?void?delBook（String?idbook）?throws?SQLException?{
		BookInfo?book?=?new?BookInfo（）;
		book.delBook（idbook）;

	}

	/**
	?*?查詢全部圖書信息
	?*?
	?*?@return
	?*?@throws?Exception
	?*/
	public?List?queryBook（）?throws?Exception?{
		BookInfo?book?=?new?BookInfo（）;
		List?model?=?book.query（）;
		for?（BookInfo_model?bookInfo_model?:?model）?{
			bookInfo_model.setType（this.getType（Integer.valueOf（bookInfo_model.getType（）））.getTypeName（））;
			if（bookInfo_model.getIsBor（）.equals（“0“））?{
				bookInfo_model.setIsBor（“已被借“）;
			}else?if（bookInfo_model.getIsBor（）.equals（“1“））?{
				bookInfo_model.setIsBor（“可借閱“）;
			}else{
				bookInfo_model.setIsBor（“不可借“）;
			}
		}
		return?model;
	}

	/**
	?*?條件搜索圖書信息
	?*?
	?*?@param?params
	?*?@return
	?*?@throws?SQLException
	?*/
	public?List?queryBook（Listject>>?params）?throws?SQLException?{
		BookInfo?book?=?new?BookInfo（）;
		List?model?=?book.query（params）;

		for?（BookInfo_model?bookInfo_model?:?model）?{
			bookInfo_model.setType（this.getType（Integer.valueOf（bookInfo_model.getType（）））.getTypeName（））;
			if（bookInfo_model.getIsBor（）.equals（“0“））?{
				bookInfo_model.setIsBor（“已被借“）;
			}else?if（bookInfo_model.getIsBor（）.equals（“1“））?{
				bookInfo_model.setIsBor（“可借閱“）;
			}else{
				bookInfo_model.setIsBor（“不可借“）;
			}
		}
		return?model;
	}

	/**
	?*?獲取所有圖書的ISBN號
	?*?
	?*?@throws?Exception
	?*/
	public?Vector?queryBookId（）?throws?Exception?{
		BookInfo?book?=?new?BookInfo（）;
		Vector?id?=?new?Vector（）;

		List?bookModel?=?book.query（）;
		for?（int?i?=?0;?i?			id.addElement（bookModel.get（i）.getBookId（））;
		}
		return?id;
	}

	/**
	?*?添加借閱信息
	?*?
	?*

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-07-25?21:55??BookManage\
?????文件?????????664??2019-07-25?23:54??BookManage\.classpath
?????文件?????????386??2017-11-13?22:25??BookManage\.project
?????目錄???????????0??2019-07-25?21:55??BookManage\.settings\
?????文件?????????598??2017-11-13?09:04??BookManage\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2019-11-17?08:07??BookManage\bin\
?????目錄???????????0??2019-11-17?08:07??BookManage\bin\Action\
?????文件???????10933??2019-11-17?08:07??BookManage\bin\Action\Control.class
?????目錄???????????0??2019-11-17?08:07??BookManage\bin\Dao\
?????文件????????5943??2019-11-17?08:07??BookManage\bin\Dao\BookInfo.class
?????文件????????5288??2019-11-17?08:07??BookManage\bin\Dao\Borrow.class
?????文件????????1283??2019-11-17?08:07??BookManage\bin\Dao\Connect.class
?????文件????????2667??2019-11-17?08:07??BookManage\bin\Dao\Manager.class
?????文件????????2978??2019-11-17?08:07??BookManage\bin\Dao\Stock.class
?????文件????????4372??2019-11-17?08:07??BookManage\bin\Dao\Type.class
?????文件????????6882??2019-11-17?08:07??BookManage\bin\Dao\User.class
?????目錄???????????0??2019-11-17?08:07??BookManage\bin\Image\
?????文件???????28579??2017-12-15?20:15??BookManage\bin\Image\背景.jpg
?????目錄???????????0??2019-11-17?08:07??BookManage\bin\Model\
?????文件????????2098??2019-11-17?08:07??BookManage\bin\Model\BookInfo_model.class
?????文件????????1716??2019-11-17?08:07??BookManage\bin\Model\Borrow_model.class
?????文件????????1063??2019-11-17?08:07??BookManage\bin\Model\Manager_model.class
?????文件????????1148??2019-11-17?08:07??BookManage\bin\Model\Stock_model.class
?????文件?????????734??2019-11-17?08:07??BookManage\bin\Model\Type_model.class
?????文件????????1855??2019-11-17?08:07??BookManage\bin\Model\User_model.class
?????目錄???????????0??2019-11-17?08:07??BookManage\bin\Util\
?????文件????????2944??2019-11-17?08:07??BookManage\bin\Util\Change.class
?????文件????????1421??2019-11-17?08:07??BookManage\bin\Util\Confirmation.class
?????文件????????1704??2019-11-17?08:07??BookManage\bin\Util\DateChoose.class
?????目錄???????????0??2019-11-17?08:07??BookManage\bin\View\
?????文件????????1003??2019-11-17?08:07??BookManage\bin\View\Login$ManLostPass$1.class
............此處省略81個文件信息