Пример #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                conn.Open();
                string query = ("select * from employee_doctor where emp_doc_name = '" + comboBox1.SelectedItem.ToString() + "'");
                cmd = new SqlCommand(query, conn);

                sda = new SqlDataAdapter(cmd);
                dt  = new DataTable();
                sda.Fill(dt);
                sdr = cmd.ExecuteReader();
                if (sdr.Read())
                {
                    int doc_id = Convert.ToInt32(sdr["emp_doc_id"].ToString());

                    query = ("select schedule_work_doctor.room_id from schedule_work_doctor inner join employee_doctor on employee_doctor.emp_doc_id = schedule_work_doctor.emp_doc_id inner join specialist on specialist.emp_doc_specialistid = employee_doctor.emp_doc_specialistid where schedule_work_doctor.swd_date_work = '" + txttime.Text + "' AND schedule_work_doctor.emp_doc_id = '" + doc_id + "'");
                    cmd   = new SqlCommand(query, conn);

                    sda = new SqlDataAdapter(cmd);
                    dt  = new DataTable();
                    sda.Fill(dt);
                    sdr = cmd.ExecuteReader();
                    if (sdr.Read())
                    {
                        int room_id  = Convert.ToInt32(sdr["room_id"].ToString());
                        int room_swd = Convert.ToInt32(txtroom.Text);

                        if (room_id == room_swd)
                        {
                            query = ("Update schedule_work_doctor set swd_note = 'ทำงานแทน',swd_status_room = 1,swd_emp_work_place = '" + txtdoctorname.Text + "',emp_doc_id = '" + doc_id + "' where swd_id = '" + txtswd.Text + "'");
                            cmd   = new SqlCommand(query, conn);
                            sda   = new SqlDataAdapter(cmd);
                            dt    = new DataTable();
                            sda.Fill(dt);

                            query = ("select swd_id,swd_date_work from schedule_work_doctor inner join employee_doctor on employee_doctor.emp_doc_id = schedule_work_doctor.emp_doc_id where swd_note = 'ทำงานแทน' AND schedule_work_doctor.swd_emp_work_place = '" + txtdoctorname.Text + "'");
                            cmd   = new SqlCommand(query, conn);

                            sda = new SqlDataAdapter(cmd);
                            dt  = new DataTable();
                            sda.Fill(dt);
                            sdr = cmd.ExecuteReader();
                            while (sdr.Read())
                            {
                                int      swd_id   = sdr.GetInt32(0);
                                DateTime date_sed = sdr.GetDateTime(1);
                                string   date_swd = date_sed.ToString("yyyy-MM-dd");
                                query = ("select count(appointment.app_date) from appointment  inner join employee_doctor on employee_doctor.emp_doc_id = appointment.emp_doc_id where app_date = '" + date_swd + "' AND employee_doctor.emp_doc_name = '" + txtdoctorname.Text + "'");
                                cmd   = new SqlCommand(query, conn);
                                sda   = new SqlDataAdapter(cmd);
                                dt    = new DataTable();
                                sda.Fill(dt);
                                int count_app = (int)cmd.ExecuteScalar();
                                if (count_app >= 1)
                                {
                                    query = ("update appointment SET appointment.status_approve = 6,appointment.swd_id = '" + swd_id + "' from appointment inner join employee_doctor on employee_doctor.emp_doc_id = appointment.emp_doc_id where employee_doctor.emp_doc_name = '" + txtdoctorname.Text + "' AND appointment.app_date = '" + date_swd + "'");
                                    cmd   = new SqlCommand(query, conn);
                                    sda   = new SqlDataAdapter(cmd);
                                    dt    = new DataTable();
                                    sda.Fill(dt);


                                    clinic_schedule_now_today doc2 = new clinic_schedule_now_today();
                                    doc2.Show();
                                    clinic_schedule_now_today clnlog11 = new clinic_schedule_now_today();
                                    clnlog11.Close();
                                    Visible = false;
                                }
                            }

                            clinic_schedule_now_today doc11 = new clinic_schedule_now_today();
                            doc11.Show();
                            clinic_schedule_now_today clnlog1 = new clinic_schedule_now_today();
                            clnlog1.Close();
                            Visible = false;
                            //  MessageBox.Show(" " + room_id);
                        }
                        else
                        {
                            MessageBox.Show("แพทย์มีข้อมูลการทำงานแล้ว");
                        }
                    }
                    else
                    {
                        query = ("Update schedule_work_doctor set swd_note = 'ทำงานแทน',swd_status_room = 1,swd_emp_work_place = '" + txtdoctorname.Text + "',emp_doc_id = '" + doc_id + "' where swd_id = '" + txtswd.Text + "'");
                        cmd   = new SqlCommand(query, conn);
                        sda   = new SqlDataAdapter(cmd);
                        dt    = new DataTable();
                        sda.Fill(dt);


                        query = ("select swd_id,swd_date_work from schedule_work_doctor inner join employee_doctor on employee_doctor.emp_doc_id = schedule_work_doctor.emp_doc_id where swd_note = 'ทำงานแทน' AND schedule_work_doctor.swd_emp_work_place = '" + txtdoctorname.Text + "'");
                        cmd   = new SqlCommand(query, conn);

                        sda = new SqlDataAdapter(cmd);
                        dt  = new DataTable();
                        sda.Fill(dt);
                        sdr = cmd.ExecuteReader();
                        while (sdr.Read())
                        {
                            int      swd_id   = sdr.GetInt32(0);
                            DateTime date_sed = sdr.GetDateTime(1);
                            string   date_swd = date_sed.ToString("yyyy-MM-dd");
                            query = ("select count(appointment.app_date) from appointment  inner join employee_doctor on employee_doctor.emp_doc_id = appointment.emp_doc_id where app_date = '" + date_swd + "' AND employee_doctor.emp_doc_name = '" + txtdoctorname.Text + "'");
                            cmd   = new SqlCommand(query, conn);
                            sda   = new SqlDataAdapter(cmd);
                            dt    = new DataTable();
                            sda.Fill(dt);
                            int count_app = (int)cmd.ExecuteScalar();
                            if (count_app >= 1)
                            {
                                query = ("update appointment SET appointment.status_approve = 6,appointment.swd_id = '" + swd_id + "' from appointment inner join employee_doctor on employee_doctor.emp_doc_id = appointment.emp_doc_id where employee_doctor.emp_doc_name = '" + txtdoctorname.Text + "' AND appointment.app_date = '" + date_swd + "'");
                                cmd   = new SqlCommand(query, conn);
                                sda   = new SqlDataAdapter(cmd);
                                dt    = new DataTable();
                                sda.Fill(dt);


                                clinic_schedule_now_today doc2 = new clinic_schedule_now_today();
                                doc2.Show();
                                clinic_schedule_now_today clnlog1 = new clinic_schedule_now_today();
                                clnlog1.Close();
                                Visible = false;
                            }
                        }



                        clinic_schedule_now_today doc1 = new clinic_schedule_now_today();
                        doc1.Show();
                        clinic_schedule_now_today clnlog = new clinic_schedule_now_today();
                        clnlog.Close();
                        Visible = false;
                    }
                }



                conn.Close();
            }catch (Exception)
            {
            }
        }
Пример #2
0
        private void msswd_Click(object sender, EventArgs e)
        {
            clinic_schedule_now_today sc = new clinic_schedule_now_today();

            sc.Show();
        }