protected void Page_Load(object sender, EventArgs e)
{
oWeb.ValidaSessionAdm();
if (!IsPostBack)
{
CodMonitorView.Value = oWeb.GetData("CodMonitorView");
DBConn oConn = new DBConn();
if (oConn.Open())
{
if (string.IsNullOrEmpty(CodMonitorView.Value))
{
cAppTipoConnsulta oAppTipoConnsulta = new cAppTipoConnsulta(ref oConn);
DataTable dtTipoConsulta = oAppTipoConnsulta.Get();
if (dtTipoConsulta != null)
{
if (dtTipoConsulta.Rows.Count > 0)
{
oCmbTipoConsulta.Items.Add(new RadComboBoxItem("Seleccione Tipo Consulta", ""));
foreach (DataRow oRow in dtTipoConsulta.Rows)
{
oCmbTipoConsulta.Items.Add(new RadComboBoxItem(oRow["nom_tipo"].ToString(), oRow["cod_tipo"].ToString()));
}
}
}
dtTipoConsulta = null;
}
else
{
cAppTipoConnsulta oAppTipoConnsulta = new cAppTipoConnsulta(ref oConn);
oAppTipoConnsulta.CodMonitor = CodMonitorView.Value;
DataTable dtTipoConsulta = oAppTipoConnsulta.GetByMonitor();
if (dtTipoConsulta != null)
{
if (dtTipoConsulta.Rows.Count > 0)
{
oCmbTipoConsulta.Items.Add(new RadComboBoxItem("Seleccione Tipo Consulta", ""));
foreach (DataRow oRow in dtTipoConsulta.Rows)
{
oCmbTipoConsulta.Items.Add(new RadComboBoxItem(oRow["nom_tipo"].ToString(), oRow["cod_tipo"].ToString()));
}
}
}
dtTipoConsulta = null;
btnGrabar1.Visible = false;
cAppMonitorView oAppMonitorView = new cAppMonitorView(ref oConn);
oAppMonitorView.CodMonitor = CodMonitorView.Value;
DataTable dtMonitorView = oAppMonitorView.Get();
if (dtMonitorView != null)
{
if (dtMonitorView.Rows.Count > 0)
{
txt_nombre.Text = dtMonitorView.Rows[0]["desc_monitor_view"].ToString();
oCmbEstado.Items.FindByValue(dtMonitorView.Rows[0]["est_monitor_view"].ToString()).Selected = true;
}
dtMonitorView.Dispose();
}
dtMonitorView = null;
txt_nombre.Enabled = false;
oCmbEstado.Enabled = false;
trPagesView.Visible = true;
cAptMonitorPages oAptMonitorPages = new cAptMonitorPages(ref oConn);
oAptMonitorPages.CodMonitor = CodMonitorView.Value;
gridPages.DataSource = oAptMonitorPages.Get();
gridPages.DataBind();
hddMonitorCreated.Value = "1";
}
oConn.Close();
}
}
else
{
if (!string.IsNullOrEmpty(oWeb.GetData("hddReload")))
{
hddReload.Value = string.Empty;
oCmbTipoConsulta.FindItemByValue("").Selected = true;
}
}
}
protected void oCmbTipoConsulta_OnClientSelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
DataTable oPages = null;
tdselectvista.Visible = true;
DBConn oConn = new DBConn();
if (oConn.Open())
{
cAppPages oAppPages = new cAppPages(ref oConn);
oAppPages.CodTipo = oCmbTipoConsulta.SelectedValue.ToString();
if (oCmbTipoConsulta.SelectedValue.ToString() == "N")
{
oAppPages.CodMonitor = CodMonitorView.Value;
oPages = oAppPages.GetByType();
}
else
{
oPages = oAppPages.GetByTipo();
}
cAppTipoConnsulta oTipoConnsulta = new cAppTipoConnsulta(ref oConn);
oTipoConnsulta.CodTipo = oCmbTipoConsulta.SelectedValue.ToString();
oTipoConnsulta.IndSegNivel = "S";
DataTable dtTpCon = oTipoConnsulta.Get();
if (dtTpCon != null)
{
if (dtTpCon.Rows.Count > 0)
{
//tpconsulta_segundonivel.Visible = true;
tpconsulta_normal.Visible = false;
//oCmbPages.Visible = false;
//lblPage.Visible = true;
//if (oPages != null)
//{
// if (oPages.Rows.Count > 0)
// {
// lblPage.Text = oPages.Rows[0]["nom_page"].ToString();
// hddCodPage.Value = oPages.Rows[0]["cod_page"].ToString();
//LoadGrid();
// }
// oPages.Dispose();
//}
//oPages = null;
btnGrabar2.Visible = false;
}
else
{
lblPage.Visible = false;
cCliente oCliente = new cCliente(ref oConn);
DataTable dtcliente = oCliente.Get();
tpconsulta_normal.Visible = true;
tpconsulta_segundonivel.Visible = false;
btnGrabar2.Visible = true;
//oCmbPages.Items.Add(new ListItem("Selecciona una vista", ""));
oCmbHolding.Items.Clear();
oCmbHolding.Items.Add(new ListItem("Selecciona holding", ""));
DataTable dtholding = oCliente.GetHolding();
if (dtholding != null)
{
foreach (DataRow oRow in dtholding.Rows)
{
oCmbHolding.Items.Add(new ListItem(oRow["holding"].ToString(), oRow["ncodholding"].ToString()));
}
}
dtholding = null;
oCmbCliente.Items.Clear();
oCmbCliente.Items.Add(new RadComboBoxItem("Selecciona cliente", ""));
if (dtcliente != null)
{
foreach (DataRow oRow in dtcliente.Rows)
{
oCmbCliente.Items.Add(new RadComboBoxItem(oRow["snombre"].ToString(), oRow["nkey_cliente"].ToString()));
}
}
dtcliente = null;
}
}
dtTpCon = null;
oCmbPages.Visible = true;
oCmbPages.Items.Clear();
oCmbPages.Items.Add(new RadComboBoxItem("Selecciona una Vista", ""));
if (oPages != null)
{
if (oPages.Rows.Count > 0)
{
foreach (DataRow oRow in oPages.Rows)
{
oCmbPages.Items.Add(new RadComboBoxItem(oRow["nom_page"].ToString(), oRow["cod_page"].ToString()));
}
}
oPages.Dispose();
}
oPages = null;
}
oConn.Close();
}
