} // doIt /// <summary> /// Verify Tree /// </summary> /// <param name="tree">tree</param> /// <returns>message</returns> private String VerifyTree(MTree tree) { if (tree.GetAD_Table_ID(true) == 0) { tree.UpdateTrees(); } String nodeTableName = tree.GetNodeTableName(); String sourceTableName = tree.GetSourceTableName(true); String sourceTableKey = sourceTableName + "_ID"; int AD_Client_ID = tree.GetAD_Client_ID(); int C_Element_ID = 0; if (MTree.TREETYPE_ElementValue.Equals(tree.GetTreeType())) { String sql = "SELECT C_Element_ID FROM C_Element " + "WHERE AD_Tree_ID=" + tree.GetAD_Tree_ID(); C_Element_ID = DataBase.DB.GetSQLValue(null, sql); if (C_Element_ID <= 0) { throw new Exception("No Account Element found"); } } // Delete unused StringBuilder sql1 = new StringBuilder(); sql1.Append("DELETE FROM ").Append(nodeTableName) .Append(" WHERE AD_Tree_ID=").Append(tree.GetAD_Tree_ID()) .Append(" AND Node_ID NOT IN (SELECT ").Append(sourceTableKey) .Append(" FROM ").Append(sourceTableName) .Append(" WHERE AD_Client_ID IN (0,").Append(AD_Client_ID).Append(")"); if (C_Element_ID > 0) { sql1.Append(" AND C_Element_ID=").Append(C_Element_ID); } sql1.Append(")"); log.Finer(sql1.ToString()); // int deletes = DataBase.DB.ExecuteQuery(sql1.ToString(), null, Get_Trx()); AddLog(0, null, new Decimal(deletes), tree.GetName() + " Deleted"); if (!tree.IsAllNodes()) { return(tree.GetName() + " OK"); } // Insert new int inserts = 0; StringBuilder sql2 = new StringBuilder(); sql2.Append("SELECT ").Append(sourceTableKey) .Append(" FROM ").Append(sourceTableName) .Append(" WHERE AD_Client_ID IN (0,").Append(AD_Client_ID).Append(")"); if (C_Element_ID > 0) { sql2.Append(" AND C_Element_ID=").Append(C_Element_ID); } sql2.Append(" AND ").Append(sourceTableKey) .Append(" NOT IN (SELECT Node_ID FROM ").Append(nodeTableName) .Append(" WHERE AD_Tree_ID=").Append(tree.GetAD_Tree_ID()).Append(")") .Append(" ORDER BY Upper(name)"); log.Finer(sql2.ToString()); // Boolean ok = true; IDataReader idr = null; //PreparedStatement pstmt = null; try { //pstmt = DataBase.prepareStatement(sql.toString(), Get_Trx()); //ResultSet rs = pstmt.executeQuery(); idr = DataBase.DB.ExecuteReader(sql2.ToString(), null, Get_Trx()); //Manish 8/06/2016 int setSeqManually = -1; //End while (idr.Read()) { int Node_ID = Utility.Util.GetValueOfInt(idr[0]);// rs.getInt(1); PO node = null; if (nodeTableName.Equals("AD_TreeNode")) { // node = new MTreeNode(tree, Node_ID); //Manish setSeqManually += 1; node = new MTreeNode(tree, Node_ID, setSeqManually); //end } else if (nodeTableName.Equals("AD_TreeNodeBP")) { //node = new MTreeNodeBP(tree, Node_ID); //Manish setSeqManually += 1; node = new MTreeNodeBP(tree, Node_ID, setSeqManually); //end } else if (nodeTableName.Equals("AD_TreeNodePR")) { //node = new MTreeNodePR(tree, Node_ID); //Manish setSeqManually += 1; node = new MTreeNodePR(tree, Node_ID, setSeqManually); //end } else if (nodeTableName.Equals("AD_TreeNodeCMC")) { //node = new MTreeNodeCMC(tree, Node_ID); //Manish setSeqManually += 1; node = new MTreeNodeCMC(tree, Node_ID, setSeqManually); //end } else if (nodeTableName.Equals("AD_TreeNodeCMM")) { //node = new MTreeNodeCMM(tree, Node_ID); //Manish setSeqManually += 1; node = new MTreeNodeCMM(tree, Node_ID, setSeqManually); //end } else if (nodeTableName.Equals("AD_TreeNodeCMS")) { // node = new MTreeNodeCMS(tree, Node_ID); //Manish setSeqManually += 1; node = new MTreeNodeCMS(tree, Node_ID, setSeqManually); //end } else if (nodeTableName.Equals("AD_TreeNodeCMT")) { //node = new MTreeNodeCMT(tree, Node_ID); //Manish setSeqManually += 1; node = new MTreeNodeCMT(tree, Node_ID, setSeqManually); //end } else if (nodeTableName.Equals("AD_TreeNodeMM")) { // node = new MTreeNodeMM(tree, Node_ID); //Manish setSeqManually += 1; node = new MTreeNodeMM(tree, Node_ID, setSeqManually); //end } if (node == null) { log.Log(Level.SEVERE, "No Model for " + nodeTableName); } else { if (node.Save()) { inserts++; } else { log.Log(Level.SEVERE, "Could not add to " + tree + " Node_ID=" + Node_ID); } } } } catch (Exception e) { log.Log(Level.SEVERE, sql2.ToString(), e); ok = false; } finally { idr.Close(); } AddLog(0, null, new Decimal(inserts), tree.GetName() + " Inserted"); return(tree.GetName() + (ok ? " OK" : " Error")); } // verifyTree
public void AddChild(MTreeNode <T> node) { children.Add(node); node.parent = this; }