public SPSClientEntity GetClientByUserID(int userId) { NHibernateDynamicQueryGenerator <SPSClientEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); //指定查询条件 dynamicQueryGenerator.AddWhereClause(SPSClientDataObject.PROPERTY_USERID.Eq(userId)); //指定排序规则 dynamicQueryGenerator.AddOrderBy(SPSClientDataObject.PROPERTY_ID.Desc()); return(this.FindSingleEntityByQueryBuilder(dynamicQueryGenerator)); }
protected void AddDefaultOrderByToQueryGenerator(string orderByColumn, bool isDesc, NHibernateDynamicQueryGenerator <DomainType> queryGenerator) { //没有排序字段用主键来排序 if (orderByColumn == string.Empty) { queryGenerator.AddOrderBy(Property.ForName(PkPropertyName[0]).Desc()); } else { if (isDesc) { queryGenerator.AddOrderBy(Property.ForName(orderByColumn).Desc()); } else { queryGenerator.AddOrderBy(Property.ForName(orderByColumn).Asc()); } } }
public List <SystemMenuEntity> GetMenuByParentIDAndApp(SystemMenuEntity pMenu, SystemApplicationEntity applicationEntity) { NHibernateDynamicQueryGenerator <SystemMenuEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); //指定查询条件 dynamicQueryGenerator.AddWhereClause(SystemMenuDataObject.PROPERTY_APPLICATIONID.Eq(applicationEntity)); if (pMenu == null) { dynamicQueryGenerator.AddWhereClause(SystemMenuDataObject.PROPERTY_PARENTMENUID.IsNull()); } else { dynamicQueryGenerator.AddWhereClause(SystemMenuDataObject.PROPERTY_PARENTMENUID.Eq(pMenu)); } //指定排序规则 dynamicQueryGenerator.AddOrderBy(SystemMenuDataObject.PROPERTY_MENUORDER.Asc()); dynamicQueryGenerator.AddOrderBy(SystemMenuDataObject.PROPERTY_MENUID.Desc()); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public SPSClientEntity FindDefaultClient() { NHibernateDynamicQueryGenerator <SPSClientEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); //指定查询条件 dynamicQueryGenerator.AddWhereClause(SPSClientDataObject.PROPERTY_ISDEFAULTCLIENT.Eq(true)); //指定排序规则 dynamicQueryGenerator.AddOrderBy(SPSClientDataObject.PROPERTY_ID.Desc()); return(this.FindSingleEntityByQueryBuilder(dynamicQueryGenerator)); }
public List <SPChannelParamsEntity> GetAllShowParams(SPChannelEntity channle) { NHibernateDynamicQueryGenerator <SPChannelParamsEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channle)); queryGenerator.AddWhereClause(PROPERTY_ISENABLE.Eq(true)); queryGenerator.AddOrderBy(PROPERTY_ID.Desc()); return(this.FindListByQueryBuilder(queryGenerator)); }
public SystemVersionEntity GetMaxDataVersionByDataTypeAndDataID(string dataType, int dataId) { NHibernateDynamicQueryGenerator <SystemVersionEntity> query = this.GetNewQueryBuilder(); query.AddWhereClause(PROPERTY_PARENTDATATYPE.Eq(dataType)); query.AddWhereClause(PROPERTY_PARENTDATAID.Eq(dataId)); query.AddOrderBy(PROPERTY_VERSIONNUMBER.Desc()); ; return(this.FindSingleEntityByQueryBuilder(query)); }
/// <summary> /// 根据字典类别名获取该类别下的所有可用的字典项(已排序) /// </summary> /// <param name="categoryName"></param> /// <returns></returns> public IList <SystemDictionaryEntity> GetDictionaryByGroupID(SystemDictionaryGroupEntity dictionaryGroup) { NHibernateDynamicQueryGenerator <SystemDictionaryEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_SYSTEMDICTIONARYGROUPID.Eq(dictionaryGroup)); dynamicQueryGenerator.AddWhereClause(PROPERTY_SYSTEMDICTIONARYISENABLE.Eq(true)); dynamicQueryGenerator.AddOrderBy(PROPERTY_SYSTEMDICTIONARYORDER.Asc()); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
/// <summary> /// 分页查找所拥护 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="totalRecords"></param> /// <returns></returns> public List <SystemUserEntity> FindAllUsers(int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddOrderBy(PROPERTY_USERID.Desc()); queryGenerator.SetFirstResult((pageIndex - 1) * pageSize); queryGenerator.SetMaxResults(pageSize); return(this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords)); }
public List <SPChannelDefaultClientSycnParamsEntity> GetAllEnableDefaultSendParams(SPChannelEntity spChannelEntity) { NHibernateDynamicQueryGenerator <SPChannelDefaultClientSycnParamsEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity)); queryGenerator.AddWhereClause(PROPERTY_ISENABLE.Eq(true)); queryGenerator.AddOrderBy(PROPERTY_ID.Desc()); return(this.FindListByQueryBuilder(queryGenerator)); }
/// <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 <SPSendClientParamsEntity> GetAllEnableParams(SPClientEntity spClientEntity) { NHibernateDynamicQueryGenerator <SPSendClientParamsEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_CLIENTID.Eq(spClientEntity)); queryGenerator.AddWhereClause(PROPERTY_ISENABLE.Eq(true)); queryGenerator.AddOrderBy(PROPERTY_ID.Desc()); return(this.FindListByQueryBuilder(queryGenerator)); }
public List <SystemPrivilegeInRolesEntity> GetRoleAssignedPermissionsByResources(SystemRoleEntity role, SystemResourcesEntity resources) { NHibernateDynamicQueryGenerator <SystemPrivilegeInRolesEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_ROLEID.Eq(role)); InClude_PrivilegeID_Query(dynamicQueryGenerator); dynamicQueryGenerator.AddWhereClause(PROPERTY_PRIVILEGEID_RESOURCESID.Eq(resources)); dynamicQueryGenerator.AddOrderBy(PROPERTY_PRIVILEGEID_PRIVILEGEORDER.Asc()); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <DomainType> FindAllByOrderByAndFilter(List <QueryFilter> filters, string orderByColumn, bool isDesc) { var queryBuilder = new NHibernateDynamicQueryGenerator <DomainType>(); //构造Filter查询条件 foreach (QueryFilter queryFilter in filters) { ICriterion whereClause = queryFilter.GenerateNhibernateCriterion(GetFieldTypeByFieldName(queryFilter.FilterFieldName)); if (whereClause != null) { queryBuilder.AddWhereClause(whereClause); } } //没有排序字段用主键来排序 if (orderByColumn == string.Empty) { queryBuilder.AddOrderBy(Property.ForName(PkPropertyName[0]).Desc()); } else { if (isDesc) { queryBuilder.AddOrderBy(Property.ForName(orderByColumn).Desc()); } else { queryBuilder.AddOrderBy(Property.ForName(orderByColumn).Asc()); } } List <DomainType> results = FindListByQueryBuilder(queryBuilder); return(results); }
public List <SPCodeEntity> FindAllByChannelIDAndClientIDAndMoAndSpNumber(SPChannelEntity channel, SPSClientEntity client, string mo, string spcode) { NHibernateDynamicQueryGenerator <SPCodeEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); if (channel != null) { dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_CHANNELID.Eq(channel)); } if (client != null) { dynamicQueryGenerator.AddWhereClause(SPClientCodeRelationDataObject.Query_ClientAssignedCode(client, PROPERTY_ID.CriterionProperty)); } if (!string.IsNullOrEmpty(mo)) { dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_MO.Like(mo, MatchMode.Anywhere)); } if (!string.IsNullOrEmpty(spcode)) { dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_SPCODE.Like(spcode, MatchMode.Anywhere)); } dynamicQueryGenerator.AddWhereClause( Not(SPCodeDataObject.PROPERTY_MOTYPE.Eq(DictionaryConst.Dictionary_CodeType_CodeDefault_Key))); dynamicQueryGenerator.AddOrderBy(PROPERTY_MOTYPE.Asc()); dynamicQueryGenerator.AddOrderBy(PROPERTY_MO.Asc()); dynamicQueryGenerator.AddOrderBy(PROPERTY_SPCODE.Asc()); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public SystemDepartmentEntity GetNewMaxOrderDepartment(SystemDepartmentEntity pEntity) { NHibernateDynamicQueryGenerator <SystemDepartmentEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); if (pEntity != null) { dynamicQueryGenerator.AddWhereClause(SystemDepartmentDataObject.PROPERTY_PARENTDEPARTMENTID.Eq(pEntity)); } else { dynamicQueryGenerator.AddWhereClause(SystemDepartmentDataObject.PROPERTY_PARENTDEPARTMENTID.IsNull()); } //Ö¸¶¨ÅÅÐò¹æÔò dynamicQueryGenerator.AddOrderBy(SystemDepartmentDataObject.PROPERTY_DEPARTMENTSORTINDEX.Desc()); return(this.FindSingleEntityByQueryBuilder(dynamicQueryGenerator)); }
public List <SystemMenuEntity> GetMenuByParentID(SystemMenuEntity menuEntity) { NHibernateDynamicQueryGenerator <SystemMenuEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); //指定查询条件 if (menuEntity != null) { dynamicQueryGenerator.AddWhereClause(SystemMenuDataObject.PROPERTY_PARENTMENUID.Eq(menuEntity)); } else { dynamicQueryGenerator.AddWhereClause(SystemMenuDataObject.PROPERTY_PARENTMENUID.IsNull()); } //指定排序规则 dynamicQueryGenerator.AddOrderBy(SystemMenuDataObject.PROPERTY_MENUORDER.Asc()); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
/// <summary> /// 分页查找所拥护 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="totalRecords"></param> /// <returns></returns> public List <SystemUserEntity> FindAllUsers(int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddOrderBy(PROPERTY_USERID.Desc()); PageQueryParams pageQueryParams = new PageQueryParams(); pageQueryParams.PageIndex = pageIndex; pageQueryParams.PageSize = pageSize; List <SystemUserEntity> result = this.FindListByPageByQueryBuilder(queryGenerator, pageQueryParams); totalRecords = pageQueryParams.RecordCount; return(result); }
public SystemMenuEntity GetNewMaxMenuByParentMenuAndApplication(SystemMenuEntity entity, SystemApplicationEntity applicationEntity) { NHibernateDynamicQueryGenerator <SystemMenuEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); //指定查询条件 dynamicQueryGenerator.AddWhereClause(SystemMenuDataObject.PROPERTY_APPLICATIONID.Eq(applicationEntity)); if (entity != null) { dynamicQueryGenerator.AddWhereClause(SystemMenuDataObject.PROPERTY_PARENTMENUID.Eq(entity)); } else { dynamicQueryGenerator.AddWhereClause(SystemMenuDataObject.PROPERTY_PARENTMENUID.IsNull()); } //指定排序规则 dynamicQueryGenerator.AddOrderBy(SystemMenuDataObject.PROPERTY_MENUORDER.Desc()); return(this.FindSingleEntityByQueryBuilder(dynamicQueryGenerator)); }
public SystemRoleEntity GetUserMinRoleTypeRole(SystemUserEntity systemUserEntity) { NHibernateDynamicQueryGenerator <SystemUserRoleRelationEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_USERID.Eq(systemUserEntity)); InClude_RoleID_Query(queryGenerator); queryGenerator.AddOrderBy(PROPERTY_ROLEID_ROLETYPE.Asc()); SystemUserRoleRelationEntity userRoleRelationEntity = this.FindSingleEntityByQueryBuilder(queryGenerator); if (userRoleRelationEntity == null) { return(null); } else { return(userRoleRelationEntity.RoleID); } }
public List <SPPaymentInfoEntity> FindAllByChannelIDAndClientChannelIDAndPhoneList(SPChannelEntity channelId, int clientChannelId, List <string> phones) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); if (channelId != null) { queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId)); } if (clientChannelId > 0) { queryBuilder.AddWhereClause(PROPERTY_CHANNLECLIENTID.Eq(clientChannelId)); } if (phones != null && phones.Count > 0) { queryBuilder.AddWhereClause(PROPERTY_MOBILENUMBER.In(phones)); } queryBuilder.AddOrderBy(PROPERTY_ID.Asc()); return(FindListByQueryBuilder(queryBuilder)); }