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%'");
}