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));
}
