public qAbiturient GetAbitByBarcode(int fileNum)
{
try
{
string abitQueryInet = @"SELECT qAbiturient.Barcode, EntryId, qAbiturient.HostelEduc,
(Case when qAbiturient.Enabled = 1 then 0 else 1 end) AS BackDoc,
qAbiturient.DateOfDisable AS BackDocDate, qAbiturient.DateOfStart AS DocDate,
qAbiturient.Priority, qAbiturient.LicenseProgramId, qAbiturient.ObrazProgramId,
qAbiturient.ProfileId, qAbiturient.FacultyId, qAbiturient.StudyFormId,
qAbiturient.StudyBasisId, qAbiturient.IsSecond,
qAbiturient.IsGosLine, qAbiturient.CommitId, qAbiturient.CommitNumber
FROM qAbiturient WHERE 0=0";
DataSet ds = _bdcInet.GetDataSet(abitQueryInet + " AND qAbiturient.Barcode = " + fileNum);
if (ds.Tables[0].Rows.Count == 0)
{
throw new Exception("Записей не найдено");
}
DataRow row = ds.Tables[0].Rows[0];
qAbiturient abit = new qAbiturient();
abit.IsSecond = (bool)row["IsSecond"];
abit.EntryId = (Guid)row["EntryId"];
abit.CommitId = (Guid)row["CommitId"];
abit.CommitNumber = (int?)row["CommitNumber"];
abit.FacultyId = (int)row["FacultyId"];
abit.LicenseProgramId = (int)row["LicenseProgramId"];
abit.ObrazProgramId = (int)row["ObrazProgramId"];
abit.ProfileId = (Guid?)(Util.ToNullObject(row["ProfileId"]));
abit.StudyFormId = (int)row["StudyFormId"];
abit.StudyBasisId = (int)row["StudyBasisId"];
abit.IsGosLine = QueryServ.ToBoolValue(row["IsGosLine"]);
abit.BackDoc = QueryServ.ToBoolValue(row["BackDoc"]);
abit.BackDocDate = row.Field <DateTime?>("BackDocDate");
abit.DocDate = (DateTime)row["DocDate"];
int prior;
if (!int.TryParse(row["Priority"].ToString(), out prior))
{
abit.Priority = null;
}
else
{
abit.Priority = prior;
}
abit.Barcode = int.Parse(row["Barcode"].ToString());
return(abit);
}
catch
{
return(null);
}
}
private Dictionary <int, ChangeAbitClass> GetAbitList(DataSet dsAbits)
{
Dictionary <int, ChangeAbitClass> abits = (from dr in dsAbits.Tables[0].AsEnumerable()
select new
{
key = dr.Field <int>("Barcode"),
val = new ChangeAbitClass(
dr.Field <int>("Barcode"),
dr.Field <string>("Priority"),
QueryServ.ToBoolValue(dr.Field <int>("BackDoc"))
)
}).ToDictionary(n => n.key, n => n.val);
return(abits);
}
private void GetFilters(ref IQueryable <qEntry> query)
{
using (PriemEntities context = new PriemEntities())
{
// Факультеты
if (cbFaculty.SelectedValue.ToString() != ComboServ.ALL_VALUE)
{
int?h = ComboServ.GetComboIdInt(cbFaculty);
if (h != null)
{
query = query.Where(c => c.FacultyId == h);
}
}
// основа обучения
if (cbStudyBasis.SelectedValue.ToString() != ComboServ.ALL_VALUE)
{
int?h = ComboServ.GetComboIdInt(cbStudyBasis);
if (h != null)
{
query = query.Where(c => c.StudyBasisId == h);
}
}
// форма обучения
if (cbStudyForm.SelectedValue.ToString() != ComboServ.ALL_VALUE)
{
int?h = ComboServ.GetComboIdInt(cbStudyForm);
if (h != null)
{
query = query.Where(c => c.StudyFormId == h);
}
}
// подвид программы
if (cbStudyLevel.SelectedValue.ToString() != ComboServ.ALL_VALUE)
{
int?h = ComboServ.GetComboIdInt(cbStudyLevel);
if (h != null)
{
query = query.Where(c => c.StudyLevelId == h);
}
}
// ускоренная
if (cbIsReduced.SelectedValue.ToString() != ComboServ.ALL_VALUE)
{
bool h = QueryServ.ToBoolValue(ComboServ.GetComboIdInt(cbIsReduced));
query = query.Where(c => c.IsReduced == h);
}
// параллельная
if (cbIsParallel.SelectedValue.ToString() != ComboServ.ALL_VALUE)
{
bool h = QueryServ.ToBoolValue(ComboServ.GetComboIdInt(cbIsParallel));
query = query.Where(c => c.IsParallel == h);
}
// для лиц с во
if (cbIsSecond.SelectedValue.ToString() != ComboServ.ALL_VALUE)
{
bool h = QueryServ.ToBoolValue(ComboServ.GetComboIdInt(cbIsSecond));
query = query.Where(c => c.IsSecond == h);
}
}
}
public extPersonAll GetPersonByBarcode(int fileNum)
{
try
{
string personQueryInet =
@"SELECT Id, Barcode, Name, SecondName, Surname, BirthDate, BirthPlace, Sex,
PassportTypeId, PassportSeries, PassportNumber, PassportAuthor, PassportDate,
PassportCode, '' AS PersonalCode, CountryId, NationalityId AS NationalityId, RegionId, Phone, Mobiles, Email,
Code, City, Street, House, Korpus, Flat,
CodeReal, CityReal, StreetReal, HouseReal, KorpusReal, FlatReal,
HostelAbit, HostelEduc, LanguageId,
SchoolCity, SchoolTypeId, SchoolName, SchoolNum, SchoolExitYear, IsExcellent,
CountryEducId, RegionEducId, AttestatRegion, AttestatSeries, AttestatNumber,
EducationDocumentSeries AS DiplomSeries, EducationDocumentNumber AS DiplomNum, AvgMark AS SchoolAVG,
(case when SchoolTypeId=1 then '' else SchoolName end) AS HighEducation, HEProfession AS HEProfession,
HEQualification AS HEQualification, DiplomaTheme AS HEWork,
EducationStart AS HEEntryYear, HEExitYear, HEStudyFormId, Parents AS PersonInfo, AddInfo AS ExtraInfo,
IsEqual, EqualDocumentNumber, HasTRKI, TRKICertificateNumber,
EnglishMark, StartEnglish
FROM extForeignPerson
WHERE 0=0";
DataSet ds = _bdcInet.GetDataSet(personQueryInet + " AND extForeignPerson.Barcode = " + fileNum);
if (ds.Tables[0].Rows.Count == 0)
{
throw new Exception("Записей не найдено");
}
DataRow row = ds.Tables[0].Rows[0];
extPersonAll pers = new extPersonAll();
pers.Id = (Guid)row["Id"];
pers.Barcode = (int?)row["Barcode"];
pers.FIO = Util.GetFIO(row["Surname"].ToString(), row["Name"].ToString(), row["SecondName"].ToString());
pers.Name = row["Name"].ToString();
pers.SecondName = row["SecondName"].ToString();
pers.Surname = row["Surname"].ToString();
pers.BirthDate = row.Field <DateTime?>("BirthDate") ?? DateTime.Now.Date;
pers.BirthPlace = row["BirthPlace"].ToString();
pers.PassportTypeId = (int)(row["PassportTypeId"]);
pers.PassportSeries = row["PassportSeries"].ToString();
pers.PassportNumber = row["PassportNumber"].ToString();
pers.PassportAuthor = row["PassportAuthor"].ToString();
pers.PassportDate = QueryServ.ToNullDateTimeValue(row["PassportDate"]);
pers.PassportCode = row["PassportCode"].ToString();
pers.PersonalCode = row["PersonalCode"].ToString();
pers.Sex = QueryServ.ToBoolValue(row["Sex"]);
pers.ForeignCountryId = (int?)(Util.ToNullObject(row["CountryId"]));
pers.ForeignNationalityId = (int)(row["NationalityId"]);
pers.RegionId = (int?)(Util.ToNullObject(row["RegionId"]));
pers.Phone = row["Phone"].ToString();
pers.Mobiles = row["Mobiles"].ToString();
pers.Email = row["Email"].ToString();
pers.Code = row["Code"].ToString();
pers.City = row["City"].ToString();
pers.Street = row["Street"].ToString();
pers.House = row["House"].ToString();
pers.Korpus = row["Korpus"].ToString();
pers.Flat = row["Flat"].ToString();
pers.CodeReal = row["CodeReal"].ToString();
pers.CityReal = row["CityReal"].ToString();
pers.StreetReal = row["StreetReal"].ToString();
pers.HouseReal = row["HouseReal"].ToString();
pers.KorpusReal = row["KorpusReal"].ToString();
pers.FlatReal = row["FlatReal"].ToString();
pers.HostelAbit = QueryServ.ToBoolValue(row["HostelAbit"]);
pers.HostelEduc = QueryServ.ToBoolValue(row["HostelEduc"]);
pers.IsEqual = QueryServ.ToBoolValue(row["IsEqual"]);
pers.HasTRKI = QueryServ.ToBoolValue(row["HasTRKI"]);
pers.EqualDocumentNumber = row["EqualDocumentNumber"].ToString();
pers.TRKICertificateNumber = row["TRKICertificateNumber"].ToString();
pers.HasAssignToHostel = false;
pers.HasExamPass = false;
pers.IsExcellent = QueryServ.ToBoolValue(row["IsExcellent"]);
pers.LanguageId = (int?)(Util.ToNullObject(row["LanguageId"]));
pers.SchoolCity = row["SchoolCity"].ToString();
pers.SchoolTypeId = (int?)(Util.ToNullObject(row["SchoolTypeId"]));
pers.SchoolName = row["SchoolName"].ToString();
pers.SchoolNum = row["SchoolNum"].ToString();
int SchoolExitYear = 0;
int.TryParse(row["SchoolExitYear"].ToString(), out SchoolExitYear);
pers.SchoolExitYear = SchoolExitYear;
pers.ForeignCountryEducId = (int?)(Util.ToNullObject(row["CountryEducId"]));
pers.RegionEducId = (int?)(Util.ToNullObject(row["RegionEducId"]));
pers.AttestatRegion = row["AttestatRegion"].ToString();
pers.AttestatSeries = row["AttestatSeries"].ToString();
pers.AttestatNum = row["AttestatNumber"].ToString();
pers.DiplomSeries = row["DiplomSeries"].ToString();
pers.DiplomNum = row["DiplomNum"].ToString();
pers.StartEnglish = QueryServ.ToBoolValue(row["StartEnglish"]);
int EnglishMark = 0;
int.TryParse(row["EnglishMark"].ToString(), out EnglishMark);
pers.EnglishMark = EnglishMark == 0 ? null : (int?)EnglishMark;
double avg;
if (!double.TryParse(row["SchoolAVG"].ToString(), out avg))
{
pers.SchoolAVG = null;
}
else
{
pers.SchoolAVG = avg;
}
pers.HighEducation = row["HighEducation"].ToString();
pers.HEProfession = row["HEProfession"].ToString();
pers.HEQualification = row["HEQualification"].ToString();
pers.HEEntryYear = (int?)(Util.ToNullObject(row["HEEntryYear"]));
pers.HEExitYear = (int?)(Util.ToNullObject(row["HEExitYear"]));
pers.HEStudyFormId = (int?)(Util.ToNullObject(row["HEStudyFormId"]));
pers.HEWork = row["HEWork"].ToString();
pers.PersonInfo = row["PersonInfo"].ToString();
pers.ExtraInfo = row["ExtraInfo"].ToString();
DataSet dsWork = _bdcInet.GetDataSet(string.Format(@"
SELECT PersonWork.WorkPlace + ', ' + PersonWork.WorkProfession + ', ' + PersonWork.WorkSpecifications + ' стаж: ' + PersonWork.Stage AS Work,
PersonWork.WorkPlace + ', ' + PersonWork.WorkProfession + ', ' + PersonWork.WorkSpecifications AS Place, PersonWork.Stage
FROM PersonWork WHERE PersonWork.PersonId = '{0}'", pers.Id));
if (dsWork.Tables[0].Rows.Count == 0)
{
pers.Stag = string.Empty;
pers.WorkPlace = string.Empty;
}
else if (dsWork.Tables[0].Rows.Count == 1)
{
pers.Stag = dsWork.Tables[0].Rows[0]["Stage"].ToString();
pers.WorkPlace = dsWork.Tables[0].Rows[0]["Place"].ToString();
}
else
{
string work = string.Empty;
foreach (DataRow dr in dsWork.Tables[0].Rows)
{
work += dr["Work"].ToString() + ";" + Environment.NewLine;
}
pers.WorkPlace = work;
}
DataSet dsScienceWork = _bdcInet.GetDataSet(string.Format(@"
SELECT ScienceWorkType.Name + ': ' + PersonScienceWork.WorkInfo AS ScienseWork
FROM PersonScienceWork LEFT JOIN ScienceWorkType ON PersonScienceWork.WorkTypeId = ScienceWorkType.Id WHERE PersonScienceWork.PersonId = '{0}'", pers.Id));
if (dsScienceWork.Tables[0].Rows.Count == 0)
{
pers.ScienceWork = string.Empty;
}
else
{
string work = string.Empty;
foreach (DataRow dr in dsScienceWork.Tables[0].Rows)
{
work += dr["ScienseWork"].ToString() + ";" + Environment.NewLine;
}
pers.ScienceWork = work;
}
return(pers);
}
catch
{
return(null);
}
}
