public SystemDictionaryEntity FindMaxOrderItemByGroupID(SystemDictionaryGroupEntity dictionaryGroup) { NHibernateDynamicQueryGenerator <SystemDictionaryEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_SYSTEMDICTIONARYGROUPID.Eq(dictionaryGroup)); dynamicQueryGenerator.AddOrderBy(PROPERTY_SYSTEMDICTIONARYORDER.Desc()); return(this.FindSingleEntityByQueryBuilder(dynamicQueryGenerator)); }
/// <summary> /// 根据字典类别名获取该类别下的所有可用的字典项(已排序) /// </summary> /// <param name="categoryName"></param> /// <returns></returns> public IList <SystemDictionaryEntity> GetDictionaryByCategoryName(string categoryName) { NHibernateDynamicQueryGenerator <SystemDictionaryEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_SYSTEMDICTIONARYCATEGORYID.Eq(categoryName)); dynamicQueryGenerator.AddWhereClause(PROPERTY_SYSTEMDICTIONARYISENABLE.Eq(true)); dynamicQueryGenerator.AddOrderBy(PROPERTY_SYSTEMDICTIONARYORDER.Asc()); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SystemDictionaryEntity> FindAllByGroupIdAndOrder() { NHibernateDynamicQueryGenerator <SystemDictionaryEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_SYSTEMDICTIONARYISENABLE.Eq(true)); dynamicQueryGenerator.AddOrderBy(PROPERTY_SYSTEMDICTIONARYGROUPID.Asc()); dynamicQueryGenerator.AddOrderBy(PROPERTY_SYSTEMDICTIONARYORDER.Asc()); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }