private void compInputBoxDriveGas_Enter(object sender, EventArgs e) { this.ResetSelectAllDriveGas(); CompInputBox obj = (CompInputBox)sender; string number = FuncString.GetOnlyNumeric(obj.Name); CompMultiBar obj_set_focus = (CompMultiBar)this.m_dataBinding.GetControlByName(this, "compMultiBarCompoundDriveGas" + number); obj_set_focus.Choise = true; }
private void compInputBoxDriveGas_Leave(object sender, EventArgs e) { CompInputBox obj = (CompInputBox)sender; string number = FuncString.GetOnlyNumeric(obj.Name); CompMultiBar obj_set_focus = (CompMultiBar)this.m_dataBinding.GetControlByName(this, "compMultiBarCompoundDriveGas" + number); obj_set_focus.Choise = false; this.InputBox_Leave(sender, e); }
private void compMultiBarBurnerLoad_Click(object sender, EventArgs e) { this.ResetSelectAllBurnerLoad(); CompMultiBar obj = (CompMultiBar)sender; string number = FuncString.GetOnlyNumeric(obj.Name); obj.Choise = true; CompInputBox obj_set_focus = (CompInputBox)this.m_dataBinding.GetControlByName(this, "compInputBoxBurnerLoad" + number); obj_set_focus.Focus(); }
private void rotaBitButton1_Click(object sender, EventArgs e) { FuncGeneral.KillProgram("EXCEL"); ExcelHelper xls = new ExcelHelper(); xls.Workbook_Hinzufuegen(); this.m_SqlHelper.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace); int i = 0; bool add_select = true; foreach (string ert in this.m_Tablelist) { string table = m_Tablelist[i]; string[] cols = m_ColumnlistOutput[i]; foreach (string col in cols) { if (add_select == true) { add_select = false; this.m_SqlHelper.SQLBuilderHinzufuegen("SELECT TOP 100", SQLHelper.SQLBuilder.DeleteSQL); } string suchen = table + "." + col + ","; this.m_SqlHelper.SQLBuilderHinzufuegen(suchen, SQLHelper.SQLBuilder.NoSpace); } i++; } string sql = ""; string sql_where = ""; string sql_inner_join = ""; sql = this.m_SqlHelper.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace); sql = FuncGeneral.DeleteRight(sql, 1); this.m_SqlHelper.SQLBuilderHinzufuegen(sql, SQLHelper.SQLBuilder.DeleteSQL); sql = this.m_SqlHelper.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace); sql_inner_join = this.m_SqlHelperInnerJoin.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace); sql_where = this.m_SqlHelperWhere.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace); this.textBox2.Text = sql + sql_inner_join + sql_where; xls.SQL2Excel(this.textBox2.Text, m_ConnectionString); string file_name = "Messwerte" + FuncString.GetOnlyNumeric(FuncString.GetTimestamp()); xls.DateiSpeichern(file_name); xls.ExcelHelperClose(); xls = null; }
private DatenService ParseCommentService(string SymboleName, string Comment) { DatenService retval; string[] commentData = Comment.Split(':'); string comment = commentData[1]; retval.SymbolTabText = commentData[0]; retval.SymbolName = SymboleName; retval.Seite = this.m_TabInfo[retval.SymbolTabText]; retval.SymbolEinheit = FuncGeneral.Parse("\\[EH.*\\]", ref comment); int.TryParse(FuncString.GetOnlyNumeric(FuncGeneral.Parse("\\[ZE[0-9]\\]", ref comment)), out retval.Zeile); int.TryParse(FuncString.GetOnlyNumeric(FuncGeneral.Parse("\\[SP[0-9]\\]", ref comment)), out retval.Spalte); retval.SymbolKommentar = comment; return(retval); }
private void CbxTable_SelectedIndexChanged(object sender, EventArgs e) { ComboBox cbx_table = (ComboBox)sender; string nummer = FuncString.FillForward(FuncString.GetOnlyNumeric(cbx_table.Name), "0", 2); string obj_name = "CbxSpalte" + nummer; ComboBox cbx_column = (ComboBox)FuncGeneral.GetControlByName(this, obj_name); cbx_column.Items.Clear(); cbx_column.Items.AddRange(this.m_Columnlist[cbx_table.SelectedIndex]); int id = cbx_column.Items.IndexOf(this.m_ClsIni.getValue("AuswahlTabelle", obj_name)); if (id > -1) { cbx_column.SelectedIndex = id; } else { cbx_column.Text = ""; } this.m_ClsIni.setValue("AuswahlTabelle", cbx_table.Name, cbx_table.SelectedItem.ToString()); this.m_ClsIni.Save(); }
private void Form1_Load(object sender, EventArgs e) { this.helperLibNoDave.LoadPlcData(); this.LoadComponentBindings(); glb_plc.IP = "10.100.72.125"; glb_plc.Rack = 0; glb_plc.Slot = 2; glb_plc.Open(); glb_plc.Read(); FrmRelease frmRelease = new FrmRelease(); FrmError frmError = new FrmError(); FrmPara frmPara = new FrmPara(); FrmService frmService = new FrmService(); List <Helper.Valve> Schieber = new List <Helper.Valve>(); Schieber.Add(this.ValveV100); Schieber.Add(this.ValveV110); Schieber.Add(this.ValveV120); Schieber.Add(this.ValveV130); Schieber.Add(this.ValveV140); Schieber.Add(this.ValveV200); Schieber.Add(this.ValveV210); Schieber.Add(this.ValveV220); Schieber.Add(this.ValveV300); Schieber.Add(this.ValveV310); Schieber.Add(this.ValveV320); Schieber.Add(this.ValveV400); Schieber.Add(this.ValveV410); Schieber.Add(this.ValveV420); Schieber.Add(this.ValveV500); Schieber.Add(this.ValveV510); Schieber.Add(this.ValveV600); Schieber.Add(this.ValveV610); Schieber.Add(this.ValveV620); Schieber.Add(this.ValveV630); Schieber.Add(this.ValveV640); Schieber.Add(this.ValveV650); Schieber.Add(this.ValveV660); Schieber.Add(this.ValveV670); Schieber.Add(this.ValveV680); Schieber.Add(this.ValveV690); Schieber.Add(this.ValveV700); Schieber.Add(this.ValveV710); frmSchieber = new FrmSchieber[Schieber.Count]; int counter = 0; foreach (Helper.Valve schieber in Schieber) { schieber.Click += new System.EventHandler(this.valve); frmSchieber[counter] = new FrmSchieber(); frmSchieber[counter].TopMost = true; string frmName = "FrmSchieber" + schieber.Name; frmSchieber[counter].Name = frmName; string titelFormular = "Schieber " + schieber.Name.Substring(5, 2) + "." + schieber.Name.Substring(7); frmSchieber[counter].Text = titelFormular; frmMng.FormularAdd(frmSchieber[counter], frmName); frmSchieber[counter].BindDatas(FuncString.GetOnlyNumeric(schieber.Name)); Point xyValve = FuncGeneral.GetMiddle(schieber); Point xyFrm = FuncGeneral.GetMiddle(frmSchieber[counter]); Point valvePos = new Point(); valvePos.X = schieber.Left + xyValve.X; valvePos.Y = schieber.Top - xyValve.Y; frmSchieber[counter].Left = valvePos.X - xyFrm.X; frmSchieber[counter].Top = valvePos.Y - xyFrm.Y * 2 - xyValve.Y + 35; if (frmSchieber[counter].Left < 0) { frmSchieber[counter].Left = 0; } if (frmSchieber[counter].Top < 0) { frmSchieber[counter].Top = valvePos.Y + xyValve.Y + 70; } } List <Helper.Scale> Behaelter = new List <Helper.Scale>(); Behaelter.Add(this.ScaleT1); frmBehaelter = new FrmBehaelter[Behaelter.Count]; counter = 0; foreach (Helper.Scale behaelter in Behaelter) { behaelter.Click += new System.EventHandler(this.Behaelter); frmBehaelter[counter] = new FrmBehaelter(); frmBehaelter[counter].TopMost = true; string frmName = "FrmBehaelter" + behaelter.Name; frmBehaelter[counter].Name = frmName; string titelFormular = "Behaelter " + behaelter.Name.Substring(5, 2) + "." + behaelter.Name.Substring(7); frmBehaelter[counter].Text = titelFormular; frmMng.FormularAdd(frmBehaelter[counter], frmName); frmBehaelter[counter].BindDatas(FuncString.GetOnlyNumeric(behaelter.Name)); Point xyValve = FuncGeneral.GetMiddle(behaelter); Point xyFrm = FuncGeneral.GetMiddle(frmBehaelter[counter]); Point valvePos = new Point(); valvePos.X = behaelter.Left + xyValve.X; valvePos.Y = behaelter.Top - xyValve.Y; frmBehaelter[counter].Left = valvePos.X - xyFrm.X; frmBehaelter[counter].Top = valvePos.Y - xyFrm.Y * 2 - xyValve.Y + 35; if (frmBehaelter[counter].Left < 0) { frmBehaelter[counter].Left = 0; } if (frmBehaelter[counter].Top < 0) { frmBehaelter[counter].Top = valvePos.Y + xyValve.Y + 70; } ToolTip toolTip1 = new ToolTip(); toolTip1.AutoPopDelay = 0; toolTip1.ShowAlways = true; toolTip1.UseAnimation = false; toolTip1.SetToolTip(this.BTN_Menu, "Menue"); toolTip1.SetToolTip(this.BTN_Error, "Fehlermeldungen"); } this.Left = 0; this.Top = 0; this.Width = Screen.PrimaryScreen.Bounds.Width; this.Height = Screen.PrimaryScreen.Bounds.Height; this.timer1.Interval = 100; this.timer1.Enabled = true; }