AX中动态产生方法并且调用，解决根据不同条件产生不同SQL逻辑的问题很方便

static void Job71(Args _args)
{
    str  string;
    inventtable inventtable;
    xppCompiler         compiler   ;
    ;

    compiler     =   new xppCompiler();
    select firstonly inventtable;
    string = @"str hello()
               {
                  inventtable inventtable1;
                  ;
                 ";
   string += "select inventtable1 where inventtable1.itemid == '"+inventtable.ItemId+"'";
   string +=@";
               info(inventtable1.itemid);
               return  inventtable1.itemid;
              }  ";
   info(string);
   string =   strfmt(string);

   if(compiler.compile(string))
   {
      string = runbuf(string);
      info(string);
   }

}