//Form UI Actions
private void dgvTables_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
frmTableDetails f = new frmTableDetails(this, dgvTables.Rows[e.RowIndex], SQLDwConfig);
f.ShowDialog();
}
}
catch (Exception ex)
{
UtilGeneral.ShowError(ex.Message);
}
}
public frmTableSplit(frmTableDetails ParentForm, string strSchema, string strTable, string strBCPCol, string strBCPValues, string strBCPValueType, MySettingsEnvironments CurrentConfig)
{
InitializeComponent();
this.frmParent = ParentForm;
SQLDwConfig = CurrentConfig;
SchemaName = strSchema;
TableName = strTable;
//Load Initial Values
lblName.Text = SchemaName + "." + TableName;
optSplitColumn.Checked = true;
optTPYear.Checked = true;
optValueTable.Checked = true;
dtpStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpEnd.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month));
txtBCPValueType.Text = strBCPValueType;
//Load Column List
MyColumnList col = new MyColumnList(SchemaName, TableName, SQLDwConfig);
colList = col.GetColumnsList();
cmbColumns.Items.Clear();
foreach (DataRow row in colList.Rows)
{
cmbColumns.Items.Add(row[MyColumnList.COLUMN_NAME]);
}
strBCPCol = strBCPCol.Replace("[", "");
strBCPCol = strBCPCol.Replace("]", "");
if (strBCPCol != "")
{
cmbColumns.SelectedItem = strBCPCol;
}
else
{
cmbColumns.SelectedIndex = 0;
}
if (strBCPValueType == Constants.BCP_SPLIT_TYPE_VALUE)
{
optValueSelect.Checked = false;
}
else
{
optSplitTimePeriod.Checked = true;
optValueSelect.Checked = true;
}
switch (strBCPValueType)
{
case Constants.BCP_SPLIT_TYPE_TIME_YEAR:
optTPYear.Checked = true;
break;
case Constants.BCP_SPLIT_TYPE_TIME_MONTH:
optTPMonth.Checked = true;
break;
case Constants.BCP_SPLIT_TYPE_TIME_DATE:
case Constants.BCP_SPLIT_TYPE_TIME_INT_DATE:
optTPDay.Checked = true;
break;
default:
optSplitColumn.Checked = true;
break;
}
lstValues.Items.Clear();
if (strBCPValues != "")
{
string[] BCPVals = strBCPValues.Split(',');
foreach (string val in BCPVals)
{
lstValues.Items.Add(val);
}
if (strBCPValueType == Constants.BCP_SPLIT_TYPE_TIME_MONTH)
{
lstValues.Items.RemoveAt(0);
lstValues.Items.RemoveAt(lstValues.Items.Count - 1);
}
}
}
