public ApiKeyValue <string, string>[] GetCarId(Contracts.ApiPagination pagination, string keyWord)
{
using (var db = new RepositoryBase().BeginTrans())
{
IQueryable <ProfileSanitationCarEntity> query = db.IQueryable <ProfileSanitationCarEntity>();
//模糊查询
if (!string.IsNullOrEmpty(keyWord))
{
query = query.Where(d => d.CarId.Contains(keyWord));
}
//分页
if (pagination != null)
{
pagination.records = query.Count();
query = query.OrderBy(d => d.CarId).Skip(pagination.rows * (pagination.page - 1)).Take(pagination.rows);
}
return(query.Select(d => new ApiKeyValue <string, string>()
{
Key = d.CarId,
Value = d.WorkShift
}).ToArray());
}
}
public IHttpActionResult GetWorkShift(int pageSize, int pageIndex, string keyWord = null)
{
Nfine.WebApi.Contracts.ApiPagination pagination = null;
pagination = new Contracts.ApiPagination()
{
page = (int)pageIndex,
rows = (int)pageSize
};
var data = new ApiPaginationData <string[]>()
{
Data = Code.GetWorkShift(pagination, keyWord),
Pagination = pagination
};
var result = ApiBackParameter <ApiPaginationData <string[]> > .Get((api) =>
{
api.StatusCode = StatusCodeEnum.成功.GetIntValue();
api.Data = data;
});
return(Ok(result));
}
