public override BE_Resultado_Operativo_Ds ObtenerResultado_Operativo_DSelAll(string codproyecto, string codpresupuesto) { BE_Resultado_Operativo_Ds facturars = new BE_Resultado_Operativo_Ds(); DbCommand storedProcCommand = this.BaseInterface.GetStoredProcCommand("dbo.S10_Resultado_OperativoD"); this.BaseInterface.AddInParameter(storedProcCommand, "@CODPROYECTO", DbType.String, codproyecto); this.BaseInterface.AddInParameter(storedProcCommand, "@CODPRESUPUESTO", DbType.String, codpresupuesto); using (SqlDataReader reader = (System.Data.SqlClient.SqlDataReader) this.BaseInterface.ExecuteReader(storedProcCommand)) { while (reader.Read()) { BE_Resultado_Operativo_D item = new BE_Resultado_Operativo_D(Convert.ToString(reader["GRUPO"]), Convert.ToString(reader["RECURSO"]), Convert.ToString(reader["PRESUPUESTO"]), Convert.ToString(reader["PROGRAMADO"]), Convert.ToString(reader["VALORIZADO"]), Convert.ToString(reader["REALL"])); 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: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 S10.") + "</div><br><hr />" + "<div style='font-size:11px; font-family:Arial;padding:20px'>"; try { enumerator = ((IEnumerable)BL_ObjControl_Resultado_Operativo_C.PoblarResultado_Operativo_CSelAll()).GetEnumerator(); while (enumerator.MoveNext()) { IEnumerator enumerator2; BE_Resultado_Operativo_C current = (BE_Resultado_Operativo_C)enumerator.Current; str = str + "<table cellspacing='0' cellpadding='0' width='605px'><tr><td colspan='3' width='350'></td><td style='font-size:10px; font-family:Arial;text-align:center;border:1px solid black;background-color:#C5E3ED' width='85'><strong>PRESUPUESTO</strong></td>" + "<td width='85' style='font-size:10px; font-family:Arial;text-align:center;border:1px solid black;background-color:#C5E3ED'><strong>PROGRAMADO</strong></td>" + "<td width='85' style='font-size:10px; font-family:Arial;text-align:center;border:1px solid black;background-color:#C5E3ED'><strong>VALORIZADO</strong></td>" + "<td width='85' style='font-size:10px; font-family:Arial;text-align:center;border:1px solid black;background-color:#C5E3ED'><strong>REAL</strong></td></tr>"; str = str + "<tr><td style='font-size:10px; font-family:Arial;text-align:left;font-weight: bold;border:1px solid black;background-color:#C5D5E9' colspan='3' width='350'>Proyecto:" + current.Des_Proyecto + "</td>"; str = str + "<td align='right' valign='top' style='font-size:10px; font-family:Arial;text-align:center;border:1px solid black;background-color:#FFA6A6'> " + current.Presupuesto + "</td>"; str = str + "<td align='right' valign='top' style='font-size:10px; font-family:Arial;text-align:center;border:1px solid black;background-color:#FFA6A6'> " + current.Programado + "</td>"; str = str + "<td align='right' valign='top' style='font-size:10px; font-family:Arial;text-align:center;border:1px solid black;background-color:#FFA6A6'> " + current.Valorizado + "</td>"; str = str + "<td align='right' valign='top' style='font-size:10px; font-family:Arial;text-align:center;border:1px solid black;background-color:#FFA6A6'> " + current.Reall + "</td>"; str = str + "</tr><tr><td style='font-size:10px; font-family:Arial;text-align:left;font-weight: bold;border:1px solid black;background-color:#C5D5E9' colspan='3' width='350'>Presupuestos:" + current.TipoPresupuesto + " - " + current.Des_Presupuesto + "</td>"; str = str + "<td colspan='4' rowspan='2' style='border:1px solid black'> </td> </tr><tr><td colspan='3' width='350' style='font-size:10px; font-family:Arial;text-align:left;font-weight: bold;border:1px solid black;background-color:#C5D5E9'>Detalle:</td></tr>"; try { enumerator2 = ((IEnumerable)BL_ObjControl_Resultado_Operativo_D.PoblarResultado_Operativo_DSelAll(current.CodProyecto, current.CodPresupuesto)).GetEnumerator(); while (enumerator2.MoveNext()) { BE_Resultado_Operativo_D rod = (BE_Resultado_Operativo_D)enumerator2.Current; str = str + "<tr>"; str = str + "<td colspan='3' width='350' align='right' valign='top' style='font-size:10px; font-family:Arial;text-align:right;border:1px solid black'> " + rod.Recurso + "</td>"; str = str + "<td align='right' valign='top' style='font-size:10px; font-family:Arial;text-align:center;border:1px solid black' width='85'> " + rod.Presupuesto + "</td>"; str = str + "<td align='right' valign='top' style='font-size:10px; font-family:Arial;text-align:center;border:1px solid black' width='85'> " + rod.Programado + "</td>"; str = str + "<td align='right' valign='top' style='font-size:10px; font-family:Arial;text-align:center;border:1px solid black' width='85'> " + rod.Valorizado + "</td>"; str = str + "<td align='right' valign='top' style='font-size:10px; font-family:Arial;text-align:center;border:1px solid black' width='85'> " + rod.Reall + "</td></tr>"; } } finally { //if (enumerator2 is IDisposable) //{ // (enumerator2 as IDisposable).Dispose(); //} } str = str + "</table><br />"; } } 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>"); }