?? default.asp
字號:
<!-- #include virtual="/eB3KTransaction.asp" -->
<!-- #include virtual="/Server/ebo.asp" -->
<!-- #include virtual="/Server/cblib.asp" -->
<!-- #include file="../Common.asp" -->
<!-- #include virtual="/Server/SqlReport.asp" -->
<!-- #include virtual="/Server/ReportBD.asp" -->
<!-- #include virtual="/Server/rawdata.asp" -->
<HTML><HEAD><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><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/grid.js"></script>
<script src="/client/cblib.js"></script><%
dim szSQL,iListWidth,szSelect,szFrom,szWhere,szGroupBy
dim sc,pc,cc,oc,childc,childiCount,siCount,piCount,ciCount,oiCount,s,p,datefrom,dateto,memo,memotext,eboRegiCount,BillType
eboRegiCount=0
BillType=CLng(GetForm("BillType"))
dim eBD, rsCheck, x, szTableName
Set eBD = Server.CreateObject("eB3KCommon.BillDocument")
x = eBD.bdGetDetailByType(Conn, CLng(BillType), rsCheck)
if CStr(x)="0" then err.raise 10000,"SaleReport",eBD.GetLastError()
szTableName=rsCheck("TableName")
set eBD = Nothing
sc=CLng(GetForm("stockCheck"))
pc=CLng(GetForm("productCheck"))
cc=CLng(GetForm("customCheck"))
oc=CLng(GetForm("operatorCheck"))
childc=CLng(GetForm("childCheck"))
siCount=CLng(GetForm("sDetail_rows"))
piCount=CLng(GetForm("pDetail_rows"))
ciCount=CLng(GetForm("cDetail_rows"))
oiCount=CLng(GetForm("oDetail_rows"))
childiCount=CLng(GetForm("childDetail_rows"))
datefrom=GetForm("DateFrom")
dateto=GetForm("DateTo")
if len(datefrom)>0 then datefrom = DateSerial(year(datefrom), month(datefrom), day(datefrom))
if len(dateto)=0 then
dateto=now()
end if
dateto = DateSerial(year(dateto), month(dateto), day(dateto))
dateto = DateAdd("d", 1, dateto)
memo=CLng(GetForm("memoCheck"))
memotext=Cstr(GetForm("SearchMemo"))
dim SQLString
function SQLWhereOR(szField,szServerSideName,iTotalCount)
dim i, szWhere
szWhere = "("
for i = 0 to iTotalCount-1
if i > 0 then szWhere = szWhere & " OR "
szWhere = szWhere & szField & "=" & GetForm(szServerSideName & i)
next
szWhere = szWhere & ")"
SQLWhereOR=szWhere
end function
szFrom = " FROM ["&szTableName&"] AS [vt], ["&szTableName&"List] AS [vl], biCorperation"
szWhere = " WHERE [vt].[BillType]="& SQLInputParam(BillType) &" AND [vt].[ID]=[vl].[ID] AND (([vt].[AccountID]=" & AccountID &" AND [biCorperation].[ID]=" & AccountID &") OR ([vt].[AccountID]=[biCorperation].[ID] AND [biCorperation].[ParentID]="&AccountID&")) AND [vt].[IsDeleted]=0"
if childc=1 or childiCount>0 then
if childc=0 then
RptChild nothing, szFrom, szWhere, nothing
else
RptChild szSelect, szFrom, szWhere, szGroupBy
end if
if childiCount>0 then SqlWhereAdd szWhere, SQLWhereOR("[vt].[AccountID]","childDetail_0_",childiCount)
end if
if sc=1 or siCount>0 then
if sc=0 then
RptStock nothing, szFrom, szWhere, nothing
else
RptStock szSelect, szFrom, szWhere, szGroupBy
end if
if siCount>0 then SqlWhereAdd szWhere, SQLWhereOR("[vt].[Stock]","sDetail_0_",siCount)
end if
if cc=1 or ciCount>0 then
if cc=0 then
RptSCCCustom nothing, szFrom, szWhere, nothing
else
RptSCCCustom szSelect, szFrom, szWhere, szGroupBy
end if
if ciCount>0 then SqlWhereAdd szWhere, SQLWhereOR("[vt].[Organization]","cDetail_0_",ciCount)
end if
if oc=1 or oiCount>0 then
if oc=0 then
RptOperator nothing, szFrom, szWhere, nothing
else
RptOperator szSelect, szFrom, szWhere, szGroupBy
end if
if oiCount>0 then SqlWhereAdd szWhere, SQLWhereOR("[vt].[Operator]","oDetail_0_",oiCount)
end if
if pc=1 or piCount>0 then
if pc=0 then
RptProduct nothing, szFrom, szWhere, nothing
else
RptProduct szSelect, szFrom, szWhere, szGroupBy
end if
if piCount>0 then SqlWhereAdd szWhere, SQLWhereOR ("[vl].[ProductID]","pDetail_0_",piCount)
end if
SqlSelectAdd szSelect, "SUM([vl].[AuditAmount]) AS 成本, SUM([vl].[TaxAmount]) AS 金額, SUM([vl].[Quantity]) AS 數(shù)量, 0 AS 毛利, 0 AS 毛利率"
if isDate(datefrom) then SqlWhereAdd szWhere, "[vt].[UpdateDate] >='"&GetDateString(datefrom)&"'"
if isDate(dateto) then SqlWhereAdd szWhere, "[vt].[UpdateDate] <'"&GetDateString(dateto)&"'"
if memo=1 then
RptMemo szSelect, szFrom, szWhere, szGroupBy
end if
szSQL="SELECT DISTINCT " & szSelect & szFrom & szWhere
if len(szGroupBy)>0 then szSQL=szSQL & " GROUP BY " & szGroupBy
eboReg 1, "gridCols", "iCols", "", "cbLocalVariable"
eboReg 2, "gridTilte_", "szTitle", "", "cbLocalVariable"
dim iCols, 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.Count
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 = NothingResponse.Write "</script>" & VBCrLf
%>
<LINK REL=stylesheet HREF="/Client/All.css" TYPE="text/css"><script src="/Client/ebComm.js"></script><BODY>
<div>查詢時(shí)間：<%if len(datefrom)=0 then Response.Write "系統(tǒng)啟用" else Response.Write FormatDateTime(datefrom,1)%>—<%=FormatDateTime(DateAdd("d",-1,dateto),1)%></div>
<div id=SelectArea></div>
<div id=PageCtrlArea></div>
</BODY>
<script>
function ecbDetail(eo,szEvent,x,y){
if (szEvent=='MOUSECLICK'){
}
}
function getGridWidth(titleText){
switch(titleText){
case '子公司':
return 100;
break;
case '倉庫':
return 70;
break;
case '品名':
return 160;
break;
case '規(guī)格':
return 100;
break;
default:
return 80;
}
}
function getGridNumeric(titleText){
switch(titleText){
case '數(shù)量':
return 1;
break;
case '金額':
return 1;
break;
case '毛利':
return 1;
break;
case '成本':
return 1;
break;
case '單價(jià)':
return 1;
break;
default:
return 0;
}
}
function getGridAlign(titleText){
switch(titleText){
case '數(shù)量':
return 'right';
break;
case '金額':
return 'right';
break;
case '毛利':
return 'right';
break;
case '成本':
return 'right';
break;
case '毛利率':
return 'right';
break;
case '單價(jià)':
return 'right';
break;
default:
return '';
}
}
function getGridTotal(titleText){
switch(titleText){
case '數(shù)量':
return 1;
break;
case '金額':
return 1;
break;
case '毛利':
return 1;
break;
case '成本':
return 1;
break;
case '單價(jià)':
return 1;
break;
default:
return 0;
}
}
function makeGrid(indata){
var gridCols=parseInt(indata.item('gridCols'));
var gDetail = new ZYDGRID(new ZYDGRIDFORIEBUG(),SelectArea,20,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();
if (gDetail.data.length!=0){
for (var i=0;i<gDetail.data.length;i++){
for (var j=0;j<gDetail.data[i].length;j++){
if (gDetail.title[j+1].text=='金額'){
if (gDetail.title[j-1].text=='單價(jià)') gDetail.data[i][j-2]=fixFloat(parseFloat(gDetail.data[i][j])/parseFloat(gDetail.data[i][j+1]),2);
gDetail.data[i][j+2]=fixFloat(parseFloat(gDetail.data[i][j])-parseFloat(gDetail.data[i][j-1]));
if (parseFloat(gDetail.data[i][j])!=0) gDetail.data[i][j+3]=fixFloat(100*(parseFloat(gDetail.data[i][j+2])/parseFloat(gDetail.data[i][j])),2)+'%';
}
}
if (i>19) break;
}
}
gDetail.calcTotal();
gDetail.refreshAll(1,0);
return gDetail
}
var gDetail=makeGrid(IDataEnd());
</script>
</HTML>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -