public override BE_ETE_ETEP_SeguimientoTransferenciaGGs ObtenerETE_ETEP_SeguimientoTransferenciaGGSelAll()
{
BE_ETE_ETEP_SeguimientoTransferenciaGGs facturars = new BE_ETE_ETEP_SeguimientoTransferenciaGGs();
DbCommand storedProcCommand = this.BaseInterface.GetStoredProcCommand("dbo.S10_Almacenes_001_004_ETE_ETEP_SeguimientoTransferenciaGG");
using (SqlDataReader reader = (SqlDataReader)this.BaseInterface.ExecuteReader(storedProcCommand))
{
while (reader.Read())
{
BE_ETE_ETEP_SeguimientoTransferenciaGG item = new BE_ETE_ETEP_SeguimientoTransferenciaGG(Convert.ToString(reader["DESCRIPCION"]), Convert.ToString(reader["ESTADO_PROYECTO"]), Convert.ToString(reader["TOTAL_PENDIENTE"]),
Convert.ToString(reader["PROYECTO_DESTINO"]));
facturars.Add(item);
}
}
return(facturars);
}
private string ContenidoAlertaTransf()
{
IEnumerator enumerator;
string str = "<html>";
str = (((((str + "<body><center> " + "<div style='font-size:11px; font-family:Arial; text-align:left; padding:10px; width:800px;'>") +
"<br><div style='padding-left:30px; padding-right:30px; text-align:justify'><strong>Estimado(a) usuario(a):</strong>" +
"<br>El listado presentado a continuacion son los que deben ser corroborado en ERP S10.") + "</div><br>" +
"<div style='font-size:11px; font-family:Arial;background-color:#E8EAEE; padding:20px'>") + "<table width='2200' cellpadding='2'>" +
"<tr><td width='880' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>PROYECTO_ORIGEN</td>") +
"<td width='80' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>VALORIZADO (S/.)</td>" +
"<td width='80' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>ESTADO_PROYECTO</td>") +
"<td width='880' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>PROYECTO_DESTINO</td></tr>";
try
{
enumerator = ((IEnumerable)BL_ObjControl_ETE_ETEP_SeguimientoTransferenciaGG.PoblarETE_ETEP_SeguimientoTransferenciaGGSelAll()).GetEnumerator();
while (enumerator.MoveNext())
{
BE_ETE_ETEP_SeguimientoTransferenciaGG current = (BE_ETE_ETEP_SeguimientoTransferenciaGG)enumerator.Current;
str = str + "<tr><td width='880' valign='top' style='font-size:8px; font-family:Arial;text-align:left;color:#000000'>" + current.Descripcion + "</td>";
str = str + "<td width='80' valign='top' style='font-size:8px; font-family:Arial;text-align:center;color:red'> " + current.TotalPendiente + "</td>";
str = str + "<td width='80' valign='top' style='font-size:8px; font-family:Arial;text-align:center;color:red'> " + current.EstadoProyecto + "</td>";
str = str + "<td width='880' valign='top' style='font-size:8px; font-family:Arial;text-align:left;color:#000000'>" + current.ProyectoDestino + "</td></tr>";
}
}
finally
{
//if (enumerator is IDisposable)
//{
// (enumerator as IDisposable).Dispose();
//}
}
str = (((((((((((((((str + "</table>") + "</div>" + "<hr /> </td></tr>") + "<table width='2200' cellpadding='2'>" +
"<tr><td colspan='7'>") + "</td></tr>" + "<tr><td colspan='7'>") + "</div><br>" +
"<div style='font-size:11px; font-family:Arial;background-color:#E8EAEE; padding:20px'>") +
"<tr><td width='100' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-bottom-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>Proyecto</td>" +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>Almacen</td>") +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>CodGuia</td>" +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>FechaGuia</td>") +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>SerieDocumento</td>" +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>NroDocumento</td>") +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>MovimientoOrigen</td>" +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>EstadoCierre</td>") +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>CodigoRecurso</td>" +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>Recurso</td>") +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>Simbolo</td>" +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>Parcial</td>") +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>CodPedido</td>" +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>ProyectoDestino</td>") +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#DF0101;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>CodGuiaRelacion</td>" +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>CreacionUsuario</td>") +
"<td width='100' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>CreacionFecha</td>" +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>ActualizacionUsuario</td>") +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>ActualizacionFecha</td>" +
"<td width='50' valign='top' style='text-align:center;background-color:#ECF9FF;font-size:8px; font-family:Arial;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'>Año</td></tr>");
try
{
enumerator = ((IEnumerable)BL_ObjControl_ETE_ETEP_SeguimientoTransferencia.PoblarETE_ETEP_SeguimientoTransferenciaSelAll()).GetEnumerator();
while (enumerator.MoveNext())
{
BE_ETE_ETEP_SeguimientoTransferencia current = (BE_ETE_ETEP_SeguimientoTransferencia)enumerator.Current;
str = str + "<tr><td width='100' valign='top' style='font-size:8px; font-family:Arial;text-align:left;border-color:#999;border-left-style: dashed;border-left-width:1px;border-bottom-style: dashed;border-bottom-width:1px'> " + current.Proyecto + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'> " + current.Almacen + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'> " + current.CodGuia + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'>" + current.FechaGuia + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'>" + current.SerieDocumento + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'>" + current.NroDocumento + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'> " + current.MovimientoOrigen + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'> " + current.EstadoCierre + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'> " + current.CodRecurso + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'> " + current.Recurso + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'> " + current.Simbolo + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'> " + current.Parcial + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'>" + current.CodPedido + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'>" + current.ProyectoDestino + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'>" + current.CodGuiaRelacion + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'>" + current.CreacionUsuario + "</td>";
str = str + "<td width='100' valign='top' style='font-size:8px; font-family:Arial;text-align:left;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'>" + current.CreacionFecha + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'>" + current.ActualizacionUsuario + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'>" + current.ActualizacionFecha + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;border-color:#999;border-bottom-style: dashed;border-bottom-width:1px'>" + current.Ano + "</td></tr>";
}
}
finally
{
//if (enumerator2 is IDisposable)
//{
// (enumerator2 as IDisposable).Dispose();
//}
}
return(((str + "</table>" + "</div>") + "<hr /><div style='font-size:10px; padding-left:30px; padding-right:30px'>" +
"<strong><em>Nexos Comerciales S.A.C</em></strong><br><br>") +
"<strong>P.D:</strong> Este correo es solo para confirmar el estado de recepcion. Agradeceremos no responderlo.</div> </div>" +
"</center></body></html>");
}
