08 2014 档案

常用的X++
摘要:Simple select statement examplestatic void selectExample(Args _args){CustTable custTable;int counter;;select * from custTable;while(custTable.AccountN... 阅读全文

posted @ 2014-08-23 11:28 Kobe.Zhang 阅读(238) 评论(0) 推荐(0)

输出Warning后,判断是断续
摘要:warning("test1"); if(infolog.level(1) == Exception::Info) //输出Warning后,判断是断续 { info("test2"); } else ... 阅读全文

posted @ 2014-08-21 13:45 Kobe.Zhang 阅读(114) 评论(0) 推荐(0)

ax没有distinct ,只能projId进行group by
摘要:Query query =new Query(); SysTableLookup lookup; QueryBuil dDataSource ds; TableId table=tableNum(InventTrans); FieldId field=f... 阅读全文

posted @ 2014-08-20 14:30 Kobe.Zhang 阅读(187) 评论(0) 推荐(0)

Dialog篩選數據
摘要:public void context(){ int selectMenu; FormRun formRun; Args args; Name ... 阅读全文

posted @ 2014-08-20 14:24 Kobe.Zhang 阅读(138) 评论(0) 推荐(0)

Common Functions(3)
摘要:1.获取Excl中sheet的名字SysExcelWorkbooks workbooks = application.workbooks();SysExcelWorkbook workbook;SysExcelWorksheets worksheets;SysExcelWorksh... 阅读全文

posted @ 2014-08-20 14:22 Kobe.Zhang 阅读(172) 评论(0) 推荐(0)

Common Functions (2)
摘要:1.小写金额转大写金额display str AmountCurXH(){ int len; len =strlen(num2str(FKYSL.AmountCurXH,1,16,1,1)); return global::numeralsToTxt_CN(FKY... 阅读全文

posted @ 2014-08-20 14:17 Kobe.Zhang 阅读(206) 评论(0) 推荐(0)

Common Functions(1)
摘要:1.刪除文件WinAPI::deleteFile(str filename); 2.四捨五入decRound() 3.獲取當前時間:stTime=dateTimeUtil::utcNow();dateTimeUtil::date(2013-02-02 12:01)=2013-02-02 4.quer... 阅读全文

posted @ 2014-08-20 14:11 Kobe.Zhang 阅读(309) 评论(0) 推荐(0)

返回文檔處理中的附件image
摘要:display image dispMainPic(){ docuRef docuRef; docuType docuType; image ret; ; select firstonly docuRef wher... 阅读全文

posted @ 2014-08-20 14:01 Kobe.Zhang 阅读(205) 评论(0) 推荐(0)

VB操作EXCEL文件大全
摘要:PrivateSubwriteToExcel(strTmp1()AsString,colTmp1AsCollection)''Dimtmp1Dimi1AsInteger,intColAsInteger,intRowAsIntegerDimxlAppAsNewExcel.ApplicationDimx... 阅读全文

posted @ 2014-08-18 08:58 Kobe.Zhang 阅读(6053) 评论(0) 推荐(0)

導出到Excel
摘要:void clicked(){ #Excel HWND HWND; SysExcelApplication excel; SysExcelWorkbooks books; SysExcelWorkbook book; SysExcelWorksheets shee... 阅读全文

posted @ 2014-08-16 16:26 Kobe.Zhang 阅读(193) 评论(0) 推荐(0)

导航