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); }