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