//書籍検索
protected AggregateBase SearchBooksAll(ParamList param)
{
Console.WriteLine("this is book search!");
//検索パラメータの取り出し
ParamBooksSearch paramList = (ParamBooksSearch)param;
TypeBookNo bookno = (TypeBookNo)paramList.GetParam(DataType.BookNo);
TypeBookName bookname = (TypeBookName)paramList.GetParam(DataType.BookName);
//SQL文の組み立て 20130706
string query = "select * from books";
//検索実行
DataSet dataSet = db.QuerySelect(query);
//データの取り出し
//System.Data.DataTableReader reader = dataSet.CreateDataReader();
List <List <string> > dataList = new List <List <string> >();
//int listCnt = 0;
//while (reader.Read())
//{
// //Listにデータを取り込む
// for (int cnt = 0; cnt < reader.VisibleFieldCount; cnt++)
// {
// dataList[listCnt][cnt] = reader[cnt].ToString();
// }
// listCnt++;
//}
AggregateBase aggregate = new AggregateBook(dataList);
return(aggregate);
}
private void SearchData()
{
Console.WriteLine("ServiceBooksSearch Run");
//検索実行
DataAccessInterface dataAccess = new DBTableAccess();
AggregateBook aggregate = (AggregateBook)dataAccess.Search(DataAccessInterface.SearchPattern.BooksAllInfo, param);
//取得データを格納
TypeBookAggregate bookInfo = new TypeBookAggregate(aggregate);
param.SetParam(bookInfo);
}
} //デフォルトコンストラクタは無効
public IteratorBook(AggregateBook bookInfo)
{
this.bookInfo = bookInfo;
}
