设备管理系统设计和实现

84 阅读 0 评论 56 点赞

我是靠谱客的博主喜悦店员，最近开发中收集的这篇文章主要介绍设备管理系统设计和实现，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

设备管理系统设计和实现

从1月份到3月初，一直在做一个系统，之前做项目都不考虑什么架构，直接把SQL写到cs文件中，后来学会了分层架构，我想以后如果要做类似的网站肯定就这样做了。

1、架构设计，采用和微软经典的petshop架构类似的分层方式，但是考虑到不需要针对多类数据库，而且也不需要考虑过于复杂的设计，所以就简单进行这样分层

2、 Model说明,model表示数据实体，一个类与数据库中的一张表是相对应的，考虑到代码复用，这里有一个基类baseinfo，其他的类均继承该基类

BaseInfo：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace VideoWorks.ITmanage.Model
{
    
    public class BaseModel
    {
        public int ID;

        //等待插入时需要的表名
        virtual public string TableName 
        {
            get { return ""; } 
           
        }

        //插入时的字段
        virtual public string Filed
        {
            get { return ""; }
        }

        //等待插入时需要的值
        virtual public string Values 
        {
            get { return ""; } 
          
        }

        //SQL中的where条件
        virtual public string Where
        {
            get { return ""; }
        
        }

        //更新数据时sql语句中的匹配对
        virtual public string Filedpair
        {
            get { return ""; }
        }

        //查询数据时sql语句中的查询结果字段，含有中文
        virtual public string Queryfiled
        {
            get { return ""; }
        }
    }
}

派生类CharacterInfo:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace VideoWorks.ITmanage.Model
{
    public class CharacterInfo  : BaseModel 
    {
        //数据成员
        private string name;
        private string privilege;
        private int deleteflag; //对应数据库中字段, 为1表示删除,0表示正常
       

      
        //默认构造函数
        public CharacterInfo()
        {

        }

        //带参构造函数
        public CharacterInfo(string name,string privilege,int deleteflag)
        {
            this.name = name;
            this.privilege = privilege;
            this.deleteflag = deleteflag;
        }




        //get set函数

        public string Name
        {
            get { return name; }
            set { name = value; }
        }

        public string Privilege
        {
            get { return privilege; }
            set { privilege = value; }
        }

        public int Deleteflag
        {
            get { return deleteflag; }
            set { deleteflag = value; }
        }


        //重载BaseModel中的成员函数
        override public string TableName
        {
            get { return "`character`"; }
        }


        override public string Values
        {
            get
            {
                return Name+"','"+Privilege+"','"+Deleteflag;
            }
        }


        override public string Filed
        {
            get
            {
                return "(name,privilege,deleteflag)";
            }
        }

        public override string Filedpair
        {
            get
            {
                return "name='" + Name + "',privilege='" + Privilege+"', deleteflag="+Deleteflag;
            }
        }

        public override string Queryfiled
        {
            get
            {
                return "ID as 编号, name as 角色类型, privilege as 权限";
            }
        }
    }
}

3、DAL层，DAL层是直接与mysql数据库交互的层次，为BLL层提供接口，调用Model实体，同样每一个类对应数据库中的一张表，这里也有基类BaseDAL

BaseDAL：其中提供的是基本的操作

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using VideoWorks.ITmanage.Model;

namespace VideoWorks.ITmanage.DAL
{
    public class BaseDAL
    {

        //添加数据
        public bool Add(BaseModel model)
        {
            string sql = "insert into " + model.TableName + model.Filed + " values('" + model.Values + "')";

            MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sql, null);

            return true;
        }

        //删除数据，条件为ID
        public bool Delete(BaseModel model)
        {
            string sql="delete from "+model.TableName+" where ID="+model.ID;

            MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sql, null);

            return true;
        }


        //删除数据其实是更新数据表中的deleteflag字段，deleteflag为1表示已经删除
        public bool Deleteflag(BaseModel model)
        {
            string sql = "update " + model.TableName + " set deleteflag=1  where ID=" + model.ID;

            MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sql, null);

            return true;
        }


        //更新数据，条件为ID
        public bool Update(BaseModel model)
        {
            string sql = "update " + model.TableName + " set " + model.Filedpair + " where ID=" + model.ID;

            MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, sql, null);

            return true;
        }

        //查询数据，条件为ID
        public DataSet Query(BaseModel model)
        {
            string sql = "select  " + model.Queryfiled + " from " + model.TableName + " where ID=" + model.ID;

            return MySqlHelper.GetDataSet(MySqlHelper.Conn, CommandType.Text, sql, null);
        }



    }
}

派生类CharacterDAL，这里可以设置用户自定义的函数，实现更加高级的功能：

using System;
using System.Data;
using System.Configuration;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml.Linq;
using VideoWorks.ITmanage.Model;



namespace VideoWorks.ITmanage.DAL
{
    public class FilterCharacter
    {
        public string Keyword{get;set;}
        public int Deleteflag { get; set; }
        
    }


    /// <summary>
    ///Character 的摘要说明,BaseDAL基类中已经提供了对数据表的基本操作，并且都是以ID为关键字
    /// </summary>
    public class CharacterDAL: BaseDAL
    {
        public CharacterDAL()
        {
            //
            //TODO: 在此处添加构造函数逻辑
            //
        }
       
        //查询角色信息，拓展的查询条件
     
        public DataSet Query(FilterCharacter filter,BaseModel model)
        {
            string sql = "select " + model.Queryfiled + " from " + model.TableName+" where ";

            
            if(filter.Keyword !=null)
            {
                sql += " name like '%" + filter.Keyword + "%'  and ";
            }
            if(filter.Deleteflag!=-1)
            {
                sql += " deleteflag=" + filter.Deleteflag + " and ";
            }
            sql += " 1=1";

            return MySqlHelper.GetDataSet(MySqlHelper.Conn, CommandType.Text, sql, null);

        }


    }
}

4、BLL层，实现web界面和DAL层的通信，其中包括各种处理逻辑，是程序中考虑最多的地方，这里是一个类对应一个功能模块，不过考虑到程序也是按照表进行划分的，故也是按照DAL层对应划分了

CharacterBLL，实现角色功能模块的管理：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using VideoWorks.ITmanage.DAL;
using VideoWorks.ITmanage.Model;


namespace VideoWorks.ITmanage.BLL
{
    public class CharacterBLL
    {
        CharacterDAL characterop = new CharacterDAL();


        //添加新角色
        public bool Add(CharacterInfo character)
        {
            return characterop.Add(character);
        }

        //更新角色
        public bool Update(CharacterInfo character)
        {
            return characterop.Update(character);
        }

        //删除角色，其实是设置标志字段
        public bool Delete(CharacterInfo character)
        {
            return characterop.Deleteflag(character);
         
        }


        //查询角色
        public DataSet Query(FilterCharacter filter,CharacterInfo character)
        {
            return characterop.Query(filter, character);
             
        }

        //返回角色列表,添加用户时使用
        public DataSet Showlist(int flag)
        {
            CharacterInfo character = new CharacterInfo();

            FilterCharacter filter = new FilterCharacter();

            filter.Deleteflag = flag;

            return characterop.Query(filter, character);

        }

        //依据ID返回角色类型
        public string Getname(int ID)
        {
            CharacterInfo character = new CharacterInfo();

            character.ID = ID;

            return characterop.Query(character).Tables[0].Rows[0]["角色类型"].ToString();


        }

        //依据角色类型返回ID
        public int GetID(string name,int flag)
        {
            CharacterInfo character = new CharacterInfo();

            FilterCharacter filter = new FilterCharacter();

            filter.Keyword = name;

            filter.Deleteflag = flag;

            return Convert.ToInt32(characterop.Query(filter,character).Tables[0].Rows[0]["编号"].ToString());
        }


        //依据下拉框填充字符串
        public DataSet Fill(int index)
        {
            CharacterInfo character = new CharacterInfo();
           
            character.ID = index;

            return characterop.Query( character);
        }


        //判断用户是否具有用户管理权限
        public bool isuser(string name)
        {
            CharacterInfo character = new CharacterInfo();

            FilterCharacter filter = new FilterCharacter();

            filter.Keyword = name;

            filter.Deleteflag = 0;

            string right = characterop.Query(filter,character).Tables[0].Rows[0]["权限"].ToString();

            if(right[0]=='1')
            {
                return true;
            }
            else
            {
                return false;
            }
        }


        //判断用户是否具有职责管理权限
        public bool isresponse(string name)
        {
            CharacterInfo character = new CharacterInfo();

            FilterCharacter filter = new FilterCharacter();

            filter.Keyword = name;

            filter.Deleteflag = 0;

            string right = characterop.Query(filter,character).Tables[0].Rows[0]["权限"].ToString();

            if (right[2] == '1')
            {
                return true;
            }
            else
            {
                return false;
            }
        }


        //判断用户是否具有设备管理权限
        public bool ismachine(string name)
        {
            CharacterInfo character = new CharacterInfo();

            FilterCharacter filter = new FilterCharacter();

            filter.Keyword = name;

            filter.Deleteflag = 0;

            string right = characterop.Query(filter,character).Tables[0].Rows[0]["权限"].ToString();

            if (right[1] == '1')
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        //判断用户是否具有运维管理权限
        public bool isoperation(string name)
        {
            CharacterInfo character = new CharacterInfo();

            FilterCharacter filter = new FilterCharacter();

            filter.Keyword = name;

            filter.Deleteflag = 0;

            string right = characterop.Query(filter,character).Tables[0].Rows[0]["权限"].ToString();

            if (right[3] == '1')
            {
                return true;
            }
            else
            {
                return false;
            }
        }
    }
}

5、web界面

界面中比较简单，只需要调用BLL和model即可，BLL会调用DAL进行数据操作

opcharacter.cs，这里只列举一下简单的用法：

 //添加角色
        public bool Add()
        {
            if (txtname.Text.Trim() == "")
            {
                
                lblmessage.Text = "角色名称不能为空";
                lblmessage.Visible = true;

                return false;
            }

            else
            {
                string privilege = "";

                privilege += (cbxprivilege.Items[0].Selected == true) ? "1" : "0";
                privilege += (cbxprivilege.Items[1].Selected == true) ? "1" : "0";
                privilege += (cbxprivilege.Items[2].Selected == true) ? "1" : "0";
                privilege += (cbxprivilege.Items[3].Selected == true) ? "1" : "0";

                CharacterInfo character = new CharacterInfo(txtname.Text.Trim(), privilege, 0);

                CharacterBLL characterop = new CharacterBLL();

                if (characterop.Add(character) == true)
                {
                    lblmessage.Text = "角色添加成功";
                    lblmessage.Visible = true;

                    return true;
                }
                else
                {
                    lblmessage.Text = "角色添加失败";
                    lblmessage.Visible = true;

                    return false;
                }

            }
        }

        //修改角色
        public bool Update(int ID)
        {
            if (txtname.Text.Trim() == "")
            {
                lblmessage.Text = "角色名称不能为空";
                lblmessage.Visible = true;

                return false;
            }
            else
            {
                string privilege = "";

                privilege += (cbxprivilege.Items[0].Selected == true) ? "1" : "0";
                privilege += (cbxprivilege.Items[1].Selected == true) ? "1" : "0";
                privilege += (cbxprivilege.Items[2].Selected == true) ? "1" : "0";
                privilege += (cbxprivilege.Items[3].Selected == true) ? "1" : "0";

                CharacterBLL characterop = new CharacterBLL();

                CharacterInfo character = new CharacterInfo(txtname.Text.Trim(), privilege, 0);

                character.ID = ID;

                if (characterop.Update(character) == true)
                {
                    lblmessage.Text = "更新角色成功";
                    lblmessage.Visible = true;

                    return true;
                }
                else
                {
                    lblmessage.Text = "更新角色失败";
                    lblmessage.Visible = true;

                    return false;
                }
            }
        }

最后的工程结构如图：