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; } }
public override void SetParam(DataTypeBase paramData) { switch (paramData.Type()) { case DataType.BookName: bookName = (TypeBookName)paramData; break; case DataType.Author: author = (TypeAuthor)paramData; break; case DataType.Press: press = (TypePress)paramData; break; case DataType.RegistDate: registDate = (TypeRegistDate)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); }
//挿入 public override void Regist(DataTable table, ParamList param) { //20130705から追加 string query = ""; switch (table) { case DataTable.Books: Console.WriteLine("this is Regist!!"); // DataTypeBase dtb = param.GetParam(DataType.BookName); TypeBookName tbn = (TypeBookName)param.GetParam(DataType.BookName); TypeAuthor ta = (TypeAuthor)param.GetParam(DataType.Author); // TypeBookName tbnn = (TypeBookName)dtb.Type(); // TypeBookName tbn = new TypeBookName("opengl"); String s1 = tbn.BookName(); String s2 = ta.Author();; //Console.WriteLine(s); query = "insert into books (book_name, author) values('" + s1 + "', '" + s2 + "')"; break; case DataTable.Category: break; case DataTable.Rental: break; case DataTable.User: TypeUserName tun = (TypeUserName)param.GetParam(DataType.UserName); //tun.UserName(); query = "insert into users (user_name) values('" + tun.UserName() + "')"; break; default: break; } db.QueryInsert(query); }