public List <SPClientEntity> FindAllNotInClientGroup(SPClientGroupEntity spClientGroupEntity)
{
NHibernateDynamicQueryGenerator <SPClientEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(Or(Not(PROPERTY_SPCLIENTGROUPID.Eq(spClientGroupEntity)), PROPERTY_SPCLIENTGROUPID.IsNull()));
return(this.FindListByQueryBuilder(queryGenerator));
}
public List <SPClientEntity> GetList_By_SPClientGroupEntity(SPClientGroupEntity fkentity)
{
NHibernateDynamicQueryGenerator <SPClientEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
dynamicQueryGenerator.AddWhereClause(PROPERTY_SPCLIENTGROUPID.Eq(fkentity));
return(this.FindListByQueryBuilder(dynamicQueryGenerator));
}
internal static SPClientGroupWrapper ConvertEntityToWrapper(SPClientGroupEntity entity)
{
if (entity == null)
{
return(null);
}
if (entity.Id == 0)
{
return(null);
}
return(new SPClientGroupWrapper(entity));
}
public List <SPPaymentInfoEntity> FindAllByOrderByAndSPClientGroupIDAndDateAndProviceNoIntercept1(int spClientGroupID, DateTime startDate, DateTime endDate, string province, string city, string phone, string sortFieldName, bool isdesc, int pageIndex, int limit, out int recordCount)
{
SPClientGroupEntity clientGroupEntity = this.DataObjectsContainerIocID.SPClientGroupDataObjectInstance.Load(spClientGroupID);
List <SPClientEntity> spClientEntities =
this.DataObjectsContainerIocID.SPClientDataObjectInstance.GetList_By_SPClientGroupEntity
(clientGroupEntity);
return(this.SelfDataObj.FindAllByOrderByAndSPClientGroupIDAndDateAndProviceNoIntercept(spClientEntities, spClientGroupID,
startDate,
endDate, province, city, phone,
sortFieldName, isdesc,
pageIndex, limit,
out recordCount));
}
public List <SPClientEntity> FindAllBySPClientGroupID(SPClientGroupEntity _sPClientGroupID)
{
return(this.SelfDataObj.GetList_By_SPClientGroupEntity(_sPClientGroupID));
}
public List <SPClientEntity> FindAllByOrderByAndFilterAndSPClientGroupID(string orderByColumnName, bool isDesc, int pageIndex, int pageSize, SPClientGroupEntity _sPClientGroupID, out int recordCount)
{
return(this.SelfDataObj.GetPageList_By_SPClientGroupEntity(orderByColumnName, isDesc, pageIndex, pageSize, _sPClientGroupID, out recordCount));
}
public List <SPClientEntity> GetPageList_By_SPClientGroupEntity(string orderByColumnName, bool isDesc, int pageIndex, int pageSize, SPClientGroupEntity fkentity, out int recordCount)
{
NHibernateDynamicQueryGenerator <SPClientEntity> dynamicQueryGenerator = this.GetNewQueryBuilder();
dynamicQueryGenerator.AddWhereClause(PROPERTY_SPCLIENTGROUPID.Eq(fkentity));
AddDefaultOrderByToQueryGenerator(orderByColumnName, isDesc, dynamicQueryGenerator);
dynamicQueryGenerator.SetFirstResult((pageIndex - 1) * pageSize);
dynamicQueryGenerator.SetMaxResults(pageSize);
return(FindListByPageByQueryBuilder(dynamicQueryGenerator, out recordCount));
}
internal SPClientGroupWrapper(SPClientGroupEntity entityObj)
{
entity = entityObj;
}
