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