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