private void btnDel_Click(object sender, EventArgs e) { if (MessageBox.Show("Вы дeйствительно хотите удалить данные?", "Удаление", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { ConnectSDO sdo = new ConnectSDO(); sqlcom = new SqlCommand("spDelYearPlan", sdo.getConnectSDO()); sqlcom.CommandType = CommandType.StoredProcedure; sqlcom.Parameters.AddWithValue("@Id", SqlDbType.Int).Value = Convert.ToInt32(dgvPlanEvent.Rows[dgvPlanEvent.CurrentRow.Index].Cells[0].Value); sdo.OpenConnection(); sqlcom.ExecuteNonQuery(); MessageBox.Show("Мероприятие удалено!"); sdo.CloseConnection(); vwEvent(); } catch (Exception) { MessageBox.Show("Не удалось удалить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Отмена", "Отмена удаления", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void spUnit(int Id, string Categ) { ConnectSDO sdo = new ConnectSDO(); SqlCommand sqlcom2 = new SqlCommand("spAddYearUnit", sdo.getConnectSDO()); sqlcom2.CommandType = CommandType.StoredProcedure; sqlcom2.Parameters.AddWithValue("@CategoryU", SqlDbType.NVarChar).Value = Categ; sqlcom2.Parameters.AddWithValue("@IdE", SqlDbType.Int).Value = Id; sdo.OpenConnection(); sqlcom2.ExecuteNonQuery(); sdo.CloseConnection(); }
private void btnSearch_Click(object sender, EventArgs e) { btnList.Visible = true; ConnectSDO sdo = new ConnectSDO(); sdo.OpenConnection(); SqlCommand comSPM = new SqlCommand("SELECT * FROM vwEventt WHERE [Дата проведения] = ' " + dtpEvent.Value.ToString("yyy-MM-dd") + "'", sdo.getConnectSDO()); adapter = new SqlDataAdapter(comSPM); datTab = new DataTable(); adapter.Fill(datTab); sdo.CloseConnection(); dgvEvent.DataSource = datTab; }
public void spQtyUnit(int Id, int Qty, string NameUnit, string Name, string Categ) { ConnectSDO sdo = new ConnectSDO(); SqlCommand sqlcom2 = new SqlCommand("spAddAssignQty", sdo.getConnectSDO()); sqlcom2.CommandType = CommandType.StoredProcedure; sqlcom2.Parameters.AddWithValue("@IdU", SqlDbType.Int).Value = Id; sqlcom2.Parameters.AddWithValue("@Name", SqlDbType.NVarChar).Value = Name; sqlcom2.Parameters.AddWithValue("@NameUnit", SqlDbType.NVarChar).Value = NameUnit; sqlcom2.Parameters.AddWithValue("@Qty", SqlDbType.Int).Value = Qty; sqlcom2.Parameters.AddWithValue("@Category", SqlDbType.NVarChar).Value = Categ; sdo.OpenConnection(); sqlcom2.ExecuteNonQuery(); sdo.CloseConnection(); }
public void vwInfEventt2(int a) { try { dgvInfYP.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dgvInfYP.AllowUserToAddRows = false; ConnectSDO ConSDO = new ConnectSDO(); ConSDO.OpenConnection(); SqlCommand comSPM = new SqlCommand("SELECT * FROM vwYearPlan1 WHERE IdE = " + a, ConSDO.getConnectSDO()); adapter = new SqlDataAdapter(comSPM); datTab = new DataTable(); adapter.Fill(datTab); ConSDO.CloseConnection(); dgvInfYP.DataSource = datTab; dgvInfYP.Columns[0].Visible = false; } catch (Exception) { MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public int vwIdUnit() { ConnectSDO sdo = new ConnectSDO(); sdo.OpenConnection(); sqlcom = new SqlCommand("SELECT MAXId FROM vwMaxIdUn", sdo.getConnectSDO()); sqlcom.ExecuteNonQuery(); SqlDataAdapter adap = new SqlDataAdapter(sqlcom); datTab = new DataTable(); adap.Fill(datTab); int a = 0; foreach (DataRow DR in datTab.Rows) { a = Convert.ToInt32(DR["MAXId"].ToString()); } sdo.CloseConnection(); return(a); }
private void btnSave_Click(object sender, EventArgs e) { if (tbNameEvent.Text.Length > 0 && cmbStatusEvent.Text != "") { try { if (tbNameEvent.Text.Length > 0 && cmbStatusEvent.Text.Length > 0) { ConnectSDO sdo = new ConnectSDO(); SqlCommand sqlcom2 = new SqlCommand("spAddEventt", sdo.getConnectSDO()); sqlcom2.CommandType = CommandType.StoredProcedure; sqlcom2.Parameters.AddWithValue("@Name", SqlDbType.NVarChar).Value = tbNameEvent.Text.Trim(); sqlcom2.Parameters.AddWithValue("@Status", SqlDbType.NVarChar).Value = cmbStatusEvent.Text.Trim(); sqlcom2.Parameters.AddWithValue("@DataFirst", SqlDbType.DateTime).Value = mcEvent.SelectionRange.Start; sqlcom2.Parameters.AddWithValue("@IdYP", SqlDbType.Int).Value = Idyp; sdo.OpenConnection(); sqlcom2.ExecuteNonQuery(); sdo.CloseConnection(); } else { MessageBox.Show("Не удалось добавить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } int Event = vwIdEvent(); if (cmbStatusQtyEvent1.Text.Length > 0) { string CategU = cmbStatusQtyEvent1.Text; int EventU = Event; spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEventAllP.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEventAllP.Text); string NameUnit = cmbStatusQtyEvent1.Text; string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameUnit, NameU, CategoryU); int Qty1 = Int32.Parse(tbEventAllB.Text); string NameUnit1 = cmbStatusQtyEvent1.Text; string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, NameUnit1, Name1, Category1); int Qty2 = Int32.Parse(tbUnitAllP.Text); string NameUnit2 = cmbStatusQtyEvent1.Text; string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, NameUnit2, Name2, Category2); int Qty3 = Int32.Parse(tbUnitAllB.Text); string NameUnit3 = cmbStatusQtyEvent1.Text; string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, NameUnit3, Name3, Category3); int Qty6 = Int32.Parse(tbAllPlayer.Text); string NameUnit6 = cmbStatusQtyEvent1.Text; string Name6 = lblParticial.Text; string Category6 = lblB.Text; spQtyUnit(IdU, Qty6, NameUnit6, Name6, Category6); } } if (cmbgr1.Text.Length > 0) { //string CategU = cmbgr1.Text; int EventU = Event; //spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEvP1.Text.Length >= 0 && tbEvB1.Text.Length >= 0 && tbpgr1.Text.Length >= 0 && tbPBgr1.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEvP1.Text); string NameUnit = cmbgr1.Text; string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameUnit, NameU, CategoryU); int Qty1 = Int32.Parse(tbEvB1.Text); string NameUnit1 = cmbgr1.Text; string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, NameUnit1, Name1, Category1); int Qty2 = Int32.Parse(tbpgr1.Text); string NameUnit2 = cmbgr1.Text; string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, NameUnit2, Name2, Category2); int Qty3 = Int32.Parse(tbPBgr1.Text); string NameUnit3 = cmbgr1.Text; string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, NameUnit3, Name3, Category3); int Qty6 = Int32.Parse(tbPlayer1.Text); string NameUnit4 = cmbgr1.Text; string Name6 = lblParticial.Text; string Category6 = lblB.Text; spQtyUnit(IdU, Qty6, NameUnit4, Name6, Category6); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (cmbgr2.Text.Length > 0) { //string CategU = cmbgr2.Text; int EventU = Event; //spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEvP2.Text.Length >= 0 && tbEvB2.Text.Length >= 0 && tbpgr2.Text.Length >= 0 && tbPBgr2.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEvP2.Text); string NameUnit = cmbgr2.Text; string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameUnit, NameU, CategoryU); int Qty1 = Int32.Parse(tbEvB2.Text); string NameUnit1 = cmbgr2.Text; string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, NameUnit1, Name1, Category1); int Qty2 = Int32.Parse(tbpgr2.Text); string NameUnit2 = cmbgr2.Text; string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, NameUnit2, Name2, Category2); int Qty3 = Int32.Parse(tbPBgr2.Text); string NameUnit3 = cmbgr2.Text; string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, NameUnit3, Name3, Category3); int Qty6 = Int32.Parse(tbPlayer2.Text); string NameUnit4 = cmbgr2.Text; string Name6 = lblParticial.Text; string Category6 = lblB.Text; spQtyUnit(IdU, Qty6, NameUnit4, Name6, Category6); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (cmbgr3.Text.Length > 0) { //string CategU = cmbgr3.Text; int EventU = Event; //spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEvP3.Text.Length >= 0 && tbEvB3.Text.Length >= 0 && tbpgr3.Text.Length >= 0 && tbPBgr3.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEvP3.Text); string NameUnit = cmbgr3.Text; string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameUnit, NameU, CategoryU); int Qty1 = Int32.Parse(tbEvB3.Text); string NameUnit1 = cmbgr3.Text; string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, NameUnit1, Name1, Category1); int Qty2 = Int32.Parse(tbpgr3.Text); string NameUnit2 = cmbgr3.Text; string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, NameUnit2, Name2, Category2); int Qty3 = Int32.Parse(tbPBgr3.Text); string NameUnit3 = cmbgr3.Text; string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, NameUnit3, Name3, Category3); int Qty6 = Int32.Parse(tbPlayer3.Text); string NameUnit4 = cmbgr3.Text; string Name6 = lblParticial.Text; string Category6 = lblB.Text; spQtyUnit(IdU, Qty6, NameUnit4, Name6, Category6); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (cmbgr4.Text.Length > 0) { //string CategU = cmbgr4.Text; int EventU = Event; //spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEvP4.Text.Length >= 0 && tbEvB4.Text.Length >= 0 && tbpgr4.Text.Length >= 0 && tbPBgr4.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEvP4.Text); string NameUnit = cmbgr4.Text; string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameUnit, NameU, CategoryU); int Qty1 = Int32.Parse(tbEvB4.Text); string NameUnit1 = cmbgr4.Text; string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, NameUnit1, Name1, Category1); int Qty2 = Int32.Parse(tbpgr4.Text); string NameUnit2 = cmbgr4.Text; string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, NameUnit2, Name2, Category2); int Qty3 = Int32.Parse(tbPBgr4.Text); string NameUnit3 = cmbgr4.Text; string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, NameUnit3, Name3, Category3); int Qty6 = Int32.Parse(tbPlayer4.Text); string NameUnit4 = cmbgr4.Text; string Name6 = lblParticial.Text; string Category6 = lblB.Text; spQtyUnit(IdU, Qty6, NameUnit4, Name6, Category6); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (cmbgr5.Text.Length > 0) { //string CategU = cmbgr5.Text; int EventU = Event; //spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEvP5.Text.Length >= 0 && tbEvB5.Text.Length >= 0 && tbpgr5.Text.Length >= 0 && tbPBgr5.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEvP5.Text); string NameUnit = cmbgr5.Text; string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameUnit, NameU, CategoryU); int Qty1 = Int32.Parse(tbEvB5.Text); string NameUnit1 = cmbgr5.Text; string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, NameUnit1, Name1, Category1); int Qty2 = Int32.Parse(tbpgr5.Text); string NameUnit2 = cmbgr5.Text; string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, NameUnit2, Name2, Category2); int Qty3 = Int32.Parse(tbPBgr5.Text); string NameUnit3 = cmbgr5.Text; string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, NameUnit3, Name3, Category3); int Qty6 = Int32.Parse(tbPlayer5.Text); string NameUnit4 = cmbgr5.Text; string Name6 = lblParticial.Text; string Category6 = lblB.Text; spQtyUnit(IdU, Qty6, NameUnit4, Name6, Category6); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } MessageBox.Show(" Mероприятие добавлено!"); } catch (Exception) { MessageBox.Show("Не удалось добавить мероприятие!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } ClearTB(); } else { MessageBox.Show("Заполните название мероприятия или выберите статус!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnOk_Click(object sender, EventArgs e) { if (Int32.Parse(tbEventSUM.Text) > 0 && Int32.Parse(tbUnitSUM.Text) > 0) { try { if (tbEvent.Text.Length > 0 && cmbStatusEvent.Text.Length > 0) { ConnectSDO sdo = new ConnectSDO(); SqlCommand sqlcom2 = new SqlCommand("spAddYearPlan", sdo.getConnectSDO()); sqlcom2.CommandType = CommandType.StoredProcedure; sqlcom2.Parameters.AddWithValue("@DataEnd", SqlDbType.DateTime).Value = mcEndEvent.SelectionRange.Start; sqlcom2.Parameters.AddWithValue("@Name", SqlDbType.NVarChar).Value = tbEvent.Text.Trim(); sqlcom2.Parameters.AddWithValue("@Status", SqlDbType.NVarChar).Value = cmbStatusEvent.Text.Trim(); sqlcom2.Parameters.AddWithValue("@DataFirst", SqlDbType.DateTime).Value = mcDataEvent.SelectionRange.Start; sdo.OpenConnection(); sqlcom2.ExecuteNonQuery(); sdo.CloseConnection(); } else { MessageBox.Show("Не удалось добавить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } int Event = vwIdEvent(); if (cmbStatusQtyEvent1.Text.Length > 0) { string CategU = cmbStatusQtyEvent1.Text; int EventU = Event; spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEventAllP.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEventAllP.Text); string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameU, CategoryU); int Qty1 = Int32.Parse(tbEventAllB.Text); string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, Name1, Category1); int Qty2 = Int32.Parse(tbUnitAllP.Text); string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, Name2, Category2); int Qty3 = Int32.Parse(tbUnitAllB.Text); string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, Name3, Category3); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (cmbgr1.Text.Length > 0) { string CategU = cmbgr1.Text; int EventU = Event; spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEvP1.Text.Length >= 0 && tbEvB1.Text.Length >= 0 && tbpgr1.Text.Length >= 0 && tbPBgr1.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEvP1.Text); string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameU, CategoryU); int Qty1 = Int32.Parse(tbEvB1.Text); string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, Name1, Category1); int Qty2 = Int32.Parse(tbpgr1.Text); string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, Name2, Category2); int Qty3 = Int32.Parse(tbPBgr1.Text); string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, Name3, Category3); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (cmbgr2.Text.Length > 0) { string CategU = cmbgr2.Text; int EventU = Event; spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEvP2.Text.Length >= 0 && tbEvB2.Text.Length >= 0 && tbpgr2.Text.Length >= 0 && tbPBgr2.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEvP2.Text); string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameU, CategoryU); int Qty1 = Int32.Parse(tbEvB2.Text); string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, Name1, Category1); int Qty2 = Int32.Parse(tbpgr2.Text); string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, Name2, Category2); int Qty3 = Int32.Parse(tbPBgr2.Text); string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, Name3, Category3); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (cmbgr3.Text.Length > 0) { string CategU = cmbgr3.Text; int EventU = Event; spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEvP3.Text.Length >= 0 && tbEvB3.Text.Length >= 0 && tbpgr3.Text.Length >= 0 && tbPBgr3.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEvP3.Text); string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameU, CategoryU); int Qty1 = Int32.Parse(tbEvB3.Text); string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, Name1, Category1); int Qty2 = Int32.Parse(tbpgr3.Text); string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, Name2, Category2); int Qty3 = Int32.Parse(tbPBgr3.Text); string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, Name3, Category3); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (cmbgr4.Text.Length > 0) { string CategU = cmbgr4.Text; int EventU = Event; spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEvP4.Text.Length >= 0 && tbEvB4.Text.Length >= 0 && tbpgr4.Text.Length >= 0 && tbPBgr4.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEvP4.Text); string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameU, CategoryU); int Qty1 = Int32.Parse(tbEvB4.Text); string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, Name1, Category1); int Qty2 = Int32.Parse(tbpgr4.Text); string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, Name2, Category2); int Qty3 = Int32.Parse(tbPBgr4.Text); string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, Name3, Category3); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (cmbStatusQtyEventt2.Text.Length > 0) { string CategU = cmbStatusQtyEventt2.Text; int EventU = Event; spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEventAllP2.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEventAllP2.Text); string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameU, CategoryU); int Qty1 = Int32.Parse(tbEventAllB2.Text); string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, Name1, Category1); int Qty2 = Int32.Parse(tbUnitAllP2.Text); string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, Name2, Category2); int Qty3 = Int32.Parse(tbUnitAllB2.Text); string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, Name3, Category3); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (cmbGR21.Text.Length > 0) { string CategU = cmbGR21.Text; int EventU = Event; spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEventP21.Text.Length >= 0 && tbEventB21.Text.Length >= 0 && tbPgr21.Text.Length >= 0 && tbPBgr21.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEventP21.Text); string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameU, CategoryU); int Qty1 = Int32.Parse(tbEventB21.Text); string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, Name1, Category1); int Qty2 = Int32.Parse(tbPgr21.Text); string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, Name2, Category2); int Qty3 = Int32.Parse(tbPBgr21.Text); string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, Name3, Category3); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (cmbGR22.Text.Length > 0) { string CategU = cmbGR22.Text; int EventU = Event; spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEventP22.Text.Length >= 0 && tbEventB22.Text.Length >= 0 && tbPgr22.Text.Length >= 0 && tbPBgr22.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEventP22.Text); string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameU, CategoryU); int Qty1 = Int32.Parse(tbEventB22.Text); string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, Name1, Category1); int Qty2 = Int32.Parse(tbPgr22.Text); string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, Name2, Category2); int Qty3 = Int32.Parse(tbPBgr22.Text); string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, Name3, Category3); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (cmbGR23.Text.Length > 0) { string CategU = cmbGR23.Text; int EventU = Event; spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEventP23.Text.Length >= 0 && tbEventB23.Text.Length >= 0 && tbPgr23.Text.Length >= 0 && tbPBgr23.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEventP23.Text); string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameU, CategoryU); int Qty1 = Int32.Parse(tbEventB23.Text); string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, Name1, Category1); int Qty2 = Int32.Parse(tbPgr23.Text); string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, Name2, Category2); int Qty3 = Int32.Parse(tbPBgr23.Text); string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, Name3, Category3); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } if (cmbGR24.Text.Length > 0) { string CategU = cmbGR24.Text; int EventU = Event; spUnit(Event, CategU); int Iduu = vwIdUnit(); if (tbEventP24.Text.Length >= 0 && tbEventB24.Text.Length >= 0 && tbPgr24.Text.Length >= 0 && tbPBgr24.Text.Length >= 0) { int IdU = Iduu; int QtyU = Int32.Parse(tbEventP24.Text); string NameU = lblEvent.Text; string CategoryU = lblP.Text; spQtyUnit(IdU, QtyU, NameU, CategoryU); int Qty1 = Int32.Parse(tbEventB24.Text); string Name1 = lblEvent.Text; string Category1 = lblB.Text; spQtyUnit(IdU, Qty1, Name1, Category1); int Qty2 = Int32.Parse(tbPgr24.Text); string Name2 = lblPeople.Text; string Category2 = lblP.Text; spQtyUnit(IdU, Qty2, Name2, Category2); int Qty3 = Int32.Parse(tbPBgr24.Text); string Name3 = lblPeople.Text; string Category3 = lblB.Text; spQtyUnit(IdU, Qty3, Name3, Category3); } else { MessageBox.Show("Не удалось добавить подразделение!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } MessageBox.Show("Годовое мероприятие добавлено!"); this.Hide(); MainForm m = new MainForm(); m.Show(); } catch (Exception) { MessageBox.Show("Не удалось добавить мероприятие!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Заполните все поля!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void SumEvent(int IdYP) { int Id = IdYP; int[] Event; int sum = 0; Event = new int[dgvEvent.RowCount]; for (int i = 0; i < dgvEvent.RowCount; i++) { Event[i] = Convert.ToInt32(dgvEvent[6, i].Value.ToString()); //MessageBox.Show(dgvEventt3[1, i].Value.ToString()); } foreach (var num in Event) { sum += num; } tbPassedEvent.Text = Convert.ToString(sum); if (tbPassedEvent.Text != "") { int a = Convert.ToInt32(tbTotalEvent.Text); int b = Convert.ToInt32(tbPassedEvent.Text); int d = SUMTotal(a, b); lblEvFull.Text = Convert.ToString(d); } int[] EventPeop; int sum2 = 0; EventPeop = new int[dgvEvent.RowCount]; for (int i = 0; i < dgvEvent.RowCount; i++) { EventPeop[i] = Convert.ToInt32(dgvEvent[7, i].Value.ToString()); //MessageBox.Show(dgvEventt3[1, i].Value.ToString()); } foreach (var num1 in EventPeop) { sum2 += num1; } tbPassedPeople.Text = Convert.ToString(sum2); if (tbPassedPeople.Text != "") { int a = Convert.ToInt32(tbTotalPeople.Text); int b = Convert.ToInt32(tbPassedPeople.Text); int d = SUMTotal(a, b); lblPepFull.Text = Convert.ToString(d); } try { ConnectSDO ConSDO = new ConnectSDO(); ConSDO.OpenConnection(); SqlCommand comSPM = new SqlCommand("SELECT SUMALL FROM vwEventP WHERE YearPlanId =" + Id, ConSDO.getConnectSDO()); adapter = new SqlDataAdapter(comSPM); datTab = new DataTable(); adapter.Fill(datTab); ConSDO.CloseConnection(); foreach (DataRow DR in datTab.Rows) { tbEventPPas.Text = (DR["SUMALL"].ToString()); } } catch (Exception) { MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } try { ConnectSDO ConSDO = new ConnectSDO(); ConSDO.OpenConnection(); SqlCommand comSPM = new SqlCommand("SELECT SUMALL FROM vwEventB WHERE YearPlanId =" + Id, ConSDO.getConnectSDO()); adapter = new SqlDataAdapter(comSPM); datTab = new DataTable(); adapter.Fill(datTab); ConSDO.CloseConnection(); foreach (DataRow DR in datTab.Rows) { tbEventBPas.Text = (DR["SUMALL"].ToString()); } } catch (Exception) { MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } try { ConnectSDO ConSDO = new ConnectSDO(); ConSDO.OpenConnection(); SqlCommand comSPM = new SqlCommand("SELECT SUMALL FROM vwPeopP WHERE YearPlanId =" + Id, ConSDO.getConnectSDO()); adapter = new SqlDataAdapter(comSPM); datTab = new DataTable(); adapter.Fill(datTab); ConSDO.CloseConnection(); foreach (DataRow DR in datTab.Rows) { tbPepPPas.Text = (DR["SUMALL"].ToString()); } } catch (Exception) { MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } try { ConnectSDO ConSDO = new ConnectSDO(); ConSDO.OpenConnection(); SqlCommand comSPM = new SqlCommand("SELECT SUMALL FROM vwPeopB WHERE YearPlanId =" + Id, ConSDO.getConnectSDO()); adapter = new SqlDataAdapter(comSPM); datTab = new DataTable(); adapter.Fill(datTab); ConSDO.CloseConnection(); foreach (DataRow DR in datTab.Rows) { tbPepPasB.Text = (DR["SUMALL"].ToString()); } } catch (Exception) { MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } try { ConnectSDO ConSDO = new ConnectSDO(); ConSDO.OpenConnection(); SqlCommand comSPM = new SqlCommand("SELECT SUMALL FROM vwPalyear WHERE YearPlanId =" + Id, ConSDO.getConnectSDO()); adapter = new SqlDataAdapter(comSPM); datTab = new DataTable(); adapter.Fill(datTab); ConSDO.CloseConnection(); foreach (DataRow DR in datTab.Rows) { tbPlayer.Text = (DR["SUMALL"].ToString()); } } catch (Exception) { MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void TBSet(int [] EventYear1, int [] EventYear2) { int IPEventP = EventYear2[0]; int IPEventB = EventYear2[1]; int IPPeopP = EventYear2[2]; int IPPeopB = EventYear2[3]; int KDEventP = EventYear2[4]; int KDEventB = EventYear2[5]; int KDPeopP = EventYear2[6]; int KDPeopB = EventYear2[7]; tbIPEventAllP.Text = Convert.ToString(IPEventP); tbIPEventAllB.Text = Convert.ToString(IPEventB); tbIPPeopAllP.Text = Convert.ToString(IPPeopP); tbIPPeopAllB.Text = Convert.ToString(IPPeopB); tbKDEventtAllP.Text = Convert.ToString(KDEventP); tbKDEventtAllB.Text = Convert.ToString(KDEventB); tbKDPeopP.Text = Convert.ToString(KDPeopP); tbKDPeopB.Text = Convert.ToString(KDPeopB); int P1 = EventYear1[0]; int B1 = EventYear1[1]; int P2 = EventYear1[2]; int B2 = EventYear1[3]; int P3 = EventYear1[4]; int B3 = EventYear1[5]; int P4 = EventYear1[6]; int B4 = EventYear1[7]; int P5 = EventYear1[8]; int B5 = EventYear1[9]; int P6 = EventYear1[10]; int B6 = EventYear1[11]; int P7 = EventYear1[12]; int B7 = EventYear1[13]; int P8 = EventYear1[14]; int B8 = EventYear1[15]; tbP1.Text = Convert.ToString(P1); tbB1.Text = Convert.ToString(B1); tbP2.Text = Convert.ToString(P2); tbB2.Text = Convert.ToString(B2); tbP3.Text = Convert.ToString(P3); tbB3.Text = Convert.ToString(B3); tbP4.Text = Convert.ToString(P4); tbB4.Text = Convert.ToString(B4); tbP5.Text = Convert.ToString(P5); tbB5.Text = Convert.ToString(B5); tbP6.Text = Convert.ToString(P6); tbB6.Text = Convert.ToString(B6); tbP7.Text = Convert.ToString(P7); tbB7.Text = Convert.ToString(B7); tbP8.Text = Convert.ToString(P8); tbB8.Text = Convert.ToString(B8); int P9 = EventYear1[16]; int B9 = EventYear1[17]; int P10 = EventYear1[18]; int B10 = EventYear1[19]; int P11 = EventYear1[20]; int B11 = EventYear1[21]; int P12 = EventYear1[22]; int B12 = EventYear1[23]; int P13 = EventYear1[24]; int B13 = EventYear1[25]; int P14 = EventYear1[26]; int B14 = EventYear1[27]; int P15 = EventYear1[28]; int B15 = EventYear1[29]; int P16 = EventYear1[30]; int B16 = EventYear1[31]; tbPP1.Text = Convert.ToString(P9); tbPPB1.Text = Convert.ToString(B9); tbPP2.Text = Convert.ToString(P10); tbPPB2.Text = Convert.ToString(B10); tbPP3.Text = Convert.ToString(P11); tbPPB3.Text = Convert.ToString(B11); tbPP4.Text = Convert.ToString(P12); tbPPB4.Text = Convert.ToString(B12); tbPP5.Text = Convert.ToString(P13); tbPPB5.Text = Convert.ToString(B13); tbPP6.Text = Convert.ToString(P14); tbPPB6.Text = Convert.ToString(B14); tbPP7.Text = Convert.ToString(P15); tbPPB7.Text = Convert.ToString(B15); tbPP8.Text = Convert.ToString(P16); tbPPB8.Text = Convert.ToString(B16); try { ConnectSDO ConSDO = new ConnectSDO(); ConSDO.OpenConnection(); SqlCommand comSPM = new SqlCommand("SELECT QtyIPP,QtyIPB,QtyKDP,QtyKDB,QtyIPPeopP,QtyIPPeopB,QtyKDPeopP,QtyKDPeopB FROM vwAllUnit WHERE Id =" + Id, ConSDO.getConnectSDO()); adapter = new SqlDataAdapter(comSPM); datTab = new DataTable(); adapter.Fill(datTab); ConSDO.CloseConnection(); foreach (DataRow DR in datTab.Rows) { tbIPEventtAllPD.Text = (DR["QtyIPP"].ToString()); tbIPEventAllBD.Text = (DR["QtyIPB"].ToString()); tbKDEventtAllPD.Text = (DR["QtyKDP"].ToString()); tbKDEventtAllBD.Text = (DR["QtyKDB"].ToString()); tbIPPeopAllPD.Text = (DR["QtyIPPeopP"].ToString()); tbIPPeopAllBD.Text = (DR["QtyIPPeopB"].ToString()); tbKDPeopPD.Text = (DR["QtyKDPeopP"].ToString()); tbKDPeopBD.Text = (DR["QtyKDPeopB"].ToString()); } } catch (Exception) { MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } try { ConnectSDO ConSDO = new ConnectSDO(); ConSDO.OpenConnection(); SqlCommand comSPM = new SqlCommand("SELECT QtyIP14P,QtyIP14B,QtyIP25P,QtyIP25B,QtyIP55P,QtyIP55B,QtyIP55PP,QtyIP55PB,QtyKD14P,QtyKD14B,QtyKD25P,QtyKD25B,QtyKD55P,QtyKD55B,QtyKDPP,QtyKDPB FROM vwAllEventtIPKD WHERE Id =" + Id, ConSDO.getConnectSDO()); adapter = new SqlDataAdapter(comSPM); datTab = new DataTable(); adapter.Fill(datTab); ConSDO.CloseConnection(); foreach (DataRow DR in datTab.Rows) { tbP1Dd.Text = (DR["QtyIP14P"].ToString()); tbB1D.Text = (DR["QtyIP14B"].ToString()); tbP2D.Text = (DR["QtyIP25P"].ToString()); tbB2D.Text = (DR["QtyIP25B"].ToString()); tbP3D.Text = (DR["QtyIP55P"].ToString()); tbB3D.Text = (DR["QtyIP55B"].ToString()); tbP4D.Text = (DR["QtyIP55PP"].ToString()); tbB4D.Text = (DR["QtyIP55PB"].ToString()); tbPP1D.Text = (DR["QtyKD14P"].ToString()); tbBB1D.Text = (DR["QtyKD14B"].ToString()); tbPP2D.Text = (DR["QtyKD25P"].ToString()); tbBB2D.Text = (DR["QtyKD25B"].ToString()); tbPP3D.Text = (DR["QtyKD55P"].ToString()); tbBB3D.Text = (DR["QtyKD55B"].ToString()); tbPP4D.Text = (DR["QtyKDPP"].ToString()); tbBB4D.Text = (DR["QtyKDPB"].ToString()); } } catch (Exception) { MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } try { ConnectSDO ConSDO = new ConnectSDO(); ConSDO.OpenConnection(); SqlCommand comSPM = new SqlCommand("SELECT QtyIP14P,QtyIP14B,QtyIP25P,QtyIP25B,QtyIP55P,QtyIP55B,QtyIP55PP,QtyIP55PB,QtyKD14P,QtyKD14B,QtyKD25P,QtyKD25B,QtyKD55P,QtyKD55B,QtyKDPP,QtyKDPB FROM vwAllPeopleIPKD WHERE Id =" + Id, ConSDO.getConnectSDO()); adapter = new SqlDataAdapter(comSPM); datTab = new DataTable(); adapter.Fill(datTab); ConSDO.CloseConnection(); foreach (DataRow DR in datTab.Rows) { tbPep1PD.Text = (DR["QtyIP14P"].ToString()); tbPep1BD.Text = (DR["QtyIP14B"].ToString()); tbPep2PD.Text = (DR["QtyIP25P"].ToString()); tbPep2BD.Text = (DR["QtyIP25B"].ToString()); tbPep3PD.Text = (DR["QtyIP55P"].ToString()); tbPep3BD.Text = (DR["QtyIP55B"].ToString()); tbPep4PD.Text = (DR["QtyIP55PP"].ToString()); tbPep4BD.Text = (DR["QtyIP55PB"].ToString()); tbPep1PPD.Text = (DR["QtyKD14P"].ToString()); tbPep1BBD.Text = (DR["QtyKD14B"].ToString()); tbPep2PPD.Text = (DR["QtyKD25P"].ToString()); tbPep2BBD.Text = (DR["QtyKD25B"].ToString()); tbPep3PPD.Text = (DR["QtyKD55P"].ToString()); tbPep3BBD.Text = (DR["QtyKD55B"].ToString()); tbPep4PPD.Text = (DR["QtyKDPP"].ToString()); tbPep4BBD.Text = (DR["QtyKDPB"].ToString()); } } catch (Exception) { MessageBox.Show("Не удалось загрузить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } int a1 = Convert.ToInt32(tbIPEventAllP.Text); int a2 = Convert.ToInt32(tbIPEventtAllPD.Text); int s1 = RetLbl(a1, a2); lbl1.Text = Convert.ToString(s1); int a3 = Convert.ToInt32(tbIPEventAllB.Text); int a4 = Convert.ToInt32(tbIPEventAllBD.Text); int s2 = RetLbl(a3, a4); lbl2.Text = Convert.ToString(s2); int a5 = Convert.ToInt32(tbP1.Text); int a6 = Convert.ToInt32(tbP1Dd.Text); int s3 = RetLbl(a5, a6); lbl3.Text = Convert.ToString(s3); int a7 = Convert.ToInt32(tbP3.Text); int a8 = Convert.ToInt32(tbP2D.Text); int s4 = RetLbl(a7, a8); lbl4.Text = Convert.ToString(s4); int a9 = Convert.ToInt32(tbP5.Text); int a10 = Convert.ToInt32(tbP3D.Text); int s5 = RetLbl(a9, a10); lbl5.Text = Convert.ToString(s5); int a11 = Convert.ToInt32(tbP7.Text); int a12 = Convert.ToInt32(tbP4D.Text); int s6 = RetLbl(a11, a12); lbl6.Text = Convert.ToString(s6); int a13 = Convert.ToInt32(tbB1.Text); int a14 = Convert.ToInt32(tbB1D.Text); int s7 = RetLbl(a13, a14); lbl7.Text = Convert.ToString(s7); int a15 = Convert.ToInt32(tbB3.Text); int a16 = Convert.ToInt32(tbB2D.Text); int s8 = RetLbl(a15, a16); lbl8.Text = Convert.ToString(s8); int a17 = Convert.ToInt32(tbB5.Text); int a18 = Convert.ToInt32(tbB3D.Text); int s9 = RetLbl(a17, a18); lbl9.Text = Convert.ToString(s9); int a19 = Convert.ToInt32(tbB7.Text); int a20 = Convert.ToInt32(tbB4D.Text); int s10 = RetLbl(a19, a20); lbl10.Text = Convert.ToString(s10); int a21 = Convert.ToInt32(tbIPPeopAllP.Text); int a22 = Convert.ToInt32(tbIPPeopAllPD.Text); int s11 = RetLbl(a21, a22); lbl11.Text = Convert.ToString(s11); int a23 = Convert.ToInt32(tbIPPeopAllB.Text); int a24 = Convert.ToInt32(tbIPPeopAllBD.Text); int s12 = RetLbl(a23, a24); lbl12.Text = Convert.ToString(s12); int a25 = Convert.ToInt32(tbP2.Text); int a26 = Convert.ToInt32(tbPep1PD.Text); int s13 = RetLbl(a25, a26); lbl13.Text = Convert.ToString(s13); int a27 = Convert.ToInt32(tbP4.Text); int a28 = Convert.ToInt32(tbPep2PD.Text); int s14 = RetLbl(a27, a28); lbl14.Text = Convert.ToString(s14); int a29 = Convert.ToInt32(tbP6.Text); int a30 = Convert.ToInt32(tbPep3PD.Text); int s15 = RetLbl(a29, a30); lbl15.Text = Convert.ToString(s15); int a31 = Convert.ToInt32(tbP8.Text); int a32 = Convert.ToInt32(tbPep4PD.Text); int s16 = RetLbl(a31, a32); lbl16.Text = Convert.ToString(s16); int a33 = Convert.ToInt32(tbB2.Text); int a34 = Convert.ToInt32(tbPep1BD.Text); int s17 = RetLbl(a33, a34); lbl17.Text = Convert.ToString(s17); int a35 = Convert.ToInt32(tbB4.Text); int a36 = Convert.ToInt32(tbPep2BD.Text); int s18 = RetLbl(a35, a36); lbl18.Text = Convert.ToString(s18); int a37 = Convert.ToInt32(tbB6.Text); int a38 = Convert.ToInt32(tbPep3BD.Text); int s19 = RetLbl(a37, a38); lbl19.Text = Convert.ToString(s19); int a39 = Convert.ToInt32(tbB8.Text); int a40 = Convert.ToInt32(tbPep4BD.Text); int s20 = RetLbl(a39, a40); lbl20.Text = Convert.ToString(s20); int b1 = Convert.ToInt32(tbKDEventtAllP.Text); int b2 = Convert.ToInt32(tbKDEventtAllPD.Text); int s21 = RetLbl(b1, b2); lbl21.Text = Convert.ToString(s21); int b3 = Convert.ToInt32(tbKDEventtAllB.Text); int b4 = Convert.ToInt32(tbKDEventtAllBD.Text); int s22 = RetLbl(b3, b4); lbl22.Text = Convert.ToString(s22); int b5 = Convert.ToInt32(tbPP1.Text); int b6 = Convert.ToInt32(tbPP1D.Text); int s23 = RetLbl(b5, b6); lbl23.Text = Convert.ToString(s23); int b7 = Convert.ToInt32(tbPP3.Text); int b8 = Convert.ToInt32(tbPP2D.Text); int s24 = RetLbl(b7, b8); lbl24.Text = Convert.ToString(s24); int b9 = Convert.ToInt32(tbPP5.Text); int b10 = Convert.ToInt32(tbPP3D.Text); int s25 = RetLbl(b9, b10); lbl25.Text = Convert.ToString(s25); int b11 = Convert.ToInt32(tbPP7.Text); int b12 = Convert.ToInt32(tbPP4D.Text); int s26 = RetLbl(b11, b12); lbl26.Text = Convert.ToString(s26); int b13 = Convert.ToInt32(tbPPB1.Text); int b14 = Convert.ToInt32(tbBB1D.Text); int s27 = RetLbl(b13, b14); lbl27.Text = Convert.ToString(27); int b15 = Convert.ToInt32(tbPPB3.Text); int b16 = Convert.ToInt32(tbBB2D.Text); int s28 = RetLbl(b15, b16); lbl28.Text = Convert.ToString(s28); int b17 = Convert.ToInt32(tbPPB5.Text); int b18 = Convert.ToInt32(tbBB3D.Text); int s29 = RetLbl(b17, b18); lbl29.Text = Convert.ToString(s29); int b19 = Convert.ToInt32(tbPPB7.Text); int b20 = Convert.ToInt32(tbBB4D.Text); int s30 = RetLbl(b19, b20); lbl30.Text = Convert.ToString(s30); int b21 = Convert.ToInt32(tbKDPeopP.Text); int b22 = Convert.ToInt32(tbKDPeopPD.Text); int s31 = RetLbl(b21, b22); lbl31.Text = Convert.ToString(s31); int b23 = Convert.ToInt32(tbKDPeopB.Text); int b24 = Convert.ToInt32(tbKDPeopBD.Text); int s32 = RetLbl(b23, b24); lbl32.Text = Convert.ToString(s32); int b25 = Convert.ToInt32(tbPP2.Text); int b26 = Convert.ToInt32(tbPep1PPD.Text); int s33 = RetLbl(b25, b26); lbl33.Text = Convert.ToString(s33); int b27 = Convert.ToInt32(tbPP4.Text); int b28 = Convert.ToInt32(tbPep2PPD.Text); int s34 = RetLbl(b27, b28); lbl34.Text = Convert.ToString(s34); int b29 = Convert.ToInt32(tbPP6.Text); int b30 = Convert.ToInt32(tbPep3PPD.Text); int s35 = RetLbl(b29, b30); lbl35.Text = Convert.ToString(s35); int b31 = Convert.ToInt32(tbPP8.Text); int b32 = Convert.ToInt32(tbPep4PPD.Text); int s36 = RetLbl(b31, b32); lbl36.Text = Convert.ToString(s36); int b33 = Convert.ToInt32(tbPPB2.Text); int b34 = Convert.ToInt32(tbPep1BBD.Text); int s37 = RetLbl(b33, b34); lbl37.Text = Convert.ToString(s37); int b35 = Convert.ToInt32(tbPPB4.Text); int b36 = Convert.ToInt32(tbPep2BBD.Text); int s38 = RetLbl(b35, b36); lbl38.Text = Convert.ToString(s38); int b37 = Convert.ToInt32(tbPPB6.Text); int b38 = Convert.ToInt32(tbPep3BBD.Text); int s39 = RetLbl(b37, b38); lbl39.Text = Convert.ToString(s39); int b39 = Convert.ToInt32(tbPPB8.Text); int b40 = Convert.ToInt32(tbPep4BBD.Text); int s40 = RetLbl(b39, b40); lbl40.Text = Convert.ToString(s40); }
public void btnOk(int IdE, int[] EventUnit1, int[] EventQty1, int[] EventQty2) { if (cmbStatusEvent.Text != "" && cmbgr1.Text != "" && cmbgr2.Text != "" && cmbgr3.Text != "" && cmbgr4.Text != "" && cmbgr5.Text != "") { try { int IdU = EventUnit1[1]; int IdQ0 = Convert.ToInt32(EventQty1[0].ToString()); int IdQ1 = Convert.ToInt32(EventQty1[1].ToString()); int IdQ2 = Convert.ToInt32(EventQty1[2].ToString()); int IdQ3 = Convert.ToInt32(EventQty1[3].ToString()); int IdQ4 = Convert.ToInt32(EventQty1[4].ToString()); int IdQ5 = Convert.ToInt32(EventQty2[0].ToString()); int IdQ6 = Convert.ToInt32(EventQty2[1].ToString()); int IdQ7 = Convert.ToInt32(EventQty2[2].ToString()); int IdQ8 = Convert.ToInt32(EventQty2[3].ToString()); int IdQ9 = Convert.ToInt32(EventQty2[4].ToString()); int IdQ10 = Convert.ToInt32(EventQty2[5].ToString()); int IdQ11 = Convert.ToInt32(EventQty2[6].ToString()); int IdQ12 = Convert.ToInt32(EventQty2[7].ToString()); int IdQ13 = Convert.ToInt32(EventQty2[8].ToString()); int IdQ14 = Convert.ToInt32(EventQty2[9].ToString()); int IdQ15 = Convert.ToInt32(EventQty2[10].ToString()); int IdQ16 = Convert.ToInt32(EventQty2[11].ToString()); int IdQ17 = Convert.ToInt32(EventQty2[12].ToString()); int IdQ18 = Convert.ToInt32(EventQty2[13].ToString()); int IdQ19 = Convert.ToInt32(EventQty2[14].ToString()); int IdQ20 = Convert.ToInt32(EventQty2[15].ToString()); int IdQ21 = Convert.ToInt32(EventQty2[16].ToString()); int IdQ22 = Convert.ToInt32(EventQty2[17].ToString()); int IdQ23 = Convert.ToInt32(EventQty2[18].ToString()); int IdQ24 = Convert.ToInt32(EventQty2[19].ToString()); int IdQ25 = Convert.ToInt32(EventQty2[20].ToString()); int IdQ26 = Convert.ToInt32(EventQty2[21].ToString()); int IdQ27 = Convert.ToInt32(EventQty2[22].ToString()); int IdQ28 = Convert.ToInt32(EventQty2[23].ToString()); int IdQ29 = Convert.ToInt32(EventQty2[24].ToString()); if (cmbStatusEvent.Text.Length > 0) { ConnectSDO sdo = new ConnectSDO(); sqlcom = new SqlCommand("spUppEventt", sdo.getConnectSDO()); sqlcom.CommandType = CommandType.StoredProcedure; sqlcom.Parameters.AddWithValue("@Name", SqlDbType.NVarChar).Value = tbNameEvent.Text.Trim(); sqlcom.Parameters.AddWithValue("@Status", SqlDbType.Int).Value = cmbStatusEvent.Text.Trim(); sqlcom.Parameters.AddWithValue("@DateFirst", SqlDbType.Int).Value = mcEvent.SelectionRange.Start; sqlcom.Parameters.AddWithValue("@IdE", SqlDbType.Int).Value = IdE; sdo.OpenConnection(); sqlcom.ExecuteNonQuery(); sdo.CloseConnection(); } if (cmbStatusQtyEvent1.Text.Length > 0) { string NameU = cmbStatusQtyEvent1.Text.Trim(); int Idu = IdU; int Ide = IdE; spUnit(NameU, Idu, Ide); if (tbEventAllP.Text.Length >= 0) { string Name1 = lblEvent.Text; string NameCateg1 = cmbStatusQtyEvent1.Text.Trim(); string NameE1 = lblP.Text; int Qty1 = Int32.Parse(tbEventAllP.Text); int IdU1 = IdU; int Id0 = IdQ0; spQtyUnit(Name1, NameCateg1, NameE1, Qty1, IdU1, Id0); string Name2 = lblEvent.Text; string NameCateg2 = cmbStatusQtyEvent1.Text.Trim(); string NameE2 = lblB.Text; int Qty2 = Int32.Parse(tbEventAllB.Text); int IdU2 = IdU; int Id1 = IdQ1; spQtyUnit(Name2, NameCateg2, NameE2, Qty2, IdU2, Id1); string Name3 = lblPeople.Text; string NameCateg3 = cmbStatusQtyEvent1.Text.Trim(); string NameE3 = lblP.Text; int Qty3 = Int32.Parse(tbUnitAllP.Text); int IdU3 = IdU; int Id3 = IdQ2; spQtyUnit(Name3, NameCateg3, NameE3, Qty3, IdU3, Id3); string Name4 = lblPeople.Text; string NameCateg4 = cmbStatusQtyEvent1.Text.Trim(); string NameE4 = lblB.Text; int Qty4 = Int32.Parse(tbUnitAllB.Text); int IdU4 = IdU; int Id4 = IdQ3; spQtyUnit(Name4, NameCateg4, NameE4, Qty4, IdU4, Id4); string Name5 = lblParticial.Text; string NameCateg5 = cmbStatusQtyEvent1.Text.Trim(); string NameE5 = lblB.Text; int Qty5 = Int32.Parse(tbAllPlayer.Text); int IdU5 = IdU; int Id5 = IdQ4; spQtyUnit(Name5, NameCateg5, NameE5, Qty5, IdU5, Id5); } } if (cmbgr1.Text.Length > 0) { //string NameU2 = cmbgr1.Text.Trim(); int Idu = IdU; int Ide = IdE; //spUnit(NameU2, IdU, Ide); if (tbEvP1.Text.Length >= 0 && tbEvB1.Text.Length >= 0 && tbpgr1.Text.Length >= 0 && tbPBgr1.Text.Length >= 0) { string Name1 = lblEvent.Text; string NameCateg1 = cmbgr1.Text.Trim(); string NameE1 = lblP.Text; int Qty1 = Int32.Parse(tbEvP1.Text); int IdU1 = IdU; int Id1 = IdQ5; spQtyUnit(Name1, NameCateg1, NameE1, Qty1, IdU1, Id1); string Name2 = lblEvent.Text; string NameCateg2 = cmbgr1.Text.Trim(); string NameE2 = lblB.Text; int Qty2 = Int32.Parse(tbEvB1.Text); int IdU2 = IdU; int Id2 = IdQ6; spQtyUnit(Name2, NameCateg2, NameE2, Qty2, IdU2, Id2); string Name3 = lblPeople.Text; string NameCateg3 = cmbgr1.Text.Trim(); string NameE3 = lblP.Text; int Qty3 = Int32.Parse(tbpgr1.Text); int IdU3 = IdU; int Id3 = IdQ7; spQtyUnit(Name3, NameCateg3, NameE3, Qty3, IdU3, Id3); string Name4 = lblPeople.Text; string NameCateg4 = cmbgr1.Text.Trim(); string NameE4 = lblB.Text; int Qty4 = Int32.Parse(tbPBgr1.Text); int IdU4 = IdU; int Id4 = IdQ8; spQtyUnit(Name4, NameCateg4, NameE4, Qty4, IdU4, Id4); string Name5 = lblParticial.Text; string NameCateg5 = cmbgr1.Text.Trim(); string NameE5 = lblB.Text; int Qty5 = Int32.Parse(tbPlayer1.Text); int IdU5 = IdU; int Id5 = IdQ9; spQtyUnit(Name5, NameCateg5, NameE5, Qty5, IdU5, Id5); } } if (cmbgr2.Text.Length > 0) { //string NameU3 = cmbgr2.Text.Trim(); int Idu = IdU; int Ide = IdE; //spUnit(NameU3, IdU, Ide); if (tbEvP2.Text.Length >= 0 && tbEvB2.Text.Length >= 0 && tbpgr2.Text.Length >= 0 && tbPBgr2.Text.Length >= 0) { string Name1 = lblEvent.Text; string NameCateg1 = cmbgr2.Text.Trim(); string NameE1 = lblP.Text; int Qty1 = Int32.Parse(tbEvP2.Text); int IdU1 = IdU; int Id1 = IdQ10; spQtyUnit(Name1, NameCateg1, NameE1, Qty1, IdU1, Id1); string Name2 = lblEvent.Text; string NameCateg2 = cmbgr2.Text.Trim(); string NameE2 = lblB.Text; int Qty2 = Int32.Parse(tbEvB2.Text); int IdU2 = IdU; int Id2 = IdQ11; spQtyUnit(Name2, NameCateg2, NameE2, Qty2, IdU2, Id2); string Name3 = lblPeople.Text; string NameCateg3 = cmbgr2.Text.Trim(); string NameE3 = lblP.Text; int Qty3 = Int32.Parse(tbpgr2.Text); int IdU3 = IdU; int Id3 = IdQ12; spQtyUnit(Name3, NameCateg3, NameE3, Qty3, IdU3, Id3); string Name4 = lblPeople.Text; string NameCateg4 = cmbgr2.Text.Trim(); string NameE4 = lblB.Text; int Qty4 = Int32.Parse(tbPBgr2.Text); int IdU4 = IdU; int Id4 = IdQ13; spQtyUnit(Name4, NameCateg4, NameE4, Qty4, IdU4, Id4); string Name5 = lblParticial.Text; string NameCateg5 = cmbgr2.Text.Trim(); string NameE5 = lblB.Text; int Qty5 = Int32.Parse(tbPlayer2.Text); int IdU5 = IdU; int Id5 = IdQ14; spQtyUnit(Name5, NameCateg5, NameE5, Qty5, IdU5, Id5); } } if (cmbgr3.Text.Length > 0) { //string NameU4 = cmbgr3.Text.Trim(); int Idu = IdU; int Ide = IdE; //spUnit(NameU4, IdU, Ide); if (tbEvP3.Text.Length >= 0 && tbEvB3.Text.Length >= 0 && tbpgr3.Text.Length >= 0 && tbPBgr3.Text.Length >= 0) { string Name1 = lblEvent.Text; string NameCateg1 = cmbgr3.Text.Trim(); string NameE1 = lblP.Text; int Qty1 = Int32.Parse(tbEvP3.Text); int IdU1 = IdU; int Id1 = IdQ15; spQtyUnit(Name1, NameCateg1, NameE1, Qty1, IdU1, Id1); string Name2 = lblEvent.Text; string NameCateg2 = cmbgr3.Text.Trim(); string NameE2 = lblB.Text; int Qty2 = Int32.Parse(tbEvB3.Text); int IdU2 = IdU; int Id2 = IdQ16; spQtyUnit(Name2, NameCateg2, NameE2, Qty2, IdU2, Id2); string Name3 = lblPeople.Text; string NameCateg3 = cmbgr3.Text.Trim(); string NameE3 = lblP.Text; int Qty3 = Int32.Parse(tbpgr3.Text); int IdU3 = IdU; int Id3 = IdQ17; spQtyUnit(Name3, NameCateg3, NameE3, Qty3, IdU3, Id3); string Name4 = lblPeople.Text; string NameCateg4 = cmbgr3.Text.Trim(); string NameE4 = lblB.Text; int Qty4 = Int32.Parse(tbPBgr3.Text); int IdU4 = IdU; int Id4 = IdQ18; spQtyUnit(Name4, NameCateg4, NameE4, Qty4, IdU4, Id4); string Name5 = lblParticial.Text; string NameCateg5 = cmbgr3.Text.Trim(); string NameE5 = lblB.Text; int Qty5 = Int32.Parse(tbPlayer3.Text); int IdU5 = IdU; int Id5 = IdQ19; spQtyUnit(Name5, NameCateg5, NameE5, Qty5, IdU5, Id5); } } if (cmbgr4.Text.Length > 0) { //string NameU5 = cmbgr4.Text.Trim(); int Idu = IdU; int Ide = IdE; //spUnit(NameU5, IdU, Ide); if (tbEvP4.Text.Length >= 0 && tbEvB4.Text.Length >= 0 && tbpgr4.Text.Length >= 0 && tbPBgr4.Text.Length >= 0) { string Name1 = lblEvent.Text; string NameCateg1 = cmbgr4.Text.Trim(); string NameE1 = lblP.Text; int Qty1 = Int32.Parse(tbEvP4.Text); int IdU1 = IdU; int Id1 = IdQ20; spQtyUnit(Name1, NameCateg1, NameE1, Qty1, IdU1, Id1); string Name2 = lblEvent.Text; string NameCateg2 = cmbgr4.Text.Trim(); string NameE2 = lblB.Text; int Qty2 = Int32.Parse(tbEvB4.Text); int IdU2 = IdU; int Id2 = IdQ21; spQtyUnit(Name2, NameCateg2, NameE2, Qty2, IdU2, Id2); string Name3 = lblPeople.Text; string NameCateg3 = cmbgr4.Text.Trim(); string NameE3 = lblP.Text; int Qty3 = Int32.Parse(tbpgr4.Text); int IdU3 = IdU; int Id3 = IdQ22; spQtyUnit(Name3, NameCateg3, NameE3, Qty3, IdU3, Id3); string Name4 = lblPeople.Text; string NameCateg4 = cmbgr4.Text.Trim(); string NameE4 = lblB.Text; int Qty4 = Int32.Parse(tbPBgr4.Text); int IdU4 = IdU; int Id4 = IdQ23; spQtyUnit(Name4, NameCateg4, NameE4, Qty4, IdU4, Id4); string Name5 = lblParticial.Text; string NameCateg5 = cmbgr4.Text.Trim(); string NameE5 = lblB.Text; int Qty5 = Int32.Parse(tbPlayer4.Text); int IdU5 = IdU; int Id5 = IdQ24; spQtyUnit(Name5, NameCateg5, NameE5, Qty5, IdU5, Id5); } } if (cmbgr5.Text.Length > 0) { //string NameU5 = cmbgr5.Text.Trim(); int Idu = IdU; int Ide = IdE; //spUnit(NameU5, IdU, Ide); if (tbEvP5.Text.Length >= 0 && tbEvB5.Text.Length >= 0 && tbpgr5.Text.Length >= 0 && tbPBgr5.Text.Length >= 0) { string Name1 = lblEvent.Text; string NameCateg1 = cmbgr5.Text.Trim(); string NameE1 = lblP.Text; int Qty1 = Int32.Parse(tbEvP5.Text); int IdU1 = IdU; int Id1 = IdQ25; spQtyUnit(Name1, NameCateg1, NameE1, Qty1, IdU1, Id1); string Name2 = lblEvent.Text; string NameCateg2 = cmbgr5.Text.Trim(); string NameE2 = lblB.Text; int Qty2 = Int32.Parse(tbEvB5.Text); int IdU2 = IdU; int Id2 = IdQ26; spQtyUnit(Name2, NameCateg2, NameE2, Qty2, IdU2, Id2); string Name3 = lblPeople.Text; string NameCateg3 = cmbgr5.Text.Trim(); string NameE3 = lblP.Text; int Qty3 = Int32.Parse(tbpgr5.Text); int IdU3 = IdU; int Id3 = IdQ27; spQtyUnit(Name3, NameCateg3, NameE3, Qty3, IdU3, Id3); string Name4 = lblPeople.Text; string NameCateg4 = cmbgr5.Text.Trim(); string NameE4 = lblB.Text; int Qty4 = Int32.Parse(tbPBgr5.Text); int IdU4 = IdU; int Id4 = IdQ28; spQtyUnit(Name4, NameCateg4, NameE4, Qty4, IdU4, Id4); string Name5 = lblParticial.Text; string NameCateg5 = cmbgr5.Text.Trim(); string NameE5 = lblB.Text; int Qty5 = Int32.Parse(tbPlayer5.Text); int IdU5 = IdU; int Id5 = IdQ29; spQtyUnit(Name5, NameCateg5, NameE5, Qty5, IdU5, Id5); } } MessageBox.Show("Mероприятие изменено!"); this.Hide(); } catch (Exception) { MessageBox.Show("Не удалось обновить данные!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Заполните все поля!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Information); } }