Дипломная работа: Автоматизация регистрации и обработки заявок на комплектующие для ПК в ООО «Tatincom Computers»

Скачать

Заказать новую работу

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
121
dGV8.DataSource = f1.GetTable("select * from post", connectionString2);
dGV8.AutoResizeColumns(DGVAutoSizeColumnsMode.AllCellsExceptHeader);
dGV8.Columns[0].Width = 40;
dGV8.Columns[1].Width = 220;
dGV8.Columns[2].Width = 220;
dGV8.Columns[3].Width = 70;
dGV8.Columns[0].HeaderText = "ID";
dGV8.Columns[1].HeaderText = "Наименование поставщика";
dGV8.Columns[2].HeaderText = "Адрес";
dGV8.Columns[3].HeaderText = "Телефон";
}
public void adddata(string str)
{
MySqlConnection sqlConnection = new MySqlConnection(connectionString2);
sqlConnection.Open();
MySqlCommand myCommandZ;
bool good = false;
myCommandZ = new MySqlCommand(str, sqlConnection);
myCommandZ.Transaction =
sqlConnection.BeginTransaction(System.Data.IsolationLevel.Serializable);
try
{
myCommandZ.ExecuteNonQuery();
/*Подтверждаем транзакцию */
myCommandZ.Transaction.Commit();
good = true;
}
catch (Exception ex)
{
/*Отклоняем транзакцию */
myCommandZ.Transaction.Rollback();
MessageBox.Show("Запрос вызывает следующую ошибку: " + ex.Message,
"Ошибка", MessageBoxBTNs.OK, MessageBoxIcon.Error);
}
finally
{
if (sqlConnection != null && sqlConnection.State !=
ConnectionState.Closed && good)
{
LoadData();
}
}
}
public void getcombo()
{
string myQ = String.Format("SELECT idpr, proizv FROM proizv");
FAvtoriz f1 = new FAvtoriz();
DataTable myD = f1.GetTable(myQ, connectionString2);
comboBox2.DataSource = myD;
comboBox2.DisplayMember = "proizv";
comboBox2.ValueMember = "idpr";
string myQ2 = String.Format("SELECT ide, edizm FROM edizm");
FAvtoriz f12 = new FAvtoriz();
DataTable myD2 = f12.GetTable(myQ2, connectionString2);
comboBox1.DataSource = myD2;
comboBox1.DisplayMember = "edizm";
comboBox1.ValueMember = "ide";
122
}
private void BTN33_Click(object sender, EventArgs e)
{
pnlZ12.Visible = true;
i = 0;
}
private void BTN9_Click(object sender, EventArgs e)
{
switch (i)
{
case 0:
adddata("insert into kat (kat) values ('" + textBox1.Text + "')");
break;
case 1:
adddata("update kat set kat='" + textBox1.Text + "' where idkat=" +
dGV3.CurrentRow.Cells[0].Value.ToString());
break;
}
pnlZ12.Visible = false;
textBox1.Text = "";
}
private void BTN32_Click(object sender, EventArgs e)
{
i = 1;
pnlZ12.Visible = true;
textBox1.Text = dGV3.CurrentRow.Cells[1].Value.ToString();
}
private void BTN31_Click(object sender, EventArgs e)
{
adddata("delete kat where idkat=" +
dGV3.CurrentRow.Cells[0].Value.ToString());
}
private void BTN8_Click(object sender, EventArgs e)
{
pnlZ12.Visible = false;
textBox1.Text = "";
}
private void dGV3_CellClick(object sender, DGVCellEventArgs e)
{
FAvtoriz f1 = new FAvtoriz();
dGV4.DataSource = f1.GetTable("select idko,nazv,cena, kompl.idpr, proizv,
kompl.ide, edizm from kompl left join proizv on kompl.idpr=proizv.idpr left join edizm on
kompl.ide=edizm.ide where idkat=" + dGV3.CurrentRow.Cells[0].Value.ToString(),
connectionString2);
dGV4.AutoResizeColumns(DGVAutoSizeColumnsMode.AllCellsExceptHeader);
dGV4.Columns[0].Width = 40;
dGV4.Columns[1].Width = 220;
dGV4.Columns[2].Width = 120;
dGV4.Columns[3].Width = 40;
dGV4.Columns[4].Width = 120;
dGV4.Columns[5].Width = 40;
dGV4.Columns[6].Width = 120;
123
dGV4.Columns[3].Visible = false;
dGV4.Columns[5].Visible = false;
dGV4.Columns[0].HeaderText = "ID";
dGV4.Columns[1].HeaderText = "Наименование услуги";
dGV4.Columns[2].HeaderText = "Стоимость";
dGV4.Columns[3].HeaderText = "ID";
dGV4.Columns[4].HeaderText = "Производитель";
dGV4.Columns[5].HeaderText = "ID";
dGV4.Columns[6].HeaderText = "Единица измерения";
}
private void dGV3_CellContentClick(object sender, DGVCellEventArgs e)
{
}
private void BTN5_Click(object sender, EventArgs e)
{
pnlZ14.Visible = true;
i = 0;
getcombo();
}
private void BTN4_Click(object sender, EventArgs e)
{
i = 1;
pnlZ12.Visible = true;
textBox8.Text = dGV4.CurrentRow.Cells[1].Value.ToString();
}
private void BTN2_Click(object sender, EventArgs e)
{
adddata("delete kompl where idko=" +
dGV4.CurrentRow.Cells[0].Value.ToString());
}
private void BTN7_Click(object sender, EventArgs e)
{
pnlZ20.Visible = true;
i = 0;
}
private void BTN6_Click(object sender, EventArgs e)
{
i = 1;
pnlZ20.Visible = true;
textBox7.Text = dGV6.CurrentRow.Cells[1].Value.ToString();
}
private void BTN1_Click(object sender, EventArgs e)
{
adddata("delete edizm where ide=" +
dGV6.CurrentRow.Cells[0].Value.ToString());
}
private void BTN35_Click(object sender, EventArgs e)
{
switch (i)
{
case 0:
adddata("insert into edizm (edizm) values ('" + textBox7.Text +
"')");
break;
case 1:
124
adddata("update edizm set edizm='" + textBox7.Text + "' where ide="
+ dGV6.CurrentRow.Cells[0].Value.ToString());
break;
}
pnlZ20.Visible = false;
textBox7.Text = "";
}
private void BTN11_Click(object sender, EventArgs e)
{
switch (i)
{
case 0:
adddata("insert into kompl (nazv,cena,idpr,ide,idkat) values ('" +
textBox8.Text +
"'," + textBox6.Text + "," + comboBox2.SelectedValue.ToString() +
"," + comboBox1.SelectedValue.ToString() + ","+
dGV3.CurrentRow.Cells[0].Value.ToString() + ")");
break;
case 1:
adddata("update kompl set nazv='" + textBox8.Text + "',cena=" +
textBox6.Text +
",idpr=" + comboBox2.SelectedValue.ToString() + ",ide=" +
comboBox1.SelectedValue.ToString() + " where idko=" +
dGV4.CurrentRow.Cells[0].Value.ToString());
break;
}
pnlZ14.Visible = false;
textBox8.Text = "";
textBox6.Text = "";
}
private void BTN10_Click(object sender, EventArgs e)
{
pnlZ14.Visible = false;
textBox8.Text = "";
textBox6.Text = "";
}
private void BTN34_Click(object sender, EventArgs e)
{
pnlZ20.Visible = false;
textBox7.Text = "";
}
private void BTN14_Click(object sender, EventArgs e)
{
pnlZ7.Visible = true;
i = 0;
}
private void BTN13_Click(object sender, EventArgs e)
{
i = 1;
pnlZ7.Visible = true;
textBox2.Text = dGV1.CurrentRow.Cells[1].Value.ToString();
}
private void BTN16_Click(object sender, EventArgs e)
{
switch (i)
{
125
case 0:
adddata("insert into proizv (proizv) values ('" + textBox2.Text +
"')");
break;
case 1:
adddata("update proizv set proizv='" + textBox2.Text + "' where
idpr=" + dGV1.CurrentRow.Cells[0].Value.ToString());
break;
}
pnlZ7.Visible = false;
textBox2.Text = "";
}
private void BTN15_Click(object sender, EventArgs e)
{
pnlZ7.Visible = false;
textBox2.Text = "";
}
private void sprav_Shown(object sender, EventArgs e)
{
LoadData();
}
private void BTN22_Click(object sender, EventArgs e)
{
adddata("delete post where idp=" +
dGV8.CurrentRow.Cells[0].Value.ToString());
}
private void BTN24_Click(object sender, EventArgs e)
{
pnlZ24.Visible = true;
i = 0;
}
private void BTN23_Click(object sender, EventArgs e)
{
pnlZ24.Visible = true;
i = 1;
textBox9.Text = dGV8.CurrentRow.Cells[1].Value.ToString();
textBox11.Text = dGV8.CurrentRow.Cells[2].Value.ToString();
textBox10.Text = dGV8.CurrentRow.Cells[3].Value.ToString();
}
private void BTN18_Click(object sender, EventArgs e)
{
switch (i)
{
case 0:
adddata("insert into post (post,adres,tel) values ('" + textBox9.Text
+ "','" + textBox11.Text + "','" + textBox10.Text + "')");
break;
case 1:
adddata("update post set post='" + textBox9.Text + "', adres='" +
textBox11.Text + "', tel='" + textBox10.Text + "' where idp=" +
dGV8.CurrentRow.Cells[0].Value.ToString());
break;
}
pnlZ24.Visible = false;
textBox9.Text = "";
Источник: https://baza.diplomsite.ru/previewfile/2207

Смотрите также:

Изложение содержания дела, по которому приняты судебные постановления
_-___-~1
_1-тема-СтрМетал
_10_Эмиль Золя для эл версии