📄 复件 default.asp
字号:
" GROUP BY "& szGroupBy &" [vl].[ProductID]"
szSQLjmshc = "SELECT "& szSelect &" [vl].[ProductID] AS [ProductID], 0 AS [FirstIn],0 AS [FirstAmount],0 AS [scrkQu],0 AS [scrkAmount],0 AS [thQu],0 AS [thAmount], 0 AS [phQu],0 AS [phAmount], 0 AS [zgsQu],0 AS [zgsQuAmount], 0 AS [zgsQu1],0 AS [zgsQuAmount1],0 AS [zxQu],0 AS [zxAmount],0 AS [jmsphQu],0 AS [jmshrQu],SUM([vl].[Quantity]) AS [jmshcQu],0 AS [kcQu],0 AS [kcAmount]" &_
" FROM [BdLeagueOutGoods] AS [vt],[BdLeagueOutGoodsList] AS [vl] "& szFrom &_
" WHERE [vt].[id]=[vl].[id] AND ([vt].[UpdateDate]>='"& DateFrom &"' AND [vt].[UpdateDate]<'"& DateTo &"') AND [vt].[AccountID]=1 " & szCgjmshcTj & szWhereOther1 &_
" GROUP BY "& szGroupBy &" [vl].[ProductID]"
szSQLkc = "SELECT "& szSelect &" [vt].[ProductID] AS [ProductID],0 AS [FirstIn],0 AS [FirstAmount],0 AS [scrkQu],0 AS [scrkAmount],0 AS [thQu],0 AS [thAmount], 0 AS [phQu],0 AS [phAmount], 0 AS [zgsQu],0 AS [zgsQuAmount], 0 AS [zgsQu1],0 AS [zgsQuAmount1],0 AS [zxQu],0 AS [zxAmount],0 AS [jmsphQu],0 AS [jmshrQu],0 AS [jmshcQu],SUM([vt].[Quantity]) AS [kcQu],SUM([vt].[Amount]) AS [kcAmount] " &_
" FROM [resProductStock] AS [vt] "& szFrom &_
" WHERE [VT].[IsDeleted]=0 AND (([vt].[CreateDate]<='"& GetDateString(DateTo) &"' AND [vt].[UpdateDate]>'"& GetDateString(DateTo) &"') OR ([vt].[CreateDate]<='"& GetDateString(DateTo) &"' ))" & szWhere &_
" GROUP BY "& szGroupBy &" [vt].[ProductID]"
szSQL="( "& szSQLscrk &" UNION "& szSQLth & " UNION " & szSQLph & " UNION " & szSQLzgs & " UNION " & szSQLzgs1 & " UNION " & szSQLzx & " UNION " & szSQLjmsph & " UNION " & szSQLjmshr & " UNION " & szSQLjmshc & " UNION "& szSQLkc & " )"
szSQL="SELECT "& ssSelect &" (SUM([nv].[kcQu])-(SUM([nv].[scrkQu])+SUM([nv].[zgsQu1])+sum([nv].[thQu])-SUM([nv].[phQu])-SUM([nv].[zgsQu])-SUM([nv].[zxQu])-SUM([nv].[jmsphQu])+SUM([nv].[jmshrQu])-SUM([nv].[jmshcQu]))) AS [期初库存], SUM([nv].[scrkQu]) AS [生产入库数量],sum([nv].[thQu]) AS [退货数量], SUM([nv].[phQu]) AS [配货数量],SUM([nv].[phAmount]) AS [配货金额],SUM([nv].[zgsQu]) AS [总公司调拨出库数量],SUM([nv].[zgsQuAmount]) AS [总公司调拨出库金额],SUM([nv].[zgsQu1]) AS [总公司调拨入库数量],SUM([nv].[zgsQuAmount1]) AS [总公司调拨入库金额], SUM([nv].[zxQu]) AS [直销数量],SUM([nv].[zxAmount]) AS [直销金额],SUM([nv].[jmsphQu]) AS [加盟商配货数量],SUM([nv].[jmshrQu]) AS [加盟商换入数量],SUM([nv].[jmshcQu]) AS [加盟商换出数量], SUM([nv].[kcQu]) AS [结存数量],'' AS [备注]" &_
" FROM "& szSQL &" AS [nv] " & ssGroupBy
eboReg 1, "gridCols", "iCols", "", "cbLocalVariable"
eboReg 1, "gridRows", "iRows", "", "cbLocalVariable"
eboReg 2, "gridTilte_", "szTitle", "", "cbLocalVariable"
dim iCols,iRows, szTitle, szValue
dim i,rs
Response.Write "<script>" & VBCrLf
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.open szSQL,Conn,1,1
IData2d 0,1iCols=rs.Fields.CountiRows=rs.RecordCount defaultPrintRows = GetPrintRows(iRows,defaultPrintRows)
eboGet 1, nothing, nothingIData2d 1,2for i=0 to rs.Fields.Count-1
szTitle=rs.Fields.Item(i).Name eboGet 2, nothing, nothing
next
rawGet rs
Set rs = Nothing
Response.Write "</script>" & VBCrLf
%>
<LINK REL=stylesheet HREF="/Client/All.css" TYPE="text/css"><script src="/Client/ebComm.js"></script><BODY>
<tr><td><div id=sTitle align=center><font size=5><b><u>总 公 司 进 销 存 报 表</u></b></font></div></td></tr>
<tr><td><div id=sTime>查询时间：<% Response.Write FormatDateTime(DateFrom,1) & " -- " & FormatDateTime(DateAdd("d",-1,DateTo),1) %></div></td></tr>
<tr><td><div id=SelectArea></div></td></tr>
</Table>
<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"> <input type=button value="Excel" onclick="excelClick()" ID="Button3" NAME="Button1"></div>
</BODY>
<script>
function excelClick(){
arrayToClipboard(gDetail.data,gDetail.title);
PasteToExcel('',true);
}
function ecbDetail(eo,szEvent,x,y){
if (szEvent=='MOUSECLICK'){
}
}
function getGridWidth(titleText){
switch(titleText){
case '产品编码':
return 120;
break;
case '货号':
return 50
break;
case '产品名称':
return 130;
break;
case '规格':
return 100;
break;
case '总公司调拨出库数量':
return 120;
break;
case '总公司调拨出库金额':
return 120;
break;
case '总公司调拨入库数量':
return 120;
break;
case '总公司调拨入库金额':
return 120;
break;
case '加盟商配货数量':
return 1;
break;
case '加盟商换入数量':
return 1;
break;
case '加盟商换出数量':
return 1;
break;
default:
return 80;
}
}
function getGridNumeric(titleText){
switch(titleText){
case '期初库存':
return 1;
break;
case '生产入库数量':
return;
break;
case '退货数量':
return 1;
break;
case '配货数量':
return 1;
break;
case '配货金额':
return 1;
break;
case '直销数量':
return 1;
break;
case '直销金额':
return 1;
break;
case '总公司调拨出库数量':
return 1;
break;
case '总公司调拨出库金额':
return 1;
break;
case '总公司调拨入库数量':
return 1;
break;
case '总公司调拨入库金额':
return 1;
break;
case '加盟商配货数量':
return 1;
break;
case '加盟商换入数量':
return 1;
break;
case '加盟商换出数量':
return 1;
break;
case '结存数量':
return 1;
break;
default:
return 0;
}
}
function getGridAlign(titleText){
switch(titleText){
case '期初库存':
return 'right';
break;
case '生产入库数量':
return 'right'
break;
case '退货数量':
return 'right';
break;
case '配货数量':
return 'right';
break;
case '配货金额':
return 'right';
break;
case '直销数量':
return 'right';
break;
case '直销金额':
return 'right';
break;
case '总公司调拨出库数量':
return 'right';
break;
case '总公司调拨出库金额':
return 'right';
break;
case '总公司调拨入库数量':
return 'right';
break;
case '总公司调拨入库金额':
return 'right';
break;
case '加盟商配货数量':
return 'right';
break;
case '加盟商换入数量':
return 'right';
break;
case '加盟商换出数量':
return 'right';
break;
case '结存数量':
return 'right';
break;
default:
return '';
}
}
function getGridTotal(titleText){
switch(titleText){
case '期初库存':
return 1;
break;
case '生产入库数量':
return 1;
break;
case '退货数量':
return 1;
break;
case '配货数量':
return 1;
break;
case '配货金额':
return 1;
break;
case '总公司调拨出库数量':
return 1;
break;
case '总公司调拨出库金额':
return 1;
break;
case '总公司调拨入库数量':
return 1;
break;
case '总公司调拨入库金额':
return 1;
break;
case '直销数量':
return 1;
break;
case '直销金额':
return 1;
break;
case '加盟商配货数量':
return 1;
break;
case '加盟商换入数量':
return 1;
break;
case '加盟商换出数量':
return 1;
break;
case '结存数量':
return 1;
break;
default:
return 0;
}
}
function makeGrid(indata){
var gridCols=parseInt(indata.item('gridCols'));
var gDetail = new ZYDGRID(new ZYDGRIDFORIEBUG(),SelectArea,40,gridCols,'100%','',1,testUndefine,IRAWDataEnd(),ecbDetail);
gDetail.title[0].text='№';
for (var i=0;i<gridCols;i++){
gDetail.title[i+1].text=indata.item('gridTilte_'+i);
gDetail.title[i+1].width=getGridWidth(indata.item('gridTilte_'+i));
gDetail.title[i+1].isNumeric=getGridNumeric(indata.item('gridTilte_'+i));
gDetail.title[i+1].formAlign=getGridAlign(indata.item('gridTilte_'+i));
gDetail.title[i+1].isTotal=getGridTotal(indata.item('gridTilte_'+i));
}
gDetail.calcTotal();
gDetail.refreshAll();
return gDetail
}
var gDetail=makeGrid(IDataEnd());
</script>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -