public override void SetParam(DataTypeBase paramData)
{
switch (paramData.Type())
{
case DataType.BookNo:
bookNo = (TypeBookNo)paramData;
break;
case DataType.BookName:
bookName = (TypeBookName)paramData;
break;
case DataType.BookAggregate:
bookInfo = (TypeBookAggregate)paramData;
break;
case DataType.RentalState:
rentalState = (TypeRentalState)paramData;
break;
case DataType.CategoryNo:
categoryNo = (TypeCategoryNo)paramData;
break;
default:
break;
}
}
//書籍検索
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);
}
