private void DgvCHILD_KeyDown(object sender, KeyEventArgs e) { try { if (e.KeyCode == Keys.Delete && insert == false) { if (MessageBox.Show("Вы действительно хотите удалить данную запись?", "Удаление выделенной записи", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { DeleteClass.deleteChild(client_id, int.Parse(dgvCHILD.CurrentRow.Cells[0].Value.ToString()), tbSCERTIF.Text + " " + tbNCERTIF.Text); if (BQNT - 1 == 0) { tbBQNT.Text = "0"; } else { tbBQNT.Text = string.Format("{0}", BQNT - 1); } FuncMINIUpdateMother(); dgvCHILD.AutoGenerateColumns = false; dgvCHILD.DataSource = null; dgvCHILD.DataSource = InsertUpdateClass.FuncChildUPD(client_id, tbSCERTIF.Text + " " + tbNCERTIF.Text); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); logger.Debug("\n/--------------------------------------------------------------------/\n" + ex.StackTrace + "\n//----------------------------//\n" + ex.Message + "\n\n"); } }
private void AddPatient_Load(object sender, EventArgs e) { try { cbTypeDoc.DataSource = docName; dgvCHILD.AutoGenerateColumns = false; dgvCHILD.DataSource = Child; if (insert == true) { woman = LoadClass.FuncINSRT(client_id); tbLNAME.Text = woman.Rows[0][0].ToString(); tbFNAME.Text = woman.Rows[0][1].ToString(); tbMNAME.Text = woman.Rows[0][2].ToString(); dateBDATE.Value = DateTime.Parse(woman.Rows[0][3].ToString()); tbADDRESS.Text = woman.Rows[0][4].ToString(); tbSNILS.Text = woman.Rows[0][5].ToString(); tbSPOLICY.Text = woman.Rows[0][6].ToString(); tbNPOLICY.Text = woman.Rows[0][7].ToString(); cbTypeDoc.SelectedIndex = int.Parse(woman.Rows[0][8].ToString()); tbSDOC.Text = woman.Rows[0][9].ToString(); tbNDOC.Text = woman.Rows[0][10].ToString(); dateDDOC.Value = DateTime.Parse(woman.Rows[0][11].ToString()); tbODOC.Text = woman.Rows[0][12].ToString(); tbSCERTIF.Text = woman.Rows[0][13].ToString(); tbNCERTIF.Text = woman.Rows[0][14].ToString(); dateDCERTIF.Value = DateTime.Parse(woman.Rows[0][15].ToString()); tbSLEAF.Text = woman.Rows[0][16].ToString(); tbNLEAF.Text = woman.Rows[0][17].ToString(); dateDLEAF.Value = DateTime.Parse(woman.Rows[0][18].ToString()); } else { forTableUPD = InsertUpdateClass.FuncMotherUPD(client_id); dateDREG.Value = DateTime.Parse(forTableUPD.Rows[0][0].ToString()); tbDIAG.Text = forTableUPD.Rows[0][1].ToString(); tbBQNT.Text = forTableUPD.Rows[0][2].ToString(); tbLNAME.Text = forTableUPD.Rows[0][3].ToString(); tbFNAME.Text = forTableUPD.Rows[0][4].ToString(); tbMNAME.Text = forTableUPD.Rows[0][5].ToString(); dateBDATE.Value = DateTime.Parse(forTableUPD.Rows[0][6].ToString()); tbADDRESS.Text = forTableUPD.Rows[0][7].ToString(); tbSNILS.Text = forTableUPD.Rows[0][8].ToString(); tbSPOLICY.Text = forTableUPD.Rows[0][9].ToString(); tbNPOLICY.Text = forTableUPD.Rows[0][10].ToString(); cbTypeDoc.SelectedIndex = int.Parse(forTableUPD.Rows[0][11].ToString()); tbSDOC.Text = forTableUPD.Rows[0][12].ToString(); tbNDOC.Text = forTableUPD.Rows[0][13].ToString(); dateDDOC.Value = DateTime.Parse(forTableUPD.Rows[0][14].ToString()); tbODOC.Text = forTableUPD.Rows[0][15].ToString(); tbSCERTIF.Text = forTableUPD.Rows[0][16].ToString(); tbNCERTIF.Text = forTableUPD.Rows[0][17].ToString(); dateDCERTIF.Value = DateTime.Parse(forTableUPD.Rows[0][18].ToString()); tbSLEAF.Text = forTableUPD.Rows[0][19].ToString(); tbNLEAF.Text = forTableUPD.Rows[0][20].ToString(); dateDLEAF.Value = DateTime.Parse(forTableUPD.Rows[0][21].ToString()); tbNCARD.Text = forTableUPD.Rows[0][22].ToString(); dateDCARD.Value = DateTime.Parse(forTableUPD.Rows[0][23].ToString()); BQNT = int.Parse(tbBQNT.Text); Child = InsertUpdateClass.FuncChildUPD(client_id, tbSCERTIF.Text + " " + tbNCERTIF.Text); dgvCHILD.DataSource = Child; AddCNTChild = dgvCHILD.Rows.Count; oldCertif = $"{tbSCERTIF.Text + " " + tbNCERTIF.Text}"; this.Text = "Редактирование записи"; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); logger.Debug("\n/--------------------------------------------------------------------/\n" + ex.StackTrace + "\n//----------------------------//\n" + ex.Message + "\n\n"); } }