?? useradd.asp
字號:
<!--#include virtual="/manage/include/top.asp"-->
<tr bgcolor="#6699CC">
<td height="1" colspan="4"></td>
</tr>
<tr>
<td height="34" colspan="2" bgcolor="#FFCC66">
<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")
sql="insert into tb_User (UserId,UserName,UserPass,Flag,Address,Tel,YouBian,Email,Mname,RegDate) values ("&UserId&",'"&UserName&"','"&UserPass&"',0,'"&Address&"','"&Tel&"','"&YouBian&"','"&Email&"','"&Mname&"','"&RegDate&"')"
response.write sql
response.End()
set rs=server.CreateObject("adodb.recordset")
sqlstr="select * from tb_User"
rs.open sqlstr,conn,3,3
rs.addnew
rs("UserId")=UserId
rs("UserName")=UserName
rs("UserPass")=UserPass
rs("Flag")=0
rs("Address")=Address
rs("Tel")=Tel
rs("YouBian")=YouBian
rs("Email")=Email
rs("mName")=mName
rs("RegDate")=now()
rs.update
response.write "<br><center><h2><font color=blue>添加連鎖店成功!</font></h2></center>"
end if
set rs1=conn.execute("select max(UserId)+1 from tb_User")
%>
<form action="/manage/user/useradd.asp" method="post" name="form1" onSubmit="return chkfields();">
<p> </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="11" 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>Emial:</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="注 冊">
<input type="reset" name="b2" value="取 消">
</div></td>
</tr>
</table>
</form>
<script language="javascript">
function chkfields(){
if(document.form1.UserId.value==''){
alert("請輸入用戶ID");
form1.UserId.focus();
return false;
}
if(document.form1.UserName.value==''){
alert("請輸入用戶名稱");
form1.UserName.focus();
return false;
}
if(document.form1.UserPass.value==''){
alert("請輸入用戶密碼");
form1.UserPass.focus();
return false;
}
if(document.form1.UserPass2.value==''){
alert("請輸入確認密碼");
form1.UserPass2.focus();
return false;
}
if(document.form1.UserPass2.value!=document.form1.UserPass.value){
alert("兩次輸入密碼不同");
form1.UserPass2.focus();
return false;
}
if(document.form1.Tel.value==''){
alert("請輸入聯系電話");
form1.Tel.focus();
return false;
}
if(document.form1.YouBian.value==''){
alert("請輸入郵編");
form1.YouBian.focus();
return false;
}
if(document.form1.Address.value==''){
alert("地址呢?");
form1.Address.focus();
return false;
}
if(document.form1.mName.value==''){
alert("聯系人是誰?");
form1.mName.focus();
return false;
}
return true;
}
</script>
<!--#include virtual="/manage/include/bottom.asp"-->
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -