private void BtnNoteAdd_Click(object sender, EventArgs e) { //throw new NotImplementedException(); ic.cStf.staff_id = ""; FrmPasswordConfirm frm = new FrmPasswordConfirm(ic); frm.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { Note1 note = new Note1(); note.active = "1"; note.date_cancel = ""; note.date_create = ""; note.date_modi = ""; note.note_1 = txtNote.Text; note.note_2 = ""; note.note_id = txtNoteId.Text; note.remark = ""; note.t_patient_id = ptt.t_patient_id; note.user_cancel = ""; note.user_create = ""; note.user_modi = ""; note.status_all = chkNoteAll.Checked ? "1" : "0"; note.b_service_point_id = "2120000000"; ic.ivfDB.noteDB.insertNote(note, ic.cStf.staff_id); setGrfNote(); txtNote.Value = ""; } }
private void openOrNew(String reqId, String name) { ic.cStf.staff_id = ""; FrmPasswordConfirm frm1 = new FrmPasswordConfirm(ic); frm1.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { String re = ic.ivfDB.orreqDB.UpdateStatusOrAccept(reqId, ic.cStf.staff_id); long chk1 = 0; if (long.TryParse(re, out chk1)) { OrTOperation opu1 = ic.ivfDB.setOR(reqId); String re1 = ic.ivfDB.oropDB.insert(opu1, ic.cStf.staff_id); if (long.TryParse(re1, out chk1)) { FrmOrAdd frm = new FrmOrAdd(ic, menu, re1, "", "", re1); String txt = ""; if (!name.Equals("")) { txt = "ป้อน OR " + name; } frm.FormBorderStyle = FormBorderStyle.None; menu.AddNewTab(frm, txt); } } } }
private void BtnSave_Click(object sender, EventArgs e) { //throw new NotImplementedException(); if (txtId.Text.Equals("")) { MessageBox.Show("ID ไม่ถูกต้อง ", ""); return; } ic.cStf.staff_id = ""; FrmPasswordConfirm frm = new FrmPasswordConfirm(ic); frm.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { setEggSti(); String re = ic.ivfDB.eggsDB.insertEggSti(eggs, ic.cStf.staff_id); for (int i = 1; i <= 17; i++) { if (grfEggsd.Rows[i][colEdit] == null) { continue; } if (grfEggsd.Rows[i][colEdit].ToString().Equals("1")) { EggStiDay eggsd = new EggStiDay(); eggsd.egg_sti_day_id = grfEggsd.Rows[i][colId].ToString(); eggsd.egg_sti_id = txtId.Text; eggsd.day1 = i.ToString(); eggsd.date = ""; eggsd.e2 = grfEggsd.Rows[i][colE2].ToString(); eggsd.lh = grfEggsd.Rows[i][colLH].ToString(); eggsd.active = ""; eggsd.remark = ""; eggsd.fsh = grfEggsd.Rows[i][colFSH].ToString(); eggsd.date_create = ""; eggsd.date_modi = ""; eggsd.date_cancel = ""; eggsd.user_create = ""; eggsd.user_modi = ""; eggsd.user_cancel = ""; eggsd.prolactin = grfEggsd.Rows[i][colProlactin].ToString(); eggsd.rt_ovary_1 = grfEggsd.Rows[i][colRt1].ToString(); eggsd.rt_ovary_2 = grfEggsd.Rows[i][colRt2].ToString(); eggsd.lt_ovary_1 = grfEggsd.Rows[i][colLt1].ToString(); eggsd.lt_ovary_2 = grfEggsd.Rows[i][colLt2].ToString(); eggsd.endo = grfEggsd.Rows[i][colEndo].ToString(); eggsd.medication = grfEggsd.Rows[i][colMedi].ToString(); ic.ivfDB.eggsdDB.insertEggStiDay(eggsd, ic.cStf.staff_id); } } } }
private void BtnSave_Click(object sender, EventArgs e) { //throw new NotImplementedException(); ic.cStf.staff_id = ""; Boolean chkSave = false; FrmPasswordConfirm frm = new FrmPasswordConfirm(ic); frm.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { setLabPrescription(); ic.ivfDB.lPrescDB.insertPrescription(labPresc, ic.cStf.staff_id); } }
private void BtnSave_Click(object sender, EventArgs e) { //throw new NotImplementedException(); ic.cStf.staff_id = ""; Boolean chkSave = false; FrmPasswordConfirm frm = new FrmPasswordConfirm(ic); frm.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { String re = ""; re = ic.ivfDB.lFormaDB.updateStatusOPUtimeModiAccept(txtID.Text); long chk = 0; if (long.TryParse(re, out chk)) { Close(); } } }
private void BtnSave_Click(object sender, EventArgs e) { //throw new NotImplementedException(); ic.cStf.staff_id = ""; FrmPasswordConfirm frm = new FrmPasswordConfirm(ic); frm.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { setOrRequest(); String re = ""; long chk = 0; re = ic.ivfDB.orreqDB.insertOrRequest(orreq, ic.cStf.staff_id); if (long.TryParse(re, out chk)) { btnSave.Image = Resources.accept_database24; setGrfReqOr(txtPttId.Text); } else { } } }
private void BtnReq_Click(object sender, EventArgs e) { //throw new NotImplementedException(); if (btnReq.Text.Equals("Confirm Request")) { stt.Hide(); setLabRequest(); String re = ic.ivfDB.lbReqDB.insertLabRequest(lbReq, txtStfConfirmID.Text); long chk = 0; if (long.TryParse(re, out chk)) { btnReq.Image = Resources.accept_database24; System.Threading.Thread.Sleep(2000); this.Dispose(); } } else { ic.cStf.staff_id = ""; FrmPasswordConfirm frm = new FrmPasswordConfirm(ic); frm.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { txtUserReq.Value = ic.cStf.staff_fname_t + " " + ic.cStf.staff_lname_t; txtStfConfirmID.Value = ic.cStf.staff_id; btnReq.Text = "Confirm Request"; btnReq.Image = Resources.Add_ticket_24; stt.Show("<p><b>สวัสดี</b></p>คุณ " + ic.cStf.staff_fname_t + " " + ic.cStf.staff_lname_t + "<br> กรุณายินยันการ confirm อีกครั้ง", btnReq); } else { btnReq.Text = "Request"; btnReq.Image = Resources.Ticket_24; } } }
private void ContextMenu_pkgd_delete(object sender, System.EventArgs e) { ic.cStf.staff_id = ""; FrmPasswordConfirm frm = new FrmPasswordConfirm(ic); frm.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { if (grfPkgD.Row < 0) { return; } if (grfPkgD[grfPkgD.Row, coldID] == null) { return; } String id = grfPkgD[grfPkgD.Row, coldID].ToString(); //String name = grfPkgD[grfPkgD.Row, coldName].ToString(); //String qty = grfPkgD[grfPkgD.Row, coldQty].ToString(); ic.ivfDB.oPkgdDB.voidPackageDetail(id, ic.cStf.staff_id); setGrfPkgD(txtID.Text); } }
private void BtnSave_Click(object sender, EventArgs e) { //throw new NotImplementedException(); ic.cStf.staff_id = ""; FrmPasswordConfirm frm = new FrmPasswordConfirm(ic); frm.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { setLabFormDay1(); String re = ""; long chk = 0; re = ic.ivfDB.lformDay1DB.insertLabFormday1(lFormDay1, ic.cStf.staff_id); if (long.TryParse(re, out chk)) { if (chk > 1) { LabFormDay1 formday1 = new LabFormDay1(); formday1 = ic.ivfDB.lformDay1DB.selectByPk1(re); txtFormDay1Code.Value = formday1.form_day1_code; } } } }
private void BtnGenEggSti_Click(object sender, EventArgs e) { //throw new NotImplementedException(); String lmpdate = ""; DateTime lmpdate1 = new DateTime(); lmpdate = ic.datetoDB(txtVisitLMP.Text); if (!DateTime.TryParse(lmpdate, out lmpdate1)) { MessageBox.Show("วันที่ LMP Date ไม่ถูกต้อง ", ""); return; } if (MessageBox.Show("ต้องการ Day Egg Sti \nวันที่ LMP Date " + txtVisitLMP.Text, "", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.OK) { setEggSti(); ic.cStf.staff_id = ""; FrmPasswordConfirm frm = new FrmPasswordConfirm(ic); frm.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { int chk = 0; String re = ic.ivfDB.eggsDB.insertEggSti(eggs, ic.cStf.staff_id); if (int.TryParse(re, out chk)) { txtId.Value = re; lmpdate = ic.datetoDB(txtVisitLMP.Text); if (DateTime.TryParse(lmpdate, out lmpdate1)) { for (int i = 1; i <= 17; i++) { if (i != 1) { lmpdate1 = lmpdate1.AddDays(1); } EggStiDay eggsd = new EggStiDay(); eggsd.egg_sti_day_id = ""; eggsd.egg_sti_id = re; eggsd.day1 = i.ToString(); eggsd.date = ic.datetoDB(lmpdate1.Year.ToString() + "-" + lmpdate1.ToString("MM-dd")); eggsd.e2 = ""; eggsd.lh = ""; eggsd.active = ""; eggsd.remark = ""; eggsd.fsh = ""; eggsd.date_create = ""; eggsd.date_modi = ""; eggsd.date_cancel = ""; eggsd.user_create = ""; eggsd.user_modi = ""; eggsd.user_cancel = ""; eggsd.prolactin = ""; eggsd.rt_ovary_1 = ""; eggsd.rt_ovary_2 = ""; eggsd.lt_ovary_1 = ""; eggsd.lt_ovary_2 = ""; eggsd.endo = ""; eggsd.medication = ""; ic.ivfDB.eggsdDB.insertEggStiDay(eggsd, ic.cStf.staff_id); } } setControlEggSti(); } } } }
private void ContextMenu_edit(object sender, System.EventArgs e) { String chk1 = "", name = "", id = "", vsid = "", resid = ""; if (grfReq.Row < 0) { return; } id = grfReq[grfReq.Row, colReqId] != null ? grfReq[grfReq.Row, colReqId].ToString() : ""; vsid = grfReq[grfReq.Row, colReqVsId] != null ? grfReq[grfReq.Row, colReqVsId].ToString() : ""; if (id.Length <= 0) { return; } ic.cStf.staff_id = ""; FrmPasswordConfirm frm1 = new FrmPasswordConfirm(ic); frm1.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { LabRequest req = new LabRequest(); req = ic.ivfDB.lbReqDB.selectByPk1(id); if (req.status_req.Equals("2") || req.status_req.Equals("4")) { // มีคนอื่น double click รับ request ไปแล้ว ที่ ดัก status เพราะ กัน รับ request แล้ว เกิด record ซ้อนกัน 2 record } else { DataTable dtVs = new DataTable(); dtVs = ic.ivfDB.lbReqDB.selectLabBloodByVsid(vsid); foreach (DataRow rowVs in dtVs.Rows) { String id1 = ""; id1 = rowVs[ic.ivfDB.lbReqDB.lbReq.req_id].ToString(); LabRequest lbreq = new LabRequest(); lbreq = ic.ivfDB.lbReqDB.selectByPk1(id1); if (lbreq.req_id.Length <= 0) { continue; } Lis lis = new Lis(); lis.lis_id = ""; lis.barcode = ""; lis.req_id = lbreq.req_id; lis.visit_vn = lbreq.vn; if (lbreq.name_female.Length > 0) { lis.patient_name = lbreq.name_female; lis.visit_hn = lbreq.hn_female; } else { lis.patient_name = lbreq.name_male; lis.visit_hn = lbreq.hn_male; } lis.visit_id = lbreq.visit_id; lis.message_lis = ""; lis.active = ""; lis.remark = ""; lis.date_create = ""; lis.date_modi = ""; lis.date_cancel = ""; lis.user_create = ""; lis.user_modi = ""; lis.user_cancel = ""; lis.statis_lis = ""; lis.date_time_receive = ""; lis.date_time_finish = ""; lis.lab_id = lbreq.item_id; String re = "", re1 = "", re2 = ""; long chk = 0, chk2 = 0; re1 = ic.ivfDB.lisDB.insertLis(lis, ic.cStf.staff_id); if (long.TryParse(re1, out chk)) { LabResult lbRes = new LabResult(); OldLabItem labi = new OldLabItem(); labi = ic.ivfDB.oLabiDB.selectByPk1(lbreq.item_id); lbRes.result_id = ""; lbRes.lis_id = re1; lbRes.req_id = lbreq.req_id; lbRes.visit_id = lbreq.visit_id; lbRes.patient_id = ""; lbRes.lab_id = lbreq.item_id; lbRes.result = ""; lbRes.method = ""; lbRes.active = ""; lbRes.remark = ""; lbRes.date_create = ""; lbRes.date_modi = ""; lbRes.date_cancel = ""; lbRes.user_create = ""; lbRes.user_modi = ""; lbRes.user_cancel = ""; lbRes.unit = ""; lbRes.sort1 = ""; lbRes.staff_id_result = ""; lbRes.staff_id_approve = ""; lbRes.date_time_result = ""; lbRes.date_time_approve = ""; lbRes.normal_value = labi.normal_vaule; lbRes.interpret = ""; lbRes.status_result = "1"; lbRes.row1 = "0"; DateTime date1 = new DateTime(); DateTime.TryParse(lbreq.req_time, out date1); //lbRes.req_date_time = date1.Year+"-"+ date1.ToString("MM-dd")+" " + date1.ToString("HH:mm:ss"); lbRes.req_date_time = lbreq.req_time; lbRes.date_time_receive = System.DateTime.Now.Year + "-" + System.DateTime.Now.ToString("MM-dd HH:mm:ss"); lbRes.doctor_id = lbreq.doctor_id; lbRes.date_time_collect = lbRes.req_date_time; lbRes.remark_nurse = lbreq.remark; re2 = ic.ivfDB.lbresDB.insertLabResult(lbRes, ic.cStf.staff_id); if (long.TryParse(re2, out chk2)) { resid = re2; re = ic.ivfDB.lbReqDB.UpdateStatusRequestAccept(lbreq.req_id, ic.cStf.staff_id); chk = 0; if (long.TryParse(re, out chk)) { // ยังไม่ได้ต่อ LIS 62-08-03 //try //{ // SetDefaultPrinter(ic.iniC.printerSticker); // Lis lis1 = new Lis(); // lis1 = ic.ivfDB.lisDB.selectByPk(re1); // Visit vs = new Visit(); // vs = ic.ivfDB.vsDB.selectByVn(lis1.visit_vn); // Patient ptt = new Patient(); // ptt = ic.ivfDB.pttDB.selectByPk1(vs.t_patient_id); // DataTable dt = new DataTable(); // dt.Columns.Add("hn", typeof(String)); // dt.Columns.Add("name", typeof(String)); // dt.Columns.Add("age", typeof(String)); // dt.Columns.Add("vn", typeof(String)); // DataRow row11 = dt.NewRow(); // row11["hn"] = lis1.visit_hn; // row11["name"] = lis1.patient_name; // row11["age"] = "Age " + ptt.AgeStringShort() + " [" + ic.datetoShow(ptt.patient_birthday) + "]"; // row11["vn"] = lis1.barcode; // dt.Rows.Add(row11); // FrmReport frm = new FrmReport(ic); // frm.setStickerPatientThemalLIS(dt); // frm.ShowDialog(this); // SetDefaultPrinter(ic.iniC.printerSticker); //} //catch (Exception ex) //{ // MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); // return; //} // ยังไม่ได้ต่อ LIS 62-08-03 } } } } } } //String id = ""; //id = grfProc[grfProc.Row, colRsId] != null ? grfProc[grfProc.Row, colRsId].ToString() : ""; FrmLabBloodAdd frm = new FrmLabBloodAdd(ic, resid); frm.ShowDialog(this); setGrfReq(); //chk = grfReq[grfReq.Row, colRqReqNum] != null ? grfReq[grfReq.Row, colRqReqNum].ToString() : ""; //name = grfReq[grfReq.Row, colRqName] != null ? grfReq[grfReq.Row, colRqName].ToString() : ""; ////if (MessageBox.Show("ต้องการ ป้อน LAB OPU \n req number " + chk+" \n name "+ name, "", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.OK) ////{ ////grfReq.Rows.Remove(grfReq.Row); //Cursor curOld; //curOld = this.Cursor; //this.Cursor = Cursors.WaitCursor; //openLabOPUNew(id, name); //setGrfReq(); //setGrfProc(""); //this.Cursor = curOld; //} }
private void acceptLabOPUAdd(String reqid, String name, String vn, String dtrid, String remark, String hn, Boolean flagOpen, String dobfemale, String itmcode) { ic.cStf.staff_id = ""; FrmPasswordConfirm frm = new FrmPasswordConfirm(ic); frm.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { lbReq = ic.ivfDB.setLabRequest(name, vn, dtrid, remark, hn, dobfemale, reqid, itmcode, "", "", "", "", "", ""); String re = ic.ivfDB.lbReqDB.insertLabRequest(lbReq, ""); long chk1 = 0; if (long.TryParse(re, out chk1)) { String re1 = ic.ivfDB.lbReqDB.UpdateStatusRequestAccept(re, ic.cStf.staff_id); String re4 = ic.ivfDB.lbReqDB.UpdateStatusRequestProcess(re, ic.cStf.staff_id); String re2 = ic.ivfDB.lbReqDB.UpdateStatusRequestAcceptOld(reqid, re); if (long.TryParse(re2, out chk1)) { //LabOpu opu = new LabOpu(); //LabRequest lbreq = new LabRequest(); //lbreq = ic.ivfDB.lbReqDB.selectByPk1(reqId); //opu.opu_id = ""; //opu.opu_code = ic.ivfDB.copDB.genOPUDoc(); //opu.embryo_freez_stage = ""; //opu.embryoid_freez_position = ""; //opu.hn_male = ""; //opu.hn_female = lbreq.hn_female; //opu.name_male = ""; //opu.name_female = lbreq.name_female; //opu.remark = ""; //opu.dob_female = ""; //opu.dob_male = ""; //opu.doctor_id = lbreq.doctor_id; //opu.proce_id = ""; //opu.opu_date = DateTime.Now.Year.ToString()+"-"+ System.DateTime.Now.ToString("MM-dd"); //opu.req_id = reqId; LabOpu opu = ic.ivfDB.setOPU(re); String re3 = ic.ivfDB.opuDB.insert(opu, ic.cStf.staff_id); if (long.TryParse(re3, out chk1)) { setGrfReq(); if (flagOpen) { if (itmcode.Equals("112")) { FrmLabOPUAdd2 frm1 = new FrmLabOPUAdd2(ic, "", re3); String txt = ""; if (!name.Equals("")) { txt = "ป้อน LAB OPU " + name; } else { txt = "ป้อน LAB OPU ใหม่ "; } frm1.FormBorderStyle = FormBorderStyle.None; menu.AddNewTab(frm1, txt); } else if (itmcode.Equals("160")) { FrmLabFetAdd3 frm1 = new FrmLabFetAdd3(ic, "", re3); String txt = ""; if (!name.Equals("")) { txt = "ป้อน LAB OPU " + name; } else { txt = "ป้อน LAB OPU ใหม่ "; } frm1.FormBorderStyle = FormBorderStyle.None; menu.AddNewTab(frm1, txt); } } } else { MessageBox.Show("Error gen OPU", ""); } } else { MessageBox.Show("ไม่สามารถ update status accept", "error"); } } //int chk = 0; } }
private void BtnVisit_Click(object sender, EventArgs e) { //throw new NotImplementedException(); if (btnVisit.Text.Equals("Confirm")) { stt.Hide(); String re = "", re1 = ""; if (ic.iniC.statusAppDonor.Equals("1")) { setVisit(); re = ic.ivfDB.vsDB.insertVisit(vs, txtStfConfirmID.Text); } else { setVisitOld(); re = ic.ivfDB.ovsDB.insertVisitOld(vsOld, txtStfConfirmID.Text, "new"); long chk1 = 0; if (long.TryParse(re, out chk1)) { setVisit(); vs.visit_vn = re; re = ic.ivfDB.ovsDB.updateVEndTimeNull(vsOld.VN); re1 = ic.ivfDB.vsDB.insertVisit(vs, txtStfConfirmID.Text); } } long chk = 0; if (long.TryParse(re, out chk)) { //if (!ic.iniC.statusAppDonor.Equals("1")) //{ //String re1 = ic.ivfDB.pttOldDB.insertPatientOld(ptt, txtStfConfirmID.Text); //if (int.TryParse(re1, out chk)) //{ //if (txtID.Text.Equals("")) //{ // //PatientOld pttOld = new PatientOld(); // //pttOld = ic.ivfDB.pttOldDB.selectByPk1(re1); // String re2 = ic.ivfDB.pttDB.updatePID(re, re1); // if (int.TryParse(re2, out chk)) // { txtID.Value = re; btnVisit.Text = "Save Visit"; btnVisit.Image = Resources.accept_database24; // txtID.Value = re; // txtPid.Focus(); // } //} //} //} System.Threading.Thread.Sleep(500); this.Dispose(); } } else { ic.cStf.staff_id = ""; FrmPasswordConfirm frm = new FrmPasswordConfirm(ic); frm.ShowDialog(this); if (!ic.cStf.staff_id.Equals("")) { txtUserReq.Value = ic.cStf.staff_fname_t + " " + ic.cStf.staff_lname_t; txtStfConfirmID.Value = ic.cStf.staff_id; btnVisit.Text = "Confirm"; btnVisit.Image = Resources.Add_ticket_24; stt.Show("<p><b>สวัสดี</b></p>คุณ " + ic.cStf.staff_fname_t + " " + ic.cStf.staff_lname_t + "<br> กรุณายินยันการ confirm อีกครั้ง", cboPttType); btnVisit.Focus(); } else { btnVisit.Text = "new Visit"; btnVisit.Image = Resources.download_database24; } } }