private void SearchButton2Execute()
{
ViewDataTable.Clear();
DataSet dataSet = new DataSet();
DataTable table = new DataTable("Table");
// カラム名の追加
table.Columns.Add("部品番号");
table.Columns.Add("数量", Type.GetType("System.Int32"));
table.Columns.Add("名称");
// DataSetにDataTableを追加
dataSet.Tables.Add(table);
// Rows.Addメソッドを使ってデータを追加
table.Rows.Add("T34F3456-123", 8, "testPar1ts");
table.Rows.Add("T34F3476-163", 2, "te2stParts");
table.Rows.Add("F34F3450-123", 8, "testP2arts");
table.Rows.Add("G34J2456-163", 3, "testParts");
table.Rows.Add("H34F3456-123", 5, "tes3tPa9rts");
table.Rows.Add("T34F3450-103", 6, "te8stParts");
table.Rows.Add("T34H3476-163", 1, "testParts");
table.Rows.Add("F34F3453-103", 2, "testPa5rts");
table.Rows.Add("G34F2406-163", 3, "testParts");
table.Rows.Add("H34F3456-123", 5, "tes4tParts");
NarrowDownText = "部品番号";
ViewDataTable = table;
}
public override global::System.Data.DataTable Clone()
{
ViewDataTable cln = ((ViewDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
private void InitClass()
{
this.DataSetName = "MyDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/MyDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableView = new ViewDataTable();
base.Tables.Add(this.tableView);
}
internal void InitVars(bool initTable)
{
this.tableView = ((ViewDataTable)(base.Tables["View"]));
if ((initTable == true))
{
if ((this.tableView != null))
{
this.tableView.InitVars();
}
}
}
private void NarrowDownLikeSearchButtonExecute()
{
try
{
var tmp = ViewDataTable.Select("[" + NarrowDownText + "] Like '%" + SearchText + "%'").CopyToDataTable();
ViewDataTable.Clear();
ViewDataTable = tmp;
}
catch
{
ViewDataTable.Clear();
}
}
private void NarrowDownSearchButtonExecute()
{
//sample
//dt_2 = dt_1.Select(" [単価] >= '" + int_1.ToString + "' ").CopyToDataTable
try
{
var tmp = ViewDataTable.Select("[" + NarrowDownText + "] = '" + SearchText + "'").CopyToDataTable();
ViewDataTable.Clear();
ViewDataTable = tmp;
}
catch
{
ViewDataTable.Clear();
}
}
private void SearchButton1Execute()
{
ViewDataTable.Clear();
DataSet dataSet = new DataSet();
DataTable table = new DataTable("Table");
// カラム名の追加
table.Columns.Add("教科");
table.Columns.Add("点数", Type.GetType("System.Int32"));
table.Columns.Add("氏名");
table.Columns.Add("クラス名");
// DataSetにDataTableを追加
dataSet.Tables.Add(table);
// DataRowクラスを使ってデータを追加
DataRow dr = table.NewRow();
dr["教科"] = "国語";
dr["点数"] = 90;
dr["氏名"] = "田中 一郎";
dr["クラス名"] = "A";
dataSet.Tables["Table"].Rows.Add(dr);
// Rows.Addメソッドを使ってデータを追加
table.Rows.Add("数学", 80, "田中 一郎", "A");
table.Rows.Add("英語", 70, "田中 一郎", "A");
table.Rows.Add("国語", 60, "鈴木 二郎", "A");
table.Rows.Add("数学", 50, "鈴木 二郎", "A");
table.Rows.Add("英語", 80, "鈴木 二郎", "A");
table.Rows.Add("国語", 70, "佐藤 三郎", "B");
table.Rows.Add("数学", 80, "佐藤 三郎", "B");
table.Rows.Add("英語", 90, "佐藤 三郎", "B");
NarrowDownText = "教科";
ViewDataTable = table;
}
public PageInfo <ViewDataTable> GetPageList(PageInfo <ViewDataTable> pageInfo, ViewDataTable oSearchEntity = null, string sOperator = null, int iOrderGroup = 0, string sSortName = null, string sSortOrder = null)
{
pageInfo = _mapper.Map <PageInfo <ViewDataTable> >(_dataTableRepository.GetPageList(_mapper.Map <PageInfo <DataTable> >(pageInfo), _mapper.Map <DataTable>(oSearchEntity), sOperator, iOrderGroup, sSortName, sSortOrder));
foreach (ViewDataTable entityViewDataTable in pageInfo.data)
{
DataBase entityDataBase = _dataBaseService.Select(entityViewDataTable.IdataBaseId);
if (entityDataBase != null)
{
entityViewDataTable.SdataBaseName = entityDataBase.SdataBaseName;
}
}
return(pageInfo);
}
internal ViewRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableView = ((ViewDataTable)(this.Table));
}
private static ViewDataTable GenerateView
(
string viewName,
DataSet source,
DataTable sourceTable,
List <string> columns,
Dictionary <string, string> viewLevelColumnTables
)
{
ViewDataTable viewTable = new ViewDataTable(viewName);
if (sourceTable == null)
{
return(viewTable);
}
foreach (string column in columns)
{
DataColumn origColumn;
if (!viewLevelColumnTables.ContainsKey(column))
{
throw new InvalidOperationException(string.Format("Column: {0} doesn't belong to {1}", column, viewName));
}
origColumn = source.Tables [viewLevelColumnTables [column]].Columns [column];
viewTable.Columns.Add(origColumn.ColumnName, origColumn.DataType);
}
foreach (DataRow sourceRow in sourceTable.Rows)
{
ViewDataRow viewRow;
Dictionary <string, DataRow> parentTablesRows;
viewRow = viewTable.NewViewRow( );
parentTablesRows = GetParentRows(sourceRow);
foreach (string column in columns)
{
if (sourceTable.Columns.Contains(column))
{
viewRow [column] = sourceRow [column];
viewRow.OriginalRow = sourceRow;
viewRow.OriginalTable = sourceTable;
}
else
{
DataTable parentTable;
DataRow parentRow;
parentTable = source.Tables [viewLevelColumnTables [column]];
parentRow = parentTablesRows [parentTable.TableName];
viewRow [column] = parentRow [column];
viewRow.OriginalRow = parentRow;
viewRow.OriginalTable = parentTable;
}
}
viewTable.Rows.Add(viewRow);
}
return(viewTable);
}
public string LoadData(PageInfo <ViewDataTable> pageInfo, ViewDataTable oSearchEntity = null, string sOperator = null, int iOrderGroup = 0, string sSortName = null, string sSortOrder = null)
{
return(JsonHelper.ObjectToJSON(_dataTableService.GetPageList(pageInfo, oSearchEntity, sOperator, iOrderGroup, sSortName, sSortOrder)));
}
