public SPRecordEntity FindByLinkIDAndChannelID(SPChannelEntity spChannelEntity, string linkId) { var queryBuilder = new NHibernateDynamicQueryGenerator<SPRecordEntity>(); queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(spChannelEntity)); queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(linkId)); return this.FindSingleEntityByQueryBuilder(queryBuilder); }
public SPSStatePaymentInfoEntity FindByChannelIDAndLinkID(int channelId, string linkid) { var queryBuilder = new NHibernateDynamicQueryGenerator<SPSStatePaymentInfoEntity>(); queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId)); queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(linkid)); return this.FindSingleEntityByQueryBuilder(queryBuilder); }
public SPSStatePaymentInfoEntity CheckChannleLinkIDIsExist(int channelID, SPSStatePaymentInfoEntity statePaymentInfoEntity, List<string> uniqueKeyNames) { var queryBuilder = new NHibernateDynamicQueryGenerator<SPSStatePaymentInfoEntity>(); queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channelID)); queryBuilder.AddWhereClause(PROPERTY_LINKID.Eq(statePaymentInfoEntity.Linkid)); if (uniqueKeyNames.Contains("mobile")) queryBuilder.AddWhereClause(PROPERTY_MOBILENUMBER.Eq(statePaymentInfoEntity.MobileNumber)); return this.FindSingleEntityByQueryBuilder(queryBuilder); }
public override void InClude_Parent_Table(string parent_alias, NHibernateDynamicQueryGenerator <SPAdAssignedHistortyEntity> queryGenerator) { switch (parent_alias) { case "SPAdPackID_SPAdAssignedHistortyEntity_Alias": queryGenerator.AddAlians(SPAdAssignedHistortyEntity.PROPERTY_NAME_SPADPACKID, PROPERTY_SPADPACKID_ALIAS_NAME); break; case "SPClientID_SPAdAssignedHistortyEntity_Alias": queryGenerator.AddAlians(SPAdAssignedHistortyEntity.PROPERTY_NAME_SPCLIENTID, PROPERTY_SPCLIENTID_ALIAS_NAME); break; default: break; } }
public List <SystemUserEntity> FindAuthenticatedUserAll(int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_ISAPPROVED.Eq(true)); queryGenerator.AddWhereClause(PROPERTY_ISLOCKEDOUT.Eq(false)); queryGenerator.SetFirstResult((pageIndex - 1) * pageSize); queryGenerator.SetMaxResults(pageSize); List <SystemUserEntity> result = this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords); return(result); }
public List <SystemUserEntity> FindAllInactiveAuthenticatedProfiles(DateTime inactiveSinceDate, int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_LASTACTIVITYDATE.Lt(inactiveSinceDate)); queryGenerator.AddWhereClause(PROPERTY_ISAPPROVED.Eq(true)); queryGenerator.AddWhereClause(PROPERTY_ISLOCKEDOUT.Eq(false)); queryGenerator.SetFirstResult((pageIndex - 1) * pageSize); queryGenerator.SetMaxResults(pageSize); return(this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords)); }
public override void InClude_Parent_Table(string parent_alias, NHibernateDynamicQueryGenerator <SystemPrivilegeInRolesEntity> queryGenerator) { switch (parent_alias) { case "RoleID_SystemPrivilegeInRolesEntity_Alias": queryGenerator.AddAlians(SystemPrivilegeInRolesEntity.PROPERTY_NAME_ROLEID, PROPERTY_ROLEID_ALIAS_NAME); break; case "PrivilegeID_SystemPrivilegeInRolesEntity_Alias": queryGenerator.AddAlians(SystemPrivilegeInRolesEntity.PROPERTY_NAME_PRIVILEGEID, PROPERTY_PRIVILEGEID_ALIAS_NAME); break; default: break; } }
public override void InClude_Parent_Table(string parent_alias, NHibernateDynamicQueryGenerator <SystemRoleMenuRelationEntity> queryGenerator) { switch (parent_alias) { case "MenuID_SystemRoleMenuRelationEntity_Alias": queryGenerator.AddAlians(SystemRoleMenuRelationEntity.PROPERTY_NAME_MENUID, PROPERTY_MENUID_ALIAS_NAME); break; case "RoleID_SystemRoleMenuRelationEntity_Alias": queryGenerator.AddAlians(SystemRoleMenuRelationEntity.PROPERTY_NAME_ROLEID, PROPERTY_ROLEID_ALIAS_NAME); break; default: break; } }
public override void InClude_Parent_Table(string parent_alias, NHibernateDynamicQueryGenerator <SystemPersonalizationSettingsEntity> queryGenerator) { switch (parent_alias) { case "ApplicationID_SystemPersonalizationSettingsEntity_Alias": queryGenerator.AddAlians(SystemPersonalizationSettingsEntity.PROPERTY_NAME_APPLICATIONID, PROPERTY_APPLICATIONID_ALIAS_NAME); break; case "UserId_SystemPersonalizationSettingsEntity_Alias": queryGenerator.AddAlians(SystemPersonalizationSettingsEntity.PROPERTY_NAME_USERID, PROPERTY_USERID_ALIAS_NAME); break; default: break; } }
public override void InClude_Parent_Table(string parent_alias, NHibernateDynamicQueryGenerator <SystemUserGroupUserRelationEntity> queryGenerator) { switch (parent_alias) { case "UserID_SystemUserGroupUserRelationEntity_Alias": queryGenerator.AddAlians(SystemUserGroupUserRelationEntity.PROPERTY_NAME_USERID, PROPERTY_USERID_ALIAS_NAME); break; case "UserGroupID_SystemUserGroupUserRelationEntity_Alias": queryGenerator.AddAlians(SystemUserGroupUserRelationEntity.PROPERTY_NAME_USERGROUPID, PROPERTY_USERGROUPID_ALIAS_NAME); break; default: break; } }
public SPCodeEntity GetCodeByMoAndSPCodeAndMoTypeAndNoFilter(string mo, string spCode, string moType, string spCodeType, string codeType, bool?limitProvince, string limitProvinceArea) { NHibernateDynamicQueryGenerator <SPCodeEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); //指定查询条件 dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_CODETYPE.Eq(codeType)); dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_MO.Eq(mo)); dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_MOTYPE.Eq(moType)); dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_SPCODE.Eq(spCode)); dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_SPCODETYPE.Eq(spCodeType)); dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_LIMITPROVINCE.Eq(limitProvince.Value)); dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_LIMITPROVINCEAREA.Eq(limitProvinceArea)); dynamicQueryGenerator.AddWhereClause(SPCodeDataObject.PROPERTY_HASFILTERS.Eq(false)); return(this.FindSingleEntityByQueryBuilder(dynamicQueryGenerator)); }
public List <DomainType> FindAllByOrderByAndFilter(List <QueryFilter> filters, string orderByColumn, bool isDesc, int firstRow, int maxRows, out int recordCount) { NHibernateDynamicQueryGenerator <DomainType> queryBuilder = new NHibernateDynamicQueryGenerator <DomainType>(); //构造Filter查询条件 AddQueryFiltersToQueryGenerator(filters, queryBuilder); AddDefaultOrderByToQueryGenerator(orderByColumn, isDesc, queryBuilder); queryBuilder.SetFirstResult(firstRow); queryBuilder.SetMaxResults(maxRows); List <DomainType> results = FindListByPageByQueryBuilder(queryBuilder, out recordCount); return(results); }
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)); }
private static void SetReportTypeFilter(NHibernateDynamicQueryGenerator<SPRecordEntity> queryBuilder, DayReportType reportType) { switch (reportType) { case DayReportType.AllUp: //queryBuilder.AddWhereClause(PROPERTY_ISREPORT.Eq(false)); break; case DayReportType.AllUpSuccess: //queryBuilder.AddWhereClause(PROPERTY_ISREPORT.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_ISSTATOK.Eq(true)); break; case DayReportType.Intercept: //queryBuilder.AddWhereClause(PROPERTY_ISREPORT.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_ISSTATOK.Eq(true)); queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(true)); break; case DayReportType.Down: //queryBuilder.AddWhereClause(PROPERTY_ISREPORT.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_ISSTATOK.Eq(true)); queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false)); break; case DayReportType.DownNotSycn: //queryBuilder.AddWhereClause(PROPERTY_ISREPORT.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_ISSTATOK.Eq(true)); queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_ISSYCNTOCLIENT.Eq(false)); break; case DayReportType.DownSycnSuccess: //queryBuilder.AddWhereClause(PROPERTY_ISREPORT.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_ISSTATOK.Eq(true)); queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_ISSYCNTOCLIENT.Eq(true)); queryBuilder.AddWhereClause(PROPERTY_ISSYCNSUCCESSED.Eq(true)); break; case DayReportType.DownSycnFailed: //queryBuilder.AddWhereClause(PROPERTY_ISREPORT.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_ISSTATOK.Eq(true)); queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_ISSYCNTOCLIENT.Eq(true)); queryBuilder.AddWhereClause(PROPERTY_ISSYCNSUCCESSED.Eq(false)); break; default: break; } }
/// <summary> /// 通过用户名分页查找用户 /// </summary> /// <param name="userName"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="totalRecords"></param> /// <returns></returns> public List <SystemUserEntity> FindUsersByName(string userName, int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_USERLOGINID.Like(userName)); PageQueryParams pageQueryParams = new PageQueryParams(); pageQueryParams.PageIndex = pageIndex; pageQueryParams.PageSize = pageSize; List <SystemUserEntity> result = this.FindListByPageByQueryBuilder(queryGenerator, pageQueryParams); totalRecords = pageQueryParams.RecordCount; return(result); }
internal List <SystemUserEntity> FindAllInactiveProfiles(DateTime inactiveSinceDate, int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_LASTACTIVITYDATE.Lt(inactiveSinceDate)); PageQueryParams pageQueryParams = new PageQueryParams(); pageQueryParams.PageIndex = pageIndex; pageQueryParams.PageSize = pageSize; List <SystemUserEntity> result = this.FindListByPageByQueryBuilder(queryGenerator, pageQueryParams); totalRecords = pageQueryParams.RecordCount; return(result); }
public List <SPChannelParamsEntity> FindPageDataByChannelID(string orderByColumnName, bool isDesc, int pageIndex, int pageSize, SPChannelEntity channle, out int recordCount) { NHibernateDynamicQueryGenerator <SPChannelParamsEntity> queryGenerator = this.GetNewQueryBuilder(); if (channle == null) { recordCount = 0; return(new List <SPChannelParamsEntity>()); } else { queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channle)); } AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, queryGenerator); return(this.FindListByPageByQueryBuilder(queryGenerator, pageIndex, pageSize, out recordCount)); }
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)); }
public List <SystemPrivilegeEntity> TestFindResouceNameAndOPName(string resourceName, string opName) { NHibernateDynamicQueryGenerator <SystemPrivilegeEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); InClude_OperationID_Query(dynamicQueryGenerator); InClude_ResourcesID_Query(dynamicQueryGenerator); dynamicQueryGenerator.AddWhereClause(PROPERTY_PRIVILEGEID.Gt(0)); dynamicQueryGenerator.AddWhereClause(PROPERTY_OPERATIONID_OPERATIONNAMECN.Eq("添加")); dynamicQueryGenerator.AddWhereClause(PROPERTY_RESOURCESID_RESOURCESNAMECN.Eq("产品")); dynamicQueryGenerator.AddOrderBy(PROPERTY_PRIVILEGEID.Desc()); dynamicQueryGenerator.AddOrderBy(PROPERTY_OPERATIONID_OPERATIONNAMECN.Desc()); dynamicQueryGenerator.AddOrderBy(PROPERTY_RESOURCESID_RESOURCESNAMECN.Desc()); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SystemMenuEntity> GetRoleAssignMenu(List <SystemRoleEntity> entities) { NHibernateDynamicQueryGenerator <SystemRoleMenuRelationEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_ROLEID.In(entities)); InClude_MenuID_Query(queryGenerator); queryGenerator.AddWhereClause(PROPERTY_MENUID_MENUISENABLE.Eq(true)); //使用disticnt以后无法排序 //queryGenerator.AddOrderBy(PROPERTY_MENUID_PARENTMENUID.Asc()); //queryGenerator.AddOrderBy(PROPERTY_MENUID_MENUORDER.Asc()); return(this.FindListByProjection <SystemMenuEntity>(queryGenerator, GetDistinctProperty(PROPERTY_MENUID.CriterionProperty))); }
/// <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 List <SPCodeInfoEntity> FindAllByOrderByAndFilterAndChannelID(SPChannelEntity channelEntity, List <QueryFilter> filters, string orderByColumnName, bool isDesc, int pageIndex, int pageSize, out int recordCount) { NHibernateDynamicQueryGenerator <SPCodeInfoEntity> queryGenerator = this.GetNewQueryBuilder(); if (channelEntity != null) { queryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(channelEntity)); } AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, queryGenerator); queryGenerator.SetFirstResult((pageIndex - 1) * pageSize); queryGenerator.SetMaxResults(pageSize); List <SPCodeInfoEntity> results = FindListByPageByQueryBuilder(queryGenerator, out recordCount); return(results); }
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)); }
private NHibernateDynamicQueryGenerator <SPRecordEntity> BuilderQueryGenerator(SPChannelEntity channel, SPCodeEntity code, SPSClientEntity client, string dataType, DateTime?startDate, DateTime?endDate, List <QueryFilter> filters, string orderByColumnName, bool isDesc) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPRecordEntity>(); if (channel != null) { queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channel)); } if (code != null) { queryBuilder.AddWhereClause(PROPERTY_CODEID.Eq(code)); } if (client != null) { queryBuilder.AddWhereClause(PROPERTY_CLIENTID.Eq(client)); } DayReportType reportType = (DayReportType)Enum.Parse(typeof(DayReportType), dataType); SetReportTypeFilter(queryBuilder, reportType); if (startDate != null) { queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startDate.Value.Date)); } if (endDate != null) { queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(endDate.Value.Date.AddDays(1))); } AddQueryFiltersToQueryGenerator(filters, queryBuilder); AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, queryBuilder); return(queryBuilder); }
public List <SystemUserEntity> FindAuthenticatedUserAll(int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_ISAPPROVED.Eq(true)); queryGenerator.AddWhereClause(PROPERTY_ISLOCKEDOUT.Eq(false)); PageQueryParams pageQueryParams = new PageQueryParams(); pageQueryParams.PageIndex = pageIndex; pageQueryParams.PageSize = pageSize; List <SystemUserEntity> result = this.FindListByPageByQueryBuilder(queryGenerator, pageQueryParams); totalRecords = pageQueryParams.RecordCount; return(result); }
public override void InClude_Parent_Table(string parent_alias, NHibernateDynamicQueryGenerator <SystemDepartmentPostRoleRelationEntity> queryGenerator) { switch (parent_alias) { case "DepartmentID_SystemDepartmentPostRoleRelationEntity_Alias": queryGenerator.AddAlians(SystemDepartmentPostRoleRelationEntity.PROPERTY_NAME_DEPARTMENTID, PROPERTY_DEPARTMENTID_ALIAS_NAME); break; case "PostID_SystemDepartmentPostRoleRelationEntity_Alias": queryGenerator.AddAlians(SystemDepartmentPostRoleRelationEntity.PROPERTY_NAME_POSTID, PROPERTY_POSTID_ALIAS_NAME); break; case "RoleID_SystemDepartmentPostRoleRelationEntity_Alias": queryGenerator.AddAlians(SystemDepartmentPostRoleRelationEntity.PROPERTY_NAME_ROLEID, PROPERTY_ROLEID_ALIAS_NAME); break; default: break; } }
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 override void InClude_Parent_Table(string parent_alias, NHibernateDynamicQueryGenerator <SPClientCodeRelationEntity> queryGenerator) { switch (parent_alias) { case "CodeID_SPClientCodeRelationEntity_Alias": queryGenerator.AddAlians(SPClientCodeRelationEntity.PROPERTY_NAME_CODEID, PROPERTY_CODEID_ALIAS_NAME); break; case "ClientID_SPClientCodeRelationEntity_Alias": queryGenerator.AddAlians(SPClientCodeRelationEntity.PROPERTY_NAME_CLIENTID, PROPERTY_CLIENTID_ALIAS_NAME); break; case "SyncDataSetting_SPClientCodeRelationEntity_Alias": queryGenerator.AddAlians(SPClientCodeRelationEntity.PROPERTY_NAME_SYNCDATASETTING, PROPERTY_SYNCDATASETTING_ALIAS_NAME); break; default: break; } }
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 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> FindAllByOrderByAndCleintIDAndChanneLIDAndDateNoIntercept(SPChannelEntity channelId, SPClientEntity clientId, DateTime startDateTime, DateTime enddateTime, string sortFieldName, bool isDesc, int pageIndex, int pageSize, out int recordCount) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); if (channelId != null) { queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channelId)); } if (clientId != null) { queryBuilder.AddWhereClause(PROPERTY_CLIENTID.Eq(clientId)); } if (startDateTime == DateTime.MinValue) { startDateTime = DateTime.Now; } if (enddateTime == DateTime.MinValue) { enddateTime = DateTime.Now; } queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startDateTime.Date)); queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(enddateTime.AddDays(1).Date)); queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false)); AddDefaultOrderByToQueryGenerator(sortFieldName, isDesc, queryBuilder); queryBuilder.SetFirstResult((pageIndex - 1) * pageSize); queryBuilder.SetMaxResults(pageSize); return(FindListByPageByQueryBuilder(queryBuilder, out recordCount)); }
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 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 <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)); }
private NHibernateDynamicQueryGenerator<SPRecordEntity> BuilderQueryGenerator(SPChannelEntity channel, SPCodeEntity code, SPSClientEntity client, string dataType, DateTime? startDate, DateTime? endDate, List<QueryFilter> filters, string orderByColumnName, bool isDesc) { var queryBuilder = new NHibernateDynamicQueryGenerator<SPRecordEntity>(); if (channel!=null) queryBuilder.AddWhereClause(PROPERTY_CHANNELID.Eq(channel)); if (code != null) queryBuilder.AddWhereClause(PROPERTY_CODEID.Eq(code)); if (client != null) queryBuilder.AddWhereClause(PROPERTY_CLIENTID.Eq(client)); DayReportType reportType = (DayReportType) Enum.Parse(typeof (DayReportType), dataType); SetReportTypeFilter(queryBuilder, reportType); if (startDate != null) queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startDate.Value.Date)); if (endDate != null) queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(endDate.Value.Date.AddDays(1))); AddQueryFiltersToQueryGenerator(filters, queryBuilder); AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, queryBuilder); return queryBuilder; }