/// <summary>
/// 根据实体条件查询分页数据
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <returns>符合条件的实体</returns>
public PagedQueryResult <EclubMicroEntity> MicroIssuePageGet(EclubMicroEntity pQueryEntity, int pageIndex, int pageSize, string sortField, int?sortOrder)
{
//Get Micro IDs
OrderBy[] pOrderBys = null;
if (!string.IsNullOrEmpty(sortField))
{
OrderByDirections dir = OrderByDirections.Asc;
if (sortOrder != null && sortOrder == 0)
{
dir = OrderByDirections.Desc;
}
pOrderBys = new OrderBy[] { new OrderBy()
{
FieldName = sortField, Direction = dir
} };
}
//Get Detail Info
PagedQueryResult <EclubMicroEntity> result = _currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pageSize, pageIndex);
foreach (EclubMicroEntity entity in result.Entities)
{
entity.PublishDate = entity.PublishTime != null?entity.PublishTime.Value.ToString("yyyy-MM-dd") : string.Empty;
}
return(result);
}
public TQueryBuilder OrderBy(TOrderBy orderByValue, OrderByDirections orderByDirection = OrderByDirections.Ascending)
{
Query.OrderBy = new List <Tuple <TOrderBy, OrderByDirections> >()
{
Tuple.Create(orderByValue, orderByDirection)
};
return(this as TQueryBuilder);
}
/// <summary>
/// 向后拼接一个排序方法。
/// </summary>
/// <param name="orderByDirection">排序方向</param>
protected virtual void BuildOrderByDirections(OrderByDirections orderByDirection)
{
switch (orderByDirection)
{
case OrderByDirections.None:
break;
case OrderByDirections.ASC:
BuildCode(Code_Space);
BuildCode(Code_ASC);
break;
case OrderByDirections.DESC:
BuildCode(Code_Space);
BuildCode(Code_DESC);
break;
default:
throw new NotSupportedException();
}
}
public PagedResult<object> GetUsers(
int p,
string prop,
OrderByDirections dir,
string f)
{
int pageSize = GetPageSize();
int total;
var items = Services
.UserService
.GetAll(0, int.MaxValue, out total);
if (!string.IsNullOrWhiteSpace(f))
{
var filteredItems = FilterUsers(items, f);
return GetOrderedPagedResult(filteredItems, p, pageSize, filteredItems.Count(), prop, dir);
}
return GetOrderedPagedResult(items, p, pageSize, total, prop, dir);
}
public DefaultOrderByAttribute(int fieldOrder = 0, OrderByDirections orderByDirection = OrderByDirections.Ascending)
{
this.OrderByDirection = orderByDirection;
this.FieldOrder = fieldOrder;
}
protected override GetAggSetoffForToolByConditionListRD ProcessRequest(APIRequest <GetAggSetoffForToolListRP> pRequest)
{
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; //登录状态信息
var rd = new GetAggSetoffForToolByConditionListRD();
var parameter = pRequest.Parameters;
pRequest.Parameters.PageSize = pRequest.Parameters.PageSize == 0 ? 10 : pRequest.Parameters.PageSize;
Agg_SetoffForToolBLL bll = new Agg_SetoffForToolBLL(loggingSessionInfo);
//查询参数
List <IWhereCondition> complexCondition = new List <IWhereCondition> {
};
complexCondition.Add(new EqualsCondition()
{
FieldName = "a.CustomerID", Value = loggingSessionInfo.ClientID
}); //默认条件
if (!string.IsNullOrEmpty(parameter.SetoffRoleId))
{
complexCondition.Add(new EqualsCondition()
{
FieldName = "a.SetoffToolType", Value = parameter.SetoffRoleId
});
}
if (!string.IsNullOrEmpty(parameter.starttime))
{
complexCondition.Add(new DirectCondition("a.DateCode>= '" + parameter.starttime + "' "));
}
if (!string.IsNullOrEmpty(parameter.endtime))
{
complexCondition.Add(new DirectCondition("a.DateCode<= '" + parameter.endtime + "' "));
}
if (String.IsNullOrEmpty(parameter.SortName))
{
parameter.SortName = "OrderAmount";
}
else
{
parameter.SortName = parameter.SortName;
}
if (String.IsNullOrEmpty(parameter.SortOrder))
{
parameter.SortOrder = "0";
}
OrderByDirections directionenum = (OrderByDirections)Enum.Parse(typeof(OrderByDirections), parameter.SortOrder);
List <OrderBy> lstOrder = new List <OrderBy> {
new OrderBy()
{
FieldName = parameter.SortName, Direction = directionenum
}
};
var tempList = bll.FindAllByPage(complexCondition.ToArray(), lstOrder.ToArray(), parameter.PageSize, parameter.PageIndex);
rd.TotalPageCount = tempList.PageCount;
rd.TotalCount = tempList.RowCount;
rd.aggsetoffforToollist = tempList.Entities.Select(m => new AggSetoffForToolByConditionList()
{
ID = m.ID.ToString(),
ObjectName = m.ObjectName,
SetoffRole = bll.GetSetoffToolTypeNameBySetoffToolType(m.SetoffToolType),
ShareCount = m.ShareCount.ToString(),
OrderAmount = m.OrderAmount.ToString(),
SetoffCount = m.SetoffCount.ToString()
}).ToList();
return(rd);
}
public TQueryBuilder ThenOrderBy(TOrderBy orderByValue, OrderByDirections orderByDirection = OrderByDirections.Ascending)
{
Query.OrderBy.Add(Tuple.Create(orderByValue, orderByDirection));
return(this as TQueryBuilder);
}
/// <summary>
/// 构建排序信息
/// </summary>
/// <param name="column">要排序的列</param>
/// <param name="direction">排序方向</param>
public OrderBy(Column column, OrderByDirections direction)
{
Column = column;
Direction = direction;
}
private PagedResult<object> GetOrderedPagedResult(
IEnumerable<IUser> items,
int page,
int pageSize,
int total,
string property,
OrderByDirections direction)
{
return new PagedResult<object>(total, page, pageSize)
{
Items = items
.Select(x => new
{
Id = x.Id,
Name = x.Name,
Email = x.Email,
UserType = x.UserType.Name,
Active = x.IsApproved && !x.IsLockedOut
})
.OrderBy(property, direction)
.Skip(page * pageSize)
.Take(pageSize)
};
}
