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 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 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 List <SystemViewItemEntity> GetList_By_SystemViewID_SystemViewEntity(SystemViewEntity fkentity) { NHibernateDynamicQueryGenerator <SystemViewItemEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_SYSTEMVIEWID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SystemPersonalizationSettingsEntity> GetList_By_ApplicationID_SystemApplicationEntity(SystemApplicationEntity fkentity) { NHibernateDynamicQueryGenerator <SystemPersonalizationSettingsEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_APPLICATIONID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public SystemConfigEntity GetConfigByKey(string key) { NHibernateDynamicQueryGenerator <SystemConfigEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_CONFIGKEY.Eq(key)); return(this.FindSingleEntityByQueryBuilder(queryGenerator)); }
public List <SystemResourcesEntity> GetList_By_MoudleID_SystemMoudleEntity(SystemMoudleEntity fkentity) { NHibernateDynamicQueryGenerator <SystemResourcesEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_MOUDLEID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SPChannelEntity> GetList_By_UpperID_SPUpperEntity(SPUpperEntity fkentity) { NHibernateDynamicQueryGenerator <SPChannelEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_UPPERID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SystemPrivilegeEntity> GetList_By_OperationID_SystemOperationEntity(SystemOperationEntity fkentity) { NHibernateDynamicQueryGenerator <SystemPrivilegeEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_OPERATIONID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SystemPrivilegeInRolesEntity> GetAllPrivilegeByCategoryByUserID(SystemUserEntity userEntity) { NHibernateDynamicQueryGenerator <SystemPrivilegeInRolesEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_ROLEID.In(QueryObjects.GetUserAssignedRoles(userEntity))); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
/// <summary> /// 获取角色分配的权限 /// </summary> /// <param name="role"></param> /// <returns></returns> public List <SystemPrivilegeEntity> GetRoleAssignedPermissions(SystemRoleEntity role) { NHibernateDynamicQueryGenerator <SystemPrivilegeInRolesEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_ROLEID.Eq(role)); return(FindListByProjection <SystemPrivilegeEntity>(dynamicQueryGenerator, PROPERTY_PRIVILEGEID)); }
public List <SystemPrivilegeInRolesEntity> GetRoleAssignedPrivilegesInRole(SystemRoleEntity systemRoleEntity) { NHibernateDynamicQueryGenerator <SystemPrivilegeInRolesEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_ROLEID.Eq(systemRoleEntity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public SPClientGroupEntity GetByUserID(int userId) { NHibernateDynamicQueryGenerator <SPClientGroupEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_USERID.Eq(userId)); return(this.FindSingleEntityByQueryBuilder(queryGenerator)); }
public List <SystemDepartmentEntity> GetList_By_OrganizationID_SystemOrganizationEntity(SystemOrganizationEntity fkentity) { NHibernateDynamicQueryGenerator <SystemDepartmentEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_ORGANIZATIONID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SPPaymentInfoEntity> GetList_By_SPClientEntity(SPClientEntity fkentity) { NHibernateDynamicQueryGenerator <SPPaymentInfoEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_CLIENTID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SPChannelSycnParamsEntity> GetList_By_ChannelID_SPChannelEntity(SPChannelEntity fkentity) { NHibernateDynamicQueryGenerator <SPChannelSycnParamsEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_CHANNELID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SystemPrivilegeEntity> GetList_By_ResourcesID_SystemResourcesEntity(SystemResourcesEntity fkentity) { NHibernateDynamicQueryGenerator <SystemPrivilegeEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_RESOURCESID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SystemConfigEntity> GetList_By_ConfigGroupID_SystemConfigGroupEntity(SystemConfigGroupEntity fkentity) { NHibernateDynamicQueryGenerator <SystemConfigEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_CONFIGGROUPID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
/// <summary> /// 通过权限代码获取权限 /// </summary> /// <param name="permissionCode"></param> /// <returns></returns> public SystemPrivilegeEntity GetByCode(string permissionCode) { NHibernateDynamicQueryGenerator <SystemPrivilegeEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_PRIVILEGEENNAME.Eq(permissionCode)); return(this.FindSingleEntityByQueryBuilder(dynamicQueryGenerator)); }
public List <SPClientChannelSettingEntity> GetSettingByClient(SPClientEntity spClientEntity) { NHibernateDynamicQueryGenerator <SPClientChannelSettingEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_CLINETID.Eq(spClientEntity)); return(this.FindListByQueryBuilder(queryGenerator)); }
public SystemRoleEntity GetRoleByCode(string roleCode) { NHibernateDynamicQueryGenerator <SystemRoleEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_ROLECODE.Eq(roleCode)); return(this.FindSingleEntityByQueryBuilder(queryGenerator)); }
public List <SystemPrivilegeInRolesEntity> GetList_By_PrivilegeID_SystemPrivilegeEntity(SystemPrivilegeEntity fkentity) { NHibernateDynamicQueryGenerator <SystemPrivilegeInRolesEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_PRIVILEGEID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SPClientCodeRelationEntity> GetList_By_CodeID_SPCodeEntity(SPCodeEntity fkentity) { NHibernateDynamicQueryGenerator <SPClientCodeRelationEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_CODEID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SystemPersonalizationSettingsEntity> GetList_By_UserId_SystemUserEntity(SystemUserEntity fkentity) { NHibernateDynamicQueryGenerator <SystemPersonalizationSettingsEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_USERID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SPClientCodeRelationEntity> GetList_By_SyncDataSetting_SPSDataSycnSettingEntity(SPSDataSycnSettingEntity fkentity) { NHibernateDynamicQueryGenerator <SPClientCodeRelationEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_SYNCDATASETTING.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public SPChannelEntity FindByAlias(string aliasName) { NHibernateDynamicQueryGenerator <SPChannelEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_FUZZYCOMMAND.Eq(aliasName)); return(this.FindSingleEntityByQueryBuilder(queryGenerator)); }
public List <SystemRoleEntity> GetAssignedRoleByUserGroup(SystemUserGroupEntity entity) { NHibernateDynamicQueryGenerator <SystemUserGroupRoleRelationEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_USERGROUPID.Eq(entity)); return(this.FindListByProjection <SystemRoleEntity>(queryGenerator, PROPERTY_ROLEID)); }
public List <SystemRoleApplicationEntity> GetList_By_RoleID_SystemRoleEntity(SystemRoleEntity fkentity) { NHibernateDynamicQueryGenerator <SystemRoleApplicationEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); dynamicQueryGenerator.AddWhereClause(PROPERTY_ROLEID.Eq(fkentity)); return(this.FindListByQueryBuilder(dynamicQueryGenerator)); }
public List <SPPaymentInfoEntity> FindAllNotSendData(int clientChannelId, DateTime startDate, DateTime endDate, int maxRetryCount) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); if (startDate == DateTime.MinValue) { startDate = DateTime.Now.Date; } if (endDate == DateTime.MinValue) { endDate = DateTime.Now.Date; } queryBuilder.AddWhereClause(PROPERTY_CHANNLECLIENTID.Eq(clientChannelId)); queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startDate.Date)); queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(endDate.AddDays(1).Date)); queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_SUCESSSTOSEND.Eq(false)); queryBuilder.AddWhereClause(PROPERTY_ISSYCNDATA.Eq(true)); queryBuilder.AddWhereClause(Or(PROPERTY_SYCNRETRYTIMES.IsNull(), PROPERTY_SYCNRETRYTIMES.Lt(maxRetryCount))); queryBuilder.AddOrderBy(PROPERTY_ID.Asc()); return(this.FindListByQueryBuilder(queryBuilder)); }
public List <SPPaymentInfoEntity> FindAllByOrderByAndSPClientGroupIDAndDateAndProviceNoIntercept(List <SPClientEntity> spClientEntities, DateTime startDate, DateTime endDate, string province, string city, string phone, string sortFieldName, bool isdesc, int pageIndex, int limit, out int recordCount) { var queryBuilder = new NHibernateDynamicQueryGenerator <SPPaymentInfoEntity>(); queryBuilder.AddWhereClause(PROPERTY_CLIENTID.In(spClientEntities)); if (startDate == DateTime.MinValue) { startDate = DateTime.Now; } if (endDate == DateTime.MinValue) { endDate = DateTime.Now; } if (!string.IsNullOrEmpty(province)) { if (province.Equals("NULL")) { queryBuilder.AddWhereClause(PROPERTY_PROVINCE.Eq("")); } else { queryBuilder.AddWhereClause(PROPERTY_PROVINCE.Eq(province)); } } if (!string.IsNullOrEmpty(city)) { queryBuilder.AddWhereClause(PROPERTY_CITY.Eq(city)); } if (!string.IsNullOrEmpty(phone)) { queryBuilder.AddWhereClause(PROPERTY_MOBILENUMBER.Like(phone, MatchMode.Start)); } queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Ge(startDate.Date)); queryBuilder.AddWhereClause(PROPERTY_CREATEDATE.Lt(endDate.AddDays(1).Date)); queryBuilder.AddWhereClause(PROPERTY_ISINTERCEPT.Eq(false)); AddDefaultOrderByToQueryGenerator(sortFieldName, isdesc, queryBuilder); queryBuilder.SetFirstResult((pageIndex - 1) * limit); queryBuilder.SetMaxResults(limit); return(FindListByPageByQueryBuilder(queryBuilder, out recordCount)); }
/// <summary> /// 获取角色包含的所有用户 /// </summary> /// <param name="role">角色</param> /// <returns></returns> public List <SystemUserEntity> GetRoleAssignedUsers(SystemRoleEntity role) { NHibernateDynamicQueryGenerator <SystemUserRoleRelationEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(SystemUserRoleRelationDataObject.PROPERTY_ROLEID.Eq(role)); return (this.FindListByProjection <SystemUserEntity>(queryGenerator, SystemUserRoleRelationDataObject.PROPERTY_USERID)); }
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 <SPDayReportEntity> FindByDate(DateTime date) { NHibernateDynamicQueryGenerator <SPDayReportEntity> dynamicQueryGenerator = this.GetNewQueryBuilder(); //指定查询条件 dynamicQueryGenerator.AddWhereClause(PROPERTY_REPORTDATE.Eq(date.Date)); return(this.FindListByQueryBuilder(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; } }
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; }