private string obtenerDatos(string sSoloActivas)
{
string sFecAux = "";
StringBuilder sb = new StringBuilder();
try
{
//sb.Append("<table id='tblDatos' class='texto' style='WIDTH: 850px; table-layout:fixed; HEIGHT: 17px;cursor: url(../../../images/imgManoAzul2.cur)' cellspacing='0' border='0'>");
sb.Append("<table id='tblDatos' class='texto MA' style='width:850px; table-layout:fixed;' cellspacing='0' border='0'>");
sb.Append(" <colgroup>");
sb.Append(" <col style='width:295px;' />");
sb.Append(" <col style='width:295px' />");
sb.Append(" <col style='width:100px' />");
sb.Append(" <col style='width:100px' />");
sb.Append(" <col style='width:60px' />");
sb.Append(" </colgroup>");
sb.Append("<tbody>");
string sColor = "";
SqlDataReader dr = WIFI.CatalogoWifi((int)Session["CR2I_IDFICEPI"], (sSoloActivas == "1") ? true : false);
while (dr.Read())
{
sb.Append("<tr id='" + dr["t085_idreserva"].ToString() + "' style='height:16px;'");
//sb.Append(" style=\"height:16px; cursor:url(../../../images/imgManoAzul2.cur),pointer\" onclick='msse(this)' ondblclick='mdwifi(this.id)'>");
sb.Append(" onclick='msse(this)' ondblclick='mdwifi(this.id)'>");
sb.Append("<td><nobr class='NBR W290'>" + dr["Solicitante"].ToString() + "</nobr></td>");
sb.Append("<td><nobr class='NBR W290'>" + dr["t085_interesado"].ToString() + "</nobr></td>");
sFecAux = dr["t085_fechoraini"].ToString().Substring(0, 16);
if (sFecAux.Substring(15, 1) == ":")
{
sFecAux = sFecAux.Substring(0, 11) + "0" + sFecAux.Substring(11, 4);
}
sb.Append("<td>" + sFecAux + "</td>");
sFecAux = dr["t085_fechorafin"].ToString().Substring(0, 16);
if (sFecAux.Substring(15, 1) == ":")
{
sFecAux = sFecAux.Substring(0, 11) + "0" + sFecAux.Substring(11, 4);
}
sb.Append("<td>" + sFecAux + "</td>");
switch (dr["t085_estado"].ToString())
{
case "1": sColor = "Orange"; break;
case "2": sColor = "Green"; break;
case "3": sColor = "Gray"; break;
case "4": sColor = "Red"; break;
}
sb.Append("<td style='Color:" + sColor + "'>" + dr["des_estado"].ToString() + "</td>");
sb.Append("</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 el catálogo de reservas wifi", ex));
}
}
