private void ll1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { clinic_search search = new clinic_search(); search.Show(); }
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);*/ }
private void pictureBox1_Click(object sender, EventArgs e) { clinic_search search = new clinic_search(); search.Show(); }
private void toolStripButton1_Click(object sender, EventArgs e) { clinic_search cs = new clinic_search(); cs.Show(); }
private void fileToolStripMenuItem_Click(object sender, EventArgs e) { clinic_search cns = new clinic_search(); cns.Show(); }