知识管理系列---3.程序实现

系列引导：

知识管理系列----1.原型设计

知识管理系列----2.数据库设计

  本项目的ORM框架采用LINQ的核心。所有的增删改查均基于LINQ语法实现。

  按照ORM基本的三层框架：

 

  SQL底层核心：   

        /// <summary>
        /// 查询SQL语句，并将查询结果实例化
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="sql"></param>
        /// <param name="func"></param>
        /// <param name="param"></param>
        /// <returns></returns>
        public static IEnumerable<T> SelectReader<T>(string sql, Func<System.Data.Common.DbDataReader, T> func, params System.Data.Common.DbParameter[] param)
            where T:class
        {
            using (SqlConnection con = new SqlConnection(connectionString))
            {
                SqlCommand cmd = new SqlCommand(sql, con);
                cmd.Connection.Open();
                cmd.Parameters.Clear();
                if (param != null && param.Length > 0)
                {
                     cmd.Parameters.AddRange(param);
                }
                SqlDataReader dr = cmd.ExecuteReader();

                var list = new List<T>();
                while (dr.Read())
                {
                    T t = func(dr);
                    if (t != null)
                        list.Add(t);
                }
                dr.Close();
                return list;
            }
        }

        Model层：（以g_Node为例）             

using System;
using JackCSoft.DAL;
namespace JackCSoft.Model
{
    /// <summary>
    /// g_Node:实体类(属性说明自动提取数据库字段的描述信息)
    /// </summary>
    [Serializable]
    [SelectContext]
    [ExecuteContext]
    public partial class g_Node
    {
        public g_Node()
        { }
        #region Model
        private int _id = 10000;
        private string _nodename;
        private int _nodetype = 0;
        private int? _create_user;
        private string _create_ymd;
        private string _create_hms;
        private int? _update_user;
        private string _update_ymd;
        private string _update_hms;
        private string _guid = "newid";
        /// <summary>
        /// 
        /// </summary>
        public int ID
        {
            set { _id = value; }
            get { return _id; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string NodeName
        {
            set { _nodename = value; }
            get { return _nodename; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int NodeType
        {
            set { _nodetype = value; }
            get { return _nodetype; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? create_user
        {
            set { _create_user = value; }
            get { return _create_user; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string create_ymd
        {
            set { _create_ymd = value ; }
            get { return _create_ymd; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string create_hms
        {
            set { _create_hms = value; }
            get { return _create_hms; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? update_user
        {
            set { _update_user = value; }
            get { return _update_user; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string update_ymd
        {
            set { _update_ymd = value; }
            get { return _update_ymd; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string update_hms
        {
            set { _update_hms = value; }
            get { return _update_hms; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string guid
        {
            set { _guid = value; }
            get { return _guid; }
        }
        #endregion Model

    }
}

        BLL层：          

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

using JackCSoft.Model;
using JackCSoft.DAL;
using JackCSoft.CommonLib;
using System.Linq.Expressions;
using System.Data.SqlClient;
using JackCSoft.DBUtility;

namespace JackCSoft.BLL
{
    public class BLL_NodeManager
    {
        CommonLib.TypePropertyOperation typeProperOperation=new TypePropertyOperation();
        BLL_g_Node instance_Node = BLL_g_Node.handler;
        BLL_g_NodeOrder instance_NodeOrder = BLL_g_NodeOrder.handler;

        #region 查询 select
        /// <summary>
        /// 获取顶层node的信息
        /// </summary>
        /// <returns></returns>
        public IEnumerable<g_Node> GetTopNodeInfo()
        {
            var obj = new JackCSoft.Model.g_Node();
            var where = new JackCSoft.Model.g_Node()
            {
                ID = 0,
                NodeType = Convert.ToInt16(NodeTypeEnumer.TopNode)   //顶层Node类型
            };
            return instance_Node.Select(obj, s => s, where, b => new { b.ID, b.NodeType });
        }
        /// <summary>
        /// 获取顶层node的信息
        /// </summary>
        /// <returns></returns>
        public IEnumerable<TResult> GetTopNodeInfo<TResult>(Func<g_Node,TResult> func) 
            where TResult:class
        {
            var obj = new JackCSoft.Model.g_Node();
            var where = new JackCSoft.Model.g_Node()
            {
                ID = 0,
                NodeType = Convert.ToInt16(NodeTypeEnumer.TopNode)   //顶层Node类型
            };
            return instance_Node.Select(obj, s => func(s), where, b => new { b.ID, b.NodeType });
        }

        /// <summary>
        /// 根据指定条件查询Node信息
        /// </summary>
        /// <returns></returns>
        public IEnumerable<TResult> GetNodeInfoByWhere<TResult,TWhere>(Func<g_Node, TResult> func,g_Node entity,Func<g_Node,TWhere> funcWhere)
            where TResult : class
            where TWhere:class
        {
            var obj = new JackCSoft.Model.g_Node();
            return instance_Node.Select(obj, s => func(s),entity,p=>funcWhere(p));
        }

        /// <summary>
        /// 根据GUID查询node信息
        /// </summary>
        /// <param name="guid"></param>
        /// <returns></returns>
        public IEnumerable<g_Node> GetNodeInfoByGUID(string guid)
        {
            var obj = new JackCSoft.Model.g_Node();
            var where = new JackCSoft.Model.g_Node()
            {
                guid=guid
            };
            return instance_Node.Select(obj, s => s, where, p => new { p.guid});
        }

        /// <summary>
        /// 查询该节点类型的最大值
        /// </summary>
        /// <param name="enumer"></param>
        /// <returns></returns>
        public g_Node GetMaxNodeIDByNodeType(int enumer)
        {
            var obj = new JackCSoft.Model.g_Node();
            var where = new JackCSoft.Model.g_Node()
            {
                NodeType=enumer
            };
            IEnumerable<g_Node> result=instance_Node.Select(obj, s => s, where, p => new { p.NodeType }).OrderByDescending(m=>m.ID);
            return (result != null && result.Count() > 0) ? result.ToArray()[0] : null;
        }

        /// <summary>
        /// 查询max id
        /// </summary>
        /// <param name="enumer"></param>
        /// <returns></returns>
        public g_Node GetMaxNodeID()
        {
            var obj = new JackCSoft.Model.g_Node();
            IEnumerable<g_Node> result = instance_Node.Select(s=>s).OrderByDescending(m => m.ID);

            return (result != null && result.Count() > 0) ? result.ToArray()[0] : null;
        }

        public DataTable GetHtmlContentByID(int id)
        {
            return DAL_Node.GetHtmlContentByID(id);
        }
        #endregion

        #region 插入 insert
        /// <summary>
        /// 往g_Node插入节点信息,并在g_NodeOrder表插入节点顺序信息
        /// </summary>
        /// <returns></returns>
        public bool InsertNode<TNode>(g_Node t,Func<g_Node,TNode> func,int parentNodeID) where TNode:class
        {
            //插入g_Node子信息
            bool _insertOk = instance_Node.Insert(t, s => func(s));

            if (_insertOk)
            {
                //查询已经插入的子节点信息 在插入g_NodeOrder表
                Expression<Func<g_Node,object>> selectEntity=s=>new {s.guid,s.ID};
                g_Node obj = new g_Node();

                IEnumerable<object> _resultList = instance_Node.Select(obj, s => selectEntity.Compile()(s), t, p => func(p));
                if (_resultList != null&&_resultList.ToArray().Count()>0)
                {
                    //插入g_NodeOrder数据表数据
                    g_NodeOrder nodeOrder = new g_NodeOrder
                    {
                        //g_NodeOrder的DBNode_GUID对应g_Node的GUID
                        DBNode_GUID = Convert.ToString(typeProperOperation.GetPropertyByNameType("guid",_resultList.ToArray()[0])),
                        //本节点的的ID编号 对应的是g_Node的ID字段
                        NodeOrderLoacte=Convert.ToInt32(typeProperOperation.GetPropertyByNameType("ID", _resultList.ToArray()[0])),
                        //父级节点表g_Node 的ID字段         
                        ParentNodeID=parentNodeID            
                    };
                    _insertOk = false;

                    Func<g_NodeOrder,object> fun=s=>new {s.DBNode_GUID,s.NodeOrderLoacte,s.ParentNodeID};
                    _insertOk=instance_NodeOrder.Insert(nodeOrder, s => fun(s));
                    return _insertOk == true ? true : false;
                }
                else
                {
                    return false;
                }
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 往g_Node插入节点信息,并在g_NodeOrder表插入节点顺序信息
        /// </summary>
        /// <returns></returns>
        public bool InsertNode<TNode>(g_Node t, Func<g_Node, TNode> func, int parentNodeID,out string guid) where TNode : class
        {
            //插入g_Node子信息
            bool _insertOk = instance_Node.Insert(t, s => func(s));

            if (_insertOk)
            {
                //查询已经插入的子节点信息 在插入g_NodeOrder表
                Expression<Func<g_Node, object>> selectEntity = s => new { s.guid, s.ID };
                g_Node obj = new g_Node();

                IEnumerable<object> _resultList = instance_Node.Select(obj, s => selectEntity.Compile()(s), t, p => func(p));
                if (_resultList != null && _resultList.ToArray().Count() > 0)
                {
                    //插入g_NodeOrder数据表数据
                    g_NodeOrder nodeOrder = new g_NodeOrder
                    {
                        //g_NodeOrder的DBNode_GUID对应g_Node的GUID
                        DBNode_GUID = Convert.ToString(typeProperOperation.GetPropertyByNameType("guid", _resultList.ToArray()[0])),
                        //本节点的的ID编号 对应的是g_Node的ID字段
                        NodeOrderLoacte = Convert.ToInt32(typeProperOperation.GetPropertyByNameType("ID", _resultList.ToArray()[0])),
                        //父级节点表g_Node 的ID字段         
                        ParentNodeID = parentNodeID
                    };
                    _insertOk = false;

                    Func<g_NodeOrder, object> fun = s => new { s.DBNode_GUID, s.NodeOrderLoacte, s.ParentNodeID };
                    _insertOk = instance_NodeOrder.Insert(nodeOrder, s => fun(s));
                    //返回执行结果
                    guid = Convert.ToString(typeProperOperation.GetPropertyByNameType("guid", _resultList.ToArray()[0]));
                    return _insertOk == true ? true : false;
                }
                else
                {
                    guid = "";
                    return false;
                }
            }
            else
            {
                guid = "";
                return false;
            }
        }
        #endregion

        #region 更新 update
        public bool UpdateNode(string nodeName,string guid)
        {
            g_Node node = new g_Node
            {
                NodeName=nodeName
            };
            g_Node where=new g_Node
            {
                guid=guid
            };
            return instance_Node.Update(node, s => new { s.NodeName }, where, p => new { p.guid});
        }
        #endregion

        #region 删除 delete
        public void DeleteTreeViewNodeByID(int id)
        {
            DataTable idDt = DAL_NodeOrder.SelectIDByParentID(id);
            if (idDt != null && idDt.Rows.Count > 0)
            {
                bool _deleteOK = true;
                //查询是否存在html等文件信息
                DataTable dt = DAL_AddressUrl.GetAddressByParentID(id);
                if (dt != null && dt.Rows.Count > 0)     //存在HTML文件
                {
                    //g_AddressUrl删除信息 g_Content删除信息
                    if (DAL_AddressUrl.DeleteAddressByParentID(id) && DAL_Content.DeleteContentByParentID(id) && DAL_Node.DeleteNodeByID(id))
                    {
                        _deleteOK = true;
                    }
                    else
                    {
                        _deleteOK = false;
                    }
                }
                //删除节点信息
                if (_deleteOK)
                {
                    if (DAL_Node.DeleteNodeByID(id) && DAL_NodeOrder.DeleteNodeOrderByID(id))
                    {
                        for (int i = 0; i < idDt.Rows.Count; i++)
                        {
                            DeleteTreeViewNodeByID(Convert.ToInt32(idDt.Rows[i]["ID"]));
                        }
                    }
                }
            }
            else
            {
                DAL_Node.DeleteNodeAndChildByID(id);
                if (DAL_NodeOrder.SelectIDByCurrentNodeID(id) != null)
                {
                    DAL_NodeOrder.DeleteNodeOrderAndChildByID(id);
                }
            }
            //return false;
        }
        #endregion
    }
}

    程序源代码：程序源代码