private void Primenit_Click(object sender, EventArgs e) { factory = new LogExpFactory(); int n_fields = FieldTypeCol.getS(); for (int i = 0; i < n_fields; ++i) { bool[] mark = new bool[4]; int n_radio_but = -1; for (int k = 0; k < 4; ++k) { mark[k] = radio_buttons[i, k].Checked; if (mark[k]) { n_radio_but = k + 1; } } if (enables[i].Checked == false && (n_radio_but != -1)) { factory.add_filter(names[i].Text, text_boxs[i].Text, names[i].Name, n_radio_but); } } filter_controler.sort(factory.get_filters()); this.Close(); }
private void FrmCreator_Load_1(object sender, EventArgs e) { fields = FieldTypeCol.getValue(); int n_fields = fields.Count; int[] a_pos = { 10, 110 }; int b_pos = 10; names = new Label[n_fields]; text_boxs = new TextBox[n_fields]; for (int k = 0; k < n_fields; ++k) { names[k] = new Label(); text_boxs[k] = new TextBox(); } for (int i = 0; i < n_fields; ++i) { b_pos += 30; int index = 0; names[i].Text = fields[i].get_name(); names[i].Left = a_pos[index++]; names[i].Top = b_pos; names[i].Name = fields[i].get_type(); text_boxs[i].Width = 120; text_boxs[i].Left = a_pos[index++]; text_boxs[i].Top = b_pos; } for (int k = 0; k < n_fields; ++k) { this.Controls.Add(names[k]); this.Controls.Add(text_boxs[k]); } }
static public void add_avtosalon(string[] str_from_box) { List <Field> new_fields = FieldTypeCol.getValue(); for (int i = 0; i < str_from_box.Count <string>(); ++i) { new_fields[i].set_value(str_from_box[i]); } Firm new_firm = new Firm(); new_firm.Field = new_fields; FirmCol.add_avtosalon(new_firm); }
private void FrmMain_Load(object sender, EventArgs e) { #region /*string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Marina Chebotova\source\repos\laborat4\laborat4\Database1.mdf;Integrated Security=True"; * sqlConnection = new SqlConnection(connectionString); * await sqlConnection.OpenAsync(); * SqlDataReader sqlReader = null; * SqlCommand command = new SqlCommand("SELECT * FROM [Avto]", sqlConnection); * try{ * sqlReader = await command.ExecuteReaderAsync(); * while(await sqlReader.ReadAsync()) * { * ListViewItem lvi = new ListViewItem(); * ListViewItem.ListViewSubItem lvsi = new ListViewItem.ListViewSubItem(); * ListViewItem.ListViewSubItem lvsi2 = new ListViewItem.ListViewSubItem(); * ListViewItem.ListViewSubItem lvsi3 = new ListViewItem.ListViewSubItem(); * ListViewItem.ListViewSubItem lvsi4 = new ListViewItem.ListViewSubItem(); * ListViewItem.ListViewSubItem lvsi5 = new ListViewItem.ListViewSubItem(); * ListViewItem.ListViewSubItem lvsi6 = new ListViewItem.ListViewSubItem(); * ListViewItem.ListViewSubItem lvsi7 = new ListViewItem.ListViewSubItem(); * ListViewItem.ListViewSubItem lvsi8 = new ListViewItem.ListViewSubItem(); * ListViewItem.ListViewSubItem lvsi9 = new ListViewItem.ListViewSubItem(); * lvi.Text = Convert.ToString(sqlReader["Name"]) + ""; * lvsi.Text = Convert.ToString(sqlReader["Town"]) + ""; * lvsi2.Text = Convert.ToString(sqlReader["Street"]) + ""; * lvsi3.Text = Convert.ToString(sqlReader["Country"]) + ""; * lvsi4.Text = Convert.ToString(sqlReader["KolMarok"]) + ""; * lvsi5.Text = Convert.ToString(sqlReader["DataOtkr"]) + ""; * lvsi6.Text = Convert.ToString(sqlReader["WebSait"]) + ""; * lvsi7.Text = Convert.ToString(sqlReader["SrednStoim"]) + ""; * lvsi8.Text = Convert.ToString(sqlReader["Region"]) + ""; * lvsi9.Text = Convert.ToString(sqlReader["Index"])+ ""; * lvi.SubItems.Add(lvsi); * lvi.SubItems.Add(lvsi2); * lvi.SubItems.Add(lvsi3); * lvi.SubItems.Add(lvsi4); * lvi.SubItems.Add(lvsi5); * lvi.SubItems.Add(lvsi6); * lvi.SubItems.Add(lvsi7); * lvi.SubItems.Add(lvsi8); * lvi.SubItems.Add(lvsi9); * listView1.Items.Add(lvi); * //listView1.Items.Add(Convert.ToString(sqlReader["Id"]) + "" + Convert.ToString(sqlReader["Name"]) + "" + Convert.ToString(sqlReader["Town"]) + "" + Convert.ToString(sqlReader["Street"]) + "" + Convert.ToString(sqlReader["Country"]) + "" + Convert.ToString(sqlReader["KolMarok"]) + "" + Convert.ToString(sqlReader["DataOtkr"]) + "" + Convert.ToString(sqlReader["WebSait"]) + "" + Convert.ToString(sqlReader["SrednStoim"]) + "" + Convert.ToString(sqlReader["Region"]) + "" + Convert.ToString(sqlReader["Index"])); * } * } * catch(Exception ex) * { * MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); * } * finally * { * if (sqlReader != null) * sqlReader.Close(); * } */ #endregion // попытка подкл к Бд int n = FieldTypeCol.getS(); List <Field> fields = FieldTypeCol.getValue(); this.listView1.View = View.Details; }
private void FrmFilter_Load(object sender, EventArgs e) { fields = FieldTypeCol.getValue(); int n_fiel = fields.Count; int[] a_pos = { 20, 120, 250, 290 }; int b_pos = 30; names = new Label[n_fiel]; text_boxs = new TextBox[n_fiel]; enables = new CheckBox[n_fiel]; radio_buttons = new RadioButton[n_fiel, 4]; groupButtons = new Panel[n_fiel]; for (int k = 0; k < n_fiel; ++k) { names[k] = new Label(); text_boxs[k] = new TextBox(); enables[k] = new CheckBox(); for (int t = 0; t < 4; t++) { radio_buttons[k, t] = new RadioButton(); } groupButtons[k] = new Panel(); } for (int i = 0; i < n_fiel; ++i) { b_pos += 30; int index = 0; names[i].Text = fields[i].get_name(); names[i].Left = a_pos[index++]; names[i].Top = b_pos; names[i].Name = fields[i].get_type(); text_boxs[i].Width = 120; text_boxs[i].Left = a_pos[index++]; text_boxs[i].Top = b_pos; enables[i].Text = "Нет"; enables[i].Left = a_pos[index++]; enables[i].Top = b_pos; enables[i].Width = 50; enables[i].Checked = true; groupButtons[i].Left = 300; groupButtons[i].Top = b_pos; groupButtons[i].Height = 30; groupButtons[i].Width = 400; radio_buttons[i, 0].Text = "="; radio_buttons[i, 0].Left = 10; radio_buttons[i, 0].Top = 0; radio_buttons[i, 0].Width = 50; radio_buttons[i, 1].Text = "!="; radio_buttons[i, 1].Left = 60; radio_buttons[i, 1].Top = 0; radio_buttons[i, 1].Width = 50; radio_buttons[i, 2].Left = 110; radio_buttons[i, 2].Top = 0; radio_buttons[i, 2].Width = 100; radio_buttons[i, 3].Left = 220; radio_buttons[i, 3].Top = 0; radio_buttons[i, 3].Width = 100; if (fields[i].get_type() == "string") { radio_buttons[i, 2].Text = "Содержит"; radio_buttons[i, 3].Text = "Не содержит"; } else if (fields[i].get_type() == "int") { radio_buttons[i, 2].Text = ">"; radio_buttons[i, 3].Text = "<"; } } for (int k = 0; k < n_fiel; ++k) { this.Controls.Add(names[k]); this.Controls.Add(text_boxs[k]); this.Controls.Add(enables[k]); for (int t = 0; t < 4; ++t) { groupButtons[k].Controls.Add(radio_buttons[k, t]); } this.Controls.Add(groupButtons[k]); } }
public Firm() { Field = FieldTypeCol.getValue(); }