public override BE_Pedido_Sin_Atenders ObtenerPedido_Sin_AtenderSelAll()
{
BE_Pedido_Sin_Atenders facturars = new BE_Pedido_Sin_Atenders();
DbCommand storedProcCommand = this.BaseInterface.GetStoredProcCommand("dbo.S10_Pedidos_Sin_Atender");
using (SqlDataReader reader = (SqlDataReader)this.BaseInterface.ExecuteReader(storedProcCommand))
{
while (reader.Read())
{
BE_Pedido_Sin_Atender item = new BE_Pedido_Sin_Atender(Convert.ToString(reader["PROYECTO"]), Convert.ToString(reader["ALMACEN"]), Convert.ToString(reader["NROPEDIDO"]),
Convert.ToString(reader["ESTADO"]), Convert.ToString(reader["FECHAPEDIDO"]), Convert.ToString(reader["CREACIONFECHA"]), Convert.ToString(reader["ACTUALIZACIONFECHA"]),
Convert.ToString(reader["FECHAAPROBACION"]), Convert.ToString(reader["TIEMPOENTREGA"]), Convert.ToString(reader["CREACIONUSUARIO"]), Convert.ToString(reader["USUARIOA"]),
Convert.ToString(reader["USUARIO"]), Convert.ToString(reader["CODPEDIDOINTERNO"]), Convert.ToString(reader["ORDENDEPRODUCCION"]), Convert.ToString(reader["DESESTADOCOTIZACION"]),
Convert.ToString(reader["DESESTADOORDENCOMPRA"]), Convert.ToString(reader["DESESTADOALMACEN"]), Convert.ToString(reader["CENTROCOMPRA"]),
Convert.ToString(reader["OBSERVACION"]));
facturars.Add(item);
}
}
return(facturars);
}
private string TextoEnvioAlertaPedidoSinAprobar()
{
IEnumerator enumerator;
string str = "<html>";
str = (((((((((((((str + "<body><center> " + "<div style='font-size:11px; font-family:Arial; text-align:left; padding:10px; width:850px;'>") +
"<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='1300' cellpadding='3'>" +
"<tr><td colspan='2'>") + "<hr /> </td></tr>" +
"<tr><td width='400' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>PROYECTO</td>") +
"<td width='30' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>ALMACEN</td>" +
"<td width='90' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>NROPEDIDO</td>") +
"<td width='50' valign='top' style='text-align:center;background-color:#FF5733;font-size:8px; font-family:Arial'>ESTADO</td>" +
"<td width='40' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>FECHA_PEDIDO</td>") +
"<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>FECHA_CREACION</td>" +
"<td width='180' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>FECHA_ACTUALIZACION</td>") +
"<td width='40' valign='top' style='text-align:center;background-color:#DDDDDD; font-size:8px; font-family:Arial'>FECHA_APROBACION</td>" +
"<td width='40' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>TIEMPO_ENTREGA</td>") +
"<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>USUARIO_CREADOR</td>" +
"<td width='180' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>USUARIO_APROBADOR</td>") +
"<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>USUARIO_ACTUALIZADOR</td>" +
"<td width='180' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>NROPEDIDO_INTERNO</td>") +
"<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>ORDEN_PRODUCCION</td>" +
"<td width='180' valign='top' style='text-align:center;background-color:#FF5733;font-size:8px; font-family:Arial'>ESTADO_COTIZACION</td>") +
"<td width='70' valign='top' style='text-align:center;background-color:#FF5733;font-size:8px; font-family:Arial'>ESTADO_ORDEN_COMPRA</td>" +
"<td width='180' valign='top' style='text-align:center;background-color:#FF5733;font-size:8px; font-family:Arial'>ESTADO_ALMACEN</td>") +
"<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>CENTRO_COMPRA</td>" +
"<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>OBSERVACION</td></tr>";
try
{
enumerator = ((IEnumerable)BL_ObjCOntrol_Pedido_Sin_Atender.PoblarPedido_Sin_AtenderSelAll()).GetEnumerator();
while (enumerator.MoveNext())
{
BE_Pedido_Sin_Atender current = (BE_Pedido_Sin_Atender)enumerator.Current;
str = str + "<tr><td width='400' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'>" + current.Proyecto + "</td>";
str = str + "<td width='30' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Almacen + "</td>";
str = str + "<td width='90' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.NroPedido + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;color:red'> " + current.Estado + "</td>";
str = str + "<td width='40' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'>" + current.FechaPedido + "</td>";
str = str + "<td width='70' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.CreacionFecha + "</td>";
str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.ActualizacionFecha + "</td>";
str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.FechaAprobacion + "</td>";
str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.TiempoEntrega + "</td>";
str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.CreacionUsuario + " </td>";
str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.UsuarioA + " </td>";
str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Usuario + " </td>";
str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.CodPedidoInterno + " </td>";
str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.OrdenProduccion + " </td>";
str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;color:red'> " + current.DesEstadoCotizacion + " </td>";
str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;color:red'> " + current.DesEstadoOrdenCompra + " </td>";
str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;color:red'> " + current.DesEstadoAlmacen + " </td>";
str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.CentroCompra + " </td>";
str = str + "<td width='180' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Observacion + " </td></tr>";
}
}
finally
{
// if (enumerator is IDisposable)
// {
// (enumerator as IDisposable).Dispose();
// }
}
return(((str + "</table>" + "</div>") + "<hr /><div style='font-size:10px; padding-left:30px; padding-right:30px'>" +
"<strong><em>QLABSP Investors</em></strong><br><br>") +
//"<strong><em>Nexos Comerciales S.A</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>");
}