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 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 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 GrfVs_AfterRowColChange(object sender, RangeEventArgs e)
{
//throw new NotImplementedException();
if (e.NewRange.r1 < 0)
{
return;
}
if (e.NewRange.Data == null)
{
return;
}
if (txtHn.Text.Equals(""))
{
return;
}
panel2.Enabled = false;
ProgressBar pB1 = new ProgressBar();
pB1.Location = new System.Drawing.Point(113, 36);
pB1.Name = "pB1";
pB1.Size = new System.Drawing.Size(862, 23);
groupBox1.Controls.Add(pB1);
pB1.Left = txtVN.Left;
pB1.Show();
txtVN.Hide();
btnVn.Hide();
btnRefresh.Hide();
txt.Hide();
label6.Hide();
txtVisitDate.Hide();
chkIPD.Hide();
//txtPreNo.Hide();
clearGrf();
String statusOPD = "", vsDate = "", vn = "", an = "", anDate = "", hn = "", preno = "";
statusOPD = grfVs[e.NewRange.r1, colVsStatus] != null ? grfVs[e.NewRange.r1, colVsStatus].ToString() : "";
preno = grfVs[e.NewRange.r1, colVsPreno] != null ? grfVs[e.NewRange.r1, colVsPreno].ToString() : "";
vsDate = grfVs[e.NewRange.r1, colVsVsDate] != null ? grfVs[e.NewRange.r1, colVsVsDate].ToString() : "";
txtVisitDate.Value = vsDate;
if (statusOPD.Equals("OPD"))
{
chkIPD.Checked = false;
vn = grfVs[e.NewRange.r1, colVsVn] != null ? grfVs[e.NewRange.r1, colVsVn].ToString() : "";
txtVN.Value = vn;
label2.Text = "VN :";
}
else
{
chkIPD.Checked = true;
an = grfVs[e.NewRange.r1, colVsAn] != null ? grfVs[e.NewRange.r1, colVsAn].ToString() : "";
anDate = grfVs[e.NewRange.r1, colVsAndate] != null ? grfVs[e.NewRange.r1, colVsAndate].ToString() : "";
txtVN.Value = an;
label2.Text = "AN :";
txtVisitDate.Value = anDate;
}
setStaffNote(vsDate, preno);
DataTable dtOrder = new DataTable();
vn = grfVs[e.NewRange.r1, colVsVn] != null ? grfVs[e.NewRange.r1, colVsVn].ToString() : "";
if (vn.IndexOf("(") > 0)
{
vn = vn.Substring(0, vn.IndexOf("("));
}
if (vn.IndexOf("/") > 0)
{
vn = vn.Substring(0, vn.IndexOf("/"));
}
Application.DoEvents();
dtOrder = bc.bcDB.vsDB.selectDrugOPD(txtHn.Text, vn, preno, bc.datetoDB(vsDate));
grfOrder.Rows.Count = 1;
if (dtOrder.Rows.Count > 0)
{
try
{
pB1.Value = 0;
pB1.Minimum = 0;
pB1.Maximum = dtOrder.Rows.Count;
foreach (DataRow row in dtOrder.Rows)
{
Row rowg = grfOrder.Rows.Add();
rowg[colOrderName] = row["MNC_PH_TN"].ToString();
rowg[colOrderMed] = "";
rowg[colOrderQty] = row["qty"].ToString();
pB1.Value++;
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex.Message, "");
}
}
GC.Collect();
DataTable dt = new DataTable();
dt = bc.bcDB.dscDB.selectByAn(txtHn.Text, an);
if (dt.Rows.Count > 0)
{
try
{
pB1.Value = 0;
pB1.Minimum = 0;
pB1.Maximum = dt.Rows.Count;
//MemoryStream stream;
//Image loadedImage, resizedImage;
C1FlexGrid grf1;
FtpClient ftp = new FtpClient(bc.iniC.hostFTP, bc.iniC.userFTP, bc.iniC.passFTP);
Boolean findTrue = false;
int colcnt = 0;
foreach (DataRow row in dt.Rows)
{
if (findTrue)
{
break;
}
colcnt++;
if (colcnt >= 2)
{
colcnt = 0;
}
String dgssid = "", filename = "", ftphost = "", id = "", folderftp = "";
id = row[bc.bcDB.dscDB.dsc.doc_scan_id].ToString();
dgssid = row[bc.bcDB.dscDB.dsc.doc_group_sub_id].ToString();
filename = row[bc.bcDB.dscDB.dsc.image_path].ToString();
ftphost = row[bc.bcDB.dscDB.dsc.host_ftp].ToString();
folderftp = row[bc.bcDB.dscDB.dsc.folder_ftp].ToString();
foreach (Control con in panel3.Controls)
{
if (findTrue)
{
break;
}
if (con is C1DockingTab)
{
foreach (Control cond in con.Controls)
{
if (findTrue)
{
break;
}
if (cond is C1DockingTabPage)
{
foreach (Control cong in cond.Controls)
{
if (findTrue)
{
break;
}
if (cong is C1DockingTab)
{
foreach (Control congd in cong.Controls)
{
if (findTrue)
{
break;
}
if (congd is C1DockingTabPage)
{
foreach (Control congd1 in congd.Controls)
{
if (congd1 is C1FlexGrid)
{
if (congd1.Name.Equals(dgssid))
{
new Thread(() =>
{
String err = "";
try
{
FtpWebRequest ftpRequest = null;
FtpWebResponse ftpResponse = null;
Stream ftpStream = null;
int bufferSize = 2048;
err = "00";
grf1 = (C1FlexGrid)congd1;
Row rowd;
if (colcnt == 1)
{
err = "001";
//grfPtt.Rows[i].StyleNew.BackColor = color;
rowd = grf1.Rows.Add();
}
else
{
err = "002";
if (grf1.Rows.Count == 0)
{
err = "0021";
rowd = grf1.Rows.Add();
}
else
{
err = "0022";
rowd = grf1.Rows[grf1.Rows.Count - 1];
}
}
MemoryStream stream;
Image loadedImage, resizedImage;
stream = new MemoryStream();
//stream = ftp.download(folderftp + "//" + filename);
//loadedImage = Image.FromFile(filename);
err = "01";
ftpRequest = (FtpWebRequest)FtpWebRequest.Create(ftphost + "/" + folderftp + "/" + filename);
ftpRequest.Credentials = new NetworkCredential(bc.iniC.userFTP, bc.iniC.passFTP);
ftpRequest.UseBinary = true;
ftpRequest.UsePassive = bc.ftpUsePassive;
ftpRequest.KeepAlive = true;
ftpRequest.Method = WebRequestMethods.Ftp.DownloadFile;
ftpResponse = (FtpWebResponse)ftpRequest.GetResponse();
ftpStream = ftpResponse.GetResponseStream();
err = "02";
byte[] byteBuffer = new byte[bufferSize];
int bytesRead = ftpStream.Read(byteBuffer, 0, bufferSize);
try
{
while (bytesRead > 0)
{
stream.Write(byteBuffer, 0, bytesRead);
bytesRead = ftpStream.Read(byteBuffer, 0, bufferSize);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
err = "03";
loadedImage = new Bitmap(stream);
err = "04";
int originalWidth = 0;
originalWidth = loadedImage.Width;
int newWidth = 600;
resizedImage = loadedImage.GetThumbnailImage(newWidth, (newWidth * loadedImage.Height) / originalWidth, null, IntPtr.Zero);
//
err = "05";
if (colcnt == 1)
{
err = "051";
rowd[colPic1] = resizedImage;
err = "06";
rowd[colPic2] = id;
err = "07";
}
else
{
err = "052 " + colPic3 + " cnt " + grf1.Cols.Count;
rowd[colPic3] = resizedImage;
err = "061";
rowd[colPic4] = id;
err = "071";
}
strm = new listStream();
strm.id = id;
err = "08";
strm.stream = stream;
err = "09";
lStream.Add(strm);
//grf1.AutoSizeRows();
//err = "10";
//grf1.AutoSizeCols();
//err = "11";
//loadedImage.Dispose();
//resizedImage.Dispose();
//stream.Dispose();
//Application.DoEvents();
err = "12";
//findTrue = true;
//break;
//GC.Collect();
}
catch (Exception ex)
{
String aaa = ex.Message + " " + err;
}
}).Start();
}
}
}
}
}
}
}
}
}
}
}
pB1.Value++;
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex.Message, "");
}
}
pB1.Dispose();
txtVN.Show();
btnVn.Show();
btnRefresh.Show();
txt.Show();
label6.Show();
chkIPD.Show();
//grf1.AutoSizeRows();
//grf1.AutoSizeRows();
panel2.Enabled = true;
}
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 BtnImportDfGen_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
String dfdate = "";
int i = 20000;
DateTime date = new DateTime();
DateTime.TryParse(DateTime.Now.ToString(), out date);
if (date.Year > 2500)
{
date = date.AddYears(-543);
}
else if (date.Year < 2000)
{
date = date.AddYears(543);
}
dfdate = date.ToString("yyyy-MM-dd", new CultureInfo("en-US"));
foreach (Row row in grfSelect.Rows)
{
String doccd = "", docyr = "", docno = "", docdat = "", fncd = "", fnno = "", fndat = "", chk = "", fndsc = "", dfamt = "", vsdate = "", vstime = "", hnno = "", hnyr = "", patname = "", preno = "", paidtypecode = "", dtrid = "", dtrname = "";
String anno = "", anyr = "";
chk = row[colchk] != null ? row[colchk].ToString() : "";
if (!chk.ToLower().Equals("true"))
{
continue;
}
doccd = row[coldoccd] != null ? row[coldoccd].ToString() : "";
docyr = row[coldoc_yr] != null ? row[coldoc_yr].ToString() : "";
docno = row[coldocno] != null ? row[coldocno].ToString() : "";
docdat = row[coldocdat] != null ? row[coldocdat].ToString() : "";
vsdate = row[colvsdate] != null ? row[colvsdate].ToString() : "";
vstime = row[colvstime] != null ? row[colvstime].ToString() : "";
hnno = row[colhnno] != null ? row[colhnno].ToString() : "";
hnyr = row[colhnyr] != null ? row[colhnyr].ToString() : "";
patname = row[colpttname] != null ? row[colpttname].ToString() : "";
preno = row[colpreno] != null ? row[colpreno].ToString() : "";
paidtypecode = row[colpaidtype] != null ? row[colpaidtype].ToString() : "";
dtrid = row[coldtrcode] != null ? row[coldtrcode].ToString() : "";
dtrname = row[coldtrname] != null ? row[coldtrname].ToString() : "";
anno = row[colanno] != null ? row[colanno].ToString() : "";
anyr = row[colanyr] != null ? row[colanyr].ToString() : "";
fncd = "470";
fndsc = "ค่าแพทย์ CHECKUP";
dfamt = "10";
DotDfDetail dotdfd = new DotDfDetail();
dotdfd.MNC_DOC_CD = doccd; //pk
dotdfd.MNC_DOC_YR = docyr; //pk
dotdfd.MNC_DOC_NO = docno; //pk
dotdfd.MNC_DOC_DAT = docdat; //pk
dotdfd.MNC_FN_CD = fncd; //pk
dotdfd.MNC_FN_NO = i.ToString(); //pk
dotdfd.MNC_FN_DAT = docdat; //pk
//dotdfd.MNC_DF_DATE = dfdate;
dotdfd.MNC_DF_DATE = bc.datetoDB(vsdate); // ต้องเป็น vsdate จากการดู data ของ วันต่างๆ
dotdfd.MNC_FN_TYP_DESC = fndsc;
dotdfd.MNC_DF_AMT = dfamt;
dotdfd.MNC_FN_AMT = dfamt;
dotdfd.MNC_DATE = bc.datetoDB(vsdate);
dotdfd.MNC_TIME = vstime;
dotdfd.MNC_HN_NO = hnno;
dotdfd.MNC_HN_YR = hnyr;
dotdfd.MNC_AN_NO = anno;
dotdfd.MNC_AN_YR = anyr;
dotdfd.MNC_PAT_NAME = patname;
dotdfd.MNC_PRE_NO = preno;
dotdfd.MNC_FN_TYP_CD = paidtypecode;
dotdfd.MNC_DOT_CD_DF = dtrid;
dotdfd.MNC_DOT_GRP_CD = "0";
dotdfd.MNC_DOT_NAME = dtrid + "0" + dtrname;
dotdfd.MNC_PAY_FLAG = "Y";
dotdfd.MNC_PAY_DAT = ""; // null
dotdfd.MNC_PAY_NO = ""; // null
dotdfd.MNC_PAY_YR = ""; // null
dotdfd.MNC_REF_NO = ""; // null
dotdfd.MNC_REF_DAT = ""; // null
dotdfd.MNC_EMP_CD = ""; // null
dotdfd.MNC_DF_GROUP = "1";
dotdfd.MNC_PAY_TYP = "2";
dotdfd.MNC_PAY_RATE = dfamt;
dotdfd.MNC_DF_DET_TYPE = ""; // null
dotdfd.status_insert_manual = "1";
String re = bc.bcDB.dotdfdDB.insert(dotdfd);
i++;
}
MessageBox.Show("gen ข้อมูล ค่าแพทย์ checkup เรียบร้อย", "");
}
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 setGrf(String hn, String vn, String preno, String dsDate, String chk, String an, C1FlexGrid grf)
{
String dsDate1 = "", dsTime = "", dsDate2 = "";
dsDate1 = bc.bcDB.vsDB.selectDSDateAN(hn, vn, preno);
String[] aa = dsDate.Split(',');
if (aa.Length > 1)
{
dsDate2 = aa[0];
//an = aa[1];
}
String[] bb = dsDate1.Split('*');
if (bb.Length > 1)
{
dsDate2 = bb[0];
dsTime = bb[1];
}
DataTable dt, dtt12;
if (chk.Equals(""))
{
dt = bc.bcDB.vsDB.selectNHSOPrintHN("", hn, preno, vn);
}
else
{
dt = bc.bcDB.vsDB.selectNHSOPrintHNAll("", hn, preno, vn);
}
DateTime dtEnd = new DateTime();
DateTime dtStart = new DateTime();
String datestart = "", dateend = "", time3 = "";
String[] an1 = an.Split('/');
if (an1.Length >= 1)
{
dtt12 = bc.bcDB.vsDB.selectPatientOR(hn, preno, an1[0]);
if (dtt12.Rows.Count > 0)
{
datestart = dtt12.Rows[0]["MNC_OR_DATE_S"].ToString();
if (datestart.Length >= 10)
{
datestart = datestart.Substring(0, 10);
//dateend = datestart;
String time1 = "0" + dtt12.Rows[0]["MNC_OR_TIME_S"].ToString();
if (time1.Length > 2)
{
String time2 = time1.Substring(time1.Length - 2, 2);
//String time3 = "";
String time4 = time1.Substring(time1.Length - 4, 2);
time3 = " " + time4 + ":" + time2;
if (DateTime.TryParse(datestart + time3, out dtStart))
{
dtEnd = dtStart;
String time5 = "";
time5 = dtt12.Rows[0]["MNC_OR_HOUR"].ToString();
int cnt = 0;
if (int.TryParse(time5, out cnt))
{
int cnt1 = 0, cnt2 = 0, cnt0 = 0;
cnt1 = cnt / 60;
cnt2 = cnt % 60;
dtEnd = dtEnd.AddHours(cnt1);
dtEnd = dtEnd.AddMinutes(cnt2);
dateend = dtEnd.ToString("HH:mm");
}
}
}
}
}
}
if (dt.Rows.Count > 0)
{
grf.Rows.Count = dt.Rows.Count + 1;
for (int i = 1; i <= dt.Rows.Count; i++)
{
grf[i, 0] = (i + 1);
grf[i, colGrfPhTn] = dt.Rows[i - 1]["MNC_PH_TN"].ToString() + " [" + dt.Rows[i - 1]["MNC_PH_cd"].ToString() + "]";
grf[i, colGrfQty] = dt.Rows[i - 1]["qty"].ToString();
grf[i, colGrfPrice] = dt.Rows[i - 1]["MNC_PH_PRI01"].ToString();
grf[i, colGrfAmt] = dt.Rows[i - 1]["amt"].ToString();
//grf[i, colHn] = dt.Rows[i]["amt"].ToString();
grf[i, colGrfDate] = bc.dateDBtoShowShort(bc.datetoDB(dt.Rows[i - 1]["MNC_CFG_DAT"].ToString())) + " " + time3 + "-" + dateend;
}
}
}
