MySQL NHibernate总结

NHibernate

Restrictions:

Restrictions用法

Restrictions.eq	＝
Restrictions.allEq	利用Map来进行多个等于的限制
Restrictions.gt	＞
Restrictions.ge	＞＝
Restrictions.lt	＜
Restrictions.le	＜＝
Restrictions.between	BETWEEN
Restrictions.like	LIKE
Restrictions.in	in
Restrictions.and	and
Restrictions.or	or
Restrictions.sqlRestriction	用SQL限定查询

 

Restrictions.eq --> equal,等于.

Restrictions.allEq --> 参数为Map对象,使用key/value进行多个等于的比对,相当于多个Restrictions.eq的效果

Restrictions.gt --> great-than > 大于

Restrictions.ge --> great-equal >= 大于等于

Restrictions.lt --> less-than, < 小于

Restrictions.le --> less-equal <= 小于等于

Restrictions.between --> 对应SQL的between子句

Restrictions.like --> 对应SQL的LIKE子句

Restrictions.in --> 对应SQL的in子句

Restrictions.and --> and 关系

Restrictions.or --> or 关系

Restrictions.isNull --> 判断属性是否为空,为空则返回true

Restrictions.isNotNull --> 与isNull相反

Restrictions.sqlRestriction --> SQL限定的查询

Order.asc --> 根据传入的字段进行升序排序

Order.desc --> 根据传入的字段进行降序排序

MatchMode.EXACT --> 字符串精确匹配.相当于"like 'value'"

MatchMode.ANYWHERE --> 字符串在中间匹配.相当于"like '%value%'"

MatchMode.START --> 字符串在最前面的位置.相当于"like 'value%'"

MatchMode.END --> 字符串在最后面的位置.相当于"like '%value'"

        public static List<T> GetAllRightData<T>(string propertyName, object value)
        {
            try
            {
                using (ISession session = NHibernateHelper.OpenSession())
                {
                    List<T> list = null;
                    list = session.CreateCriteria(typeof(T))
                        .Add(Restrictions.Eq(propertyName, value))
                        .List<T>().ToList();
                    return list;
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine("MySql GetAllRightData1 Error:" + e.Message);
                return null;
            }
        }
        internal static List<T> GetAllLike<T>(string propertyName, string value)
        {
            try
            {
                using (ISession session = NHibernateHelper.OpenSession())
                {
                    List<T> list = null;
                    list = session.CreateCriteria(typeof(T))
                        .Add(Restrictions.Like(propertyName, value,MatchMode.Anywhere))
                        .List<T>().ToList();
                    return list;
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine("MySql GetAllLike Error:" + e.Message);
                return null;
            }
        }
        public static List<T> GetOrData<T>(string propertyName1, object value1, string propertyName2, object value2)
        {
            try
            {
                using (ISession session = NHibernateHelper.OpenSession())
                {
                    List<T> list = null;
                    list = session.CreateCriteria(typeof(T))
                        .Add(Restrictions.Or(Restrictions.Eq(propertyName1, value1), Restrictions.Eq(propertyName2, value2)))
                        .List<T>().ToList();
                    return list;
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine("MySql GetOrData Error:" + e.Message);
                return null;
            }
        }
 public static T GetDataByName<T>(string propertyName, string value)
        {
            try
            {
                using (ISession session = NHibernateHelper.OpenSession())
                {
                    using (ITransaction transaction = session.BeginTransaction())
                    {
                        T t = session.CreateCriteria(typeof(T)).Add(Restrictions.Eq(propertyName, value)).UniqueResult<T>();
                        transaction.Commit();
                        if (t == null) { Console.WriteLine(propertyName + ":" + value + "not exist!"); }
                        else
                        { Console.WriteLine(propertyName + ":" + value + "find!!!"); }
                        return t;
                    }
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine("MySql SearchUser Error:" + e.Message);
                return default(T);
            }
        }
  
        internal static List<T> SearchDataByDay<T>(string propertyName, string value, string datePropertyName, DateTime start,DateTime end) 
        { 
            try
            {
                using (ISession session = NHibernateHelper.OpenSession())
                {
                    using (ITransaction transaction = session.BeginTransaction())
                    {
                        List<T> t = session.CreateCriteria(typeof(T))
                            .Add(Restrictions.Eq(propertyName, value))
                            .Add(Restrictions.Between(datePropertyName, start, end))
                            .List<T>().ToList();
                        transaction.Commit();
    
                        return t;
                    }
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine("SearchTrainDataByDay Error:" + e.Message);
                return default(List<T>);
            }
        }