Data_Control/sbgl_adminUser.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

namespace Data_Control
{
    public  class sbgl_adminUser:EquipmentDBConnection 
    {
        /// <summary>
        /// 从数据库中获得所有用户的详细信息
        /// </summary>
        /// <returns>包含所有用户信息的DataSet</returns>
        public DataSet adminList()
        {
            using (SqlConnection conn = this.GetEquipmentConnStr())
            {
                string sqlstr = "select ID as id,Admin_User as admin_user,"+
                    "Admin_Pwd as admin_pwd,DepartmentName as bmnr from Admin";
                conn.Open();
                SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);
                DataSet ds = new DataSet();
                da.Fill(ds);
                return ds;
            }

        }

        /// <summary>
        /// 从数据库中获取指定用户所有信息
        /// </summary>
        /// <param name="id">用户ID</param>
        /// <returns>包含指定用户信息的IDataReader</returns>
        public DataSet  admininfo(int id)
        {
            using (SqlConnection conn = this.GetEquipmentConnStr())
            {
                string sqlstr = "select * from Admin where ID= " + id;
                conn.Open();
                SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);
                DataSet ds = new DataSet();
                da.Fill (ds);
                return ds;
            }
        }
        /// <summary>
        /// 添加新用户
        /// </summary>
        /// <param name="userName">用户名</param>
        /// <param name="pwd">密码</param>
        /// <param name="popedom">权限</param>
        /// <param name="departmentID">部门编号</param>
        /// <param name="departmentName">部门名称</param>
        /// <param name="superUser">超级管理员标志</param>
        public void add_admin(string userName, string pwd, string popedom, int departmentID, string departmentName, int superUser)
        {
            using (SqlConnection conn = this.GetEquipmentConnStr())