⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 addyezhu.asp

📁 投资管理系统, asp+ mssql server
💻 ASP
字号:
<%
response.expires=-1
dim ThisKey
ThisKey = "e"
%>
<!--#include file="../inc/permission.asp"-->
<!--#include file="../inc/conn.asp"-->
<html>
<head>
<title>添加业主</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel=stylesheet href="../css/main.css" type="text/css">
</head>
<%
if request("submit")<>"" then
	if request("Pwd1")<>request("Pwd2") then
		response.write "请验证你输入的用户口令。<a href=# onclick='javascript:history.back(-1);'>【返回】</a>"
		response.end
	else
		Set rs=Server.CreateObject("ADODB.Recordset")
		rs.open "select * from tblYeZhuBase where Name='"&trim(request("Name"))&"' or LoginName='"&trim(request("LoginName"))&"'",conn,1,2
		if not rs.eof then
			rs.close
			Set rs=Nothing
			response.write "此用户或用户名已经存在。<a href=# onclick='javascript:history.back(-1);'>【返回】</a>"
			response.end
		else
			Set rs1=Server.CreateObject("ADODB.Recordset")
			rs1.open "select * from tblUserLogin where LoginName='"&trim(request("LoginName"))&"'",conn,1,1
			if not rs1.eof then
				rs1.close
				Set rs1=Nothing
				response.write "此用户名已经存在。<a href=# onclick='javascript:history.back(-1);'>【返回】</a>"
				response.end
			else
				rs.addnew
				rs("Name")=replace(trim(request("Name")),"'","''")
				rs("Zerenren")=replace(trim(request("Zerenren")),"'","''")
				rs("Lianxiren")=replace(trim(request("Lianxiren")),"'","''")
				rs("Tel")=replace(trim(request("Tel")),"'","''")
				rs("Address")=replace(trim(request("Address")),"'","''")
				rs("PostCode")=replace(trim(request("PostCode")),"'","''")
				rs("Fax")=replace(trim(request("Fax")),"'","''")
				rs("EMail")=replace(trim(request("EMail")),"'","''")
				rs("LoginName")=replace(trim(request("LoginName")),"'","''")
				if request("Pwd1")="" then
					rs("Pwd")=replace(trim(request("LoginName")),"'","''")
				else
					rs("Pwd")=request("Pwd1")
				end if
				rs.update
				rs.close
				Set rs=Nothing			
			%>
			<form name="returnform" action="index.asp" method="post" target="FrmRight">
				<Script language="JavaScript">
					returnform.submit();
				</Script>
			</form>
			<body onload="javascript:window.close();" onUnLoad="javascript:alert('添加业主成功!');">
			<%
			end if
		end if
	end if
else
%>
<BODY BGCOLOR="#FFFFCC">
<table border=0 cellpadding=0 cellspacing=0 width=560 align=center>
 <form name="SubmitForm" method="post" action="">
  <tr>
   <td width="80" align=center class=tdlt>单位名称</td>
   <td align=left class=tdrt><INPUT TYPE="text" NAME="Name" value="" class="input" size=26 maxlength=150></td>
   <td width="80" align=center class=tdrt>责&nbsp;任&nbsp;人</td>
   <td align=left class=tdrt><INPUT TYPE="text" NAME="Zerenren" value="" class="input" size=26 maxlength=50></td>
  </tr>
  <tr>
   <td width="80" align=center class=tdl>联&nbsp;系&nbsp;人</td>
   <td align=left class=tdr><INPUT TYPE="text" NAME="Lianxiren" value="" class="input" size=26 maxlength=150></td>
   <td width="80" align=center class=tdr>联系电话</td>
   <td align=left class=tdr><INPUT TYPE="text" NAME="Tel" value="" class="input" size=26 maxlength=50></td>
  </tr>
  <tr>
   <td width="80" align=center class=tdl>地&nbsp;&nbsp;&nbsp;&nbsp;址</td>
   <td align=left class=tdr><INPUT TYPE="text" NAME="Address" value="" class="input" size=26 maxlength=150></td>
   <td width="80" align=center class=tdr>邮政编码</td>
   <td align=left class=tdr><INPUT TYPE="text" NAME="PostCode" value="" class="input" size=26 maxlength=50></td>
  </tr>
  <tr>
   <td width="80" align=center class=tdl>传&nbsp;&nbsp;&nbsp;&nbsp;真</td>
   <td align=left class=tdr><INPUT TYPE="text" NAME="Fax" value="" class="input" size=26 maxlength=150></td>
   <td width="80" align=center class=tdr>电子邮箱</td>
   <td align=left class=tdr><INPUT TYPE="text" NAME="EMail" value="" class="input" size=26 maxlength=50></td>
  </tr>
  <tr>
   <td width="80" align=center class=tdl rowspan=2 valign=top>用&nbsp;户&nbsp;名</td>
   <td align=left class=tdr rowspan=2 valign=top><INPUT TYPE="text" NAME="LoginName" value="" class="input" size=26 maxlength=150></td>
   <td width="80" align=center class=tdr>口&nbsp;&nbsp;&nbsp;&nbsp;令</td>
   <td align=left class=tdr><INPUT TYPE="PassWord" NAME="Pwd1" value="" class="input" size=34 maxlength=50 style="font-size:9pt;"></td>
  </tr>
  <tr>
   <td width="80" align=center class=tdr>口令验证</td>
   <td align=left class=tdr><INPUT TYPE="PassWord" NAME="Pwd2" value="" class="input" size=34 maxlength=50 style="font-size:9pt;"></td>
  </tr>
  <tr>
   <td colspan=4 align=center class=tdl>
	<INPUT TYPE="submit" name="submit" value="添 加" onclick="return CheckData();" class="font9boldwhite">
	<input type="button" name="exit" value="退 出" class="font9boldwhite" onclick="javascript:window.close();">
   </td>
  </tr>
  <tr>
   <td colspan=4 align=left>
   <b>说明:</b>请注意单位名称和用户名不能重复;如果不输入口令,则口令为用户名,用户可自己修改。
   </td>
  </tr>
 </form>
</table>
</BODY>
<%end if%>
</HTML>

<script language=javascript>
function CheckData()
{	
	if(jtrim(document.SubmitForm.Name.value)==""){
		alert("请输入单位名称!");
		document.SubmitForm.Name.focus();
		return false;
	}

	if(jtrim(document.SubmitForm.LoginName.value)==""){
		alert("请输入用户名!");
		document.SubmitForm.LoginName.focus();
		return false;
	}
	return true;
}
</script>
<script language=javascript src="../inc/jtrim.js"></script>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -