public FrmDatabaseImportExplorer(Connector.SgbdType sgbdType, String connectionString, DataBase db)
{
InitializeComponent();
_connectionString = connectionString;
_sgbdType = sgbdType;
_appReader = new AppSettingsReader();
_db = db;
populateTreeView();
((DataGridViewComboBoxColumn)dgvDataType.Columns["DataTypeTargetColumn"]).DataSource = _lstDt;
((DataGridViewComboBoxColumn)dgvDataType.Columns["DataTypeTargetColumn"]).DisplayMember = "Name";
((DataGridViewComboBoxColumn)dgvDataType.Columns["DataTypeTargetColumn"]).ValueMember = "Name";
DataGridViewTextBoxCell cell = new DataGridViewTextBoxCell();
cell.ValueType = typeof(Int64);
dgvDataType.Columns[5].CellTemplate = cell;
_mapper = new DataTypeMapper(_sgbdType);
}
public string GetBaseStruct(string baseName, List<DataImportTable> tableList)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine(baseName);
sb.AppendLine(tableList.Count.ToString());
DataTypeMapper dtm = new DataTypeMapper(_sgbdType);
foreach (DataImportTable table in tableList)
{
sb.AppendLine();
sb.AppendLine(String.Format("\"{0}\" {1} {2} {3}", table.Name, table.Order.ToString(), table.Count.ToString(), table.Columns.Count.ToString()));
foreach (DataImportColumn column in table.Columns)
{
string finalType = dtm.Map(column.DataType);
string length = dtm.MapLength(column.DataType, column.Size);
if (finalType == "VARCHAR" || finalType == "VARCHAR2")
if (length != string.Empty)
length = ((Int64.Parse(length) + 1)).ToString();
sb.AppendLine(String.Format("\"{0}\" {1} {2} {3}", column.Name, column.Order.ToString(), length, finalType));
}
}
return sb.ToString();
}
