/// <summary> /// Gets the table with the specified name. /// </summary> /// <param name="name">The name.</param> /// <returns>The table, or <c>null</c> if no table with that name exists.</returns> public override ITable GetTable(string name) { if (name == null) { throw new ArgumentNullException("name"); } ITable table = null; // get name in correct casing name = SqlHelper.ExecuteScalar <string>("SELECT name FROM sys.tables WHERE name=@name", SqlHelper.CreateParameter("name", name)); if (name != null) { table = new DefaultTable(name); using (IRecordsReader reader = SqlHelper.ExecuteReader( @"SELECT c.name AS Name, st.name AS DataType, c.max_length, c.is_nullable, c.is_identity FROM sys.tables AS t JOIN sys.columns AS c ON t.object_id = c.object_id JOIN sys.schemas AS s ON s.schema_id = t.schema_id JOIN sys.types AS ty ON ty.user_type_id = c.user_type_id JOIN sys.types st ON ty.system_type_id = st.user_type_id WHERE t.name = @name ORDER BY c.column_id", SqlHelper.CreateParameter("name", name))) { while (reader.Read()) { table.AddField(table.CreateField(reader.GetString("Name"), GetType(reader))); } } } return(table); }
void InitDB(String strCmpactDBFilePath, DbInteractiveArgs InitSqliteArgs) { try { DbInteractiveArgs args = InitSqliteArgs; args.Database = strCmpactDBFilePath; args.ThisDbConnection.ConnectionString = String.Format("data source={0}", strCmpactDBFilePath); bool b = this.Connect(args); if (b) { List <String> AllTableNames = GetAllTableNames(args); int nIndex = -1; nIndex = (int)AllTableNames?.IndexOf(DefaultTable); int nUpperIndex = (int)AllTableNames?.IndexOf(DefaultTable.ToUpper()); if (nIndex == -1 && nUpperIndex == -1) { CreateKeyValueTable(DefaultTable, args); } Console.WriteLine("已经成功连接数据库"); } else { Console.WriteLine("未能连接数据库"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// Loads Resource information into the datagrid /// </summary> /// <remarks> /// </remarks> /// <history> /// [vmasanas] 04/10/2004 Created /// [vmasanas} 25/03/2006 Modified to support new features /// </history> private void BindGrid() { Hashtable EditTable; Hashtable DefaultTable; EditTable = LoadFile(rbMode.SelectedValue, "Edit"); DefaultTable = LoadFile(rbMode.SelectedValue, "Default"); // check edit table // if empty, just use default if (EditTable.Count == 0) { EditTable = DefaultTable; } else { //remove obsolete keys ArrayList ToBeDeleted = new ArrayList(); foreach (string key in EditTable.Keys) { if (!DefaultTable.Contains(key)) { ToBeDeleted.Add(key); } } if (ToBeDeleted.Count > 0) { UI.Skins.Skin.AddModuleMessage(this, Localization.GetString("Obsolete", LocalResourceFile), ModuleMessageType.YellowWarning); foreach (string key in ToBeDeleted) { EditTable.Remove(key); } } //add missing keys foreach (string key in DefaultTable.Keys) { if (!EditTable.Contains(key)) { EditTable.Add(key, DefaultTable[key]); } else { // Update default value Pair p = (Pair)EditTable[key]; p.Second = ((Pair)DefaultTable[key]).First; EditTable[key] = p; } } } SortedList s = new SortedList(EditTable); dgEditor.DataSource = s; dgEditor.DataBind(); }
public static ITable GetTableInfo(Type type) { ITable table = null; if (type == typeof(ColumnTestEntityExts)) { table = new DefaultTable("column_test_entity"); } return(table); }
public Table <TEntity, TPrimaryKey> CreateTable <TEntity, TPrimaryKey>( IKeyInfo <TEntity, TPrimaryKey> primaryKey, IdentitySpecification <TEntity> identitySpecification, IDatabase database) where TEntity : class { Table <TEntity, TPrimaryKey> table = new DefaultTable <TEntity, TPrimaryKey>( database, primaryKey, identitySpecification); return(table); }
public DataTable GetCustomerTableForStatusUpdateOnly() { try { DefaultTable table = new DefaultTable(Entities.CUSTOMER.TABLE_NAME); table.Columns.Add(Entities.CUSTOMER.ID, typeof(int)); table.Columns.Add(Entities.CUSTOMER.STATUS_ID, typeof(int)); return(table); } catch (Exception ex) { Logger.getInstance().Error(MODULE_NAME, "GetCustomerTableForStatusUpdateOnly", ex); throw ex; } }
public static ITable GetTableInfo(Type type) { ITable table = null; if (type == typeof(TreeTestRootEntityExt)) { table = new DefaultTable("tree_test_root"); } else if (type == typeof(TreeTestOne2ManyEntityExt)) { table = new DefaultTable("tree_test_one2many"); } else if (type == typeof(TreeTestOne2OneEntityExt)) { table = new DefaultTable("tree_test_one2one"); } return(table); }
public static ITable GetTableInfo(Type type) { ITable table = null; if (type == typeof(InheritanceTestSuperEntityExt)) { table = new DefaultTable("inheritance_test_super"); } else if (type == typeof(InheritanceTestSubEntityAExt)) { table = new DefaultTable("inheritance_test_suba"); } else if (type == typeof(InheritanceTestSubEntityBExt)) { table = new DefaultTable("inheritance_test_subb"); } return(table); }
static void Main(string[] args) { var app = new PlaygroundController(); var vasia = new HumanPlayer { Name = "Pidor ", PlayerGuid = Guid.NewGuid() }; var petya = new HumanPlayer { Name = "Hui ", PlayerGuid = Guid.NewGuid() }; var table = new DefaultTable { TableGuid = Guid.NewGuid(), TableName = "Table nahui " }; app.AddTable(table); app.AddPlayerToTable(table.TableGuid, vasia); app.AddPlayerToTable(table.TableGuid, petya); app.StartTableGame(table.TableGuid); Console.ReadKey(); }
private ITable GetTableInfo(Type regType, Type subType) { ITable table = GetTableInfoIfManagedClass(regType, subType); if (table == null) { object[] attributes = regType.GetCustomAttributes(false); foreach (object attribute in attributes) { if (attribute is TableInfo) { var tableInfo = (TableInfo)attribute; TableInfo annotatedTableInfo = (TableInfo)attribute; table = new DefaultTable(annotatedTableInfo.TableName , annotatedTableInfo.UpdateStrategy , annotatedTableInfo.VerifyOnWriteStrategy , annotatedTableInfo.DirtyCheckStrategy); } } } UpdateToDefaultStrategiesIfNoneDefined(table); return(table); }