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