private void button_delete1_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows != null)
{
int tt = Convert.ToInt32(dataGridView1.SelectedCells[0].RowIndex);
Diploma.Text_blocks f = new Diploma.Text_blocks();
int id = Convert.ToInt32(dataGridView1[0, tt].Value);
f.Delete_text_blocks(id, Program.connection_str);
MessageBox.Show("Удаление успешно!");
Load_text_blocks();
}
}
private void button_update1_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows != null)
{
/*По левому краю
* По центру
* По правому краю
* По ширине*/
add_text_blocks i = new add_text_blocks();
i.comboBox1.Items.Add("По левому краю");
i.comboBox1.Items.Add("По центру");
i.comboBox1.Items.Add("По правому краю");
i.comboBox1.Items.Add("По ширине");
int tt = Convert.ToInt32(dataGridView1.SelectedCells[0].RowIndex);
Diploma.Text_blocks f = new Diploma.Text_blocks();
int id = Convert.ToInt32(dataGridView1[0, tt].Value);
f = f.Select_text_blocks_id(id, Program.connection_str);
i.textBox1.Text = f.Name_blocks;
i.textBox2.Text = f.Content;
i.numericUpDown1.Value = f.X;
i.numericUpDown2.Value = f.Y;
i.numericUpDown3.Value = f.Height;
i.numericUpDown4.Value = f.Width;
//i.comboBox1.Text = f.Alignment_text;
i.textBox3.Text = f.Font_type;
i.textBox4.Text = f.Mark_text;
i.textBox5.Text = f.Font_size.ToString();
for (int j = 0; j < i.comboBox1.Items.Count; j++)
{
if (i.comboBox1.Items[j].ToString() == f.Alignment_text)
{
i.comboBox1.SelectedIndex = j;
break;
}
}
if (i.ShowDialog() == DialogResult.OK)
{
f.Update_text_blocks(f.id, i.textBox1.Text, i.textBox2.Text, i.textBox3.Text, i.comboBox1.Text,
i.textBox4.Text, Convert.ToInt32(i.textBox5.Text), Convert.ToInt32(i.numericUpDown3.Value),
Convert.ToInt32(i.numericUpDown4.Value), Convert.ToInt32(i.numericUpDown1.Value),
Convert.ToInt32(i.numericUpDown2.Value), Program.connection_str);
MessageBox.Show("Редактирование успешно!");
}
Load_text_blocks();
}
}
public void Load_text_blocks()
{
dataGridView1.RowCount = 1;
dataGridView1[0, 0].Value = "";
dataGridView1[1, 0].Value = "";
Diploma.Text_blocks f = new Diploma.Text_blocks();
List <Diploma.Text_blocks> tb = f.Select_text_blocks(Program.connection_str, Program.Maquette_id);
if (tb.Count != 0)
{
dataGridView1.RowCount = tb.Count;
for (int i = 0; i < tb.Count; i++)
{
dataGridView1[0, i].Value = tb[i].id;
dataGridView1[1, i].Value = tb[i].Name_blocks;
}
}
}
public void add_text_blocks()
{
add_text_blocks f = new add_text_blocks();
f.comboBox1.Items.Add("По левому краю");
f.comboBox1.Items.Add("По центру");
f.comboBox1.Items.Add("По правому краю");
f.comboBox1.Items.Add("По ширине");
f.label6.Font = new Font("Tahoma", 14, FontStyle.Bold);
f.textBox3.Text = f.label6.Font.Name;
f.textBox4.Text = f.label6.Font.Style.ToString();
f.textBox5.Text = (Math.Round(f.label6.Font.Size)).ToString();
if (f.ShowDialog() == DialogResult.OK)
{
Diploma.Text_blocks t = new Diploma.Text_blocks();
t.Add_text_blocks(f.textBox1.Text, f.textBox2.Text, f.textBox3.Text, f.comboBox1.Text,
f.textBox4.Text, Convert.ToInt32(f.textBox5.Text), Convert.ToInt32(f.numericUpDown3.Value),
Convert.ToInt32(f.numericUpDown4.Value), Convert.ToInt32(f.numericUpDown1.Value),
Convert.ToInt32(f.numericUpDown2.Value), Program.Maquette_id, Program.connection_str);
MessageBox.Show("Успешно добавлен!");
}
Load_text_blocks();
}
