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("Все данные загружены в БД!");
}
}
