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