新做的NHibernate项目，大家来拍拍砖，同时还要请多多提些问题

简单说明：

这个项目的结构，大家来拍拍砖，同时还要请多多提些问题。

项目不是为了做新闻，由于对新闻比较了解，不同的项目中也用的多，我就想通过这个项目吧新闻功能做的深入完善些，这里也就用新闻做演示用。

这个结构是根据之前的项目结构，以及院子里不是朋友们的提供的方案、代码等，整合起来的。不敢妄称为啥框架，只是希望对开发的项目能起到一些帮助作用。

第一次写blog，可能有点乱，大家见谅了。


使用结构资源

NHibernate.net
FluentNHibernate
Autofac
MVC
Jquery

项目结构

总体结构

说明下为啥这样做： 我工作的单位都是变化比较快的公司（命苦呀），很多事情都是比较杂，之前的项目就是模块太多了，维护起来很麻烦，我就想可不可以按照功能模块来划分， 吧一个模块深入，又不影响其他人的工作。。。 所以倒腾了这样的一个结果。（受到SpaceBuilder影响）.

另外一个想法是：今后项目扩展性会好些； 模块的延续行也会提升。像之前在不同的公司，项目中的新闻还要拿出来改啊啥的。 如果这个结果吧新闻模块完善后，其他项目只需要引用改模块即可。



文章咨询模块


稍微了解过NHibernate.net应该能开出来大概的结构意思吧？ 还是上几段代码吧。

using System;
using System.Linq;
using System.Text;

using Job.FluenCore.Common;
using Iesi.Collections.Generic;

namespace Job.FluenCore.Article.Model
{
    public class News : IEntity
    {
        /// <summary>
        /// 文章编号
        /// </summary>
        public virtual int Id { get; set; }

        /// <summary>
        /// 新闻类型何种类型
        /// 文章、单页
        /// News.TypeId =NewsClass.TypeId
        /// </summary>
        public virtual NewsClassType TypeId { get; set; }

        /// <summary>
        /// News.ClassId =NewsClass.ClassId
        /// </summary>
        public virtual int ClassId { get; set; }

        /// <summary>
        /// 访问次数
        /// </summary>
        public virtual int Visits { get; set; }
        /// <summary>
        /// 添加时间
        /// </summary>
        public virtual DateTime AddTime { get; set; }
        /// <summary>
        /// 编辑时间
        /// </summary>
        public virtual DateTime EditTime { get; set; }
        /// <summary>
        /// 文章状态
        /// </summary>
        public virtual NewAuditType ContentStatus { get; set; }


        /// <summary>
        /// 主题 详细页
        /// </summary>
        public virtual string Title { get; set; }
        /// <summary>
        /// 主题颜色
        /// </summary>
        public virtual string TitleColor { get; set; }
        /// <summary>
        /// 复标题 用于首页等。
        /// </summary>
        public virtual string TitleSub { get; set; }
        /// <summary>
        /// 内容
        /// </summary>
        public virtual string Content { get; set; }
        /// <summary>
        /// 作者
        /// </summary>
        public virtual string Author { get; set; }
        /// <summary>
        /// 简介
        /// </summary>
        public virtual string Introduction { get; set; }

        /// <summary>
        /// seo
        /// </summary>
        public virtual string PageTitle { get; set; }
        /// <summary>
        /// seo
        /// </summary>
        public virtual string PageKeywords { get; set; }
        /// <summary>
        /// seo
        /// </summary>
        public virtual string PageDescription { get; set; }

        /// <summary>
        /// 置顶
        /// </summary>
        public virtual byte IsTop { get; set; }
        /// <summary>
        /// 推荐
        /// </summary>
        public virtual byte IsRecommend { get; set; }
        /// <summary>
        /// 回复
        /// </summary>
        public virtual byte IsNoComment { get; set; }
        /// <summary>
        /// 文章星级 默认 0
        /// </summary>
        public virtual short Star { get; set; }
        /// <summary>
        /// 文章排序 默认 0
        /// </summary>
        public virtual int ContentOrder { get; set; }
        /// <summary>
        /// 文章Url
        /// </summary>
        public virtual string ContentUrl { get; set; }

        /// <summary>
        /// 缩略图 编号
        /// </summary>
        public virtual int IndexImage { get; set; }
        
        /*
        /// <summary>
        /// 文章分类\
        /// 数据库字段=ClassID
        /// </summary>
        public virtual NewsClass Class { get; set; }
        /// <summary>
        /// 文章评论
        /// </summary>
        public virtual ISet<NewsComments> Comments { get; set; } 
        ///// <summary>
        ///// 图片 下载文件
        ///// </summary>
        public virtual ISet<NewsFile> Files { get; set; }
        */
    }
}

using System;
//using System.Collections.Generic;
using System.Linq;

using Iesi.Collections.Generic;
using FluentNHibernate.Mapping;
using Job.FluenCore.Article.Model;

namespace Job.FluenCore.Article.Mapping
{
    public class NewsMap : ClassMap<News>
    {
        public NewsMap()
        {
            Table("[t_News]");
            Id(p => p.Id).GeneratedBy.Identity();
            Map(p => p.ClassId).Not.Nullable().Default("0");
            Map(p => p.Title).Not.Nullable().Length(255);
            Map(p => p.TitleColor).Nullable().Length(10);
            Map(p => p.TitleSub).Nullable().Length(255);
            Map(p => p.Content).Nullable().CustomSqlType("text");
            Map(p => p.Author).Nullable().Length(50);
            Map(p => p.Introduction).Nullable().Length(1000);

            Map(p => p.PageTitle).Nullable().Length(100);
            Map(p => p.PageKeywords).Nullable().Length(100);
            Map(p => p.PageDescription).Nullable().Length(255);

            Map(p => p.IsTop).Not.Nullable().Default("0");
            Map(p => p.IsRecommend).Not.Nullable().Default("0");
            Map(p => p.IsNoComment).Not.Nullable().Default("0");
            Map(p => p.Star).Not.Nullable().Default("0");
            Map(p => p.ContentOrder).Not.Nullable().Default("0");
            Map(p => p.ContentUrl).Nullable().Length(255);
            Map(p => p.IndexImage).Not.Nullable().Default("0");

            Map(p => p.Visits).Not.Nullable().Default("0");
            Map(p => p.AddTime).Not.Nullable().Default("getdate()");
            Map(p => p.EditTime).Not.Nullable().Default("getdate()");
            Map(p => p.ContentStatus).CustomType<NewAuditType>();

            /*
            References<NewsClass>(p => p.Class)
                .LazyLoad()
                .Column("ClassID")
                .Cascade.All();
            
            HasMany<NewsComments>(p => p.Comments)
                .AsSet().LazyLoad()
                .Inverse() //    Inverse="false"(默认)：父实体负责维护关联关系     Inverse="true"：子实体负责维护关联关系
                .KeyColumn("NewsID")
                .Cascade.All();

            HasMany<NewsFile>(p => p.Files)
                .AsSet().LazyLoad()
                .Inverse() //    Inverse="false"(默认)：父实体负责维护关联关系     Inverse="true"：子实体负责维护关联关系
                .KeyColumn("NewsID")
                .Cascade.All();
            */
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;

using Webdiyer.WebControls.Mvc;

using Job.FluenCore.Common;
using Job.FluenCore.DateFactory;
using Job.FluenCore.Article.Mapping;
using Job.FluenCore.Article.Model;

namespace Job.FluenCore.Article.Repository
{
    #region Interface
    public interface INewsRepository : IRepositoryBase<News>
    {
        void UpdateHitClick(int Id);
    }
    #endregion

    public class NewsRepository : RepositoryBase<News>, INewsRepository
    {
        public NewsRepository(IDatabaseFactory databaseFactory)
            : base(databaseFactory)
        {
        }

        public void UpdateHitClick(int Id)
        {
            var s = "update [t_News] set Visits=Visits+1 whre Id=:f1";

            base.CreateSQLQuery(s)
                .SetInt32("f1", Id)
                .ExecuteUpdate();
            //base.Commit();
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
//using System.Data.Entity.Validation;

using Webdiyer.WebControls.Mvc;

using Job.FluenCore.Common;
using Job.FluenCore.DateFactory;
using Job.FluenCore.Article.Model;
using Job.FluenCore.Article.Repository;

namespace Job.FluenCore.Article.Service
{
    public interface INewsService : IServiceBase<INewsRepository>
    {
        void UpdateHitClick(int Id, string Ip);
    }

    public class NewsService : ServiceBase<INewsRepository>, INewsService
    {
        public NewsService(IUnitOfWork _unitwork, INewsRepository _repository)
            : base(_unitwork, _repository)
        { 
        }

        public void UpdateHitClick(int Id, string Ip)
        {
            base.Repository().UpdateHitClick(Id);

            /*
            var s = "update [t_News] set Visits=Visits+1,ip=:f2 whre Id=:f1";            
            base.Repository().CreateSQLQuery(s)
                .SetInt32("f1", Id)
                .SetString("f2", Ip)
                .ExecuteUpdate();
            base.Repository().Commit();
            */
        }

    }
}

using System;
using System.Collections.Specialized;
using System.Web;
using System.Web.Mvc;
using System.Web.Routing;

using Autofac;

using Job.FluenCore.Article.Mapping;
using Job.FluenCore.Article.Model;
using Job.FluenCore.Article.Repository;
using Job.FluenCore.Article.Service;

namespace Job.FluenCore.Article.Modules
{
    public class NewsModule : Module
    {
        protected override void Load(ContainerBuilder builder)
        {
            if (builder == null)
            {
                throw new ArgumentNullException("Job.FluenCore.Article.Modules ContainerBuilder");
            }

            builder.RegisterType<NewsService>().As<INewsService>().InstancePerLifetimeScope();
            builder.RegisterType<NewsRepository>().As<INewsRepository>().InstancePerLifetimeScope();

            builder.RegisterType<NewsClassService>().As<INewsClassService>().InstancePerLifetimeScope();
            builder.RegisterType<NewsClassRepository>().As<INewsClassRepository>().InstancePerLifetimeScope();


            base.Load(builder);
        }

        public System.Reflection.Assembly GetAssembly()
        {
            return System.Reflection.Assembly.GetExecutingAssembly();
        }
    }
}

namespace Job.FluenCore.DateFactory
{
    public interface IRepositoryBase<T> where T : class
    {
        /// <summary>
        /// 提交事务
        /// </summary>
        void Commit();

        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="IsNowSave"></param>
        /// <returns></returns>
        T Add(T entity, bool IsNowSave = true);

        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="IsNowSave"></param>
        void Update(T entity, bool IsNowSave = true);

        void SaveOrUpdate(T entity, bool IsNowSave = true);

        void Delete(T entity);
        void Delete(int Id, bool Load = false);
        void Delete(Expression<Func<T, bool>> where);

        T GetById(int Id);
        T GetById(string Id);

        /// <summary>
        /// 根据条件获得模型 Linq语句
        /// </summary>
        /// <param name="where"></param>
        /// <returns></returns>
        T Get(Expression<Func<T, bool>> where);

        /// <summary>
        /// 支持 selector where查询
        /// var list= GetMany(o => o.Id > 0).Select(o => o).OrderByDescending(o=>o.AddTime).ToPagedList(pageindex, pagesize);
        /// </summary>
        T Get(Expression<Func<T, bool>> where, Expression<Func<T, T>> selector);

        /// <summary>
        /// 支持 select where orderby查询
        /// var list= GetMany().Select(o => o).OrderByDescending(o=>o.AddTime).ToPagedList(pageindex, pagesize);
        /// </summary>
        IQueryable<T> GetMany();

        /// <summary>
        /// 支持 select orderby查询
        /// var list= GetMany(o => o.Id > 0).Select(o => o).OrderByDescending(o=>o.AddTime).ToPagedList(pageindex, pagesize);
        /// </summary>
        IQueryable<T> GetMany(Expression<Func<T, bool>> where);

        /// <summary>
        /// 支持 where查询
        /// var list= GetList(o => o.Id > 0).Select(o => o).OrderByDescending(o=>o.AddTime).ToPagedList(pageindex, pagesize);
        /// </summary>
        PagedList<T> GetList(Expression<Func<T, bool>> where, int pagesize, int pageindex);

        /// <summary>
        /// 支持 select where查询
        /// var list= GetList(o => o.Id > 0).Select(o => o).OrderByDescending(o=>o.AddTime).ToPagedList(pageindex, pagesize);
        /// </summary>
        PagedList<T> GetList(Expression<Func<T, bool>> where, Expression<Func<T, T>> select, int pagesize, int pageindex);

        /// <summary>
        /// 支持 select where查询
        /// var list= GetList(o => o.Id > 0).Select(o => o).OrderByDescending(o=>o.AddTime).ToPagedList(pageindex, pagesize);
        /// </summary>
        PagedList<T> GetList(Expression<Func<T, bool>> where, Expression<Func<T, T>> select, Func<T, string> orderName, string sortOrder, int pagesize, int pageindex);

        /// <summary>
        /// 支持 select where查询
        /// var list= GetForModel[T](o => o.Id > 0).Select(o => o).OrderByDescending(o=>o.AddTime).ToPagedList(pageindex, pagesize);
        /// </summary>
        IQueryable<TModel> GetForModel<TModel>();

        /// <summary>
        /// 支持NHibernate语句，查询、更新、删除
        /// eg .CreateCriteria().add(Expression.like("name", "Fritz%")).add( Expression.between("weight", minWeight, maxWeight))
        /// </summary>
        ICriteria CreateCriteria();

        /// <summary>
        /// 支持NHibernate语句，查询、更新、删除
        /// eg .CreateCriteria().add(Expression.like("name", "Fritz%")).add( Expression.between("weight", minWeight, maxWeight))
        /// </summary>
        ICriteria CreateCriteria(string entityName);
        
        /// <summary>
        /// 支持 hql,参数，查询、更新、删除\ 注意不是SQL
        /// hibernate 中createQuery与createSQLQuery两者区别是：前者用的hql语句进行查询，后者可以用sql语句查询|
        /// eg .CreateQuery("from Customer c where c.Name.Firstname=:fn and c.Name.Lastname=:ln").SetString("fn", firstname).SetString("ln", lastname)
        /// </summary>
        IQuery CreateQuery(string queryString);

        /// <summary>
        /// 支持 SQL、参数，查询、更新、删除  更新语句请加 ExecuteUpdate|
        /// 注意：需使用正确的 数据表结构字段 
        /// eg CreateSQLQuery("select ID from News where id=:f1 and IsTop>5").SetString("f1", firstname) \ 
        /// eg CreateSQLQuery("{Call sp_Login(?,?) }").SetString(0, "admin").SetString(1, "admin");
        /// </summary>
        ISQLQuery CreateSQLQuery(string queryString);
             
        /// <summary>
        /// 分页查询(sql分页方式) 统计
        /// 注意：需使用正确的 数据表结构字段 
        /// </summary>
        System.Collections.Generic.IList<TModel> GetListForPaging<TModel>(string tableName, int pageNumber, int pageSize, string orderName, string sortOrder, string CommandText, out int Count);

        /// <summary>
        /// 分页查询(sql分页方式) 不统计
        /// 注意：需使用正确的 数据表结构字段 
        /// </summary>
        System.Collections.Generic.IList<TModel> GetListForPaging<TModel>(string tableName, int pageNumber, int pageSize, string orderName, string sortOrder, string CommandText);

        /// <summary>
        /// 原生SQL关联查询
        /// 注意：需使用正确的 数据表结构字段 
        /// </summary>
        System.Collections.Generic.IList<TModel> GetListForPaging<TModel>(string strQuery);


        /// <summary>
        /// 原生SQL关联查询
        /// 注意：需使用正确的 数据表结构字段 
        /// </summary>
        System.Data.DataSet GetDataSet(string strQuery);

        /// <summary>
        /// 计算总个数(分页)
        /// </summary>
        int GetCount(string tableName, string commandText);
    }

using System;
using System.Text;
using System.Web;
using System.Web.Mvc;
using System.Web.Mvc.Html;
using System.Linq;
using System.Linq.Expressions;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.ComponentModel;

using Job.FluenCore.Ceche;
using Webdiyer.WebControls.Mvc;
using DotNet.Common;
using Job.FluenCore.Common;
using Job.FluenCore.Common.MVCFormwork;

using Job.FluenCore.Article;
using Job.FluenCore.Article.Model;
using Job.FluenCore.Article.Repository;
using Job.FluenCore.Article.Service;

namespace Job.Web.Controller
{
    public class NewsController : BaseWebController
    {
        protected readonly INewsService _NewsService;
        protected readonly INewsClassService _NewClassService;
        
        public NewsController(INewsService NewsService, INewsClassService NewClassService)
        {
            this._NewsService = NewsService;
            this._NewClassService = NewClassService;
        }


        #region web
        [HttpGet]
        public virtual ActionResult Index(int? page, int intPid = 0, int intStatus = 1)
        {
            //int _page = page ?? GetPageIndex();
            //var stus = (NewsClassStatusType)intStatus;
            //var where = PredicateExtensions.True<News>();
            //if (intStatus == 0 || intStatus == 1) { where = where.And(p => p.Status == stus); }
            //if (intPid > 0) { where = where.And(p => p.ParentId == intPid); }

            //var list = _NewsService
            //    .Repository()
            //    .GetList(where, GetPageSize(), _page);

            //PageData();

            return View();
        }

        [HttpGet]
        public virtual ActionResult Detail(int id, int intStatus = 1)
        {
            //var data = _NewsService.Repository().GetById(id);
            //data = data ?? new News();
            //PageData();
            return View();
        }

        #endregion


        #region admin
        /* true 显示错误； false 继续 */
        [LoginAllowView]
        [Description("[详细信息]检查是否存在(add,Update必备)")]
        public ActionResult CheckExist()
        {
            var action = QueryString.Request["action"];
            var ID = QueryString.Request["ID"].GetNum(0);
            var val = QueryString.Request[action];
            var b = false;
            if (!val.IsNullOrWhiteSpace())
            {
                switch (action)
                {
                    case "ContentUrl":
                        b = _NewsService.Repository().GetMany(p => p.Id != ID && p.ContentUrl == val).Any();
                        break;
                }
            }
            b = !b;
            return Content(b.ToString().ToLower());
        }


        [Description("[Index主页]新闻管理")]
        [ViewPage]
        [DefaultPage]
        public ActionResult AdminIndex(int Type = 0)
        {
            var CurrentTypeID = Type;
            var titel = typeof(NewsClassType).GetEnumDictionaryA().GetValue(CurrentTypeID);
            titel = titel ?? "文章";
            ViewBag.Title = titel + "管理";
            ViewBag.CurrentID = CurrentTypeID;
            return View();
        }

        [ViewPage]
        [Description("[详细信息]新闻详细信息(add,Update,Detail必备)")]
        public ActionResult AdminDetail()
        {
            ViewBag.IsView = (QueryString.Request["IsView"] == "1") ? 1 : 0;
            ViewBag.CurrentID = QueryString.Request["ID"].GetNum(0);
            return View();
        }

        [Description("[Get Json]获取新闻Json")]
        [LigerUIExceptionResult]
        public ActionResult AdminGet(int? id)
        {
            var _id = id ?? 0;
            var data = _NewsService.Repository().Get(o => o.Id == _id);
            data = data ?? new News();
            return this.JsonFormat(data, true, "获取[新闻]");
        }

        [Description("[系统]添加动作")]
        [LigerUIExceptionResult]
        public ActionResult AdminAdd()
        {
            News model = new News();
            this.TryUpdateModel(model);
            model.Id = 0;
            model.AddTime = model.AddTime == null ? DateTime.UtcNow : model.AddTime;
            model.EditTime = model.AddTime == null ? DateTime.UtcNow : model.EditTime;
            return AdminSave(model);
        }

        [Description("[系统]修改动作")]
        [LigerUIExceptionResult]
        public ActionResult AdminUpdate()
        {
            News model = new News();
            this.TryUpdateModel(model);
            model.AddTime = model.AddTime == null ? DateTime.UtcNow : model.AddTime;
            model.EditTime = model.AddTime == null ? DateTime.UtcNow : model.EditTime;
            return AdminSave(model);
        }

        [Description("[Delete]页面删除请求")]
        [LigerUIExceptionResult]
        public ActionResult AdminDelete(int Id)
        {
            var status = true;
            _NewsService.Repository().Delete(Id);
            return this.JsonFormat(null, status, "删除[新闻]");
        }
        
        [Description("[gridRequest请求]获取新闻")]
        [LoginAllowView]
        public ActionResult AdminGetGrid()
        {
            var gridRequest = new LigerUIGridRequest(HttpContext);
            var where = gridRequest.Where;
            var parms = FilterHelper.GetFilterTanslateQuery(ref where);

            int Count = _NewsService.Repository().GetMany()
                .Where(where, parms)
                .Count();

            var data = _NewsService.Repository().GetMany()
                .Where(where, parms)
                .OrderBy(gridRequest.SortName + " " + gridRequest.SortOrder)
                .Skip((gridRequest.PageNumber - 1) * gridRequest.PageSize)
                .Take(gridRequest.PageSize)
                .Select(o => new
                {
                    Id = o.Id,
                    Title = o.Title,
                    TitleColor = o.TitleColor,
                    EditTime = o.EditTime,
                    ContentUrl = o.ContentUrl,
                    ContentStatus = o.ContentStatus,
                    IndexImage = o.IndexImage,
                    IsNoComment = o.IsNoComment,
                    IsRecommend = o.IsRecommend,
                    IsTop = o.IsTop,
                    Visits = o.Visits,
                    Star = o.Star,
                    AddTime = o.AddTime,
                    //TypeId = o.TypeId,
                    ClassId = o.ClassId
                })
                .ToList();

            var grid = new LigerUIGrid();
            grid.Rows = data;
            grid.Total = Count;
            return this.JsonFormat(grid);
        }
        #endregion

        #region heper

        [NonAction]
        public ActionResult AdminSave(News model)
        {
            var status = SaveNewsClass(model, model.Id > 1);
            return this.JsonFormat(null, status, "保存[新闻分类]");
        }

        public bool SaveNewsClass(News model, bool IsEdit = true)
        {
            if (model == null) { return false; }

            model.AddTime = DateTimeHelper.DateTimeYeas(model.AddTime);
            model.EditTime = DateTimeHelper.DateTimeYeas(model.EditTime);
            model.ClassId = model.ClassId < 0 ? QueryString.Request["ClassId"].GetNum(0) : model.ClassId;

            if (IsEdit)
            {
                _NewsService.Repository().Update(model);
            }
            else
            {
                _NewsService.Repository().Add(model);
            }
            return true;
        }
        #endregion
    }
}

同时我们对Linq的扩展也可以流畅的对数据操作。

 

不过这里也有一些问题需要改进；
1 目前的动态自定义查询问题，
让使用者自己可以控制查询字段、条件、显示结果字段、排序等；（特别是在管理后台，jquery + ligerUI 结合使用， 管理者可以按需查询等, ）
如：
_NewsService.Repository().GetMany()
                .Where("条件")
                .OrderBy("id desc")
                .Take(10)
                .Skip(10)
                .Select("New(Id,Title)");

2 跨表问题（目前可用试图、存储过程处理）；

3 数据验证问题；

4 结构关系的调整处理。

未完。。。。 
先下班了。。。 晚上再写。