private void combostatus_SelectedIndexChanged(object sender, EventArgs e) { string query = ("Update schedule_work_doctor set swd_note = '" + combostatus.SelectedItem.ToString() + "'"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); clinic_timeschedule doc1 = new clinic_timeschedule(); doc1.Show(); clinic_timeschedule clnlog = new clinic_timeschedule(); clnlog.Close(); Visible = false; MessageBox.Show("เปลี่ยนสถานะ " + combostatus.SelectedItem.ToString() + " เรียบร้อย"); }
private void button2_Click(object sender, EventArgs e) { string query = ("Update schedule_work_doctor set swd_start_time = '" + txtstarttime.Text + "' ,swd_end_time = '" + txtendtime.Text + "',swd_note = '" + txtremark.Text + "' where room_id = '" + txtroom.Text + "' AND swd_timezone = '" + txttimezone.Text + "' AND swd_day_work = '" + txtday.Text + "'"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); clinic_timeschedule doc1 = new clinic_timeschedule(); doc1.Show(); clinic_timeschedule clnlog = new clinic_timeschedule(); clnlog.Close(); Visible = false; MessageBox.Show("เปลี่ยนแปลงตารางเรียบร้อย"); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { string query = ("Update schedule_work_doctor set swd_month_work = '" + comboBox1.SelectedItem.ToString() + "'"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); clinic_timeschedule doc1 = new clinic_timeschedule(); doc1.Show(); clinic_timeschedule clnlog = new clinic_timeschedule(); clnlog.Close(); Visible = false; MessageBox.Show("จัดตารางปฏิบัติงานแพทย์ประจำเดือน " + comboBox1.SelectedItem.ToString()); }
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e) { string com = comboBox2.SelectedItem.ToString(); int open = DateTime.Now.Day; int next = open + 20; // MessageBox.Show("เปลี่ยนเป็นสถานะ ปิด "); string query = ("Update schedule_work_doctor set swd_status_room = 0 ,emp_doc_id = 0 ,swd_work_place = '',swd_emp_work_place = '',swd_note = '',swd_status = '" + comboBox2.SelectedItem.ToString() + "',swd_end_date = '' "); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); conn.Close(); clinic_timeschedule doc1 = new clinic_timeschedule(); doc1.Show(); clinic_timeschedule clnlog = new clinic_timeschedule(); clnlog.Close(); Visible = false; MessageBox.Show("เปลี่ยนเป็นสถานะ " + comboBox2.SelectedItem.ToString()); // string today = DateTime.Now.ToString("dd-MM-yyyy", new CultureInfo("th-TH")); // string end_date = dateTimePicker1.Text; // groupBox4.Visible = true; /* * string query = ("Update schedule_work_doctor set swd_status_room = 0 ,emp_doc_id = 0 ,swd_status = '" + comboBox2.SelectedItem.ToString() + "'"); * cmd = new SqlCommand(query, conn); * sda = new SqlDataAdapter(cmd); * dt = new DataTable(); * * sda.Fill(dt); * conn.Close(); * clinic_timeschedule doc1 = new clinic_timeschedule(); * doc1.Show(); * clinic_timeschedule clnlog = new clinic_timeschedule(); * clnlog.Close(); * Visible = false; * MessageBox.Show("เปลี่ยนเป็นสถานะ " + comboBox2.SelectedItem.ToString()); */ }
private void dateTimePicker1_ValueChanged(object sender, EventArgs e) { /* string date = dateTimePicker1.Text; * lbldate.Text = date; */ string query = ("Update schedule_work_doctor set swd_end_date = '" + dateTimePicker1.Text + "'"); cmd = new SqlCommand(query, conn); sda = new SqlDataAdapter(cmd); dt = new DataTable(); sda.Fill(dt); clinic_timeschedule doc1 = new clinic_timeschedule(); doc1.Show(); clinic_timeschedule clnlog = new clinic_timeschedule(); clnlog.Close(); Visible = false; // groupBox4.Visible = true; // lbldate.Text = ""+ dateTimePicker1.Text; }