public static string centel_chenge_swd_doc_work(schedule_work_doctor swd) { // string query = String.Format("SELECT COUNT(*) from schedule_work_doctor swd inner join room on room.room_id = swd.room_id where swd_day_work = '{0}' AND swd_start_time = '{1}' AND swd_status_room = 1 ", swd.swd_day_work,swd.swd_start_time); try { // conn.Open(); // command.CommandText = query; // int amountOfUsers = (int)command.ExecuteScalar(); // if (amountOfUsers < 1) // { string query = String.Format("Update schedule_work_doctor set swd_note = '',swd_status_room = 1 where swd_id = {0}", swd.swd_id); conn.Open(); command.CommandText = query; command.ExecuteNonQuery(); return("ยกเลิกการทำงานแทนเรียบร้อย"); // } // else // { // return "ห้องตรวจซ้ำ กรุณาเลือกใหม่"; // } } finally { conn.Close(); } }
/* * protected void btnsubmit_Click(object sender, EventArgs e) * { * string name = "" + Session["doc_name"]; * // int s = 1; * doctor doc = doctor.doc_idshow(name); * if (doc != null) * { * schedule_work_doctor swd = new schedule_work_doctor(DropDownList2.SelectedIndex.ToString(), DropDownList3.SelectedIndex.ToString(), Convert.ToInt32(DropDownList1.SelectedIndex.ToString()), doc.emp_doc_id); * * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true); * } * } */ protected void btnsummit_Click(object sender, EventArgs e) { try { schedule_work_doctor swd = new schedule_work_doctor(Convert.ToInt32(txtswd.Text)); schedule_work_doctor.update_chenge_note(swd); //ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.update_chenge_note(swd) + "');", true); Response.Redirect("../page/next_swd.aspx"); // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + doc.emp_doc_id + "');", true); // schedule_work_doctor swd = new schedule_work_doctor(DropDownList1.SelectedValue.ToString(), DropDownList2.SelectedValue.ToString(), Convert.ToInt32(txtroom.Text), doc.emp_doc_id); // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.update_next_swd(swd) + "');", true); // int s = 1; // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + DropDownList1.SelectedValue.ToString()+ "');", true); } catch (Exception) { } }
public static schedule_work_doctor swd_show(string name) { string query = String.Format("select schedule_work_doctor.swd_day_work, schedule_work_doctor.swd_start_time, schedule_work_doctor.room_id, schedule_work_doctor.swd_note from schedule_work_doctor inner join employee_doctor on employee_doctor.emp_doc_id = schedule_work_doctor.emp_doc_id where emp_doc_name = '{0}'", name); try { conn.Open(); command.CommandText = query; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { string swd_day_work = reader.GetString(0); string swd_start_time = reader.GetString(1); int room_id = reader.GetInt32(2); schedule_work_doctor swd = new schedule_work_doctor(swd_day_work, swd_start_time, room_id, name); return(swd); } } finally { conn.Close(); } return(null); }
public static string updateswd2(schedule_work_doctor swd) { string query = String.Format("SELECT COUNT(*) from schedule_work_doctor where swd_status_room = 1 AND emp_doc_id = {0} AND swd_start_time = '{1}' AND swd_day_work = '{2}' AND swd_date_work = '{3}'", swd.emp_doc_id, swd.swd_start_time, swd.swd_day_work, swd.swd_date_work); try { conn.Open(); command.CommandText = query; int amountOfUsers = (int)command.ExecuteScalar(); if (amountOfUsers < 1) { query = String.Format("Update schedule_work_doctor set swd_status_room = 3,swd_note = 'รอการอนุมัติการเลื่อนปฏิบัติงาน',emp_doc_id = {0} where room_id = {1} AND swd_start_time = '{2}' AND swd_day_work = '{3}' AND swd_date_work = '{4}'", swd.emp_doc_id, swd.room_id, swd.swd_start_time, swd.swd_day_work, swd.swd_date_work); // conn.Open(); command.CommandText = query; command.ExecuteNonQuery(); return("รอการอนุมัติการเลื่อนปฏิบัติงาน"); } else { return("ห้องตรวจซ้ำ กรุณาเลือกใหม่"); } } finally { conn.Close(); } }
public static string updateswd(schedule_work_doctor swd) { string query = String.Format("SELECT COUNT(*) from schedule_work_doctor where swd_status_room = 1 AND emp_doc_id = {0} AND swd_start_time = '{1}' AND swd_day_work = '{2}' AND swd_date_work = '{3}'", swd.emp_doc_id, swd.swd_start_time, swd.swd_day_work, swd.swd_date_work); try { conn.Open(); command.CommandText = query; /* query = String.Format("SELECT COUNT(swd_status_room) from schedule_work_doctor where swd_status_room = 1 AND swd_start_time = '{0}' AND swd_day_work = '{1}' AND swd_date_work = '{2}'", swd.swd_start_time, swd.swd_day_work, swd.swd_date_work); * command.CommandText = query; * int count_enp_id = (int)command.ExecuteScalar();*/ int amountOfUsers = (int)command.ExecuteScalar(); if (amountOfUsers < 1) { query = String.Format("Update schedule_work_doctor set swd_status_room = 1,emp_doc_id = {0} where room_id = {1} AND swd_start_time = '{2}' AND swd_day_work = '{3}' AND swd_date_work = '{4}'", swd.emp_doc_id, swd.room_id, swd.swd_start_time, swd.swd_day_work, swd.swd_date_work); // conn.Open(); command.CommandText = query; command.ExecuteNonQuery(); return("ลงเวลาเรียบร้อย"); } else { return("ห้องตรวจซ้ำ กรุณาเลือกใหม่"); } } finally { conn.Close(); } }
public static schedule_work_doctor swd_work(int ID) { string query = String.Format("select schedule_work_doctor.swd_status_room,employee_doctor.emp_doc_name from employee_doctor inner join schedule_work_doctor on schedule_work_doctor.emp_doc_id = employee_doctor.emp_doc_id where employee_doctor.emp_doc_id = '{0}' AND swd_status_room = 4", ID); try { conn.Open(); command.CommandText = query; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int swd_status_room1 = reader.GetInt32(0); string emp_name = reader.GetString(1); schedule_work_doctor swd = new schedule_work_doctor(swd_status_room1, emp_name); return(swd); } } finally { conn.Close(); } return(null); }
public static schedule_work_doctor check_room_5(DateTime day, int empdoctorid) { string query = string.Format("select swd_start_time,swd_status_room, room_id ,emp_doc_id from schedule_work_doctor where swd_status_room = 1 AND swd_date_work = '{0}' AND emp_doc_id = {1}", day, empdoctorid); try { conn.Open(); command.CommandText = query; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { string swd_start_time = reader.GetString(0); int swd_status_room = reader.GetInt32(1); int room_id = reader.GetInt32(2); int emp_doc_id1 = reader.GetInt32(3); schedule_work_doctor swd = new schedule_work_doctor(swd_start_time, swd_status_room, room_id, emp_doc_id1); return(swd); } } finally { conn.Close(); } return(null); }
protected void btncencel_Click(object sender, EventArgs e) { try { int id_swd_work_doctor = Convert.ToInt32(lblswdid.Text); doctor doc_id = doctor.doc_idshow(lbldoctorre.Text); if (doc_id != null) { schedule_work_doctor swd_cencel = new schedule_work_doctor(doc_id.emp_doc_id, id_swd_work_doctor, doc_id.emp_doc_id); // schedule_work_doctor swd_doc_cencel = new schedule_work_doctor(doc_id.emp_doc_id); // schedule_work_doctor.centel_chenge_swd_doc_work(swd_doc_cencel); // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.centel_chenge_swd_doc_work(swd_cencel) + "');", true); ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.centel_chenge_note_work(swd_cencel) + "');", true); } } catch (Exception) { } }
protected void btnsubmit_Click(object sender, EventArgs e) { try { string name = "" + Session["doc_name"]; int id_swd_work_doctor = Convert.ToInt32(lblswdid.Text); doctor doc = doctor.doc_idshow(name); if (doc != null) { schedule_work_doctor swd = new schedule_work_doctor(id_swd_work_doctor); ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.update_chenge_note_work(swd) + "');", true); Response.Redirect("../Page/index_doctor.aspx"); } } catch (Exception) { } }
protected void Page_Load(object sender, EventArgs e) { // GetData(); lbldoctor.Text = "" + Session["doc_name"]; int id = Convert.ToInt32(Session["doc_id"]); btnworkswd.Visible = false; schedule_work_doctor sc = schedule_work_doctor.swd_work(id); if (sc != null) { if (sc.swd_status_room == 4) { btnworkswd.Visible = true; // Response.Redirect("../page/schedule_work.aspx"); } } }
public static schedule_work_doctor check_swdid_doctor(string name, string date_swd) { string query = string.Format("select swd_id from schedule_work_doctor inner join employee_doctor on employee_doctor.emp_doc_id = schedule_work_doctor.emp_doc_id where employee_doctor.emp_doc_name = '{0}' AND swd_date_work = '{1}'", name, date_swd); try { conn.Open(); command.CommandText = query; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int swd_id = reader.GetInt32(0); schedule_work_doctor swd = new schedule_work_doctor(swd_id); return(swd); } } finally { conn.Close(); } return(null); }
protected void btnsubmit_Click(object sender, EventArgs e) { try { CultureInfo culture = new CultureInfo("th-TH"); string date = txtdate.Text; string time = txttimeapp.Text; string name = "" + Session["opd_name_app"]; string remark = "" + Session["remark_app"]; string name_doc = "" + Session["doctor_app"]; doctor doc_name = doctor.doc_idshow(name_doc); DateTime day = Convert.ToDateTime(date, culture); string date_app = day.ToString("yyyy-MM-dd", culture); string app_day = txtday.Text; double time_zone = Convert.ToDouble(time); string date_work = day.ToString("yyyy-MM-dd", culture); DateTime today_th = DateTime.Today; string today = today_th.ToString("yyyy-MM-dd", new CultureInfo("th-TH")); int today_day = today_th.Day; int day_select = day.Day; if (time_zone <= 12.00) { if (day.Date >= today_th.Date) { if (doc_name != null) { int doc_id = doc_name.emp_doc_id; schedule_work_doctor ss = schedule_work_doctor.check_swdid_doctor(name_doc, date_app); if (ss != null) { int swd_id_app = ss.swd_id; appointment app = new appointment(doc_id, "เช้า", app_day, date_app, time, remark, name, date_work); ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + appointment.update_app_doctor(app) + "');", true); Response.Redirect("../page/nurse_index_opd.aspx"); } else { // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('"+name_doc+" "+date_app+"');", true); } // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + name_doc + " " + date_app + "');", true); } else { // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ไม่อ่าน');", true); } } else { ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ไม่สามารถเลื่อนนัดได้');", true); } } else if (time_zone >= 12.01) { if (day.Date >= today_th.Date) { if (doc_name != null) { int doc_id = doc_name.emp_doc_id; schedule_work_doctor ss = schedule_work_doctor.check_swdid_doctor(name_doc, date_app); if (ss != null) { int swd_id_app = ss.swd_id; appointment app = new appointment(doc_id, "บ่าย", app_day, date_app, time, remark, name, date_work); ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + appointment.update_app_doctor(app) + "');", true); Response.Redirect("../page/nurse_index_opd.aspx"); } else { // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert(' " + name + " + " + date_app + "');", true); } } } else { ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ไม่สามารถเลื่อนนัดได้');", true); } } } catch (Exception) { ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ไม่สามารถเลื่อนนัดได้');", true); } }
protected void btnsubmit_Click(object sender, EventArgs e) { string name = "" + Session["doc_name"]; // int s = 1; DateTime day = Convert.ToDateTime(TextBox2.Text); DateTime today = DateTime.Today; string time1 = DropDownList3.SelectedValue.ToString(); schedule_work_doctor swd1 = schedule_work_doctor.check_room(day, time1); doctor doc = doctor.doc_idshow(name); int today_num = today.Day; if (today_num == 20) { ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('หมดเวลาในการลงทะเบียน');", true); } else { if (swd1 != null) { int room_id = swd1.room_id; int status_room = swd1.swd_status_room; string time = swd1.swd_start_time; if (doc != null) { int doc_id = doc.emp_doc_id; /* schedule_work_doctor swd2 = schedule_work_doctor.check_room_1(day,room_id); * schedule_work_doctor swd3 = schedule_work_doctor.check_room_2(day, room_id,doc_id); * if(swd3 != null) * { * if (swd2 != null) * { * int room_id1 = swd2.room_id; * int status_room1 = swd2.swd_status_room; * string time2 = swd2.swd_start_time; * int emp_id = swd2.emp_doc_id; * int emp_doc_id = swd3.emp_doc_id; * if (emp_id == emp_doc_id) * { * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('มีแพทย์มาปฏิบัติงานแล้ว');", true); * } * else * { * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ไม่เวลา111111111 " +emp_doc_id+" , "+emp_id+"');", true); * // schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, TextBox2.Text, DropDownList3.SelectedValue.ToString(), room_id, doc.emp_doc_id); * * // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true); * * } * * * } * * * * * }*/ schedule_work_doctor swd2 = schedule_work_doctor.check_room_3(day, time, room_id); schedule_work_doctor swd4 = schedule_work_doctor.check_room_5(day, doc_id); if (swd2 != null) { int emp_doctor_id = swd2.emp_doc_id; if (swd4 != null) { int roomiddoc = swd4.room_id; int docid = swd4.emp_doc_id; int swd3 = schedule_work_doctor.check_room_4(roomiddoc, day); if (swd3 == 0) { ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('มีแพทย์ทำงานห้องตรวจแล้ว');", true); } else { schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, TextBox2.Text, DropDownList3.SelectedValue.ToString(), roomiddoc, doc.emp_doc_id); ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true); } /* * if (room_id == 1 && time1 == time) * { * * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + room_id + " " + time1 + " " + time + "');", true); * * * } * else if (room_id == 2 && time1 == time) * { * * * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + room_id + " " + time1 + " " + time + "');", true); * * } * else if (room_id == 3 && time1 == time) * { * * * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + room_id + " " + time1 + " " + time + "');", true); * * } * */ } else { schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, TextBox2.Text, DropDownList3.SelectedValue.ToString(), room_id, doc.emp_doc_id); ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true); } } // if (room_id == 1 || time1 == time) // { // schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, TextBox2.Text, DropDownList3.SelectedValue.ToString(), room_id, doc.emp_doc_id); // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true); // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('มีแพทย์อยู่ห้องตรวจแล้ว12');", true); //} //else // { // schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, TextBox2.Text, DropDownList3.SelectedValue.ToString(), room_id, doc.emp_doc_id); // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true); // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('มีแพทย์อยู่ห้องตรวจแล้ว12');", true); // } /* * if (room_id == 1 && status_room == 0) * { * schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, DropDownList3.SelectedValue.ToString(),1, doc.emp_doc_id); * * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true); * }else if (room_id == 2 && status_room == 0) * { * schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, DropDownList3.SelectedValue.ToString(), 2, doc.emp_doc_id); * * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true); * } * else if (room_id == 3 && status_room == 0) * { * schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, DropDownList3.SelectedValue.ToString(), 3, doc.emp_doc_id); * * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true); * } * */ } } else { ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ห้องตรวจซ้ำกรุณาลงใหม่');", true); } } }
protected void btnsummit_Click(object sender, EventArgs e) { string name = "" + Session["doc_name"]; // int s = 1; DateTime day = Convert.ToDateTime(txtswdwork.Text); string time1 = DropDownList1.SelectedValue.ToString(); schedule_work_doctor swd1 = schedule_work_doctor.check_room(day, time1); if (swd1 != null) { int room_id = swd1.room_id; int status_room = swd1.swd_status_room; string time = swd1.swd_start_time; doctor doc = doctor.doc_idshow(name); if (doc != null) { int doc_id = doc.emp_doc_id; schedule_work_doctor swd2 = schedule_work_doctor.check_room_3(day, time, room_id); schedule_work_doctor swd4 = schedule_work_doctor.check_room_5(day, doc_id); int swd5 = schedule_work_doctor.check_room_6(day, doc_id); if (swd5 == 1) { ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('มีแพทย์ทำงานในห้องตรวจแล้ว');", true); } else { if (swd2 != null) { if (swd4 != null) { int roomiddoc = swd4.room_id; int docid = swd4.emp_doc_id; int swd3 = schedule_work_doctor.check_room_4(roomiddoc, day); if (swd3 == 0) { ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('มีแพทย์ทำงานห้องตรวจแล้ว');", true); } else { schedule_work_doctor swd = new schedule_work_doctor(txtday.Text, txtswdwork.Text, time1, roomiddoc, doc.emp_doc_id); ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd2(swd) + "');", true); Response.Redirect("../Page/index_doctor.aspx"); } } else { schedule_work_doctor swd = new schedule_work_doctor(txtday.Text, txtswdwork.Text, time1, room_id, doc.emp_doc_id); ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd2(swd) + "');", true); Response.Redirect("../Page/index_doctor.aspx"); } } } // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + room_id + "');", true); /* schedule_work_doctor swd = new schedule_work_doctor(txtday.Text, txtswdwork.Text, time1, room_id, doc.emp_doc_id); * if (room_id == 1 || time1 == time) * { * * string update = schedule_work_doctor.updateswd2(swd); * if (update == "ห้องตรวจซ้ำ กรุณาเลือกใหม่") * { * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ห้องตรวจซ้ำ กรุณาเลือกใหม่');", true); * } * else * { * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd2(swd) + "');", true); * Response.Redirect("../Page/index_doctor.aspx"); * } * * * // Response.Redirect("../Page/index_doctor.aspx"); * // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + room_id + "');", true); * * * } * else * { * string update = schedule_work_doctor.updateswd2(swd); * if (update == "ห้องตรวจซ้ำ กรุณาเลือกใหม่") * { * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('ห้องตรวจซ้ำ กรุณาเลือกใหม่');", true); * } * else * { * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd2(swd) + "');", true); * Response.Redirect("../Page/index_doctor.aspx"); * } * * * // ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd2(swd) + "');", true); * // Response.Redirect("../Page/index_doctor.aspx"); * } */ /* * if (room_id == 1 && status_room == 0) * { * schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, DropDownList3.SelectedValue.ToString(),1, doc.emp_doc_id); * * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true); * }else if (room_id == 2 && status_room == 0) * { * schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, DropDownList3.SelectedValue.ToString(), 2, doc.emp_doc_id); * * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true); * } * else if (room_id == 3 && status_room == 0) * { * schedule_work_doctor swd = new schedule_work_doctor(txtdate.Text, DropDownList3.SelectedValue.ToString(), 3, doc.emp_doc_id); * * ClientScript.RegisterStartupScript(GetType(), "hwa", "alert('" + schedule_work_doctor.updateswd(swd) + "');", true); * } * */ } } }