Разработка БД для ИС «Пожарная часть»

AutoSizeMode = DataGridViewAutoSizeColumnMode. Fill; columnAddress. DisplayStyle = DataGridViewComboBoxDisplayStyle. Nothing; dataGridView1.Columns.Insert (0, columnAddress); // видобъекта DataGridViewComboBoxColumn columnObjectType = new DataGridViewComboBoxColumn { DataPropertyName = «id_objecttype», HeaderText = «Видобъекта», Width = 150, DataSource = bindingSourceObjectType, DisplayMember = «name», ValueMember = «id» }; columnObjectType. DisplayStyle = DataGridViewComboBoxDisplayStyle. Nothing; dataGridView1.Columns.Insert (1, columnObjectType); foreach (DataGridViewColumn col in dataGridView1. Columns) col.HeaderCell.Style.Alignment = DataGridViewContentAlignment. MiddleCenter; //conn.Close (); } catch (MySql.Data.MySqlClient.MySqlException ex) { MessageBox. Show («Текстошибки: „+ ex. Message); } } private void toolStripButton1_Click (object sender, EventArgs e) { MySqlCommandBuilder cmb = new MySqlCommandBuilder (dataAdapter); dataAdapter. Update (ds, „objects“); dataGridView1. DataSource = ds; } private void toolStripButton2_Click (object sender, EventArgs e) { MySqlCommandBuilder cmb = new MySqlCommandBuilder (dataAdapter); dataGridView1.Rows.RemoveAt (dataGridView1.CurrentRow.Index);dataAdapter.Update (ds, „objects“); } }}using System;using System.Collections.Generic;using System. ComponentModel;using System. Data;using System. Drawing;using System. Linq;using System. Text;using System.Threading.Tasks;using System.Windows.Forms;using System. Configuration;using MySql.Data.MySqlClient;namespace fire{ public partial class prich: Form { MySqlDataAdapter dataAdapter; DataSet ds; public prich () { InitializeComponent (); } private void prich_Load (object sender, EventArgs e) { MySqlConnection conn; string myConnectionString = „server=“ + ConfigurationManager. AppSettings[“ mysql_server» ] + «;uid=» + ConfigurationManager. AppSettings[" mysql_user" ] + «;pwd=» + ConfigurationManager. AppSettings[" mysql_password" ] + «;database=» + ConfigurationManager. AppSettings[" mysql_database" ] + «;»; try { conn = new MySqlConnection (); conn. ConnectionString = myConnectionString; conn. Open (); MySqlCommand sqlCom = new MySqlCommand («SELECT * FROM reasons», conn); sqlCom. ExecuteNonQuery (); dataAdapter = new MySqlDataAdapter (sqlCom); ds = new DataSet (); dataAdapter. Fill (ds, «mytable»); dataGridView1. DataSource = ds; dataGridView1. DataMember = «mytable»; dataGridView1. Columns[" id" ]. Visible = false; dataGridView1. Columns[" name" ]. HeaderText = «Причина»; dataGridView1. Columns[" name" ]. AutoSizeMode = DataGridViewAutoSizeColumnMode. Fill; //conn.Close (); } catch (MySql.Data.MySqlClient.MySqlException ex) { MessageBox. Show («Текстошибки: «+ ex. Message); } } private void toolStripButton1_Click (object sender, EventArgs e) { MySqlCommandBuilder cmb = new MySqlCommandBuilder (dataAdapter); dataAdapter. Update (ds, «mytable»); dataGridView1. DataSource = ds; } private void toolStripButton2_Click (object sender, EventArgs e) { MySqlCommandBuilder cmb = new MySqlCommandBuilder (dataAdapter); dataGridView1.Rows.RemoveAt (dataGridView1.CurrentRow.Index);dataAdapter.Update (ds, «mytable»); } }}using System;using System.Collections.Generic;using System. ComponentModel;using System. Data;using System. Drawing;using System. Linq;using System. Text;using System.Threading.Tasks;using System.Windows.Forms;using System. Configuration;using MySql.Data.MySqlClient;namespace fire{ public partial class vidob: Form { MySqlDataAdapter dataAdapter; DataSet ds; public vidob () { InitializeComponent (); } private void vidob_Load (object sender, EventArgs e) { MySqlConnection conn; //myConnectionString = «server=192.

168.

4.201;uid=lana;" + // «pwd=123;database=mybase;»; string myConnectionString = «server=» + ConfigurationManager. AppSettings[" mysql_server" ] + «;uid=» + ConfigurationManager. AppSettings[" mysql_user" ] + «;pwd=» + ConfigurationManager. AppSettings[" mysql_password" ] + «;database=» + ConfigurationManager. AppSettings[" mysql_database" ] + «;»; try { conn = new MySqlConnection (); conn. ConnectionString = myConnectionString; conn. Open (); MySqlCommand sqlCom = new MySqlCommand («SELECT * FROM objecttypes», conn); sqlCom. ExecuteNonQuery (); dataAdapter = new MySqlDataAdapter (sqlCom); ds = new DataSet (); dataAdapter. Fill (ds, «objecttypes»); dataGridView1. DataSource = ds; dataGridView1. DataMember = «objecttypes»; dataGridView1. Columns[" id" ]. Visible = false; dataGridView1. Columns[" name" ]. HeaderText = «Видобъекта»; dataGridView1. Columns[" name" ]. AutoSizeMode = DataGridViewAutoSizeColumnMode. Fill; foreach (DataGridViewColumn col in dataGridView1. Columns) col.HeaderCell.Style.Alignment = DataGridViewContentAlignment. MiddleCenter; //conn.Close (); } catch (MySql.Data.MySqlClient.MySqlException ex) { MessageBox. Show («Текстошибки: „+ ex. Message); } } private void toolStripButton1_Click (object sender, EventArgs e) { MySqlCommandBuilder cmb = new MySqlCommandBuilder (dataAdapter); dataAdapter. Update (ds, „objecttypes“); dataGridView1. DataSource = ds; } private void toolStripButton2_Click (object sender, EventArgs e) { MySqlCommandBuilder cmb = new MySqlCommandBuilder (dataAdapter); dataGridView1.Rows.RemoveAt (dataGridView1.CurrentRow.Index);dataAdapter.Update (ds, „objecttypes“); } }}using System;using System.Collections.Generic;using System. ComponentModel;using System. Data;using System. Drawing;using System. Linq;using System. Text;using System.Threading.Tasks;using System.Windows.Forms;using System. Configuration;using MySql.Data.MySqlClient;using iTextSharp.text.pdf;using iTextSharp. text;using System. IO;namespace fire{ public partial class vis: Form { MySqlDataAdapter dataAdapter; DataSet ds; BindingSource bindingSource; public vis () { InitializeComponent (); } private void vis_Load (object sender, EventArgs e) { MySqlConnection conn; string myConnectionString = „server=“ + ConfigurationManager. AppSettings[“ mysql_server» ] + «;uid=» + ConfigurationManager. AppSettings[" mysql_user" ] + «;pwd=» + ConfigurationManager. AppSettings[" mysql_password" ] + «;database=» + ConfigurationManager. AppSettings[" mysql_database" ] + «;»; try { conn = new MySqlConnection (); conn. ConnectionString = myConnectionString; conn. Open (); // причины MySqlDataAdapter dataAdapterReason = new MySqlDataAdapter («SELECT id, name FROM reasons», conn); MySqlCommandBuilder commandBuilderReason = new MySqlCommandBuilder (dataAdapterReason); DataTable dataTableReason = new DataTable (); dataAdapterReason. Fill (dataTableReason); BindingSource bindingSourceReason = new BindingSource (); bindingSourceReason. DataSource = dataTableReason; // объекты string sql = «SELECT obj. id, adr. city, adr. street, adr. house, adr. appartment, objtype.name as objecttypename, obj. square, obj. floor» + «FROM objects obj left join adresses adr on adr. id = obj. id_address» + «left join objecttypes objtype on objtype. id = obj. id_objecttype»; MySqlDataAdapter dataAdapterObject = new MySqlDataAdapter (sql, conn); MySqlCommandBuilder commandBuilderObject = new MySqlCommandBuilder (dataAdapterObject); DataTable dataTableObject = new DataTable (); dataAdapterObject. Fill (dataTableObject); DataColumn dc = new DataColumn («sumColumn»); dc. Expression = «city + ', ' + street + ' ' + house + '.

-' + appartment + ' (площадь: ' + square + ', этаж: ' + floor + ')'"; dataTableObject.Columns.Add (dc); BindingSource bindingSourceObject = new BindingSource (); bindingSourceObject. DataSource = dataTableObject; // вызовы MySqlCommand sqlCom = new MySqlCommand («SELECT * FROM calls», conn); sqlCom. ExecuteNonQuery (); dataAdapter = new MySqlDataAdapter (sqlCom); ds = new DataSet (); dataAdapter. Fill (ds, «calls»); bindingSource = new BindingSource (); bindingSource. DataSource = ds. Tables[" calls" ]; dataGridView1. DataSource = ds. Tables[" calls" ]; dataGridView1. Columns[" id" ]. Visible = false; dataGridView1. Columns[" num_team" ]. HeaderText = «Номербригады»; dataGridView1. Columns[" num_team" ]. Width = 50; dataGridView1. Columns[" date" ]. HeaderText = «Датавыезда»; dataGridView1. Columns[" id_object" ]. Visible = false; dataGridView1. Columns[" id_reason" ]. Visible = false; dataGridView1. Columns[" arrived" ]. HeaderText = «Датаприбытия»; dataGridView1. Columns[" num_sufferer" ]. HeaderText = «Количествопострадавших»; // объекты DataGridViewComboBoxColumn columnObject = new DataGridViewComboBoxColumn { DataPropertyName = «id_object», HeaderText = «Объект», Width = 120, DataSource = bindingSourceObject, DisplayMember = «sumColumn», ValueMember = «id» }; columnObject. AutoSizeMode = DataGridViewAutoSizeColumnMode. Fill; columnObject. DisplayStyle = DataGridViewComboBoxDisplayStyle. Nothing; dataGridView1.Columns.Add (columnObject); // причины DataGridViewComboBoxColumn columnReason = new DataGridViewComboBoxColumn { DataPropertyName = «id_reason», HeaderText = «Причина», Width = 200, DataSource = bindingSourceReason, DisplayMember = «name», ValueMember = «id» }; columnReason. DisplayStyle = DataGridViewComboBoxDisplayStyle. Nothing; dataGridView1.Columns.Add (columnReason); foreach (DataGridViewColumn col in dataGridView1. Columns) { col.HeaderCell.Style.Alignment = DataGridViewContentAlignment. MiddleCenter; //col.HeaderCell.Style.Font = new Font («Arial», 12 °F, FontStyle. Bold, GraphicsUnit. Pixel); } //conn.Close (); } catch (MySql.Data.MySqlClient.MySqlException ex) { MessageBox. Show («Текстошибки: „+ ex. Message); } } private void toolStripButton1_Click (object sender, EventArgs e) { MySqlCommandBuilder cmb = new MySqlCommandBuilder (dataAdapter); dataAdapter. Update (ds, „calls“); //dataGridView1.DataSource = ds; } private void toolStripButton2_Click (object sender, EventArgs e) { MySqlCommandBuilder cmb = new MySqlCommandBuilder (dataAdapter); dataGridView1.Rows.RemoveAt (dataGridView1.CurrentRow.Index); dataAdapter. Update (ds, „calls“); } private void toolStripButton3_Click (object sender, EventArgs e) { //экспортвпдф var doc = new Document (PageSize.A4, 10f, 10f, 10f, 0f); BaseFont baseFont = BaseFont. CreateFont (@“ C: windowsfontsarial. ttf», BaseFont. IDENTITY_H, BaseFont. NOT_EMBEDDED); iTextSharp.text.Font font = new iTextSharp.text.Font (baseFont, iTextSharp.text.Font.DEFAULTSIZE, iTextSharp.text.Font.NORMAL); PdfWriter. GetInstance (doc, new FileStream («.» + @" Document. pdf", FileMode. Create)); doc. Open (); PdfPTable pdfTable = new PdfPTable (dataGridView1.ColumnCount — 3); pdfTable.DefaultCell.Padding = 3; pdfTable. WidthPercentage = 100; pdfTable. HorizontalAlignment = Element. ALIGN_CENTER; pdfTable.DefaultCell.BorderWidth = 1; foreach (DataGridViewColumn column in dataGridView1. Columns) { if (!column.HeaderText.Equals («id») && !column.HeaderText.Equals («id_object») && !column.HeaderText.Equals («id_reason»)) { PdfPCell cell = new PdfPCell (new Phrase (column.HeaderText, font)); pdfTable. AddCell (cell); } } foreach (DataGridViewRow row in dataGridView1. Rows) { foreach (DataGridViewCell cell in row. Cells) { if (cell.ColumnIndex ≠ 0 && cell. ColumnIndex ≠ 3 && cell. ColumnIndex ≠ 4) { if (cell.Value ≠ null) pdfTable. AddCell (new Phrase (cell.EditedFormattedValue.ToString (), font)); } } } //передаемтекствпдф doc. Add (new Paragraph («Реестрвызововn», font)); doc. Add (new Paragraph (««, font)); //doc.Add (new Paragraph («Тип: «+ tip, font)); //doc.Add (new Paragraph («Размещение: «+ razm, font)); //doc.Add (new Paragraph («Цвет: «+ cvet, font)); //doc.Add (new Paragraph («Количестволамп: «+ lamp, font)); //doc.Add (new Paragraph («Мощность: «+ mosh, font)); //doc.Add (new Paragraph («Вес: «+ ves, font)); doc. Add (new Paragraph (««, font)); doc. Add (pdfTable); doc. Close (); System.Diagnostics.Process.Start («.» + @» Document. pdf»); } private void toolStripLabel1_Click (object sender, EventArgs e) { } private void toolStripLabel2_Click (object sender, EventArgs e) { } private void dateTimePicker1_ValueChanged (object sender, EventArgs e) { } private void toolStripButton4_Click (object sender, EventArgs e) { } private void button1_Click (object sender, EventArgs e) { //this.bindingSource.Filter = «[date] >= '» + dateTimePicker1.Value.ToString («yyyy-MM-dd») + «' and [date] <= '» + dateTimePicker2.Value.ToString («yyyy-MM-dd») + «'»; this.bindingSource.Filter = String. Format («[date] >= '{0}' and [date] <= '{1}'», dateTimePicker1.Value.ToString («yyyy-MM-dd»), dateTimePicker2.Value.ToString («yyyy-MM-dd»)); } private void button2_Click (object sender, EventArgs e){ this.bindingSource.Filter = «»; } }}.