📄 default.asp

📁 进销存软件源代码
💻 ASP
字号:
<!-- #include virtual="/eB3KTransaction.asp" -->
<!-- #include virtual="/Server/ebo.asp" -->
<!-- #include virtual="/Server/cblib.asp" -->
<!-- #include file="../Common.asp" -->
<!-- #include virtual="/Server/resProductStock.asp" -->
<!-- #include virtual="/Server/resOrder.asp" -->
<HTML>
<HEAD><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><script src="/Client/ebComm.js"></script></HEAD>
<script src="/client/Request.js"></script>
<script src="/client/IClient.js"></script>
<BODY></BODY>
<%
sysdefinedGet = EBO_GETTOSERVER
dim SumProductCode
dim szErrorOut,cTotalAmount
SumProductCode=""
szErrorOut=""
cTotalAmount = 0
dim eBD, x, TotalCount, iCount, Amount, bdid, TaxAmount
TaxAmount = 0
TotalCount = 0
iCount = 0
Amount = 0

'eboReg
eboReg 1, "uID", "ID", "", "cbRSDirect"
eboReg 1, "Stock2", "Organization", "", "cbRSDirect"
eboReg 1, "Stock2Text", "Organization", "", "cbRSStockToText"
eboReg 1, "Stock", "Stock", "", "cbRSDirect"
eboReg 1, "StockText", "Stock", "", "cbRSStockToText"
eboReg 1, "Operator", "Operator", "", "cbRSDirect"
eboReg 1, "OperatorText", "Operator", "", "cbRSOperatorToText"
eboReg 1, "StockOp", "bigint1", "", "cbRSDirect"
eboReg 1, "StockOpText", "bigint1", "", "cbRSOperatorToText"
eboReg 1, "StockOp2", "bigint2", "", "cbRSDirect"
eboReg 1, "StockOp2Text", "bigint2", "", "cbRSOperatorToText"

eboReg 1,"UserID","nvarchar1","","cbRSDirect"
eboReg 1,"Owner","Owner","","cbRSUserToText"
eboReg 1,"Auditor","Auditor","","cbRSUserToText"
eboReg 1,"Date","BillDate","","cbRSDateToText"
eboReg 1,"Memo","BillMemo","","cbRSDirect"
eboReg 1,"Amount","Amount","","cbRSDirect"

eboReg 2,"Detail_0_","ProductID","","cbRSListDirect"
eboReg 2,"Detail_5_","Price","","cbRSListDirect"
eboReg 2,"Detail_6_", "TaxPrice", "", "cbRSListDirect"
eboReg 2,"Detail_7_","TaxRate","","cbRSListDirect"
eboReg 2,"Detail_8_","Quantity","","cbRSListDirect"
eboReg 2,"Detail_9_","Amount","","cbRSListDirect"

eboReg 2,"Detail_11_", "TaxAmount", "", "cbRSListDirect"
eboReg 2,"Detail_12_", "BillListMemo", "", "cbRSListDirect"


eboReg 11, "Stock", "Stock", "", "cbRSStockCheck"
eboReg 11, "Stock2", "Organization", "", "cbRSStockAllCheck"
eboReg 11, "Date", "BillDate", "", "cbRSDateCheck"
eboReg 11, "Memo", "BillMemo", "", "cbRSDirect"
eboReg 11, "UserID", "nvarchar1", "", "cbRSDirect"
eboReg 11, "uID", "RootID", "", "cbRSDirect"

eboReg 11, "Amount", "Amount", "", "cbLocalVariable"
eboReg 11, "TaxAmount", "TaxAmount", "", "cbLocalVariable"
eboReg 11, "Organization", "AccountID", "", "cbRSStockToAccountID"
eboReg 11, "Owner", "Owner", "", "cbLocalVariable"

eboReg 12, "Detail_0_", "ProductID", "", "cbRSListProductCheck"
eboReg 12, "Detail_5_", "Price", "", "cbRSListDirect"
eboReg 12, "Detail_6_", "TaxPrice", "", "cbRSListDirect"
eboReg 12, "Detail_7_", "TaxRate", "", "cbRSListDirect"
eboReg 12, "Detail_8_", "Quantity", "", "cbRSListDirect"
eboReg 12, "Detail_9_", "Amount", "", "cbRSListCurrencyZero"
eboReg 12, "Detail_11_", "TaxAmount", "", "cbRSListCurrencyZero"
eboReg 12, "Detail_12_", "BillListMemo", "", "cbRSListDirect"


'End

function bdAuditTitle(bdType, szTableName, rsBD)
    rsBD("Cost") = cTotalAmount
    rsBD("Auditor") = Owner
    IData2d 0,1
    eboGet 1, rsBD, nothing
	bdAuditTitle=0
end function

function bdAuditList(bdType, szTableName, rsBD, rsBDList)
        dim rs,rsCheck,szSQL,SumQuantity
		szSQL="SELECT ISNULL(SUM([Quantity]),0) AS [Quantity] FROM ["&ResourceTableNameProductStock&"] WHERE AccountID="&AccountID&" AND IsDeleted=0 AND Stock="&rsBD("Stock")&" AND ProductID="&rsBDList("ProductID")
		Set rsCheck=dbx.open(szSQL,3,4)
		SumQuantity=rsCheck("Quantity")
		if SumQuantity<Clng(rsBDList("Quantity").value) then SumProductCode=SumProductCode+resProductToProductAndPrec(rsBDList("ProductID"))&vbcrlf
		Set rsCheck=Nothing
	rsBDList("AuditQuantity")=0
	rsBDList("AuditAmount")=0
	rsBDList("AuditCost")=0
	if rsBDList("Quantity")<>0 then
		OutStock1 rsBD("Stock"), rsBD, rsBDList
		OrderOut rsBD("Organization"),rsBD,rsBDList
		rsBDList("AuditCost")=rsBDList("AuditAmount")/rsBDList("Quantity")
	end if
	eboGet 2, rsBD, rsBDList
    cTotalAmount=cTotalAmount+rsBDList("Amount")
    TotalCount=TotalCount+1
	bdAuditList=0
end function

function bdSaveTitle(bdType, bdTableName, rsBD)
    IData2d 0,11
	eboSet 11, rsBD, nothing
end function

function bdSaveList(bdType, bdTableName, rsBD, rsBDList)
	if iCount < TotalCount then
		eboSet 12, rsBD, rsBDList
		'Calculate Amount
		rsBDList("Amount")=fixFloat(rsBDList("Amount"))
		rsBDList("TaxAmount")=fixFloat(rsBDList("TaxAmount"))
		Amount=Amount+fixFloat(rsBDList("Amount"))
		TaxAmount=TaxAmount+fixFloat(rsBDList("TaxAmount"))
		'End
		iCount = iCount + 1
		bdSaveList = 0
	else
		bdSaveList = -1
	end if
end function

bdid=0
x=0
if IsNumeric(request("ID")) then
	bdid=request("ID")
	Set eBD = Server.CreateObject("eB3KCommon.BillDocument")
	IData2d 1,2
	x = eBD.bdAudit(bdid, CLng(bdType), me)
	if len(SumProductCode)<>0 then
	  err.Raise 10000,"OutStock",SumProductCode &"  数量不足！"
    end if
	if x<>0 then
		IData2d 1,12
		x = eBD.bdSave(0, CLng(45), me)
		if CStr(x)="0" then
			mySetAbort
		else
			x=1
		end if
	end if
	set eBD = Nothing
end if

%>
<script>
IClient('data','<%=x%>');
IClient('end','');
</script>
</HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -