?? gongxu.asp
字號:
<!--#include file="conn.asp" -->
<HTML>
<HEAD>
<TITLE></TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-color: #FFffff;
}
-->
</style>
<link href="style.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY bgcolor="#FF0000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" >
<div align="center">
<table width="100%" border="0" cellspacing="5" cellpadding="5">
<tr>
<td> <div align="right">
<% If session("admin")<>"yes" Then
response.write("系統超時，您需要<font color=red><b>重新登陸</font></b>。 ")
response.end
Else %>
您現在處于管理狀態。
<%end if%>
<strong><a href="javascript:self.location.reload();"><font color="#FF0000">刷新</font></a></strong>
</div></td>
</tr>
<tr>
<td> <strong>工序管理：</strong><br>
<br>
<%if request("delcp")<>""then
set rs=server.createobject("adodb.recordset")
id=request("id")
sql="select * from produc where id like '"&id&"' "
rs.open sql,conn,1,3
if rs.eof or rs.bof then
else%>
<script language="JavaScript" >
alert("刪除了！");
</script>
<%
rs.delete
end if
rs.close
end if%>
<%set rs=server.createobject("adodb.recordset")
sql="select * from gongxu where gid like '"&request("gid")&"'"
rs.open sql,conn,3,2
if rs.eof or rs.bof then
if request("gid")<>"" and request("name")<>"" and request("act")<>"" then
rs.addnew
rs("gid")=request("gid")
rs("name")=request("name")
if request("MONEY")="" then
rs("money")=0
else
rs("money")=request("money")
end if
rs.movenext
ms=" <b>添加成功</b>"
end if
else
ms=" <b>添加失敗，已經有了這個工序序號，請更換序號。</b>"
end if
rs.close%>
<%
'修改
if request("act2")<>"" and request("mid")<>"" and request("name2")<>"" then
set rs=server.createobject("adodb.recordset")
sql="select * from gongxu where gid like '"&request("mid")&"'"
rs.open sql,conn,3,2
if rs.eof or rs.bof then
ms2="錯誤"
else
rs("name")=request("name2")
if request("MONEY2")="" then
rs("money")=0
else
rs("money")=request("money2")
end if
rs.update
ms2=" <b>修改成功</b>"
end if
rs.close
end if
%>
<%if request("del")="yes" then
set rs=server.createobject("adodb.recordset")
id=request("id")
sql="select * from gongxu where id like '"&id&"' "
rs.open sql,conn,1,3
if rs.eof or rs.bof then
else%>
<script language="">
//question = confirm("你確認刪除嗎?")
//if (question !="0"){
//de="yes";
alert("刪除了！");
</script>
<%
rs.delete
end if
rs.close
end if%>
<%set rs=server.createobject("adodb.recordset")
sql="select * from gongxu order by gid asc"
rs.open sql,conn,3,2
if rs.eof or rs.bof then
gid=1
%>
<table width="100%" border="0" cellpadding="2" cellspacing="2" class="front">
<tr>
<td><div align="center">目前還沒有。</div></td>
</tr>
</table>
<%else
pgsize=8
page=request.querystring("page")
rs.pagesize=pgsize
pgnm=rs.pagecount
if page=""or clng(page)<1 then page=1
if clng(page)>pgnm then page=pgnm
if pgnm>0 then rs.absolutepage=page
count=0%>
<table width="100%" border="0" cellpadding="1" cellspacing="1" class="front">
<tr>
<td bgcolor="#F2EADF" ><div align="left" class="gb4">現有記錄：<font color="#FF0000"><%=rs.recordcount %></font>共<font color="#FF0000">
<%= pgnm %></font> 頁，當前頁：<font color="#0033FF"><%= page %> </font><a href=?page=1>第一頁</a> <a href=?page=<%=pgnm%>>最后一頁</a>
<a href=?page=<%=page+1%>>下一頁</a>
<a href=?page=<%=page-1%>>上一頁</a>
<strong><a href="#add"><font color="#FF0000">添加工序</font></a></strong>
</div></td>
</tr>
</table><br>
<% do while not rs.eof and count<rs.pagesize %>
<table width="100%" border="0" cellpadding="2" cellspacing="2" class="front">
<tr>
<td width="12%"><strong>序號：</strong></td>
<td width="20%"><%= rs("gid") %></td>
<td width="9%"><strong>名稱：</strong></td>
<td width="29%"><%= rs("name") %></td>
<td width="8%"><strong>工錢：</strong></td>
<td width="22%"><%=rs("money") %> <font color="#000000">元/件</font></td>
</tr>
<tr>
<td colspan="6"><div align="left"><a href="?del=yes&id=<%=rs("id")%>"><font color="#FF0000">刪除這個工序</font></a>
(請謹慎刪除) <a href="?mid=<%=rs("gid")%>&mname=<%=rs("name")%>&mmoney=<%=rs("money")%>#modi"><font color="#FF0000"><font color="#FF0000">修改這個工序</font></font></a></div>
<div align="center"></div></td>
</tr>
<tr>
<td colspan="6"><hr size="1" noshade></td>
</tr>
</table>
<%
if not rs.eof or not rs.bof then rs.movenext
count=count+1
loop
rs.movelast
gid=rs("gid")+1
end if
%>
<p class="style1"></p>
<br>
<table width="98%" border="0" cellpadding="2" cellspacing="2" class="input">
<tr>
<td>
<form name="form1" method="post" action="">
<div align="center"><br>
序號 ：
<input name="gid" type="text" id="gid" value="<%=gid%>"" size="10" maxlength="10">
名稱：
<input name="name" type="text" id="name" value="不能為空"" size="15" maxlength="15">
參照工錢：
<input name="money" type="text" id="money" value="0"" size="15" maxlength="15">
元 （0 表示再定）<br>
<input name="act" type="submit" id="act" value="添 加">
<br>
<%= ms %> <a name="add"></a>
<input name="del" type="hidden" id="del2" value="no">
<br>
<br>
</div>
</form></td>
</tr>
</table>
<br>
<table width="98%" border="0" cellpadding="2" cellspacing="2" class="input">
<tr>
<td> <form name="form1" method="post" action="">
<div align="center"><br>
序號 ：
<input name="gid2" type="text" id="gid2" value="<%=request("mid")%>"" size="10" maxlength="10" disabled>
名稱：
<input name="name2" type="text" id="name2" value="<%=request("mname")%>"" size="15" maxlength="15">
參照工錢：
<input name="money2" type="text" id="money2" value="<%=request("mmoney")%>"" size="15" maxlength="15">
元 （0 表示再定）<br>
<input name="act2" type="submit" id="act2" value="修 改">
<br>
<%= ms2 %> <a name="modi" id="modi"></a>
<input name="del" type="hidden" id="del" value="no">
<input name="mid" type="hidden" id="del3" value="<%=request("mid")%>">
<br>
<br>
</div>
</form></td>
</tr>
</table> <br>
<br>
</td>
</tr>
</table>
</div>
</BODY>
</HTML> <% rs.close
conn.close%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -