Dcube又名Dynamicube,它是一款功能超级的报表汇总插件, BS CS 程序都可应用,随意汇总任何字段合计功能,简便灵活.很多鞋服行业软件都在使用它,但它有一个致命的局域性,当查出来的数据超过1w行的时候,性能明显降下来,当超过2w行的时候,整个客户端就感觉是”死”的状态.
下面是一个在网页中使用dcube3的例子:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<SCRIPT LANGUAGE="JavaScript">
function test()
{
DCube1.style.visibility="visible";
var DCCT_UNBOUND=99;
var DCFNone=0;
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <HTML> <HEAD> <TITLE> New Document </TITLE> <META NAME= "Generator" CONTENT= "EditPlus" > <META NAME= "Author" CONTENT= "" > <META NAME= "Keywords" CONTENT= "" > <META NAME= "Description" CONTENT= "" > <SCRIPT LANGUAGE= "JavaScript" > function test() { DCube1.style.visibility= "visible" ; var DCCT_UNBOUND=99; var DCFNone=0; var DCFSum=1; var DCFAverage=2; var DCPage=4; var DCRow=2; var DCColumn=1; var DCData=3; var thisField; var trCount; DCube1.DCConnectType = DCCT_UNBOUND; DCube1.Fields.DeleteAll(); //var DCube1 = document.getElementById("Dcube1"); DCube1.DCConnectType =99; var f; f = DCube1.Fields.Add( "KHMC" , "客户名称" , DCRow); f = DCube1.Fields.Add( "SL" , "数量" ,DCData); /* f = DCube1.Fields.Add("品牌名称", "品牌", 4); f.GroupFooterCaption = "合计:"; f = DCube1.Fields.Add("大类名称", "大类", 4); f.GroupFooterCaption = "合计:"; f = DCube1.Fields.Add("季节名称", "季节", 4); f.GroupFooterCaption = "合计:";*/ DCube1.RefreshData(); DCube1.AutoDataRefresh = true ; } </SCRIPT> <script for = "DCube1" event = "FetchData" > var arrVal= new Array(2); arrVal[0]= "张三" arrVal[1]= "50" DCube1.AddRowEx(GetVBArray(arrVal)); arrVal= new Array(2); arrVal[0]= "李四" arrVal[1]= "60" DCube1.AddRowEx(GetVBArray(arrVal)); </script> <script language= "vbscript" > Function GetVBArray(arrValue) Dim Temp Dim vbArray Temp=arrValue. join ( "&#^&" ) vbArray=Split(Temp, "&#^&" ) GetVBArray = vbArray End Function </script> </HEAD> <BODY> <OBJECT id= "DCube1" style= "position:absolute;WIDTH: 100%; HEIGHT: 100%;VISIBILITY: hidden" codeBase= "Dcube3.Cab#version=3.2.1.1177" classid= "clsid:6D63F73D-3688-3000-9C0F-00A0C90F29FC" name= "DCube1" > <PARAM NAME= "_ExtentX" VALUE= "18653" /> <PARAM NAME= "_ExtentY" VALUE= "9499" /> <PARAM NAME= "DataSource" VALUE= "" /> <PARAM NAME= "RowAlignment" VALUE= "0" /> <PARAM NAME= "ColAlignment" VALUE= "0" /> <PARAM NAME= "RowStyle" VALUE= "1" /> <PARAM NAME= "ColStyle" VALUE= "1" /> <PARAM NAME= "OutlineIconAlignment" VALUE= "1" /> <PARAM NAME= "GridColor" VALUE= "12632256" /> <PARAM NAME= "BackColor" VALUE= "16777215" /> <PARAM NAME= "DCConnect" VALUE= "" /> <PARAM NAME= "DCDatabaseName" VALUE= "" /> <PARAM NAME= "CursorStyle" VALUE= "0" /> <PARAM NAME= "FieldsBackColor" VALUE= "8421504" /> <PARAM NAME= "FieldsForeColor" VALUE= "16777215" /> <PARAM NAME= "HeadingsForeColor" VALUE= "0" /> <PARAM NAME= "HeadingsBackColor" VALUE= "16777215" /> <PARAM NAME= "DCRecordSource" VALUE= "" /> <PARAM NAME= "sBackColor" VALUE= "16777215" /> <PARAM NAME= "TotalsForeColor" VALUE= "0" /> <PARAM NAME= "GridStyle" VALUE= "1" /> <PARAM NAME= "ForeColor" VALUE= "0" /> <PARAM NAME= "AllowFiltering" VALUE= "-1" /> <PARAM NAME= "AllowUserPivotFields" VALUE= "-1" /> <PARAM NAME= "LeftMargin" VALUE= "0.75" /> <PARAM NAME= "RightMargin" VALUE= "0.75" /> <PARAM NAME= "TopMargin" VALUE= "0.49" /> <PARAM NAME= "BottomMargin" VALUE= "0.49" /> <PARAM NAME= "HeaderMargin" VALUE= "0.49" /> <PARAM NAME= "FooterMargin" VALUE= "0.49" /> <PARAM NAME= "FooterCaption" VALUE= "- Page &P -" /> <PARAM NAME= "HeaderCaption" VALUE= "DynamiCube" /> <PARAM NAME= "HeaderJustification" VALUE= "1" /> <PARAM NAME= "FooterJustification" VALUE= "1" /> <PARAM NAME= "ColPageBreak" VALUE= "0" /> <PARAM NAME= "RowPageBreak" VALUE= "0" /> <PARAM NAME= "ColHeadingsOnEveryPage" VALUE= "1" /> <PARAM NAME= "RowHeadingsOnEveryPage" VALUE= "0" /> <PARAM NAME= "DCOptions" VALUE= "0" /> <PARAM NAME= "AutoDataRefresh" VALUE= "-1" /> <PARAM NAME= "PrinterColumnSpacing" VALUE= "0.01" /> <PARAM NAME= "DCConnectType" VALUE= "0" /> <PARAM NAME= "DCQueryTimeOut" VALUE= "0" /> <PARAM NAME= "SQLYearPart" VALUE= "datepart('yyyy',<field>)" /> <PARAM NAME= "SQLQuarterPart" VALUE= "datepart('q',<field>)" /> <PARAM NAME= "SQLMonthPart" VALUE= "datepart('m',<field>)" /> <PARAM NAME= "SQLWeekPart" VALUE= "datepart('ww',<field>)" /> <PARAM NAME= "BorderStyle" VALUE= "1" /> <PARAM NAME= "AllowSplitters" VALUE= "-1" /> <PARAM NAME= "QueryByPass" VALUE= "0" /> <PARAM NAME= "DataPath" VALUE= "" /> <PARAM NAME= "DataNotAvailableCaption" VALUE= "" /> <PARAM NAME= "PageFieldsVisible" VALUE= "-1" /> <PARAM NAME= "CubeBackColor" VALUE= "13160660" /> <PARAM NAME= "GroupFooterType" VALUE= "0" /> <PARAM NAME= "FooterBackColor" VALUE= "-1" /> <PARAM NAME= "FooterForeColor" VALUE= "0" /> <PARAM NAME= "HeaderBackColor" VALUE= "-1" /> <PARAM NAME= "HeaderForeColor" VALUE= "0" /> <PARAM NAME= "FilteredFieldBackColor" VALUE= "-1" /> <PARAM NAME= "FilteredFieldForeColor" VALUE= "16777215" /> <PARAM NAME= "MousePointer" VALUE= "0" /> <PARAM NAME= "LoadProgressNotifyDelay" VALUE= "1000" /> <PARAM NAME= "IncludeColorsInPrintout" VALUE= "-1" /> </OBJECT> <input type= 'button' value= '注册' onclick= "test()" /> </BODY> </HTML> |
本博客均为原创,转载请注明出处.
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步