private void Exportar(string pfechad, string pfechah, string pProveedorID, string ptipo_mant)
{
String NombreXLS = "Reporte_Estadistico_TipoTrabajoxOficina_" + DateTime.Now.ToString();
brExportReportes br = new brExportReportes();
DataTable dt = br.ListarReporte_Estadistico_xTrabajoEntidad_Export(pfechad, pfechah, pProveedorID, ptipo_mant);
string attachment = "attachment; filename=" + NombreXLS + ".xls";
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
Response.ContentEncoding = Encoding.Default;
Response.AddHeader("Cache-Control", "max-age=0");
Response.Charset = "UTF-8";
string html = "<table border='1' style='color:#556DA6';>";
html = html + "<thead><tr>";
html = html + "<th style='background-color:#EBEBE9;'>PROVEEDOR</th>";
html = html + "<th style='background-color:#EBEBE9;'>TIPO_MANTENIMIENTO</th>";
html = html + "<th style='background-color:#EBEBE9;'>TRABAJOS x TIPO MANT</th>";
html = html + "<th style='background-color:#EBEBE9;'>TRABAJOS x ENTIDAD</th>";
html = html + "<th style='background-color:#EBEBE9;'>%(TIPO/ENTIDAD)</th>";
html = html + "</tr></thead><tbody>";
if (dt.Rows.Count == 0)
{
html = html + "<tr>";
html = html + "<td colspan='5'>No se encontraron registros</td></tr>";
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
html = html + "<tr>";
html = html + "<td>" + dt.Rows[i][0].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][1].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][2].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][3].ToString() + "</td>";
html = html + "<td style=\"mso-number-format:'Percent';\">" + dt.Rows[i][4].ToString() + "</td>";
html = html + "</tr>";
}
}
html = html + "</tbody></table>";
Response.Write(html);
Response.End();
}
private void Exportar(string pfechad, string pfechah, string pProveedorID, string pPersonalID)
{
String NombreXLS = "Reporte_Estadistico_HorasTrabxTecnico_" + DateTime.Now.ToString();
brExportReportes br = new brExportReportes();
DataTable dt = br.ListarReporte_Estadistico_HorasTrabxTecnico_Export(pfechad, pfechah, pProveedorID, pPersonalID);
string attachment = "attachment; filename=" + NombreXLS + ".xls";
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
Response.ContentEncoding = Encoding.Default;
Response.AddHeader("Cache-Control", "max-age=0");
Response.Charset = "UTF-8";
string html = "<table border='1' style='color:#556DA6';>";
html = html + "<thead><tr>";
html = html + "<th style='background-color:#EBEBE9;'>PROVEEDOR</th>";
html = html + "<th style='background-color:#EBEBE9;'>TÉCNICO</th>";
html = html + "<th style='background-color:#EBEBE9;'>HORA(s)</th>";
html = html + "<th style='background-color:#EBEBE9;'>MINUTO(s)</th>";
html = html + "<th style='background-color:#EBEBE9;'>PORCENTAJE %</th>";
html = html + "</tr></thead><tbody>";
if (dt.Rows.Count == 0)
{
html = html + "<tr>";
html = html + "<td colspan='5'>No se encontraron registros</td></tr>";
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
html = html + "<tr>";
html = html + "<td>" + dt.Rows[i][1].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][3].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][7].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][8].ToString() + "</td>";
html = html + "<td style=\"mso-number-format:'Percent';\">" + dt.Rows[i][6].ToString() + "</td>";
html = html + "</tr>";
}
}
html = html + "</tbody></table>";
Response.Write(html);
Response.End();
}
private void Exportar(string pfechad, string pfechah, string pPersonalID)
{
String NombreXLS = "Reporte_Estadistico_SalidasNoReportadas_" + DateTime.Now.ToString();
brExportReportes br = new brExportReportes();
DataTable dt = br.ListarReporte_Estadistico_SalidasNoReportadas_Export(pfechad, pfechah, pPersonalID);
string attachment = "attachment; filename=" + NombreXLS + ".xls";
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
Response.ContentEncoding = Encoding.Default;
Response.AddHeader("Cache-Control", "max-age=0");
Response.Charset = "UTF-8";
string html = "<table border='1' style='color:#556DA6';>";
html = html + "<thead><tr>";
html = html + "<th style='background-color:#EBEBE9;'>PROVEEDOR</th>";
html = html + "<th style='background-color:#EBEBE9;'>TÉCNICO</th>";
html = html + "<th style='background-color:#EBEBE9;'>TOTAL TRABAJOS x TÉCNICOS</th>";
html = html + "<th style='background-color:#EBEBE9;'>SALIDAS NO REPORTADAS X TÉCNICOS</th>";
html = html + "</tr></thead><tbody>";
if (dt.Rows.Count == 0)
{
html = html + "<tr>";
html = html + "<td colspan='4'>No se encontraron registros</td></tr>";
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
html = html + "<tr>";
html = html + "<td>" + dt.Rows[i][0].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][1].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][5].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][2].ToString() + "</td>";
html = html + "</tr>";
}
}
html = html + "</tbody></table>";
Response.Write(html);
Response.End();
}
private void Exportar(string pfechad, string pfechah, string pCSID)
{
String NombreXLS = "Reporte_FichaPorOficina_" + DateTime.Now.ToString();
brExportReportes br = new brExportReportes();
DataTable dt = br.ListarReporte_xOficinaEntidad_Export(pfechad, pfechah, pCSID);
string attachment = "attachment; filename=" + NombreXLS + ".xls";
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
Response.ContentEncoding = Encoding.Default;
Response.AddHeader("Cache-Control", "max-age=0");
Response.Charset = "UTF-8";
string html = "<table border='1' style='color:#556DA6';>";
html = html + "<thead><tr>";
html = html + "<th style='background-color:#EBEBE9;'>FECHA</th>";
html = html + "<th style='background-color:#EBEBE9;'>TIPO_MANTENIMIENTO</th>";
html = html + "<th style='background-color:#EBEBE9;'>DISTRIBUIDOR</th>";
html = html + "<th style='background-color:#EBEBE9;'>ABONADO</th>";
html = html + "<th style='background-color:#EBEBE9;'>OFICINA</th>";
html = html + "<th style='background-color:#EBEBE9;'>PROVEEDOR</th>";
html = html + "<th style='background-color:#EBEBE9;'>TÉCNICO</th>";
html = html + "<th style='background-color:#EBEBE9;'>USUARIO</th>";
html = html + "<th style='background-color:#EBEBE9;'>OBSERVACIONES</th>";
html = html + "</tr></thead><tbody>";
if (dt.Rows.Count == 0)
{
html = html + "<tr>";
html = html + "<td colspan='9'>No se encontraron registros</td></tr>";
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
html = html + "<tr>";
html = html + "<td style=\"mso-number-format:mm/dd/yyyy hh:mm:ss;\">" + dt.Rows[i][0].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][11].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][3].ToString() + "</td>";
html = html + "<td style=\"mso-number-format:'@';\">" + dt.Rows[i][4].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][5].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][7].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][9].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][10].ToString() + "</td>";
html = html + "<td>" + dt.Rows[i][12].ToString() + "</td>";
html = html + "</tr>";
}
}
html = html + "</tbody></table>";
Response.Write(html);
Response.End();
}
