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 PageTotalAmount, PageTotalTaxAmount, PageTotalQuantity,TotalAmount, TotalTaxAmount,PageTotalAmount1,PageTotalAmount2,TotalAmount1,TotalAmount2
TotalAmount=0
TotalTaxAmount=0

eboReg 10,"<font size=5><b><u>变　价　单</u></b></font>","","align=center",""

eboReg 20,"日期","BillDate","","cbRSDirect"
eboReg 20,"编号","ID","","cbRSDirect"
eboReg 20,"供应商","Organization","","cbRSVenderToText"
eboReg 20,"柜组","Stock","","cbRSStockToText"
eboReg 20,"备注","BillMemo","","cbRSDirect"

eboReg 30,"编码","ProductID","width=10%","cbRSListProductToCode"
eboReg 30,"名称","ProductID","width=18%","cbRSListProductToTitle"
eboReg 30,"规格","ProductID","width=5%","cbRSListProductToSpec"
eboReg 30,"单位","ProductID","width=5%","cbRSListProductToUnit"
eboReg 30,"数量","Quantity","width=5% align=right","cbRSListDirect"
eboReg 30,"进价","Price","width=8% align=right","cbRSListDirect"
eboReg 30,"原售价","TaxPrice","width=8% align=right","cbRSListDirect"
eboReg 30,"现售价","Currency1","width=8% align=right","cbRSListDirect"
eboReg 30,"原售价金额","TaxAmount","width=8% align=right","cbRSListDirect"
eboReg 30,"现售价金额","Currency2","width=8% align=right","cbRSListDirect"
eboReg 30,"差额","Amount","width=8% align=right","cbRSListDirect"


eboReg 40,"本页小计","","colspan=8",""
eboReg 40,"原售价金额","PageTotalAmount1","align=right","cbLocalVariable"
eboReg 40,"现售价金额","PageTotalAmount2","align=right","cbLocalVariable"
eboReg 40,"金额","PageTotalAmount","align=right","cbLocalVariable"


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


eboReg 42,"金额（大写）","","",""
eboReg 42,"","szRMBTotal","colspan=8","cbLocalVariable"
eboReg 42,"&nbsp;","","",""
eboReg 42,"&nbsp;","","",""

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,"库管","Operator","","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, 2
	eboRpt2DStart 30

	PageTotalAmount=0
	PageTotalTaxAmount=0
	PageTotalQuantity=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)
	TotalAmount1=rsBD("TaxAmount")
	TotalAmount2=rsBD("Amount")
	TotalAmount=rsBD("Currency1")
	TotalTaxAmount=rsBD("TaxAmount")
	szRMBTotal=GetRMB_Upcase(TotalAmount)
	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
	PageTotalAmount1=PageTotalAmount1+rsBDList("TaxAmount")
	PageTotalAmount2=PageTotalAmount2+rsBDList("Currency2")
	PageTotalAmount=PageTotalAmount+rsBDList("Amount")
	PageTotalTaxAmount=PageTotalTaxAmount+rsBDList("TaxAmount")
	PageTotalQuantity=PageTotalQuantity+rsBDList("Quantity")
	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,"MoveStock.Print", eBD.GetLastError()
set eBD = Nothing
%></BODY>
</HTML>