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

Скачать

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

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
111
adddata("insert into history (idz,idst,datast,ids) values (" + idz.ToString()
+ ","+ idst.ToString() + ",curdate(),"+Globals.ids.ToString()+" )");
}
public void sostskl()
{
adddata("delete from sostsk");
adddata("insert into sostsk (idko) select idko from kompl");
adddata(" update sostsk set kolvor = (select IFNULL(count(idko),0) from
zayavkadet where sostsk.idko =idko and idz in (select idz from zayavka where idst=3)) ");
adddata(" update sostsk set kolvop = (select ifnull(sum(kolvo), 0) from
pokompl where sostsk.idko =idko)");
adddata(" update sostsk set itog = kolvop-kolvor");
}
public static class Globals
{
public static string str_connect { get; set; }
public static int role { get; set; }
public static int ids { get; set; }
public static int idko { get; set; }
public static string kompl { get; set; }
}
private void BTN1_Click(object sender, EventArgs e)
{
String fios="";
int role=0;
if (login.Text != "" & pass.Text != "")
{
connectionString = String.Format(@"Server={0};DATABASE=tatincomDb;UID
=root; Password =", textBox1.Text);
Globals.str_connect = connectionString;
MySqlConnection sqlConnection = new MySqlConnection(connectionString);
try
{
sqlConnection.Open();
Form2 newForm = new Form2();
MySqlCommand command = new MySqlCommand("SELECT ids,fio,idrole FROM
sotr where login ='" + login.Text + "' and pass=" + pass.Text, sqlConnection);
MySqlDataReader coRead = command.ExecuteReader();
while (coRead.Read())
{
fios = Convert.ToString(coRead["fio"]);
role = Convert.ToInt32(coRead["idrole"]);
Globals.role = role;
Globals.ids = Convert.ToInt32(coRead["ids"]);
}
coRead.Close();
if (String.Equals(fios, "") == true)
{
MessageBox.Show("Логин или пароль введен не верно", "Ошибка",
MessageBoxBTNs.OK, MessageBoxIcon.Error);
}
else
112
{
Form2 f2 = new Form2();
f2.Strole2.Text = Convert.ToString(role);
f2.fio2.Text = fios;
FAvtoriz.ActiveForm.Hide();
f2.Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(),
MessageBoxBTNs.OK, MessageBoxIcon.Error);
sqlConnection.Close();
}
}
else
MessageBox.Show("Введите логин и пароль!", "Ошибка", MessageBoxBTNs.OK,
MessageBoxIcon.Error);
}
}
}
Программный код Формы Заявки
namespace Zayavki
{
public partial class zayavka : Form
{
public int I;
public string connectionString2;
public zayavka()
{
InitializeComponent();
}
private void LoadData(int idst)
{
connectionString2 = FAvtoriz.Globals.str_connect;
FAvtoriz f1 = new FAvtoriz();
if (idst == 0)
{
dataGridView8.DataSource = f1.GetTable(“select idz, nazv, dataz,z.idst,
status ,z.ids, fio” +
“ from zayavka as z left join klient as k on z.idk=k.idk left join
status as st on z.idst=st.idst “ +
“ left join
112
ort as s on z.ids=s.ids “, connectionString2);
}
else {
dataGridView8.DataSource = f1.GetTable(“select idz, nazv, dataz,z.idst,
status ,z.ids, fio” +
“ from zayavka as z left join klient as k on z.idk=k.idk left join
status as st on z.idst=st.idst “ +
“ left join
112
ort as s on z.ids=s.ids where z.idst=2”,
connectionString2);
}
113
dataGridView8.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
dGV8.Columns[0].Width = 40;
dGV8.Columns[1].Width = 220;
dGV8.Columns[2].Width = 220;
dGV8.Columns[3].Width = 220;
dGV8.Columns[3].Visible = false;
dGV8.Columns[4].Width = 120;
dGV8.Columns[5].Width = 220;
dGV8.Columns[5].Visible = false;
dGV8.Columns[6].Width = 120;
dGV8.Columns[0].HeaderText = “№ заказа”;
dGV8.Columns[1].HeaderText = “Наименование клиента”;
dGV8.Columns[2].HeaderText = “Дата заявки”;
dGV8.Columns[3].HeaderText = “ИДС”;
dGV8.Columns[4].HeaderText = “Статус”;
dGV8.Columns[5].HeaderText = “ИДK”;
dGV8.Columns[6].HeaderText = “ФИО сотрудника”;
getcombo();
}
public void getcombo()
{
string myQ = String.Format(“SELECT idk, nazv FROM klient”);
FAvtoriz f1 = new FAvtoriz();
DataTable myD = f1.GetTable(myQ, connectionString2);
comboBox1.DataSource = myD;
comboBox1.DisplayMember = “nazv”;
comboBox1.ValueMember = “idk”;
}
public void adddata(string str)
{
MySqlConnection sqlConnection = new MySqlConnection(connectionString2);
sqlConnection.Open();
MySqlCommand myCommandZ;
myCommandZ = new MySqlCommand(str, sqlConnection);
myCommandZ.Transaction =
sqlConnection.BeginTransaction(System.Data.IsolationLevel.Serializable);
try
{
myCommandZ.ExecuteNonQuery();
myCommandZ.Transaction.Commit();
}
catch (Exception ex)
{
myCommandZ.Transaction.Rollback();
MessageBox.Show(“Запрос вызывает следующую ошибку: “ + ex.Message,
“Ошибка”, MessageBoxBTNs.OK, MessageBoxIcon.Error);
}
finally
{
}
}
private void BTN3_Click(object sender, EventArgs e)
{
pnlZ24.Visible = true;
I = 0;
FAvtoriz f1 = new FAvtoriz();
dGV1.DataSource = f1.GetTable(“select idzz,nazv,cena, kompl.idpr, proizv,
kompl.ide, edizm,kolvo, itog from zayavkadet as z left join kompl “
114
+ “on z.idko=kompl.idko left join proizv on kompl.idpr=proizv.idpr left
join edizm on kompl.ide=edizm.ide “ +
“ left join sostsk on kompl.idko=sostsk.idko where idz=” +
dGV8.CurrentRow.Cells[0].Value.ToString(), connectionString2);
dGV1.AutoResizeColumns(DGVAutoSizeColumnsMode.AllCellsExceptHeader);
dGV1.Columns[0].Width = 40;
dGV1.Columns[1].Width = 220;
dGV1.Columns[2].Width = 120;
dGV1.Columns[3].Width = 40;
dGV1.Columns[3].Visible = false;
dGV1.Columns[4].Width = 120;
dGV1.Columns[5].Width = 40;
dGV1.Columns[5].Visible = false;
dGV1.Columns[6].Width = 120;
dGV1.Columns[7].Width = 80;
dGV1.Columns[8].Width = 80;
dGV1.Columns[0].HeaderText = “ID”;
dGV1.Columns[1].HeaderText = “Наименование комплектующего”;
dGV1.Columns[2].HeaderText = “Стоимость”;
dGV1.Columns[3].HeaderText = “ID”;
dGV1.Columns[4].HeaderText = “Производитель”;
dGV1.Columns[5].HeaderText = “ID”;
dGV1.Columns[6].HeaderText = “Единица измерения”;
dGV1.Columns[7].HeaderText = “Количество”;
dGV1.Columns[8].HeaderText = “Количество на складе”;
if (FAvtoriz.Globals.role == 1)
{
pnlZ7.Visible = false;
}
}
private void BTN31_Click(object sender, EventArgs e)
{
adddata(“delete from zayavka where idz=” +
dGV8.CurrentRow.Cells[0].Value.ToString());
LoadData(0);
}
private void BTN33_Click(object sender, EventArgs e)
{
adddata(“insert into zayavka (idk,dataz,ids,idst,datast) values (“ +
comboBox1.SelectedValue.ToString() +
“,curdate(),” + FAvtoriz.Globals.ids.ToString() + “,1,curdate() )”);
MySqlConnection sqlConnection = new MySqlConnection(connectionString2);
sqlConnection.Open();
Form2 newForm = new Form2();
MySqlCommand command = new MySqlCommand(“SELECT max(idz) as m FROM
zayavka “, sqlConnection);
MySqlDataReader coRead = command.ExecuteReader();
while (coRead.Read())
{
FAvtoriz f1 = new FAvtoriz();
f1.hadd(Convert.ToInt32(coRead[“m”]), 1);
}
coRead.Close();
LoadData(0);
115
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void zayavka_Shown(object sender, EventArgs e)
{
if (FAvtoriz.Globals.role == 1)
{LoadData(2);
pnlZ3.Visible = false;
pnlZ5.Visible = false;
}
else {
LoadData(0);
pnlZ4.Visible = false;
}
}
private void textBox1_DoubleClick(object sender, EventArgs e)
{
vkompl newForm = new vkompl();
newForm.Show();
}
private void zayavka_Activated(object sender, EventArgs e)
{
if (String.Equals(FAvtoriz.Globals.kompl, “”) == false)
{
textBox1.Text = FAvtoriz.Globals.kompl;
textBox2.Text = FAvtoriz.Globals.idko.ToString();
}
}
private void BTN2_Click(object sender, EventArgs e)
{
adddata(“insert into zayavkadet (idz,idko,kolvo) values (“ +
dGV8.CurrentRow.Cells[0].Value.ToString() + “,” + textBox2.Text + “,” + textBox9.Text + “
)”);
FAvtoriz f1 = new FAvtoriz();
f1.sostskl();
dGV1.DataSource = f1.GetTable(“select idzz,nazv,cena, kompl.idpr, proizv,
kompl.ide, edizm,kolvo, itog from zayavkadet as z left join kompl “
+ “on z.idko=kompl.idko left join proizv on kompl.idpr=proizv.idpr left
join edizm on kompl.ide=edizm.ide “+
“ left join sostsk on kompl.idko=sostsk.idko where idz=” +
dGV8.CurrentRow.Cells[0].Value.ToString(), connectionString2);
dGV1.AutoResizeColumns(DGVAutoSizeColumnsMode.AllCellsExceptHeader);
dGV1.Columns[0].Width = 40;
dGV1.Columns[1].Width = 220;
dGV1.Columns[2].Width = 120;
dGV1.Columns[3].Width = 40;
dGV1.Columns[3].Visible = false;
dGV1.Columns[4].Width = 120;
dGV1.Columns[5].Width = 40;
dGV1.Columns[5].Visible = false;
dGV1.Columns[6].Width = 120;
dGV1.Columns[7].Width = 80;
dGV1.Columns[8].Width = 80;
dGV1.Columns[0].HeaderText = “ID”;
dGV1.Columns[1].HeaderText = “Наименование комплектующего”;
Источник: https://baza.diplomsite.ru/previewfile/2207

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

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