public SQLCommandsReturnInfoClass ExecSql(string cmd, DBRegistrationClass DBReg, NotifiesClass localNotify) { var SQLcommand = new SQLCommandsClass(DBReg); SQLcommand.SetEncoding("NONE"); var ri = SQLcommand.ExecuteCommand(cmd, true); if (!ri.commandDone) { string errorStr = AppStaticFunctionsClass.GetErrorCodeString(ri.lastError, DBReg); localNotify?.AddToERROR(AppStaticFunctionsClass.GetFormattedError($@"FieldForm->ExecuteCommand", $@"{cmd}->{errorStr}")); } else { localNotify?.AddToINFO(AppStaticFunctionsClass.GetFormattedInfo($@"Command done", cmd)); } return(ri); }
private void DoCreateAlter(IList <string> cmd, DBRegistrationClass DBReg) { var SQLcommand = new SQLCommandsClass(DBReg); SQLcommand.Notify.Register4Info(MeldungRaised); SQLcommand.Notify.Register4Error(ErrorRaised); IList <string> cmd2 = new List <string>(); foreach (string s in cmd) { if (s.Trim().StartsWith("/*")) { continue; } if (string.IsNullOrEmpty(s)) { continue; } cmd2.Add(s); } var ri = SQLcommand.ExecuteCommand(cmd2, true); }
private SQLCommandsReturnInfoClass ExecSql(string command) { var _sqLcommand = new SQLCommandsClass(DBReg); _sqLcommand.SetEncoding(cbEncoding.Text); var ri = _sqLcommand.ExecuteCommandWithGlobalConnection(command, true); if (ri.commandDone) { done++; txtSQLdone.Text += $@"{command}{Environment.NewLine}"; tabPageSQLdone.Text = $@"SQL done {done}"; } else { notdone++; txtSQLfail.Text += $@"{command}{Environment.NewLine}"; tabPageSQLfail.Text = $@"SQL fail {notdone}"; } return(ri); }
public SQLViewForm1(DBRegistrationClass ca, List <TableClass> actTables, Form mdiParent = null, eColorDesigns appDesign = eColorDesigns.Gray, eColorDesigns developDesign = eColorDesigns.Gray, bool testMode = false) { MdiParent = mdiParent; _dbReg = ca; _actTables = actTables; _appDesign = appDesign; _developDesign = developDesign; InitializeComponent(); var nf = new NotifiesClass(); nf.gaugeNotify.OnRaiseGaugeHandler += new NotifyGauge.RaiseGaugeHandler(GaugeRaised); _localNotifies.AddNotify(nf, "SQLViewForm"); _localNotifies.AddNotify(NotifiesClass.Instance(), "GLOBAL"); _sqLcommand = new SQLCommandsClass(_dbReg, _localNotifies.Find("SQLViewForm")); tabPageSucceeded.Text = "commands succeded DESC"; Meldungen(); Errors(); History(); ClearDevelopDesign(_developDesign); SetDesign(_appDesign); cbTestlauf.Checked = testMode; cbTestlauf.Visible = testMode; }
private void DoCreateAlter(IList <string> cmd, DBRegistrationClass DBReg, NotifiesClass _localNofity, string Name) { var SQLcommand = new SQLCommandsClass(DBReg, _localNofity); var ri = SQLcommand.ExecuteCommand(cmd, true); }