列表过滤报表使用方法.doc

一、列表控件使用方法1、栏目的预置deletefromaa_columndic_basewhereckey='0412'andcfld=N'ipriority'InsertIntoaa_columndic_base(cKey,cFld,cQryField,aptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,bFilter,bMerge,cSumType,cProjectNO,cSubID,CanModify,ReferType) Values(N'0412',N'ipriority',Null,1,N'优先级',Null,0,1,1200,1,Null,0,0,1,0,N'',0,0,0,N'none',N'U870',N'ST',1,2)InsertIntoaa_columndic_base(cKey,cFld,cQryField,aptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,bFilter,bMerge,cSumType,cProjectNO,cSubID,CanModify,ReferType) Values(N'0412',N'ipriority',Null,1,N'優先級',Null,0,1,1200,1,Null,0,0,1,0,N'zh-tw',0,0,0,N'none',N'U870',N'ST',1,2)InsertIntoaa_columndic_base(cKey,cFld,cQryField,aptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,bFilter,bMerge,cSumType,cProjectNO,cSubID,CanModify,ReferType) Values(N'0412',N'ipriority',Null,1,N'Priorty',Null,0,1,1200,1,Null,0,0,1,0,N'en-us',0,0,0,N'none',N'U870',N'ST',1,2)其中0412为栏目的标识,可以根据需要预置多个自己想要的栏目。2、列表初始化 ''此定义为窗体变量或是全局变量SetoColumn=, "0412"'以材料出库单列表的栏目为例子,0412为ckey'取数SetrstList="select"&&"fromrecordoutlist",conn,adOpenStatic,