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