28,390
社区成员
发帖
与我相关
我的任务
分享
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!-- #include file="../conn.asp"-->
<%
ZC_NO=trim(request.QueryString("ZC_NO"))
set rs=server.CreateObject("adodb.recordset")
Sql = "SELECT * FROM ZCOrderHDR,ZCOrderLIN where( ZCOrderHDR.ZC_NO = ZCOrderLIN.ZC_NO and ZCOrderHDR.ZC_NO='"&ZC_NO&"' ) order by ZCOrderLIN.item_NO"
rs.open sql,conn,1,3
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<link rel="stylesheet" href="../css/MFGquery.css" type="text/css" media="screen">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<title>固定資產財務編輯</title>
<body>
<div align="center">
<table border="1" cellpadding="0" cellspacing="0" bordercolor="#000000" style="border-collapse:collapse" width="100%" rules="none">
<tr style="background-image:url(../images/headerbg.gif)">
<td width="100%" height="26" class="title" align="left">固定資產財務編輯</td>
</tr>
<tr>
<td ><form method="post" action="save2.asp" onSubmit="return checkinput()">
<table border="0" width="100%" cellpadding="0" cellspacing="0" class="Tline">
<tr bgcolor="#E5ECF9">
<td align="center" style="width:8%">序號</td>
<td align="center" style="width:10%">資產編號</td>
<td align="center" style="width:10%">資產名稱</td>
<td align="center" style="width:15%">異動方式</td>
<td align="center" style="width:8%">原保管人工號</td>
<td align="center" style="width:10%">原保管人姓名</td>
<td align="center" style="width:10%">轉入保管人工號</td>
<td align="center" style="width:10%">轉入保管人姓名</td>
<td align="center" style="width:10%">剩餘價值</td>
<td align="center" style="width:10%">取得成本</td>
</tr>
<%
do while not rs.eof
%>
<tr>
<td align="center" style="width:8%"><%=rs("item_NO")+0%></td>
<td align="center" style="width:10%"><input name="zc_num<%=rs("item_NO")%>" type="text" style="width:90% " id="zc_num<%=rs("item_NO")%>" value="<%=rs("zc_num")%>" title="資產編號"></td>
<td align="center" style="width:10%"><input name="zc_name<%=rs("item_NO")%>" type="text" style="width:90% " id="zc_name<%=rs("item_NO")%>" value="<%=rs("zc_name")%>" title="資產名稱"></td>
<td align="center" style="width:13%"><input name="type<%=rs("item_NO")%>" type="text" style="width:90% " id="type<%=rs("item_NO")%>" value="<%=(rs("type"))%>" title="異動方式"></td>
<td align="center" style="width:10%"><input name="ywk_no<%=rs("item_NO")%>" type="text" style="width:90% " id="ywk_no<%=rs("item_NO")%>" value="<%=(rs("ywk_no"))%>" title="原保管人工號"></td>
<td align="center" style="width:10%"><input name="ywk_name<%=rs("item_NO")%>" type="text" style="width:90% " id="ywk_name<%=rs("item_NO")%>" value="<%=rs("ywk_name")%>" title="原保管人姓名" ></td>
<td align="center" style="width:10%"><input name="wk_no<%=rs("item_NO")%>" type="text" style="width:90% " id="wk_no<%=rs("item_NO")%>" value="<%=rs("wk_no")%>" title="轉入保管人工號"></td>
<td align="center" style="width:10%"><input name="wk_name<%=rs("item_NO")%>" type="text" style="width:90% " id="wk_name<%=rs("item_NO")%>" value="<%=rs("wk_name")%>" title="轉入保管人姓名" ></td>
<td align="center" style="width:10%"><input name="money<%=rs("item_NO")%>" type="text" style="width:90% " id="money<%=rs("item_NO")%>" value="<%=rs("money")%>" title="剩餘價值"></td>
<td align="center" style="width:10%"><input name="chengben<%=rs("item_NO")%>" type="text" style="width:90% " id="chengben<%=rs("item_NO")%>" value="<%=rs("chengben")%>" title="取得成本"></td>
</tr>
<%
rs.movenext
loop
%>
</table>
<tr>
<td colspan="2" align="center"><input type="submit" name="submit" value="修改" >
</td>
</tr>
</td>
</tr>
</table></form>
</div>
</body>
</html>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
for i=1 to request.form("id").count
response.write request.form("id").item(i)&"|"
response.write request.form("zc_num").item(i)&"|"
response.write request.form("zc_name").item(i)&"|"
'''''''获取记录其他的项目
next
参考:ASP内置对象类型属性介绍