//書籍検索 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; }