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