userop.cs

贸易有限公司项目管理系统(C#.NET2003),供学习参考！

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
/// <summary>
/// 黄建华（2007.9）
/// </summary>
public class UserOp
{
    
	public UserOp()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    /// <summary>
    /// 此方法用来判断用户是否存在
    /// </summary>
    /// <param name="name"></param>
    /// <returns></returns>
    public static bool judge(string name)
    {
        try
        {
            SqlConnection con =DB.createCon();
            con.Open();
            SqlCommand com = new SqlCommand("select count(*) from UserInfo where UserName=@name", con);
            //com.Parameters.Add(new SqlParameter("@name",SqlDbType.VarChar,50,name));
            SqlParameter pa = new SqlParameter("@name", SqlDbType.VarChar, 20);
            pa.Value = name;
            com.Parameters.Add(pa);
            int count = Convert.ToInt32(com.ExecuteScalar());
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        catch (Exception e)
        {
            return false;


        }

    }
    /// <summary>
    /// 此方法用于判断登陆时用户名与密码是否都正确
    /// </summary>
    /// <param name="name"></param>
    /// <param name="password"></param>
    /// <returns></returns>
    public static bool IsPass(string name, string password)
    {
        SqlConnection con = DB.createCon();
        con.Open();
        SqlCommand cmd = new SqlCommand("select count(*) from UserInfo where UserName=@name and UserPassword=@password", con);
        SqlParameter pa = new SqlParameter("@name", SqlDbType.VarChar, 20);
        pa.Value = name;
        cmd.Parameters.Add(pa);
        pa = new SqlParameter("@password", SqlDbType.VarChar, 20);
        pa.Value = password;
        cmd.Parameters.Add(pa);
        int count = Convert.ToInt32(cmd.ExecuteScalar());
        if (count > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }
   
}