public static TableLink LoadTableLink(IDataLayer dbConnection, IPrimaryKeyCreator primaryKeyCreator, FieldBlank[] fields, IndexBlank[] indicies, string database, string select, string conditionWithoutWhere, params DbParameter[] conditionParameters) { return LoadTableLink(dbConnection, primaryKeyCreator, fields, indicies, new LinkConstraint[0], database, select, conditionWithoutWhere, conditionParameters); }
public static TableLink LoadTableLink(IDataLayer dbConnection, IPrimaryKeyCreator primaryKeyCreator, FieldBlank[] fields, IndexBlank[] indicies, LinkConstraint[] constraints, string database, string select, string conditionWithoutWhere, params DbParameter[] conditionParameters) { TableLink link = new TableLink( new DatabaseTableProvider(dbConnection, database, select, conditionWithoutWhere, conditionParameters), primaryKeyCreator, fields, indicies, constraints); if (primaryKeyCreator != null) link.Table.PrimaryKey = new DataColumn[] { link.Table.Columns[0] }; return link; }
public TableLink(ITableProvider tableProvider, IPrimaryKeyCreator primaryKeyCreator, FieldBlank[] fields, IndexBlank[] indicies, params LinkConstraint[] constraints) { this.tableProvider = tableProvider; if (tableProvider.Table.Columns.Count != fields.Length) throw new Exception("Ошибка создания TableLink: число колонок таблицы не равно числу полей"); this.primaryKeyCreator = primaryKeyCreator; this.indicies = indicies; this.constraints = constraints; Dictionary<string, bool> isIndicesPartByName = new Dictionary<string, bool>(); foreach (IndexBlank index in indicies) { if (index.IsMultiIndex) multiIndicesByName[index.IndexName] = new Dictionary<UniversalKey, List<RowLink>>(); else singleIndicesByName[index.IndexName] = new Dictionary<UniversalKey, RowLink>(); foreach (string fieldName in index.IndexColumns) isIndicesPartByName[fieldName] = true; //fieldsByName[fieldName].IsIndicesPart = true; } int columnIndex = 0; foreach (FieldBlank fieldBlank in fields) { fieldsByName[fieldBlank.FieldName] = new FieldLink(fieldBlank, columnIndex, DictionaryHlp.GetValueOrDefault(isIndicesPartByName, fieldBlank.FieldName)); columnIndex++; } foreach (DataRow dataRow in tableProvider.Table.Rows) { if (dataRow.RowState != DataRowState.Deleted) CreateIndexForRow(new RowLink(this, dataRow)); } }
public TableLink(IDataLayer dbConnection, string database, DataTable table, string updateQuery, IPrimaryKeyCreator primaryKeyCreator, FieldBlank[] fields, IndexBlank[] indicies, params LinkConstraint[] constraints) : this(new DatabaseTableProvider(dbConnection, database, updateQuery, table), primaryKeyCreator, fields, indicies, constraints) { }