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
}