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