public void Delete(EasyTable table, EasyBaseColumn condition)
{
if (condition is EasyBoolColumn)
{
EasyBoolColumn b = (EasyBoolColumn)condition;
int l = b.GetRowCount();
for (int i = 0; i < l; i++)
{
if (b.Values[i])
{
table.Delete(i, Transaction);
}
}
}
else if (condition is EasyIntColumn)
{
EasyIntColumn iCol = (EasyIntColumn)condition;
int l = iCol.GetRowCount();
for (int i = 0; i < l; i++)
{
table.Delete(iCol.Values[i], Transaction);
}
}
else
{
throw new NotSupportedException();
}
}
public void CreateTableFromSchema()
{
EasyTable tables = FindTable(1);
EasyTable columnsTable = FindTable(2);
EasyBaseColumn column = tables.FindColumn("table_name");
int index = column.GetRowCount() - 1;
string tablename = (string)tables.FindColumn("table_name").GetValue(index);
EasyIntColumn inx = (EasyIntColumn)
columnsTable.FindColumn("table_name").Custom("=", tablename, EasyBaseColumn.IA);
List <CreateField> columns = new List <CreateField>();
for (int i = 0; i < inx.GetRowCount(); i++)
{
int j = (int)inx.GetValue(i);
CreateField field = new CreateField();
field.Name = (string)columnsTable.FindColumn("column_name").GetValue(j);
field.IsIdentity = (bool)columnsTable.FindColumn("is_identity").GetValue(j);
string data = (string)columnsTable.FindColumn("data_type").GetValue(j);
field.FieldType = Type.GetType("System." + data);
columns.Add(field);
}
CreateTableStructure(tablename, columns, 0, null);
}
public void Update(EasyTable table, EasyBaseColumn condition, KeyValuePair <string, object>[] values)
{
if (condition is EasyBoolColumn)
{
EasyBoolColumn b = (EasyBoolColumn)condition;
int l = b.GetRowCount();
for (int i = 0; i < l; i++)
{
if (b.Values[i])
{
table.Update(i, values, Transaction);
}
}
}
else if (condition is EasyIntColumn)
{
EasyIntColumn iCol = (EasyIntColumn)condition;
int l = iCol.GetRowCount();
for (int i = 0; i < l; i++)
{
table.Update(iCol.Values[i], values, Transaction);
}
}
else
{
throw new NotSupportedException();
}
}