private void button1_Click(object sender, EventArgs e)
{
string query = ("insert into visit_record (vr_weight,vr_height,vr_systolic,vr_diastolic,vr_hearth_rate,vr_date,vr_status,vr_remark,opd_id) values ('" + txtw.Text + "','" + txth.Text + "','" + txts1.Text + "','" + txts2.Text + "','" + txthearth.Text + "',SYSDATETIME(),0,'" + txtremark.Text + "'," + lblopd.Text + ");");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
query = ("Update queue_visit_record set qvr_status = 0 where opd_id = '" + lblopd.Text + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
clinc_nurse_service m4 = new clinc_nurse_service();
m4.Show();
clinc_nurse_service clnlog = new clinc_nurse_service();
clnlog.Close();
Visible = false;
MessageBox.Show("บันทึกข้อมูลซักประวัติเรียบร้อย");
/*string query = ("insert into visit_record (vr_weight,vr_height,vr_systolic,vr_diastolic,vr_hearth_rate,vr_date,vr_remark,opd_id) values ('" + txtw.Text + "','" + txth.Text + "','" + txts1.Text + "','" + txts2.Text + "','" + txthearth.Text + "',SYSDATETIME(),'" + txtremark.Text + "'," + lblopd.Text + ");");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
* MessageBox.Show("บันทึกข้อมูลซักประวัติเรียบร้อย");*/
}
private void button5_Click(object sender, EventArgs e)
{
conn.Open();
string query = ("insert into queue_diag_room(qdr_date,qdr_time_sent,status_queue,swd_id,opd_id)values (SYSDATETIME(), SYSDATETIME(),1,'" + lblswd.Text + "','" + lblopdid.Text + "');");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
Queue <int> collection = new Queue <int>();
query = ("select count(*) from queue_diag_room inner join opd on opd.opd_id = queue_diag_room.opd_id inner join schedule_work_doctor on schedule_work_doctor.swd_id = queue_diag_room.swd_id inner join employee_doctor on employee_doctor.emp_doc_id = schedule_work_doctor.emp_doc_id where queue_diag_room.status_queue = 1 AND schedule_work_doctor.swd_id = '" + lblswd.Text + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
// sdr = cmd.ExecuteReader();
int queue = (int)cmd.ExecuteScalar();
collection.Enqueue(queue);
foreach (int value in collection)
{
if (value <= 9)
{
query = ("Update queue_diag_room Set qdr_record = '" + value + "' where opd_id = '" + lblopdid.Text + "'");
//
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
query = ("Update visit_record set vr_status = 1 where opd_id = '" + lblopdid.Text + "'");
//
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
clinc_nurse_service s2 = new clinc_nurse_service();
s2.Show();
sent_room clnlog = new sent_room();
clnlog.Close();
Visible = false;
MessageBox.Show("ส่งเข้าห้องตรวจเรียบร้อย คุณคิวที่ " + value);
}
else
{
MessageBox.Show("คิวห้องตรวจเต็ม");
}
}
conn.Close();
}
private void pictureBox2_Click(object sender, EventArgs e)
{
clinc_nurse_service nurse = new clinc_nurse_service();
nurse.Show();
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
clinc_nurse_service ser = new clinc_nurse_service();
ser.Show();
}