private void setGrfHn() { String datestart = "", dateend = "", hn = "", txt = ""; String[] hn1; DataTable dt = new DataTable(); datestart = bc.datetoDB(txtDateStart.Text); dateend = bc.datetoDB(txtDateEnd.Text); hn = txtHn.Text.Trim(); hn1 = hn.Split(','); if (hn1.Length <= 0) { MessageBox.Show("No data HN", ""); return; } for (int j = 0; j < hn1.Length; j++) { hn1[j] = "'" + hn1[j].Trim() + "'"; txt += hn1[j] + ","; } if (txt.Length > 0) { if (txt.Substring(txt.Length - 1).Equals(",")) { txt = txt.Substring(0, txt.Length - 1); } } dt = bc.bcDB.vsDB.selectVisitByLikeHn(txt, datestart, dateend); grfHn.Clear(); grfHn.Rows.Count = 1; //grfQue.Rows.Count = 1; grfHn.Cols.Count = 20; Column colChk = grfHn.Cols[colHnPrnReqLab]; colChk.DataType = typeof(Boolean); Column colChk2 = grfHn.Cols[colHnPrnReqXray]; colChk2.DataType = typeof(Boolean); Column colChk3 = grfHn.Cols[colHnPrnResLab]; colChk3.DataType = typeof(Boolean); Column colChk4 = grfHn.Cols[colHnPrnResXray]; colChk4.DataType = typeof(Boolean); Column colChk5 = grfHn.Cols[colHnPrnDrug]; colChk5.DataType = typeof(Boolean); Column colChk6 = grfHn.Cols[colHnPrnStaffNote]; colChk6.DataType = typeof(Boolean); grfHn.Cols[colHnPrnDrug].Caption = "ใบยา"; grfHn.Cols[colHnPrnStaffNote].Caption = "Staff N."; grfHn.Cols[colHnPrnReqLab].Caption = "Req Lab"; grfHn.Cols[colHnPrnReqXray].Caption = "Req Xray"; grfHn.Cols[colHnPrnResLab].Caption = "Req Lab"; grfHn.Cols[colHnPrnResXray].Caption = "Res Xray"; grfHn.Cols[colHnVnShow].Caption = "VN"; grfHn.Cols[colHnHn].Caption = "HN"; grfHn.Cols[colHnPttName].Caption = "Patient Name"; grfHn.Cols[colHnVsDate].Caption = "Date"; grfHn.Cols[colHnVsTime].Caption = "Time"; grfHn.Cols[colHnSex].Caption = "Sex"; grfHn.Cols[colHnAge].Caption = "Age"; grfHn.Cols[colHnPaid].Caption = "Paid"; grfHn.Cols[colHnDsc].Caption = "Description"; grfHn.Cols[colHnPrnStaffNote].Width = 60; grfHn.Cols[colHnPrnReqLab].Width = 60; grfHn.Cols[colHnPrnReqLab].Width = 60; grfHn.Cols[colHnPrnReqXray].Width = 60; grfHn.Cols[colHnPrnResLab].Width = 60; grfHn.Cols[colHnPrnResXray].Width = 65; grfHn.Cols[colHnVnShow].Width = 80; grfHn.Cols[colHnHn].Width = 80; grfHn.Cols[colHnPttName].Width = 310; grfHn.Cols[colHnVsDate].Width = 110; grfHn.Cols[colHnVsTime].Width = 80; grfHn.Cols[colHnSex].Width = 60; grfHn.Cols[colHnAge].Width = 80; grfHn.Cols[colHnPaid].Width = 110; grfHn.Cols[colHnDsc].Width = 300; grfHn.ShowCursor = true; //grf.Cols[colPic1].ImageAndText = true; //grf.Cols[colPic2].ImageAndText = true; //grf.Cols[colPic3].ImageAndText = true; //grf.Cols[colPic4].ImageAndText = true; //grf.Styles.Normal.ImageAlign = ImageAlignEnum.CenterTop; //grf.Styles.Normal.TextAlign = TextAlignEnum.CenterBottom; ContextMenu menuGw = new ContextMenu(); //menuGw.MenuItems.Add("&แก้ไข Image", new EventHandler(ContextMenu_edit)); //menuGw.MenuItems.Add("&Rotate Image", new EventHandler(ContextMenu_retate)); //menuGw.MenuItems.Add("Delete Image", new EventHandler(ContextMenu_delete)); grfHn.ContextMenu = menuGw; //foreach (DocGroupScan dgs in bc.bcDB.dgsDB.lDgs) //{ //menuGw.MenuItems.Add("&เลือกประเภทเอกสาร และUpload Image ["+dgs.doc_group_name+"]", new EventHandler(ContextMenu_upload)); String date = ""; //if (lDgss.Count <= 0) getlBsp(); date = txtDateStart.Text; int i = 1; grfHn.Rows.Count = dt.Rows.Count + 1; foreach (DataRow row in dt.Rows) { try { String status = "", vn = ""; Patient ptt = new Patient(); vn = row["MNC_VN_NO"].ToString() + "/" + row["MNC_VN_SEQ"].ToString() + "(" + row["MNC_VN_SUM"].ToString() + ")"; ptt.patient_birthday = bc.datetoDB(row["mnc_bday"].ToString()); grfHn[i, 0] = (i); grfHn[i, colHnPrn] = true; grfHn[i, colHnPrnDrug] = chkDrug.Checked; grfHn[i, colHnPrnStaffNote] = chkStaffNote.Checked; grfHn[i, colHnPrnReqLab] = chkReqLab.Checked; grfHn[i, colHnPrnReqXray] = chkReqXray.Checked; grfHn[i, colHnPrnResLab] = chkResLab.Checked; grfHn[i, colHnPrnResXray] = chkResXray.Checked; grfHn[i, colHnId] = vn; grfHn[i, colHnVnShow] = vn; grfHn[i, colHnVsDate] = bc.datetoShow(row["mnc_date"].ToString()); grfHn[i, colHnHn] = row["MNC_HN_NO"].ToString(); grfHn[i, colHnPttName] = row["prefix"].ToString() + " " + row["MNC_FNAME_T"].ToString() + " " + row["MNC_LNAME_T"].ToString(); grfHn[i, colHnVsTime] = bc.FormatTime(row["mnc_time"].ToString()); //grfQue[i, colQueVnShow] = row["MNC_REQ_DAT"].ToString(); grfHn[i, colHnSex] = row["mnc_sex"].ToString(); grfHn[i, colHnAge] = ptt.AgeStringShort(); grfHn[i, colHnPaid] = row["MNC_FN_TYP_DSC"].ToString(); grfHn[i, colHnSymptom] = row["MNC_SHIF_MEMO"].ToString(); grfHn[i, colHnPreNo] = row["MNC_pre_no"].ToString(); grfHn[i, colHnDsc] = row["MNC_ref_dsc"].ToString(); if ((i % 2) == 0) { grfHn.Rows[i].StyleNew.BackColor = ColorTranslator.FromHtml(bc.iniC.grfRowColor); } i++; } catch (Exception ex) { new LogWriter("e", "FrmPrintCri setGrfHn ex " + ex.Message); } } //addDevice.MenuItems.Add("", new EventHandler(ContextMenu_upload)); //menuGw.MenuItems.Add(addDevice); //} //row1[colVSE2] = row[ic.ivfDB.pApmDB.pApm.e2].ToString().Equals("1") ? imgCorr : imgTran; grfHn.Cols[colHnId].Visible = false; grfHn.Cols[colHnPreNo].Visible = false; grfHn.Cols[colHnPrn].Visible = false; grfHn.Cols[colHnVnShow].AllowEditing = false; grfHn.Cols[colHnHn].AllowEditing = false; grfHn.Cols[colHnPttName].AllowEditing = false; grfHn.Cols[colHnVsDate].AllowEditing = false; grfHn.Cols[colHnVsTime].AllowEditing = false; grfHn.Cols[colHnSex].AllowEditing = false; grfHn.Cols[colHnAge].AllowEditing = false; grfHn.Cols[colHnPaid].AllowEditing = false; grfHn.Cols[colHnSymptom].AllowEditing = false; grfHn.Cols[colHnPreNo].AllowEditing = false; grfHn.Cols[colHnDsc].AllowEditing = false; //grfQue.Cols[colQueVnShow].AllowEditing = false; }
private void setGrfQue() { //grfQue.Clear(); grfQue.Rows.Count = 1; //grfQue.Rows.Count = 1; grfQue.Cols.Count = 18; //Column colpic1 = grf.Cols[colPic1]; //colpic1.DataType = typeof(Image); //Column colpic2 = grf.Cols[colPic2]; //colpic2.DataType = typeof(Image); //Column colpic3 = grf.Cols[colPic3]; //colpic3.DataType = typeof(Image); //Column colpic4 = grf.Cols[colPic4]; //colpic4.DataType = typeof(Image); grfQue.Cols[colQueVnShow].Caption = "VN"; grfQue.Cols[colQueHn].Caption = "HN"; grfQue.Cols[colQuePttName].Caption = "Patient Name"; grfQue.Cols[colQueVsDate].Caption = "Date"; grfQue.Cols[colQueVsTime].Caption = "Time"; grfQue.Cols[colQueSex].Caption = "Sex"; grfQue.Cols[colQueAge].Caption = "Age"; grfQue.Cols[colQuePaid].Caption = "Paid"; grfQue.Cols[colQueSymptom].Caption = "Symptom"; grfQue.Cols[colQueHeight].Caption = "Height"; grfQue.Cols[coolQueBw].Caption = "BW"; grfQue.Cols[colQueBp].Caption = "BP"; grfQue.Cols[colQuePulse].Caption = "Pulse"; grfQue.Cols[colQyeTemp].Caption = "Temp"; grfQue.Cols[colQueDsc].Caption = "Description"; grfQue.Cols[colQueVnShow].Width = 80; grfQue.Cols[colQueHn].Width = 80; grfQue.Cols[colQuePttName].Width = 310; grfQue.Cols[colQueVsDate].Width = 110; grfQue.Cols[colQueVsTime].Width = 80; grfQue.Cols[colQueSex].Width = 60; grfQue.Cols[colQueAge].Width = 80; grfQue.Cols[colQuePaid].Width = 110; grfQue.Cols[colQueSymptom].Width = 300; grfQue.Cols[colQueHeight].Width = 60; grfQue.Cols[coolQueBw].Width = 60; grfQue.Cols[colQueBp].Width = 60; grfQue.Cols[colQuePulse].Width = 60; grfQue.Cols[colQyeTemp].Width = 60; grfQue.Cols[colQueDsc].Width = 300; grfQue.ShowCursor = true; //grf.Cols[colPic1].ImageAndText = true; //grf.Cols[colPic2].ImageAndText = true; //grf.Cols[colPic3].ImageAndText = true; //grf.Cols[colPic4].ImageAndText = true; //grf.Styles.Normal.ImageAlign = ImageAlignEnum.CenterTop; //grf.Styles.Normal.TextAlign = TextAlignEnum.CenterBottom; ContextMenu menuGw = new ContextMenu(); //menuGw.MenuItems.Add("&แก้ไข Image", new EventHandler(ContextMenu_edit)); //menuGw.MenuItems.Add("&Rotate Image", new EventHandler(ContextMenu_retate)); //menuGw.MenuItems.Add("Delete Image", new EventHandler(ContextMenu_delete)); grfQue.ContextMenu = menuGw; //foreach (DocGroupScan dgs in bc.bcDB.dgsDB.lDgs) //{ //menuGw.MenuItems.Add("&เลือกประเภทเอกสาร และUpload Image ["+dgs.doc_group_name+"]", new EventHandler(ContextMenu_upload)); String date = ""; DateTime dtt = new DateTime(); //if (lDgss.Count <= 0) getlBsp(); //new LogWriter("d", "FrmDoctorView1 setGrfQue 01 "); date = txtDate.Text; DataTable dt = new DataTable(); //if (DateTime.TryParse(txtDate.Value.ToString(), out dtt)) //{ // date = dtt.Year.ToString() + "-" + dtt.ToString("MM-dd"); //} //if (date.Length <= 0) //{ // return; //} //this.Text = "Last Update 2020-02-06 Format Date " + System.DateTime.Now.ToString("dd-MM-yyyy") + " [" + date + "] hostFTP " + bc.iniC.hostFTP + " folderFTP " + bc.iniC.folderFTP; //new LogWriter("d", "FrmDoctorView1 setGrfQue 02 date "+ date); dt = bc.bcDB.vsDB.selectVisitByDtr(bc.user.staff_id, bc.datetoDB(date), "queue"); //new LogWriter("d", "FrmDoctorView1 setGrfQue 03 "); int i = 1; grfQue.Rows.Count = dt.Rows.Count + 1; foreach (DataRow row in dt.Rows) { try { String status = "", vn = ""; Patient ptt = new Patient(); vn = row["MNC_VN_NO"].ToString() + "/" + row["MNC_VN_SEQ"].ToString() + "(" + row["MNC_VN_SUM"].ToString() + ")"; ptt.patient_birthday = bc.datetoDB(row["mnc_bday"].ToString()); grfQue[i, 0] = (i); grfQue[i, colQueId] = vn; grfQue[i, colQueVnShow] = vn; grfQue[i, colQueVsDate] = bc.datetoShow(row["mnc_date"].ToString()); grfQue[i, colQueHn] = row["MNC_HN_NO"].ToString(); grfQue[i, colQuePttName] = row["prefix"].ToString() + " " + row["MNC_FNAME_T"].ToString() + " " + row["MNC_LNAME_T"].ToString(); grfQue[i, colQueVsTime] = bc.FormatTime(row["mnc_time"].ToString()); //grfQue[i, colQueVnShow] = row["MNC_REQ_DAT"].ToString(); grfQue[i, colQueSex] = row["mnc_sex"].ToString(); grfQue[i, colQueAge] = ptt.AgeStringShort(); grfQue[i, colQuePaid] = row["MNC_FN_TYP_DSC"].ToString(); grfQue[i, colQueSymptom] = row["MNC_SHIF_MEMO"].ToString(); grfQue[i, colQueHeight] = row["mnc_high"].ToString(); grfQue[i, coolQueBw] = row["mnc_weight"].ToString(); grfQue[i, colQueBp] = row["mnc_bp1_l"].ToString(); grfQue[i, colQuePulse] = row["MNC_ratios"].ToString(); grfQue[i, colQyeTemp] = row["MNC_temp"].ToString(); grfQue[i, colQuePreNo] = row["MNC_pre_no"].ToString(); grfQue[i, colQueDsc] = row["MNC_ref_dsc"].ToString(); if ((i % 2) == 0) { grfQue.Rows[i].StyleNew.BackColor = ColorTranslator.FromHtml(bc.iniC.grfRowColor); } i++; } catch (Exception ex) { new LogWriter("e", "FrmDoctorView setGrfQue ex " + ex.Message); } } grfQue.Cols[0].Visible = true; grfQue.Rows[0].Visible = true; //addDevice.MenuItems.Add("", new EventHandler(ContextMenu_upload)); //menuGw.MenuItems.Add(addDevice); //} //row1[colVSE2] = row[ic.ivfDB.pApmDB.pApm.e2].ToString().Equals("1") ? imgCorr : imgTran; grfQue.Cols[colQueId].Visible = false; grfQue.Cols[colQuePreNo].Visible = false; grfQue.Cols[colQueVnShow].AllowEditing = false; grfQue.Cols[colQueHn].AllowEditing = false; grfQue.Cols[colQuePttName].AllowEditing = false; grfQue.Cols[colQueVsDate].AllowEditing = false; grfQue.Cols[colQueVsTime].AllowEditing = false; grfQue.Cols[colQueSex].AllowEditing = false; grfQue.Cols[colQueAge].AllowEditing = false; grfQue.Cols[colQuePaid].AllowEditing = false; grfQue.Cols[colQueSymptom].AllowEditing = false; grfQue.Cols[colQueHeight].AllowEditing = false; grfQue.Cols[coolQueBw].AllowEditing = false; grfQue.Cols[colQueBp].AllowEditing = false; grfQue.Cols[colQuePulse].AllowEditing = false; grfQue.Cols[colQyeTemp].AllowEditing = false; grfQue.Cols[colQuePreNo].AllowEditing = false; grfQue.Cols[colQueDsc].AllowEditing = false; //grfQue.Cols[colQueVnShow].AllowEditing = false; }
private void setGrf() { grfVs.Clear(); grfVs.Rows.Count = 1; grfVs.Cols.Count = 8; C1TextBox text = new C1TextBox(); grfVs.Cols[colVsVsDate].Editor = text; grfVs.Cols[colVsVn].Editor = text; grfVs.Cols[colVsDept].Editor = text; grfVs.Cols[colVsPreno].Editor = text; grfVs.Cols[colVsVsDate].Width = 100; grfVs.Cols[colVsVn].Width = 80; grfVs.Cols[colVsDept].Width = 100; grfVs.Cols[colVsPreno].Width = 100; grfVs.Cols[colVsStatus].Width = 60; grfVs.ShowCursor = true; //grfVs.AllowMerging = C1.Win.C1FlexGrid.AllowMergingEnum.RestrictRows; grfVs.Cols[colVsVsDate].Caption = "Visit Date"; grfVs.Cols[colVsVn].Caption = "VN"; grfVs.Cols[colVsDept].Caption = "แผนก"; grfVs.Cols[colVsPreno].Caption = ""; grfVs.Cols[colVsPreno].Visible = false; grfVs.Cols[colVsVn].Visible = false; grfVs.Cols[colVsAn].Visible = false; grfVs.Cols[colVsAndate].Visible = false; grfVs.Rows[0].Visible = false; grfVs.Cols[0].Visible = false; grfVs.Cols[colVsVsDate].AllowEditing = false; grfVs.Cols[colVsVn].AllowEditing = false; grfVs.Cols[colVsDept].AllowEditing = false; grfVs.Cols[colVsPreno].AllowEditing = false; DataTable dt = new DataTable(); MessageBox.Show("hn " + hn, ""); dt = bc.bcDB.vsDB.selectVisitByHn3(txtHn.Text); int i = 1, j = 1, row = grfVs.Rows.Count; //txtVN.Value = dt.Rows.Count; //txtName.Value = ""; //txt.Value = ""; foreach (DataRow row1 in dt.Rows) { Row rowa = grfVs.Rows.Add(); String status = "", vn = ""; status = row1["MNC_PAT_FLAG"] != null ? row1["MNC_PAT_FLAG"].ToString().Equals("O") ? "OPD" : "IPD" : "-"; vn = row1["MNC_VN_NO"].ToString() + "/" + row1["MNC_VN_SEQ"].ToString() + "(" + row1["MNC_VN_SUM"].ToString() + ")"; rowa[colVsVsDate] = bc.datetoShow(row1["mnc_date"]); rowa[colVsVn] = vn; rowa[colVsStatus] = status; rowa[colVsPreno] = row1["mnc_pre_no"].ToString(); rowa[colVsDept] = row1["MNC_SHIF_MEMO"].ToString(); rowa[colVsAn] = row1["mnc_an_no"].ToString() + "/" + row1["mnc_an_yr"].ToString(); rowa[colVsAndate] = bc.datetoShow(row1["mnc_ad_date"].ToString()); } //ContextMenu menuGw = new ContextMenu(); //menuGw.MenuItems.Add("&ยกเลิก รูปภาพนี้", new EventHandler(ContextMenu_Void)); //menuGw.MenuItems.Add("&Update ข้อมูล", new EventHandler(ContextMenu_Update)); //foreach (DocGroupScan dgs in bc.bcDB.dgsDB.lDgs) //{ // menuGw.MenuItems.Add("&เลือกประเภทเอกสาร และUpload Image [" + dgs.doc_group_name + "]", new EventHandler(ContextMenu_upload)); //} //grfVs.ContextMenu = menuGw; //grfVs.Cols[colVsVsDate].Visible = false; //grfVs.Cols[colImagePath].Visible = false; //row1[colVSE2] = row[ic.ivfDB.pApmDB.pApm.e2].ToString().Equals("1") ? imgCorr : imgTran; //grfVs.AutoSizeCols(); //grfVs.AutoSizeRows(); //grfVs.Refresh(); //theme1.SetTheme(grfVs, "ExpressionDark"); }
private void setGrfApm() { grfApm.Clear(); grfApm.Rows.Count = 1; //grfQue.Rows.Count = 1; grfApm.Cols.Count = 11; grfApm.Cols[colApmHn].Caption = "HN"; grfApm.Cols[colApmPttName].Caption = "Patient Name"; grfApm.Cols[colApmDate].Caption = "Date"; grfApm.Cols[colApmTime].Caption = "Time"; grfApm.Cols[colApmSex].Caption = "Sex"; grfApm.Cols[colApmAge].Caption = "Age"; grfApm.Cols[colApmDsc].Caption = "Appointment"; grfApm.Cols[colApmRemark].Caption = "Remark"; grfApm.Cols[colApmDept].Caption = "Dept"; grfApm.Cols[colApmHn].Width = 80; grfApm.Cols[colApmPttName].Width = 300; grfApm.Cols[colApmDate].Width = 100; grfApm.Cols[colApmTime].Width = 80; grfApm.Cols[colApmSex].Width = 80; grfApm.Cols[colApmAge].Width = 80; grfApm.Cols[colApmDsc].Width = 300; grfApm.Cols[colApmRemark].Width = 300; grfApm.Cols[colApmDept].Width = 110; ContextMenu menuGw = new ContextMenu(); grfApm.ContextMenu = menuGw; String date = ""; //if (lDgss.Count <= 0) getlBsp(); date = txtDate.Text; DataTable dt = new DataTable(); dt = bc.bcDB.vsDB.selectAppointmentByDtr(bc.user.staff_id, bc.datetoDB(date)); int i = 1; grfApm.Rows.Count = dt.Rows.Count + 1; foreach (DataRow row in dt.Rows) { try { Patient ptt = new Patient(); ptt.patient_birthday = bc.datetoDB(row["mnc_bday"].ToString()); grfApm[i, 0] = (i); grfApm[i, colApmHn] = row["MNC_HN_NO"].ToString(); grfApm[i, colApmHn] = row["MNC_HN_NO"].ToString(); grfApm[i, colApmPttName] = row["prefix"].ToString() + "" + row["MNC_FNAME_T"].ToString() + "" + row["MNC_LNAME_T"].ToString(); grfApm[i, colApmDate] = bc.datetoShow(row["mnc_app_dat"].ToString()); grfApm[i, colApmTime] = bc.FormatTime(row["mnc_app_tim"].ToString()); grfApm[i, colApmSex] = row["mnc_sex"].ToString(); grfApm[i, colApmAge] = ptt.AgeStringShort(); grfApm[i, colApmDsc] = row["mnc_app_dsc"].ToString(); grfApm[i, colApmRemark] = row["MNC_REM_MEMO"].ToString(); grfApm[i, colApmDept] = row["mnc_name"].ToString(); //if ((i % 2) == 0) // grfApm.Rows[i].StyleNew.BackColor = ColorTranslator.FromHtml(bc.iniC.grfRowColor); i++; } catch (Exception ex) { new LogWriter("e", "FrmDoctorView setGrfApm ex " + ex.Message); } } grfApm.Cols[colApmId].Visible = false; grfApm.Cols[colApmHn].AllowEditing = false; grfApm.Cols[colApmPttName].AllowEditing = false; grfApm.Cols[colApmDate].AllowEditing = false; grfApm.Cols[colApmTime].AllowEditing = false; grfApm.Cols[colApmSex].AllowEditing = false; grfApm.Cols[colApmAge].AllowEditing = false; grfApm.Cols[colApmDsc].AllowEditing = false; grfApm.Cols[colApmRemark].AllowEditing = false; grfApm.Cols[colApmDept].AllowEditing = false; }
private void setGrf() { String datestart = "", dateend = "", hn = "", txt = ""; DataTable dt = new DataTable(); //MessageBox.Show("txtDateStart " + txtDateStart.Text, ""); //MessageBox.Show("txtDateEnd " + txtDateEnd.Text, ""); datestart = bc.datetoDB(txtDateStart.Text); dateend = bc.datetoDB(txtDateEnd.Text); //MessageBox.Show("datestart "+ datestart, ""); //MessageBox.Show("dateend "+ dateend, ""); grfHn.Clear(); grfHn.Rows.Count = 1; //grfQue.Rows.Count = 1; grfHn.Cols.Count = 8; grfHn.Cols[colDateReq].Caption = "Date Req"; grfHn.Cols[colHN].Caption = "HN"; grfHn.Cols[colFullName].Caption = "Name"; grfHn.Cols[colDateReceive].Caption = "Date Rec"; grfHn.Cols[colReqNo].Caption = "Req No"; grfHn.Cols[colVN].Caption = "VN"; grfHn.Cols[colId].Caption = "id"; grfHn.Cols[colDateReq].Width = 100; grfHn.Cols[colHN].Width = 80; grfHn.Cols[colFullName].Width = 300; grfHn.Cols[colDateReceive].Width = 100; grfHn.Cols[colReqNo].Width = 80; grfHn.Cols[colVN].Width = 80; //MessageBox.Show("1111", ""); if (datestart.Length <= 0 && dateend.Length <= 0 && txtHn.Text.Length <= 0) { return; } if (chkDateReq.Checked) { dt = bc.bcDB.dscDB.selectLabOutByDateReq(datestart, dateend, txtHn.Text.Trim(), "daterequest"); } else if (chkDateLabOut.Checked) { dt = bc.bcDB.dscDB.selectLabOutByDateReq(datestart, dateend, txtHn.Text.Trim(), "datecreate"); } else if (chkDateReqHIS.Checked) { dt = bc.bcDB.dscDB.selectLabOutByDateReq(datestart, dateend, txtHn.Text.Trim(), "datecreate"); } //grfHn.Cols[colHnPrnStaffNote].Width = 60; //if (datestart.Length <= 0 && dateend.Length <= 0) //{ // MessageBox.Show("วันทีเริ่มต้น ไม่มีค่า", ""); // return; //} grfHn.ShowCursor = true; ContextMenu menuGw = new ContextMenu(); grfHn.ContextMenu = menuGw; int i = 1; grfHn.Rows.Count = dt.Rows.Count + 1; foreach (DataRow row in dt.Rows) { try { grfHn[i, 0] = (i); grfHn[i, colHN] = row["hn"].ToString(); grfHn[i, colFullName] = row["patient_fullname"].ToString();//row["prefix"].ToString() + " " + row["MNC_FNAME_T"].ToString() + " " + row["MNC_LNAME_T"].ToString(); grfHn[i, colDateReceive] = bc.datetoShow(row["date_create"].ToString()); grfHn[i, colDateReq] = bc.datetoShow(row["date_req"].ToString()); grfHn[i, colReqNo] = row["req_id"].ToString(); grfHn[i, colVN] = row["vn"].ToString(); grfHn[i, colId] = row["doc_scan_id"].ToString(); } catch (Exception ex) { new LogWriter("e", "FrmLabOutReceiveView setGrf ex " + ex.Message); } i++; } grfHn.Cols[colId].Visible = false; grfHn.Cols[colHN].AllowEditing = false; grfHn.Cols[colFullName].AllowEditing = false; grfHn.Cols[colDateReceive].AllowEditing = false; grfHn.Cols[colDateReq].AllowEditing = false; grfHn.Cols[colReqNo].AllowEditing = false; grfHn.Cols[colVN].AllowEditing = false; }
private void setGrfVn(String hn) { //grfDept.Rows.Count = 7; grfVn.Clear(); DataTable dt = new DataTable(); grfVn.DataSource = null; //ConnectDB con = new ConnectDB(bc.iniC); //con.OpenConnectionEx(); dt = bc.bcDB.vsDB.selectVisitByHn3(hn); //con.CloseConnectionEx(); //grfExpn.Rows.Count = dt.Rows.Count + 1; grfVn.Rows.Count = 1; grfVn.Cols.Count = 12; C1TextBox txt = new C1TextBox(); C1ComboBox cboproce = new C1ComboBox(); //ic.ivfDB.itmDB.setCboItem(cboproce); grfVn.Cols[colVsName].Editor = txt; grfVn.Cols[colVsDate].Editor = txt; grfVn.Cols[colVsName].Width = 140; grfVn.Cols[colVsDate].Width = 120; grfVn.Cols[colVsVn].Width = 80; grfVn.Cols[colVsmeno].Width = 140; grfVn.Cols[colVsDsc].Width = 80; grfVn.Cols[coLVsAn].Width = 80; grfVn.Cols[colVsStatus].Width = 40; grfVn.Cols[colVsAnDate].Width = 120; grfVn.ShowCursor = true; //grdFlex.Cols[colID].Caption = "no"; //grfDept.Cols[colCode].Caption = "รหัส"; grfVn.Cols[colVsName].Caption = "HN"; grfVn.Cols[colVsDate].Caption = "Visit Date"; grfVn.Cols[colVsVn].Caption = "VN"; grfVn.Cols[colVsmeno].Caption = "อาการ"; grfVn.Cols[colVsDsc].Caption = "desc"; grfVn.Cols[coLVsAn].Caption = "AN"; grfVn.Cols[colVsStatus].Caption = " "; grfVn.Cols[colVsAnDate].Caption = "AN Date"; Color color = ColorTranslator.FromHtml(bc.iniC.grfRowColor); //CellRange rg1 = grfBank.GetCellRange(1, colE, grfBank.Rows.Count, colE); //rg1.Style = grfBank.Styles["date"]; //grfCu.Cols[colID].Visible = false; for (int i = 0; i <= dt.Rows.Count - 1; i++) { Row row = grfVn.Rows.Add(); row[0] = i; row[colVsVn] = dt.Rows[i]["MNC_VN_NO"].ToString() + "/" + dt.Rows[i]["MNC_VN_SEQ"].ToString() + "(" + dt.Rows[i]["MNC_VN_SUM"].ToString() + ")"; row[colVsName] = dt.Rows[i]["prefix"].ToString() + " " + dt.Rows[i]["MNC_FNAME_T"].ToString() + " " + dt.Rows[i]["MNC_LNAME_T"].ToString(); row[colVsDate] = bc.datetoShow(dt.Rows[i]["mnc_date"].ToString()); row[colVsPreNo] = dt.Rows[i]["mnc_pre_no"].ToString(); row[colVsmeno] = dt.Rows[i]["mnc_shif_memo"].ToString(); row[colVsDsc] = dt.Rows[i]["mnc_ref_dsc"].ToString(); row[coLVsAn] = dt.Rows[i]["mnc_an_no"].ToString() + "/" + dt.Rows[i]["mnc_an_yr"].ToString(); row[colVsStatus] = dt.Rows[i]["MNC_PAT_FLAG"].ToString(); row[colVsAnDate] = bc.datetoShow(dt.Rows[i]["mnc_ad_date"].ToString()); row[colVsHn] = dt.Rows[i]["mnc_hn_no"].ToString(); row[colDOB] = dt.Rows[i]["MNC_bday"].ToString(); } grfVn.Cols[colVsVn].AllowEditing = false; grfVn.Cols[colCuName].AllowEditing = false; grfVn.Cols[colVsPreNo].Visible = false; grfVn.Cols[colVsName].Visible = false; grfVn.Cols[colVsHn].Visible = false; grfVn.Cols[colDOB].Visible = false; }
private void BtnImportDfSelect_Click(object sender, EventArgs e) { //throw new NotImplementedException(); pageLoad = true; showLbLoading(); DataTable dt = new DataTable(); DateTime startdate1 = new DateTime(); DateTime enddate1 = new DateTime(); DateTime.TryParse(txtDateStart.Text, out startdate1); DateTime.TryParse(txtDateEnd.Text, out enddate1); String paidtype = "", startdate = "", enddate = ""; if (startdate1.Year > 2500) { startdate1 = startdate1.AddYears(-543); } else if (startdate1.Year < 2000) { startdate1 = startdate1.AddYears(543); } startdate = startdate1.ToString("yyyy-MM-dd", new CultureInfo("en-US")); if (enddate1.Year > 2500) { enddate1 = enddate1.AddYears(-543); } else if (enddate1.Year < 2000) { enddate1 = enddate1.AddYears(543); } enddate = enddate1.ToString("yyyy-MM-dd", new CultureInfo("en-US")); String[] paid = txtPaidType.Text.Trim().Split(','); if (paid.Length > 0) { foreach (String txt in paid) { paidtype += "'" + txt + "',"; } if (paidtype.Length > 1) { paidtype = paidtype.Substring(0, paidtype.Length - 1); } } else { paidtype = txtPaidType.Text.Trim(); } dt = bc.bcDB.vsDB.selectFinancePatient(startdate, enddate, paidtype); Column colChk = grfSelect.Cols[colchk]; colChk.DataType = typeof(Boolean); grfSelect.Cols.Count = 21; //grfSelect.Cols.Count = 12; grfSelect.Rows.Count = 1; grfSelect.Cols[colvsdate].Caption = "Date"; grfSelect.Cols[colhnno].Caption = "HN"; grfSelect.Cols[colpttname].Caption = "Patient Name"; grfSelect.Cols[colpreno].Caption = "preno"; grfSelect.Cols[colpaidtype].Caption = "สิทธิ"; grfSelect.Cols[coldtrcode].Caption = "แพทย์"; grfSelect.Cols[colanno].Caption = "AN NO"; grfSelect.Cols[colanyr].Caption = "AN YR"; //grfSelect.Cols[coldtrname].Caption = "HN"; grfSelect.Cols[colchk].Width = 50; grfSelect.Cols[colvsdate].Width = 100; grfSelect.Cols[colhnno].Width = 80; grfSelect.Cols[colpttname].Width = 250; grfSelect.Cols[colpreno].Width = 60; grfSelect.Cols[colpaidtype].Width = 60; grfSelect.Cols[coldtrname].Width = 250; //grfSelect.Cols[colfndesc].Width = 250; //grfSelect.Cols[colfncd].Width = 50; //grfSelect.Cols[colno].Width = 50; //grfSelect.Cols[colfnamt].Width = 50; //grfSelect.Cols[coldtrname].Width = 60; grfSelect.Rows.Count = dt.Rows.Count + 1; int i = 1; foreach (DataRow drow in dt.Rows) { grfSelect[i, colvsdate] = bc.datetoShow(drow["MNC_DATE"].ToString()); grfSelect[i, colhnno] = drow["MNC_HN_NO"].ToString(); grfSelect[i, colpttname] = drow["MNC_PFIX_DSC"].ToString() + " " + drow["MNC_FNAME_T"].ToString() + " " + drow["MNC_LNAME_T"].ToString(); grfSelect[i, colpreno] = drow["MNC_PRE_NO"].ToString(); grfSelect[i, colpaidtype] = drow["MNC_FN_TYP_CD"].ToString(); grfSelect[i, coldtrcode] = drow["MNC_DOT_CD"].ToString(); grfSelect[i, coldtrname] = drow["MNC_PFIX_DSCdtr"].ToString() + " " + drow["MNC_DOT_FNAME"].ToString() + " " + drow["MNC_DOT_LNAME"].ToString(); grfSelect[i, coldoccd] = drow["MNC_DOC_CD"].ToString(); grfSelect[i, coldoc_yr] = drow["MNC_DOC_yr"].ToString(); grfSelect[i, coldocno] = drow["MNC_DOC_no"].ToString(); grfSelect[i, coldocdat] = drow["MNC_doc_dat"].ToString(); grfSelect[i, colvstime] = drow["MNC_time"].ToString(); grfSelect[i, colanno] = drow["MNC_AN_NO"].ToString(); grfSelect[i, colanyr] = drow["MNC_AN_YR"].ToString(); grfSelect[i, colhnyr] = drow["MNC_hn_YR"].ToString(); grfSelect[i, colchk] = true; grfSelect[i, 0] = i; i++; } grfSelect.Cols[coldoccd].Visible = false; grfSelect.Cols[coldoc_yr].Visible = false; grfSelect.Cols[coldocno].Visible = false; grfSelect.Cols[coldocdat].Visible = false; grfSelect.Cols[colvstime].Visible = false; grfSelect.Cols[colvsdate].AllowEditing = false; grfSelect.Cols[colhnno].AllowEditing = false; grfSelect.Cols[colpttname].AllowEditing = false; grfSelect.Cols[colpreno].AllowEditing = false; grfSelect.Cols[colpaidtype].AllowEditing = false; grfSelect.Cols[coldtrname].AllowEditing = false; //grfSelect.Cols[colGrfUcepSelectHn].AllowEditing = false; //grfSelect.Cols[colGrfUcepSelectHn].AllowEditing = false; hideLbLoading(); pageLoad = false; }
private void setGrf() { String datestart = "", dateend = "", hn = "", txt = ""; DataTable dt = new DataTable(); datestart = bc.datetoDB(txtDateStart.Text); dateend = bc.datetoDB(txtDateEnd.Text); dt = bc.bcDB.dscDB.selectDistByDateCrate(datestart, dateend); grfHn.Clear(); grfHn.Rows.Count = 1; //grfQue.Rows.Count = 1; grfHn.Cols.Count = 10; grfHn.Cols[colHN].Caption = "HN"; grfHn.Cols[colFullName].Caption = "Patient FullName"; grfHn.Cols[colVN].Caption = "VN"; grfHn.Cols[colAN].Caption = "AN"; grfHn.Cols[colVsDate].Caption = "vs Date"; grfHn.Cols[colCrDate].Caption = "scan Date"; grfHn.Cols[colRowCnt].Caption = "row cnt"; grfHn.Cols[colPicBfS].Caption = "pic BfS"; grfHn.Cols[colCnt].Caption = "CNT"; grfHn.Cols[colHN].Width = 100; grfHn.Cols[colFullName].Width = 300; grfHn.Cols[colVN].Width = 80; grfHn.Cols[colAN].Width = 80; grfHn.Cols[colVsDate].Width = 100; grfHn.Cols[colCrDate].Width = 100; grfHn.Cols[colRowCnt].Width = 80; grfHn.Cols[colPicBfS].Width = 80; grfHn.ShowCursor = true; ContextMenu menuGw = new ContextMenu(); grfHn.ContextMenu = menuGw; int i = 1; grfHn.Rows.Count = dt.Rows.Count + 1; foreach (DataRow row in dt.Rows) { try { grfHn[i, 0] = (i); grfHn[i, colHN] = row["hn"].ToString(); grfHn[i, colFullName] = row["prefix"].ToString() + " " + row["MNC_FNAME_T"].ToString() + " " + row["MNC_LNAME_T"].ToString(); grfHn[i, colVN] = row["vn"].ToString(); grfHn[i, colAN] = row["an"].ToString(); grfHn[i, colVsDate] = bc.datetoShow(row["visit_date"].ToString()); grfHn[i, colCrDate] = bc.datetoShow(row["date_create"].ToString()); grfHn[i, colRowCnt] = row["row_cnt"].ToString(); grfHn[i, colPicBfS] = row["pic_before_scan_cnt"].ToString(); grfHn[i, colCnt] = row["cnt"].ToString(); } catch (Exception ex) { new LogWriter("e", "FrmLabOutReceiveView setGrf ex " + ex.Message); } i++; } grfHn.Cols[colHN].AllowEditing = false; grfHn.Cols[colFullName].AllowEditing = false; grfHn.Cols[colVN].AllowEditing = false; grfHn.Cols[colAN].AllowEditing = false; grfHn.Cols[colVsDate].AllowEditing = false; grfHn.Cols[colCrDate].AllowEditing = false; grfHn.Cols[colRowCnt].AllowEditing = false; grfHn.Cols[colPicBfS].AllowEditing = false; }
private void printReserveVaccinePDF() { String pathFolder = "", filename = "", datetick = ""; int gapLine = 20, gapLine1 = 15, gapX = 40, gapY = 20, xCol2 = 200, xCol1 = 160, xCol3 = 300, xCol4 = 390, xCol5 = 500; Size size = new Size(); C1PdfDocument pdf = new C1PdfDocument(); C1PdfDocumentSource pds = new C1PdfDocumentSource(); StringFormat _sfRight, _sfRightCenter; //Font _fontTitle = new Font("Tahoma", 15, FontStyle.Bold); _sfRight = new StringFormat(); _sfRight.Alignment = StringAlignment.Far; _sfRightCenter = new StringFormat(); _sfRightCenter.Alignment = StringAlignment.Far; _sfRightCenter.LineAlignment = StringAlignment.Center; Font titleFont = new Font(bc.iniC.pdfFontName, bc.pdfFontSizetitleFont, FontStyle.Bold); Font hdrFont = new Font(bc.iniC.pdfFontName, bc.pdfFontSizehdrFont, FontStyle.Regular); Font hdrFontB = new Font(bc.iniC.pdfFontName, 16, FontStyle.Bold); Font ftrFont = new Font(bc.iniC.pdfFontName, 8); Font txtFont = new Font(bc.iniC.pdfFontName, bc.pdfFontSizetxtFont, FontStyle.Regular); pdf.FontType = FontTypeEnum.Embedded; RectangleF rcPage = pdf.PageRectangle; rcPage = RectangleF.Empty; rcPage.Inflate(-72, -92); rcPage.Location = new PointF(rcPage.X, rcPage.Y + titleFont.SizeInPoints + 10); rcPage.Size = new SizeF(0, titleFont.SizeInPoints + 3); rcPage.Width = 110; Image loadedImage; loadedImage = Resources.LOGO_BW_tran; float newWidth = loadedImage.Width * 100 / loadedImage.HorizontalResolution; float newHeight = loadedImage.Height * 100 / loadedImage.VerticalResolution; float widthFactor = 4.8F; float heightFactor = 4.8F; if (widthFactor > 1 | heightFactor > 1) { if (widthFactor > heightFactor) { widthFactor = 1; newWidth = newWidth / widthFactor; newHeight = newHeight / widthFactor; //newWidth = newWidth / 1.2; //newHeight = newHeight / 1.2; } else { newWidth = newWidth / heightFactor; newHeight = newHeight / heightFactor; } } RectangleF recf = new RectangleF(15, 15, (int)newWidth, (int)newHeight); pdf.DrawImage(loadedImage, recf); rcPage.X = gapX + recf.Width - 10; rcPage.Y = gapY; RectangleF rc = rcPage; string[] filePaths = Directory.GetFiles(System.IO.Path.GetDirectoryName(Application.ExecutablePath) + "\\slip\\", txtID.Text.Trim() + "*.jpg"); if (filePaths.Length > 0) { int i = 1, xx = 40; foreach (String filename1 in filePaths) { Image loadedImage1, resizedImage1 = null; loadedImage1 = Image.FromFile(filename1); int originalWidth = 0; originalWidth = loadedImage1.Width; int newWidth1 = 200; resizedImage1 = loadedImage1.GetThumbnailImage(newWidth1, (newWidth1 * loadedImage1.Height) / originalWidth, null, IntPtr.Zero); RectangleF recf1 = new RectangleF(i == 1?xx: newWidth1 + 10, 380, (int)newWidth1, (int)resizedImage1.Height); pdf.DrawImage(loadedImage1, recf1); i++; } } Image qrcode = c1BarCode1.Image; RectangleF recf2 = new RectangleF(350, 500, qrcode.Width, qrcode.Height); pdf.DrawImage(qrcode, recf2); size = bc.MeasureString(bc.iniC.hostname, titleFont); rcPage.Width = size.Width; pdf.DrawString(bc.iniC.hostname, titleFont, Brushes.Black, rcPage); gapY += gapLine; rcPage.Y = gapY; size = bc.MeasureString(bc.iniC.hostaddresst, hdrFont); rcPage.Width = size.Width; pdf.DrawString(bc.iniC.hostaddresst, hdrFont, Brushes.Black, rcPage); String dose = "", amt11 = ""; int amt111 = 0; dose = txtDose.Text.Replace("จอง", "").Replace("เข็ม", "").Replace("3,300", "").Replace("1,650", "").Replace("4,950", "").Trim().Replace("6,600", "").Trim().Replace("8,250", "") .Replace("8,250", "").Replace("9,900", "").Replace("11,500", "").Replace("13,200", "").Replace("14,850", "").Replace("16,500", "").Replace("18,150", "").Replace("19,800", "").Trim(); int.TryParse(dose, out amt111); amt111 *= 1650; gapY += gapLine; gapY += gapLine; gapY += gapLine; gapX = xCol1; rc.X = (pdf.PageSize.Width / 2) - 15; rc.Y = gapY; pdf.DrawString("ใบจองวัคซีน", titleFont, Brushes.Black, rc); gapY += gapLine; gapY += gapLine; gapX = 30; rc.X = gapX; rc.Y = gapY; pdf.DrawString("ข้าพเจ้า ชื่อ-นามสกุล", txtFont, Brushes.Black, rc); rc.X = 110; rc.Y = rc.Y - 4; pdf.DrawString(txtName.Text, hdrFont, Brushes.Black, rc); pdf.DrawLine(Pens.Gray, 100, gapY + 15, 380, gapY + 15); rc.X = 400; rc.Y = gapY; pdf.DrawString("เลขที่ประชาชน", txtFont, Brushes.Black, rc); rc.X = 470; rc.Y = rc.Y - 4; pdf.DrawString(txtPID.Text, hdrFont, Brushes.Black, rc); pdf.DrawLine(Pens.Gray, 455, gapY + 15, 590, gapY + 15); gapY += gapLine; gapX = 30; rc.X = gapX; rc.Y = gapY; pdf.DrawString("ที่อยู่ปัจจุบัน", txtFont, Brushes.Black, rc); rc.X = 75; rc.Y = rc.Y - 4; pdf.DrawString(txtAddress.Text, hdrFont, Brushes.Black, rc); pdf.DrawLine(Pens.Gray, 70, gapY + 15, 400, gapY + 15); rc.X = 420; rc.Y = gapY; pdf.DrawString("เบอร์ที่ติดต่อได้", txtFont, Brushes.Black, rc); rc.X = 480; rc.Y = rc.Y - 4; pdf.DrawString(txtMobile.Text, hdrFont, Brushes.Black, rc); pdf.DrawLine(Pens.Gray, 470, gapY + 15, 590, gapY + 15); gapY += gapLine; gapX = 30; rc.X = gapX; rc.Y = gapY; rc.Width = 610; pdf.DrawString("ขอจองวัคซีนทางเลือก MODERNA และชำระเงิน จำนวน โดส ราคา 1,650 บาทต่อโดส", txtFont, Brushes.Black, rc); rc.X = 19; rc.Y = rc.Y - 4; pdf.DrawString(dose, hdrFont, Brushes.Black, rc); pdf.DrawLine(Pens.Gray, 215, gapY + 15, 220, gapY + 15); gapY += gapLine; gapX = 30; rc.X = gapX; rc.Y = gapY; pdf.DrawString("ราคาดังกล่าวเป็นราคาที่ รวมค่าวัคซีน ค่าประกัน ค่าบริการสำหรับการฉีด ไม่รวมค่าแพทย์ ถ้าต้องการพบแพทย์ โดยชำระเงินเต็มจำนวน", txtFont, Brushes.Black, rc); gapY += gapLine; gapX = 30; rc.X = gapX; rc.Y = gapY; pdf.DrawString("โดสละ 1,650 รวม โดส เป็นเงิน บาท ตามใบเจองเลขที่ ", txtFont, Brushes.Black, rc); rc.X = 100; rc.Y = rc.Y - 4; pdf.DrawString(dose, hdrFont, Brushes.Black, rc); rc.X = 175; rc.Y = rc.Y; pdf.DrawString(amt111.ToString("#,###.00"), hdrFont, Brushes.Black, rc); rc.X = 310; rc.Y = rc.Y; pdf.DrawString(txtID.Text.Trim(), hdrFont, Brushes.Black, rc); pdf.DrawLine(Pens.Gray, 95, gapY + 15, 100, gapY + 15); pdf.DrawLine(Pens.Gray, 165, gapY + 15, 220, gapY + 15); pdf.DrawLine(Pens.Gray, 340, gapY + 15, 470, gapY + 15); gapY += gapLine; gapX = 30; rc.X = gapX; rc.Y = gapY; pdf.DrawString("หมายเหตุ 1.ทางโรงพยาบาลจะนัดรับวัคซีนหลังจาก โรงพยาบาลได้รับการจัดสรรจากหน่วยงานภาครัฐ ตามที่อยู่และเบอร์โทรที่ได้ให้ไว้", txtFont, Brushes.Black, rc); gapY += gapLine; gapX = 30; rc.X = 67; rc.Y = gapY; pdf.DrawString("2.กรณีได้รับจัดสรรวัคซีนมาไม่เพียงพอต่อการจองที่โรงพยาบาลได้รับจองตามที่ได้รับจัดสรร ทางโรงพยาบาลจะเรียงลำดับการเข้ารับวัคซีนตามลำดดับการจองก่อน-หลัง", txtFont, Brushes.Black, rc); gapY += gapLine; gapX = 30; rc.X = 67; rc.Y = gapY; pdf.DrawString("และจะคืนเงินมัดจำให้เต็มจำนวน กรณีจองแล้วไม่ได้", txtFont, Brushes.Black, rc); gapY += gapLine; gapX = 30; rc.X = 67; rc.Y = gapY; pdf.DrawString("3.ทางโรงพยาบาลสงวนสิทธิ์ยกเลิกการของโดยไม่คืนเงินกรณีผู้จองไม่มารับวัคซีนตามช่วงเวลาที่กำหนด", txtFont, Brushes.Black, rc); gapY += gapLine; gapX = 30; rc.X = 67; rc.Y = gapY; pdf.DrawString("4.ห้ามนำวัคซีนไปขายต่อเพราะเป็นสินค้าควบคุมราคา", txtFont, Brushes.Black, rc); gapY += gapLine; gapX = 30; rc.X = 67; rc.Y = gapY; pdf.DrawString("5.ต้องมารับบริการฉีดวัคซีน ที่โรงพยาบาล บางนา5 เท่านั้น", txtFont, Brushes.Black, rc); gapY += gapLine; gapY += gapLine; gapY += gapLine; gapY += gapLine; gapX = 30; rc.X = 370; rc.Y = gapY; pdf.DrawString("ผู้จอง", txtFont, Brushes.Black, rc); pdf.DrawLine(Pens.Gray, 400, gapY + 15, 500, gapY + 15); gapY += gapLine; gapX = 30; rc.X = 370; rc.Y = gapY; pdf.DrawString("ผู้รับจอง on line", txtFont, Brushes.Black, rc); pdf.DrawLine(Pens.Gray, 400, gapY + 15, 500, gapY + 15); String txt = ""; if (txtDate.Text.Trim().Length > 9) { txt = bc.datetoShow(txtDate.Text.Trim()) + " " + txtDate.Text.Substring(10).Trim(); } else { txt = txtDate.Text.Trim(); } gapY += gapLine; gapX = 30; rc.X = 370; rc.Y = gapY; pdf.DrawString("วันที่จอง " + txt, txtFont, Brushes.Black, rc); pdf.DrawLine(Pens.Gray, 400, gapY + 15, 500, gapY + 15); gapY += gapLine; gapY += gapLine; gapY += gapLine; gapY += gapLine; gapY += gapLine; gapY += gapLine; gapY += gapLine; gapY += gapLine; gapY += gapLine; gapY += gapLine; gapY += gapLine; gapY += gapLine; gapY += gapLine; gapX = 30; rc.X = gapX; rc.Y = gapY; pdf.DrawString("สอบถามเพิ่มเติมโทร 02 138 1155-60 ต่อ 143 ", txtFont, Brushes.Black, rc); gapY += gapLine; gapX = 30; rc.X = gapX; rc.Y = gapY; pdf.DrawString("วันจันทร์ ถึง วันศุกร์ เวลา 8.00 - 16.00 น. (ปิดพักเที่ยง) ", txtFont, Brushes.Black, rc); gapY += gapLine; gapX = 30; rc.X = gapX; rc.Y = gapY; pdf.DrawString("line @657bkkyq", txtFont, Brushes.Black, rc); RectangleF rcHdr = new RectangleF(); rcHdr.Width = pdf.PageSize.Width - 20; rcHdr.Height = pdf.PageSize.Height - 20; rcHdr.X = 10; rcHdr.Y = 10; String PathName = "medical", fileName = ""; datetick = DateTime.Now.Ticks.ToString(); if (!Directory.Exists("report")) { Directory.CreateDirectory("report"); } fileName = "report\\" + txtID.Text.Trim() + "_" + datetick + ".pdf"; if (File.Exists(fileName)) { File.Delete(fileName); System.Threading.Thread.Sleep(100); } pdf.DrawRectangle(Pens.Black, rcHdr); // ตาราง String path = Path.GetDirectoryName(Application.ExecutablePath); pdf.Save(path + "\\" + fileName); Process.Start(fileName); }