} // getTree /// <summary> /// Get Tree Node /// </summary> /// <param name="tree">tree</param> /// <param name="Node_ID">node</param> /// <returns>node or null</returns> public static MTreeNodeCMT Get(MTree tree, int Node_ID) { MTreeNodeCMT retValue = null; String sql = "SELECT * FROM AD_TreeNodeCMT WHERE AD_Tree_ID=@Param1 AND Node_ID=@Param2"; SqlParameter[] Param = new SqlParameter[2]; IDataReader idr = null; DataTable dt = null; try { //pstmt = DataBase.prepareStatement (sql, tree.get_TrxName()); //pstmt.setInt (1, tree.getAD_Tree_ID()); Param[0] = new SqlParameter("@Param1", tree.GetAD_Tree_ID()); Param[1] = new SqlParameter("@Param2", Node_ID); //pstmt.setInt (2, Node_ID); //ResultSet rs = pstmt.executeQuery (); idr = DataBase.DB.ExecuteReader(sql, Param, tree.Get_TrxName()); dt = new DataTable(); dt.Load(idr); foreach (DataRow dr in dt.Rows) { retValue = new MTreeNodeCMT(tree.GetCtx(), dr, tree.Get_TrxName()); } } catch (Exception e) { _log.Log(Level.SEVERE, sql, e); } finally { idr.Close(); dt = null; } return(retValue); } // get
/// <summary> /// Get Tree /// </summary> /// <param name="ctx">context</param> /// <param name="AD_Tree_ID">tree</param> /// <param name="trxName">transaction</param> /// <returns>array of nodes</returns> public static MTreeNodeCMT[] GetTree(Ctx ctx, int AD_Tree_ID, Trx trxName) { List <MTreeNodeCMT> list = new List <MTreeNodeCMT>(); String sql = "SELECT * FROM AD_TreeNodeCMT WHERE AD_Tree_ID=@Param1 ORDER BY Node_ID"; SqlParameter[] Param = new SqlParameter[1]; IDataReader idr = null; DataTable dt = null; try { //pstmt = DataBase.prepareStatement (sql, trxName); Param[0] = new SqlParameter("@Param1", AD_Tree_ID); idr = DataBase.DB.ExecuteReader(sql, Param, trxName); dt = new DataTable(); dt.Load(idr); //pstmt.setInt (1, AD_Tree_ID); //ResultSet rs = pstmt.executeQuery (); foreach (DataRow dr in dt.Rows) { list.Add(new MTreeNodeCMT(ctx, dr, trxName)); } } catch (Exception e) { _log.Log(Level.SEVERE, sql, e); } finally { idr.Close(); dt = null; } MTreeNodeCMT[] retValue = new MTreeNodeCMT[list.Count]; retValue = list.ToArray(); return(retValue); } // getTree