Дипломная работа: Автоматизация учета пациентов на примере ООО «АРХИДЕНТ»

Скачать

Заказать новую работу

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
102
connection.Open();
/*MessageBox.Show(
"ПодключениекБДуспешнооткрыто.\r\n" +
" Параметры подключениея к базе данных: " + "\r\n" +
" |базаданных: ---------- " + connection.Database + "\r\n" +
" |сервер: --------------- " + connection.DataSource + "\r\n" +
" |версиясервера: ------- " + connection.ServerVersion + "\r\n" +
" |состояние: ------------ " + connection.State);*/
}
catch (Exception ex)
{
MessageBox.Show("ERROR: " + ex.Message, "ERROR DB
CONNECTION", MessageBoxButton.OK, MessageBoxImage.Error);
MessageBoxResult result =
MessageBox.Show("Сброситьпутьдобазыданных ?", "err db connect",
MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
SettingsApp.Default.FullPathDataBase = "C:\\";
SettingsApp.Default.Save();
}
Environment.Exit(0);
}
//загрузкапациентов
sqlExpression = "SELECT Id_patient, namePatient, surname, patronymic,
age, passport, phone, registration_date FROM Patient;";
command = new SqlCommand(sqlExpression, connection);
103
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Patient temp = new Patient();
temp.Id = reader.GetInt32(0);
temp.namePatient = reader.GetString(1);
temp.surname = reader.GetString(2);
temp.patronymic = reader.GetString(3);
temp.age = reader.GetInt32(4);
temp.passport = reader.GetString(5);
temp.phone = reader.GetString(6);
//не работает загрузка даты регистрации
PatientDataGrid.Items.Add(temp);
}
}
//загрузкарасписания
sqlExpression = "SELECT [Reception].[Id_Reception],
[Reception].[doctor], [Doctor].[nameDoctor], [Doctor].[surname],
[Doctor].[patronymic], [Reception].[patient], [Patient].[namePatient],
[Patient].[surname], [Patient].[patronymic], [Reception].[procedure],
[Procedure].[nameProcedure], [Reception].[begin_reception], [Reception].[status],
[Reception].[price] FROM (([Reception] LEFT JOIN [Doctor] ON
[Reception].[doctor] = [Doctor].[Id_doc]) LEFT JOIN [Patient] ON
[Reception].[patient] = [Patient].[Id_patient]) LEFT JOIN [Procedure] ON
[Reception].[procedure] = [Procedure].[Id_Procedure]";
command = new SqlCommand(sqlExpression, connection);
104
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Reception_ temp = new Reception_();
temp.Id = reader.GetInt32(0);
temp.doctor_id = reader.GetInt32(1);
temp.nameDoctor = reader.GetString(2);
temp.surnameDoctor = reader.GetString(3);
temp.patronymicDoctor = reader.GetString(4);
temp.patient_id = reader.GetInt32(5);
temp.namePatient = reader.GetString(6);
temp.surnamePatient = reader.GetString(7);
temp.patronymicPatient = reader.GetString(8);
temp.procedure = reader.GetInt32(9);
temp.nameProcedure = reader.GetString(10);
temp.begin_reception = reader.GetDateTime(11);
temp.status = reader.GetBoolean(12);
temp.price = reader.GetInt32(13);
ReceptionDataGrid.Items.Add(temp);
}
}
105
//загрузкапроцедур
sqlExpression = "SELECT [Procedure].[Id_Procedure],
[Procedure].[nameProcedure] FROM [Procedure]";
command = new SqlCommand(sqlExpression, connection);
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Procedure temp = new Procedure();
temp.Id = reader.GetInt32(0);
temp.nameProcedure = reader.GetString(1);
ProcedureDataGrid.Items.Add(temp);
}
}
//загрузкаврачей
sqlExpression = "SELECT [Doctor].[Id_doc], [Doctor].[nameDoctor],
[Doctor].[surname], [Doctor].[patronymic], [Doctor].[position],
[Position].[namePosition] FROM [Doctor] LEFT JOIN [Position] ON
[Doctor].[position] = [Position].[Id_position]";
command = new SqlCommand(sqlExpression, connection);
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Doctor temp = new Doctor();
106
temp.Id = reader.GetInt32(0);
temp.nameDoctor = reader.GetString(1);
temp.surname = reader.GetString(2);
temp.patronymic = reader.GetString(3);
temp.position_id = reader.GetInt32(4);
temp.positionname = reader.GetString(5);
DoctorDataGrid.Items.Add(temp);
}
}
}
private void ButtonNewPatient_Click(object sender, RoutedEventArgs e)
{
Patient newpatient = new Patient();
PatientCard patientCard = new PatientCard(newpatient, connection,
true);
patientCard.Show();
}
private void ButtonPatientCard_Click(object sender, RoutedEventArgs e)
{
if (SelectionObj != null)
{
PatientCard patientCard = new PatientCard(SelectionObj,
connection);
patientCard.Show();
}
else
{
MessageBox.Show("Что бы открыть карточку пациента,
Источник: https://baza.diplomsite.ru/previewfile/286

Смотрите также:

134126
1444
1532
1564
1804
1sma5-0at3rev1
2 Общ фарм +
2270
2409
2737