private string TextoKceroNegativo()
{
IEnumerator enumerator;
string str = "<html>";
str = (((((((((((str + "<body><center> " + "<div style='font-size:11px; font-family:Arial; text-align:left; padding:10px; width:650px;'>") +
"<br><div style='padding-left:30px; padding-right:30px; text-align:justify'><strong>Estimado(a) usuario(a):</strong>" +
"<br>El listado presentado a continuaci\x00f3n es el Kardex con cantidades (Stock actual) negativas y los Precios en ceros y negativos.") +
"</div><br>" + "<div style='font-size:11px; font-family:Arial;background-color:#E8EAEE; padding:20px'>") +
"<table width='1210' cellpadding='3'>" + "<tr><td colspan='2'>") +
"<hr /> </td></tr>" + "<tr><td width='120' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>PROYECTO</td>") +
"<td width='120' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>ALMACEN</td>" +
"<td width='50' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>CODRECURSO</td>") +
"<td width='370' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>RECURSO</td>" +
"<td width='30' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>UNIDAD</td>") +
"<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>FECHAGUIA</td>" +
"<td width='30' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>NROGUIA</td>") +
"<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>MOVIMIENTO</td>" +
"<td width='30' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>MONEDA</td>") +
"<td width='40' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>CANTIDAD</td>" +
"<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>PRECIO</td>") +
"<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>STOCK_ANTERIOR</td>" +
"<td width='40' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>STOCK_ACTUAL</td>") +
"<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>PROYECTO_TRANSFERENCIA</td>" +
"<td width='70' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:8px; font-family:Arial'>ALMACEN_TRANSFERENCIA</td></tr>";
try
{
enumerator = ((IEnumerable)BL_ObjControl_Kardex_Ceros_Negativo.PoblarKardex_Ceros_NegativoSelAll()).GetEnumerator();
while (enumerator.MoveNext())
{
BE_Kardex_Ceros_Negativo current = (BE_Kardex_Ceros_Negativo)enumerator.Current;
str = str + "<tr><td width='120' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'>" + current.Proyecto + "</td>";
str = str + "<td width='120' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Almacen + "</td>";
str = str + "<td width='50' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.CodRecurso + "</td>";
str = str + "<td width='370' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Recurso + "</td>";
str = str + "<td width='30' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Unidad + "</td>";
str = str + "<td width='60' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.FechaGuia + "</td>";
str = str + "<td width='30' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'>" + current.NroGuia + "</td>";
str = str + "<td width='60' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Movimiento + "</td>";
str = str + "<td width='30' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Moneda + "</td>";
str = str + "<td width='40' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'>" + current.Cantidad + "</td>";
str = str + "<td width='60' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.Precio + "</td>";
str = str + "<td width='60' valign='top' style='font-size:8px; font-family:Arial;text-align:center;color:red'> " + current.StockActual + "</td>";
str = str + "<td width='40' valign='top' style='font-size:8px; font-family:Arial;text-align:center;color:red'>" + current.StockAnterior + "</td>";
str = str + "<td width='70' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'> " + current.ProyectoTransferencia + "</td>";
str = str + "<td width='70' valign='top' style='font-size:8px; font-family:Arial;text-align:center;'>" + current.AlmacenTransferencia + "</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>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>");
}
public override BE_Kardex_Ceros_Negativos ObtenerKardex_Ceros_NegativoSelAll()
{
BE_Kardex_Ceros_Negativos facturars = new BE_Kardex_Ceros_Negativos();
DbCommand storedProcCommand = this.BaseInterface.GetStoredProcCommand("dbo.Kardex_Cantidades_Cero_Negativos");
using (SqlDataReader reader = (SqlDataReader)this.BaseInterface.ExecuteReader(storedProcCommand))
{
while (reader.Read())
{
BE_Kardex_Ceros_Negativo item = new BE_Kardex_Ceros_Negativo(Convert.ToString(reader["PROYECTO"]), Convert.ToString(reader["ALMACEN"]), Convert.ToString(reader["CODRECURSO"]),
Convert.ToString(reader["RECURSO"]), Convert.ToString(reader["UNIDAD"]), Convert.ToString(reader["FECHAGUIA"]), Convert.ToString(reader["NROGUIA"]),
Convert.ToString(reader["MOVIMIENTO"]), Convert.ToString(reader["MONEDA"]), Convert.ToString(reader["CANTIDAD"]), Convert.ToString(reader["PRECIO"]),
Convert.ToString(reader["STOCKANTERIOR"]), Convert.ToString(reader["STOCKACTUAL"]), Convert.ToString(reader["PROYECTOTRANS"]), Convert.ToString(reader["ALMACENTRANS"]));
facturars.Add(item);
}
}
return(facturars);
}
