private void UserStartReady()
{
UserActionClass.Instance().UserAction = UserActionType.none;
hsBreak.Enabled = false;
hsRunSQL.Enabled = true;
hsRunSQLfromFile.Enabled = true;
}
private void RunSQLFromFile()
{
progressBar1.Value = progressBar1.Minimum;
UserActionClass.Instance().UserAction = UserActionType.none;
if (!string.IsNullOrEmpty(SQLViewLastRunClass.Instance().ScriptPath))
{
ofdSQL.InitialDirectory = SQLViewLastRunClass.Instance().ScriptPath;
}
if (ofdSQL.ShowDialog() != DialogResult.OK)
{
return;
}
hsRunSQLfromFile.Enabled = false;
dataSet1.Clear();
dgvResults.AutoGenerateColumns = true;
var fi = new FileInfo(ofdSQL.FileName);
progressBar1.Value = 0;
progressBar1.Maximum = (int)fi.Length;
hsBreak.Enabled = true;
string connectionstr = ConnectionStrings.Instance().MakeConnectionString(_dbReg);
string[] strarr = File.ReadAllLines(fi.FullName);
var sb = new StringBuilder();
var ri = _sqLcommand.ExecuteCommandsAddToDataset(dataSet1, strarr, true);
dataSet1 = ri.dataSet;
hsRunSQLfromFile.Enabled = true;
SQLViewLastRunClass.Instance().ScriptPath = fi.Directory.FullName;
UserBreak();
}
private void hsClose_Click(object sender, EventArgs e)
{
UserActionClass.Instance().UserAction = UserActionType.none; Close();
}
private void UserStart()
{
UserActionClass.Instance().UserAction = UserActionType.none;
}
private void UserBreak()
{
UserActionClass.Instance().UserAction = UserActionType.abort;
}
