private void ContextMenu_edit(object sender, System.EventArgs e)
{
String hn = "", name = "", pttid = "", vn = "";
//pttid = grfPtt[grfPtt.Row, colPttId] != null ? grfPtt[grfPtt.Row, colPttId].ToString() : "";
vn = grfPtt[grfPtt.Row, colVN] != null ? grfPtt[grfPtt.Row, colVN].ToString() : "";
hn = grfPtt[grfPtt.Row, colHn] != null ? grfPtt[grfPtt.Row, colHn].ToString() : "";
name = grfPtt[grfPtt.Row, colName] != null ? grfPtt[grfPtt.Row, colName].ToString() : "";
//if (MessageBox.Show("ต้องการ แก้ไข Patient \n hn number " + chk + " \n name " + name, "", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.OK)
//{
//grfReq.Rows.Remove(grfReq.Row);
//VisitAdd(pttid, vn, name, pttid);
//}
String date = "", date1 = "";
date = DateTime.Now.Year + "-" + DateTime.Now.ToString("MM-dd");
DataTable dt = new DataTable();
date = "2018-11-05";
date1 = "05-11-2018";
dt = ic.ivfDB.oJpxdDB.selectByVN2(vn);
//if (dt.Rows.Count <= 0) return;
FrmReport frm = new FrmReport(ic);
frm.setStickerDrugReport(date, dt, "");
frm.ShowDialog(this);
}
private void BtnPrint_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
FrmReport frm = new FrmReport(ic);
DataTable dt = new DataTable();
dt = ic.ivfDB.orreqDB.selectByOrAppointment(txtID.Text);
dt.Rows[0]["age"] = txtDob.Text;
frm.setOrAppointment(dt);
frm.ShowDialog(this);
}
private void BtnFinish_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
SetDefaultPrinter(ic.iniC.printerA4);
String date = "";
date = DateTime.Now.ToString("dd/MM/") + DateTime.Now.Year;
FrmReport frm = new FrmReport(ic);
frm.setOpdAuthenSign(txtPttNameE.Text, txtHn.Text, txtDob.Text, cboDoctor.Text, cboAnes.Text, date, cboOperation.Text);
frm.ShowDialog(this);
}
private void ContextMenu_order_prn_df(object sender, System.EventArgs e)
{
String or_date = "", name = "", diagnosis = "", operation = "", hn = "";
or_date = grfOpera[grfOpera.Row, colQueOrDate] != null ? grfOpera[grfOpera.Row, colQueOrDate].ToString() : "";
diagnosis = grfOpera[grfOpera.Row, colQueRemark] != null ? grfOpera[grfOpera.Row, colQueRemark].ToString() : "";
name = grfOpera[grfOpera.Row, colQueName] != null ? grfOpera[grfOpera.Row, colQueName].ToString() : "";
hn = grfOpera[grfOpera.Row, colQueHn] != null ? grfOpera[grfOpera.Row, colQueHn].ToString() : "";
operation = grfOpera[grfOpera.Row, colQueOpera] != null ? grfOpera[grfOpera.Row, colQueOpera].ToString() : "";
FrmReport frm = new FrmReport(ic);
frm.setORDf(name, hn, or_date, diagnosis, operation);
frm.ShowDialog(this);
}
private void ContextMenu_order_prn_form_a(object sender, System.EventArgs e)
{
String or_date = "", name = "", diagnosis = "", operation = "", hn = "", surgeon = "", age = "", anesthesia;
or_date = grfOpera[grfOpera.Row, colQueOrDate] != null ? grfOpera[grfOpera.Row, colQueOrDate].ToString() : "";
diagnosis = grfOpera[grfOpera.Row, colQueRemark] != null ? grfOpera[grfOpera.Row, colQueRemark].ToString() : "";
name = grfOpera[grfOpera.Row, colQueName] != null ? grfOpera[grfOpera.Row, colQueName].ToString() : "";
hn = grfOpera[grfOpera.Row, colQueHn] != null ? grfOpera[grfOpera.Row, colQueHn].ToString() : "";
operation = grfOpera[grfOpera.Row, colQueOpera] != null ? grfOpera[grfOpera.Row, colQueOpera].ToString() : "";
surgeon = grfOpera[grfOpera.Row, colQueSurgeon] != null ? grfOpera[grfOpera.Row, colQueSurgeon].ToString() : "";
age = grfOpera[grfOpera.Row, colQueOpera] != null ? grfOpera[grfOpera.Row, colQueOpera].ToString() : "";
anesthesia = grfOpera[grfOpera.Row, colQueAnes] != null ? grfOpera[grfOpera.Row, colQueAnes].ToString() : "";
FrmReport frm = new FrmReport(ic);
frm.setORFormA(name, hn, or_date, diagnosis, operation, surgeon, age, anesthesia);
frm.ShowDialog(this);
}
private void BtnPrint_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
FrmReport frm = new FrmReport(ic);
DataTable dt = new DataTable();
dt = ic.ivfDB.eggsdDB.selectByEggStiId(txtId.Text);
dt.Columns.Add("status_abnormal", typeof(String));
dt.Columns.Add("abnormal1", typeof(String));
dt.Columns.Add("abnormal2", typeof(String));
dt.Columns.Add("status_typing", typeof(String));
dt.Columns.Add("status_typing_other", typeof(String));
dt.Columns.Add("typing_other", typeof(String));
dt.Columns.Add("status_infectious", typeof(String));
dt.Columns.Add("status_add_lab", typeof(String));
dt.Columns.Add("add_lab", typeof(String));
dt.Columns.Add("bhcg", typeof(String));
String date1 = "";
foreach (DataRow row in dt.Rows)
{
date1 = ic.datetoShow(row["date"].ToString());
row["date"] = date1.Replace("-", "/");
row["status_abnormal"] = chkAbnormal.Checked ? "1": "0";
row["abnormal1"] = txtAbnormal1.Text;
row["abnormal2"] = txtAbnormal2.Text;
row["status_typing"] = chkTyping.Checked ? "1" : "0";
row["status_typing_other"] = chkOther.Checked ? "1" : "0";;
row["typing_other"] = cboOther.Text;
row["status_infectious"] = chkInfection.Checked ? "1" : "0";
row["status_add_lab"] = chkAmh.Checked ? "1" : "0";
row["add_lab"] = cboAmh.Text;
row["bhcg"] = cboBhcg.Text;
//row["status_abnormal"] = "";
//row["status_abnormal"] = "";
}
frm.setEggStiReport(dt, txtPttNameE.Text, "", txtVisitLMP.Text, txtG.Text, txtP.Text, txtA.Text, cboDoctor.Text
, txtOPUDate.Text, txtOPUTime.Text, txtEmbryoTranferDate.Text, txtEmbryoTranferTime.Text, txtAllergy.Text, txtVisitHeight.Text, txtVisitBP.Text, txtVisitBW.Text, txtVisitPulse.Text);
frm.ShowDialog(this);
}
private void BtnPrnCheckList1_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
FrmReport frm = new FrmReport(ic);
DataTable dt = new DataTable();
String path_pic = "";
dt = ic.ivfDB.vsDB.selectByCheckList1(txtPttId.Text, txtID.Text);
//path_pic = dt.Rows[0]["path_pic"] != null ? dt.Rows[0]["path_pic"].ToString(): "";
path_pic = System.IO.Directory.GetCurrentDirectory() + "\\" + "check_list_1.jpg";
dt.Rows[0]["path_pic"] = path_pic;
dt.Rows[0]["mobile"] = txtMobile11.Text;
dt.Rows[0]["pulse"] = txtPulse1.Text;
dt.Rows[0]["height"] = txtHeight1.Text;
dt.Rows[0]["bw"] = txtBW1.Text;
dt.Rows[0]["bp"] = txtBP1.Text;
dt.Rows[0]["lmp"] = txtLMP1.Text;
dt.Rows[0]["path_pic"] = path_pic;
frm.setVisitCheckList1Report(dt);
frm.ShowDialog(this);
}
private void ContextMenu_sticker(object sender, System.EventArgs e)
{
String chk1 = "", name = "", id = "", vsid = "", resid = "", re3 = "";
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;
}
SetDefaultPrinter(ic.iniC.printerSticker);
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));
dt.Columns.Add("path_barcode", typeof(String));
LabRequest lbreq = new LabRequest();
lbreq = ic.ivfDB.lbReqDB.selectByPk1(id);
Visit vs = new Visit();
vs = ic.ivfDB.vsDB.selectByPk1(vsid);
Patient ptt = new Patient();
ptt = ic.ivfDB.pttDB.selectByPk1(vs.t_patient_id);
Lis lis = new Lis();
lis.lis_id = "";
lis.barcode = "";
lis.req_id = id;
lis.visit_vn = vs.visit_vn;
lis.patient_name = ptt.Name;
lis.visit_hn = ptt.patient_hn;
lis.visit_id = vs.t_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.lab_id;
re3 = ic.ivfDB.lisDB.insertLis(lis, ic.cStf.staff_id);
String re = "", re1 = "", re2 = "";
long chk = 0, chk2 = 0;
Lis lis1 = new Lis();
lis1 = ic.ivfDB.lisDB.selectByPk(re3);
DataRow row11 = dt.NewRow();
row11["hn"] = vs.visit_hn;
row11["name"] = ptt.Name;
row11["age"] = "Age " + ptt.AgeStringShort() + " [" + ic.datetoShow(ptt.patient_birthday) + "]";
row11["vn"] = lis1.barcode;
row11["path_barcode"] = System.IO.Directory.GetCurrentDirectory() + "\\report\\" + lis1.barcode + ".jpg";
dt.Rows.Add(row11);
if (!Directory.Exists("report"))
{
Directory.CreateDirectory("report");
}
if (!File.Exists(System.IO.Directory.GetCurrentDirectory() + "\\report\\" + lis1.barcode + ".jpg"))
{
File.Delete(System.IO.Directory.GetCurrentDirectory() + "\\report\\" + lis1.barcode + ".jpg");
}
C1BarCode barc = new C1BarCode();
if (ic.iniC.lisBarcode.Equals("Code_128_B"))
{
barc.CodeType = C1.BarCode.CodeType.Code_128_B;
}
else if (ic.iniC.lisBarcode.Equals("Code_128_A"))
{
barc.CodeType = C1.BarCode.CodeType.Code_128_A;
}
else if (ic.iniC.lisBarcode.Equals("Code_128_C"))
{
barc.CodeType = C1.BarCode.CodeType.Code_128_C;
}
else if (ic.iniC.lisBarcode.Equals("Code_128auto"))
{
barc.CodeType = C1.BarCode.CodeType.Code_128auto;
}
else if (ic.iniC.lisBarcode.Equals("Code_128auto"))
{
//barc.CodeType = C1.BarCode.CodeType.en;
}
else
{
}
barc.Size = new Size(100, 60);
barc.BarHeight = 60;
barc.Text = lis1.barcode;
Bitmap bitm = new Bitmap(100, 40);
//bitm = barc.Image;
Image img = barc.Image;
//img.Size = new Size(100, 40);
img.Save(System.IO.Directory.GetCurrentDirectory() + "\\report\\" + lis1.barcode + ".jpg", ImageFormat.Jpeg);
FrmReport frm = new FrmReport(ic);
frm.setStickerPatientThemalLIS(dt);
frm.ShowDialog(this);
}
private void ContextMenu_print_sticker(object sender, System.EventArgs e)
{
if (grfOrder.Row < 0)
{
return;
}
if (grfOrder[grfOrder.Row, colOrdid] == null)
{
return;
}
//if (!vsOld.VSID.Equals("166") && vsOld.VSID.Equals("999")) // -0020
if (!vs.vsid.Equals("166") && vs.vsid.Equals("999")) // +0020
{
MessageBox.Show("รอ รับชำระ ไม่สามารถพิมพ์ Sticker ได้", "");
//return;
}
String id = "", date = "";
date = DateTime.Now.Year + "-" + DateTime.Now.ToString("MM-dd");
CellRange cell = grfOrder.Selection;
//if (cell is null) return;
if (cell.TopRow < 1)
{
return;
}
for (int i = cell.TopRow; i <= cell.BottomRow; i++)
{
String pxid = "", status = "", re = "", edit = "", usage = "";
pxid = grfOrder[i, colOrdid].ToString();
status = grfOrder[i, colOrdstatus].ToString();
edit = grfOrder[i, colOrdEdit].ToString();
if (status.Equals("px"))
{
id += pxid + ",";
}
if (cboLangSticker.Text.Trim().Equals("English"))
{
usage = grfOrder[i, colOrdUsE].ToString();
if (edit.Equals("1"))
{
re = ic.ivfDB.oJpxdDB.updateUsageEByID(id, usage);
}
}
else
{
usage = grfOrder[i, colOrdUsT].ToString();
if (edit.Equals("1"))
{
re = ic.ivfDB.oJpxdDB.updateUsageTByID(id, usage);
}
}
}
id = id.Trim();
if (id.Length > 0)
{
if (id.Substring(id.Length - 1).IndexOf(',') >= 0)
{
id = id.Substring(0, id.Length - 1);
}
PrinterSettings settings = new PrinterSettings();
printerOld = settings.PrinterName;
SetDefaultPrinter(ic.iniC.printerSticker);
DataTable dt = new DataTable();
if (cboLangSticker.Text.Trim().Equals("English"))
{
dt = ic.ivfDB.oJpxdDB.selectBypxidFreqEN(id);
}
else
{
dt = ic.ivfDB.oJpxdDB.selectBypxidFreqTH(id);
}
if (dt.Rows.Count > 0)
{
//if (dt.Rows.Count <= 0) return;
foreach (DataRow row in dt.Rows)
{
String qty = "", unit = "";
qty = row["qty"] != null ? row["qty"].ToString() : " ";
unit = row["unit_name"] != null ? row["unit_name"].ToString() : " ";
row["unit_name"] = qty + " " + unit;
//MessageBox.Show("unit "+ row["unit_name"].ToString(), "");
}
ic.ivfDB.oJpxdDB.updateStatusPrintOKByID(id);
if (flagedit.Equals("edit"))
{
ic.ivfDB.oJpxdDB.updateStatusUpStockOKByID(id);
}
FrmReport frm = new FrmReport(ic);
frm.setStickerDrugReport(date, dt, cboLangSticker.Text.Trim());
frm.ShowDialog(this);
}
}
}
private void BtnPrnSticker_Click(object sender, EventArgs e)
{
// throw new NotImplementedException();
PrinterSettings settings = new PrinterSettings();
printerOld = settings.PrinterName;
SetDefaultPrinter(ic.iniC.printerSticker);
//ic.logw.WriteLog("d", "PrinterSticker " + ic.iniC.printerSticker);
String date = "", date1 = "";
date = DateTime.Now.Year + "-" + DateTime.Now.ToString("MM-dd");
DataTable dt = new DataTable();
//date = "2018-11-05";
//date1 = "05-11-2018";
foreach (Row row in grfOrder.Rows)
{
String pxid = "", status = "", re = "", edit = "", usage = "";
pxid = row[colOrdid] != null ? row[colOrdid].ToString() : "";
status = row[colOrdstatus] != null ? row[colOrdstatus].ToString() : "";
edit = row[colOrdEdit] != null ? row[colOrdEdit].ToString() : "";
if (edit.Equals("1"))
{
if (cboLangSticker.Text.Trim().Equals("English"))
{
usage = row[colOrdUsE].ToString();
re = ic.ivfDB.oJpxdDB.updateUsageEByID(pxid, usage);
}
else
{
usage = row[colOrdUsT].ToString();
re = ic.ivfDB.oJpxdDB.updateUsageTByID(pxid, usage);
}
}
}
if (cboLangSticker.Text.Trim().Equals("English"))
{
dt = ic.ivfDB.oJpxdDB.selectByVN1FreqEN(txtVn.Text);
}
else
{
dt = ic.ivfDB.oJpxdDB.selectByVN1FreqTH(txtVn.Text);
}
//if (dt.Rows.Count <= 0) return;
foreach (DataRow row in dt.Rows)
{
String qty = "", unit = "";
qty = row["qty"] != null ? row["qty"].ToString() : " ";
unit = row["unit_name"] != null ? row["unit_name"].ToString() : " ";
row["unit_name"] = qty + " " + unit;
if (ptt.f_patient_nation_id.Equals("1")) // thai
{
row["patient_name"] = ic.ivfDB.fpfDB.getList1(ptt.f_patient_prefix_id) + " " + ptt.patient_firstname + " " + ptt.patient_lastname;
}
//if (cboLangSticker.Text.Trim().Equals("English"))
//{
// row["patient_name"] = txtPttNameE.Text.Trim();
//}
//else
//{
// row["patient_name"] = txtPttName.Text.Trim();
//}
//MessageBox.Show("unit "+ row["unit_name"].ToString(), "");
}
ic.ivfDB.oJpxdDB.updateStatusPrintOKByVN(txtVn.Text);
ic.ivfDB.oJpxdDB.updateStatusUpStockOKByVN(txtVn.Text);
//PrinterSettings settings1 = new PrinterSettings();
//settings1.DefaultPageSettings.PrinterSettings.PrinterName = ic.iniC.printerSticker;
//settings1.PrinterName = ic.iniC.printerSticker;
FrmReport frm = new FrmReport(ic);
frm.setStickerDrugReport(date, dt, cboLangSticker.Text.Trim());
frm.ShowDialog(this);
}
private void BtnPrint_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
DataTable dt = new DataTable();
//dt.NewRow();
//DataRow toInsert = dt.NewRow();
dt.Rows.InsertAt(dt.NewRow(), 0);
dt.Columns.Add("form_day1_id", typeof(String));
dt.Columns.Add("hn_female", typeof(String));
dt.Columns.Add("name_female", typeof(String));
dt.Columns.Add("hn_male", typeof(String));
dt.Columns.Add("name_male", typeof(String));
dt.Columns.Add("dob_female", typeof(String));
dt.Columns.Add("dob_male", typeof(String));
dt.Columns.Add("doctor_name", typeof(String));
dt.Columns.Add("date_request", typeof(String));
dt.Columns.Add("fertili_2_pn", typeof(String));
dt.Columns.Add("status_biopsy", typeof(String));
dt.Columns.Add("pgs", typeof(String));
dt.Columns.Add("ngs", typeof(String));
dt.Columns.Add("pgs_min", typeof(String));
dt.Columns.Add("pgs_max", typeof(String));
dt.Columns.Add("ngs_7_pair", typeof(String));
dt.Columns.Add("ngs_23_pair", typeof(String));
dt.Columns.Add("ngs_min", typeof(String));
dt.Columns.Add("ngs_max", typeof(String));
dt.Columns.Add("embryo_freezing_day", typeof(String));
dt.Columns.Add("embryo_freezing_embryo", typeof(String));
dt.Columns.Add("blastocyst", typeof(String));
dt.Columns.Add("morula", typeof(String));
dt.Columns.Add("cleavage", typeof(String));
dt.Columns.Add("embryo_transfer_fresh_cycle", typeof(String));
dt.Columns.Add("embryo_glue", typeof(String));
dt.Columns.Add("embryo_transfer_fresh_day3", typeof(String));
dt.Columns.Add("embryo_transfer_fresh_day5", typeof(String));
dt.Columns.Add("discard", typeof(String));
dt.Columns.Add("remark", typeof(String));
dt.Columns.Add("embryo_freezing_embryo_max", typeof(String));
//dt.Columns.Add("", typeof(String));
//dt.Columns.Add("", typeof(String));
//dt.Columns.Add("", typeof(String));
dt.Rows[0]["form_day1_id"] = "";
dt.Rows[0]["hn_female"] = txtHnFeMale.Text;
dt.Rows[0]["name_female"] = txtNameFeMale.Text;
dt.Rows[0]["hn_male"] = txtHnMale.Text;
dt.Rows[0]["name_male"] = txtNameMale.Text;
dt.Rows[0]["dob_female"] = txtDobFeMale.Text;
dt.Rows[0]["dob_male"] = txtDobMale.Text;
dt.Rows[0]["doctor_name"] = cboDoctor.SelectedItem == null ? "" : ((ComboBoxItem)cboDoctor.SelectedItem).Value;
dt.Rows[0]["date_request"] = "";
dt.Rows[0]["fertili_2_pn"] = txtFertili2Pn.Text;
dt.Rows[0]["status_biopsy"] = chkBiopsy.Checked == true ? "1" : "0";
dt.Rows[0]["pgs"] = chkPgsMin.Checked == true ? "1" : "0";
dt.Rows[0]["ngs"] = chkNgs.Checked == true ? "1" : "0";
dt.Rows[0]["pgs_min"] = txtPgsMin.Text;
dt.Rows[0]["pgs_max"] = txtPgsMax.Text;
dt.Rows[0]["ngs_7_pair"] = chkNgs7Pair.Checked == true ? "1" : "0";
dt.Rows[0]["ngs_23_pair"] = chkNgs23Pair.Checked == true ? "1" : "0";
dt.Rows[0]["ngs_min"] = txtNgsMin.Text;
dt.Rows[0]["ngs_max"] = txtNgsMax.Text;
dt.Rows[0]["embryo_freezing_day"] = chkEmbryoFreezingDay.Checked == true ? "1" : "0";
dt.Rows[0]["embryo_freezing_embryo"] = cboEmbryoFreezingDay.SelectedItem == null ? "" : ((ComboBoxItem)cboEmbryoFreezingDay.SelectedItem).Value;
dt.Rows[0]["blastocyst"] = chkBlastocyst.Checked == true ? "1" : "0";
dt.Rows[0]["morula"] = chkMorula.Checked == true ? "1" : "0";
dt.Rows[0]["cleavage"] = chkCleavage.Checked == true ? "1" : "0";
dt.Rows[0]["embryo_transfer_fresh_cycle"] = chkEmbryoTransferFresh.Checked == true ? "1" : "0";
dt.Rows[0]["embryo_glue"] = chkEmbryoGlue.Checked == true ? "1" : "0";
dt.Rows[0]["embryo_transfer_fresh_day3"] = chkEmbryoTransferFreshDay3.Checked == true ? "1" : "0";
dt.Rows[0]["embryo_transfer_fresh_day5"] = chkEmbryoTransferFreshDay5.Checked == true ? "1" : "0";
dt.Rows[0]["discard"] = chkDiscard.Checked == true ? "1" : "0";
dt.Rows[0]["remark"] = cboRemark.Text;
dt.Rows[0]["embryo_freezing_embryo_max"] = txtEmbryoFreezingEmbryoMax.Text;
//dt.Rows[0][""]
FrmReport frm = new FrmReport(ic);
frm.setLabFormDay1Report(dt);
frm.ShowDialog(this);
}
