AX 2009 - 随笔分类 - Sprite.z

Dynamics ax 2009 installation log

摘要：May be somebody want to start the AX journey life beginning as a newbie, firstly you need to build a AX environment to study it. Here is some suggesti... 阅读全文

posted @ 2015-05-28 10:08 Sprite.z 阅读(179) 评论(0) 推荐(0)

Ax barcode print

摘要：static void winAPI(Args _args){ str FilePathName; str labelData; int i = 1; boolean isSuccessful; FilenameFilter filter; str filePat... 阅读全文

posted @ 2014-12-27 22:40 Sprite.z 阅读(280) 评论(0) 推荐(0)

Generate SSRS report PDF file automatically in AX 2009

摘要：Remark: The AOS service running user can't be 'Network Service'(The default value), or else the web request will be deny running in batch job.static v... 阅读全文

posted @ 2014-12-19 14:38 Sprite.z 阅读(459) 评论(0) 推荐(0)

AX SSRS report data helper

摘要：While we develop a ax ssrs report often using 'Business Logic' rather than 'AX Queries'. The 'Business Logic' is base on a AX class, there is a static... 阅读全文

posted @ 2014-11-17 17:11 Sprite.z 阅读(271) 评论(0) 推荐(0)

Sending Email by System.Net.Mail in AX

摘要：We could easyly to write a method to send the mail by C#, in axapta we can use the System.Net.Mail to send mail as C#. 1 void sendMail 2 ( 3 str _Subject, 4 str _MailTo, 5 str _CCTo, 6 str _Body, 7 str _Attachment 8 ) 9 { 10 System.Net.Mail.MailAddress ... 阅读全文

posted @ 2013-08-22 09:00 Sprite.z 阅读(1012) 评论(0) 推荐(0)

Find the tables extending a specific extended data type

摘要：Recently I was instructed to updated a table field, It is easy to write a simple statement to complete the task. But I have no idea about that there may be some tables having the same field in the system. So I writed a job to verify mine suspicious. 1 static void Jinn_FindExtendedType(Args _args) .. 阅读全文

posted @ 2013-05-31 09:28 Sprite.z 阅读(249) 评论(0) 推荐(0)

Dialog lookup method

摘要：1 public void fld1_1_lookup(FormControl _formControl, Name _ReportName) 2 { 3 Query query = new Query(); 4 QueryBuildDataSource queryBuildDataSource; 5 SysTableLookup sysTableLookup; 6 FormStringControl _control = dialog.formRun().controlCalling... 阅读全文

posted @ 2012-11-15 11:19 Sprite.z 阅读(363) 评论(0) 推荐(0)

Dialog control field event

摘要：1. Use the info() method to info the control field's name. 1 protected Object dialog(DialogRunbase _dialog, boolean forceOnClient) 2 { 3 ; 4 5 dialog = super(_dialog, forceOnClient); 6 7 dlg_field1 = dialog.addFieldValue(Types::String, g_Value); 8 9 info(dlg_field1.name()); //The ... 阅读全文

posted @ 2012-11-13 15:59 Sprite.z 阅读(323) 评论(0) 推荐(0)

Connected to Ax AOS by code

摘要：1 public Axapta Logon() 2 { 3 // NameValueCollection settings = (NameValueCollection)System.Configuration.ConfigurationSettings.GetConfig("AXConnection "); 4 string username = System.Configuration.ConfigurationSettings.AppSettings["UserName"].ToString(); 5 string password = Syste 阅读全文

posted @ 2012-11-13 09:54 Sprite.z 阅读(261) 评论(0) 推荐(0)

微软Axapta中PDF支持中文

摘要：微软Axapta中PDF不支持中文，但字体设置成嵌入式字体，只要将字体改成以下字体就可以了。Arial Unicode MS来自官方的说明：http://support.microsoft.com/kb/945075 阅读全文

posted @ 2012-11-13 09:52 Sprite.z 阅读(204) 评论(0) 推荐(0)

通过COM发送邮件而不跳出安全警告

摘要：1 void EmailExtendedMAPISendMail()//不会跳出安全警告框,嘿嘿 2 { 3 MapiEx mapiEx; 4 MapiExMail mapiExMail; 5 boolean mapiInitialised; 6 COM outlookNameSpace; 7 COM outlook; 8 COM folder; 9 COM ... 阅读全文

posted @ 2012-11-13 09:50 Sprite.z 阅读(457) 评论(0) 推荐(0)

SSRS传递参数（转载）

摘要：1 //有时想通过AX直接传入参数给SRS报表获取数据，可以使用如下方式 2 3 void run() 4 { 5 MenuFunction VendRptMI; 6 Args Args; 7 ; 8 9 VendRptMI = new MenuFunction(menuItemOutputStr(IWS_PurchOrderSRS),MenuItemType::Output);10 Args = new Args();11 Args.parm("PurchOrder_PurchId=00000043_062");//传递单个参数12 13... 阅读全文

posted @ 2012-10-25 15:32 Sprite.z 阅读(1677) 评论(0) 推荐(0)

SSRS报表创建步骤（转载）

摘要：1，打开AOT，新建一个Query,如图2，打开vs2008，新建一个Dynamics AX Reporting Project3,在项目中添加一个Dynamics model file4,新增一个report5，设计报表，添加在AX中新增的Query，设置参数，设计报表样式，和显示数据6，设计完成后，Sava to AOD7，回到AX系统，打开AOT，展开Report Libraries，找到在vs中设计的报表库,然后右键，部署该报表库8，部署完成后，添加到菜单上，并通过菜单打开报表，查看效果转自：http://www.cnblogs.com/dingkui/archive/2012/10/ 阅读全文

posted @ 2012-10-25 15:22 Sprite.z 阅读(477) 评论(0) 推荐(0)

Example：Import sales journal from excel by code

摘要：1 //生成导入模板 2 void creatTemplate() 3 { 4 SysExcelApplication m_application; 5 SysExcelWorkbooks m_workbooks; 6 SysExcelWorkbook m_workbook; 7 SysExcelWorksheets m_worksheets; 8 SysExcelWorksheet m_worksheet; 9 SysExcelCells m_cells; 10 int ... 阅读全文

posted @ 2012-08-30 16:14 Sprite.z 阅读(358) 评论(0) 推荐(0)

找出包含扩展了某扩展字段的所有表

摘要：比如，已知一个扩展类型是ProjCategoryId,下面的代码将为你找出所有使用过这个扩展类型的表。 1 static void findTableWithProjCategoryId(Args _args) 2 { 3 xInfo xInfo = new xInfo(); 4 5 treeNode t = xInfo.rootNode().AOTfindChild("DataDictionary").AOTfindChild("Tables"); 6 treeNode childNode; 7 treeNode fields; 8 treenod.. 阅读全文

posted @ 2012-08-30 16:10 Sprite.z 阅读(268) 评论(0) 推荐(0)

常用API

摘要：curuserId()当前用户IDcurext()当前公司IDappl.company().ext()当前公司IDfieldid2pname(tablenum(VendTable),fieldnum(VendTable,DlvTerm)))获取字段名setFocus()获得焦点infolog.activateWindow(form.hWnd())获取窗口焦点currency::curPrice2CurPrice(Price,CurrencyCode,"USD",CurrencyDate)价格汇率转换Currency::curAmount2CurAmount();金额汇率转换阅读全文

posted @ 2012-08-30 16:10 Sprite.z 阅读(533) 评论(0) 推荐(0)

怎样用Axapta读取Ini文件的数据

摘要：在某个class（比如可以加在winAPI中）中增加如下的方法，然后调用此方法即可。 1 client static str getPrivateProfileString(str section, str key, str value, str file) 2 { 3 #WinAPI 4 #define.sizeOfStringValue(1024) 5 Binary stringValue; 6 7 DLL DLL = new DLL(#KERNELDLL); 8 DLLFunction method = ... 阅读全文

posted @ 2012-08-30 16:09 Sprite.z 阅读(215) 评论(0) 推荐(0)

在下拉框中选择数据

摘要：比如要在下拉框中显示ItemID,但是只显示ItemGroup='Group1' 且 ItemType='Bom'的物项，那么传统的使用扩展类型的方法就不使用了，因为扩展类型不能动态传递参数（Itemgroup和ITEMTYPE）。第一步，在InventTable里建立一个方法，lookupItemByItemTypeGroup。 1 client static void lookupItemByItemTypeGroup(FormStringControl lookupCtrl,ItemGroupId ItemGroupId,ItemType _ItemTYp 阅读全文

posted @ 2012-08-30 16:03 Sprite.z 阅读(517) 评论(0) 推荐(0)

自动建立销售订单

摘要：有几个Ax开头的class值得我们研究一下，下面就是调用AxSalesTable和AxSalesLine来创建销售单的例子。 1 static void main(Args args) 2 { 3 AxSalesTable axSalesTable; 4 AxSalesLine axSalesLine; 5 ; 6 // 建立销售单头 7 axSalesTable = new AxSalesTable(); 8 axSalesTable.purchOrderFormNum('CUSTPONUM'); 9 axSalesTable.cust... 阅读全文

posted @ 2012-08-30 15:59 Sprite.z 阅读(265) 评论(0) 推荐(0)

将报表打印到文件

摘要：1 static void Jinn_printter(Args _args) 2 { 3 Args m_args = new Args(); 4 SysReportRun m_reportRun; 5 printJobSettings m_printJobSettings = new printJobSettings(); 6 7 boolean isCorrect = true; 8 ; 9 try10 {11 if (winAPI::fileExists(... 阅读全文

posted @ 2012-08-30 15:56 Sprite.z 阅读(204) 评论(0) 推荐(0)

Sprite.z

随笔分类 - AX 2009

公告