public void ShowConfigForm() { CurrentConfigFileName = UtilGeneral.GetConfigValue(MySettingsUserConfig.KEY_CONFIG_NAME); frmConfig f = new frmConfig(CurrentConfigFileName, this); f.ShowDialog(); }
/// <summary> /// Initial routine for the form /// </summary> public frmMain() { InitializeComponent(); this.Top = 0; this.Left = 0; this.Width = Screen.PrimaryScreen.WorkingArea.Width; this.Height = Screen.PrimaryScreen.WorkingArea.Height; tlpMain.Width = this.Width; dgvTables.Width = (int)(tlpMain.Width * 0.9); tlpMain.Height = this.Height - (sbrMain.Height * 5); dgvTables.Height = (int)(tlpMain.Height * 0.9); tlpRight.Height = (int)(tlpMain.Height * 0.9); this.Show(); try { CurrentConfigFileName = UtilGeneral.GetConfigValue(MySettingsUserConfig.KEY_CONFIG_NAME); if (CurrentConfigFileName == "") { ShowConfigForm(); } else { SQLDwConfig = new MySettingsEnvironments(CurrentConfigFileName); if (!SQLDwConfig.ConfigFileExists()) { UtilGeneral.ShowMessage("Configuration File do not exist. Please create a Configuration file to continue"); ShowConfigForm(); } else { LoadData(); } } if (dgvTables.ColumnCount > 0) { dgvTables.Columns[MyTableList.TABLE_NAME].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvTables.Columns[MyTableList.INDEX_TYPE].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvTables.Columns[MyTableList.BCP_SPLIT_VALUE_TYPE].Width = 30; } } catch (Exception ex) { UtilGeneral.ShowError(ex.Message); } }
private string GetColListForMerge(string MergeScriptType, string SourceAlias, string TargetAlias) { string colstring = ""; foreach (DataRow col in ColumnList.Rows) { string colName; colName = col[COLUMN_NAME].ToString(); colName = UtilGeneral.GetQuotedString(colName); switch (MergeScriptType) { case COL_SCRIPT_TYPE_MERGE_KEY_COL_JOIN: if (col[PKCOLUMN].ToString() == "1") { colstring += Constants.TAB + SourceAlias + "." + colName + " = " + TargetAlias + "." + colName; colstring += COLUMN_SEPERATOR + Environment.NewLine; } break; case COL_SCRIPT_TYPE_MERGE_COL_UPDATE: if (col[PKCOLUMN].ToString() != "1") { colstring += Constants.TAB + Constants.TAB + TargetAlias + "." + colName + " = " + SourceAlias + "." + colName; colstring += COLUMN_SEPERATOR + Environment.NewLine; } break; } } if (MergeScriptType == COL_SCRIPT_TYPE_MERGE_COL_UPDATE) { string strHasColumn = UtilGeneral.GetQuotedString(UtilGeneral.GetConfigValue(MySettingsUserConfig.KEY_HASH_COL_NAME)); colstring += Constants.TAB + Constants.TAB + Constants.MERGE_TARGET_ALIAS + "." + strHasColumn + " = " + Constants.MERGE_SOURCE_ALIAS + "." + strHasColumn; colstring += COLUMN_SEPERATOR + Environment.NewLine; } colstring = colstring.TrimEnd(); //Remove the last comma if (colstring.EndsWith(COLUMN_SEPERATOR.Trim())) { colstring = colstring.Substring(0, colstring.Length - 1); } return(colstring); }