09 2011 档案

获取StringEdit中每行的值
摘要：For (I=0;I<edtProdId.getLineCount();I++) ｛ if(strlen(edtProdID.getLine(I)) == 0) Continue; ACT_tmpProductionWIPMaterial.ProdId = edtProdID.getLine(I); } 阅读全文
posted @ 2011-09-23 16:13 perock 阅读(327) 评论(0) 推荐(0)
join,group by,sum,多表联接汇总，复杂的Join语句
摘要：whileselect ItemId,sum(Qty), sum(QtySec), WrkCtrID, InventSizeId, ConfigId, InventcolorId, UnitId, UnitIdSec from _NJ_WIP GroupBy ItemId ,WrkCtrID, In... 阅读全文
posted @ 2011-09-20 11:35 perock 阅读(751) 评论(0) 推荐(0)
Query，QueryRun, Group By,多表联接汇总
摘要：void runWrkCtr() { NJ_WIP _NJ_WIP; ACT_tmpProductionWIPMaterial _tmpWIP; Int I, ctr = 0; ProdTable _ProdTable; str tmps... 阅读全文
posted @ 2011-09-20 11:26 perock 阅读(531) 评论(0) 推荐(0)
setprefix，在info框中添加节点
摘要：static void job22(Args _args) { inventtable it; int a,b,c,d; void setpre1() { setprefix("preFix1"); info("p... 阅读全文
posted @ 2011-09-20 11:20 perock 阅读(966) 评论(0) 推荐(0)
数据源中编写disp方法需加参数，否则Grid中记录会随光标变动
摘要：display transdate dispReceDate(ACT_tmpProductionWIPMaterial _ACT_tmpProductionWIPMaterial) { ACT_JobTable _Table; ACT_JobTrans _Trans; ... 阅读全文
posted @ 2011-09-20 11:17 perock 阅读(253) 评论(0) 推荐(0)
导入csv
摘要：void importxls() { #AviFiles str s,tempStr; int i,cnt,fieldCount; contain... 阅读全文
posted @ 2011-09-20 11:14 perock 阅读(305) 评论(0) 推荐(0)
导出CSV
摘要：static void ExInventMaterialType(Args _args) { InventTable _invent; #AviFiles str s,tempStr; ... 阅读全文
posted @ 2011-09-20 11:10 perock 阅读(602) 评论(0) 推荐(0)
组装query,query汇总，query字段
摘要：void runWrkCtr() { NJ_WIP _NJ_WIP; ACT_tmpProductionWIPMaterial _tmpWIP; Int I, ctr = 0; ProdTable _ProdTable; str tmps... 阅读全文
posted @ 2011-09-15 09:46 perock 阅读(443) 评论(0) 推荐(0)