private void getPatient() { System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); #region Variable var dt = new DataTable(); var clsTempData = new clsTempData(); var mobileStatus = ""; #endregion #region Procedure if (rbAll.Checked) { mobileStatus = "All"; } else if (rbNotRegister.Checked) { mobileStatus = "NotRegister"; } else if (rbRegister.Checked) { mobileStatus = "Register"; } dt = clsTempData.getPatient(dtDOEFrom.Value,dtDOETo.Value,getPayor(),mobileStatus); clsTempData.dtIsConverted = null; if (dt!=null && dt.Rows.Count > 0) { #region Check IsConvertPreOrder for (int i = 0; i < dt.Rows.Count; i++) { if (clsTempData.IsConverted( dt.Rows[i]["Name"].ToString().Replace(dt.Rows[i]["PreName"].ToString(),""), dt.Rows[i]["LastName"].ToString(), dt.Rows[i]["DOE"].ToString(), dtDOEFrom.Value.ToString("yyyy-MM-dd HH:mm"), dtDOETo.Value.ToString("yyyy-MM-dd HH:mm"))) { dt.Rows[i]["IsConvertPreOrder"] = "1"; } } dt.AcceptChanges(); #endregion lblSearchResult.Text = string.Format("พบข้อมูลทั้งหมด {0} รายการ",dt.Rows.Count.ToString()); gvPatient.DataSource = dt; gvPatient.Columns["PreName"].Visible = false; gvPatient.Columns["IsConvertPreOrder"].Visible = false; } else { lblSearchResult.Text = string.Format("ไม่พบข้อมูลที่ต้องการ"); gvPatient.DataSource = null; } #endregion }
private void Search() { #region Variable var dt = new DataTable(); var clsTempData = new clsTempData(); var countNoChecklist = 0; #endregion #region Procedure dt = clsTempData.getPatient(dtDOEFrom.Value, dtDOETo.Value, getDropDownListValue(ddlCompany, "Company")); if (dt != null && dt.Rows.Count > 0) { clsGlobal.dtPatient = dt.Copy(); if (btSync.InvokeRequired) { btSync.Invoke(new MethodInvoker(delegate { btSync.Enabled = true; })); } //lblSyncToMobile.Text = ""; #region RemoveColumn string[] columns = { "PatientGUID", "LabEpisode", "Address", "Tel", "Email", "Physician", "RegType", "Programid", "DIVI", "DEP", "SEC", "POS", "LAN", "NAT", "CNT_TRY", "LOC", "Payor", "Epi_Rowid", "ORD_STS", "STS", "DR_CDE", "NTE", "Job", "BusUnit", "BusDiv", "Line", "Shift", "Location", "GrpBook", "HISExist" }; for (int i = 0; i < columns.Length; i++) { dt.Columns.Remove(columns[i]); } dt.AcceptChanges(); #endregion if (gvSyncToMobile.InvokeRequired) { gvSyncToMobile.Invoke(new MethodInvoker(delegate { #region SortDatatable if(dt!=null && dt.Rows.Count > 0) { for(int i = 0; i < dt.Rows.Count; i++) { if (int.Parse(dt.Rows[i]["ChecklistCount"].ToString()) > 0) { dt.Rows[i]["ChecklistCount"] = 1; } else { dt.Rows[i]["ChecklistCount"] = 0; } } dt.AcceptChanges(); } var dv = dt.DefaultView; dv.Sort = "ChecklistCount,No"; #endregion gvSyncToMobile.DataSource = dv.ToTable(); for(int i = 0; i < gvSyncToMobile.Rows.Count; i++) { var checklistCount = (gvSyncToMobile.Rows[i].Cells["ChecklistCount"].Value!=null?gvSyncToMobile.Rows[i].Cells["ChecklistCount"].Value.ToString():"0"); if (checklistCount == "0") { gvSyncToMobile.Rows[i].DefaultCellStyle.BackColor = ColorTranslator.FromHtml("#FF6262"); countNoChecklist += 1; } } gvSyncToMobile.Columns["ChecklistCount"].Visible = false; })); } if (lblSyncToMobile.InvokeRequired) { lblSyncToMobile.Invoke(new MethodInvoker(delegate { lblSyncToMobile.Text = string.Format("พบข้อมูลทั้งหมด {0} รายการ | ไม่มี Checklist {1} รายการ", dt.Rows.Count.ToString(), countNoChecklist.ToString()); })); } } else { clsGlobal.dtPatient = null; if (btSync.InvokeRequired) { btSync.Invoke(new MethodInvoker(delegate { btSync.Enabled = false; })); } if (lblSyncToMobile.InvokeRequired) { lblSyncToMobile.Invoke(new MethodInvoker(delegate { lblSyncToMobile.Text = "- ไม่พบข้อมูลที่ต้องการ -"; })); } } #endregion }