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);
}
