private string ObtenerTareas(string sTipoBusqueda, string num_proy_tec, string num_fase, string num_act,
string strNomTarea, string sT305IdProy)
{
string sResul = "", sPT;
int nPT, nPE;
SqlDataReader dr;
try
{
StringBuilder strBuilder = new StringBuilder();
// int i = 0;
strBuilder.Append("<table id='tblDatos' class='texto MA' style='width: 440px;'>");
strBuilder.Append("<colgroup><col style='width:440px'></colgroup>");
strBuilder.Append("<tbody>");
if ((sT305IdProy == "") || (sT305IdProy == "-1"))
{
nPE = -1;
int iUser = (int)Session["UsuarioActual"];
dr = TAREAPSP.Catalogo4(strNomTarea, 2, 0, sTipoBusqueda, iUser);
}
else
{
if (num_proy_tec == "")
{
nPT = -1;
}
else
{
sPT = num_proy_tec.Replace(".", "");
nPT = int.Parse(sPT);
}
if (nPT == -1)
{
//sPE = sPE.Replace(".", "");
nPE = int.Parse(sT305IdProy);
int iUser = (int)Session["UsuarioActual"];
dr = TAREAPSP.Catalogo3(strNomTarea, nPE, 2, 0, sTipoBusqueda, iUser);
}
else
{
if (num_fase == "" || num_fase == "-1" || num_fase == "0")
{
if (num_act == "" || num_act == "-1" || num_act == "0")
{
dr = TAREAPSP.Catalogo2(null, strNomTarea, nPT, null, null, 2, 0, sTipoBusqueda);
}
else
{
dr = TAREAPSP.Catalogo2(null, strNomTarea, nPT, null, int.Parse(num_act), 2, 0, sTipoBusqueda);
}
}
else
{
if (num_act == "" || num_act == "-1" || num_act == "0")
{
dr = TAREAPSP.Catalogo2(null, strNomTarea, nPT, int.Parse(num_fase), null, 2, 0, sTipoBusqueda);
}
else
{
dr = TAREAPSP.Catalogo2(null, strNomTarea, nPT, int.Parse(num_fase), int.Parse(num_act), 2, 0, sTipoBusqueda);
}
}
}
}
while (dr.Read())
{
StringBuilder sbTitle = new StringBuilder();
sbTitle.Append("<b>Proy. Eco.</b>: ");
sbTitle.Append(dr["nom_proyecto"].ToString().Replace((char)34, (char)39));
sbTitle.Append("<br><b>Proy. Téc.</b>: ");
sbTitle.Append(dr["t331_despt"].ToString().Replace((char)34, (char)39));
if (dr["t334_desfase"].ToString() != "")
{
sbTitle.Append("<br><b>Fase</b>: ");
sbTitle.Append(dr["t334_desfase"].ToString().Replace((char)34, (char)39));
}
if (dr["t335_desactividad"].ToString() != "")
{
sbTitle.Append("<br><b>Actividad</b>: ");
sbTitle.Append(dr["t335_desactividad"].ToString().Replace((char)34, (char)39));
}
sbTitle.Append("<br><b>Tarea</b>: ");
sbTitle.Append(dr["t332_destarea"].ToString().Replace((char)34, (char)39));
strBuilder.Append("<tr id='" + dr["t332_idtarea"].ToString());
strBuilder.Append("' nPE=\"");
strBuilder.Append(dr["num_proyecto"].ToString().Replace((char)34, (char)39));
strBuilder.Append("\" sPE=\"");
strBuilder.Append(dr["nom_proyecto"].ToString().Replace((char)34, (char)39));
strBuilder.Append("\" nPT=\"");
strBuilder.Append(dr["t331_idpt"].ToString().Replace((char)34, (char)39));
strBuilder.Append("\" sPT=\"");
strBuilder.Append(dr["t331_despt"].ToString().Replace((char)34, (char)39));
strBuilder.Append("\" nF=\"");
strBuilder.Append(dr["t334_idfase"].ToString().Replace((char)34, (char)39));
strBuilder.Append("\" sF=\"");
strBuilder.Append(dr["t334_desfase"].ToString().Replace((char)34, (char)39));
strBuilder.Append("\" nA=\"");
strBuilder.Append(dr["t335_idactividad"].ToString().Replace((char)34, (char)39));
strBuilder.Append("\" sA=\"");
strBuilder.Append(dr["t335_desactividad"].ToString().Replace((char)34, (char)39));
strBuilder.Append("\" sT305IdPr=\"");
strBuilder.Append(dr["t305_idproyectosubnodo"].ToString().Replace((char)34, (char)39));
strBuilder.Append("\" sEst=\"");
strBuilder.Append(dr["t301_estado"].ToString().Replace((char)34, (char)39));
strBuilder.Append("\" onclick='ms(this);estructura(this);' onmouseover='TTip(event)' ondblclick='aceptarClick(this.rowIndex)' title=\"cssbody=[dvbdy] cssheader=[dvhdr] header=[<img src='../../../images/info.gif' style='vertical-align:middle'> Estructura] body=[");
strBuilder.Append(sbTitle);
//strBuilder.Append("]\"><td><span class='NBR' style='width:400px;'>" + dr["t332_destarea"].ToString() + "</span></td></tr>");
strBuilder.Append("]\"><td><nobr style='width:400px;'>" + dr["t332_destarea"].ToString() + "</nobr></td></tr>");
}
dr.Close();
dr.Dispose();
strBuilder.Append("</tbody>");
strBuilder.Append("</table>");
sResul = "OK@#@" + strBuilder.ToString();
}
catch (Exception ex)
{
sResul = "Error@#@" + Errores.mostrarError("Error al Obtener las tareas", ex);
}
return(sResul);
}
