Axapta: Multi tables lookup

最新推荐文章于 2023-11-16 12:43:54 发布

weixin_30852419

最新推荐文章于 2023-11-16 12:43:54 发布

阅读量104

点赞数

CC 4.0 BY-SA版权

文章标签： c#

原文链接：http://www.cnblogs.com/JackyXu1981/archive/2008/11/21/1338228.html

本文介绍如何在Axapta中使用SysMultiTableLookup类实现多表查询，以获取销售订单行创建时所需的不同表中的信息。通过覆盖SalesTableForm中的SalesLine_ItemId查找方法，演示了具体实现步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Axapta: Multi tables lookup

/Files/JackyXu1981/SysMultiTableLookup.rar SysMultiTableLookup Class DownLoad

The SysMultiTableLookup.rar is a class to show multi table information.

When you want to create a sales line in SO, You can selet an item and see some information of item. Those information is from invent table.

But sometimes you want those information from multi tables, How to do?

SysMultiTableLookup class provide a solution to it.

It is from http://kashperuk.blogspot.com/

I had used it on creating a sales line.

Overwrite lookup method of SalesLine_ItemId on SalesTable Form

public void lookup()
{
    Query                   query          = new Query();
    QueryBuildDataSource    queryBuildDataSource,queryBuildDataSource2 ;
    QueryBuildRange         queryBuildRange;
    SysMultiTableLookup          sysTableLookup ; //Not SysTableLookup class
    ;

    queryBuildDataSource = query.addDataSource(tableNum(InventTable));    //link a another table
    queryBuildDataSource2 = queryBuildDataSource.addDataSource(tablenum(InventTableModule));
    queryBuildDataSource2.joinMode(JoinMode::InnerJoin) ;
    queryBuildDataSource2.relations(true) ;

sysTableLookup =SysMultiTableLookup::newParameters(this,query) ;

    sysTableLookup.addLookupField(fieldNum(InventTable, ItemId));
    sysTableLookup.addLookupField(fieldNum(InventTable, ItemName));
    sysTableLookup.addLookupField(fieldNum(InventTable, NameAlias));
    sysTableLookup.addLookupfield(fieldNum(InventTable, ItemGroupId));
    sysTableLookup.addLookupfield(fieldNum(InventTable, ItemType));
    sysTableLookup.addLookupfield(fieldNum(InventTable, HDSH_ItemOriginName));
    sysTableLookup.addLookupfield(fieldNum(InventTable, HDSH_PrevItemId));
    sysTableLookup.addLookupField(fieldNum(InventTableModule,UnitId),2) ;    // get a field from another table. 2 is second datasource

    queryBuildDataSource.addRange(fieldNum(InventTable, HDSH_Visible)).value("0");
    queryBuildDataSource2.addRange(fieldNum(InventTableModule, ModuleType)).value("0");

sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}

First only need u import class: SysMultiTableLookup.