private void hsRunAllCommands_Click(object sender, EventArgs e) { pbProgress.Maximum = _sql.CommandsCount; pbProgress.Minimum = 0; pbProgress.Value = 0; _sql.ScriptNotify.Register4Info(ScriptInfoRaised); _sql.ScriptNotify.Register4Error(ScriptErrorRaised); _sql.RunPreparedCommands(); }
private void ExecuteCommandsFromFile(string filename) { var fi = new FileInfo(filename); if (!fi.Exists) { return; } var content = new StringBuilder(); _notifies?.AddToINFO($@"{StaticFunctionsClass.DateTimeNowStr()} Prepare executing script in file {filename}"); Application.DoEvents(); string _connstr = ConnectionStrings.Instance.MakeConnectionString(_actScriptingDbReg); _sql = new DBBasicClassLibrary.SQLScriptingClass(_connstr, AppSettingsClass.Instance.SQLVariables.GetNewLine(), AppSettingsClass.Instance.SQLVariables.CommentStart, AppSettingsClass.Instance.SQLVariables.CommentEnd, AppSettingsClass.Instance.SQLVariables.SingleLineComment, "SCRIPT"); _sql.ScriptNotify.Register4Info(EventMeldungRaised); _sql.Commands.Clear(); int lineCount = 0; int clearAfter = StaticFunctionsClass.ToIntDef(txtClear.Text, 1000); fcbCommands.Clear(); fcbCommands.BeginUpdate(); content.Clear(); long mx = fi.Length / 20; pbProgress.Maximum = (int)mx; pbProgress.Minimum = 0; pbProgress.Value = 0; using (var sr = new StreamReader(fi.FullName, Encoding.Default)) { if (pbProgress.Maximum >= pbProgress.Minimum) { pbProgress.Value = 0; } var startDt = DateTime.Now; while (!sr.EndOfStream) { string str = sr.ReadLine(); bool cmdeady = _sql.AddCommandLine($@"{str}{Environment.NewLine}"); if (!cmdeady) { continue; } lineCount++; var returnList = _sql.RunPreparedCommands(); _sql.Commands.Clear(); } fcbCommands.EndUpdate(); Cursor = Cursors.Default; _notifies?.AddToINFO($@"{StaticFunctionsClass.DateTimeNowStr()} Preparing done {lineCount.ToString()} commands"); Application.DoEvents(); } }