public string ValidarExistaData()
{
string result = "";
DateTime ldt_Fecha;
if (chkEnvioAutAct.Checked == true)
{
ldt_Fecha = Convert.ToDateTime(txtFechaAut.Text);
}
else
{
ldt_Fecha = Convert.ToDateTime(dtFechaManual.Text);
}
CDReporteData rpt = new CDReporteData();
DataTable dtHtml = rpt.DataRepCumple(cboCompania.SelectedValue.ToString(), ldt_Fecha, Constanst.UsuarioSist);
if (dtHtml.Rows.Count == 1 && dtHtml.Columns.Count == 1)
{
result = "NO";
}
else if (dtHtml.Rows.Count > 1 && dtHtml.Columns.Count > 1)
{
result = "OK";
}
return(result);
}
public string BoDyForHtmlMail()
{
string result = "", sHeaderFields = "", sbody = "";
DateTime ldt_Fecha;
if (chkEnvioAutAct.Checked == true)
{
ldt_Fecha = Convert.ToDateTime(txtFechaAut.Text);
}
else
{
ldt_Fecha = Convert.ToDateTime(dtFechaManual.Text);
}
CDReporteData rpt = new CDReporteData();
DataTable dtHtml = rpt.DataRepCumple(cboCompania.SelectedValue.ToString(), ldt_Fecha, Constanst.UsuarioSist);
if (dtHtml == null || dtHtml.Rows.Count <= 0)
{
}
if (dtHtml.Rows.Count > 1 && dtHtml.Columns.Count > 1)
{
string sFlag = "", sNombreCompleto, sArea, sFechaText;
sHeaderFields = "<br />" +
"<div>" +
"<table style= 'width:100%;border-collapse: collapse;' >" +
"<tr >" +
"<th style='color:white;background-color:#e30019;font-family:Calibri;width:100px; font-size:15px;font-style:italic' > DÍA </th>" +
"<th style='color:white;background-color:#e30019;font-family:Calibri;width:300px;font-size:15px;font-style:italic'> NOMBRE COMPLETO </th>" +
" <th style='color:white;background-color:#e30019;font-family:Calibri;width:300px;font-size:15px;font-style:italic'> ÁREA </th>" +
" </tr>";
for (int i = 0; i < dtHtml.Rows.Count; i++)
{
sFlag = dtHtml.Rows[i]["c_flag"].ToString().Substring(8, 1);
sNombreCompleto = dtHtml.Rows[i]["c_empleado"].ToString();
sArea = dtHtml.Rows[i]["c_area"].ToString();
sFechaText = dtHtml.Rows[i]["c_dia"].ToString();
if (sFlag == "A")
{
sbody = sbody + "<tr>" +
"<td colspan='3' style ='color:#e30019;font-size:20px;font-family:Calibri;font-weight:bold;padding-top:5px;padding-bottom:5px' >" + sFechaText + "</td>" +
"</tr>";
}
else if (sFlag == "B")
{
sbody = sbody + "<tr>" +
"<td> </td>" +
"<td style = 'font-weight:bold;font-family:Calibri;color:#6D6D6D' >" + sNombreCompleto + "</td>" +
"<td style = 'font-weight:bold;font-family:Calibri;color:#6D6D6D' >" + sArea + "</td>" +
"</tr>";
}
}
/* sPieImg = "<tr>" +
* "<td> </td>" +
* "<td style='text-align:right' > <img src='cid:pie.jpg' /> </td>" +
* "<td> </td>"+
* "</tr>";*/
}
result = sHeaderFields + sbody + "</table></div>";
result = result +
"<div style = 'width:100%;background-color:#e30019;color:#e30019; height:30px;margin-top:20px;' >....</div>";
if (dtHtml.Rows.Count == 1 && dtHtml.Columns.Count == 1)
{
result = "NODATA";
}
return(result);
}
