private void buttonViewScript_Click(object sender, EventArgs e) { string flags = GetFlags(); if (string.IsNullOrEmpty(flags)) { MessageBox.Show("Please choose at least one flag", "Prompt"); return; } TableSynchronization.OptimizeOption option = TableSynchronization.OptimizeOption.Minimum; if (comboBoxOptimizeOption.Text.Equals("Middle")) { option = TableSynchronization.OptimizeOption.Middle; } else if (comboBoxOptimizeOption.Text.Equals("None")) { option = TableSynchronization.OptimizeOption.None; } int step = (int)numericUpDownStep.Value; _TableSync = new TableSynchronization(DataAccess.Conn, TableName, step, option, checkBoxFastestMode.Checked, flags); textBoxScript.Text = _TableSync.GetSql(); this.Height = textBoxScript.Top + textBoxScript.Height + 40; }
private bool Start() { try { _StartTime = DateTime.Now; TableSynchronization.OptimizeOption option = TableSynchronization.OptimizeOption.Minimum; if (comboBoxOptimizeOption.Text.Equals("Middle")) { option = TableSynchronization.OptimizeOption.Middle; } else if (comboBoxOptimizeOption.Text.Equals("None")) { option = TableSynchronization.OptimizeOption.None; } int step = (int)numericUpDownStep.Value; _TableSync = new TableSynchronization(DataAccess.Conn, TableName, step, option, checkBoxFastestMode.Checked, _Flags); _TableSync.Synchronize(); _Thread = new System.Threading.Thread(ShowProgress); _Thread.IsBackground = true; _Thread.Start(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
private void buttonViewScript_Click(object sender, EventArgs e) { TableSynchronization.OptimizeOption option = TableSynchronization.OptimizeOption.Minimum; if (comboBoxOptimizeOption.Text.Equals("Middle")) { option = TableSynchronization.OptimizeOption.Middle; } else if (comboBoxOptimizeOption.Text.Equals("None")) { option = TableSynchronization.OptimizeOption.None; } int step = (int)numericUpDownStep.Value; textBoxScript.Text = GetSql(step, option); this.Height = textBoxScript.Top + textBoxScript.Height + 40; }
private bool Start() { try { _StartTime = DateTime.Now; TableSynchronization.OptimizeOption option = TableSynchronization.OptimizeOption.Minimum; if (comboBoxOptimizeOption.Text.Equals("Middle")) { option = TableSynchronization.OptimizeOption.Middle; } else if (comboBoxOptimizeOption.Text.Equals("None")) { option = TableSynchronization.OptimizeOption.None; } int step = (int)numericUpDownStep.Value; string sql = GetSql(step, option); GlobalSetting.DataAccess.Excute(sql); _TableSync = new TableSynchronization(DataAccess.Conn, TableName, step, option, false, null); _Thread = new System.Threading.Thread(ShowProgress); _Thread.IsBackground = true; _Thread.Start(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
private string GetSql(int step, TableSynchronization.OptimizeOption option) { return(string.Format("exec SP_Rebuild '{0}', {1}, {2}", _TableName.Replace("'", "''"), step, (int)option)); }