db_user.cs

这是一个很好的图书管理系统 数据库SQL2005

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using PublicClass;
using System.Data.SqlClient;

namespace DAL
{
    /// <summary>
    /// T_User表操作类
    /// </summary>
    public class DB_User
    {
        private UserModel _User;
        /// <summary>
        /// 用户实体
        /// </summary>
        public UserModel User
        {
            get { return _User; }
            set { _User = value; }
        }

        /// <summary>
        /// 检索用户信息
        /// </summary>
        /// <returns>返回用户信息</returns>
        public DataTable LoginSelect()
        {
            SqlParameter[] sqlp = new SqlParameter[] { new SqlParameter("@UserName",_User.UserName) };

            DataTable dt = SqlHelper.Select(sqlp, "T_User_Select");

            return dt;
        }

        /// <summary>
        /// 插入用户信息
        /// </summary>
        /// <returns>返回影响行数</returns>
        public int InsertUser()
        {
            SqlParameter[] sqlp = new SqlParameter[] { 
                new SqlParameter("@UserName", _User.UserName),
                new SqlParameter("@UserPwd", _User.PassWord),
                new SqlParameter("@Level", _User.Level) };

            int row = SqlHelper.Insert(sqlp, "T_User_Insert");

            return row;
        }

        /// <summary>
        /// 读取数据库中所有用户的信息
        /// </summary>
        /// <returns>返回所有用户信息</returns>
        public DataTable SelectUser()
        {
            DataTable dt = SqlHelper.Select("T_User_SelectAll");

            return dt;
        }

        public DataTable SelectUser(string id)
        {
            SqlParameter[] sqlp = new SqlParameter[] { new SqlParameter("@UserName", id) };

            DataTable dt = SqlHelper.Select(sqlp, "T_User_SelectUser");

            return dt;
        }

        /// <summary>
        /// 删除用户
        /// </summary>
        /// <returns>返回影响行数</returns>
        public int DeleteUser()
        {
            SqlParameter[] sqlp = new SqlParameter[] { new SqlParameter("@ID", _User.UserID) };

            int row = SqlHelper.Delete(sqlp,"T_User_DeleteUser");

            return row;
        }

        /// <summary>
        /// 更新用户信息
        /// </summary>
        /// <returns>返回影响行数</returns>
        public int UpdateUser()
        {
            SqlParameter[] sqlp = new SqlParameter[] { 
                new SqlParameter("@ID", _User.UserID),
            new SqlParameter("@PassWord", _User.PassWord),
            new SqlParameter("@Level", _User.Level)};

            int row = SqlHelper.Update(sqlp, "T_User_UpdateUser");

            return row;
        }

        /// <summary>
        /// 查询用户信息
        /// </summary>
        /// <returns>返回查询结果(DataTable)</returns>
        public DataTable SearchUserID()
        {
            SqlParameter[] sqlp = new SqlParameter[] { new SqlParameter("@UserID", _User.UserID) };

            DataTable dt = SqlHelper.Select(sqlp, "T_User_SearchUserID");

            return dt;
        }
    }
}