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;
}
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;
}
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;
}
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;
}
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;
}
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;
}