/// <summary>
/// </summary>
/// <param name="db"></param>
/// <param name="tipoProj"></param>
/// <param name="listaID"></param>
/// <param name="debug"></param>
/// <returns></returns>
internal static ArrayList getChildren(/*DocsPaWS.Utils.Database db,*/ string tipoProj, ArrayList listaID)
{
ArrayList listaIdFascicoli = new ArrayList();
#region Codice Commentato
/* string queryStr;
* IDataReader dr;
* string idProject = (string)listaID[0];
* for (int i=1; i < listaID.Count; i++)
* idProject += "," + (string)listaID[i];
* if(tipoProj.Equals("T")) {
* queryStr =
* "SELECT SYSTEM_ID FROM PROJECT WHERE CHA_TIPO_PROJ='F' AND ID_PARENT IN (" + idProject + ")";
* logger.Debug(queryStr);
* dr = db.executeReader(queryStr);
* while(dr.Read()) {
* listaID.Add(dr.GetValue(0).ToString());
* listaIdFascicoli.Add(dr.GetValue(0).ToString());
* }
* dr.Close();
* } else if(tipoProj.Equals("F"))
* listaIdFascicoli = listaID;
* string idFascicoli = (string)listaIdFascicoli[0];
* for (int i=1; i < listaIdFascicoli.Count; i++)
* idFascicoli += "," + (string)listaIdFascicoli[i];
* queryStr =
* "SELECT SYSTEM_ID FROM PROJECT WHERE CHA_TIPO_PROJ='C' AND ID_FASCICOLO IN (" + idFascicoli + ")";
* logger.Debug(queryStr);
* dr = db.executeReader(queryStr);
* while(dr.Read())
* listaID.Add(dr.GetValue(0).ToString());
* dr.Close();*/
#endregion
DocsPaDB.Query_DocsPAWS.Fascicoli fascicoli = new DocsPaDB.Query_DocsPAWS.Fascicoli();
listaID = fascicoli.GetChildren(/*db,*/ tipoProj, listaID);
return(listaID);
}
