public static int ExecuteNoneQuery(AppModule module, SqlCommand sqlcommand, params object[] namevalues) { var db = module.OpenConnection(); var result = DBConn.ExecuteNoneQuery(db, sqlcommand, namevalues); db.CloseConnection(); return(result); }
public static IEnumerable <T> ExecuteCommand <T>(AppModule module, SqlCommand sqlcommand, params object[] namevalues) where T : IEntityBase, new() { var db = module.OpenConnection(); var result = DBConn.ExecuteQuery <T>(db, sqlcommand, namevalues).ToList(); db.CloseConnection(); return(result); }
public static IEnumerable <Table> LoadTables(this AppModule module) { try { } catch (Exception) { throw; } var conn = module.OpenConnection(); string[] restrictions = new string[4]; restrictions[3] = "BASE TABLE"; DataTable stable = conn.GetSchema("Tables", restrictions); foreach (DataRow row in stable.Rows) { Table table = null; try { string tableName = row[1].ToString().Equals("dbo", StringComparison.OrdinalIgnoreCase) ? row[2].ToString() : string.Format("{0}.{1}", row[1], row[2]); string name = row[2].ToString(); if (module.Filter.Length > 0 && (!name.StartsWith(module.Filter, StringComparison.OrdinalIgnoreCase))) { continue; } table = new Table { Name = row[2].ToString(), Schema = row[1].ToString(), CodeName = row[2].ToString().ToFormatedName(), IsFromDB = true }; GetColumns(module, row[1].ToString(), row[2].ToString()).AddToCollection(table.Columns); var keycolumns = table.Columns.Where(c => c.IsKey).Select(c => c.Name).ToMergeString(","); table.Key = keycolumns; } catch (Exception) { throw; } yield return(table); conn.CloseConnection(); } }
public static IEnumerable <Column> GetColumns(this AppModule module, string schema, string table) { IEnumerable <Column> columns = null; var conn = module.OpenConnection(); columns = GetColumns(conn, schema, table, module.SqlBuilder.GetName(table)).ToList(); conn.CloseConnection(); foreach (var column in columns) { var sysColumn = module.SystemColumns.FirstOrDefault(s => s.Name.Equals(column.Name, StringComparison.OrdinalIgnoreCase)); if (sysColumn != null) { column.IsSystem = true; column.IsReadOnly = sysColumn.IsReadOnly; column.SystemParameter = sysColumn.SystemParameter; } yield return(column); } }