users.cs

自己做的的一个小的邮件系统,上传上去大家一起分享一下

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;
//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

using System.Data.SqlClient;

/// <summary>
/// Users 的摘要说明
/// </summary>

//public class XiaoUser
//{
//    public string UserName;
//    public string RealName;
//    public string UserPwd;
//    public string Phone;
//    public string Birthday;
//    public string Email;
//}

public interface IUsers
{ 
     //向数据库中插入记录
    bool InsertUser(string xiaoUserName,string xiaoRealName,string xiaoUserPwd,string xiaoPhone,string xiaoBirthday,string xiaoEmail);

    //判断用户是否存在数据库中哈，这个是用在登录系统是判断地
    bool IsExists(string xiaoUserName, string xiaoUserPwd);

    //取得数据库中所有的用户
    SqlDataReader GetAllUsers();

    
}
public class Users : IUsers
{
    public bool InsertUser(string xiaoUserName, string xiaoRealName, string xiaoUserPwd, string xiaoPhone, string xiaoBirthday, string xiaoEmail)
    {
        string connStr = ConfigurationManager.ConnectionStrings["DBConnectionStrings"].ConnectionString;
        SqlConnection conn = new SqlConnection(connStr);

        try
        {
            if (conn.State.ToString() == "Closed")
                conn.Open();

            SqlCommand cmd = new SqlCommand("insert into Users (UserName,RealName,UserPwd,Phone,Birthday,Email) values (@UserName,@RealName,@UserPwd,@Phone,@Birthday,@Email)", conn);
            cmd.Parameters.Add("@UserName", SqlDbType.VarChar, 50);
            cmd.Parameters.Add("@RealName", SqlDbType.VarChar, 50);
            cmd.Parameters.Add("@UserPwd", SqlDbType.VarChar, 10);
            cmd.Parameters.Add("@Phone", SqlDbType.VarChar, 50);
            cmd.Parameters.Add("@Birthday", SqlDbType.VarChar, 255);
            cmd.Parameters.Add("@Email", SqlDbType.VarChar, 255);

            cmd.Parameters["@UserName"].Value = xiaoUserName;
            cmd.Parameters["@RealName"].Value = xiaoRealName;
            cmd.Parameters["@UserPwd"].Value = xiaoUserPwd;
            cmd.Parameters["@Phone"].Value = xiaoPhone;
            cmd.Parameters["@Birthday"].Value = xiaoBirthday;
            cmd.Parameters["@Email"].Value = xiaoEmail;

            int i = cmd.ExecuteNonQuery();
            if (i > 0)
            {
                return true;
            }
            else
            {
                return false;
            }

        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }
    }

    public bool IsExists(string xiaoUserName, string xiaoUserPwd)
    {
        string connStr = ConfigurationManager.ConnectionStrings["DBConnectionStrings"].ConnectionString;
        SqlConnection conn = new SqlConnection(connStr);
        string SqlStr = "select * from Users where UserName='" + xiaoUserName + "' and UserPwd='" + xiaoUserPwd + "'" ;
        try
        {
            if (conn.State.ToString() == "Closed")
                conn.Open();
            SqlCommand comm = new SqlCommand(SqlStr, conn);
            SqlDataReader sdr = comm.ExecuteReader();
            if (sdr.Read())
            {
                return true;
            }
            else
            {
                return false;
            }



        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }
        finally
        {

            if (conn.State.ToString() == "Open")
                conn.Close();
        }
        
          
    }

    public SqlDataReader GetAllUsers()
    {
        string connStr = ConfigurationManager.ConnectionStrings["DBConnectionStrings"].ConnectionString;
        SqlConnection conn = new SqlConnection(connStr);
        string SqlStr = "SELECT * FROM USERS ORDER BY USERID DESC";
        SqlDataReader dr=null;
        try
        {
            if (conn.State.ToString() == "Closed")
                conn.Open();
            SqlCommand comm = new SqlCommand(SqlStr, conn);
            dr = comm.ExecuteReader();
            comm.Dispose();

        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }
        return dr;

    }

	 
}
//5_1_a_s_p_x.c_o_m