• X++ code to remove identical copy


    /***
    Our client asked for a job to remove the identical copy from VAR layer.
    For some unknown reason, some AOT objects are touched in VAR layer but actually are identical copy. When the developer compared the VAR layer object with the one in lower layer (BUS, SYS etc.), AX showed it was an identical copy.
     Here is the example on how you can remove the identical copy in X++ code:
    Wrote by Jimmy on 2010-11-12
    */

    static void Jimmy_FindAndDeleteIdenticalObjects(Args _args)
    {
        SysTreeNode         comparable1, comparable2;
        TreeNode            curLevelTreeNode, upperLevelTreeNode;
        UtilIdElements      utilElements, joinUtilElements;
    ;
        while select UtilElements
            where UtilElements.utilLevel        == UtilEntryLevel::var &&
                  (
                    UtilElements.recordType     == UtilElementType::Form        ||
                    Utilelements.recordType     == UtilElementType::Report      ||
                    Utilelements.recordType     == UtilElementType::Table       ||
                    Utilelements.recordType     == UtilElementType::Class       ||
                    Utilelements.recordType     == UtilElementType::Enum        ||
                    Utilelements.recordType     == UtilElementType::ExtendedType
                  )
        {
            //Should use join if for a normal table, but not applicable for UtilElements
            //Performance hit if use exists join
            select firstonly recid from joinUtilElements
                where joinUtilElements.utilLevel     != UtilElements.utilLevel   &&
                      joinUtilElements.name          == UtilElements.name        &&
                      joinUtilElements.recordType    == UtilElements.recordType;
            if (joinUtilElements.RecId)
            {
                //Thanks for Jim Shepherd here
                curLevelTreeNode    = SysTreeNode::findNodeInLayer(UtilElements.recordType, UtilElements.name, UtilElements.parentId, UtilElements.utilLevel);
                
                upperLevelTreeNode  = SysTreeNode::getLayeredNode(curLevelTreenode, 1);
                comparable1         = SysTreeNode::newTreeNode(curLevelTreeNode);
                comparable2         = SysTreeNode::newTreeNode(upperLevelTreeNode);
                if (SysCompare::silentCompare(comparable1, comparable2))
                {
                    info(strFmt("Element name: %1, Element type: %2", UtilElements.name, enum2str(UtilElements.recordType)));
                    //Remove the node
                    curLevelTreeNode.AOTdelete();
                }
           }
       }
    }
    //Thanks for Jim Shepherd here.   
    //http://fredshen.wordpress.com/2009/04/09/x-code-to-remove-identical-copy/
    
  • 相关阅读:
    Windows批处理方式实现MySQL定期自动备份多个数据库
    MySQL数据库中库、表名、字段的大小写问题
    使用modbus4j通过串口解析modbus协议(java)
    mybatis —— 动态sql之if条件判断各种使用方式
    Mysql 获取表的comment 字段
    [转载]如何判断数据库,表或字段是否存在
    设计模式目录
    图片上传及访问
    实现第一个API
    ListView 源码解析
  • 原文地址:https://www.cnblogs.com/Fandyx/p/1875637.html
Copyright © 2020-2023  润新知