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;
}
}
}
