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