- Visual C++源码
- Visual Basic源码
- C++ Builder源码
- Java源码
- Delphi源码
- C/C++源码
- PHP源码
- Perl源码
- Python源码
- Asm源码
- Pascal源码
- Borland C++源码
- Others源码
- SQL源码
- VBScript源码
- JavaScript源码
- ASP/ASPX源码
- C#源码
- Flash/ActionScript源码
- matlab源码
- PowerBuilder源码
- LabView源码
- Flex源码
- MathCAD源码
- VBA源码
- IDL源码
- Lisp/Scheme源码
- VHDL源码
- Objective-C源码
- Fortran源码
- tcl/tk源码
- QT源码
storage.asp
资源名称:4s.rar [点击查看]
上传用户:apresys
上传日期:2021-03-30
资源大小:813k
文件大小:7k
源码类别:
WEB源码(ASP,PHP,...)
开发平台:
DOS
- <!--#include file="conn.asp"-->
- <!--#include file="checkuser.asp"-->
- <html>
- <head>
- <title>∷汽车4S店配件仓储管理系统:.</title>
- <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
- <link href="css/main.css" rel="stylesheet" type="text/css">
- <SCRIPT language=javascript src="js/selectcity.js"></script>
- <script language="JavaScript" src="js/validate.js" type="text/JavaScript"></script>
- <script language="JavaScript" src="js/type.js"></script>
- <SCRIPT language=javascript src="css/init.js"></SCRIPT>
- <style type="text/css">
- <!--
- td { font-family: "宋体"; font-size: 9pt}
- body { font-family: "宋体"; font-size: 9pt}
- select { font-family: "宋体"; font-size: 9pt}
- A {text-decoration: none; color: #336699; font-family: "宋体"; font-size: 9pt}
- A:hover {text-decoration: underline; color: #FF0000; font-family: "宋体"; font-size: 9pt}
- -->
- </style>
- <SCRIPT LANGUAGE=javascript>
- <!--
- function Juge(add1)
- {
- if (add1.storage.value == "")
- {
- alert("名称不能为空!");
- add1.storage.focus();
- return (false);
- }
- }
- function SelectAll() {
- for (var i=0;i<document.selform.selBigClass.length;i++) {
- var e=document.selform.selBigClass[i];
- e.checked=!e.checked;
- }
- }
- //-->
- </script>
- </HEAD>
- <BODY topMargin=0 rightMargin=0 leftMargin=0>
- <!--#include file="top.asp"--><% dim sql,rs
- select case request("action")
- case "add"
- call SaveAdd()
- case "modify"
- call SaveModify()
- case "del"
- call delCate()
- case "edit"
- isEdit=True
- call myform(isEdit)
- case else
- isEdit=False
- call myform(isEdit)
- end select
- sub SaveAdd
- set rs=server.createobject("adodb.recordset")
- sql="select * from storage where storage='"&trim(request.Form("storage"))&"'"
- rs.open sql,conn,1,3
- if not rs.eof then
- response.Write "<script language=javascript>alert('已经有相同货架存在!');</script>"
- response.write "<meta http-equiv=""refresh"" content=""0;url=storage.asp"">"
- response.end
- else
- rs.addnew
- rs("storage") = trim(request.Form("storage"))
- rs.update
- end if
- rs.close
- set rs=nothing
- response.Write "<script language=javascript>alert('添加成功!');</script>"
- response.write "<meta http-equiv=""refresh"" content=""0;url=storage.asp"">"
- response.end
- end sub
- sub SaveModify
- set rs=server.createobject("adodb.recordset")
- sql="select * from storage where id="&request.Form("id")
- rs.open sql,conn,1,3
- rs("storage") = trim(request.Form("storage"))
- rs.update
- rs.close
- set rs=nothing
- response.Write "<script language=javascript>alert('修改成功!');</script>"
- response.write "<meta http-equiv=""refresh"" content=""0;url=storage.asp"">"
- response.end
- rs.close
- set rs=nothing
- end sub
- sub delCate()
- conn.execute("delete from storage where id in ("&Request.Form("selBigClass")&")")
- response.Write "<script language=javascript>alert('删除成功!');</script>"
- response.write "<meta http-equiv=""refresh"" content=""0;url=storage.asp"">"
- response.end
- end sub
- %> <% sub myform(isEdit) %>
- <TABLE width=98% align=center border="1" cellspacing="0" bordercolor="#D6D3CE">
- <TBODY>
- <TR>
- <td align="center" valign="top"><%if oskey="supper" or oskey="admin" then%>
- <fieldset style="width:98%"><legend>
- <%
- set rs=server.createobject("adodb.recordset")
- if isedit then
- rs.open "select * from storage where id=" & request("id"),conn,1,1
- response.write "编辑仓库"
- else
- response.write "添加仓库"
- end if %></legend>
- <table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#D4D0C8">
- <form name="add1" method="post" action="storage.asp" onSubmit="return Juge(this)" >
- <tr> <input type="Hidden" name="action" value='<% If isedit then%>modify<% Else %>add<% End If %>'>
- <% If isedit then%><input type="Hidden" name="id" value="<%=rs("id")%>"> <% End If %>
- <td height="18" align="center">仓库 <input name="storage" type="text" size="10" value='<% if isedit then
- response.write rs("storage")
- end if %>'><input type="submit" class="button" value="<% if isedit then
- response.write "编辑"
- else
- response.write "添加"
- end if %>"> </td>
- </tr>
- </form>
- </table>
- </fieldset>
- <TABLE cellSpacing=1 cellPadding=0 width="100%" border=0 >
- <TR>
- <TD height="25" align="center">仓库 列 表</TD>
- </TR>
- </TABLE>
- <form action="storage.asp" method="post" name="selform" >
- <table width="50%" border="1" cellpadding="0" cellspacing="0" bordercolor="#D4D0C8" align="center">
- <tr>
- <td align="center" valign="top">
- <fieldset style="width:95%">
- <table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#D4D0C8">
- <tr class="but">
- <td width="55%" height="18" align="center" class="but" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but'">名 称</td>
- <td width="45%" height="18" align="center" class="but" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but'">操 作</td>
- </tr>
- <%
- set rs=server.CreateObject("ADODB.RecordSet")
- rs.Source="select* from storage"
- rs.Open rs.Source,conn,1,1
- if not rs.EOF then
- do while not rs.eof
- %>
- <tr><td height="18" align="center" class="but" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but'"><a href="storage.Asp?id=<%=rs("ID")%>&action=edit"><%=rs("storage")%></a></td>
- <td height="18" align="center" class="but" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but'"><input name="selBigClass" type="checkbox" id="selBigClass" value="<%=rs("ID")%>"></td>
- </tr>
- <%
- rs.movenext
- loop
- end if
- rs.close
- set rs=nothing
- %>
- <tr><td align="center"colspan="10" height="22"><%if oskey="supper" or oskey="admin" then%>
- <input type="checkbox" name="checkbox" value="checkbox" onClick="javascript:SelectAll()"> 选择/反选
- <input onClick="{if(confirm('此操作将删除该信息!nn确定要执行此项操作吗?')){this.document.selform.submit();return true;}return false;}" type=submit value=删除 name=action2>
- <input type="Hidden" name="action" value='del'><%end if%></td></tr>
- </table>
- </fieldset>
- <%end if%>
- </td>
- </tr>
- </table>
- </form>
- </TD>
- </TR>
- </table>
- </TBODY>
- </TABLE>
- <%end sub%>
- <P>
- <TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
- <TBODY>
- <TR vAlign=center>
- <TD align=middle width="100%"><!--#include file="footer.htm"--></TD>
- </TR></TBODY></TABLE></P></BODY></HTML>