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); }