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; } } }
private void B_import_Click(object sender, EventArgs e) { if (cb_dep.SelectedItem.ToString() == "") { MessageBox.Show("Для импорта данных, требуется выбрать базовое подразделение, куда они будут загружены!"); } else { int idPerson = 0; progressBar1.Value = 0; progressBar1.Maximum = dgv2.Rows.Count; for (int i = 0; i < dgv2.Rows.Count; i++) { string ssp = ""; string ssv = ""; idDep = (int)cb_dep.SelectedValue; if (dgv2.Rows[i].Cells[1].Value.ToString().Trim() != "") { ssp = dgv2.Rows[i].Cells[1].Value.ToString().Trim(); ProfDataSet.DepartmentsDataTable ddt = new ProfDataSet.DepartmentsDataTable(); departmentsTableAdapter1.FillByFullName(ddt, ssp); if (ddt.Rows.Count == 0) { ProfDataSet.DepartmentsRow dr = ddt.NewDepartmentsRow(); dr.idParent = idDep; dr.fullName = ssp; dr.shortName = ssp; departmentsTableAdapter1.Update(dr); idDep = dr.id; } else { idDep = (int)ddt.Rows[0]["id"]; } } if (dgv2.Rows[i].Cells[2].Value.ToString().Trim() != "") { ssv = dgv2.Rows[i].Cells[2].Value.ToString().Trim(); ProfDataSet.DepartmentsDataTable ddt = new ProfDataSet.DepartmentsDataTable(); departmentsTableAdapter1.FillByFullName(ddt, ssp); if (ddt.Rows.Count == 0) { ProfDataSet.DepartmentsRow dr = ddt.NewDepartmentsRow(); dr.idParent = idDep; dr.fullName = ssv; dr.shortName = ssv; departmentsTableAdapter1.Update(dr); idDep = dr.id; } else { idDep = (int)ddt.Rows[0]["id"]; } } string fam = cryptoStr(dgv2.Rows[i].Cells[3].Value.ToString().Trim()); string nam = cryptoStr(dgv2.Rows[i].Cells[4].Value.ToString().Trim()); string otc = cryptoStr(dgv2.Rows[i].Cells[5].Value.ToString().Trim()); string pn = dgv2.Rows[i].Cells[9].Value.ToString().Trim(); DateTime dt = DateTime.Parse(dgv2.Rows[i].Cells[7].Value.ToString().Trim()); ProfDataSet.PeopleDataTable pdt = new ProfDataSet.PeopleDataTable(); peopleTableAdapter1.FillByFIO(pdt, fam, nam, otc, pn); if (pdt.Rows.Count == 0) { ProfDataSet.PeopleRow p = pdt.NewPeopleRow(); p.famil = cryptoStr(dgv2.Rows[i].Cells[3].Value.ToString().Trim()); p.name = cryptoStr(dgv2.Rows[i].Cells[4].Value.ToString().Trim()); p.otch = cryptoStr(dgv2.Rows[i].Cells[5].Value.ToString().Trim()); p.gender = dgv2.Rows[i].Cells[6].Value.ToString().Trim() != "" ? dgv2.Rows[i].Cells[6].Value.ToString().Trim() : "Муж"; p.birthday = dgv2.Rows[i].Cells[7].Value.ToString().Trim() != "" ? DateTime.Parse(dgv2.Rows[i].Cells[7].Value.ToString().Trim()) : DateTime.Parse("01.01.1970"); p.phone = cryptoStr(dgv2.Rows[i].Cells[8].Value.ToString().Trim()); p.numProfTicket = dgv2.Rows[i].Cells[9].Value.ToString().Trim(); p.dateEnter = dgv2.Rows[i].Cells[10].Value.ToString().Trim() != "" ? DateTime.Parse(dgv2.Rows[i].Cells[10].Value.ToString().Trim()) : DateTime.Parse("01.01.1970"); p.isPensioner = (bool)dgv2.Rows[i].Cells[11].Value ? "T" : "F"; p.startTrudYearStr = dgv2.Rows[i].Cells[12].Value.ToString().Trim() != "" ? dgv2.Rows[i].Cells[12].Value.ToString().Trim() : ""; p.typeDoc = cryptoStr(dgv2.Rows[i].Cells[13].Value.ToString().Trim()); p.pasp_ser = cryptoStr(dgv2.Rows[i].Cells[14].Value.ToString().Trim()); p.pasp_num = cryptoStr(dgv2.Rows[i].Cells[15].Value.ToString().Trim()); p.pasp_date = dgv2.Rows[i].Cells[16].Value.ToString().Trim() != "" ? DateTime.Parse(dgv2.Rows[i].Cells[16].Value.ToString().Trim()) : DateTime.Parse("01.01.1970"); p.pasp_issue = cryptoStr(dgv2.Rows[i].Cells[17].Value.ToString().Trim()); p.propiska = cryptoStr(dgv2.Rows[i].Cells[18].Value.ToString().Trim()); p.activity = dgv2.Rows[i].Cells[19].Value.ToString().Trim(); p.socialWork = dgv2.Rows[i].Cells[20].Value.ToString().Trim(); p.hobbies = dgv2.Rows[i].Cells[21].Value.ToString().Trim(); p.type = rb_w.Checked ? "W" : rb_s.Checked ? "S" : ""; p.isProf = "T"; p.dateExit = DateTime.Parse("01.01.1970"); peopleTableAdapter1.Update(p); idPerson = p.id; peopleDepartmentTableAdapter1.Insert(idPerson, idDep, DateTime.Now); } progressBar1.Value++; } MessageBox.Show("Все данные загружены в БД!"); } }