selectadmininfo.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.Text;
using Common;
using System.Data;
namespace DataAccess
{
    public class SelectAdminInfo
    {
        CommonOperator objCommonOperator = new CommonOperator();
        public DataTable SelectAdmin(string AdminName,string AdminPassword)
        {
            DataTable BookAmerceTable = null;
            string sql = "select * from Admin where AdminName='" + AdminName + "' and AdminPassword='" + AdminPassword + "'";
            string sqlTable = "SelectAdmin";
            try
            {
                objCommonOperator.ConnectDb();
                BookAmerceTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return BookAmerceTable;
        }
        /// <summary>
        /// 查询所有的用户信息返回
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAdminuserInfo()
        {
            DataTable dminInfoTable = null;
            string sql = "select AdminID as '用户ID',AdminName as '用户名字',AdminPassword as '用户密码',AdminPopedom as '用户权限',AdminState as '是否停用'    from Admin ";
            string sqlTable = "SelectAdmin";
            try
            {
                objCommonOperator.ConnectDb();
                dminInfoTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return dminInfoTable;
        }
        /// <summary>
        /// 插入一条新的数据到Admin
        /// </summary>
        /// <param name="AdminName"></param>
        /// <param name="AdminPassword"></param>
        /// <param name="AdminPopedom"></param>
        /// <param name="AdminState"></param>
        public void InsertAdmin(string AdminName, string AdminPassword, string AdminPopedom, int AdminState)
        {
            try
            {
                string sql = "insert into Admin  values('" + AdminName + "','" + AdminPassword + "','" + AdminPopedom + "','" + AdminState + "')";
                objCommonOperator.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
        }
        /// <summary>
        /// 查询该用户名是否已经存在
        /// </summary>
        /// <param name="AdminName"></param>
        /// <returns></returns>
        public DataTable SelectAdminName(string AdminName)
        {
            DataTable BookAmerceTable = null;
            string sql = "select * from Admin where AdminName='" + AdminName + "'";
            string sqlTable = "SelectAdmin";
            try
            {
                objCommonOperator.ConnectDb();
                BookAmerceTable = objCommonOperator.Search(sql, sqlTable);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
            return BookAmerceTable;
        }
        /// <summary>
        /// 根据用户名删除用户信息
        /// </summary>
        /// <param name="AdminName"></param>
        public void delAdmin(string AdminName)
        {
            try
            {
                string sql = "DELETE FROM Admin   "
                          + "WHERE AdminName ='" + AdminName + "'";
                objCommonOperator.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
        }
        /// <summary>
        /// 更新用户所有信息
        /// </summary>
        /// <param name="ID"></param>
        /// <param name="AdminName"></param>
        /// <param name="AdminPassword"></param>
        /// <param name="AdminPopedom"></param>
        /// <param name="AdminState"></param>
        public void UpdatetAdminInfo(int ID,string AdminName, string AdminPassword, string AdminPopedom, int AdminState)
        {
            try
            {
                string sql = "update Admin "+
                              " set AdminName='" + AdminName + "',AdminPassword='" + AdminPassword + "',AdminPopedom='" + AdminPopedom + "',AdminState='" + AdminState + "'"+
                              "where AdminID =" + ID + "";
                objCommonOperator.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
        }
        /// <summary>
        /// 根据用户名修改密码
        /// </summary>
        /// <param name="AdminName"></param>
        /// <param name="AdminPassword"></param>
        public void UpdatetAdminName(string AdminName, string AdminPassword)
        {
            try
            {
                string sql = "update Admin " +
                              " set AdminPassword='" + AdminPassword + "'" +
                              "where AdminName ='" + AdminName + "'";
                objCommonOperator.Execute(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objCommonOperator.CloseDb();
            }
        }
    }
}