private void b_delete_Click(object sender, EventArgs e) { if (idDep > 0) { ProfDataSet.DepartmentsDataTable dt = new ProfDataSet.DepartmentsDataTable(); departmentsTableAdapter1.FillByDepChild(dt, idDep); ProfDataSet.PeopleDepartmentDataTable dtp = new ProfDataSet.PeopleDepartmentDataTable(); peopleDepartmentTableAdapter1.FillByDep(dtp, idDep); int childDep = dt.Rows.Count; int countPeople = dtp.Rows.Count; if (childDep == 0) { if (countPeople == 0) { departmentsTableAdapter1.DeleteByDep(idDep); MessageBox.Show("Информация удалена!"); loadDepartmentsGrid(); } else { MessageBox.Show("Вы не можете удалить данное подразделение, т.к. у него есть члены профсоюза!"); } } else { MessageBox.Show("Вы не можете удалить данное подразделение, т.к. у него есть дочерние подразделения!"); } } else { MessageBox.Show("Не выбрано подразделение!"); } }
private void loadPeople(int idDepart) { cb_people.Enabled = false; dgv.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Raised; dgv.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; ProfDataSet.PeopleDepartmentDataTable dt = new ProfDataSet.PeopleDepartmentDataTable(); peopleDepartmentTableAdapter1.FillByDep(dt, idDepart); DataTable dt_n = new DataTable(); dt_n.Columns.Add("id", typeof(int)); dt_n.Columns.Add("fio", typeof(string)); foreach (DataRow dr in dt.Rows) { DataRow dr_n = dt_n.NewRow(); dr_n["id"] = dr["pid"]; dr_n["fio"] = $"{decryptoStr(dr["famil"].ToString())} {decryptoStr(dr["name"].ToString())} {decryptoStr(dr["otch"].ToString())}"; dt_n.Rows.Add(dr_n); } cb_people.DataSource = dt_n; cb_people.DisplayMember = "fio"; cb_people.ValueMember = "id"; cb_people.Enabled = true; }
private void b_search_Click(object sender, EventArgs e) { ProfDataSet.PeopleDataTable dtPeople = new ProfDataSet.PeopleDataTable(); peopleTableAdapter1.Fill(dtPeople); dgv.Rows.Clear(); if (dtPeople.Rows.Count != 0) { int i = 0; foreach (DataRow pers in dtPeople.Rows) { if (decryptoStr(pers["famil"].ToString()).ToLower().StartsWith(tb_search.Text.Trim().ToLower())) { ProfDataSet.PeopleDepartmentDataTable dtDep = new ProfDataSet.PeopleDepartmentDataTable(); peopleDepartmentTableAdapter1.FillByPers(dtDep, (int)pers["id"]); if (!dtDep.Rows[0].IsNull("idDepartment")) { dgv.Rows.Add(); ProfDataSet.PeopleWorkDataTable dtWork = new ProfDataSet.PeopleWorkDataTable(); peopleWorkTableAdapter1.FillByPeopleId(dtWork, (int)pers["id"]); DataRow dr = dtWork.FirstOrDefault(p => p.isActual == "T" && p.isWorked == "T"); string workPlace = ""; string doljn = ""; if (dr != null) { workPlace = dr["workPlace"].ToString(); doljn = dr["doljn"].ToString(); } dgv[0, i].Value = (int)pers["id"]; dgv[1, i].Value = decryptoStr(pers["famil"].ToString()) + " " + decryptoStr(pers["name"].ToString()) + " " + decryptoStr(pers["otch"].ToString()); dgv[2, i].Value = workPlace; dgv[3, i].Value = doljn; i++; } } } if (i == 0) { b_move.Visible = false; MessageBox.Show("Не найден!"); } else { b_move.Visible = true; } } }