120
dataGridView1.Columns[1].HeaderText = "Наименование средства";
dataGridView1.Columns[2].HeaderText = "Характеристика";
dataGridView1.Columns[3].HeaderText = "Дата регистрации";
dataGridView1.Columns[4].HeaderText = "Ремонт";
dataGridView1.Columns[5].HeaderText = "Код производителя";
dataGridView1.DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter;
string query = "DELETE FROM measuring_instrument" + " WHERE
id_measuring_instrument = @id_measuring_instrument and
name_measuring_instrument = @name_measuring_instrument and characteristic =
@characteristic and registration_date = @registration_date and
repair_and_maintenance = @repair_and_maintenance and id_manufacturer =
@id_manufacturer";
adapter.DeleteCommand = new MySqlCommand(query, connection);
MySqlParameterCollection pc;
MySqlParameter p;
pc = adapter.DeleteCommand.Parameters;
p = pc.Add("@id_measuring_instrument", MySqlDbType.Int32, 11,
"id_measuring_instrument");
p.SourceVersion = DataRowVersion.Current;
p = pc.Add("@name_measuring_instrument", MySqlDbType.VarChar, 85,
"name_measuring_instrument");
p.SourceVersion = DataRowVersion.Current;
p = pc.Add("@characteristic", MySqlDbType.VarChar, 45, "characteristic");
p.SourceVersion = DataRowVersion.Current;
p = pc.Add("@registration_date", MySqlDbType.Date, 10,
"registration_date"); // date
121
p.SourceVersion = DataRowVersion.Current;
p = pc.Add("@repair_and_maintenance", MySqlDbType.VarChar, 45,
"repair_and_maintenance");
p.SourceVersion = DataRowVersion.Current;
p = pc.Add("@id_manufacturer", MySqlDbType.Int32, 11,
"id_manufacturer");
p.SourceVersion = DataRowVersion.Current;
query = "INSERT INTO measuring_instrument (id_measuring_instrument,
name_measuring_instrument, characteristic,
registration_date,
repair_and_maintenance, id_manufacturer) VALUES (@id_measuring_instrument,
@name_measuring_instrument, @characteristic,
@registration_date,
@repair_and_maintenance, @id_manufacturer)";
adapter.InsertCommand = new MySqlCommand(query, connection);
pc = adapter.InsertCommand.Parameters;
pc.Add("@id_measuring_instrument",
MySqlDbType.Int32,
11,
"id_measuring_instrument");
pc.Add("@name_measuring_instrument",
"name_measuring_instrument");
MySqlDbType.VarChar,
85,
pc.Add("@characteristic", MySqlDbType.VarChar, 45, "characteristic");
pc.Add("@registration_date", MySqlDbType.Date, 10, "registration_date");
pc.Add("@repair_and_maintenance", MySqlDbType.VarChar, 45,
"repair_and_maintenance");
pc.Add("@id_manufacturer", MySqlDbType.Int32, 11, "id_manufacturer");
query = "UPDATE measuring_instrument SET id_measuring_instrument =
@id_measuring_instrument, name_measuring_instrument =
@name_measuring_instrument, characteristic = @characteristic, registration_date =
@registration_date, repair_and_maintenance = @repair_and_maintenance,
id_manufacturer = @id_manufacturer WHERE id_measuring_instrument =
@iid_measuring_instrument";
adapter.UpdateCommand = new MySqlCommand(query, connection);
122
pc = adapter.UpdateCommand.Parameters;
pc.Add("@id_measuring_instrument", MySqlDbType.Int32, 11,
"id_measuring_instrument");
p = pc.Add("@iid_measuring_instrument", MySqlDbType.Int32, 11,
"id_measuring_instrument");
p.SourceVersion = DataRowVersion.Original;
pc = adapter.UpdateCommand.Parameters;
pc.Add("@name_measuring_instrument", MySqlDbType.VarChar, 85,
"name_measuring_instrument");
p = pc.Add("@iname_measuring_instrument", MySqlDbType.VarChar, 85,
"name_measuring_instrument");
p.SourceVersion = DataRowVersion.Original;
pc = adapter.UpdateCommand.Parameters;
pc.Add("@characteristic", MySqlDbType.VarChar, 45, "characteristic");
p = pc.Add("@icharacteristic", MySqlDbType.VarChar, 45,
"characteristic");
p.SourceVersion = DataRowVersion.Original;
pc = adapter.UpdateCommand.Parameters;
pc.Add("@registration_date", MySqlDbType.Date, 10, "registration_date");
p = pc.Add("@iregistration_date", MySqlDbType.Date, 10,
"registration_date");
p.SourceVersion = DataRowVersion.Original;
pc = adapter.UpdateCommand.Parameters;
pc.Add("@repair_and_maintenance", MySqlDbType.VarChar, 45,
"repair_and_maintenance");
p = pc.Add("@irepair_and_maintenance", MySqlDbType.VarChar, 45,
"repair_and_maintenance");
p.SourceVersion = DataRowVersion.Original;
pc = adapter.UpdateCommand.Parameters;
pc.Add("@id_manufacturer", MySqlDbType.Int32, 11, "id_manufacturer");
123
p = pc.Add("@iid_manufacturer", MySqlDbType.Int32, 11,
"id_manufacturer");
p.SourceVersion = DataRowVersion.Original;
}
}
}
}
Справочник «Производитель»
using System;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Threading.Tasks;
usingMySql.Data.MySqlClient;
namespaceprog
{
public partial class forms_manufacturer : Form
{
DataSet ds;
DataTabledt;
MySqlDataAdapter adapter;
stringconnectionString = @"Data Source=.\\SQLEXPRESS;
server=localhost;
user=root; Initial Catalog=accounting_card; charset=utf8";
124
stringsql = "SELECT * FROM manufacturer";
publicforms_manufacturer()
{
InitializeComponent();
}
private void button3_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows != null)
{
foreach (DataGridViewRowi in dataGridView1.SelectedRows)
ds.Tables[0].Rows[i.Index].Delete();
}
}
private void button4_Click(object sender, EventArgs e)
{
// обновлениеновойстрокивDataTable
DataRow row = ds.Tables[0].NewRow();
ds.Tables[0].Rows.Add(row);
}
private void button2_Click(object sender, EventArgs e)
{
adapter.Update(ds.Tables[0]);
MessageBox.Show("Обновлениезавершено");
}
private void button1_Click(object sender, EventArgs e)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
ds = new DataSet();
125
dt = new DataTable();
adapter = new MySqlDataAdapter(sql, connection);
adapter.Fill(dt);
ds.Tables.Add(dt);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.TopLeftHeaderCell.Value = "X";
dataGridView1.Columns[0].HeaderText = "Код производителя";
dataGridView1.Columns[1].HeaderText = "Наименование производителя";
dataGridView1.DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter;
string query = "DELETE FROM manufacturer" + " WHERE id_manufacturer =
@id_manufacturer and name_manufacturer = @name_manufacturer";
adapter.DeleteCommand = new MySqlCommand(query, connection);
MySqlParameterCollection pc;
MySqlParameter p;
pc = adapter.DeleteCommand.Parameters;
p = pc.Add("@id_manufacturer", MySqlDbType.Int32, 11,
"id_manufacturer");
p.SourceVersion = DataRowVersion.Current;
p = pc.Add("@name_manufacturer", MySqlDbType.VarChar, 45,
"name_manufacturer");
p.SourceVersion = DataRowVersion.Current;
query = "INSERT INTO manufacturer (id_manufacturer,
name_manufacturer)
VALUES (@id_manufacturer, @name_manufacturer)";
adapter.InsertCommand = new MySqlCommand(query, connection);
pc = adapter.InsertCommand.Parameters;
pc.Add("@id_manufacturer", MySqlDbType.Int32, 11, "id_manufacturer");
pc.Add("@name_manufacturer", MySqlDbType.VarChar, 45, "name_manufacturer");
126
query = "UPDATE manufacturer SET id_manufacturer = @id_manufacturer,
name_manufacturer = @name_manufacturer WHERE id_manufacturer =
@iid_manufacturer";
adapter.UpdateCommand = new MySqlCommand(query, connection);
pc = adapter.UpdateCommand.Parameters;
pc.Add("@id_manufacturer", MySqlDbType.Int32, 11, "id_manufacturer");
p = pc.Add("@iid_manufacturer", MySqlDbType.Int32, 11,
"id_manufacturer");
p.SourceVersion = DataRowVersion.Original;
pc = adapter.UpdateCommand.Parameters;
pc.Add("@name_manufacturer", MySqlDbType.VarChar, 45, "name_manufacturer");
p = pc.Add("@iname_manufacturer", MySqlDbType.VarChar, 45,
"name_manufacturer");
p.SourceVersion = DataRowVersion.Original;
}
}
}
}
Расчетный модуль «Поиск карточки учета»
using System;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Threading.Tasks;
127
usingMySql.Data.MySqlClient;
namespaceprog
{
public partial class forms info2 : Form
{
DataSetds; // DataSet - набор данных, включая таблицы,
содержащие,
упорядочивающие и ограничивающие данные, а также связи между таблицами.
DataTabledt; // DataTable - определяет значительное количество членов, многие
из которых совпадают по именам и функциям с аналогичными членами DataSet.
MySqlDataAdapteradapter; // MySqlDataAdapter - выступает в качестве моста
между DataSet и SQL Server для извлечения и сохранения данных.
// connectionString - строка, которая содержит информацию, необходимую
ODBC драйверу/OLE DB провайдеру для подключения к источнику данных.
stringconnectionString = @"Data Source=.\\SQLEXPRESS;
server=localhost;
user=root; Initial Catalog=accounting_card; charset=utf8";
// sql - запрос
string s = "SELECT accounting_card.id_accounting_card, accounting_card.date,
accounting_card.id_division, accounting_card.id_meaduring_instrumen,
accounting_card.id_employee,
accounting_card.in_operation,
accounting_card.in_storage,
accounting_card.id_stock,
accounting_card.calibration_frequency, accounting_card.number_of_calibration
FROM accounting_card ";
public forms info2()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{ }
128
private void forms info2_Load(object sender, EventArgs e)
{
string queryString1 = "SELECT id_accounting_card FROM accounting_card";
using (MySqlConnection connection =
newMySqlConnection(connectionString))
{
MySqlCommand cmd1 = new MySqlCommand(queryString1, connection);
DataTable tbl1 = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter(cmd1);
da.Fill(tbl1);
this.comboBox1.DataSource = tbl1;
this.comboBox1.DisplayMember =
"id_accounting_card";//
столбецдляотображения
//this.comboBox1.ValueMember = "id_client"; //столбецс id
//this.comboBox1.SelectedIndex = -1;
}
}
private void button1_Click_1(object sender, EventArgs e)
{
stringsql = null;
string l = comboBox1.Text;
string q = "WHERE (((accounting_card.id_accounting_card)= '" + l + "'))";
sql = s + q;
// считываем данные из базы данных
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
129
ds = new DataSet();
dt = new DataTable();
adapter = new MySqlDataAdapter(sql, connection);
adapter.Fill(dt);
ds.Tables.Add(dt);
dataGridView1.DataSource = ds.Tables[0];
// вводим заголовки ячеек
dataGridView1.TopLeftHeaderCell.Value = "X";
dataGridView1.Columns[0].HeaderText = "Код";
dataGridView1.Columns[1].HeaderText = "Дата";
dataGridView1.Columns[2].HeaderText = "Отдел";
dataGridView1.Columns[3].HeaderText = "Устройство";
dataGridView1.Columns[4].HeaderText = "Сотрудник";
dataGridView1.Columns[5].HeaderText = "в эксплуатац.";
dataGridView1.Columns[6].HeaderText = "на проверке";
dataGridView1.Columns[7].HeaderText = "Склад";
dataGridView1.Columns[8].HeaderText = "Периодичность";
dataGridView1.Columns[9].HeaderText = "Калибровок";
// выравниваем названия столбцов по центру
dataGridView1.DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter;
}
}
}}