Axapta: Multi tables lookup
来源:互联网 发布:qq资源网源码 编辑:程序博客网 时间:2024/06/06 00:29
/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.
From:http://www.cnblogs.com/JackyXu1981/articles/1338228.html
- Axapta: Multi tables lookup
- Oracle Apps Lookup Tables,Views,Queries,FAQ
- Efficient C Tips #9 – Use lookup tables
- Sysbench with support of multi-tables workload
- "CMN_1552: Error accessing lookup cache." when running a PowerCenter session with large lookup tables
- lookup
- Oracle BI EE 11g – Lookup Tables – Sparse and Dense Lookups
- How to scan images, lookup tables and time measurement with OpenCV
- OpenCV--How to scan images, lookup tables and time measurement with OpenCV
- opencv_tutorial 2.2 - How to scan Images,Lookup tables and time measurement with opencv
- Business System Supporter-Axapta
- Axapta 全局函数
- Axapta中的保留字
- Axapta中使用FTP
- Excel导入Axapta 3.0
- multi-
- Axapta当中的RunOn属性
- 贝塔斯曼招聘软件工程师(Axapta相关)
- Google可能退出中国
- What are the difference between DDL, DML and DCL commands?
- 2009-03-11 | C# BCD码与十进制数的转换 分享
- c#中 Static Public Void 它们的用途与区别
- C# BCD编码解码
- Axapta: Multi tables lookup
- what would you do if you had only one day left to live?
- 帮你做新年理财计划
- struts2中的action单元测试
- java数据结构讲述之链表
- 解决 UIViewTable cellForRowAtIndexPath 警告 问题
- 手动绑定数据到GridView并实现编辑,删除,取消···
- AfxMessageBox字符问题
- ASP.NET(C#)常用代码30例