Views/UserCenter/CheckUser.ashx

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ WebHandler Language="C#" Class="CheckUser" %>

using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using MicroDBHelper;

public class CheckUser : IHttpHandler, System.Web.SessionState.IRequiresSessionState
{

    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";

        string flag = "False",
                Action = context.Request.Form["action"],
                Fields = context.Request.Form["fields"];

        if (Action == "CheckUser" && !string.IsNullOrEmpty(Fields.toStringTrim()))
            flag = CheckUserName(Fields.toStringTrim());

        if (Action == "CheckEMail" && !string.IsNullOrEmpty(Fields.toStringTrim()))
            flag = CheckEMail(Fields.toStringTrim());

        context.Response.Write(flag);
    }

    private string CheckUserName(string Fields)
    {
        string flag = "False";
        try
        {
            string _sql = "select UID from UserInfo where UserName=@UserName";
            SqlParameter[] _sp ={
                                new SqlParameter("@UserName",SqlDbType.VarChar,50),
                           };
            _sp[0].Value = Fields;

            if (MsSQLDbHelper.Exists(_sql, _sp))
                flag = "此帐号已经存在。<br/> This account has already existed.";
            else
                flag = "True";
        }
        catch { }

        return flag;
    }

    private string CheckEMail(string Fields)
    {
        string flag = "False";
        try
        {
            string _sql = "select UID from UserInfo where EMail=@EMail";
            SqlParameter[] _sp ={
                                new SqlParameter("@EMail",SqlDbType.VarChar,100),
                           };
            _sp[0].Value = Fields;