示例#1
0
        private void PTestsButton_Click(object sender, EventArgs e)
        {
            int          id    = DbConnector.GetInstance().GetPatientProfile(PatientBox.Text).id;
            string       query = String.Format(@"select distinct testtype.name, test.date_time as 'date', test.result as result
	from test inner join (select medical_card.id 
							from medical_card inner join patient
									on medical_card.patient_id = {0}) as mc
			   on test.card_id = mc.id
               inner join testtype on testtype.id = test.id;", id);
            Form         f     = new Form();
            ReportWindow w     = new ReportWindow("Tests of " + PatientBox.Text, query);

            f.Controls.Add(w);
            f.Size = w.Size;
            f.Show();
        }
示例#2
0
        private void DSessionsButton_Click(object sender, EventArgs e)
        {
            int          id    = DbConnector.GetInstance().GetEmployeeProfile(DoctorBox.Text).id;
            string       query = String.Format(@"select session.date_time as 'date', proc.name as 'procedure', mc.disease_name as 'disease name',
                        employee.name as 'doctor' , session.total_cost as 'cost'
                            from session inner join employee 
	                        on session.employee_id = {0}
                                inner join proc
                                on proc.id = session.proc_id
                            inner join medical_card as mc 
                                on mc.id = session.card_id;", id);
            Form         f     = new Form();
            ReportWindow w     = new ReportWindow("Procedure sessions by " + DoctorBox.Text, query);

            f.Controls.Add(w);
            f.Size = w.Size;
            f.Show();
        }
示例#3
0
        private void PSurveysButton_Click(object sender, EventArgs e)
        {
            int          id    = DbConnector.GetInstance().GetPatientProfile(PatientBox.Text).id;
            string       query = String.Format(@"select distinct surveytype.name as 'survey name', mc.disease_name as disease, survey.result,survey.date_time as 
    'survey date',employee.name as doctor 
    from survey 
    inner join employee on employee.id = survey.employee_id
	inner join (select medical_card.id,medical_card.disease_name from medical_card
				inner join patient
				on medical_card.patient_id ={0}) as mc
                on survey.card_id = mc.id
                inner join surveytype on surveytype.id=survey.type_id;", id);
            Form         f     = new Form();
            ReportWindow w     = new ReportWindow("Surveys of " + PatientBox.Text, query);

            f.Controls.Add(w);
            f.Size = w.Size;
            f.Show();
        }
示例#4
0
        private void PSessionsButton_Click(object sender, EventArgs e)
        {
            int          id    = DbConnector.GetInstance().GetPatientProfile(PatientBox.Text).id;
            string       query = String.Format(@"select distinct mc.disease_name as 'disease',  diseasetype.name as 'disease type',
 session.date_time as 'session date',proc.name as 'procedure',
	    employee.name as doctor, session.total_cost as 'cost' 
        from session inner join proc on proc.id=session.proc_id
        inner join employee on employee.id = session.employee_id
	    inner join (select medical_card.id,medical_card.disease_name,medical_card.type_id
				from medical_card inner join patient
				on medical_card.patient_id = {0}) as mc
                on session.card_id = mc.id
				inner join diseasetype on diseasetype.id = mc.type_id;"                , id);
            Form         f     = new Form();
            ReportWindow w     = new ReportWindow("Sessions of " + PatientBox.Text, query);

            f.Controls.Add(w);
            f.Size = w.Size;
            f.Show();
        }
示例#5
0
        private void TestConfirmButton_Click(object sender, EventArgs e)
        {
            string       startDate = TestStartPicker.Value.ToString("yyyy-MM-dd");
            string       endDate   = TestEndPicker.Value.ToString("yyyy-MM-dd");
            string       query     = string.Format(@"select testtype.name as 'test name', test.date_time as 'date', test.result, 
                        mc.disease_name as 'suffered disease', mc.name as 'patient'
	                    from test inner join (select medical_card.disease_name, medical_card.id,patient.name
								from medical_card inner join patient
													on patient.id=medical_card.patient_id) as mc
					 on mc.id = test.card_id
                     inner join testtype on testtype.id = test.type_id
                     where date_format(test.date_time,'%Y-%m-%d')>=Date('{0}') 
                     and date_format(test.date_time,'%Y-%m-%d')<=Date('{1}');", startDate, endDate);
            Form         f         = new Form();
            ReportWindow w         = new ReportWindow("Tests made from " + startDate + " to " + endDate, query);

            f.Controls.Add(w);
            f.Size = w.Size;
            f.Show();
        }
示例#6
0
        private void SurveysConfirmButton_Click(object sender, EventArgs e)
        {
            string       startDate = SurveyStartPicker.Value.ToString("yyyy-MM-dd");
            string       endDate   = SurveyEndPicker.Value.ToString("yyyy-MM-dd");
            string       query     = string.Format(@"select distinct surveytype.name as 'survey name', mc.disease_name as disease, survey.result,survey.date_time as 
                        'survey date',mc.name as 'patient',employee.name as 'doctor'
                        from survey 
                        inner join employee on survey.employee_id = employee.id
	                    inner join (select medical_card.id,medical_card.disease_name,patient.name from medical_card
				inner join patient
				on medical_card.patient_id = patient.id) as mc
                on survey.card_id = mc.id
                inner join surveytype on surveytype.id=survey.type_id
                where date_format(survey.date_time,'%Y-%m-%d')>=('{0}')
                and date_format(survey.date_time,'%Y-%m-%d')<=('{1}');", startDate, endDate);
            Form         f         = new Form();
            ReportWindow w         = new ReportWindow("Surveys made from " + startDate + " to " + endDate, query);

            f.Controls.Add(w);
            f.Size = w.Size;
            f.Show();
        }
示例#7
0
        private void SessionsConfirmButton_Click(object sender, EventArgs e)
        {
            string       startDate = SessionStartPicker.Value.ToString("yyyy-MM-dd");
            string       endDate   = SessionEndPicker.Value.ToString("yyyy-MM-dd");
            string       query     = string.Format(@"select proc.name as 'procedure', session.date_time as 'date',  
                        mc.disease_name as 'treated disease' ,
                        employee.name as 'doctor',mc.name as 'patient', session.total_cost as 'cost'
                            from session inner join employee
					            on employee.id = session.employee_id
				             inner join proc
					             on proc.id = session.proc_id
			                inner join (select medical_card.disease_name, medical_card.id,patient.name
								from medical_card inner join patient
									on patient.id = medical_card.patient_id) as mc
                                    on mc.id = session.card_id
                where date_format(session.date_time,'%Y-%m-%d')>=('{0}')
                and date_format(session.date_time,'%Y-%m-%d')<=('{1}');", startDate, endDate);
            Form         f         = new Form();
            ReportWindow w         = new ReportWindow("Procedure sessions made from " + startDate + " to " + endDate, query);

            f.Controls.Add(w);
            f.Size = w.Size;
            f.Show();
        }