02 2012 档案

ax转到主窗体 GoToMainTable
摘要：转到主窗体设置步骤： 创建表MainTable 创建一个EDT 指向MainTable字段; 将EDT拖入MainTable生成表字段; 创建MainForm 将mainForm拖入MenuItem生成MenuItem; 设置MainTable属性FormRef指向MenuItem; 完成！ 阅读全文
posted @ 2012-02-29 17:28 perock 阅读(264) 评论(0) 推荐(0)
TabAx安装方法
摘要：导入xpo之后，修改info这个Class方法startupPost 加入下列代码： if(!WinAPI::isShiftButtonDown()) { // check for user ID if(curUserId()=="MF") // <- change to your loginname { ... 阅读全文
posted @ 2012-02-29 17:09 perock 阅读(338) 评论(0) 推荐(0)
AxShowField插件安装方法 SysSetupFormRun中Task方法
摘要：public int task(int _p1) { #task FormDataSource formDataSource; //zcb insert begin //Use origin class object object; //zcb insert end ... 阅读全文
posted @ 2012-02-29 16:10 perock 阅读(662) 评论(0) 推荐(0)
AxAssist安装说明
摘要：Microsoft Dynamics AX 4.0: Add this code after variable definition section in Classes->EditorScripts->getApplicableScripts() method: // > AxAssist, 20.02.2011 if(DEV_AxAssistSingleton::ge... 阅读全文
posted @ 2012-02-29 15:54 perock 阅读(408) 评论(0) 推荐(0)
设置报表的 条形码 Barcode 字体 生产参数
摘要：void initBarCodeFont() { ; prodParm = ProdParameters::find(); barCodeSetup = barCodeSetup::find(prodParm.ACT_PTBC); barCode = barCodeSetup.barcode(); if(... 阅读全文
posted @ 2012-02-29 15:48 perock 阅读(755) 评论(0) 推荐(0)
转英文 TotalEng
摘要：static str totalEng(real _realValue,CurrencyCode _currencyCode = "USD") { int sLen,sFind,sFindA,sFindB; str num2En,num2En_int,num2EnA,num2EnB,num2EnA_1,... 阅读全文
posted @ 2012-02-29 14:47 perock 阅读(250) 评论(0) 推荐(0)
使用ODBC操作数据库的几种方法
摘要：Connecting to Databases through X++ In this article, I am going to explain about different ways through which one can connect to different databases for data manipulation operatio... 阅读全文
posted @ 2012-02-17 08:50 perock 阅读(5663) 评论(1) 推荐(1)
回调方法
摘要：Call-back methods Sometimes it is useful to call methods on the parent/caller of your class. If you are using the runbase framework you can call accessors methods from the form that called yo... 阅读全文
posted @ 2012-02-16 08:55 perock 阅读(477) 评论(0) 推荐(0)
Export to Excel/Word - COM-Interface
摘要：Export to Excel/Word - COM-Interface Axapta has subset of classes which can be used for exporting data into Excel viaCOMin your own way. You can find them in theAOT( Application O... 阅读全文
posted @ 2012-02-15 17:51 perock 阅读(357) 评论(0) 推荐(0)
Progress Bar
摘要：Progress Bar [edit]Introduction A progress bar is a graphical representation of a job's progress and is used extensively in the standard application. By using a progress bar, use... 阅读全文
posted @ 2012-02-15 17:50 perock 阅读(514) 评论(0) 推荐(0)
Using Timer
摘要：Using Timer If you want perform a periodic task you can usebatch processing, but there is another option to perform local fast periodic tasks -timers. You can call thesetTimeO... 阅读全文
posted @ 2012-02-15 17:49 perock 阅读(236) 评论(0) 推荐(0)
Expressions in query ranges
摘要：Expressions in query ranges One of least understood but most powerful Axapta features is the so-calledExpressions in query rangessyntax. This isnotthe same as simply using a Query... 阅读全文
posted @ 2012-02-15 17:44 perock 阅读(503) 评论(0) 推荐(0)
FTP from Axapta
摘要：FTP from Axapta fromDevelopment Axaptaby (Dahlsgaard Jan) add at theclass declarationof theWinInet classthe following: DLLFunction internetConnect;DLLFunction ftpGetFi... 阅读全文
posted @ 2012-02-15 17:41 perock 阅读(399) 评论(0) 推荐(0)
Map Class
摘要：Map Class Map (Foundation class)consist of a data set that contains a key and a corresponding value, where the key is unique. The key and the value need not be from the same data typ... 阅读全文
posted @ 2012-02-15 17:40 perock 阅读(952) 评论(0) 推荐(0)
Box class
摘要：Box class Box is a class used for showing an information- or confirmation box to the user. [edit]Example if (Box::yesNo("Is it safe to delete this?", DialogButton::No, "Delete inventory") == Dialog... 阅读全文
posted @ 2012-02-15 17:39 perock 阅读(300) 评论(0) 推荐(0)
Set Class
摘要：Set Class Set consist of a data set that contains values of the same type, where value is unique. A Set is alway sorted on the value. Contents [hide] 1 How to use 1.1 Define ... 阅读全文
posted @ 2012-02-15 17:35 perock 阅读(379) 评论(0) 推荐(0)
使用ExcelIo类操作读取excel文件
摘要：static void NJ_MF_Test_ExcelIoTest(Args _args) { ExcelIo io; #Excel dialogField dialogFilename; Dialog dialog = new Dialog("Excel Upload"); container con; ;... 阅读全文
posted @ 2012-02-15 16:49 perock 阅读(1489) 评论(0) 推荐(0)
Edit方法
摘要：Edit方法参数个数可以有两个也可以有三个，如果有三个参数那么第二个参数一定要是Table edit NoYes markLine(boolean _set, InventTable _table, NoYes _value) { if (_set) { //Add or remove the selected line from th... 阅读全文
posted @ 2012-02-15 16:17 perock 阅读(336) 评论(0) 推荐(0)
控制数据源中某一列是否允许编辑 FormDataObject allowEdit
摘要：void updateDesign() { FormDataObject fldItemName; // Only allow the item name to be modified if it's a service item // // Notice that this effects the controls both on the... 阅读全文
posted @ 2012-02-15 15:16 perock 阅读(343) 评论(0) 推荐(0)
设置表格字段背景色displayOption
摘要：public void displayOption(Common _record, FormRowDisplayOption _options) { GridColours gridColoursLocal = _record; ; super(_record, _options); // If highlight flag is set,... 阅读全文
posted @ 2012-02-15 14:04 perock 阅读(475) 评论(0) 推荐(0)
SysEmailBatch 邮件
摘要：SysEmailBatch The SysEmailBatch class is used for sending emails from Axapta. SysEmailBatch mailer; mailer = SysEMailBatch::construct();mailer.parmPriority(emailPriority::Normal);mailer.parmSender... 阅读全文
posted @ 2012-02-15 12:56 perock 阅读(268) 评论(0) 推荐(0)
多栏报表 多列报表
摘要：Multi Column Report [edit]Data Structure This is tutorial how to create multiple columns on a report. The report designer has no support for multi column rendering; Like in Word where you can set a ... 阅读全文
posted @ 2012-02-15 12:46 perock 阅读(518) 评论(0) 推荐(0)
TempTable 临时表
摘要：临时表方法:table.setTmp() 将一个表作为临时表使用tmpTable.Data() 一般配合 doinsert()使用，从参数表中Copy一行记录后插入到临时表.tmpTable.SetTmpData(Common cursor) 设置tmpTable中的内容到cursor中临时表在报表中：将临时表传递给报表做数据源调用SetRecord()方法：this.queryRun()... 阅读全文
posted @ 2012-02-15 12:38 perock 阅读(698) 评论(0) 推荐(0)
使用ADO读取SQL数据库
摘要：static void UpdateInventTableFromUAT(Args _args) { SysOperationProgressEmbedded progress; CCADOConnection connection; str strSQL; ... 阅读全文
posted @ 2012-02-14 09:22 perock 阅读(590) 评论(0) 推荐(0)
导出xml
摘要：public static void main(Args _args) { XmlDocument doc; XmlElement nodeXml; XmlElement nodeTable; XmlElement nodeAccount; XmlElement nodeName; LedgerTable ledgerTable; #define.fi... 阅读全文
posted @ 2012-02-14 08:25 perock 阅读(324) 评论(0) 推荐(0)
获取当前用户所属的所有仓位,DictRelation,
摘要：//获取当前用户所属的所有仓位 表:WMSLocation public client static void lookupWMSLocationIdbyUser(FormStringControl _ctrl,inventLocationId _inventLocationId ) { SysTableLookup sy... 阅读全文
posted @ 2012-02-13 15:30 perock 阅读(381) 评论(0) 推荐(0)
Form.SelectMode使用窗体Lookup
摘要：Form element.selectMode(ACT_InventLocationLookup_InventLocationId) //selectMode方法指定FormControl在单击时将关闭lookup窗口 ----------------------------------------- 以下方法是数据源中某字段下Lookup的 public void lookup(For... 阅读全文
posted @ 2012-02-13 15:21 perock 阅读(803) 评论(0) 推荐(0)
存储过程IN参数疑难问题解决方法
摘要：首先，我不会令大家失望，真想解决问题的认真往下看 很久很久以前，我在使用Server的存储过程时，遇到一个问题，就是，IN(@ids)这样的语句执行不了，其实是可以执行的，很多人提出的解决方案是，EXEC(SQL)，但对于像我这样的很多人来说，本来存储过程效率高是因为他预执行了一次（据说是，没验证过），反正SQL Server肯定对他有一定的优化方案。而如果使用EXEC(SQL)... 阅读全文
posted @ 2012-02-01 10:44 perock 阅读(305) 评论(0) 推荐(0)