📄 default.asp
字号:
<!-- #include virtual="/eB3KTransaction.asp" --><!-- #include virtual="/Server/ebo.asp" --><!-- #include virtual="/Server/cblib.asp" -->
<!-- #include virtual="/Server/common.asp" --><%
dim eBP,y
Set eBP = Server.CreateObject("NaFine.Privilege")
y=eBP.PrivilegeTest(1,Clng(1009),8,me)
if CStr(y)<>"0" then err.raise 10000,"User.Open", eBP.GetLastError()
dim defaultPrintRows
defaultPrintRows = 40
function GetPrintRows(iRows,defaultPrintRows)
if iRows > defaultPrintRows then
GetPrintRows = defaultPrintRows
else
GetPrintRows = iRows
end if
end functioniListWidth = 4 'ListWidth
dim szSQL,szFind,iListWidth
dim product,YearDate
product = GetForm("product")
YearDate = GetForm("YearDate")
if not isNumeric(YearDate) then
err.Raise 10000, "BuyPlanReport", "请输入正确的年度！"
end ifszSQL = ""
'szSQL = szSQL & "SELECT Code AS [Code],(SUM(SaleQu)/SUM(AllQu)) AS [SaleRate],SUM(SaleQu) AS [SaleQuantity],SUM(AllQu) AS [AllQuantity] FROM("
szSQL = szSQL & "SELECT top 10 Code AS [Code],0 AS [SaleRate],SUM(SaleQu) AS [SaleQuantity],SUM(AllQu) AS [AllQuantity] FROM("
szSQL = szSQL & "SELECT [biProduct].[Code],-SUM(Quantity) AS SaleQu,0 AS AllQu FROM [resProductStock],[biProduct] WHERE [resProductStock].[ProductID]=[biProduct].[ID] AND [biProduct].[Code] LIKE '%" & Product & "%' AND [resProductStock].[BillType]=1 AND YEAR([resProductStock].[CreateDate])=" & YearDate & " GROUP BY [resProductStock].[ProductID],[biProduct].[Code]"
szSQL = szSQL & " UNION "
szSQL = szSQL & "SELECT [biProduct].[Code],0 AS SaleQu,SUM(Quantity) AS AllQu FROM [resProductStock],[biProduct] WHERE [resProductStock].[ProductID]=[biProduct].[ID] AND [biProduct].[Code] LIKE '%" & Product & "%' AND YEAR([resProductStock].[CreateDate])=" & YearDate & " GROUP BY [resProductStock].[ProductID],[biProduct].[Code]"
szSQL = szSQL & ") AS cml GROUP BY [Code]"
%>
<script title=User>
var iPanelx
function cbSearch(ifrid, fun, data){
if (fun=='start')
ifrid.document.title=getMainTitle();
}
function panelShow(idCtrl,idPanel,idChild,dir){
var coll=idPanel.all.tags('div');
for (i=0;i<coll.length;i++){
if (coll(i)==idChild)
coll(i).style.display='block';
else
coll(i).style.display='none';
}
idPanel.style.display='block';
var rect=idCtrl.getBoundingClientRect();
var rectPanel=idPanel.getBoundingClientRect();
idPanel.style.left=rect.left;
idPanel.style.top=rect.top;
idPanel.style.left=parseInt(idPanel.style.left)+document.body.scrollLeft;
idPanel.style.top=parseInt(idPanel.style.top)+document.body.scrollTop;
}
function panelHide(){bdPanel.style.display='none';}function gridInit(t){ t[0].text='№'; t[1].text='产品编码'; t[1].width=150; t[2].text='销售比率'; t[2].width=80; t[3].text='销售额'; t[3].width=80; t[4].text='总量'; t[4].width=80;
}function ecbDetail(eo,szEvent,x,y){// if (szEvent=='MOUSECLICK'){// var data=new Array();// if (isNaN(x)) return;// if (x<0||x>gDetail.data.length) return;// iPanelx=x
// switch(y){
// case 1:
// case 2:
// case 3:
// case 4:
// case 5:
// panelShow(eo.grid.rows(x+1).cells(y+1),bdPanel,bdPanelProduct,1);
// break;
// }// }}</script><HTML><HEAD><meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK REL=stylesheet HREF="/Client/All.css" TYPE="text/css">
<script src="/Client/ebComm.js"></script>
</HEAD><script src="/client/ebo.js"></script><script src="/client/Request.js"></script><script src="/client/IClient.js"></script>
<script src="/client/IServer.js"></script><script src="/client/grid.js"></script>
<script src="/client/print.js"></script><%'eboRegeboReg 1, "List_0_", "Code", "", "cbRSDirect"eboReg 1, "List_1_", "SaleRate", "", "cbRSDirect"eboReg 1, "List_2_", "SaleQuantity", "", "cbRSDirect"eboReg 1, "List_3_", "AllQuantity", "", "cbRSDirect"
eboReg 2, "List_rows", "i", "", "cbLocalVariable"eboReg 2, "List_cols", "iListWidth", "", "cbLocalVariable"eboReg 2, "MaxPage", "iMaxPage", "", "cbLocalVariable"'Enddim iPage,iRows,iMaxPageiMaxPage = 0iPage = GetLong(Request("Page"),1) 'default page pos'iRows = GetLong(Request("Rows"),40) 'default rowsdim eBD,rsdim i,x,szTableNamei = 0Response.Write "<script>" & VBCrLf
if szSQL <> "" then 'Set rs = Server.CreateObject("ADODB.RecordSet") 'rs.open szSQL,Conn,1,1 Set rs = dbx.opEn(szSQL,3,4)
iRows = rs.RecordCount if iRows<=0 then iRows = GetLong(Request("Rows"),40) end if
defaultPrintRows = GetPrintRows(iRows,defaultPrintRows) iMaxPage = Int((rs.RecordCount+iRows-1)/iRows) if rs.RecordCount > 0 then rs.move iPage*iRows-iRows IData2d 1,1 Do While Not rs.EOF And i < iRows eboGet 1, rs, nothing i = i + 1 rs.MoveNext Loop Set rs = Nothingend if
IData2d 0,2eboGet 2, nothing, nothingResponse.Write "</script>" & VBCrLf
%>
<BODY><div id=sTitle align=center><font size=5><b><u>销售比率分析</u></b></font></div>
<div id=sTime>年度：<%=YearDate%></div>
<div id=SelectArea></div><div id=PageCtrlArea></div><div> <input type=button value="预览" onClick=displayPrint(sTitle,sTime,<%=defaultPrintRows%>,1) id=button1 name=button1> <input type=button value="打印" onClick=displayPrint(sTitle,sTime,<%=defaultPrintRows%>,0) id=button2 name=button2></div>
<div id=bdPanel width=100 height=60 style="position:absolute; display:none; border:1 solid #000000">
</BODY><script>
requestSet('Page','<%=iPage%>');requestSet('Rows','<%=iRows%>');var indata = IDataEnd();var gDetail = new ZYDGRID(new ZYDGRIDFORIEBUG(),SelectArea,indata.item('List_rows'),indata.item('List_cols'),'100%','',0,testUndefine,testUndefine,ecbDetail);gridInit(gDetail.title);var gPageCtrl = new ZYDPAGECTRL(new ZYDPAGECTRLFORIEBUG(),PageCtrlArea,request('Page'),indata.item('MaxPage'));function mydetailproc(method,ebo){ if (method==EBO_SET){ var i,j; var rows=parseInt(indata.item(ebo.serversidename+'_rows')); var cols=parseInt(indata.item(ebo.serversidename+'_cols')); ebo.id.data.length=0; for (i=0;i<rows;i++){ ebo.id.data[i]=new Array(); for (j=0;j<cols;j++){ ebo.id.data[i][j]=indata.item(ebo.serversidename+'_'+j+'_'+i); if (j==3){
if (ebo.id.data[i][j]==0 ||ebo.id.data[i][j-1]==0) ebo.id.data[i][j-2]=0;
else
ebo.id.data[i][j-2]=fixFloat(ebo.id.data[i][j-1]/ebo.id.data[i][j],2); }
} } } return (true);}eboReg('List',gDetail,'',mydetailproc);eboSet();gDetail.refreshAll();function IClientSetSize(){ document.body.style.borderWidth=1; document.body.style.borderColor='#000000'; document.body.style.borderStyle='solid'; IClient('setSize',new Array(document.body.scrollWidth+2,document.body.scrollHeight+2));}IClientSetSize();
</script></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -