protected void Page_Load(object sender, EventArgs e) { var ident = Context.User.Identity.Name.ToString(); dt = new DataTable(); dt = query.EjecutaConsultaSQl("SELECT dir_comercial,mandrake FROM Tbl_Acceso_Usuarios where username='******'"); if (Context.User.Identity.IsAuthenticated == true) { /*if (dt.Rows[0][0].ToString() == "LP - DA") * {*/ Lb_numases.Visible = true; Lb_poliza.Visible = false; /*} * else * { * Lb_numases.Visible = false; * Lb_numases2.Visible = true; * Lb_nombreases.Visible = false; * Lb_poliza.Visible = false; * Lb_poliza2.Visible = true; * } * } * else * { * Lb_numases.Visible = false; * Lb_numases2.Visible = false; * Lb_nombreases.Visible = false; * Lb_poliza.Visible = false; * Lb_poliza2.Visible = false; * }*/ } }
protected void Page_Load(object sender, EventArgs e) { datos_ases.Visible = false; datos_ases_dos.Visible = false; dt = new DataTable(); dt = query.EjecutaConsultaSQl("Select Convert(char(10), MAX(F_PAGO), 103) from POLIZARIO15"); Label1.Text = dt.Rows[0][0].ToString(); /* if (Context.User.Identity.IsAuthenticated == true) * { * try * { * dt = new DataTable(); * dt = query.EjecutaConsultaSQl("Select Convert(char(10), MAX(F_PAGO), 103) from POLIZARIO15"); * Label1.Text = dt.Rows[0][0].ToString(); * variable = Request.QueryString["variable"]; * buscame(variable); * * } * catch (Exception ex) * { * this.Page.Response.Write("<script language='JavaScript'>window.alert('" + ex.Message + "');</script>"); * } * } * else * { * Response.Redirect(""); * } */ }
protected void Page_Load(object sender, EventArgs e) { dt = new DataTable(); dt = query.EjecutaConsultaSQl("SELECT A.DESC_VTA,A.DESC_OFNA,A.EDA,A.DESC_GEREN,A.PROM_MAT,A.PROM_SUC,A.RAZ_SOCIAL,A.NUM_AGENTE,A.NOMBRE_DEL,A.FECHA_DE_C,A.CONCURSO,A.GRUPO,A.MES_ACTUAL,B.POL_VIDA,B.[PólizasAMFLEX],B.PÓLIZAS,B.COMISIONES,B.CUMPLE_POL_VIDA,B.META_PÓLIZAS,B.META_COMISIONES,B.CUMPLETA,B.BONO_EXCEDENTE,B.FALTA_PÓLIZAS,B.FALTA_COMISIONES,B.PORCENTAJE_A_GANAR,B.POLIZAS_ACUMULADAS,B.POLIZAS_PROMEDIO,B.POR_BONOADIC,B.PROACTIVO,B.POL_FALTANTES,A.ENE,A.FEB,A.MAR,ABR='',MAY='',JUN='',JUL='',AGO='',SEP='',OCT='',NOV='',DIC='' FROM DETALLE_EFECTIVIDAD_REPORTE_UNO A LEFT OUTER JOIN ASESORES_TA_LP B ON A.NUM_AGENTE=B.ASESOR WHERE A.DESC_VTA NOT LIKE '%Z%'"); }