RentHouseDAL/AdminService.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using RentHouseModel;
using System.Data.SqlClient;
using System.Data;
//|5|1|a|s|p|x
namespace RentHouseDAL
{
    public static class AdminService
    {
        public static int AddAdmin(Admin admin)
        {
            string sql = "insert into Admins values(@AdminName,@Password,@Rank)";
            SqlParameter[] para = new SqlParameter[] { 
                new SqlParameter("@AdminName",admin.AdminName),
                new SqlParameter("@Password",admin.Password),
                new SqlParameter("@Rank",admin.Rank)
            };
            return DBHelper.ExecuteCommand(sql,CommandType.Text,para);
        }

        public static int DeleteAdminByAdminName(string adminname)
        {
            string sql = "delete from Admins where AdminName=@AdminName";
            SqlParameter[] para = new SqlParameter[] { 
                new SqlParameter("@AdminName",adminname)
            };
            return DBHelper.ExecuteCommand(sql, CommandType.Text, para);
        }

        public static int GetSuperCount()
        {
            string sql = "select count(*) from Admins where Rank=N'超级管理员'";
            return Convert.ToInt32(DBHelper.GetScalar(sql,CommandType.Text,null));
        }

        public static int GetNormalCount()
        {
            string sql = "select count(*) from Admins where Rank=N'普通管理员'";
            return Convert.ToInt32(DBHelper.GetScalar(sql, CommandType.Text, null));
        }

        public static Admin GetAdminByAdminName(string adminname)
        {
            Admin admin = new Admin();
            string sql = "select * from Admins where AdminName=@AdminName";
            SqlParameter[] para = new SqlParameter[]{
                new SqlParameter("@AdminName", adminname)
            };
            using (SqlDataReader reader = DBHelper.GetReader(sql, CommandType.Text, para))
            {
                if (reader.Read())
                {
                    admin.AdminName = reader["AdminName"].ToString();
                    admin.Password = reader["Password"].ToString();
                    admin.Rank = reader["Rank"].ToString();
                }
                else