📄 item_output_over.inc
字号:
<%
'###############################################################################
'#
'# 文 件 名 : item_output_over.inc
'#
'# 创 建 人 : yaoxiaohui
'# 日 期 : 2002-12-03
'#
'# 修改历史 : ****年**月**日 ******
'# 修改内容 : *********************************
'#
'# 功能描述 : 领用函数文件
'# 版 本 : v1.0
'#
'#Copyright(c) 2001-2002 上海阿尔卡特网络支援系统有限公司
'#
'###############################################################################
'*******************************************************************************
Function SheetDetail()
dim sql, rs
sql = "select *from t_stock_master where sheet_id =" & pSheetID
set rs = Openrs(conn,sql)
if rs.EOF then
else
pNodeID = GetValue(rs,"node_id")
pDepMgr = GetValue(rs,"department_manager")
pWorksheetID = GetValue(rs,"worksheet_id")
pItemName = GetValue(rs,"item_name")
pHandover = GetValue(rs,"handover")
pReceiver = GetValue(rs,"receiver")
end if
rs.Close()
set rs = nothing
sql = "select opdate from t_stock_detail where sheet_id =" & pSheetID
pOpdate = DLookUp(conn,sql)
SheetDetail = _
"<form name=""frmSheetDetail"" method=post action=""" & sFileName & """>" & vbLF & _
"<input type=""hidden"" name=""FormAction"">" & vbLF & _
"<table cellspacing=0 cellpadding=3 width=""100%"" align=center border=0>" & vbLF & _
"<tr height=20>" & _
"<td colspan=6 bgcolor=""black"" align=center style=""color:white;font-weight:600"">领料单_" & pSheetID & "细节</td></tr>" & _
" <tr height=30 bgcolor=white>" & vbLF & _
" <td align=right colspan=1>部门：</td>" & vbLF & _
" <td>" & vbLF & _
" <select name=""node_id"" style=""width:100"">" & vbLF & _
" <option value=-1>全部</option>" & vbLF & _
SelectOptions(conn, "select *from t_node", "node_id", "node_desp", pNodeID) & vbLF & _
" </select></td>" & vbLF & _
" <td align=right>部门主管：</td>" & vbLF & _
" <td><input type=""text"" name=""department_manager"" value=""" & pDepMgr & """ size=15 maxlength=20>" & vbLF & _
" <td align=right>日期：</td>" & vbLF & _
" <td>"& DrawCal("", pOpDate, "opdate", "dateimg") &"</td>" & vbLF & _
" </tr>" & vbLF & _
" <tr height=30 bgcolor=white>" & vbLF & _
" <td align=right>工作单号：</td>" & vbLF & _
" <td><input type=""text"" name=""worksheet_id"" value=""" & pWorksheetID & """ size=15 maxlength=20>" & vbLF & _
" <td align=right colspan=1>项目名称：</td>" & vbLF & _
" <td><input type=""text"" name=""item_name"" value=""" & pItemName & """ size=15 maxlength=20>" & vbLF & _
" </tr>" & vbLF & _
" <tr height=30 bgcolor=white>" & vbLF & _
" <td align=right>发料人：</td>" & vbLF & _
" <td><input type=""text"" name=""handover"" value=""" & pHandover & """ size=15 maxlength=20>" & vbLF & _
" <td align=right>领料人：</td>" & vbLF & _
" <td><input type=""text"" name=""receiver"" value=""" & pReceiver & """ size=15 maxlength=20>" & vbLF & _
" <td></td>" & vbLF & _
" </tr>" & vbLF & _
" <tr height=10 bgcolor=white><td colspan=8></td></tr>" & vbLF & _
"</table>" & vbLF
End Function
'*******************************************************************************
Function TableHeader()
TableHeader = _
"<table cellspacing=1 cellpadding=0 width=""100%"" align=center bgcolor=silver style=""table-layout:fixed"">" & vbLF & _
"<tr style=""display:none"">" & vbLF & _
" <td width=40>这一行仅用于控制表格的宽度</td>" & vbLF & _
" <td width=100></td>" & vbLF & _
" <td width=90></td>" & vbLF & _
" <td width=60></td>" & vbLF & _
" <td width=70></td>" & vbLF & _
" <td width=70></td>" & vbLF & _
" <td width=70></td>" & vbLF & _
" <td width=70></td>" & vbLF & _
" <td width=""*""></td></tr>" & vbLF & _
"<tr height=20>" & _
"<td colspan=" & iCols & " bgcolor=""#0040a0"" align=center style=""color:white;font-weight:600"">被领用物品和设备一览</td></tr>" & _
"<tr bgcolor=white>" & _
"<td class=tdHead align=center> 序号</td>" & _
"<td class=tdHead align=center> <img src=""../images/bg/ar-y.gif"" width=8 height=8> 物品名称</td>" & _
"<td class=tdHead align=center> 型号规格</td>" & _
"<td class=tdHead align=center> 单位</td>" & _
"<td class=tdHead align=center> 数量</td>" & _
"<td class=tdHead align=center> 单价</td>" & _
"<td class=tdHead align=center> 存货仓库</td>" & _
"<td class=tdHead align=center> 存货位置</td>" & _
"<td class=tdHead align=center> 备注</td>" & _
"</tr>"
End Function
'*******************************************************************************
Function TableRecords(sSQL, iCols, iRecordsPerPage, iTotalRecords, iCurrentPage, iTotalPages, sFileName, sFormParams, sSortParams)
dim sTemp : sTemp = "" ' 临时字符串变量
dim j ' 临时循环变量
'------------------------------------
' 分页所需的变量定义
'------------------------------------
Dim iCounter : iCounter = 1
Dim iPrevPage, iNextPage
Dim rowCount : rowCount = 0
'------------------------------------
' 获取数据库连接
'------------------------------------
dim rs : set rs = Openrs(conn,sSQL)
dim sGoodsID, sGoodsName, sModel, sUnit, sQuantity, sGoodsType, sDepotName, sUnitPrice, sLocation, sRemark
''response.write sSQL : response.end
' 如果未到记录尾，将记录定位到你翻到的页面的第一个记录，否则显示空行
if Not rs.EOF then
rs.move (iCurrentPage - 1) * iRecordsPerPage
end if
while not rs.EOF and iCounter <= iRecordsPerPage
rowCount = rowCount + 1
sGoodsID = rs("goods_id")
sGoodsName = rs("goods_name")
sModel = rs("model")
sUnit = rs("unit")
sQuantity = rs("quantity")
sGoodsType = rs("type_desc")
sDepotName = rs("depot_name")
sUnitPrice = rs("unit_price")
sLocation = rs("location")
sRemark = rs("remark")
sTemp = sTemp & "<tr bgcolor=white height=20>" & _
"<td align=center nowrap> " & rowCount & " </td>" & _
"<input type=""hidden"" name=""goods_id_" & rowCount & """ value=""" & sGoodsID &""">" & _
"<td align=center title=""" & sGoodsName & """ nowrap> " & sGoodsName & " </td>" & _
"<td align=center title=""" & sModel & """ nowrap> " & sModel & " </td>" & _
"<td align=center title=""" & sUnit & """ nowrap> " & sUnit & " </td>" & _
"<td align=center title=""" & sQuantity & """ nowrap> " & sQuantity & " </td>" & _
"<td align=center title=""" & sUnitPrice & """ nowrap> " & sUnitPrice & " </td>" & _
"<td align=center title=""" & sDepotName & """ nowrap> " & sDepotName & " </td>" & _
"<td align=center title=""" & sLocation & """ nowrap> " & sLocation & " </td>" & _
"<td align=center title=""" & sRemark & """ nowrap> " & sRemark & " </td>" & _
"</tr>"
iCounter = iCounter + 1
rs.movenext
wend
rs.Close()
set rs = nothing
' 填补空白行
sTemp = sTemp & WhiteRows(iCols, iCounter, iRecordsPerPage)
' 首页、前页、后页、尾页等分页信息
sTemp = sTemp & "<tr bgcolor=white height=20><td colspan=" & iCols & " align=right>" & _
Paginate(sFileName, sFormParams, sSortParams, iCurrentPage, iTotalPages) & _
" </td></tr>"
TableRecords = _
sTemp & _
"<input type=""hidden"" name=""row_count"" value=""" & rowCount &""">" & _
"<input type=""hidden"" name=""sheet_id"" value=""" & pSheetID &""">" & _
" <tr height=30 bgcolor=white>" & vbLF & _
" <td colspan = 9 align=center>" & _
" <span title=""完成领用单"" style=""cursor:hand"" onmouseover=""mover();"" onmouseout=""mout();"" onclick=""btnItemadd_OnClick();"">" & _
" <img border=0 src=""../images/arrowr.gif"" style=""vertical-align:middle"">完成领用单</span>" & _
" " & vbLF & _
" <span title=""取消领用单"" style=""cursor:hand"" onmouseover=""mover();"" onmouseout=""mout();"" onclick=""btnDelete_OnClick();"">" & _
" <img border=0 src=""../images/trash.gif"" style=""vertical-align:middle"">取消领用单</span>" & _
" " & vbLF & _
" <span title=""返回出入库单管理界面！"" style=""cursor:hand"" onmouseover=""mover();"" onmouseout=""mout();"" onclick=""btnCancel_OnClick();"">" & _
" <img border=0 src=""../images/delete.gif"" style=""vertical-align:middle"">返回</span>" & _
" </td>" & vbLF & _
" </tr>" & _
"</form>"
End Function
'*******************************************************************************
Function ItemOutput()
dim pQuantity, sQuantity, sMinQ
dim pRemindID : pRemindID = ""
dim rowCount : rowCount = GetParam("row_count") ''记录数
dim iCount : iCount = 1
dim sql, sql2, sql3, rs
while iCount <= Cint(rowCount)
pGoodsID = GetParam("goods_id_" & iCount)
sql = "select quantity from t_stock_detail" & _
" where goods_id = " & ToSQL(pGoodsID,"number") & _
" and sheet_id =" & ToSQL(pSheetID,"number")
'response.write sql & "<br>" : response.end
pQuantity = DLookUp(conn,sql)
sql2 = "select quantity,min_quantity from t_goods where goods_id =" & ToSQL(pGoodsID,"number")
set rs = Openrs(conn,sql2)
if rs.EOF then
else
sQuantity = GetValue(rs,"quantity")
sMinQ = GetValue(rs,"min_quantity")
end if
if (sQuantity - pQuantity) > 0 then
sql3 = "update t_goods set quantity ="& ToSQL(sQuantity - pQuantity,"number") & _
" where goods_id =" & ToSQL(pGoodsID,"number")
call Openrs(conn,sql3)
else
sql3 = "update t_goods set current_status = 5,quantity ="& ToSQL(sQuantity - pQuantity,"number") & _
" where goods_id =" & ToSQL(pGoodsID,"number")
call Openrs(conn,sql3)
end if
'response.write sMinQ :response.end
if sMinQ <> "" then
if (sQuantity - pQuantity) < sMinQ then
sql = "update t_goods set remind_status = 2 where goods_id =" & ToSQL(pGoodsID,"number")
call Openrs(conn,sql)
pRemindID = pGoodsID & "," & pRemindID
end if
end if
iCount = iCount + 1
wend
sql = "update t_stock_master set sheet_status = 1" & _
",node_id=" & ToSQL(pNodeID,"Text") & _
",department_manager=" & ToSQL(pDepMgr,"text") & _
",handover=" & ToSQL(pHandover,"text") & _
",receiver=" & ToSQL(pReceiver,"text") & _
",worksheet_id=" & ToSQL(pWorksheetID,"text") & _
",item_name=" & ToSQL(pItemName,"text") & _
" where sheet_id =" & ToSQL(pSheetID,"number")
call Openrs(conn,sql)
dim Num : Num = Len(pRemindID)
'response.write pRemindID : response.end
if Num > 0 then
pRemindID = left(pRemindID,Num - 1)
end if
Response.Write _
"<script language=""javascript"">" & vbLF & _
" alert(""清单_" & pSheetID & "所列物品已领用！"");" & vbLF & _
"</script>" & vbLF
'response.write pRemindID : response.end
response.redirect "remind.asp?goods_id=" & pRemindID & "&sheet_id=" & pSheetID
response.end
End Function
'*******************************************************************************
sub Cancel()
dim sql
sql = "update t_goods set current_status = 1 where current_status = 7"
call Openrs(conn,sql)
response.redirect "../stock/sheet_mgr.asp"
response.end
end sub
'*******************************************************************************
sub Delete()
dim sql
sql = "delete from t_stock_detail where sheet_id =" & pSheetID
call Openrs(conn,sql)
sql = "delete from t_stock_master where sheet_id =" & pSheetID
call Openrs(conn,sql)
response.redirect "../stock/sheet_mgr.asp"
response.end
end sub
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -