private void bt2_Click(object sender, EventArgs e)
{
try
{
DateTime today_th = DateTime.Today;
double time = Convert.ToDouble(lbltime.Text);
if (time >= 08.00 && time <= 15.30)
{
string today = today_th.ToString("yyyy-MM-dd", new CultureInfo("th-TH"));
if (lb11.Text != cmd.Connection.Database &&
lb22.Text != cmd.Connection.Database &&
lb33.Text != cmd.Connection.Database &&
lb44.Text != cmd.Connection.Database &&
lb55.Text != cmd.Connection.Database &&
statusapp.Text != cmd.Connection.Database)
{
Queue <int> collection = new Queue <int>();
/* collection.Enqueue(1);
* collection.Enqueue(2);
* collection.Enqueue(3);
* collection.Enqueue(4);
* collection.Enqueue(5);
* collection.Enqueue(6);
* collection.Enqueue(7);
* collection.Enqueue(8);
* collection.Enqueue(9);
* collection.Enqueue(10);*/
conn.Open();
string query = ("select * from employee_ru inner join privilege on privilege.emp_ru_id = employee_ru.emp_ru_id inner join opd on opd.emp_ru_id = employee_ru.emp_ru_id where employee_ru.emp_ru_idcard = '" + textBox1.Text + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
sdr = cmd.ExecuteReader();
if (sdr.Read())
{
int emp_ru_id = Convert.ToInt32(sdr["emp_ru_id"].ToString());
int opd_id = Convert.ToInt32(sdr["opd_id"].ToString());
query = ("select Count(opd_id) from queue_visit_record where opd_id = '" + opd_id + "' AND qvr_status <= 5 AND queue_visit_record.qvr_date = '" + label4.Text + "' ");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
int count_visit = (int)cmd.ExecuteScalar();
if (count_visit < 1)
{
query = ("select Count(*) from appointment where opd_id = '" + opd_id + "' AND status_approve = 2");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
int app_count = (int)cmd.ExecuteScalar();
if (app_count == 1)
{
DialogResult dialogResult = MessageBox.Show("ส่งคิวการนัดหมาย", "คุณต้องการส่งคิวการนัดหมายหรือไม่", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
//*****
query = ("select appointment.app_date from appointment where opd_id = '" + opd_id + "' AND status_approve = 2");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
sdr = cmd.ExecuteReader();
if (sdr.Read())
{
string date = sdr["app_date"].ToString();
DateTime date_app = Convert.ToDateTime(date);
int date_day = date_app.Day;
int today_day = today_th.Day;
if (today_day >= date_day)
{
query = ("insert into queue_visit_record(qvr_record,qvr_time,qvr_date,qvr_status,emp_ru_id,vr_id,opd_id) values(' ', '" + lbltime.Text + "', '" + label4.Text + "',5,'" + emp_ru_id + " ',' ','" + opd_id + " ')");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);//**
query = ("select Count(*) from queue_visit_record inner join opd on opd.opd_id = queue_visit_record.opd_id inner join employee_ru on employee_ru.emp_ru_id = queue_visit_record.emp_ru_id where queue_visit_record.qvr_status = 5 AND queue_visit_record.qvr_date = '" + label4.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)
{
query = ("Update queue_visit_record set qvr_record = '" + value + "' where emp_ru_id = '" + emp_ru_id + "'");
//
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
clinic_search m3 = new clinic_search();
m3.Show();
clinic_search clnlog = new clinic_search();
clnlog.Close();
Visible = false;
MessageBox.Show("ส่วนของการนัดหมาย คิวที่ " + value + " ");
}
}
else
{
MessageBox.Show("ยังไม่ถึงเวลานัดหมาย");
}
}
/*
* query = ("select Count(*) from queue_visit_record inner join opd on opd.opd_id = queue_visit_record.opd_id inner join employee_ru on employee_ru.emp_ru_id = queue_visit_record.emp_ru_id where queue_visit_record.qvr_status = 5");
* 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)
* {
* query = ("Update queue_visit_record set qvr_record = '" + value + "' where emp_ru_id = '" + emp_ru_id + "'");
* //
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
* clinic_search m3 = new clinic_search();
* m3.Show();
* clinic_search clnlog = new clinic_search();
* clnlog.Close();
* Visible = false;
* MessageBox.Show("ส่วนของการนัดหมาย คิวที่ " + value + " ");
* }
*
*
*/
}
else if (dialogResult == DialogResult.No)
{
DialogResult dialogResult1 = MessageBox.Show("ส่งคิวการซักประวัติ", "คุณต้องการส่งคิวการซักประวัติหรือไม่", MessageBoxButtons.YesNo);
if (dialogResult1 == DialogResult.Yes)
{
query = ("insert into queue_visit_record(qvr_record,qvr_time,qvr_date,qvr_status,emp_ru_id,vr_id,opd_id) values(' ', '" + lbltime.Text + "','" + label4.Text + "',1,'" + emp_ru_id + " ',' ','" + opd_id + " ')");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
query = ("select Count(*) from queue_visit_record inner join opd on opd.opd_id = queue_visit_record.opd_id inner join employee_ru on employee_ru.emp_ru_id = queue_visit_record.emp_ru_id where queue_visit_record.qvr_status = 1 AND queue_visit_record.qvr_date = '" + label4.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)
{
query = ("Update queue_visit_record set qvr_record = '" + value + "' where emp_ru_id = '" + emp_ru_id + "'");
//
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
clinic_search m3 = new clinic_search();
m3.Show();
clinic_search clnlog = new clinic_search();
clnlog.Close();
Visible = false;
MessageBox.Show("คิวที่ " + value);
}
}
else if (dialogResult1 == DialogResult.No)
{
clinic_search m3 = new clinic_search();
m3.Show();
clinic_search clnlog = new clinic_search();
clnlog.Close();
Visible = false;
}
}
}
else
{
DialogResult dialogResult = MessageBox.Show("ส่งคิวการซักประวัติ", "คุณต้องการส่งคิวการซักประวัติหรือไม่", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
query = ("insert into queue_visit_record(qvr_record,qvr_time,qvr_date,qvr_status,emp_ru_id,vr_id,opd_id) values(' ', '" + lbltime.Text + "', '" + label4.Text + "',1,'" + emp_ru_id + " ',' ','" + opd_id + " ')");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
query = ("select Count(*) from queue_visit_record inner join opd on opd.opd_id = queue_visit_record.opd_id inner join employee_ru on employee_ru.emp_ru_id = queue_visit_record.emp_ru_id where queue_visit_record.qvr_status = 1 AND queue_visit_record.qvr_date = '" + label4.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)
{
query = ("Update queue_visit_record set qvr_record = '" + value + "' where emp_ru_id = '" + emp_ru_id + "' AND queue_visit_record.qvr_date = '" + label4.Text + "'");
//
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
clinic_search m3 = new clinic_search();
m3.Show();
clinic_search clnlog = new clinic_search();
clnlog.Close();
Visible = false;
MessageBox.Show("คิวที่ " + value);
}
}
else if (dialogResult == DialogResult.No)
{
clinic_search m3 = new clinic_search();
m3.Show();
clinic_search clnlog = new clinic_search();
clnlog.Close();
Visible = false;
}
}
}
else
{
MessageBox.Show("คนไข้ถูกส่งคิวเข้าห้องซักประวัติเรียบร้อยแล้ว");
}
/*
* query = ("insert into queue_visit_record(qvr_record,qvr_time,qvr_date,qvr_status,emp_ru_id,vr_id,opd_id) values(' ', SYSDATETIME(), SYSDATETIME(),1,'" + emp_ru_id + " ',' ','" + opd_id + " ')");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
* DialogResult dialogResult = MessageBox.Show("ส่งคิวการซักประวัติ", "คุณต้องการส่งคิวการซักประวัติหรือไม่", MessageBoxButtons.YesNo);
* if (dialogResult == DialogResult.Yes)
* {
* query = ("select Count(*) from queue_visit_record inner join opd on opd.opd_id = queue_visit_record.opd_id inner join employee_ru on employee_ru.emp_ru_id = queue_visit_record.emp_ru_id where queue_visit_record.qvr_status = 1");
* 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)
* {
* query = ("Update queue_visit_record set qvr_record = '" + value + "' where emp_ru_id = '" + emp_ru_id + "'");
* //
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
*
* MessageBox.Show("คิวที่ " + value);
* }
*
*
*
*
*
*
* }
* else if (dialogResult == DialogResult.No)
* {
* clinic_search m3 = new clinic_search();
* m3.Show();
* clinic_search clnlog = new clinic_search();
* clnlog.Close();
* Visible = false;
* }
*/
}
/*
*
* string query = ("insert into queue_visit_record(qvr_record,qvr_time,qvr_date,qvr_status,emp_ru_id,vr_id,opd_idcard) values(' ', SYSDATETIME(), SYSDATETIME(),1,' ',' ',' ')");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
*/
//dataGridView1.Rows[n].Cells[0].Value = item["emp_ru_idcard"].ToString();
textBox1.MaxLength = 13;
textBox1.Clear();
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
lb11.Text = "";
lb22.Text = "";
lb33.Text = "";
lb44.Text = "";
lb55.Text = "";
statusapp.Text = "";
conn.Close();
}
else
{
MessageBox.Show("ตรวจสอบข้อมูลอีกครั้ง");
}
}
else
{
MessageBox.Show("ไม่สามารถส่งคิวการให้บริการได้");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OKCancel);
}
//----------------------------------------------------------------------
/*try
* {
* drd = cmd.ExecuteReader();
* MessageBox.Show("Save");
* while (drd.Read())
* {
*
* }
*
* }
* catch(Exception ex)
* {
* MessageBox.Show(ex.Message);
* }*/
//----------------------------------------------------------------------
/*string query = (" ");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);*/
}
private void bt2_Click(object sender, EventArgs e)
{
try
{
if (lb11.Text != cmd.Connection.Database &&
lb22.Text != cmd.Connection.Database &&
lb33.Text != cmd.Connection.Database &&
lb44.Text != cmd.Connection.Database &&
lb55.Text != cmd.Connection.Database &&
statusapp.Text != cmd.Connection.Database)
{
Queue <int> collection = new Queue <int>();
/* collection.Enqueue(1);
* collection.Enqueue(2);
* collection.Enqueue(3);
* collection.Enqueue(4);
* collection.Enqueue(5);
* collection.Enqueue(6);
* collection.Enqueue(7);
* collection.Enqueue(8);
* collection.Enqueue(9);
* collection.Enqueue(10);*/
conn.Open();
string query = ("select * from employee_ru inner join privilege on privilege.emp_ru_id = employee_ru.emp_ru_id inner join opd on opd.emp_ru_id = employee_ru.emp_ru_id where employee_ru.emp_ru_idcard = '" + textBox1.Text + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
sdr = cmd.ExecuteReader();
if (sdr.Read())
{
int emp_ru_id = Convert.ToInt32(sdr["emp_ru_id"].ToString());
int opd_id = Convert.ToInt32(sdr["opd_id"].ToString());
query = ("select Count(*) from appointment where opd_id = '" + opd_id + "' AND status_approve = 2");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
int app_count = (int)cmd.ExecuteScalar();
if (app_count == 1)
{
query = ("insert into queue_visit_record(qvr_record,qvr_time,qvr_date,qvr_status,emp_ru_id,vr_id,opd_id) values(' ', SYSDATETIME(), SYSDATETIME(),5,'" + emp_ru_id + " ',' ','" + opd_id + " ')");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
DialogResult dialogResult = MessageBox.Show("ส่งคิวการซักประวัติ", "คุณต้องการส่งคิวการซักประวัติหรือไม่", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
query = ("select Count(*) from queue_visit_record inner join opd on opd.opd_id = queue_visit_record.opd_id inner join employee_ru on employee_ru.emp_ru_id = queue_visit_record.emp_ru_id where queue_visit_record.qvr_status = 5");
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)
{
query = ("Update queue_visit_record set qvr_record = '" + value + "' where emp_ru_id = '" + emp_ru_id + "'");
//
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
clinic_search m3 = new clinic_search();
m3.Show();
clinic_search clnlog = new clinic_search();
clnlog.Close();
Visible = false;
MessageBox.Show("ส่วนของการนัดหมาย คิวที่ " + value + " ");
}
}
else if (dialogResult == DialogResult.No)
{
clinic_search m3 = new clinic_search();
m3.Show();
clinic_search clnlog = new clinic_search();
clnlog.Close();
Visible = false;
}
}
else
{
query = ("insert into queue_visit_record(qvr_record,qvr_time,qvr_date,qvr_status,emp_ru_id,vr_id,opd_id) values(' ', SYSDATETIME(), SYSDATETIME(),1,'" + emp_ru_id + " ',' ','" + opd_id + " ')");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
DialogResult dialogResult = MessageBox.Show("ส่งคิวการซักประวัติ", "คุณต้องการส่งคิวการซักประวัติหรือไม่", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
query = ("select Count(*) from queue_visit_record inner join opd on opd.opd_id = queue_visit_record.opd_id inner join employee_ru on employee_ru.emp_ru_id = queue_visit_record.emp_ru_id where queue_visit_record.qvr_status = 1");
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)
{
query = ("Update queue_visit_record set qvr_record = '" + value + "' where emp_ru_id = '" + emp_ru_id + "'");
//
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
clinic_search m3 = new clinic_search();
m3.Show();
clinic_search clnlog = new clinic_search();
clnlog.Close();
Visible = false;
MessageBox.Show("คิวที่ " + value);
}
}
else if (dialogResult == DialogResult.No)
{
clinic_search m3 = new clinic_search();
m3.Show();
clinic_search clnlog = new clinic_search();
clnlog.Close();
Visible = false;
}
}
/*
* query = ("insert into queue_visit_record(qvr_record,qvr_time,qvr_date,qvr_status,emp_ru_id,vr_id,opd_id) values(' ', SYSDATETIME(), SYSDATETIME(),1,'" + emp_ru_id + " ',' ','" + opd_id + " ')");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
* DialogResult dialogResult = MessageBox.Show("ส่งคิวการซักประวัติ", "คุณต้องการส่งคิวการซักประวัติหรือไม่", MessageBoxButtons.YesNo);
* if (dialogResult == DialogResult.Yes)
* {
* query = ("select Count(*) from queue_visit_record inner join opd on opd.opd_id = queue_visit_record.opd_id inner join employee_ru on employee_ru.emp_ru_id = queue_visit_record.emp_ru_id where queue_visit_record.qvr_status = 1");
* 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)
* {
* query = ("Update queue_visit_record set qvr_record = '" + value + "' where emp_ru_id = '" + emp_ru_id + "'");
* //
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
*
* MessageBox.Show("คิวที่ " + value);
* }
*
*
*
*
*
*
* }
* else if (dialogResult == DialogResult.No)
* {
* clinic_search m3 = new clinic_search();
* m3.Show();
* clinic_search clnlog = new clinic_search();
* clnlog.Close();
* Visible = false;
* }
*/
}
/*
*
* string query = ("insert into queue_visit_record(qvr_record,qvr_time,qvr_date,qvr_status,emp_ru_id,vr_id,opd_idcard) values(' ', SYSDATETIME(), SYSDATETIME(),1,' ',' ',' ')");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
*/
//dataGridView1.Rows[n].Cells[0].Value = item["emp_ru_idcard"].ToString();
textBox1.MaxLength = 13;
textBox1.Clear();
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
lb11.Text = "";
lb22.Text = "";
lb33.Text = "";
lb44.Text = "";
lb55.Text = "";
statusapp.Text = "";
conn.Close();
}
else
{
MessageBox.Show("ตรวจสอบข้อมูลอีกครั้ง");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OKCancel);
}
//----------------------------------------------------------------------
/*try
* {
* drd = cmd.ExecuteReader();
* MessageBox.Show("Save");
* while (drd.Read())
* {
*
* }
*
* }
* catch(Exception ex)
* {
* MessageBox.Show(ex.Message);
* }*/
//----------------------------------------------------------------------
/*string query = (" ");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);*/
}
