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