?? 復件 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 + -