52,798
社区成员
发帖
与我相关
我的任务
分享
<script type="text/javascript">
function checkreg(typeid){
var keyvalue;
var errorword;
var alertword;
switch(typeid)
{
case "1":
alertword="客户";
errorword="checkusername";
keyvalue=document.form.username.value;
break;
case "2":
alertword="电话";
errorword="checktel";
keyvalue=document.form.tel.value;
break;
case "3":
alertword="邮箱";
errorword="checkemail";
keyvalue=document.form.email.value;
break;
default:
alertword="客户";
errorword="checkusername";
keyvalue=document.form.username.value;
break;
}
$.ajax({
type: "POST",
url: "checkreg.aspx",
data: {addType:'add',typeid:typeid,typename:keyvalue},
processData: true,
success: function(data)
{
if (data=="1")
{
$("#"+errorword).html("此"+ alertword +"可以添加");
}
else
{
$("#"+errorword).html("此"+ alertword +"已经存在");
}
}
});
}
</script>
<tr>
<td align="right" class="Forumrow" width="70"><b>客户姓名:</b></td>
<td width="1010" align="left" class="Forumrow"><input name="username" type="text" onblur="javascript:checkreg(1)" class="smallInput" id="username" value="<%=username%>" size="60" />
<font color='#FF0000'>*</font>
<div id="checkusername" style="color:#FF0000"></div></td>
</tr>
<tr>
<td align="right" valign="middle" class="Forumrow"><b>电 话:</b></td>
<td align="left" class="Forumrow"><input name="tel" type="text" onblur="javascript:checkreg(2)" class="smallInput" id="tel" value="<%=tel%>" size="60" />
<font color='#FF0000'>*</font><div id="checktel" style="color:#FF0000"></div></td>
</tr>
<tr>
<td align="right" valign="middle" class="Forumrow"><b>邮 箱:</b></td>
<td align="left" class="Forumrow"><input name="email" type="text" onblur="javascript:checkreg(3)" class="smallInput" id="email" value="<%=email%>" size="60" />
<font color='#FF0000'>*</font><div id="checkemail" style="color:#FF0000"></div></td>
</tr>
public partial class company_checkreg : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Request["addType"] == "add")
{
//string username = Request["username"];
DataBase DB = new DataBase();
int flag=1;
string typename = Request["typename"];
string dataword = null;
string typeid = Request["typeid"];
switch (typeid)
{
case "1":
dataword = "username";
break;
case "2":
dataword = "tel";
break;
case "3":
dataword = "email";
break;
default:
dataword = "username";
break;
}
SqlDataReader dr = DB.RunProcGetReader("caozuo 1,'customer_baseinfo','top 1 id','"+ dataword +"=''"+ typename.Trim() +"''',''");
while (dr.Read())
{
flag = 0;
}
dr.Close();
DB.Close();
Response.Write(flag);
Response.End();
}
}
}
SqlDataReader dr = DB.RunProcGetReader("caozuo 1,'customer_baseinfo','top 1 id','CHARINDEX(''" + typename.Trim() + "''," + dataword + ")>0',''");