Пример #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string    id             = Server.HtmlEncode(Request.QueryString["id"]);
            string    serial         = Server.HtmlEncode(Request.QueryString["serial"]);
            string    fecha          = "";
            string    departamento   = "";
            string    solicitante    = "";
            string    sa             = "";
            string    ss             = "";
            string    so             = "";
            string    app            = "";
            string    win            = "";
            string    off            = "";
            string    otr            = "";
            string    observacioness = "";
            string    scpu           = "";
            string    impresora      = "";
            string    monitor        = "";
            string    teclado        = "";
            string    mouse          = "";
            string    regulador      = "";
            string    conexionr      = "";
            string    conexioni      = "";
            string    switche        = "";
            string    observacionesh = "";
            DBConnect conector       = new DBConnect();
            DataTable listado        = conector.SSolicitud(id);

            for (int i = 0; i < listado.Rows.Count; i++)
            {
                ListItem opcion = new ListItem();
                fecha          = listado.Rows[i][1].ToString();
                departamento   = listado.Rows[i][2].ToString();
                solicitante    = listado.Rows[i][3].ToString();
                sa             = listado.Rows[i][4].ToString();
                ss             = listado.Rows[i][5].ToString();
                so             = listado.Rows[i][6].ToString();
                app            = listado.Rows[i][7].ToString();
                win            = listado.Rows[i][8].ToString();
                off            = listado.Rows[i][9].ToString();
                otr            = listado.Rows[i][10].ToString();
                observacioness = listado.Rows[i][11].ToString();
                scpu           = listado.Rows[i][12].ToString();
                impresora      = listado.Rows[i][13].ToString();
                monitor        = listado.Rows[i][14].ToString();
                teclado        = listado.Rows[i][15].ToString();
                mouse          = listado.Rows[i][16].ToString();
                regulador      = listado.Rows[i][17].ToString();
                conexionr      = listado.Rows[i][18].ToString();
                conexioni      = listado.Rows[i][19].ToString();
                observacionesh = listado.Rows[i][20].ToString();
                switche        = listado.Rows[i][21].ToString();
            }
            Response.ContentType = "application/pdf";
            //System.Web.HttpContext.Current.Server.MapPath
            sharpPDF.pdfDocument myDoc = new sharpPDF.pdfDocument("Sample Application", "Me", false);
            myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/encabezadorpt.gif"), "encabezado");
            myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/piedepagina.gif"), "pie");
            /*Table's creation*/
            sharpPDF.pdfPage         myFirstPage = myDoc.addPage();
            sharpPDF.Tables.pdfTable myTable     = new sharpPDF.Tables.pdfTable(myDoc);
            myTable.borderSize  = 1;
            myTable.borderColor = new sharpPDF.pdfColor(0, 0, 0);
            myTable.coordX      = 60;
            myTable.coordY      = 640;
            myTable.tableHeader.addColumn(100);
            myTable.tableHeader.addColumn(210);
            myTable.tableHeader.addColumn(67);
            myTable.tableHeader.addColumn(115);
            myFirstPage.addImage(myDoc.getImageReference("encabezado"), 50, 700);
            myFirstPage.addText("SOLICITUD DE SERVICIO", 60, 650, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 20);
            sharpPDF.Tables.pdfTableRow myRow = myTable.createRow();
            myRow[0].addText("Departamento:", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
            myRow[1].addText(departamento, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
            myRow[2].addText("Telefono:", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
            myRow[3].addText("0243-2721295", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
            myTable.addRow(myRow);
            myRow = null;
            myFirstPage.addTable(myTable, 600);
            sharpPDF.Tables.pdfTable myTable2 = new sharpPDF.Tables.pdfTable(myDoc);
            myTable2.borderSize  = 1;
            myTable2.borderColor = new sharpPDF.pdfColor(0, 0, 0);
            myTable2.coordX      = 60;
            myTable2.coordY      = 617;
            myTable2.tableHeader.addColumn(146);
            myTable2.tableHeader.addColumn(164);
            myTable2.tableHeader.addColumn(49);
            myTable2.tableHeader.addColumn(133);
            sharpPDF.Tables.pdfTableRow myRow2 = myTable2.createRow();
            myRow2[0].addText("Nombre del Solicitante:", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
            myRow2[1].addText(solicitante, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
            myRow2[2].addText("Fecha:", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
            myRow2[3].addText(fecha, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
            myTable2.addRow(myRow2);
            myRow2 = null;
            myFirstPage.addTable(myTable2, 600);
            myFirstPage.addText("Descripcion del Tipo de Falla", 60, 580, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12);
            myFirstPage.drawRectangle(60, 578, 552, 497, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
            myFirstPage.addText("Software", 65, 560, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            if (sa == "1")
            {
                myFirstPage.drawRectangle(65, 540, 75, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Sistemas Administrativos", 80, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(65, 540, 75, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Sistemas Administrativos", 80, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (ss == "1")
            {
                myFirstPage.drawRectangle(220, 540, 230, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Sistemas de Salud", 235, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(220, 540, 230, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Sistemas de Salud", 235, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (so == "1")
            {
                myFirstPage.drawRectangle(340, 540, 350, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Sistema Operativo", 355, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(340, 540, 350, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Sistema Operativo", 355, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (app == "1")
            {
                myFirstPage.drawRectangle(460, 540, 470, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Aplicaciones", 475, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(460, 540, 470, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Aplicaciones", 475, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (win == "1")
            {
                myFirstPage.drawRectangle(65, 520, 75, 530, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Windows", 80, 520, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(65, 520, 75, 530, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Windows", 80, 520, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (off == "1")
            {
                myFirstPage.drawRectangle(220, 520, 230, 530, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Office", 235, 520, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(220, 520, 230, 530, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Office", 235, 520, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (otr == "1")
            {
                myFirstPage.drawRectangle(340, 520, 350, 530, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Otro", 355, 520, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(340, 520, 350, 530, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Otro", 355, 520, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }

            myFirstPage.addText(observacioness, 65, 500, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
/// hardware

            myFirstPage.drawRectangle(60, 497, 552, 409, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
            myFirstPage.addText("Hardware", 65, 477, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));

            if (scpu == "1")
            {
                myFirstPage.drawRectangle(65, 457, 75, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("C.P.U.", 80, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(65, 457, 75, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("C.P.U.", 80, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (impresora == "1")
            {
                myFirstPage.drawRectangle(220, 457, 230, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Impresora", 235, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(220, 457, 230, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Impresora", 235, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (monitor == "1")
            {
                myFirstPage.drawRectangle(340, 457, 350, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Monitor", 355, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(340, 457, 350, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Monitor", 355, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (teclado == "1")
            {
                myFirstPage.drawRectangle(460, 457, 470, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Teclado", 475, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(460, 457, 470, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Teclado", 475, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (mouse == "1")
            {
                myFirstPage.drawRectangle(65, 437, 75, 447, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Mouse", 80, 437, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(65, 437, 75, 447, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Mouse", 80, 437, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (regulador == "1")
            {
                myFirstPage.drawRectangle(220, 437, 230, 447, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Regulador", 235, 437, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(220, 437, 230, 447, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Regulador", 235, 437, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (conexionr == "1")
            {
                myFirstPage.drawRectangle(340, 437, 350, 447, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Conexion de Red", 355, 437, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(340, 437, 350, 447, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Conexion de Red", 355, 437, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (conexioni == "1")
            {
                myFirstPage.drawRectangle(65, 417, 75, 427, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Conexion de Internet", 80, 417, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(65, 417, 75, 427, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Conexion de Internet", 80, 417, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            if (switche == "1")
            {
                myFirstPage.drawRectangle(220, 417, 230, 427, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
                myFirstPage.addText("Switche de Red", 235, 417, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            else
            {
                myFirstPage.drawRectangle(220, 417, 230, 427, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("Switche de Red", 235, 417, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            }
            myFirstPage.addText(observacioness, 220, 417, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            myFirstPage.addText("Datos del Servicio", 200, 395, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            myFirstPage.drawRectangle(60, 390, 552, 320, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
            myFirstPage.drawRectangle(276, 390, 552, 375, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
            myFirstPage.addText("Conforme Notificacion", 280, 377, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            myFirstPage.drawRectangle(276, 375, 414, 360, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
            myFirstPage.addText("Firma Solicitante", 280, 362, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            myFirstPage.drawRectangle(414, 375, 552, 360, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
            myFirstPage.addText("Firma Tecnico", 416, 362, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            myFirstPage.drawRectangle(276, 360, 414, 320, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
            myFirstPage.drawRectangle(414, 360, 552, 320, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
            myFirstPage.addText("Fecha de notificacion al Tecnico:", 75, 375, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            myFirstPage.addText(fecha, 90, 360, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
            myTable     = null;
            myFirstPage = null;
            myDoc.createPDF(Response.OutputStream);
            myDoc = null;
        }
Пример #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            int    mmm  = 0;
            string menu = Server.HtmlEncode(Request.QueryString["menu"]);

            if (menu == "1")
            {
                mmm++;
            }
            else
            {
                Response.Redirect("../Default.aspx");
            }
            DBConnect conexion = new DBConnect();
            DataTable DTv6     = conexion.Sv6();
            int       rec      = DTv6.Rows.Count;
            decimal   d        = rec / 25;
            int       t        = Convert.ToInt16(decimal.Round(d, 1));
            int       n        = 0;

            Response.ContentType = "application/pdf";
            //System.Web.HttpContext.Current.Server.MapPath
            sharpPDF.pdfDocument myDoc = new sharpPDF.pdfDocument("Sample Application", "Me", false);
            myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/encabezado.gif"), "encabezado");
            myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/piedepagina.gif"), "pie");
            /*Table's creation*/
            int k = 25;
            int i = 0;

            for (n = 0; n <= t; n++)
            {
                sharpPDF.pdfPage myFirstPage = myDoc.addPage(748, 1024);
                //sharpPDF.pdfPage myFirstPage = myDoc.addPage(210, 297);
                sharpPDF.Tables.pdfTable myTable = new sharpPDF.Tables.pdfTable(myDoc);
                myTable.borderSize  = 1;
                myTable.borderColor = new sharpPDF.pdfColor(0, 0, 0);
                myTable.coordX      = 20;
                myTable.coordY      = 600;
                myTable.tableHeader.addColumn(150);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(60);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(60);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(60);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(60);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(60);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(60);
                myFirstPage.addImage(myDoc.getImageReference("encabezado"), 20, 690);
                myFirstPage.addText("FALLAS DE HARDWARE REPORTADAS Y SOLVENTADAS POR CADA DEPARTAMENTO", 80, 650, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 20);
                sharpPDF.Tables.pdfTableRow myRow = myTable.createRow();
                myRow[0].addText("DEPARTAMENTO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[1].addText("CPU", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[2].addText("CPUP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[3].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[4].addText("IMP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[5].addText("IMPP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[6].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[7].addText("MON", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[8].addText("MONP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[9].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[10].addText("TEC", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[11].addText("TECP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[12].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[13].addText("MOU", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[14].addText("MOUP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[15].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[16].addText("REG", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[17].addText("REGP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[18].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myTable.addRow(myRow);
                myRow = null;
                while (i < k)
                {
                    if (i < rec)
                    {
                        sharpPDF.Tables.pdfTableRow myRow2 = myTable.createRow();
                        myRow2[0].addText(DTv6.Rows[i]["departamento"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[1].addText(DTv6.Rows[i]["cpurep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[2].addText(DTv6.Rows[i]["cpures"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[3].addText(DTv6.Rows[i]["cpup"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[4].addText(DTv6.Rows[i]["impresorarep"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[5].addText(DTv6.Rows[i]["impresorares"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[6].addText(DTv6.Rows[i]["impresorap"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[7].addText(DTv6.Rows[i]["monitorrep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[8].addText(DTv6.Rows[i]["monitorres"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[9].addText(DTv6.Rows[i]["cmonitor"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[10].addText(DTv6.Rows[i]["tecladorep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[11].addText(DTv6.Rows[i]["tecladores"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[12].addText(DTv6.Rows[i]["tecladop"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[13].addText(DTv6.Rows[i]["mouserep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[14].addText(DTv6.Rows[i]["mouseres"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[15].addText(DTv6.Rows[i]["mousep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[16].addText(DTv6.Rows[i]["reguladorrep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[17].addText(DTv6.Rows[i]["reguladorres"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[18].addText(DTv6.Rows[i]["reguladorp"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myTable.addRow(myRow2);
                        myRow2 = null;
                        i++;
                    }
                    else
                    {
                        i++;
                    }
                }
                myFirstPage.addTable(myTable, 600);
                myFirstPage.drawRectangle(20, 45, 990, 10, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("CPU = CPU Reportados", 30, 35, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("CPUP = Fallas de CPU resueltas", 30, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("IMP = Impresoras reportadas", 230, 35, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("IMPP = Fallas de Impresoras resueltas", 230, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("MON = Monitores Reportados", 430, 35, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("MONP = Fallas de Monitores Resueltas", 430, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("TEC = Teclados Reportados", 630, 35, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("TECP = Fallas de Teclados Resueltas", 630, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("MOU = Mouse Reportados", 780, 35, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("MOUP = Fallas de Mouse Resueltas", 780, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("REG = Reguladores Reportados", 30, 15, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("REP = Fallas de Mouse Resueltas", 230, 15, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myTable     = null;
                myFirstPage = null;
                k           = k + 25;
            }
            myDoc.createPDF(Response.OutputStream);
            myDoc = null;
        }
Пример #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string fechainicio = Server.HtmlEncode(Request.QueryString["fechainicio"]);
            string fechafinal  = Server.HtmlEncode(Request.QueryString["fechafinal"]);
            string dmyi        = Server.HtmlEncode(Request.QueryString["dmyi"]);
            string dmyf        = Server.HtmlEncode(Request.QueryString["dmyf"]);
            string tipo        = Server.HtmlEncode(Request.QueryString["tipo"]);
            string eq          = "";

            if (tipo == "1")
            {
                eq = "C.P.U";
            }
            if (tipo == "2")
            {
                eq = "MONITOR";
            }
            if (tipo == "3")
            {
                eq = "TECLADO";
            }
            if (tipo == "4")
            {
                eq = "MOUSE";
            }
            if (tipo == "5")
            {
                eq = "IMPRESORA";
            }
            if (tipo == "6")
            {
                eq = "REGULADOR";
            }
            if (tipo == "15")
            {
                eq = "SWITCHE";
            }
            DBConnect  conexion        = new DBConnect();
            DataTable  DTrptAllequipos = conexion.RPTAllequipos(tipo, fechainicio, fechafinal);
            DataTable  datos           = new DataTable();
            DataColumn columna1        = new DataColumn("Equipo");
            DataColumn columna2        = new DataColumn("Pendiente");
            DataColumn columna3        = new DataColumn("Revision");
            DataColumn columna4        = new DataColumn("Culminado");
            DataColumn columna5        = new DataColumn("Total");

            columna1.AllowDBNull = true;
            columna2.AllowDBNull = true;
            columna3.AllowDBNull = true;
            columna4.AllowDBNull = true;
            columna5.AllowDBNull = true;
            datos.Columns.Add(columna1);
            datos.Columns.Add(columna2);
            datos.Columns.Add(columna3);
            datos.Columns.Add(columna4);
            datos.Columns.Add(columna5);
            int dd = 0;

            if (DTrptAllequipos.Rows.Count > 0)
            {
                for (dd = 0; dd < DTrptAllequipos.Rows.Count; dd++)
                {
                    DataTable DTrptpendiente  = conexion.RPTequipos(DTrptAllequipos.Rows[dd]["nequipo"].ToString(), tipo, "0", fechainicio, fechafinal);
                    DataTable DTrptenrevision = conexion.RPTequipos(DTrptAllequipos.Rows[dd]["nequipo"].ToString(), tipo, "1", fechainicio, fechafinal);
                    DataTable DTrptculminado  = conexion.RPTequipos(DTrptAllequipos.Rows[dd]["nequipo"].ToString(), tipo, "2", fechainicio, fechafinal);
                    DataRow   dr = datos.NewRow();
                    dr["Equipo"]    = DTrptAllequipos.Rows[dd]["nequipo"].ToString();
                    dr["Pendiente"] = DTrptpendiente.Rows[0]["count"].ToString();
                    dr["Revision"]  = DTrptenrevision.Rows[0]["count"].ToString();
                    dr["Culminado"] = DTrptculminado.Rows[0]["count"].ToString();
                    dr["Total"]     = DTrptAllequipos.Rows[dd]["count"].ToString();
                    datos.Rows.Add(dr);
                }
            }
            int     rec = datos.Rows.Count;
            decimal d   = rec / 25;
            int     t   = Convert.ToInt16(decimal.Round(d, 1));
            int     n   = 0;

            Response.ContentType = "application/pdf";
            sharpPDF.pdfDocument myDoc = new sharpPDF.pdfDocument("Sample Application", "Me", false);
            myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/encabezado.gif"), "encabezado");
            myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/piedepagina.gif"), "pie");
            int k = 25;
            int i = 0;

            for (n = 0; n <= t; n++)
            {
                sharpPDF.pdfPage         myFirstPage = myDoc.addPage();
                sharpPDF.Tables.pdfTable myTable     = new sharpPDF.Tables.pdfTable(myDoc);
                myTable.borderSize  = 1;
                myTable.borderColor = new sharpPDF.pdfColor(0, 0, 0);
                myTable.coordX      = 20;
                myTable.coordY      = 650;
                myTable.tableHeader.addColumn(150);
                myTable.tableHeader.addColumn(80);
                myTable.tableHeader.addColumn(80);
                myTable.tableHeader.addColumn(80);
                myTable.tableHeader.addColumn(80);
                myFirstPage.addImage(myDoc.getImageReference("encabezado"), 50, 700);
                myFirstPage.addText("ACTIVIDADES REALIZADAS  DURANTE EL PERIODO" + dmyi + " AL " + dmyf, 20, 680, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12);
                sharpPDF.Tables.pdfTableRow myRow = myTable.createRow();
                myRow[0].addText("EQUIPOS (" + eq + ")", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.Black);
                myRow[1].addText("PENDIENTE", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.Black);
                myRow[2].addText("EN REVISION", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.Black);
                myRow[3].addText("CULMINADO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.Black);
                myRow[4].addText("TOTAL", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.Black);
                myTable.addRow(myRow);
                myRow = null;
                while (i < k)
                {
                    if (i < rec)
                    {
                        sharpPDF.Tables.pdfTableRow myRow2 = myTable.createRow();
                        myRow2[0].addText(datos.Rows[i]["Equipo"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 10, sharpPDF.pdfColor.Black);
                        myRow2[1].addText(datos.Rows[i]["Pendiente"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 10, sharpPDF.pdfColor.Black);
                        myRow2[2].addText(datos.Rows[i]["Revision"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 10, sharpPDF.pdfColor.Black);
                        myRow2[3].addText(datos.Rows[i]["Culminado"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 10, sharpPDF.pdfColor.Black);
                        myRow2[4].addText(datos.Rows[i]["Total"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 10, sharpPDF.pdfColor.Black);
                        myTable.addRow(myRow2);
                        myRow2 = null;
                        i++;
                    }
                    else
                    {
                        i++;
                    }
                }
                myFirstPage.addTable(myTable, 600);
                myTable     = null;
                myFirstPage = null;
                k           = k + 25;
            }
            myDoc.createPDF(Response.OutputStream);
            myDoc = null;
        }
Пример #4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            int    mmm  = 0;
            string menu = Server.HtmlEncode(Request.QueryString["menu"]);

            if (menu == "1")
            {
                mmm++;
            }
            else
            {
                Response.Redirect("../Default.aspx");
            }
            DBConnect conexion = new DBConnect();
            DataTable DTv9     = conexion.Sv9();
            int       rec      = DTv9.Rows.Count;
            decimal   d        = rec / 25;
            int       t        = Convert.ToInt16(decimal.Round(d, 1));
            int       n        = 0;

            Response.ContentType = "application/pdf";
            //System.Web.HttpContext.Current.Server.MapPath
            sharpPDF.pdfDocument myDoc = new sharpPDF.pdfDocument("Sample Application", "Me", false);
            myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/encabezado.gif"), "encabezado");
            myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/piedepagina.gif"), "pie");
            /*Table's creation*/
            int k = 25;
            int i = 0;

            for (n = 0; n <= t; n++)
            {
                sharpPDF.pdfPage myFirstPage = myDoc.addPage(748, 1024);
                //sharpPDF.pdfPage myFirstPage = myDoc.addPage(210, 297);
                sharpPDF.Tables.pdfTable myTable = new sharpPDF.Tables.pdfTable(myDoc);
                myTable.borderSize  = 1;
                myTable.borderColor = new sharpPDF.pdfColor(0, 0, 0);
                myTable.coordX      = 20;
                myTable.coordY      = 600;
                myTable.tableHeader.addColumn(150);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(60);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(60);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(60);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(60);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(40);
                myTable.tableHeader.addColumn(60);
                myFirstPage.addImage(myDoc.getImageReference("encabezado"), 20, 690);
                myFirstPage.addText("FALLAS DE SOFTWARE REPORTADAS Y SOLVENTADAS POR CADA DEPARTAMENTO", 80, 650, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 20);
                sharpPDF.Tables.pdfTableRow myRow = myTable.createRow();
                myRow[0].addText("DEPARTAMENTO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[1].addText("SA", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[2].addText("SAP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[3].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[4].addText("SS", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[5].addText("SSP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[6].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[7].addText("SO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[8].addText("SOP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[9].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[10].addText("AP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[11].addText("APP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[12].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[13].addText("WIN", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[14].addText("WINP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myRow[15].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                myTable.addRow(myRow);
                myRow = null;
                while (i < k)
                {
                    if (i < rec)
                    {
                        sharpPDF.Tables.pdfTableRow myRow2 = myTable.createRow();
                        myRow2[0].addText(DTv9.Rows[i]["departamento"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[1].addText(DTv9.Rows[i]["sarep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[2].addText(DTv9.Rows[i]["saresp"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[3].addText(DTv9.Rows[i]["sap"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[4].addText(DTv9.Rows[i]["ssrep"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[5].addText(DTv9.Rows[i]["ssresp"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[6].addText(DTv9.Rows[i]["ssp"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[7].addText(DTv9.Rows[i]["sorep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[8].addText(DTv9.Rows[i]["soresp"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[9].addText(DTv9.Rows[i]["sop"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[10].addText(DTv9.Rows[i]["apprep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[11].addText(DTv9.Rows[i]["appresp"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[12].addText(DTv9.Rows[i]["appp"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[13].addText(DTv9.Rows[i]["winrep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[14].addText(DTv9.Rows[i]["winresp"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[15].addText(DTv9.Rows[i]["winp"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myTable.addRow(myRow2);
                        myRow2 = null;
                        i++;
                    }
                    else
                    {
                        i++;
                    }
                }
                myFirstPage.addTable(myTable, 600);
                myFirstPage.drawRectangle(20, 55, 990, 20, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
                myFirstPage.addText("SA = Sistemas Administrativos", 30, 45, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("SAP = Fallas de Sistemas Administrativos Procesados", 30, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("SS = Sistemas de Salud", 230, 45, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("SSP = Fallas de Sistemas de Salud Procesados", 230, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("SO = Sistemas Operativos", 430, 45, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("SOP = Fallas de Sistemas Operativos Procesados", 430, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("AP = Aplicaciones", 630, 45, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("APP = Aplicaciones Procesadas", 630, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("WIN = Windows", 780, 45, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myFirstPage.addText("WINP = Fallas de Windows Procesadas", 780, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
                myTable     = null;
                myFirstPage = null;
                k           = k + 25;
            }
            myDoc.createPDF(Response.OutputStream);
            myDoc = null;
        }
Пример #5
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string    htipo     = Server.HtmlEncode(Request.QueryString["htipo"]);
            string    capacidad = Server.HtmlEncode(Request.QueryString["capacidad"]);
            string    modelo    = Server.HtmlEncode(Request.QueryString["modelo"]);
            DBConnect conexion  = new DBConnect();
            DataTable contar    = new DataTable();

            contar = conexion.SCountDisp(htipo, capacidad, modelo);
            int     rec = contar.Rows.Count;
            decimal d   = rec / 25;
            int     t   = Convert.ToInt16(decimal.Round(d, 1));
            int     n   = 0;

            Response.ContentType = "application/pdf";
            sharpPDF.pdfDocument myDoc = new sharpPDF.pdfDocument("Sample Application", "Me", false);
            myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/encabezado.gif"), "encabezado");
            myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/piedepagina.gif"), "pie");
            /*Table's creation*/
            int k = 25;
            int i = 0;

            for (n = 0; n <= t; n++)
            {
                sharpPDF.pdfPage myFirstPage = myDoc.addPage();
                //sharpPDF.pdfPage myFirstPage = myDoc.addPage(748, 1024);
                sharpPDF.Tables.pdfTable myTable = new sharpPDF.Tables.pdfTable(myDoc);
                myTable.borderSize  = 1;
                myTable.borderColor = new sharpPDF.pdfColor(0, 0, 0);
                myTable.coordX      = 50;
                myTable.coordY      = 600;
                myTable.tableHeader.addColumn(150);
                myTable.tableHeader.addColumn(160);
                myTable.tableHeader.addColumn(100);
                myFirstPage.addImage(myDoc.getImageReference("encabezado"), 20, 690);
                myFirstPage.addText("CANTIDAD DE DISPOSITIVOS EXISTENTES", 80, 650, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 20);
                sharpPDF.Tables.pdfTableRow myRow = myTable.createRow();
                if (htipo == "7")
                {
                    myRow[0].addText("DISCO DURO TIPO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[1].addText("CAPACIDAD", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[2].addText("TOTAL", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                }
                if (htipo == "8")
                {
                    myRow[0].addText("TARJETA TIPO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[1].addText("MODELO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[2].addText("TOTAL", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                }
                if (htipo == "9")
                {
                    myRow[0].addText("MEMORIA TIPO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[1].addText("CAPACIDAD", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[2].addText("TOTAL", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                }
                if (htipo == "10")
                {
                    myRow[0].addText("PROCESADOR TIPO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[1].addText("MODELO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[2].addText("TOTAL", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                }
                if (htipo == "11")
                {
                    myRow[0].addText("TARJETA TIPO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[1].addText("MODELO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[2].addText("TOTAL", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                }
                if (htipo == "12")
                {
                    myRow[0].addText("TARJETA TIPO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[1].addText("MODELO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[2].addText("TOTAL", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                }
                if (htipo == "14")
                {
                    myRow[0].addText("TARJETA TIPO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[1].addText("MODELO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[2].addText("TOTAL", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                }
                if (htipo == "16")
                {
                    myRow[0].addText("CDROM TIPO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[1].addText("MODELO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[2].addText("TOTAL", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                }
                myTable.addRow(myRow);
                myRow = null;
                while (i < k)
                {
                    if (i < rec)
                    {
                        sharpPDF.Tables.pdfTableRow myRow2 = myTable.createRow();
                        myRow2[0].addText(contar.Rows[i]["dispositivo"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[1].addText(contar.Rows[i]["capacidad"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myRow2[2].addText(contar.Rows[i]["total"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                        myTable.addRow(myRow2);
                        myRow2 = null;
                        i++;
                    }
                    else
                    {
                        i++;
                    }
                }
                myFirstPage.addTable(myTable, 600);
                myTable     = null;
                myFirstPage = null;
                k           = k + 25;
            }
            myDoc.createPDF(Response.OutputStream);
            myDoc = null;
        }
Пример #6
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string    fechainicio = Server.HtmlEncode(Request.QueryString["fechainicio"]);
            string    fechafinal  = Server.HtmlEncode(Request.QueryString["fechafinal"]);
            int       ts          = Convert.ToInt16(Server.HtmlEncode(Request.QueryString["htipo"]));
            DBConnect conexion    = new DBConnect();
            DataTable DTv10       = conexion.Sv10(fechainicio, fechafinal);
            int       rec         = DTv10.Rows.Count;
            decimal   d           = rec / 25;
            int       t           = Convert.ToInt16(decimal.Round(d, 1));
            int       n           = 0;

            Response.ContentType = "application/pdf";
            //System.Web.HttpContext.Current.Server.MapPath
            sharpPDF.pdfDocument myDoc = new sharpPDF.pdfDocument("Sample Application", "Me", false);
            myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/encabezado.gif"), "encabezado");
            myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/piedepagina.gif"), "pie");
            /*Table's creation*/
            if (ts == 1)
            {
                int k = 25;
                int i = 0;
                for (n = 0; n <= t; n++)
                {
                    sharpPDF.pdfPage myFirstPage = myDoc.addPage(748, 1024);
                    //sharpPDF.pdfPage myFirstPage = myDoc.addPage(210, 297);
                    sharpPDF.Tables.pdfTable myTable = new sharpPDF.Tables.pdfTable(myDoc);
                    myTable.borderSize  = 1;
                    myTable.borderColor = new sharpPDF.pdfColor(0, 0, 0);
                    myTable.coordX      = 50;
                    myTable.coordY      = 600;
                    myTable.tableHeader.addColumn(150);
                    myTable.tableHeader.addColumn(60);
                    myTable.tableHeader.addColumn(100);
                    myTable.tableHeader.addColumn(70);
                    myTable.tableHeader.addColumn(70);
                    myTable.tableHeader.addColumn(80);
                    myTable.tableHeader.addColumn(100);
                    myTable.tableHeader.addColumn(110);
                    myTable.tableHeader.addColumn(140);
                    myFirstPage.addImage(myDoc.getImageReference("encabezado"), 20, 690);
                    myFirstPage.addText("ACTIVIDADES REALIZADAS HARDWARE", 80, 650, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 20);
                    sharpPDF.Tables.pdfTableRow myRow = myTable.createRow();
                    myRow[0].addText("SOPORTE TÉCNICO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[1].addText("CPU", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[2].addText("IMPRESORA", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[3].addText("MONITOR", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[4].addText("TECLADO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[5].addText("MOUSE", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[6].addText("REGULADOR", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[7].addText("CONEXION DE RED", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[8].addText("CONEXION DE INTERNET", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myTable.addRow(myRow);
                    myRow = null;
                    while (i < k)
                    {
                        if (i < rec)
                        {
                            sharpPDF.Tables.pdfTableRow myRow2 = myTable.createRow();
                            myRow2[0].addText(DTv10.Rows[i]["soporte"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[1].addText(DTv10.Rows[i]["cpu"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[2].addText(DTv10.Rows[i]["impresora"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[3].addText(DTv10.Rows[i]["monitor"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[4].addText(DTv10.Rows[i]["teclado"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[5].addText(DTv10.Rows[i]["mouse"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[6].addText(DTv10.Rows[i]["regulador"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[7].addText(DTv10.Rows[i]["conexionr"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[8].addText(DTv10.Rows[i]["conexioni"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myTable.addRow(myRow2);
                            myRow2 = null;
                            i++;
                        }
                        else
                        {
                            i++;
                        }
                    }
                    myFirstPage.addTable(myTable, 600);
                    myTable     = null;
                    myFirstPage = null;
                    k           = k + 25;
                }
            }
            if (ts == 2)
            {
                int k = 25;
                int i = 0;
                for (n = 0; n <= t; n++)
                {
                    sharpPDF.pdfPage myFirstPage = myDoc.addPage(748, 1024);
                    //sharpPDF.pdfPage myFirstPage = myDoc.addPage(210, 297);
                    sharpPDF.Tables.pdfTable myTable = new sharpPDF.Tables.pdfTable(myDoc);
                    myTable.borderSize  = 1;
                    myTable.borderColor = new sharpPDF.pdfColor(0, 0, 0);
                    myTable.coordX      = 50;
                    myTable.coordY      = 600;
                    myTable.tableHeader.addColumn(150);
                    myTable.tableHeader.addColumn(160);
                    myTable.tableHeader.addColumn(145);
                    myTable.tableHeader.addColumn(145);
                    myTable.tableHeader.addColumn(115);
                    myTable.tableHeader.addColumn(80);
                    myTable.tableHeader.addColumn(60);
                    myTable.tableHeader.addColumn(60);
                    myFirstPage.addImage(myDoc.getImageReference("encabezado"), 20, 690);
                    myFirstPage.addText("ACTIVIDADES REALIZADAS SOFTWARE", 80, 650, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 20);
                    sharpPDF.Tables.pdfTableRow myRow = myTable.createRow();
                    myRow[0].addText("SOPORTE TÉCNICO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[1].addText("SISTEMAS ADMINISTRATIVOS", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[2].addText("SISTEMAS DE SALUD", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[3].addText("SISTEMA OPERATIVO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[4].addText("APLICACIONES", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[5].addText("WINDOWS", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[6].addText("OFFICE", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myRow[7].addText("OTROS", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
                    myTable.addRow(myRow);
                    myRow = null;
                    while (i < k)
                    {
                        if (i < rec)
                        {
                            sharpPDF.Tables.pdfTableRow myRow2 = myTable.createRow();
                            myRow2[0].addText(DTv10.Rows[i]["soporte"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[1].addText(DTv10.Rows[i]["sa"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[2].addText(DTv10.Rows[i]["ss"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[3].addText(DTv10.Rows[i]["so"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[4].addText(DTv10.Rows[i]["app"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[5].addText(DTv10.Rows[i]["win"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[6].addText(DTv10.Rows[i]["off"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myRow2[7].addText(DTv10.Rows[i]["otr"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
                            myTable.addRow(myRow2);
                            myRow2 = null;
                            i++;
                        }
                        else
                        {
                            i++;
                        }
                    }
                    myFirstPage.addTable(myTable, 600);
                    myTable     = null;
                    myFirstPage = null;
                    k           = k + 25;
                }
            }
            myDoc.createPDF(Response.OutputStream);
            myDoc = null;
        }