private string ObtenerCalendarios(string sTipo, string sNodo, string sIdFicepi) { try { StringBuilder sb = new StringBuilder(); SqlDataReader dr = null; int? idFicepi = null; if (sIdFicepi != "") { idFicepi = int.Parse(sIdFicepi); } sb.Append("<table id='tblDatos' class='texto MA' style='WIDTH: 400px;'>"); sb.Append("<colgroup><col style='width:400px;' /></colgroup>"); sb.Append("<tbody>"); if (sTipo == "E" || sTipo == "T") { dr = Calendario.Catalogo(null, "", true, sTipo, null, "", null, 2, 0); } else { if (sNodo == "") { sNodo = "-1"; } dr = Calendario.Asignacion(int.Parse(sNodo), idFicepi); } while (dr.Read()) { sb.Append("<tr id='" + dr["t066_idcal"].ToString() + "' njl='" + dr["Njorlabcal"].ToString() + "' onclick='ms(this)' ondblclick='aceptarClick(this.rowIndex)' onmouseover=TTip(event);>"); sb.Append("<td><div style='width:380px;' class='NBR'>" + dr["t066_descal"].ToString() + "</div></td></tr>"); } dr.Close(); dr.Dispose(); sb.Append("</tbody>"); sb.Append("</table>"); return("OK@#@" + sb.ToString()); } catch (Exception ex) { return("Error@#@" + Errores.mostrarError("Error al obtener los Calendarios", ex)); } }
private void ObtenerCalendarios() { StringBuilder sb = new StringBuilder(); sb.Append("<table id='tblDatos' class='texto MA' style='WIDTH: 754px;'>"); sb.Append("<colgroup><col style='width:325px;' /><col style='width:300px' /><col style='width:75px' /><col style='width:54px;' /></colgroup>"); sb.Append("<tbody>"); //short? nCR = null; SqlDataReader dr = Calendario.Catalogo(null, "", true, null, null, "", null, 2, 0); /*SqlDataReader dr; * if (SUPER.Capa_Negocio.Utilidades.EsAdminProduccion()) * dr = Calendario.Catalogo(null, "", true, null, null, "", null, 2, 0); * else * dr = Calendario.CatalogoUsu((int)Session["UsuarioActual"], null, "", true, null, "", 2, 0); */ while (dr.Read()) { sb.Append("<tr id='" + dr["t066_idcal"].ToString() + "' responsable='" + dr["nombreResponsable"] + "' "); sb.Append(" provincia='" + dr["t173_denominacion"] + "' njorlabcal='" + dr["Njorlabcal"] + "' nhlacv='" + dr["t066_nhlacv"] + "' "); sb.Append(" observaciones = '" + dr["t066_obs"] + "' estado = '" + (bool)dr["t066_estado"] + "' "); sb.Append("onclick ='mm(event)' ondblclick='mostrarDetalle(this.id)' style='height:16px'>"); sb.Append("<td style='padding-left:5px'>" + dr["t066_descal"].ToString() + "</td>"); sb.Append("<td>" + dr["t303_denominacion"].ToString() + "</td>"); string sDesTipo = ""; switch (dr["t066_tipocal"].ToString()) { case "E": sDesTipo = "Empresarial"; break; case "D": sDesTipo = "Departamental"; break; case "P": sDesTipo = "Proyecto"; break; } sb.Append("<td>" + sDesTipo + "</td>"); if ((bool)dr["t066_estado"]) { sb.Append("<td align='center' ord='1'><img src='../../../../images/imgOk.gif' /></td>"); } else { sb.Append("<td ord='0'><img src='../../../../images/imgSeparador.gif' /></td>"); } sb.Append("</tr>"); //i++; } dr.Close(); dr.Dispose(); sb.Append("</tbody>"); sb.Append("</table>"); strTablaHtml = sb.ToString(); }
private string setPantalla(string sActivo, string sIDFicepiResp) { string sResul = ""; StringBuilder sb = new StringBuilder(); try { SqlDataReader dr; bool? bActivo; int? iIDFicepiResp = null; if (sActivo == "0") { bActivo = null; } else { bActivo = true; } if (sIDFicepiResp == "") { iIDFicepiResp = null; } else { iIDFicepiResp = int.Parse(sIDFicepiResp); } dr = Calendario.Catalogo(null, "", bActivo, null, null, "", iIDFicepiResp, 3, 0); /*if (SUPER.Capa_Negocio.Utilidades.EsAdminProduccion()) * dr = Calendario.Catalogo(null, "", bActivo, null, null, "", iIDFicepiResp, 3, 0); * else * dr = Calendario.CatalogoUsu((int)Session["UsuarioActual"], null, "", bActivo, null, "", 3, 0); */ sb.Append("<table id='tblDatos' class='texto MA' style='WIDTH: 750px;'>"); sb.Append("<colgroup><col style='width:325px;' /><col style='width:300px' /><col style='width:75px' /><col style='width:50px;' /></colgroup>"); sb.Append("<tbody>"); while (dr.Read()) { sb.Append("<tr id='" + dr["t066_idcal"].ToString() + "' responsable='" + dr["nombreResponsable"] + "' "); sb.Append(" provincia='" + dr["t173_denominacion"] + "' njorlabcal='" + dr["Njorlabcal"] + "' nhlacv='" + dr["t066_nhlacv"] + "' "); sb.Append(" observaciones = '" + dr["t066_obs"] + "' estado = '" + (bool)dr["t066_estado"] + "' "); sb.Append(" onclick ='mm(event)' ondblclick='mostrarDetalle(this.id)' style='height:16px'>"); sb.Append("<td style='padding-left:5px'>" + dr["t066_descal"].ToString() + "</td>"); sb.Append("<td>" + dr["t303_denominacion"].ToString() + "</td>"); string sDesTipo = ""; switch (dr["t066_tipocal"].ToString()) { case "E": sDesTipo = "Empresarial"; break; case "D": sDesTipo = "Departamental"; break; case "P": sDesTipo = "Proyecto"; break; } sb.Append("<td>" + sDesTipo + "</td>"); if ((bool)dr["t066_estado"]) { sb.Append("<td align='center' ord='1'><img src='../../../../images/imgOk.gif' /></td>"); } else { sb.Append("<td ord='0'><img src='../../../../images/imgSeparador.gif' /></td>"); } sb.Append("</tr>"); //i++; } dr.Close(); dr.Dispose(); sb.Append("</tbody>"); sb.Append("</table>"); sResul = "OK@#@" + sb.ToString();; } catch (Exception ex) { sResul = "Error@#@" + Errores.mostrarError("Error al ordenar el catálogo", ex); } return(sResul); }