user.asp

医药进销存管理系统 全代码 很详细 可惜没有数据库 可供参考

<!--#include virtual="/manage/include/top.asp"-->
		 <tr bgcolor="#dddddd">
		   <td height="1" colspan="4"></td>
		 </tr>
		 <tr>
		   <td height="34" colspan="2" bgcolor="#efefef">		     
	       <span class="style8">　<img src="/manage/images/borrow.gif"><span class="style2"><strong> 连锁店添加</strong></span></span></td>
		 </tr>
		 <tr>
		   <td height="184" colspan="4">
<%
If Session("flag")<>1 Then
  Response.Write "<script language=javascript>window.history.back();</script>"
  Response.End()
End If
Set conn=Server.CreateObject("ADODB.Connection")
conn.connectionstring="Driver={Sql Server};Server=(local);UID=sa;database=DB_lsmanage"
conn.open

if request.ServerVariables("CONTENT_LENGTH")>0 then
  UserId=trim(request("UserId"))
  UserName=trim(request("UserName"))
  UserPass=trim(request("UserPass"))
  Address=trim(request("Address"))
   mName=trim(request("mName"))
   Tel=trim(request("Tel"))
   Email=trim(request("Email"))
   YouBian=request("YouBian")
   if not isNumeric(YouBian) then
%>
<script language="javascript">
  alert("请输入有效的邮编！");
  window.history.back();
</script>
<%
response.End()
end if
   RegDate=now()
   sql="User_Add  "&UserId&",'"&UserName&"','"&UserPass&"',0,'"&Tel&"','"&mName&"','"&YouBian&"','"&Email&"','"&Address&"','"&RegDate&"' "
  set rs=conn.execute(sql)
  %>
   <script language="javascript">
   alert("成功添加连锁店!");
   window.close();
   </script>
   <%end if
set rs1=conn.execute("select max(UserId)+1 from tb_User")
%>
<form action="/manage/user/user.asp" method="post" name="uform1">
			     <p>&nbsp;</p>
			     <table width="600" border="0" align="center" cellpadding="8" cellspacing="1" bgcolor="#0099CC">
				    <tr>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>用户ID:</strong></div></td>
					  <td width="211" bgcolor="#FFFFFF"><input type="text" value="<%=rs1(0)%>" name="UserId" size="10" style="border:1px solid;border-color:#000000" readonly></td>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>用户名称:</strong></div></td>
					  <td width="180" bgcolor="#FFFFFF"><input type="text" name="UserName" size="20" style="border:1px solid;border-color:#000000"></td>
					</tr>

				    <tr>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>用户密码:</strong></div></td>
					  <td width="211" bgcolor="#FFFFFF"><input type="password" name="UserPass" size="20" style="border:1px solid;border-color:#000000"></td>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>确认密码:</strong></div></td>
					  <td width="180" bgcolor="#FFFFFF"><input type="password" name="UserPass2" size="20" style="border:1px solid;border-color:#000000"></td>
					</tr>
										
					<tr>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>联系电话:</strong></div></td>
					  <td bgcolor="#FFFFFF">
					    <input type="text" name="Tel" size="15" maxlength="12" style="border:1px solid;border-color:#000000">
					  </td>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>联系人:</strong></div></td>
					  <td bgcolor="#FFFFFF"><input type="text" name="mName" size="10" style="border:1px solid;border-color:#000000"></td>
					</tr>
					<tr>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>邮编:</strong></div></td>
					  <td bgcolor="#FFFFFF"><input type="text" name="YouBian" size="8" maxlength="6" style="border:1px solid;border-color:#000000"></td>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>Email:</strong></div></td>
					  <td width="180" bgcolor="#FFFFFF"><input type="text" name="Email" size="20" style="border:1px solid;border-color:#000000"></td>				      
					</tr>
					<tr>
					  <td bgcolor="#FFFFFF"><div align="right"><strong>地 址:</strong></div></td>
					  <td colspan="3" bgcolor="#FFFFFF"><input type="text" name="Address" size="30" style="border:1px solid;border-color:#000000"></td>
				    </tr>
					<tr bgcolor="#FFFFFF">
					  <td colspan="4" height="2">
				        <div align="center">
				          <input type="submit" name="b1" value="注　册"style="border:1px solid;border-color:#4c99d4;background:#f2ebc3" onClick="return chkfields1();">
				          　　　　&nbsp;
				          <input type="reset" name="b2" value="取　消"style="border:1px solid;border-color:#4c99d4;background:#f2ebc3">
			          </div></td>
				   </tr>
		     </table>
	</form>
<!--#include virtual="/manage/include/bottom.asp"-->