private void btnFilter_Click(object sender, EventArgs e) { using (new LoadingClass.PleaseWait(this.Location, "Generando...")) { var MedicalCenter = new ServiceBL().GetInfoMedicalCenter(); List <string> Filters = new List <string>(); DateTime? pdatBeginDate = dtpDateTimeStar.Value.Date; DateTime? pdatEndDate = dptDateTimeEnd.Value.Date.AddDays(1); if (ddlCustomerOrganization.SelectedValue.ToString() != "-1") { var id3 = ddlCustomerOrganization.SelectedValue.ToString().Split('|'); Filters.Add("v_CustomerOrganizationId==" + "\"" + id3[0] + "\"&&v_CustomerLocationId==" + "\"" + id3[1] + "\""); } if (ddlProtocolId.SelectedValue.ToString() != "-1") { Filters.Add("IdProtocolId==" + "\"" + ddlProtocolId.SelectedValue + "\""); } // Create the Filter Expression strFilterExpression = null; if (Filters.Count > 0) { foreach (string item in Filters) { strFilterExpression = strFilterExpression + item + " && "; } strFilterExpression = strFilterExpression.Substring(0, strFilterExpression.Length - 4); } var objData = new PacientBL().GetInterfaceSeguimiento(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression); grdData.DataSource = objData; lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count()); } }
private void btnFilter_Click(object sender, EventArgs e) { using (new LoadingClass.PleaseWait(this.Location, "Generando...")) { var MedicalCenter = new ServiceBL().GetInfoMedicalCenter(); List <string> Filters = new List <string>(); DateTime? pdatBeginDate = dtpDateTimeStar.Value.Date; DateTime? pdatEndDate = dptDateTimeEnd.Value.Date.AddDays(1); if (ddlCustomerOrganization.SelectedValue.ToString() != "-1") { var id3 = ddlCustomerOrganization.SelectedValue.ToString().Split('|'); Filters.Add("v_CustomerOrganizationId==" + "\"" + id3[0] + "\"&&v_CustomerLocationId==" + "\"" + id3[1] + "\""); } if (ddlEmployerOrganization.SelectedValue.ToString() != "-1") { var id3 = ddlEmployerOrganization.SelectedValue.ToString().Split('|'); Filters.Add("v_EmployerOrganizationId==" + "\"" + id3[0] + "\"&&v_EmployerLocationId==" + "\"" + id3[1] + "\""); } if (ddlWorkingOrganization.SelectedValue.ToString() != "-1") { var id3 = ddlWorkingOrganization.SelectedValue.ToString().Split('|'); Filters.Add("v_WorkingOrganizationId==" + "\"" + id3[0] + "\"&&v_WorkingLocationId==" + "\"" + id3[1] + "\""); } if (ddlProtocolId.SelectedValue.ToString() != "-1") { Filters.Add("ProtocolId==" + "\"" + ddlProtocolId.SelectedValue + "\""); } // Create the Filter Expression strFilterExpression = null; if (Filters.Count > 0) { foreach (string item in Filters) { strFilterExpression = strFilterExpression + item + " && "; } strFilterExpression = strFilterExpression.Substring(0, strFilterExpression.Length - 4); } if (tabControl1.SelectedTab.Name == "tpShauindo") { var objData = new PacientBL().ReporteMatrizShauindo(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression); grdShauindo.DataSource = objData; lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count()); btnExportShauindo.Enabled = true; } else if (tabControl1.SelectedTab.Name == "tpLaZanja") { var objData = new PacientBL().ReporteMatrizLaZanja(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression); grdLaZanja.DataSource = objData; lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count()); btnExportLaZanja.Enabled = true; } else if (tabControl1.SelectedTab.Name == "tpGoldFields") { var objData = new PacientBL().ReporteMatrizGoldFields(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression); grdGolFields.DataSource = objData; lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count()); btnExportGolFields.Enabled = true; } else if (tabControl1.SelectedTab.Name == "tpSolucManteIntegra") { var objData = new PacientBL().ReporteMatrizSolucManteIntegra(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression); grdSoluc.DataSource = objData; lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count()); btnExportSoluc.Enabled = true; } else if (tabControl1.SelectedTab.Name == "tpMiBanco") { var objData = new PacientBL().ReporteMatrizMiBanco(pdatBeginDate, pdatEndDate, ddlCustomerOrganization.SelectedValue.ToString(), strFilterExpression); grdMiBanco.DataSource = objData; lblRecordCount.Text = string.Format("Se encontraron {0} registros.", objData.Count()); btnExportMiBanco.Enabled = true; } } }