private void CreateAll()
{
this.m_Datas.Clear();
this.CreateTableColumnList();
string cbx_name = "";
for (int i = 1; i <= 6; i++)
{
cbx_name = "CbxTabelle" + FuncString.FillForward(i.ToString(), "0", 2);
ComboBox obj_cbx_tabelle = (ComboBox)FuncGeneral.GetControlByName(this, cbx_name);
obj_cbx_tabelle.Items.Clear();
obj_cbx_tabelle.Items.AddRange(this.m_Tablelist.ToArray());
obj_cbx_tabelle.SelectedIndexChanged += new System.EventHandler(this.CbxTable_SelectedIndexChanged);
obj_cbx_tabelle.SelectedIndex = obj_cbx_tabelle.Items.IndexOf(this.m_ClsIni.getValue("AuswahlTabelle", cbx_name));
cbx_name = "CbxSpalte" + FuncString.FillForward(i.ToString(), "0", 2);
ComboBox obj_cbx_column = (ComboBox)FuncGeneral.GetControlByName(this, cbx_name);
obj_cbx_column.SelectedIndex = obj_cbx_column.Items.IndexOf(this.m_ClsIni.getValue("AuswahlTabelle", cbx_name));
obj_cbx_column.SelectedIndexChanged += new System.EventHandler(this.CbxColumn_SelectedIndexChanged);
cbx_name = "txtFilter" + FuncString.FillForward(i.ToString(), "0", 2);
TextBox obj_txt_filter = (TextBox)FuncGeneral.GetControlByName(this, cbx_name);
obj_txt_filter.Text = this.m_ClsIni.getValue("AuswahlTabelle", cbx_name);
obj_txt_filter.TextChanged += new System.EventHandler(this.txtFilter_TextChanged);
}
for (int i = 1; i <= 2; i++)
{
cbx_name = "cbxAndOr" + FuncString.FillForward(i.ToString(), "0", 2);
ComboBox obj_cbx_column = (ComboBox)FuncGeneral.GetControlByName(this, cbx_name);
obj_cbx_column.SelectedIndex = obj_cbx_column.Items.IndexOf(this.m_ClsIni.getValue("AuswahlTabelle", cbx_name));
obj_cbx_column.SelectedIndexChanged += new System.EventHandler(this.cbxAndOr_SelectedIndexChanged);
}
}
private void CreateO2Curve()
{
string caption = "O2 Kurve";
TabPage tab_page = this.CreateTabPage(caption, this.m_tabControl);
GroupBox group_box = (GroupBox)this.CreateGroupBox(4, 4, this.m_tabControl.Width - 18, this.m_tabControl.Height - 56, caption, tab_page);
Label label;
CompMultiBar multi_bar;
int off = 290;
int width_label = 48;
int width = 30;
int space = 2;
int left = 4;
int left_multi_bar = 0;
for (int i = 0; i < 11; i++)
{
string format = "{0:0.00}";
label = this.CreateLabel(left, i * 20 + off, width_label, 20, String.Format(format, 10 - i) + "-", group_box);
left_multi_bar = label.Left + label.Width + space;
}
string varname = "";
int col = 0;
int row = 0;
for (int i = 0; i < 21; i++)
{
multi_bar = this.CreateMultiBar(i * (width + space) + left_multi_bar, off + 13, width, 200, group_box);
multi_bar.Name = "compMultiBarBurnerLoad" + i.ToString();
multi_bar.ColorBar1 = Color.Blue;
multi_bar.Click += new System.EventHandler(this.compMultiBarBurnerLoad_Click);
label = this.CreateLabel(i * (width + space) + left_multi_bar, multi_bar.Top + multi_bar.Height + space, width, 30, i.ToString(), group_box, ContentAlignment.MiddleCenter);
varname = "DB55.Burner" + FuncString.FillForward(i.ToString(), "0", 2);
this.m_dataBinding.AddList(this, multi_bar.Name.ToString(), "Value1", varname);
PlcItemList plc_item_list = this.GetPlcItemList(varname);
CompInputBox input_box;
left = col * (89 + 2) + 72;
int top = row * (35 + 2) + 30;
plc_item_list.Varname = varname;
input_box = this.CreateInputBox(left, top, plc_item_list.Format, group_box);
input_box.Name = "compInputBoxBurnerLoad" + i.ToString();
input_box.Symbol = varname;
input_box.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.InputBox_KeyPress);
input_box.Leave += new System.EventHandler(this.compInputBoxBurnerLoad_Leave);
input_box.Enter += new System.EventHandler(this.compInputBoxBurnerLoad_Enter);
this.m_dataBinding.AddList(this, input_box.Name.ToString(), "Text", varname);
this.m_plcItemList.Add(input_box, plc_item_list);
this.m_userManagement.AddUserRightControl(input_box, plc_item_list.UserRightEnable);
col++;
if (col > 6)
{
this.CreateLabel(input_box.Left + input_box.Width + space, input_box.Top, 20, input_box.Height, plc_item_list.Unit, group_box, ContentAlignment.MiddleLeft);
row++;
col = 0;
}
}
}
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 btnStartQuery_Click(object sender, EventArgs e)
{
string cbx_name = "";
string txt_name = "";
string conjunction = "";
bool add_where = true;
bool add_select = true;
this.m_SqlHelper.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.DeleteSQL);
this.m_SqlHelperWhere.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.DeleteSQL);
for (int i = 1; i <= 6; i++)
{
cbx_name = "CbxTabelle" + FuncString.FillForward(i.ToString(), "0", 2);
ComboBox obj_cbx_tabelle = (ComboBox)FuncGeneral.GetControlByName(this, cbx_name);
cbx_name = "CbxSpalte" + FuncString.FillForward(i.ToString(), "0", 2);
ComboBox obj_cbx_column = (ComboBox)FuncGeneral.GetControlByName(this, cbx_name);
txt_name = "txtFilter" + FuncString.FillForward(i.ToString(), "0", 2);
TextBox obj_txt_filter = (TextBox)FuncGeneral.GetControlByName(this, txt_name);
if (obj_cbx_tabelle.SelectedItem != null)
{
string table = obj_cbx_tabelle.SelectedItem.ToString();
if (obj_cbx_column.SelectedItem != null)
{
if (add_select == true)
{
add_select = false;
this.m_SqlHelper.SQLBuilderHinzufuegen("SELECT TOP 100", SQLHelper.SQLBuilder.DeleteSQL);
}
string column = obj_cbx_column.SelectedItem.ToString();
string suchen = table + column;
TableStruct table_struct = (TableStruct)this.m_Datas[suchen];
string display = table_struct.Display;
this.m_SqlHelper.SQLBuilderHinzufuegen(table, SQLHelper.SQLBuilder.NoSpace);
this.m_SqlHelper.SQLBuilderHinzufuegen(".", SQLHelper.SQLBuilder.NoSpace);
this.m_SqlHelper.SQLBuilderHinzufuegen(column, SQLHelper.SQLBuilder.NoSpace);
if (display.Length > 0)
{
this.m_SqlHelper.SQLBuilderHinzufuegen(" AS");
this.m_SqlHelper.SQLBuilderHinzufuegen(display, SQLHelper.SQLBuilder.NoSpace);
this.m_SqlHelper.SQLBuilderHinzufuegen(",", SQLHelper.SQLBuilder.NoSpace);
}
else
{
this.m_SqlHelper.SQLBuilderHinzufuegen(",", SQLHelper.SQLBuilder.NoSpace);
}
if (obj_txt_filter.Text.Length > 0)
{
if (add_where == true)
{
add_where = false;
this.m_SqlHelperWhere.SQLBuilderHinzufuegen("WHERE", SQLHelper.SQLBuilder.DeleteSQL);
}
if (conjunction.Length > 0)
{
this.m_SqlHelperWhere.SQLBuilderHinzufuegen(conjunction);
}
if ((table_struct.Columntype == "char") || (table_struct.Columntype == "nchar"))
{
this.m_SqlHelperWhere.SQLBuilderHinzufuegen(table_struct.Table + "." + table_struct.Column);
this.m_SqlHelperWhere.SQLBuilderHinzufuegen("LIKE");
this.m_SqlHelperWhere.SQLBuilderHinzufuegen("N'%", SQLHelper.SQLBuilder.NoSpace);
this.m_SqlHelperWhere.SQLBuilderHinzufuegen(obj_txt_filter.Text, SQLHelper.SQLBuilder.NoSpace);
this.m_SqlHelperWhere.SQLBuilderHinzufuegen("%'", SQLHelper.SQLBuilder.NoSpace);
}
else
{
this.m_SqlHelperWhere.SQLBuilderHinzufuegen(table_struct.Table + "." + table_struct.Column);
this.m_SqlHelperWhere.SQLBuilderHinzufuegen("=");
this.m_SqlHelperWhere.SQLBuilderHinzufuegen(obj_txt_filter.Text, SQLHelper.SQLBuilder.NoSpace);
}
if (i >= 1 || i < 3)
{
conjunction = " AND";
}
if (i == 4)
{
conjunction = " " + this.cbxAndOr01.Text;
}
if (i == 5)
{
conjunction = " " + this.cbxAndOr02.Text;
}
}
}
}
}
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);
this.m_SqlHelperInnerJoin.SQLBuilderHinzufuegen("FROM", SQLHelper.SQLBuilder.DeleteSQL);
this.m_SqlHelperInnerJoin.SQLBuilderHinzufuegen("MW_KENNDATEN_EINGABE");
this.m_SqlHelperInnerJoin.SQLBuilderHinzufuegen("INNER JOIN");
this.m_SqlHelperInnerJoin.SQLBuilderHinzufuegen("MW_ERGEBNIS");
this.m_SqlHelperInnerJoin.SQLBuilderHinzufuegen("ON");
this.m_SqlHelperInnerJoin.SQLBuilderHinzufuegen("MW_KENNDATEN_EINGABE.LINK = MW_ERGEBNIS.Link");
this.m_SqlHelperInnerJoin.SQLBuilderHinzufuegen("INNER JOIN");
this.m_SqlHelperInnerJoin.SQLBuilderHinzufuegen("MW_WERTE_MESSUNG");
this.m_SqlHelperInnerJoin.SQLBuilderHinzufuegen("ON");
this.m_SqlHelperInnerJoin.SQLBuilderHinzufuegen("MW_KENNDATEN_EINGABE.LINK = MW_WERTE_MESSUNG.Link");
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.textBox1.Text = sql + sql_inner_join + sql_where;
this.BindData(this.textBox1.Text, this.m_BS_Auswahl);
}
