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