对增删改查用面向对象进行包装--nhibernate实例篇

嘿嘿，看到有人写这个对增删改查用面向对象进行包装 ，想下去年搞的项目里就是这样弄的，贴出来大家共享下吧，感觉没啥技术含量，就是思路还行吧。不废话了自己看吧，这事nhibernate自己搞的一个底层

 

  1using System;
  2using System.Collections.Generic;
  3using System.Text;
  4using System.Collections;
  5using NHibernate;
  6
  7namespace LogicInterface.lib
  8{
  9    public class DBBaseDAL<T>
 10    {
 11        InsertOrUpdata#region InsertOrUpdata
 12        /**//// <summary>
 13        /// 新增更新记录
 14        /// </summary>
 15        /// <param name="t">实体</param>
 16        public static bool SaveOrUpdata(T t, SaveType type)
 17        {
 18            ISession session = SessionManager.GetCurrentSession();
 19            ITransaction tx = null;
 20            bool isOk = false;
 21            try
 22            {
 23                tx = session.BeginTransaction();
 24                if (type == SaveType.Add)
 25                {
 26                    session.Save(t);
 27                }
 28                else
 29                    if (type == SaveType.Update)
 30                    {
 31                        session.Update(t);
 32                    }
 33                    else
 34                        if (type == SaveType.SaveOrUpdateCopy)
 35                        {
 36                            session.SaveOrUpdateCopy(t);
 37                            session.Flush();
 38                        }
 39                        else
 40                        {
 41                            session.Save(t);
 42                        }
 43                tx.Commit();
 44                isOk = true;
 45            }
 46            catch (HibernateException ex)
 47            {
 48                if (tx != null) tx.Rollback();
 49                throw new CustomException("执行语句异常", ex.InnerException);
 50            }
 51            finally
 52            {
 53                SessionManager.CloseSession();
 54            }
 55            return isOk;
 56        }
 57
 58        /**//// <summary>
 59        /// 批量更新
 60        /// </summary>
 61        /// <param name="objList"></param>
 62        /// <returns></returns>
 63        public static bool Update(List<T> objList)
 64        {
 65            bool isOk = false;
 66            ISession session = SessionManager.GetCurrentSession();
 67            session.BeginTransaction();
 68            try
 69            {
 70                for (int i = 0; i < objList.Count; i++)
 71                {
 72                    session.Update(objList[i]);
 73                }
 74                session.Transaction.Commit();
 75                isOk = true;
 76            }
 77            catch
 78            {
 79                session.Transaction.Rollback();
 80                throw new CustomException(CustomExceptionType.ErrorExecHql, session);
 81            }
 82            finally
 83            {
 84                SessionManager.CloseSession();
 85            }
 86            return isOk;
 87        }
 88
 89        #endregion
 90
 91        Delete#region Delete
 92        /**//// <summary>
 93        /// 删除记录
 94        /// </summary>
 95        /// <param name="t">实体</param>
 96        public static bool Delete(T t)
 97        {
 98            ISession session = SessionManager.GetCurrentSession();
 99            ITransaction tx = null;
            bool isOk = false;
            try
            {
                tx = session.BeginTransaction();
                session.Delete(t);
                tx.Commit();
                isOk = true;
            }
            catch (HibernateException ex)
            {
                if (tx != null) tx.Rollback();
                throw new CustomException("执行语句异常", ex.InnerException);
            }
            finally
            {
                SessionManager.CloseSession();
            }
            return isOk;
        }
        /**//// <summary>
        /// 批量删除
        /// </summary>
        /// <param name="objs"></param>
        /// <returns></returns>
        public static bool Delete(IList<T> objs)
        {
            bool isOk = false;
            ISession session = SessionManager.GetCurrentSession();
            session.BeginTransaction();
            try
            {
                for (int i = 0; i < objs.Count; i++)
                {
                    session.Delete(objs[i]);
                }
                session.Transaction.Commit();
                isOk = true;
            }
            catch
            {
                session.Transaction.Rollback();
                throw new CustomException(CustomExceptionType.ErrorExecHql, session);
            }
            finally
            {
                SessionManager.CloseSession();
            }
            return isOk;
        }
        #endregion

        GetObject#region GetObject
        /**//// <summary>
        /// 获取记录
        /// </summary>
        /// <param name="id">主键</param>
        /// <returns>记录</returns>
        public static T GetObject(object id)
        {
            ISession session = SessionManager.GetCurrentSession();
            ITransaction tx = null;
            try
            {
                tx = session.BeginTransaction();

                T t = (T)session.Get<T>(id);

                tx.Commit();

                return t;
            }
            catch (HibernateException ex)
            {
                if (tx != null) tx.Rollback();
                throw new CustomException("执行语句异常", ex.InnerException);
            }
            finally
            {
                SessionManager.CloseSession();
            }
        }
        #endregion

        GetObjects#region GetObjects
        /**//// <summary>
        /// 获取全部记录
        /// </summary>
        /// <returns></returns>
        public static IList<T> GetObjects()
        {
            return GetObjects(null, null);
        }
        /**//// <summary>
        /// 获取全部记录集合
        /// </summary>
        /// <param name="where">条件字段（不写where关键字）</param>
        /// <returns>记录集合</returns>
        public static IList<T> GetObjects(string where)
        {
            return GetObjects(where, null);
        }
        /**//// <summary>
        /// 获取符合where记录集合
        /// </summary>
        /// <param name="where">条件字段（不写where关键字）</param>
        /// <param name="orderBy">排序字段（不写orderby关键字）</param>
        /// <returns>记录集合</returns>
        public static IList<T> GetObjects(string where, string orderBy)
        {
            StringBuilder hql = new StringBuilder();
            hql.AppendFormat("from {0} as tmp", typeof(T).Name);

            if (!string.IsNullOrEmpty(where))
            {
                hql.AppendFormat(" where {0}", where);
            }
            if (!string.IsNullOrEmpty(orderBy))
            {
                hql.AppendFormat(" order by {0}", orderBy);
            }
            ISession session = SessionManager.GetCurrentSession();
            ITransaction tx = null;
            try
            {
                tx = session.BeginTransaction();
                IList<T> list = session.CreateQuery(hql.ToString()).List<T>();
                tx.Commit();
                return list;
            }
            catch (HibernateException ex)
            {
                if (tx != null) tx.Rollback();
                throw new CustomException("执行语句异常", ex.InnerException);
            }
            finally
            {
                SessionManager.CloseSession();
            }
        }

        /**//// <summary>
        /// 分页GetObjects( T )/
        /// <param name="where">条件（不带where关键字）</param>
        /// <param name="orderBy">排序字段（不带orderBy关键字）</param>
        /// <param name="pageIndex">当前页</param>
        /// <param name="pageSize">页面大小</param>
        /// <param name="recordCount">出参：总记录数</param>
        /// <returns></returns>
        public static IList<T> GetObjects(string where, string orderBy, int pageIndex, int pageSize, out int recordCount)
        {
            //拼Hql语句
            StringBuilder hql = new StringBuilder();
            hql.AppendFormat("from {0} as tmp", typeof(T).Name);
            if (!string.IsNullOrEmpty(where))
            {
                hql.AppendFormat(" where {0}", where);
            }
            if (!string.IsNullOrEmpty(orderBy))
            {
                hql.AppendFormat(" order by {0}", orderBy);
            }
            ISession session = SessionManager.GetCurrentSession();
            IQuery iquery = session.CreateQuery(hql.ToString());
            iquery = pager(iquery, pageIndex, pageSize, out recordCount);//分页
            IList<T> objs = iquery.List<T>();
            SessionManager.CloseSession();
            return objs;
        }

        /**//// <summary>
        /// 分页GetObjects( T )

        /// </summary>
        /// <param name="where"></param>
        /// <param name="orderBy"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="recordCount"></param>
        /// <returns></returns>
        public static IList<T> GetObjects_two(string hql, int pageIndex, int pageSize, out int recordCount)
        {
            //拼Hql语句


            ISession session = SessionManager.GetCurrentSession();
            try
            {
                DateTime da = DateTime.Now;

                IQuery iquery = session.CreateQuery(hql).SetDateTime("curr_time", da);
                iquery = pager(iquery, pageIndex, pageSize, out recordCount);//分页
                IList<T> objs = iquery.List<T>();
                return objs;

            }
            catch (Exception ex)
            {
                throw ex;

            }
            finally
            {
                SessionManager.CloseSession();
            }
        }
        /**//// <summary>
        /// 传参数查询结果方法2
        /// </summary>
        /// <param name="where"></param>
        /// <param name="orderBy"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="recordCount"></param>
        /// <returns></returns>
        public static IList<T> GetObjectsByHql(string hql)
        {
            //拼Hql语句


            ISession session = SessionManager.GetCurrentSession();
            try
            {
                IQuery iq = session.CreateQuery(hql);
                IList<T> list = iq.List<T>();
                return list;


            }
            catch (Exception ex)
            {
                throw ex;

            }
            finally
            {
                SessionManager.CloseSession();
            }
            return null;


        }
        /**//// <summary>
        /// top 查询返回列表
        /// </summary>
        /// <param name="where"></param>
        /// <param name="orderBy"></param>
        /// <param name="topCount"></param>
        /// <returns></returns>
        public static IList<T> GetObjects(string where, string orderBy, int topCount)
        {
            //拼Hql语句
            StringBuilder hql = new StringBuilder();
            hql.AppendFormat("from {0} as tmp", typeof(T).Name);
            if (!string.IsNullOrEmpty(where))
            {
                hql.AppendFormat(" where {0}", where);
            }
            if (!string.IsNullOrEmpty(orderBy))
            {
                hql.AppendFormat(" order by {0}", orderBy);
            }
            ISession session = SessionManager.GetCurrentSession();
            IQuery iquery = session.CreateQuery(hql.ToString());
            //实现top功能
            iquery = iquery.SetFirstResult(0);
            iquery = iquery.SetMaxResults(topCount);
            IList<T> objs = iquery.List<T>();
            SessionManager.CloseSession();
            return objs;
        }
        /**//// <summary>
        /// 主要用于返回列表
        /// </summary>
        /// <param name="showRecodeNumber">显示多少条</param>
        /// <param name="where">查询条件</param>
        /// <param name="orderBy">排序字段</param>
        /// <param name="sortStyle">排序方式</param>
        /// <returns></returns>
        public static IList<T> GetObjects(int showRecodeNumber, string where, string orderBy, string sortStyle)
        {
            //拼Hql语句
            StringBuilder hql = new StringBuilder();
            hql.AppendFormat("from {0} as tmp", typeof(T).Name);
            if (!string.IsNullOrEmpty(where))
            {
                hql.AppendFormat(" where {0}", where);
            }
            if (!string.IsNullOrEmpty(orderBy))
            {
                if (StringTools.ObjectToStr(sortStyle).ToUpper().Trim() == "ASC")
                {
                    hql.AppendFormat(" order by {0} {1}", orderBy, "ASC");
                }
                else
                {
                    hql.AppendFormat(" order by {0} {1}", orderBy, "DESC");
                }
            }
            ISession session = SessionManager.GetCurrentSession();
            IQuery iquery = session.CreateQuery(hql.ToString());
            //if (iquery.List<T>() != null && iquery.List<T>().Count >= showRecodeNumber)
            //{
            //实现top功能
            iquery = iquery.SetFirstResult(0);
            iquery = iquery.SetMaxResults(StringTools.ObjectToInt(showRecodeNumber));
            IList<T> objs = iquery.List<T>();
            SessionManager.CloseSession();
            return objs;
            //}
            //return null;
        }

        //select top 5 company_name,Company_type,COMINATE_CATEGORY,COMINATE_DATETIME from mm_company
        //where COMINATE_CATEGORY=100 and Company_type=1
        //order by COMINATE_DATETIME desc

        #endregion

}//class

}

 

嘿嘿写的不好，见谅！