protected override void OnClosed() { loadClass.CloseDB(); }
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 ApplicationInetList_FormClosing(object sender, FormClosingEventArgs e) { loadClass.CloseDB(); }