public FormAboutCurrentRepair(ClassDB db, string surnameEmployee, string date)
{
InitializeComponent();
this.db = db;
this.surnameEmployee = surnameEmployee;
this.date = date;
dgvInfoCurrentRepairs.ColumnCount = 11;
dgvInfoCurrentRepairs.Columns[0].HeaderCell.Value = "ID работы";
dgvInfoCurrentRepairs.Columns[1].HeaderCell.Value = "Ремонтная работа";
dgvInfoCurrentRepairs.Columns[2].HeaderCell.Value = "Фамилия клиента";
dgvInfoCurrentRepairs.Columns[3].HeaderCell.Value = "Марка автомобиля";
dgvInfoCurrentRepairs.Columns[4].HeaderCell.Value = "Модель автомобиля";
dgvInfoCurrentRepairs.Columns[5].HeaderCell.Value = "Фамилия сотрудника";
dgvInfoCurrentRepairs.Columns[6].HeaderCell.Value = "Должность сотрудника";
dgvInfoCurrentRepairs.Columns[7].HeaderCell.Value = "Дата";
dgvInfoCurrentRepairs.Columns[8].HeaderCell.Value = "Время начала";
dgvInfoCurrentRepairs.Columns[9].HeaderCell.Value = "Время окончания";
dgvInfoCurrentRepairs.Columns[10].HeaderCell.Value = "Статус";
db.ShowInfoCurrentRepair(surnameEmployee, date, dgvInfoCurrentRepairs);
if (dgvInfoCurrentRepairs.Rows.Count == 0)
{
toolStripBtDeleteRepair.Enabled = false;
}
}
public FormWorkHours(ClassDB db)
{
InitializeComponent();
this.db = db;
RefreshTable();
}
private void btEnter_Click(object sender, EventArgs e)
{
if (tbIP.Text == "" || tbLogin.Text == "" || tbLoginDB.Text == "" || tbPass.Text == "" || tbPassDB.Text == "" || tbPort.Text == "")
{
MessageBox.Show("Неверно указаны данные для подключения к БД", "Ошибка");
error = true;
}
else
{
db = new ClassDB(tbIP.Text, tbPort.Text, tbLoginDB.Text, tbPassDB.Text);
try
{
MySqlConnection testConnect = db.conn;
testConnect.Open();
testConnect.Close();
error = false;
}
catch
{
MessageBox.Show("Неверно указаны данные для подключения к БД", "Ошибка");
error = true;
}
if (!error)
{
Hide();
switch (tbLogin.Text)
{
case "admin":
if (tbPass.Text == "admin")
{
statusLogin = ADMIN;
FormMain fmAdmin = new FormMain(db, statusLogin);
fmAdmin.ShowDialog();
}
else
{
MessageBox.Show("Введены неверные данные", "Ошибка");
}
break;
case "user":
statusLogin = USER;
FormMain fmUser = new FormMain(db, statusLogin);
fmUser.ShowDialog();
break;
default:
MessageBox.Show("Введены неверные данные");
break;
}
}
}
}
public FormPicWorkHours(ClassDB db)
{
InitializeComponent();
this.db = db;
dgvWorkHours.ColumnCount = 4;
dgvWorkHours.Columns[0].HeaderCell.Value = "ID Смены";
dgvWorkHours.Columns[1].HeaderCell.Value = "Дата";
dgvWorkHours.Columns[2].HeaderCell.Value = "Фамилия сотрудника";
dgvWorkHours.Columns[3].HeaderCell.Value = "Должность";
db.SearchWorkHoursForPic(dgvWorkHours);
}
public FormAboutCar(ClassDB db, string curRow)
{
InitializeComponent();
this.db = db;
dgvAboutCar.ColumnCount = 3;
dgvAboutCar.Columns[0].HeaderCell.Value = "ID клиента";
dgvAboutCar.Columns[1].HeaderCell.Value = "Модель";
dgvAboutCar.Columns[2].HeaderCell.Value = "Марка";
db.ShowInfoCar(dgvAboutCar, curRow);
}
public FormActions(ClassDB db)
{
InitializeComponent();
this.db = db;
dgvActions.ColumnCount = 3;
dgvActions.Columns[0].HeaderCell.Value = "ID";
dgvActions.Columns[1].HeaderCell.Value = "Название";
dgvActions.Columns[2].HeaderCell.Value = "Текст";
db.LoadTables("actions", dgvActions);
}
public FormPicClient(ClassDB db)
{
InitializeComponent();
this.db = db;
dataGridView1.ColumnCount = 6;
dataGridView1.Columns[0].HeaderCell.Value = "ID Клиента";
dataGridView1.Columns[1].HeaderCell.Value = "Фамилия";
dataGridView1.Columns[2].HeaderCell.Value = "Имя";
dataGridView1.Columns[3].HeaderCell.Value = "Отчество";
dataGridView1.Columns[4].HeaderCell.Value = "Мобильный телефон";
dataGridView1.Columns[5].HeaderCell.Value = "Номер СТС машины";
db.LoadTables("clients", dataGridView1);
}
public FormCars(ClassDB db)
{
InitializeComponent();
this.db = db;
dgvCars.ColumnCount = 5;
dgvCars.Columns[0].HeaderCell.Value = "СТС";
dgvCars.Columns[1].HeaderCell.Value = "Марка";
dgvCars.Columns[2].HeaderCell.Value = "Модель";
dgvCars.Columns[3].HeaderCell.Value = "Год выпуска";
dgvCars.Columns[4].HeaderCell.Value = "Дата последнего ТО";
db.LoadTables("cars", dgvCars);
}
public FormRepairs(ClassDB db)
{
InitializeComponent();
this.db = db;
dataGridView1.ColumnCount = 5;
dataGridView1.Columns[0].HeaderCell.Value = "ID работы";
dataGridView1.Columns[1].HeaderCell.Value = "Наименование";
dataGridView1.Columns[2].HeaderCell.Value = "Категория";
dataGridView1.Columns[3].HeaderCell.Value = "Цена";
dataGridView1.Columns[4].HeaderCell.Value = "Должность";
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
db.LoadTables("repairs", dataGridView1);
}
public FormAddClient(ClassDB db, string idClient, string surname, string name,
string patronimyc, string phone, string numSTS)
{
InitializeComponent();
edit = true;
this.db = db;
db.SearchSTSCars(cbNumSTS);
this.idClient = idClient;
tbSurname.Text = surname;
tbName.Text = name;
tbPatronimyc.Text = patronimyc;
tbPhone.Text = phone;
cbNumSTS.Text = numSTS;
}
public FormPicExtensionClients(ClassDB db)
{
this.db = db;
InitializeComponent();
dgvExtentionWorks.ColumnCount = 7;
dgvExtentionWorks.Columns[0].HeaderCell.Value = "ID клиента";
dgvExtentionWorks.Columns[1].HeaderCell.Value = "Фамилия";
dgvExtentionWorks.Columns[2].HeaderCell.Value = "Имя";
dgvExtentionWorks.Columns[3].HeaderCell.Value = "Номер телефона";
dgvExtentionWorks.Columns[4].HeaderCell.Value = "Марка";
dgvExtentionWorks.Columns[5].HeaderCell.Value = "Модель";
dgvExtentionWorks.Columns[6].HeaderCell.Value = "Количество дней";
db.SearchExtentionWorksForPic(dgvExtentionWorks);
}
public FormRequests(ClassDB db, TabControl tabControl)
{
InitializeComponent();
this.db = db;
this.tabControl = tabControl;
dgvRequests.ColumnCount = 5;
dgvRequests.Columns[0].HeaderCell.Value = "ID заявки";
dgvRequests.Columns[1].HeaderCell.Value = "Категория";
dgvRequests.Columns[2].HeaderCell.Value = "ID клиента";
dgvRequests.Columns[3].HeaderCell.Value = "Описание";
dgvRequests.Columns[4].HeaderCell.Value = "Статус обработки";
db.LoadTables("requests", dgvRequests);
}
public FormEmployees(ClassDB db)
{
InitializeComponent();
this.db = db;
dgvEmployees.ColumnCount = 7;
dgvEmployees.Columns[0].HeaderCell.Value = "ID сотрудника";
dgvEmployees.Columns[1].HeaderCell.Value = "Фамилия";
dgvEmployees.Columns[2].HeaderCell.Value = "Имя";
dgvEmployees.Columns[3].HeaderCell.Value = "Отчество";
dgvEmployees.Columns[4].HeaderCell.Value = "Мобильный телефон";
dgvEmployees.Columns[5].HeaderCell.Value = "Должность";
dgvEmployees.Columns[6].HeaderCell.Value = "Соредняя оценка";
db.LoadTables("employees", dgvEmployees);
}
public UserControlClientsToday(ClassDB db, TabPage tabPage)
{
InitializeComponent();
this.db = db;
this.tabPage = tabPage;
timeStartRepair = DateTime.Now.ToString("HH:mm:ss");
toolStripBtFinishRepair.Enabled = false;
toolStripBtDeleteRepair.Enabled = false;
for (int i = DateTime.Now.Year; i >= 1970; i--)
{
cbYearCreated.Items.Add(i);
}
}
public FormMain(ClassDB db, int statusLogin)
{
InitializeComponent();
toolStripBtDeleteClient.Enabled = false;
toolStripBtSave.Enabled = false;
this.db = db;
if (statusLogin == USER)
{
Text = "Система управления станцией технического обслуживания (Вы вошли как Штатный сотрудник)";
списокСотрудниковToolStripMenuItem.Enabled = false;
списокАкцийToolStripMenuItem.Enabled = false;
расписаниеToolStripMenuItem.Enabled = false;
}
if (statusLogin == ADMIN)
{
Text = "Система управления станцией технического обслуживания (Вы вошли как Администратор)";
}
}
//Для отложенных клиентов
public UserControlClientsToday(ClassDB db, TabPage tabPage, List <int> idExtentionRepairs, int quantityDaysForExtensionWorks)
{
InitializeComponent();
this.db = db;
this.tabPage = tabPage;
timeStartRepair = DateTime.Now.ToString("HH:mm:ss");
toolStripBtFinishRepair.Enabled = false;
toolStripBtDeleteRepair.Enabled = false;
for (int i = 0; i < idExtentionRepairs.Count; i++)
{
db.InfoExtensionRepairs(idExtentionRepairs[i], idCurrentRepairs, clbRepairs,
lbEmployeesRepairs, lbRepairsCosts);
}
int totalCost = 0;
for (int i = 0; i < lbRepairsCosts.Items.Count; i++)
{
totalCost += Convert.ToInt32(lbRepairsCosts.Items[i].ToString());
}
lbRepairsTotalCost.Text = "Итоговая\nстоимость:\n" + totalCost + " рублей";
for (int i = DateTime.Now.Year; i >= 1970; i--)
{
cbYearCreated.Items.Add(i);
}
toolStripProgressBarStatusRepairs.Maximum = clbRepairs.Items.Count;
toolStripProgressBarStatusRepairs.Value = clbRepairs.CheckedItems.Count;
toolStripStatusLabelInfoClient.Text = "Всего дней работы: " + quantityDaysForExtensionWorks;
}
public FormAddClient(ClassDB db)
{
InitializeComponent();
this.db = db;
db.SearchSTSCars(cbNumSTS);
}