users.cs

一个出售宠物的网站,比较全面

using System;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
namespace hellopet
{
	/// <summary>
	/// users 的摘要说明。
	/// </summary>
	public class Users
	{
	    //用户登录
	    public string userLogin(string username,string password)
	    {
		SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
		SqlCommand myCommand=new SqlCommand("usersLogin",conn);
		myCommand.CommandType=CommandType.StoredProcedure;
		//传递参数
		SqlParameter parameterUsername=new SqlParameter("@username",SqlDbType.Char,10);
		parameterUsername.Value=username;
		myCommand.Parameters.Add(parameterUsername);
		
		SqlParameter parameterPassword=new SqlParameter("@password",SqlDbType.Char,10);
		parameterPassword.Value=password;
		myCommand.Parameters.Add(parameterPassword);
		//执行命令
		conn.Open();
		SqlDataReader dr=myCommand.ExecuteReader(CommandBehavior.CloseConnection);
		if(dr.Read())
		    return username;
		else
		    return string.Empty;
    
	    }
	    //用户注册
	    public void AddUsers(string username,string password,string e_mail)
	    {
		SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
	    SqlCommand myCommand=new SqlCommand("addUsers",conn);
	    myCommand.CommandType=CommandType.StoredProcedure;
	    
	    //传递参数
	    SqlParameter pUsername=new SqlParameter("@username",SqlDbType.Char,10);
	    pUsername.Value=username;
	    myCommand.Parameters.Add(pUsername);
	    SqlParameter pPassword=new SqlParameter("@password",SqlDbType.Char,10);
	    pPassword.Value=password;
	    myCommand.Parameters.Add(pPassword);
	    SqlParameter pE_mail=new SqlParameter("@e_mail",SqlDbType.Char,20);
	    pE_mail.Value=e_mail;
	    myCommand.Parameters.Add(pE_mail);
	    
	    conn.Open();
	    myCommand.ExecuteNonQuery();
	    conn.Close();
	    }
	    //查询用户是否存在
	    public SqlDataReader CheckUsername(string username)
	    {
		SqlConnection conn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
		SqlCommand myCommand=new SqlCommand("queryUsers",conn);
		myCommand.CommandType=CommandType.StoredProcedure;
		SqlParameter pUsername=new SqlParameter("@username",SqlDbType.Char,10);
		pUsername.Value=username;
		myCommand.Parameters.Add(pUsername);
		conn.Open();
		SqlDataReader da=myCommand.ExecuteReader();
		return da;
		//conn.Close();
	    }
	}
}