private DataItem CreateDataItem(DataSourceView parDsv, string parTableName, string parColumnName) { DataTable dataTable = ((DataSourceView)parDsv).Schema.Tables[parTableName]; DataColumn dataColumn = dataTable.Columns[parColumnName]; return(new DataItem(parTableName, parColumnName, OleDbTypeConverter.GetRestrictedOleDbType(dataColumn.DataType))); }
/// <summary> /// Create data item /// </summary> /// <param name="dsv"></param> /// <param name="factTableName"></param> /// <param name="factFKDimColumnName"></param> /// <param name="dataType"></param> /// <returns></returns> internal static DataItem CREATE_DATA_ITEM( DB_SQLHELPER_BASE sqlHelper, DataSourceView dsv, String factTableName, String factFKDimColumnName, System.Data.OleDb.OleDbType dataType) { DataTable data_table = dsv.Schema.Tables[factTableName]; DataColumn dataColumn = data_table.Columns[factFKDimColumnName]; if (dataColumn == null) { sqlHelper.ADD_MESSAGE_LOG( String.Format("Table [{0}] doesn't have column [{0}]", factTableName, factFKDimColumnName), MESSAGE_TYPE.COLUMN_BINDING_DATA_ITEM, MESSAGE_RESULT_TYPE.Error); } DataItem dataItem = new DataItem(factTableName, dataColumn.ColumnName); if (dataType != null) { dataItem.DataType = dataType; } else { dataItem.DataType = OleDbTypeConverter.GetRestrictedOleDbType(dataColumn.DataType); } return(dataItem); }
/// <summary> /// Create Column Binding Data Item /// </summary> /// <param name="dsv"></param> /// <param name="tableName"></param> /// <param name="columnName"></param> /// <param name="dataType"></param> /// <returns></returns> internal static DataItem CREATE_COLUMN_BINDING_DATA_ITEM( DB_SQLHELPER_BASE sqlHelper, DataSourceView dsv, String tableName, String columnName, System.Data.OleDb.OleDbType dataType) { DataItem dataItem = null; DataTable data_table = dsv.Schema.Tables[tableName]; if (data_table == null) { sqlHelper.ADD_MESSAGE_LOG( String.Format("Table {0} is not existed in current DSV", tableName), MESSAGE_TYPE.COLUMN_BINDING_DATA_ITEM, MESSAGE_RESULT_TYPE.Warning); } DataColumn dataColumn = data_table.Columns[columnName]; if (dataColumn == null) { sqlHelper.ADD_MESSAGE_LOG( String.Format("Column {0} is not existed in table {1}", columnName, tableName), MESSAGE_TYPE.COLUMN_BINDING_DATA_ITEM, MESSAGE_RESULT_TYPE.Warning); } dataItem = new DataItem(tableName, dataColumn.ColumnName); if (dataType != null) { dataItem.DataType = dataType; } else { dataItem.DataType = OleDbTypeConverter.GetRestrictedOleDbType(dataColumn.DataType); } return(dataItem); }
private DataItem CreateDataItem(DataSourceView dsv, string tableName, string columnName) { DataTable dataTable = ((DataSourceView)dsv).Schema.Tables[tableName]; DataColumn dataColumn = dataTable.Columns[columnName]; return(new DataItem(tableName, columnName, OleDbTypeConverter.GetRestrictedOleDbType(dataColumn.DataType))); }
private void SetProperties(MeasureDataType dataType, Type type, double min, double max, bool allowsDecimals, bool allowsMoreThan4Decimals) { this.dataType = dataType; this.type = type; if (dataType == MeasureDataType.Currency) //Type=Decimal isn't enough for it to correctly determine Currency { this.oleDbType = OleDbType.Currency; } else { this.oleDbType = OleDbTypeConverter.GetRestrictedOleDbType(type); } this.min = min; this.max = max; this.displayMin = FormatDouble(min); this.displayMax = FormatDouble(max); this.allowsDecimals = allowsDecimals; this.allowsMoreThan4Decimals = allowsMoreThan4Decimals; }
private DataItem CreateDataItem(string tableName, string columnName, NullProcessing aNullProcessing, DataType aDataType) { DataTable dataTable = _CbDataSourceView.Schema.Tables[tableName]; DataColumn dataColumn = dataTable.Columns[columnName]; OleDbType aOleDbType; if (aDataType == null) { aOleDbType = OleDbTypeConverter.GetRestrictedOleDbType(dataColumn.DataType); } else { aOleDbType = ConvertFromSqlDataType(aDataType); } DataItem aDataItem = new DataItem(tableName, columnName, aOleDbType); aDataItem.NullProcessing = aNullProcessing; return(aDataItem); }