public bool InsertItemDict(string sheetName, Dictionary <string, object> data, List <string> columns = null, int startRow = 0)
{
ChangeSheet(sheetName);
columns = columns ?? TableClass.GetTableNamesDict(data);
return(InsertItemDictInner(data, columns, startRow));
}
private void AddTableADOX(string tableName)
{
TableClass tableADOX = new TableClass();
tableADOX.Name = tableName;
m_catalogADOX.Tables.Append(tableADOX);
}
public void Start(TableClass table)
{
IsEnabled = false;
_table = table;
Details = _table.DetailList;
Started?.Invoke(this, new EventArgs());
}
public override void DataToEdit()
{
cbTable.Items.Clear();
cbTable.Items.AddRange(Tables.ToArray());
cbTable.Text = NotNullObject.TableName;
TableClass tc = cbTable.SelectedItem as TableClass;
cbFields.Items.Clear();
cbFields.Items.AddRange(tc.Fields.Values.ToArray());
lvFields.Items.Clear();
foreach (string fn in NotNullObject.FieldNames.Values)
{
string[] st = new string[1];
st[0] = fn;
ListViewItem lvi = new ListViewItem(st);
lvFields.Items.Add(lvi);
}
txtConstraintName.Text = NotNullObject.Name;
txtINDEXName.Text = NotNullObject.IndexName;
DataFilled = true;
}
public IndexForm(Form parent, TableClass tableObject, DBRegistrationClass dbReg, List <TableClass> tables)
{
InitializeComponent();
this.MdiParent = parent;
BearbeitenMode = StateClasses.EditStateClass.eBearbeiten.eInsert;
_dbReg = dbReg;
_localNotify.Notify.OnRaiseErrorHandler += Notify_OnRaiseErrorHandler;
_localNotify.Notify.OnRaiseInfoHandler += Notify_OnRaiseInfoHandler;
_orgTableObject = tableObject;
_tableObject = tableObject;
_orgIndexObject = new IndexClass();
_orgIndexObject.Name = $@"{tableObject.Name}_INX";
_orgIndexObject.IsActive = true;
_indexObject = _orgIndexObject;
_tables = tables;
_indexActiveChanged = false;
lvFields.Items.Clear();
txtIndexName.Text = MakeNewIndexName();
FillSortingToCombo();
_dataFilled = true;
}
public override List <T> GetItemList <T>(string tableName, List <FilterCondition> where, ref PageCondition page)
{
Type tp = typeof(T);
List <string> columns = TableClass.GetTableFieldNames <T>();
return(GetItemList <T>(tableName, where, ref page, columns));
}
public void FillPrimaryKey()
{
TableClass tb = (TableClass)cbDestinationTable.SelectedItem;
txtPrimaryKey.Text = (tb?.primary_constraint != null) ? tb.primary_constraint.Name : string.Empty;
txtIndexName.Text = (tb?.primary_constraint != null) ? tb.primary_constraint.IndexName : string.Empty;
}
public static void PrintTable(TableClass table, bool[,] possiblePositions)
{
Console.SetCursorPosition(0, 0);
ConsoleColor originalBackground = Console.BackgroundColor;
ConsoleColor alterBackGround = ConsoleColor.DarkGray;
for (int i = 0; i < table.Lines; i++)
{
Console.Write(8 - i + "|");
for (int j = 0; j < table.Columns; j++)
{
if (possiblePositions[i, j])
{
Console.BackgroundColor = alterBackGround;
}
else
{
Console.BackgroundColor = originalBackground;
}
PrintPiece(table.PieceMethod(i, j));
Console.BackgroundColor = originalBackground;
}
Console.WriteLine();
}
Console.WriteLine(" a b c d e f g h");
Console.BackgroundColor = originalBackground;
}
public void FillPrimaryKey()
{
cbPrimaryKey.Items.Clear();
TableClass tb = (TableClass)cbDestinationTable.SelectedItem;
if (tb?.primary_constraint != null)
{
/*
* foreach (ConstraintsClass pk in tb.primary_constraints)
* {
* cbPrimaryKey.Items.Add(pk);
* }
* if (cbPrimaryKey.Items.Count > 0)
* {
* cbPrimaryKey.SelectedIndex = 0;
* }
*/
cbPrimaryKey.Items.Add(tb.primary_constraint);
if (cbPrimaryKey.Items.Count > 0)
{
cbPrimaryKey.SelectedIndex = 0;
}
else
{
cbPrimaryKey.SelectedIndex = -1;
}
}
}
public IndexForm(Form parent, string indexName, DBRegistrationClass dbReg, List <TableClass> tables, eBearbeiten mode)
{
InitializeComponent();
this.MdiParent = parent;
BearbeitenMode = mode;
_dbReg = dbReg;
if (mode == eBearbeiten.eInsert)
{
IndexName = "NEW_INDEX_INX1";
NewIndexName = "NEW_INDEX_INX1";
TableName = tables[0].Name;
}
else
{
IndexName = indexName;
NewIndexName = indexName;
TableName = RefreshIndicesAndGetTablename();
}
_localNotify.Notify.OnRaiseErrorHandler += Notify_OnRaiseErrorHandler;
_localNotify.Notify.OnRaiseInfoHandler += Notify_OnRaiseInfoHandler;
_tables = tables;
TableObject = StaticTreeClass.GetTableObjectForIndexForm(_dbReg, TableName);
cbFields.Items.Clear();
lvFields.Items.Clear();
DataFilled = true;
}
public FieldForm(DBRegistrationClass dbReg, Form parent, TreeNode tableNode, TableFieldClass fieldObject, NotifiesClass lnotify, StateClasses.EditStateClass.eBearbeiten bearbeitenMode)
{
InitializeComponent();
DataFilled = false;
this.MdiParent = parent;
_dbReg = dbReg;
TableNode = tableNode;
var tc = (TableClass)tableNode.Tag;
TableObject = tc.Clone() as TableClass;
BearbeitenMode = bearbeitenMode;
FillCombos();
if (BearbeitenMode == StateClasses.EditStateClass.eBearbeiten.eInsert)
{
NewFieldObject();
}
else
{
FieldObject = fieldObject;
FieldObject.IsPrimary = TableObject.IsPrimary(FieldObject.Name);
FieldObject.Domain.NotNull = TableObject.IsNotNull(FieldObject.Name);
FieldObject.TableName = TableObject.Name;
}
OrgFieldObject = FieldObject.DeepClone();
ObjectToEdit(FieldObject);
_localTableNotify = (lnotify == null) ? new NotifiesClass() : lnotify;
DataFilled = false;
_localTableNotify.Register4Info(TableInfoRaised);
localNotify.Register4Info(InfoRaised);
localNotify.Register4Error(ErrorRaised);
}
public IndexForm(Form parent, IndexClass indexObject, DBRegistrationClass dbReg, List <TableClass> tables)
{
InitializeComponent();
this.MdiParent = parent;
BearbeitenMode = eBearbeiten.eEdit;
_dbReg = dbReg;
cbFields.Items.Clear();
lvFields.Items.Clear();
_indexObject = indexObject;
_orgIndexObject = indexObject;
var TableName = RefreshIndicesAndGetTablename(_orgIndexObject.Name);
_tableObject = tables.Find(X => X.Name == TableName);
// _tableObject.Indices.TryGetValue(_orgIndexObject.Name,out _orgIndexObject);
_indexActiveChanged = false;
_localNotify.Notify.OnRaiseErrorHandler += Notify_OnRaiseErrorHandler;
_localNotify.Notify.OnRaiseInfoHandler += Notify_OnRaiseInfoHandler;
_tables = tables;
// _tableObject = StaticTreeClass.Instance().GetTableObjectForIndexForm(_dbReg, TableName);
_orgTableObject = _tableObject;
FillSortingToCombo();
_dataFilled = true;
}
public bool BulkDataToFile <T>(string fName, List <T> data, string valueEncloseChar = "`")
{
if (data == null)
{
return(false);
}
tableUtils.SetEscapeChar(valueEncloseChar);
using (FileStream fs = File.OpenWrite(fName))
{
using (StreamWriter sw = new StreamWriter(fs))
{
foreach (T d in data)
{
List <object> vl = TableClass.GetTableValues <T>(d);
string val = tableUtils.JoinObjectList(vl);
sw.WriteLine(val);
}
}
}
tableUtils.SetEscapeChar("\"");
return(true);
}
public UniqueForm(Form parent, DBRegistrationClass dbReg, List <TableClass> tables, NotNullsClass notnullObject, ContextMenuStrip cmGroup, ContextMenuStrip cm)
{
InitializeComponent();
this.MdiParent = parent;
_dbReg = dbReg;
_tables = tables;
Cm = cm;
CmGroup = cmGroup;
if (notnullObject == null)
{
NotNullObject = new NotNullsClass();
NotNullObject.Name = "NEW_CNSTR";
NotNullObject.ConstraintType = eConstraintType.NOTNULL;
}
else
{
NotNullObject = notnullObject;
}
OrgTable = tables.Find(X => X.Name == notnullObject.TableName);
NotNullObject.TableName = OrgTable.Name;
_localNotify.Register4Error(Notify_OnRaiseErrorHandler);
_localNotify.Register4Info(Notify_OnRaiseInfoHandler);
}
/// <summary>
/// 创建Access库
/// </summary>
/// <param name="connectionString"></param>
/// <param name="accessFileFullpath"></param>
/// <param name="dts"></param>
public static void CreateDataBase(string connectionString, string accessFileFullpath, DataFieldTypeCollection dts)
{
CatalogClass cat = null;
try
{
cat = new CatalogClass();
cat.Create(connectionString);
}
catch (Exception ex)
{
throw new Exception($"创建Access数据库失败,路径[{accessFileFullpath}],异常信息:[{ex.Message}]");
}
#region 新建表
try
{
TableClass tbl = new TableClass();
tbl.ParentCatalog = cat;
tbl.Name = "mytable";
foreach (DataFieldType dt in dts)
{
//增加一个文本字段
ColumnClass col2 = new ColumnClass();
col2.ParentCatalog = cat;
col2.Name = dt.FiledName;
col2.Properties["Jet OLEDB:Allow Zero Length"].Value = true;
switch (dt.Type.ToLower())
{
case "string":
col2.Type = ADOX.DataTypeEnum.adLongVarWChar;
tbl.Columns.Append(col2, ADOX.DataTypeEnum.adLongVarWChar, 16);
break;
case "datetime":
tbl.Columns.Append(col2, ADOX.DataTypeEnum.adDate, dt.Length);
break;
case "int":
tbl.Columns.Append(col2, ADOX.DataTypeEnum.adInteger, dt.Length);
break;
}
}
//把表加入数据库(非常重要)
cat.Tables.Append(tbl);
//转换为ADO连接,并关闭
(cat.ActiveConnection as ADODB.Connection).Close();
cat.ActiveConnection = null;
cat = null;
}
catch (Exception ex)
{
throw new Exception($"创建Access数据库表失败,路径[{accessFileFullpath}],异常信息:[{ex.Message}]");
}
#endregion
}
public void Start(TableClass table)
{
AllFittings = Broker.Instance.LoadAllFittings();
_table = table;
IsEnabledRemove = false;
IsEnabledInsert = false;
Started?.Invoke(this, new EventArgs());
}
private void cbSourceTable_SelectedIndexChanged(object sender, EventArgs e)
{
if (DataFilled && (cbSourceTable.SelectedItem != null))
{
TableClass tc = (TableClass)cbSourceTable.SelectedItem;
ForeignKeyObject.SourceTableName = tc.Name;
DataToEdit();
}
}
public ExpensesDB( )
{
tableDetails = new TableClass(typeof(BankDetails));
DetailTableName = tableDetails.ClassName;
InsertDetailsSqlQuery = tableDetails.CreateInsertScript();
if (!IsTableExist(DetailTableName))
{
CreateTable(tableDetails.CreateTableScript());
}
}
private void cbDestinationTable_SelectedIndexChanged(object sender, EventArgs e)
{
if (DataFilled && (cbDestinationTable.SelectedItem != null))
{
TableClass tb = (TableClass)cbDestinationTable.SelectedItem;
ForeignKeyObject.DestTableName = tb.Name;
//EditToData();
DataToEdit();
}
}
public bool InsertItemListDict(string tableName, List <Dictionary <string, object> > data)
{
if (data == null || data.Count == 0)
{
return(true);
}
List <string> cols = TableClass.GetTableNamesDict(data.First());
return(InsertItemListDict(tableName, data, cols));
}
/// <summary>
/// MySQL limit parameter , max_allowed_packet=4194304
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="tableName"></param>
/// <param name="data"></param>
/// <returns></returns>
public bool InsertItemList <T>(string tableName, List <T> data)
{
if (data == null || data.Count == 0)
{
return(true);
}
List <string> cols = TableClass.GetTableFieldNames <T>();
return(InsertItemList(tableName, data, cols));
}
private void cbTables_SelectedIndexChanged(object sender, EventArgs e)
{
if (_dataFilled)
{
_tableObject = (TableClass)cbTables.SelectedItem;
DataToCBFields();
lvFields.Items.Clear();
MakeSQL();
}
}
/// <summary>
///
/// </summary>
/// <param name="catalog"></param>
/// <param name="srcTable"></param>
internal void CreateTable(
Catalog catalog,
DataTable srcTable)
{
string tableName = Sanitize(srcTable.TableName);
Table newTable = new TableClass();
newTable.Name = tableName;
catalog.Tables.Append(newTable);
// ArrayList keySet = new ArrayList();
foreach (DataColumn srcColumn in srcTable.Columns)
{
Column column = new ColumnClass();
column.Name = Sanitize(srcColumn.ColumnName);
column.Type = TypeFor(srcColumn);
column.DefinedSize = SizeFor(srcColumn);
column.ParentCatalog = catalog;
if (srcColumn.AllowDBNull)
{
column.Attributes = ColumnAttributesEnum.adColNullable;
}
LookupTable(catalog, srcTable).Columns.Append(
column,
DataTypeEnum.adVarWChar, // default
0); // default
}
if (srcTable.PrimaryKey.Length > 0)
{
Key key = new KeyClass();
key.Name = Sanitize(String.Format("{0}", tableName));
key.Type = KeyTypeEnum.adKeyPrimary;
key.RelatedTable = tableName;
foreach (DataColumn srcColumn in srcTable.PrimaryKey)
{
Column column = LookupColumn(catalog, srcColumn);
key.Columns.Append(
column.Name,
DataTypeEnum.adVarWChar, // default
0); // default
}
LookupTable(catalog, srcTable).Keys.Append(
key,
KeyTypeEnum.adKeyPrimary, // default
Type.Missing, // default
String.Empty, // default
String.Empty); // default
}
}
public NewCustomerDB( )
{
DB = new DataBase(ConType.SQLDB);
t = new TableClass(typeof(NewCustomer));
InsertSqlQuery = t.CreateInsertScript();
Tablename = t.ClassName;
if (!IsTableExit())
{
CreateTable();
}
}
public DataOps( )
{
Db = new DataBase(ConType.SQLDB);
table = new TableClass(typeof(T));
Tablename = table.ClassName;
InsertSqlQuery = table.CreateInsertScript();
if (!IsTableExist())
{
CreateTable();
}
}
public void Start(TableClass table)
{
IsEnabled = false;
IsEnabledOne = false;
IsEnabledTwo = false;
IsEnabledThree = false;
IsEnabledFour = false;
AllEdgeTapes = Broker.Instance.LoadAllEdgeTapes();
_table = table;
Details = _table.DetailList;
Started?.Invoke(this, new EventArgs());
}
public ChessMatch()
{
Tab = new TableClass(8, 8);
Turn = 1;
ActivePlayer = Color.Branca;
Finished = false;
Check = false;
EnPassantVulnerab = null;
Pieces = new HashSet <Piece>();
CapturedPieces = new HashSet <Piece>();
PiecePlacement();
}
public void AddTables(string tablename)
{
TableClass actTable = null;
actTables.TryGetValue(tablename, out actTable);
if (actTable != null)
{
foreach (var tcf in actTable.Fields.Values)
{
words.Add(tcf.Name);
}
}
}
public void FillSourceFields(string TableName)
{
cbSourceTableFields.Items.Clear();
if (TableName.Length > 0)
{
TableClass Tab = Tables.Find(x => x.Name == TableName);// StaticTreeClass.GetTableObjectFromName(DRC, DestTableName);
var Fds = Tab.Fields;
foreach (TableFieldClass dstr in Fds.Values)
{
cbSourceTableFields.Items.Add(dstr.Name);
}
}
}
public static void Main()
{
Queue <Customer> CustList = new Queue <Customer>();
Customer cust1 = new Customer();
Customer cust2 = new Customer();
Customer cust3 = new Customer();
Customer cust4 = new Customer();
Customer cust5 = new Customer();
Customer cust6 = new Customer();
cust2.FirstName = "Jane";
cust2.LastName = "Jones";
cust2.MealChangeEvent += mealsEventHandler;
cust3.FirstName = "Jack";
cust3.LastName = "Jump";
cust3.MealChangeEvent += mealsEventHandler;
cust4.FirstName = "Jeff";
cust4.LastName = "Run";
cust4.MealChangeEvent += mealsEventHandler;
cust5.FirstName = "Jill";
cust5.LastName = "Hill";
cust5.MealChangeEvent += mealsEventHandler;
cust6.FirstName = "John";
cust6.LastName = "Winstone";
cust6.MealChangeEvent += mealsEventHandler;
CustList.Enqueue(cust1);
CustList.Enqueue(cust2);
CustList.Enqueue(cust3);
CustList.Enqueue(cust4);
CustList.Enqueue(cust5);
CustList.Enqueue(cust6);
TableClass Tab = new TableClass();
foreach (Customer value in CustList)
{
Tab.TableEvent += value.HandleTable;
Tab.Open();
/*while (value.Meal != Meals.done)
* {
* value.mealChanger(value.Meal);
* }*/
}
Console.WriteLine("Everyone is Full!!");
Console.ReadLine();
}
//Создаем новую пустую БД из схемы
public void CreateDB( string pathDB)
{
if (!m_isSchema)
return;
if (File.Exists(pathDB))
{
File.Copy( pathDB, pathDB+".old", true);
File.Delete( pathDB);
}
string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+pathDB;
try
{
m_catalogADOX.Create(connStr);
for ( int i = 0; i < m_schema.tables.Length; i++ )
{
TableClass tableADOX = new TableClass();
tableADOX.Name = m_schema.tables[i].name;
tableADOX.ParentCatalog = m_catalogADOX;
jcolumns[] cols = m_schema.tables[i].columns;
for ( int j = 0; j < cols.Length; j++ )
{
ColumnClass columnADOX = new ColumnClass();
columnADOX.ParentCatalog = m_catalogADOX;
columnADOX.Name = cols[j].name;
columnADOX.Type = cols[j].type;
columnADOX.DefinedSize = cols[j].definedSize;
columnADOX.Precision = cols[j].precision;
columnADOX.Properties["Autoincrement"].Value = (object)cols[j].autoincrement;
columnADOX.Properties["Nullable"].Value = (object)cols[j].nullable;
columnADOX.Properties["Fixed Length"].Value = (object)cols[j].fixedLength;
tableADOX.Columns.Append(columnADOX, cols[j].type, cols[j].definedSize);
}
m_catalogADOX.Tables.Append(tableADOX);
//index
jindexs[] ind = m_schema.tables[i].indexs;
if (ind != null)
{
for ( int j = 0; j < ind.Length; j++ )
{
IndexClass indexADOX = new IndexClass();
indexADOX.Name = ind[j].name;
indexADOX.Clustered = ind[j].clustered;
indexADOX.IndexNulls = ind[j].indexNulls;
indexADOX.PrimaryKey = ind[j].primaryKey;
indexADOX.Unique = ind[j].unique;
m_catalogADOX.Tables[m_schema.tables[i].name].Indexes.Append( ind[j].name, ind[j].name);
}
}
//key
jkeys[] key = m_schema.tables[i].keys;
if (key != null)
{
for ( int j = 0; j < key.Length; j++ )
{
KeyClass keyADOX = new KeyClass();
keyADOX.Name = key[j].name;
keyADOX.Type = key[j].type;
//keyADOX.Columns = key[j].column;
//keyADOX.Columns.Append(key[j].column, ADOX.DataTypeEnum.adInteger, 0);
//ColumnClass columnADOX = new ColumnClass();
//columnADOX.Name = key[j].column;
m_catalogADOX.Tables[m_schema.tables[i].name].Keys.Append(
key[j].name, key[j].type, m_catalogADOX.Tables[m_schema.tables[i].name].Columns[key[j].column], "", "");
//Без этой записи на win2000 выдавала глюк!!! Первая строка в vars отказывалась запичыватся
m_catalogADOX.Tables[m_schema.tables[i].name].Keys.Refresh();
}
}
}
}
finally
{
//if (conn != null)
// conn.Close();
//m_catalogADOX.ActiveConnection = null;
}
//Data и
ConnectionClass conn = null;
try
{
conn = new ConnectionClass();
conn.Open(connStr,"","",0);
for ( int i = 0; i < m_schema.tables.Length; i++ )
{
jrows[] rows = m_schema.tables[i].rows;
if (rows != null && m_schema.tables[i].name=="vars")
FillDataRestruct( conn, m_schema.tables[i].name, rows);
}
}
finally
{
if (conn != null)
conn.Close();
}
}
private void AddTableADOX( string tableName)
{
TableClass tableADOX = new TableClass();
tableADOX.Name = tableName;
m_catalogADOX.Tables.Append(tableADOX);
}
public TestArcObjectsContext()
{
TblBronTable = new TableClass<TblBron>(base.Workspace);
}
