useradapt.cs

来自「最好用的站点内容管理系统 全部源代码都有」· CS 代码 · 共 43 行

//======================================================
//==     (c)2008 aspxcms inc by NeTCMS v1.0              ==
//==          Forum:bbs.aspxcms.com                   ==
//==         Website:www.aspxcms.com                  ==
//======================================================
using System;
using System.Data;
using System.Data.SqlClient;
using NetCMS.DALFactory;
using NetCMS.Model;
using System.Text.RegularExpressions;
using System.Text;
using System.Reflection;
using NetCMS.DALProfile;
using NetCMS.Config;

namespace NetCMS.DALSQLServer
{
    class UserAdapt : DbBase, IUserAdapt
    {
        public bool isExist(string username)
        {
            SqlParameter param = new SqlParameter("@username", username);
            string sql = "select count(UserName) from " + Pre + "sys_User where UserName=@username";
            if (Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, sql, param)) != 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        public string getUserNumByUserName(string username)
        {
            SqlParameter param = new SqlParameter("@username", username);
            string sql = "select UserNum from " + Pre + "sys_User where UserName=@username";
            return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, sql, param));
        }
    }
}