public static void OpenTable(AxMapControl MapControl, ITableName pTName, DataTable dt = null) { try { MapControl.Map.ClearLayers(); MapControl.SpatialReference = null; MapControl.ActiveView.PartialRefresh(esriViewDrawPhase.esriViewAll, null, null); IName pName = pTName as IName; ITable pFc = pName.Open() as ITable; if (null != dt) { InitDataTable(pFc, dt); ICursor pCursor = pFc.Search(null, false); IRow pfea = pCursor.NextRow(); int j = 0; while (pfea != null) { DataRow dataRow = dt.NewRow(); for (int i = 0; i < pfea.Fields.FieldCount; i++) { dataRow[i] = pfea.get_Value(i).ToString(); } dt.Rows.Add(dataRow); pfea = pCursor.NextRow(); j++; } ComReleaser.ReleaseCOMObject(pCursor); } } catch { } }
public JoinCondition(ITableName lhs, JoinClause jn, ITableName rhs, ITruthy comp) { Lhs = lhs; Jn = jn; Rhs = rhs; Comp = comp; }
public OperationalDatasetCollection(IWorkspace osdbWorkspace) { if (osdbWorkspace == null) throw new System.ArgumentNullException("osdbWorkspace"); // Find the table and determine if this user can edit it ITable theTable = null; string theTableName = ""; try { util.SystemDefaults theDefaults = new util.SystemDefaults(); theTableName = OperationalDatasetCollection.TABLE_NAME; theTable = ((IFeatureWorkspace)osdbWorkspace).OpenTable(theTableName); } catch (Exception) {} if (theTable == null) throw new Exception("Could not open the QA parameters table '" + theTableName + "'"); IDataset theDataset = theTable as IDataset; this._canRead = false; this._canWrite = false; int privs = util.PermissionsAnalyzer.Analyze(theDataset); this._canWrite = (privs == util.PermissionsAnalyzer.READWRITE_PERMISSION); this._canRead = (privs == util.PermissionsAnalyzer.READONLY_PERMISSION) || this._canWrite; if (this._canRead) { this.LoadNames(theTable); OperationalDatasetCollection._lightWeight = (ITableName)theDataset.FullName; } }
/// <summary> /// Adds the table to ListBox. /// </summary> /// <param name="pWorkspace">The p workspace.</param> /// <param name="imageListBoxControl1">The image ListBox control1.</param> public static void AddTableToListBox(IWorkspace pWorkspace, ImageListBoxControl imageListBoxControl1) { if (pWorkspace != null) { IconType iconType = IconType.Table; IEnumDatasetName enumDatasetName = pWorkspace.get_DatasetNames(esriDatasetType.esriDTTable); try { enumDatasetName.Reset(); IDatasetName datasetName; while ((datasetName = enumDatasetName.Next()) != null) { ITableName tableName = datasetName as ITableName; if (tableName != null) { ControlAPI.AddItemToListBox(iconType, datasetName.Name, imageListBoxControl1); } } } finally { Marshal.ReleaseComObject(enumDatasetName); } } }
public SqlBuilder(T instance, SqlCommand command, IDb db, ICache cache, ITableName tableName = null) { this.instance = instance; this.command = command; this.db = db; this.cache = cache; this.tableName = tableName ?? new TableName_ClassName(); }
public override string BuildQueryString(int depth) { ITableName tableName = null; IBigQueryable parent = null; if (typedParent is ITableName) { parent = (IBigQueryable)typedParent; tableName = (ITableName)typedParent; } else if (typedParent is ITableName) { parent = (IBigQueryable)typedParent; tableName = (ITableName)typedParent; } if (tableName != null) { var sb = new StringBuilder(); sb.Append(Indent(depth)); sb.AppendLine("FROM"); sb.Append(Indent(depth + 1)); sb.Append("FLATTEN("); sb.Append(tableName.GetTableName()); sb.Append(", "); sb.Append(BigQueryTranslateVisitor.BuildQuery(depth, parent.QueryContext.IndentSize, fieldSelector)); sb.Append(")"); return(sb.ToString()); } var subquery = typedParent as SubqueryBigQueryable <T>; if (subquery != null) { var sb = new StringBuilder(); sb.Append(Indent(depth)); sb.AppendLine("FROM FLATTEN("); sb.Append(subquery.BuildQueryStringWithoutFrom(depth)); sb.Append(", "); sb.Append(BigQueryTranslateVisitor.BuildQuery(depth, subquery.QueryContext.IndentSize, fieldSelector)); sb.Append(")"); return(sb.ToString()); } throw new InvalidOperationException("Unexpected pattern, please report query to GitHub issues"); }
public Db( IConnectionFactory connectionFactory, IRead reader, ICache cache, ITableName tableName = null ) { this.reader = reader; this.connectionFactory = connectionFactory; this.cache = cache; this.tableName = tableName ?? new TableName_ClassName(); this.getParameterNamesFromSql = new GetParameterNamesFromSql(); this.parameters = new List <(string name, object value)>(); }
public static void OpenTable(AxMapControl MapControl, ITableName pTName, ListView listview1) { try { MapControl.Map.ClearLayers(); MapControl.SpatialReference = null; MapControl.ActiveView.PartialRefresh(esriViewDrawPhase.esriViewAll, null, null); IName pName = pTName as IName; ITable pFc = pName.Open() as ITable; listview1.Items.Clear(); listview1.Columns.Clear(); LoadListView(pFc, listview1); ICursor pCursor = pFc.Search(null, false); IRow pfea = pCursor.NextRow(); int j = 0; while (pfea != null) { ListViewItem lv = new ListViewItem(); for (int i = 0; i < pfea.Fields.FieldCount; i++) { string sFieldName = pfea.Fields.get_Field(i).Name; lv.SubItems.Add(FeatureHelper.GetRowValue(pfea, sFieldName).ToString()); } lv.Tag = pfea; if (j % 2 == 0) { lv.BackColor = System.Drawing.Color.GreenYellow; } listview1.Items.Add(lv); pfea = pCursor.NextRow(); j++; } LSGISHelper.OtherHelper.ReleaseObject(pCursor); } catch { } }
public static ITableName Join(this ITableName lhs, JoinClause jn, ITableName rhs, ITruthy comp) { return(new JoinCondition(lhs, jn, rhs, comp)); }
public static ITableName FullOuterJoin(this ITableName lhs, ITableName rhs, ITruthy comp) { return(new JoinCondition(lhs, JoinClause.FullOuter, rhs, comp)); }
public static FromClause From(ITableName t) { return(new FromClause(t)); }
public QATestCollection(IWorkspace osdbWorkspace, string operationalAreaName) { if (osdbWorkspace == null) throw new System.ArgumentNullException("osdbWorkspace"); // Find the QA tests table and QA params table and determine if this user can edit them ITable theTestTable = null; ITable theParamTable = null; string theTTName = ""; string thePTName = ""; try { util.SystemDefaults theDefaults = new util.SystemDefaults(); theTTName = QATestCollection.TABLE_NAME; theTestTable = ((IFeatureWorkspace)osdbWorkspace).OpenTable(theTTName); thePTName = QAParameterCollection.TABLE_NAME; theParamTable = ((IFeatureWorkspace)osdbWorkspace).OpenTable(thePTName); } catch (Exception) {} if (theTestTable == null) throw new Exception("Could not open the QA parameters table '" + theTTName + "'"); if (theParamTable == null) throw new Exception("Could not open the QA parameters table '" + thePTName + "'"); IDataset theQaTestDS = theTestTable as IDataset; IDataset theQaParamDS = theParamTable as IDataset; bool bCanReadTests = true; bool bCanReadParams = true; bool bCanWriteTests = true; bool bCanWriteParams = true; // no longer concerned about permissions. These are on an open PGDB format /*int privs = util.PermissionsAnalyzer.Analyze(theQaTestDS); bCanWriteTests = (privs == util.PermissionsAnalyzer.READWRITE_PERMISSION); bCanReadTests = (privs == util.PermissionsAnalyzer.READONLY_PERMISSION) || bCanWriteTests; privs = util.PermissionsAnalyzer.Analyze(theQaParamDS); bCanWriteParams = (privs == util.PermissionsAnalyzer.READWRITE_PERMISSION); bCanReadParams = (privs == util.PermissionsAnalyzer.READONLY_PERMISSION) || bCanWriteParams; */ if (bCanReadTests && bCanReadParams) { this._canRead = true; this._canWrite = bCanWriteTests && bCanWriteParams; QAParameterCollection._lightWeight = (ITableName)theQaParamDS.FullName; QAParameterCollection._canRead = bCanReadParams; QAParameterCollection._canWrite = bCanWriteParams; this.LoadTests(theTestTable, theParamTable); QATestCollection._lightWeight = (ITableName)theQaTestDS.FullName; } }
public FromClause(ITableName tbl) { Tbl = tbl; }