總結：NHibernate——DAL層處理類AbstractDao

 

可以把增、刪、改、查都寫成泛型方法

    /// <summary>

    ///

    /// </summary>

    /// <typeparam name="T"></typeparam>

    public class AbstractDao<T>

    {

        private string m_sessionFactoryConfigPath;

        protected ISession CurrentSession

        {

            get

            {

                return SessionManager.Instance.GetSession(m_sessionFactoryConfigPath);

            }

        }

 

        public AbstractDao(string sessionFactoryConfigPath)

        {

            if (string.IsNullOrEmpty(sessionFactoryConfigPath))

            {

                throw new ArgumentNullException("");

            }

 

            m_sessionFactoryConfigPath = sessionFactoryConfigPath;

        }

 

 

        protected static object s_workLocker = new object();

 

 

        /// <summary>

        /// 獲得實體物件

        /// </summary>

        /// <param name="key">關鍵字</param>

        /// <returns>對應實體</returns>

        public T GetEntity(Object key)

        {

            if (!CurrentSession.IsConnected)

            {

                CurrentSession.Reconnect();

            }

            T entity = default(T);

 

            lock (s_workLocker)

            {

                try

                {

                    using (ISession session = CurrentSession)

                    {

                        using (session.BeginTransaction())

                        {

                            entity = session.Load<T>(key);

                        }

                    }

                }

                catch (Exception ex)

                {

                    throw new PersistenceException("", ex);

                }

            }

            return entity;

        }

 

        /// <summary>

        /// 獲得IList<string>類型的傳回值

        /// </summary>

        /// <param name="hql"></param>

        /// <returns></returns>

        public IList<string> GetIListString(string hql)

        {

            IList<string> lists = null;

 

            lock (s_workLocker)

            {

                using (ISession session = CurrentSession)

                {

                    using (ITransaction transaction = session.BeginTransaction())

                    {

                        try

                        {

                            lists = session.CreateQuery(hql).List<string>();

                            transaction.Commit();

                        }

                        catch (Exception ex)

                        {

                            transaction.Rollback();

                            throw new PersistenceException("", ex);

                        }

                    }

                }

            }

            return lists;

        }

}