public Family(string ID)
{
connection StaffConnectuon = new connection();
SqlDataReader myReader = StaffConnectuon.select("*", "[Состав семьи]", "[Код семьи] =" + ID);
while (myReader.Read()) {
IDFamily = Convert.ToInt32(myReader[0].ToString());
TreeFamily = myReader[2].ToString();
FIO = myReader[3].ToString();
BirthDayFamily = myReader[4].ToString();
}
}
public Diplom(string IDPerson)
{
connection StaffConnectuon = new connection();
SqlDataReader myReader = StaffConnectuon.select("*", "Диплом", "[Код сотрудника] =" + IDPerson);
while (myReader.Read())
{
IDDiplom = Convert.ToInt32(myReader[0].ToString());
NameOfUniversity = myReader[2].ToString();
Scienist = myReader[3].ToString();
EndYear = myReader[4].ToString();
Qualification = myReader[5].ToString();
}
}
/// <summary>
/// Конструктор для описывания сотрудника
/// </summary>
/// <param name="myReader">Данные, получаемые через sql запрос</param>
public Person(string IDPerson)
{
connection StaffConnectuon = new connection();
SqlDataReader myReader = StaffConnectuon.select("*", "Сотрудники", "[Код сотрудника] =" + IDPerson);
while (myReader.Read())
{
ID = Convert.ToInt32(myReader[0].ToString());
LastName = myReader[1].ToString();
Name = myReader[2].ToString();
MoreName = myReader[3].ToString();
BirthDay = myReader[4].ToString();
NumberContract = Convert.ToInt32(myReader[5].ToString());
Merry = myReader[6].ToString();
WorkDate = myReader[7].ToString();
Gender = myReader[8].ToString();
Adress = myReader[9].ToString();
HaveAHome = myReader[10].ToString();
SeriaOfPass = Convert.ToInt32(myReader[11].ToString());
NumberPass1 = Convert.ToInt32(myReader[12].ToString());
DatePass = myReader[13].ToString();
PlaceOfBirth = myReader[14].ToString();
IDPass = Convert.ToInt32(myReader[15].ToString());
WhoGivePass = myReader[16].ToString();
Citizen = myReader[17].ToString();
INN = Convert.ToInt32(myReader[18].ToString());
InshuranceNumber = Convert.ToInt32(myReader[19].ToString());
MedicCardNumber = Convert.ToInt32(myReader[20].ToString());
Department = myReader[21].ToString();
Occupation = myReader[22].ToString();
Sector = myReader[23].ToString();
Sailary = Convert.ToInt32(myReader[24].ToString());
MaxBonuseMoney = Convert.ToInt32(myReader[25].ToString());
HomeTele = Convert.ToInt32(myReader[26].ToString());
workTele = Convert.ToInt32(myReader[27].ToString());
MobTele = Convert.ToInt32(myReader[28].ToString());
Exp = myReader[29].ToString();
}
}