private void setControl(String id)
{
orreq = ic.ivfDB.orreqDB.selectByPk1(id);
ptt = ic.ivfDB.pttDB.selectByPk1(orreq.t_patient_id);
txtID.Value = orreq.or_req_id;
txtHn.Value = orreq.patient_hn;
txtPttNameE.Value = orreq.patient_name;
txtDob.Value = ic.sVsOld.dob + "[" + ptt.AgeStringShort() + "]";
txtPttId.Value = ptt.t_patient_id;
txtSex.Value = ptt.f_sex_id.Equals("1") ? "ชาย" : "หญิง";
txtBg.Value = ptt.f_patient_blood_group_id.Equals("2140000005") ? "O"
: ptt.f_patient_blood_group_id.Equals("2140000002") ? "A" : ptt.f_patient_blood_group_id.Equals("2140000003") ? "B"
: ptt.f_patient_blood_group_id.Equals("2140000004") ? "AB" : "ไม่ระบุ";
txtID.Value = orreq.or_req_id;
txtReqCode.Value = orreq.or_req_code;
//txtDiagGrpId.Value = orreq.id
txtDiagId.Value = orreq.opera_id;
txtAnesId.Value = orreq.anesthesia_id;
txtDtrId.Value = orreq.doctor_surgical_id;
txtReqDate.Value = orreq.or_req_date;
txtDiagGrp.Value = orreq.operation_group_name;
txtOpera.Value = orreq.operation_name;
txtAnes.Value = orreq.anesthesia_name;
cboDiag.Value = orreq.remark;
txtOrDate.Value = orreq.or_date;
txtOrTime.Value = orreq.or_time;
txtDtrName.Value = orreq.surgeon;
}
private void setControl(String vsid)
{
//vsOld = ic.ivfDB.ovsDB.selectByPk1(vsid); // -0020
//pttOld = ic.ivfDB.pttOldDB.selectByPk1(vsOld.PID); // -0020
//vs = ic.ivfDB.vsDB.selectByVn(vsid); // -0020
vs = ic.ivfDB.vsDB.selectByPk1(vsid); // +0020
ptt = ic.ivfDB.pttDB.selectByPk1(vs.t_patient_id);
//txtHn.Value = ptt.patient_hn;// -0020
txtHn.Value = ic.showHN(ptt.patient_hn, ptt.patient_year);// +0020
txtVn.Value = vs.visit_vn;
txtPttNameE.Value = ptt.Name;
txtPttName.Value = ic.ivfDB.fpfDB.getList1(ptt.f_patient_prefix_id) + " " + ptt.patient_firstname + " " + ptt.patient_lastname;
txtVnShow.Value = ic.showVN(vs.visit_vn);
txtDob.Value = ic.datetoShow(ptt.patient_birthday) + " [" + ptt.AgeStringShort() + "]";
txtAllergy.Value = ptt.allergy_description;
txtIdOld.Value = ptt.t_patient_id_old;
txtVnOld.Value = vs.visit_vn;
txtVsId.Value = vs.t_visit_id;
txtPttId.Value = ptt.t_patient_id;
txtSex.Value = ptt.f_sex_id.Equals("1") ? "ชาย" : "หญิง";
txtBg.Value = ptt.f_patient_blood_group_id.Equals("2140000005") ? "O"
: ptt.f_patient_blood_group_id.Equals("2140000002") ? "A" : ptt.f_patient_blood_group_id.Equals("2140000003") ? "B"
: ptt.f_patient_blood_group_id.Equals("2140000004") ? "AB" : "ไม่ระบุ";
txtVisitHeight.Value = vs.height;
txtVisitBW.Value = vs.bw;
txtVisitBP.Value = vs.bp;
txtVisitPulse.Value = vs.pulse;
chkChronic.Checked = ptt.status_congenial.Equals("1") ? true : false;
ic.setC1Combo(cboDoctor, vs.doctor_id);
Patient ptt1 = new Patient();
ptt1 = ic.ivfDB.pttDB.selectByHn(vs.patient_hn_male);
txtNameMale.Value = ptt1.Name;
stt.Show("<p><b>สวัสดี</b></p>คุณ " + ptt.congenital_diseases_description + "<br> กรุณา ป้อนรหัสผ่าน", chkChronic);
txtCongenital.Value = ptt.congenital_diseases_description;
if (!ptt.t_patient_id.Equals(""))
{
PatientImage pttI = new PatientImage();
pttI = ic.ivfDB.pttImgDB.selectByPttIDStatus4(ptt.t_patient_id);
filenamepic = pttI.image_path;
Thread threadA = new Thread(new ParameterizedThreadStart(ExecuteA));
threadA.Start();
}
//if (!vsOld.VSID.Equals("166")) // -0020
// ต้องการ พิมพ์ sticker ย้อยหลัง
//if (!vs.vsid.Equals("166")) // ต้องการ พิมพ์ sticker ย้อยหลัง
//{ // ต้องการ พิมพ์ sticker ย้อยหลัง
// btnPrnSticker.Enabled = false; // ต้องการ พิมพ์ sticker ย้อยหลัง
//} // ต้องการ พิมพ์ sticker ย้อยหลัง
//txtBg.Value = pttOld.b
//txtAllergy.Value =
}
private void initConifg()
{
ptt = new Patient();
vs = new Visit();
ptt = ic.ivfDB.pttDB.selectByHn(hn);
vs = ic.ivfDB.vsDB.selectByPk1(vsid);
txtPttNameE.Value = name;
txtHn.Value = hn;
txtDob.Value = ptt.AgeStringShort() + " [" + ic.datetoShow(ptt.patient_birthday) + "]";
ic.ivfDB.stfDB.setCboDoctor(cboDoctor, vs.doctor_id);
ic.ivfDB.stfDB.setCboDoctor(cboAnes, "");
btnFinish.Click += BtnFinish_Click;
}
private void setControl1()
{
LabFormA lFormA = new LabFormA();
Patient pttmale = new Patient();
lFormA = ic.ivfDB.lFormaDB.selectByVnOld(vs.visit_vn);
pttmale = ic.ivfDB.pttDB.selectByHn(vs.patient_hn_male);
ptt.patient_birthday = pttOld.DateOfBirth;
txtHn.Value = vsOld.PIDS;
txtVn.Value = vsOld.VN;
txtPttNameE.Value = vsOld.PName;
txtDob.Value = ic.datetoShow(pttOld.DateOfBirth) + " [" + ptt.AgeStringShort() + "]";
txtAllergy.Value = ptt.allergy_description;
txtPttPID.Value = pttOld.PID;
txtVnOld.Value = vsOld.VN;
txtSex.Value = ptt.f_sex_id.Equals("1") ? "ชาย" : "หญิง";
txtBg.Value = ptt.f_patient_blood_group_id.Equals("2140000005") ? "O"
: ptt.f_patient_blood_group_id.Equals("2140000002") ? "A" : ptt.f_patient_blood_group_id.Equals("2140000003") ? "B"
: ptt.f_patient_blood_group_id.Equals("2140000004") ? "AB" : "ไม่ระบุ";
txtVisitHeight.Value = ptt.patient_height;
txtVisitBW.Value = vs.bw;
txtVisitBP.Value = vs.bp;
txtVisitPulse.Value = vs.pulse;
txtPttId.Value = ptt.t_patient_id;
txtVsId.Value = vs.t_visit_id;
txtG.Value = ptt.g;
txtP.Value = ptt.p;
txtA.Value = ptt.a;
txtVisitLMP.Value = vs.lmp;
txtOPUDate.Value = lFormA.opu_date;
txtOPUTime.Value = lFormA.opu_time;
txtEmbryoTranferDate.Value = lFormA.embryo_tranfer_date;
ic.setC1Combo(cboDoctor, vs.doctor_id);
txtNameMale.Value = pttmale.Name;
chkChronic.Checked = ptt.status_congenial.Equals("1") ? true : false;
stt.Show("<p><b>สวัสดี</b></p>คุณ " + ptt.congenital_diseases_description + "<br> กรุณา ป้อนรหัสผ่าน", chkChronic);
if (!ptt.t_patient_id.Equals(""))
{
PatientImage pttI = new PatientImage();
pttI = ic.ivfDB.pttImgDB.selectByPttIDStatus4(ptt.t_patient_id);
filenamepic = pttI.image_path;
Thread threadA = new Thread(new ParameterizedThreadStart(ExecuteA));
threadA.Start();
}
}
private void BtnSearch_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
ic.sVsOld.PIDS = "";
ic.sVsOld.PName = "";
FrmSearchHn frm = new FrmSearchHn(ic, FrmSearchHn.StatusConnection.host, FrmSearchHn.StatusSearch.PttSearch, FrmSearchHn.StatusSearchTable.PttSearch);
frm.ShowDialog(this);
ptt = new Patient();
ptt = ic.ivfDB.pttDB.selectByHn(ic.sVsOld.PIDS);
txtHn.Value = ic.sVsOld.PIDS;
txtPttNameE.Value = ic.sVsOld.PName;
txtDob.Value = ic.sVsOld.dob + "[" + ptt.AgeStringShort() + "]";
txtPttId.Value = ptt.t_patient_id;
txtSex.Value = ptt.f_sex_id.Equals("1") ? "ชาย" : "หญิง";
txtBg.Value = ptt.f_patient_blood_group_id.Equals("2140000005") ? "O"
: ptt.f_patient_blood_group_id.Equals("2140000002") ? "A" : ptt.f_patient_blood_group_id.Equals("2140000003") ? "B"
: ptt.f_patient_blood_group_id.Equals("2140000004") ? "AB" : "ไม่ระบุ";
setGrfReqOr(txtPttId.Text);
}
private void setGrfApm()
{
//grfApm.Clear();
grfApm.Rows.Count = 1;
//grfQue.Rows.Count = 1;
grfApm.Cols.Count = 12;
grfApm.Cols[colApmHn].Caption = "HN";
grfApm.Cols[colApmVnShow].Caption = "VN";
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[colApmVnShow].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
{
String status = "", vn = "";
Patient ptt = new Patient();
ptt.patient_birthday = bc.datetoDB(row["mnc_bday"].ToString());
vn = row["MNC_VN_NO"].ToString() + "/" + row["MNC_VN_SEQ"].ToString() + "(" + row["MNC_VN_SUM"].ToString() + ")";
grfApm[i, 0] = (i);
grfApm[i, colApmHn] = row["MNC_HN_NO"].ToString();
grfApm[i, colApmVnShow] = vn;
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[0].Visible = true;
grfApm.Rows[0].Visible = true;
grfApm.Cols[colApmHn].AllowEditing = false;
grfApm.Cols[colApmVnShow].Visible = 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 setGrfIPD()
{
//grfIPD.Clear();
grfIPD.Rows.Count = 1;
//grfQue.Rows.Count = 1;
grfIPD.Cols.Count = 14;
grfIPD.Cols[colIPDHn].Caption = "HN";
grfIPD.Cols[colIPDVnShow].Caption = "VN";
grfIPD.Cols[colIPDPttName].Caption = "Patient Name";
grfIPD.Cols[colIPDDate].Caption = "Date";
grfIPD.Cols[colIPDTime].Caption = "Time";
grfIPD.Cols[colIPDSex].Caption = "Sex";
grfIPD.Cols[colIPDAge].Caption = "Age";
grfIPD.Cols[colIPDDsc].Caption = "Description";
grfIPD.Cols[colIPDRemark].Caption = "Symptom";
grfIPD.Cols[colIPDDept].Caption = "Dept";
grfIPD.Cols[colIPDWrd].Caption = "Ward";
grfIPD.Cols[colIPDAn].Caption = "AN";
grfIPD.Cols[colIPDHn].Width = 80;
grfIPD.Cols[colIPDVnShow].Width = 80;
grfIPD.Cols[colIPDPttName].Width = 300;
grfIPD.Cols[colIPDDate].Width = 100;
grfIPD.Cols[colIPDTime].Width = 80;
grfIPD.Cols[colIPDSex].Width = 80;
grfIPD.Cols[colIPDAge].Width = 80;
grfIPD.Cols[colIPDDsc].Width = 200;
grfIPD.Cols[colIPDRemark].Width = 300;
grfIPD.Cols[colIPDDept].Width = 170;
grfIPD.Cols[colIPDWrd].Width = 110;
grfIPD.Cols[colIPDAn].Width = 70;
ContextMenu menuGw = new ContextMenu();
grfIPD.ContextMenu = menuGw;
String date = "";
//if (lDgss.Count <= 0) getlBsp();
date = txtDate.Text;
DataTable dt = new DataTable();
dt = bc.bcDB.vsDB.selectPttinWardByDtr(bc.user.staff_id);
int i = 1;
grfIPD.Rows.Count = dt.Rows.Count + 1;
foreach (DataRow row in dt.Rows)
{
try
{
String status = "", vn = "";
Patient ptt = new Patient();
ptt.patient_birthday = bc.datetoDB(row["mnc_bday"].ToString());
vn = row["MNC_VN_NO"].ToString() + "/" + row["MNC_VN_SEQ"].ToString() + "(" + row["MNC_VN_SUM"].ToString() + ")";
grfIPD[i, 0] = (i);
grfIPD[i, colIPDHn] = row["MNC_HN_NO"].ToString();
grfIPD[i, colIPDVnShow] = vn;
grfIPD[i, colIPDPttName] = row["prefix"].ToString() + " " + row["MNC_FNAME_T"].ToString() + " " + row["MNC_LNAME_T"].ToString();
grfIPD[i, colIPDDate] = bc.datetoShow(row["MNC_AD_DATE"].ToString());
grfIPD[i, colIPDTime] = bc.FormatTime(row["mnc_time"].ToString());
grfIPD[i, colIPDSex] = row["mnc_sex"].ToString();
grfIPD[i, colIPDAge] = ptt.AgeStringShort();
grfIPD[i, colIPDDsc] = row["MNC_FN_TYP_DSC"].ToString();
grfIPD[i, colIPDRemark] = row["MNC_SHIF_MEMO"].ToString();
grfIPD[i, colIPDDept] = row["MNC_MD_DEP_DSC1"].ToString();
grfIPD[i, colIPDWrd] = row["MNC_MD_DEP_DSC"].ToString();
grfIPD[i, colIPDAn] = row["mnc_an_no"].ToString();
//if ((i % 2) == 0)
// grfIPD.Rows[i].StyleNew.BackColor = ColorTranslator.FromHtml(bc.iniC.grfRowColor);
i++;
}
catch (Exception ex)
{
new LogWriter("e", "FrmDoctorView setGrfApm ex " + ex.Message);
}
}
grfIPD.Cols[colIPDId].Visible = false;
grfIPD.Cols[0].Visible = true;
grfIPD.Rows[0].Visible = true;
grfIPD.Cols[colIPDHn].AllowEditing = false;
grfIPD.Cols[colIPDVnShow].Visible = false;
grfIPD.Cols[colIPDPttName].AllowEditing = false;
grfIPD.Cols[colIPDDate].AllowEditing = false;
grfIPD.Cols[colIPDTime].AllowEditing = false;
grfIPD.Cols[colIPDSex].AllowEditing = false;
grfIPD.Cols[colIPDAge].AllowEditing = false;
grfIPD.Cols[colIPDDsc].AllowEditing = false;
grfIPD.Cols[colIPDRemark].AllowEditing = false;
grfIPD.Cols[colIPDDept].AllowEditing = false;
//grfIPD.Cols[colIPDDsc].Visible = 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 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;
}
public PatientOld setPatientToOLD(Patient ptt)
{
PatientOld pttO1 = new PatientOld();
pttO1.Address = ptt.patient_house;
//pttO1.PIDS = ptt.patient_hn;
pttO1.Age = ptt.AgeStringShort().Replace("Y", ".").Replace("M", ".").Replace("D", ".");
pttO1.AgentID = ptt.agent;
pttO1.Allergy = ptt.patient_drugallergy;
pttO1.BuildingVillage = "";
pttO1.CompanyName = "";
pttO1.CompanyPhoneNo = "";
pttO1.ContractName = ptt.contract;
pttO1.DateOfBirth = ptt.patient_birthday;
pttO1.District = "";
pttO1.Email = ptt.email;
pttO1.EmergencyPersonAddress = "";
//pttO1.EmergencyPersonalContact = ptt.patient_contact_firstname+" "+ptt.patient_contact_lastname;
String prefix = "";
prefix = fpfDB.getList(ptt.patient_contact_f_patient_prefix_id);
//prefix = prefix.Equals("Mrs.") ? "1" : prefix.Equals("Miss") ? "2" : prefix.Equals("Mr.") ? "3" : prefix.Equals("Girl") ? "4" : prefix.Equals("Boy") ? "5" : "";
pttO1.EmergencyPersonalContact = prefix + " " + ptt.patient_contact_firstname + " " + ptt.patient_contact_lastname;
pttO1.EPAddress = "";
pttO1.EPDistrict = "";
pttO1.EPEmail = "";
pttO1.EPHomePhoneNo = "";
pttO1.EPMobilePhoneNo = "";
pttO1.EPProvince = "";
pttO1.EPRoad = "";
pttO1.EPSubDistrict = "";
pttO1.EPZipcode = "";
pttO1.HomePhoneNo = ptt.mobile2;
pttO1.IDNumber = ptt.passport;
pttO1.IDType = "";
pttO1.InsuranceName = ptt.insurance;
String mat = "";
mat = fmsDB.getList(ptt.f_patient_marriage_status_id);
pttO1.MaritalID = mat.Equals("หย่า") ? "3" : mat.Equals("หม้าย") ? "4" : mat.Equals("โสด") ? "1" : mat.Equals("คู่") ? "2" : "";
pttO1.MobilePhoneNo = ptt.mobile1;
pttO1.Moo = ptt.patient_moo;
pttO1.Nationality = fpnDB.getList(ptt.f_patient_nation_id);
pttO1.Occupation = "";
pttO1.OName = "";
pttO1.OSurname = "";
pttO1.PatientTypeID = ptt.patient_type;
//pttO1.PaymentID = ptt.b_contract_plans_id;
pttO1.PaymentID = "1";
pttO1.PID = ptt.t_patient_id_old.Equals("-1") ? "" : ptt.t_patient_id_old.Equals("0") ? "" : ptt.t_patient_id_old;
pttO1.PIDS = ptt.patient_hn;
pttO1.PName = ptt.patient_firstname_e;
pttO1.Province = "";
pttO1.PSurname = ptt.patient_lastname_e;
pttO1.Race = fracDB.getList(ptt.f_patient_race_id);
pttO1.RelationshipID = "";
pttO1.RelationshipOther = "";
pttO1.Religion = frgDB.getList(ptt.f_patient_religion_id);
pttO1.Road = ptt.patient_road;
pttO1.SexID = sexDB.getList(ptt.f_sex_id).Equals("ชาย") ? "1" : "2";
pttO1.Soi = "";
String pre = "";
pre = fpfDB.getList(ptt.f_patient_prefix_id);
pttO1.SubDistrict = "";
pttO1.SurfixID = pre.Equals("Mrs.") ? "1" : pre.Equals("Miss") ? "2" : pre.Equals("Mr.") ? "3" : pre.Equals("Girl") ? "4" : pre.Equals("Boy") ? "5" : "";
pttO1.ZipCode = "";
return(pttO1);
}
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);
}