public void ReadOffsetTables() { ScalarType = _file.GetUint32(); var numTables = _file.GetUint16(); SearchRange = _file.GetUint16(); EntrySelector = _file.GetUint16(); RangeShift = _file.GetUint16(); for (var i = 0; i < numTables; i++) { var tag = _file.GetString(4); var table = new Table() { Checksum = _file.GetUint32(), Offset = _file.GetUint32(), Length = _file.GetUint32() }; TableList.Add(tag); Tables.Add(table); } }
public void CreateTableList() { try { SampleData.Current.Tables.ForEach(t => { var orders = new ObservableCollection <OrderData>(); SampleData.Current.Orders.FindAll(o => o.TableId.Equals(t.Id)).ForEach(item => { orders.Add(new OrderData() { OrderId = item.Id, OrderCost = item.AmountOwing, OrderStatus = item.OrderState.ToString(), OrderName = item.DisplayName }); }); if (orders.Count > 0) { TableList.Add(new TableData { Id = t.Id, OrderList = orders, TableName = t.DisplayName }); } }); } catch (Exception ex) { Log($"Error: {ex.Message}"); } }
/// <inheritdoc /> public int Read(BinaryReader reader) { var byteCount = 0; var header = reader.ReadBytes(MagicHead.Length); byteCount += MagicHead.Length; if (!CompareBytes(header, MagicHead)) { throw new ConfigException("Invalid Header"); } TableCount = reader.ReadUInt16(); byteCount += sizeof(ushort); for (ushort i = 0; i < TableCount; ++i) { var tableItem = new TableItem { TableIdx = i }; byteCount += tableItem.Read(reader); TableList.Add(tableItem); var sep = reader.ReadBytes(TableSeparator.Length); byteCount += TableSeparator.Length; if (!CompareBytes(sep, GetHashedBytes(TableSeparator, i))) { throw new ConfigException("Invalid Table Separator"); } } var end = reader.ReadBytes(MagicEnd.Length); byteCount += MagicEnd.Length; if (!CompareBytes(end, MagicEnd)) { throw new ConfigException("Invalid End"); } return(byteCount); }
// Separates table by adding the two tables that were combined at first, // and adding them back to tableList. public void SeparateTables(CombinedTable <Table> combinedTable) { foreach (Table table in combinedTable.combinedTables) { TableList.Add(table); } TableList.Remove(combinedTable); }
private void BuildDomFromSchema(JsonData data, string tableName, JsonSchema schema = null) { // first, create a new table instance for the data JsonSchemaTable table = new JsonSchemaTable(tableName, data, this, schema); TableList.Add(table); JsonData objectToParse; if (data != null && data.IsArray) { objectToParse = data.Count > 0 ? data[0] : null; } else { objectToParse = data; } //enumerate all schema foreach (var property in schema.Properties) { string propertyName = property.Key; JsonData objectData = null; if (objectToParse != null && objectToParse.ContainsKey(propertyName)) { objectData = objectToParse[propertyName]; } if (property.Value.Type == JsonObjectType.Object) { if (IsFlattableR(property.Value)) { continue; } else { string newTableName = GetUniqueTableName(propertyName); JsonTableRelation relation = new JsonTableRelation(GetUniqueRelationName(tableName, newTableName), tableName, newTableName); RelationList.Add(relation); BuildDomFromSchema(objectData, newTableName, schema.Properties[propertyName]); } } // schema.Properties[propertyName].Item may be null if schema has no other definitions for the array ("Item": { "type": "array" }) => we wont add this array since it will always be an empty array with no columns else if (property.Value.Type == JsonObjectType.Array && schema.Properties[propertyName].Item != null) { // need to add a table anyway, either for a true object or just a fake table using "ArrayValue" as field name string newTableName = GetUniqueTableName(propertyName); JsonTableRelation relation = new JsonTableRelation(GetUniqueRelationName(tableName, newTableName), tableName, newTableName); RelationList.Add(relation); // see if there is an object underneath BuildDomFromSchema(objectData, newTableName, schema.Properties[propertyName].Item); } } }
public Table AddTable(string name, string tableName = "") { var item = new Table(GenDataBase) { GenObject = ((GenObject)GenObject).CreateGenObject("Table"), Name = name, TableName = tableName }; TableList.Add(item); return(item); }
/// <summary> /// 构造函数 /// </summary> /// <param name="dataSet"></param> public JsonDataSet(DataSet dataSet) { // 对DataSet里面的Table循环处理 foreach (DataTable table in dataSet.Tables) { List <string> columnList = new List <string>(); foreach (DataColumn item in table.Columns) { columnList.Add(item.ColumnName); } TableList.Add(table.TableName, columnList); } _dataSet = dataSet; }
public void LoadTableInfo() { SqlConnection connection = new SqlConnection(); ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings[ConnectionStringName]; connection.ConnectionString = settings.ConnectionString; connection.Open(); DataTable dataTable = connection.GetSchema("Tables", new[] { null, "dbo", null, null }); DataColumn colTableName = dataTable.Columns["TABLE_NAME"]; if (colTableName != null) { foreach (DataRow row in dataTable.Rows) { String tableName = row[colTableName].ToString(); if (!tableName.StartsWith("sys")) { try { Table table = new Table(tableName); DataTable dt = connection.GetSchema("Columns", new[] { null, null, tableName }); DataColumn colColumnName = dt.Columns["COLUMN_NAME"]; DataColumn colColumnType = dt.Columns["DATA_TYPE"]; foreach (DataRow row2 in dt.Rows) { table.Columns.Add( new Column(row2[colColumnName].ToString(), row2[colColumnType].ToString())); } TableList.Add(table); } catch (Exception e) { Console.WriteLine("Unexpected exception when processing table: " + e.Message); } } } } }
protected void CreateElement(string name, enumVariousElement type, out Element e) { e = null; Accessor.Name = name; Accessor.Type = type; if (!TableList.ContainsKey(Accessor)) { e = new Element(); e.Key = Accessor.Clone(); e.Value = null; TableList.Add(e.Key, e); } else { e = TableList[Accessor]; } }
private void GetTable(string item) { foreach (var table in item.GetSlices("CREATE TABLE", $"){NewLine};")) { var t = new Table(); string tName, tAlias; GetTableDefinition(table, "CREATE TABLE", $"{NewLine}(", out tName, out tAlias); t.Name = tName; t.Alias = tAlias; foreach (var column in table.Substring(table.IndexOf($"{NewLine}(") + $"{NewLine}(".Length).Split(new string[] { NewLine }, StringSplitOptions.RemoveEmptyEntries).Select(x => x.Trim())) { GetTableColumn(t, column); } TableList.Add(t); } }
private void AddDataset(IDataset[] datasets) { foreach (IDataset aDataset in datasets) { if (aDataset.Type == esriDatasetType.esriDTTable) { if (aDataset.Name.IndexOf("_ATTACH") == -1) { TableDropdownDataContext item = new TableDropdownDataContext { TableName = Utility.ParseTableName(aDataset), Value = aDataset, Fields = Utility.ReturnFieldNames(aDataset) }; if (!TableList.Any(x => x.TableName == item.TableName)) { TableList.Add(item); } } } } }
public void AddTableToList(Table table) { TableList.Add(table); }
public DataTableMsx Add(DataTableMsx dt) { TableList.Add(dt); return(dt); }