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