//20130708から追加
//ユーザ検索
protected AggregateBase SearchUserAll(ParamList param)
{
Console.WriteLine("this is SearchUser method of DBTableAccess");
AggregateBase aggregate = null;
String query = "select * from users";
List <List <string> > dataList = new List <List <string> >();
DataSet dataset = ((DBSqlServer)db).QuerySelect(query, "users");
for (int i = 0; i < dataset.Tables["users"].Rows.Count; i++)
{
String rowColumn0 = dataset.Tables["users"].Rows[i][0].ToString().Trim();
String rowColumn1 = dataset.Tables["users"].Rows[i][1].ToString().Trim();
//Console.WriteLine("this is DBTableAccess: " + rowColumn);
List <String> item = new List <string>();
item.Add(rowColumn0);
item.Add(rowColumn1);
dataList.Add(item);
}
for (int j = 0; j < dataList.Count; j++)
{
for (int k = 0; k < 2; k++)
{
Console.Write("this is DBTableAccess: " + dataList[j][k].ToString() + " ");
Console.WriteLine(dataList[j][k].ToString());
}
}
aggregate = new AggregateUser(dataList);
return(aggregate);
}
protected DataTypeAggreegate(DataType type, AggregateBase value)
: base(type)
{
data = value;
}
public IteratorCategory(AggregateCategory categoryInfo)
{
this.categoryInfo = categoryInfo;
}
public TypeUserAggregate(AggregateBase value)
: base(DataType.UserAggregate, value)
{
}
public TypeCategoryAggregate(AggregateBase value)
: base(DataType.CategoryAggregate, value)
{
}
public TypeBookAggregate(AggregateBase value)
: base(DataType.BookAggregate, value)
{
}