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