default.asp

进销存软件源代码

<!-- #include virtual="/eB3KTransaction.asp" --><!-- #include file="../Common.asp" --><!-- #include virtual="/Server/eboRpt.asp" --><!-- #include virtual="/Server/cblib.asp" --><%
dim iCurPage, iMaxPage, iLinePerPage, iFontSize, iOLECmd
dim szSQLBD, szSQLBDList
iCurPage = 0

if Request("Preview")="1" then
	iOLECmd=7
else
	iOLECmd=6
end if

dim szRMBTotalName,szRMBTotal,szPageTotalName, szTotalName, szPrintPage
szPageTotalName=""
szTotalName="合计"
szRMBTotalName="合计金额（大写）"
iLinePerPage = 25
iFontSize = 12

dim PageTotalInAmount2,PageTotalAmount, PageTotalTaxAmount, PageTotalQuantity,PageTotalCha,PageTotalInAmount,TotalAmount, TotalTaxAmount,TotalCha,TotalAmount2
TotalAmount2=0
TotalAmount=0
TotalTaxAmount=0
TotalCha=0

eboReg 10,"<font size=5><b><u>批　发　部　退　货　单</u></b></font>","","align=center",""

eboReg 20,"编号","ID","","cbRSDirect"
eboReg 20,"供应商","Organization","","cbRSVenderToText"
eboReg 20,"仓库","Stock","","cbRSStockToText"
eboReg 20,"日期","BillDate","","cbRSDateToText"
eboReg 20,"类型","Int1","","cbRSIOTypeToText"
eboReg 20,"备注","BillMemo","","cbRSDirect"

eboReg 30,"编码","ProductID","width=13%","cbRSListProductToCode"
eboReg 30,"名称","ProductID","width=20%","cbRSListProductToTitle"
eboReg 30,"规格","ProductID","width=5%","cbRSListProductToSpec"
eboReg 30,"单位","ProductID","width=5%","cbRSListProductToUnit"
eboReg 30,"数量","Quantity","width=7% align=right","cbRSListDirect"
eboReg 30,"无税进价","Currency1","width=9% align=right","cbRSListDirect"
eboReg 30,"含税进价","Currency2","width=9% align=right","cbRSListDirect"
eboReg 30,"无税金额","Amount","width=9% align=right","cbRSListDirect"
eboReg 30,"进价金额","Currency3","width=9% align=right","cbRSListDirect"
'eboReg 30,"零售价","TaxPrice","width=8% align=right","cbRSListDirect"
'eboReg 30,"零售金额","TaxAmount","width=9% align=right","cbRSListDirect"
'eboReg 30,"税率","TaxRate","width=5% align=right","cbRSListDirect"
'eboReg 30,"进销差额","Currency4","width=9% align=right","cbRSListDirect"


eboReg 40,"本页小计","","colspan=4",""
eboReg 40,"数量","PageTotalQuantity","align=right","cbLocalVariable"
eboReg 40,"&nbsp;","","",""
eboReg 40,"&nbsp;","","",""
eboReg 40,"无税金额","PageTotalInAmount","align=right","cbLocalVariable"
eboReg 40,"进价金额","PageTotalInAmount2","align=right","cbLocalVariable"

'eboReg 40,"&nbsp;","","",""
'eboReg 40,"零售金额","PageTotalTaxAmount","align=right","cbLocalVariable"
'eboReg 40,"进销差额","PageTotalCha","align=right","cbLocalVariable"


eboReg 41,"合计","","colspan=7",""
eboReg 41,"","TotalAmount","align=right","cbLocalVariable"
eboReg 41,"","TotalAmount2","align=right","cbLocalVariable"



eboReg 42,"金额（大写）","","",""
eboReg 42,"","szRMBTotal","colspan=9","cbLocalVariable"


eboReg 50,"打印时间：" & formatdatetime(now),"","width=34% ",""
eboReg 50,"","szPrintPage","width=33% align=center","cbLocalVariable"	'第n页，共n页
eboReg 50,"【e商NetPOWER】","","width=33% align=right",""

eboReg 51,"库管","bigint1","","cbRSOperatorToText"
eboReg 51,"制单","Owner","","cbRSUserToText"
eboReg 51,"审核","Auditor","","cbRSUserToText"

dim eBD,x,bdid,iCount,iTotalCount
iCount=0

bdid=0
if IsNumeric(request("ID")) then
	bdid=request("ID")
end if

function rptPageStart(rsBD, rsBDList)
	iCurPage=iCurPage+1
	szPrintPage = "第"&iCurPage&"页，共"&iMaxPage&"页"
	response.write "<table width=100% height=100% title=bdPage border=0><tr><td class=no align=center valign=middle>"
	eboRpt 10, rsBD, rsBDList, 2
	eboRpt 20, rsBD, rsBDList, 3
	eboRpt2DStart 30

	PageTotalAmount=0
	PageTotalTaxAmount=0
	PageTotalQuantity=0
	PageTotalInAmount=0
	PageTotalInAmount2=0
	PageTotalCha=0
end function

function rptPageEnd(rsBD, rsBDList)
	eboRpt2D 40, rsBD, rsBDList
	eboRpt2D 41, rsBD, rsBDList
	eboRpt2D 42, rsBD, rsBDList
	eboRpt2DEnd
	eboRpt 50, rsBD, rsBDList, 4
	eboRpt 51, rsBD, rsBDList, 4
	eboRpt 60, rsBD, rsBDList, 2
	response.write "</td></tr></table>"
end function

function bdOpenTitle(bdType, bdTableName, rsBD)
	TotalAmount=rsBD("Amount")
	TotalAmount2=rsBD("Currency2")
	TotalTaxAmount=rsBD("TaxAmount")
	TotalCha=rsBD("Currency1")
	szRMBTotal=GetRMB_Upcase(TotalTaxAmount)
	bdOpenTitle=0
end function

function bdOpenList(bdType, bdTableName, rsBD, rsBDList)
	dim i
	if iCount=0 then
		iTotalCount=rsBDList.RecordCount
		iMaxPage = Int((iTotalCount+iLinePerPage-1)/iLinePerPage)
	end if
	if iCount Mod iLinePerPage = 0 then rptPageStart rsBD,rsBDList
	
	eboRpt2D 30, rsBD, rsBDList
	PageTotalAmount=PageTotalAmount+rsBDList("Amount")
	PageTotalTaxAmount=PageTotalTaxAmount+rsBDList("TaxAmount")
	PageTotalQuantity=PageTotalQuantity+rsBDList("Quantity")
	PageTotalInAmount=PageTotalInAmount+rsBDList("Amount")
	PageTotalInAmount2=PageTotalInAmount2+rsBDList("Currency3")	
	PageTotalCha=PageTotalCha+rsBDList("Currency4")
	iCount = iCount + 1
	
	if iCount Mod iLinePerPage = 0 then rptPageEnd rsBD,rsBDList
	if iCount=iTotalCount then
		rptPageEnd rsBD,rsBDList
	end if
	bdOpenList = 0
end function
%><HTML><HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>打印</title>
<style type="text/css">
td {font-size: <%=iFontSize%>px;border-style:solid; border-color:#000000;border-left-width:0px;border-right-width:1px;border-top-width:0px;border-bottom-width:1px;}
.no {border-style:solid;border-width:0px}
</style><script>
function start(){
	try{printWB.ExecWB(<%=iOLECmd%>,1);}catch(e){}
	window.close();
}
</script>
</head><object id="printWB" style="display:none" width=0 height=0 classid="clsid:8856F961-340A-11D0-A96B-00C04FD705A2" VIEWASTEXT></object><body topmargin=0 leftmargin=0 onload="start()"><%
Set eBD = Server.CreateObject("eB3KCommon.BillDocument")
x = eBD.bdOpen(bdid, Clng(bdType), me)
if CStr(x)="0" then err.raise 10000,"InStockJXB.Print", eBD.GetLastError()
set eBD = Nothing
%></BODY>
</HTML>