Разработка информационной системы для автоматизации распределения дополнительных обязанностей сотрудников

ExecuteScalar().ToString();intiid = int.Parse(id);iid = iid + 1;string name = textBox1.Text;stringtel = textBox2.Text;stringdolg = comboBox1.SelectedValue.ToString();stringdolg_query = "SELECT code FROM dolgn WHERE nam LIKE '%" + dolg + "%'";OleDbCommandcmd_dolg = newOleDbCommand(dolg_query, myConnection);stringdolg_idf = cmd_dolg.ExecuteScalar().ToString();intdolg_id = int.Parse(dolg_idf);string query = "INSERT INTO sotr([code], [fio], [code_dol], [tel]) Values(" + iid + ", '" + name + "', " + dolg_id + ", '" + tel + "')";OleDbCommand command = newOleDbCommand(query, myConnection);command.ExecuteNonQuery();MessageBox.Show("Сотрудникдобавлен"); }privatevoid Form2_FormClosing(object sender, FormClosingEventArgs e) {myConnection.Close(); } }}namespacekadr{publicpartialclassForm3 : Form {publicstaticstringconnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=kadr.mdb";privateOleDbConnectionmyConnection;publicForm3() {InitializeComponent();myConnection = newOleDbConnection(connectString);myConnection.Open(); }privatevoid Form3_Load(object sender, EventArgs e){// TODO: данная строка кода позволяет загрузить данные в таблицу "kadrDataSet15.dolgn". При необходимости она может быть перемещена или удалена.this.dolgnTableAdapter1.Fill(this.kadrDataSet15.dolgn);}privatevoid button1_Click(object sender, EventArgs e) {stringid_query = "SELECT MAX(code) FROM dolgn";OleDbCommandcmd = newOleDbCommand(id_query, myConnection);string id = cmd.ExecuteScalar().ToString();intiid = int.Parse(id);iid = iid + 1;string name = textBox1.Text;string query = "INSERT INTO dolgn([code], [nam]) Values(" + iid + ", '" + name + "')";OleDbCommand command = newOleDbCommand(query, myConnection);command.ExecuteNonQuery();MessageBox.Show("Должностьдобавлена"); }privatevoid Form3_FormClosing(object sender, FormClosingEventArgs e) {myConnection.Close(); } }}namespacekadr{publicpartialclassForm4 : Form {publicstaticstringconnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=kadr.mdb";privateOleDbConnectionmyConnection;publicForm4() {InitializeComponent();myConnection = newOleDbConnection(connectString);myConnection.Open(); }privatevoid Form4_Load(object sender, EventArgs e){// TODO: данная строка кода позволяет загрузить данные в таблицу "kadrDataSet16.vid_rab". При необходимости она может быть перемещена или удалена.this.vid_rabTableAdapter1.Fill(this.kadrDataSet16.vid_rab);}privatevoid button1_Click(object sender, EventArgs e) {stringid_query = "SELECT MAX(code) FROM vid_rab";OleDbCommandcmd = newOleDbCommand(id_query, myConnection);string id = cmd.ExecuteScalar().ToString();intiid = int.Parse(id);iid = iid + 1;string name = textBox1.Text;stringst = textBox2.Text;intstm = int.Parse(st);string query = "INSERT INTO vid_rab([code], [nam], [stm]) Values(" + iid + ", '" + name + "', "+ stm +")";OleDbCommand command = newOleDbCommand(query, myConnection);command.ExecuteNonQuery();MessageBox.Show("Добавлено"); }privatevoid Form3_FormClosing(object sender, FormClosingEventArgs e) {myConnection.Close(); } }}namespacekadr{publicpartialclassForm5 : Form {publicstaticstringconnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=kadr.mdb";privateOleDbConnectionmyConnection;publicForm5() {InitializeComponent();myConnection = newOleDbConnection(connectString);myConnection.Open(); }privatevoid Form5_Load(object sender, EventArgs e){// TODO: данная строка кода позволяет загрузить данные в таблицу "kadrDataSet17.typ". При необходимости она может быть перемещена или удалена.this.typTableAdapter1.Fill(this.kadrDataSet17.typ);}privatevoid button1_Click(object sender, EventArgs e) {stringid_query = "SELECT MAX(code) FROM typ";OleDbCommandcmd = newOleDbCommand(id_query, myConnection);string id = cmd.ExecuteScalar().ToString();intiid = int.Parse(id);iid = iid + 1;System.Threading.Thread.CurrentThread.CurrentCulture = newSystem.Globalization.CultureInfo("en-US");string name = textBox1.Text;string k = textBox2.Text;doublekoef = Convert.ToDouble(k); string query = "INSERT INTO typ([code], [nam], [koef]) Values(" + iid + ", '" + name + "', " + koef + ")";OleDbCommand command = newOleDbCommand(query, myConnection);command.ExecuteNonQuery();MessageBox.Show("Добавлено"); }privatevoid Form5_FormClosing(object sender, FormClosingEventArgs e) {myConnection.Close(); } }}namespacekadr{publicpartialclassForm8 : Form {publicstaticstringconnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=kadr.mdb";privateOleDbConnectionmyConnection;publicForm8() {InitializeComponent();myConnection = newOleDbConnection(connectString);myConnection.Open(); }privatevoid Form8_Load(object sender, EventArgs e){// TODO: данная строка кода позволяет загрузить данные в таблицу "kadrDataSet24.zp2". При необходимости она может быть перемещена или удалена.this.zp2TableAdapter1.Fill(this.kadrDataSet24.zp2);// TODO: данная строка кода позволяет загрузить данные в таблицу "kadrDataSet23.vid_rab". При необходимости она может быть перемещена или удалена.this.vid_rabTableAdapter1.Fill(this.kadrDataSet23.vid_rab);}privatevoid button1_Click(object sender, EventArgs e) {string vid = comboBox1.SelectedValue.ToString();string query = "SELECT * FROM zp2 WHERE [nam] LIKE '%" + vid + "%'";OleDbDataAdapter command = newOleDbDataAdapter(query, myConnection);DataTable dt = newDataTable();command.Fill(dt); dataGridView1.DataSource = dt; }privatevoid Form8_FormClosing(object sender, FormClosingEventArgs e) {myConnection.Close(); }privatevoid button2_Click(object sender, EventArgs e) {Excel.ApplicationexApp = newExcel.Application();exApp.Workbooks.Add();Excel.Worksheetwsh = (Excel.Worksheet)exApp.ActiveSheet;inti, j; j = 0;for (i = 1; i < dataGridView1.Columns.Count + 1; i++) {wsh.Cells[1, i] = dataGridView1.Columns[i - 1].HeaderText; }for (i = 0; i <= dataGridView1.RowCount - 2; i++) {for (j = 0; j <= dataGridView1.ColumnCount - 1; j++) {wsh.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString(); } }exApp.Visible = true; } }}namespacekadr{publicpartialclassForm7 : Form {publicstaticstringconnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=kadr.mdb";privateOleDbConnectionmyConnection;publicForm7() {InitializeComponent();myConnection = newOleDbConnection(connectString);myConnection.Open(); }privatevoid Form7_Load(object sender, EventArgs e){// TODO: данная строка кода позволяет загрузить данные в таблицу "kadrDataSet22.zp1". При необходимости она может быть перемещена или удалена.this.zp1TableAdapter1.Fill(this.kadrDataSet22.zp1);}privatevoid button1_Click(object sender, EventArgs e) {Excel.ApplicationexApp = newExcel.Application();exApp.Workbooks.Add();Excel.Worksheetwsh = (Excel.Worksheet)exApp.ActiveSheet;inti, j; j = 0;for (i = 1; i < dataGridView1.Columns.Count + 1; i++) {wsh.Cells[1, i] = dataGridView1.Columns[i - 1].HeaderText; }for (i = 0; i <= dataGridView1.RowCount - 2; i++) {for (j = 0; j <= dataGridView1.ColumnCount - 1; j++) {wsh.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString(); } }exApp.Visible = true; }privatevoid Form7_FormClosing(object sender, FormClosingEventArgs e){myConnection.Close(); } }}