//поиск по ид. номеру
private void tbPersonNumber_TextChanged(object sender, EventArgs e)
{
try
{
WinFormsServ.Search(this.dgvAbitList, "Ид_номер", tbPersonNumber.Text);
}
catch
{
}
}
//поиск по фио
private void tbFIO_TextChanged(object sender, EventArgs e)
{
try
{
WinFormsServ.Search(this.dgvAbitList, "ФИО", tbFIO.Text);
}
catch
{
try
{
WinFormsServ.Search(this.dgvAbitList, "Фамилия", tbFIO.Text);
}
catch
{
}
}
}
//поле поиска
private void tbSearch_TextChanged(object sender, EventArgs e)
{
WinFormsServ.Search(this.dgvAbiturients, "FIO", tbSearch.Text);
}
private void tbNumber_TextChanged(object sender, EventArgs e)
{
WinFormsServ.Search(this.dgvAbiturients, "PersonNum", tbNumber.Text);
}
private void btnLoad_Click(object sender, EventArgs e)
{
loadClass = new LoadFromInet();
bdcInet = loadClass.BDCInet;
int fileNum = 0;
string barcText = tbPersonNum.Text.Trim();
if (barcText == string.Empty)
{
WinFormsServ.Error("Не введен номер");
return;
}
//if (barcText.Length == 7)
//{
// if (barcText.StartsWith("2"))
// {
// WinFormsServ.Error("Выбран человек, подавший заявления в магистратуру");
// return;
// }
// barcText = barcText.Substring(1);
//}
if (!int.TryParse(barcText, out fileNum))
{
WinFormsServ.Error("Неправильно введен номер");
return;
}
if (MainClass.CheckPersonBarcode(fileNum))
{
try
{
//extPerson person = loadClass.GetPersonByBarcode(fileNum);
DataTable dtEge = new DataTable();
//if(person != null)
//{
// string queryEge = "SELECT EgeMark.Id, EgeMark.EgeExamNameId AS ExamId, EgeMark.Value, EgeCertificate.PrintNumber, EgeCertificate.Number, EgeMark.EgeCertificateId FROM EgeMark LEFT JOIN EgeCertificate ON EgeMark.EgeCertificateId = EgeCertificate.Id LEFT JOIN Person ON EgeCertificate.PersonId = Person.Id";
// DataSet dsEge = bdcInet.GetDataSet(queryEge + " WHERE Person.Barcode = " + fileNum + " ORDER BY EgeMark.EgeCertificateId ");
// dtEge = dsEge.Tables[0];
//}
CardFromInet crd = new CardFromInet(fileNum, null, true);
crd.ToUpdateList += UpdateDataGrid;
crd.Show();
}
catch (Exception exc)
{
WinFormsServ.Error(exc.Message);
tbPersonNum.Text = "";
tbPersonNum.Focus();
}
}
else
{
UpdateDataGrid();
using (PriemEntities context = new PriemEntities())
{
extPersonAll person = (from per in context.extPersonAll
where per.Barcode == fileNum
select per).FirstOrDefault();
string fio = person.FIO;
string num = person.PersonNum;
string persId = person.Id.ToString();
WinFormsServ.Search(this.dgvAbiturients, "PersonNum", num);
DialogResult dr = MessageBox.Show(string.Format("Абитуриент {0} с данным номером баркода уже импортирован в базу.\nОткрыть карточку абитуриента?", fio), "Внимание", MessageBoxButtons.YesNo);
if (dr == System.Windows.Forms.DialogResult.Yes)
{
MainClass.OpenCardPerson(persId, this, null);
}
}
}
tbPersonNum.Text = "";
tbPersonNum.Focus();
loadClass.CloseDB();
}
//поиск по номеру
private void tbNumber_TextChanged(object sender, EventArgs e)
{
WinFormsServ.Search(this.dgvAbitList, "Рег_Номер", tbNumber.Text);
}
private void tbFIO_TextChanged(object sender, EventArgs e)
{
WinFormsServ.Search(this.dgvAbits, "ФИО", tbFIO.Text);
}
