private string TextoEnvioAlertaPlanilla()
{
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 continuacion son los que deben ser corroborado en ERP SPRING, en el SUELDO DEL TRABAJADOR.")
+ "</div><br>" + "<div style='font-size:11px; font-family:Arial;background-color:#E8EAEE; padding:20px'>") + "<table width='610' cellpadding='7'>"
+ "<tr><td colspan='2'>") + "<hr /> </td></tr>" + "<tr><td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>CODIGO</td>")
+ "<td width='230' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>NOMBRE</td>"
+ "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>MONTO ACTUAL</td>")
+ "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>MONTO ANTERIOR</td>"
+ "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>USUARIO</td>")
+ "<td width='80' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>MAQUINA</td>"
+ "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>FECHA</td>")
+ "<td width='80' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>PUESTO</td>"
+ "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>CENTROCOSTO</td>")
+ "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>GERENCIA</td>"
+ "<td width='80' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>AREA</td></tr>";
try
{
enumerator = ((IEnumerable)BL_ObjControl_Auditoria_Planilla_P.PoblarAuditoria_Planilla_PSelAll()).GetEnumerator();
while (enumerator.MoveNext())
{
BE_Auditoria_Planilla_P current = (BE_Auditoria_Planilla_P)enumerator.Current;
str = str + "<tr><td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.Codigo + "</td>";
str = str + "<td width='230' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'> " + current.Nombre + "</td>";
str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'> " + current.MontoLocal + "</td>";
str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'> " + current.MontoLocalA + "</td>";
str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.CodUser + "</td>";
str = str + "<td width='80' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.IP + "</td>";
str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.Fecha + "</td>";
str = str + "<td width='80' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.Cargo + "</td>";
str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.CentroC + "</td>";
str = str + "<td width='80' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.Gerencia + "</td>";
str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.Area + "</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>");
}
public override BE_Auditoria_Planilla_Ps Obtener_Auditoria_Planilla_PSelAll()
{
BE_Auditoria_Planilla_Ps ps2 = new BE_Auditoria_Planilla_Ps();
DbCommand storedProcCommand = this.BaseInterface.GetStoredProcCommand("dbo.Auditoria_Monto_Sueldo");
using (SqlDataReader reader = (SqlDataReader)this.BaseInterface.ExecuteReader(storedProcCommand))
{
while (reader.Read())
{
BE_Auditoria_Planilla_P item = new BE_Auditoria_Planilla_P(Convert.ToString(reader["IDITEM"]), Convert.ToString(reader["CODUSER"]),
Convert.ToString(reader["CODIGO"]), Convert.ToString(reader["NOMBRE"]), Convert.ToString(reader["MONTOLOCAL"]),
Convert.ToString(reader["MONTOLOCALA"]), Convert.ToString(reader["IP"]), Convert.ToString(reader["FECHA"]),
Convert.ToString(reader["PUESTO"]), Convert.ToString(reader["CENTROCOSTOS"]), Convert.ToString(reader["AREA"]), Convert.ToString(reader["GERENCIA"]));
ps2.Add(item);
}
}
return(ps2);
}
private void Actualizar_Dato_Planilla()
{
IEnumerator enumerator;
try
{
enumerator = ((IEnumerable)BL_ObjControl_Auditoria_Planilla_P.PoblarAuditoria_Planilla_PSelAll()).GetEnumerator();
while (enumerator.MoveNext())
{
BE_Auditoria_Planilla_P current = (BE_Auditoria_Planilla_P)enumerator.Current;
BL_ObjControl_Auditoria_Planilla_P.ActualizarAuditoria_Planilla_PSelAll(current.IdItem);
}
}
finally
{
//if (enumerator is IDisposable)
//{
// (enumerator as IDisposable).Dispose();
//}
}
}