public IHttpActionResult Get(string title = "", DateTime?date = null, int pageSize = 20, int pageIndex = 1)
{
AjaxPageResult <IQueryable <WorkLog> > result = new AjaxPageResult <IQueryable <WorkLog> >();
IQueryable <WorkLog> data = null;
data = _WorkLogDAL.Get();
if (date != null)
{
DateTime tomorrow = date.Value.AddDays(1);
data = data.Where(o => o.CreateTime >= date.Value && o.CreateTime <= tomorrow);
}
if (!string.IsNullOrWhiteSpace(title))
{
data = data.Where(o => o.Title.Contains(title));
}
int total = data.Count();
data = data.OrderByDescending(o => o.CreateTime)
.Skip(pageSize * (pageIndex - 1))
.Take(pageSize);
result.data = data;
result.total = total;
return(Json(result));
}
public IHttpActionResult Get(string name, int pageSize = 20, int pageIndex = 1)
{
AjaxPageResult <DataTable> result = new AjaxPageResult <DataTable>();
DataTable data = _TeamDAL.Get(name, pageSize, pageIndex);
result.data = data;
result.total = data.Rows.Count;
return(Json(result));
}
public IHttpActionResult Get(string name, int state, int pageSize = 20, int pageIndex = 1)
{
AjaxPageResult <DataTable> result = new AjaxPageResult <DataTable>();
DataTable data = _CustomerDAL.Get(name, state, pageSize, pageIndex);
int total = _CustomerDAL.GetCount(name, state);
result.total = total;
result.data = data;
return(Json(result));
}
public IHttpActionResult Get(string name, int pageSize = 20, int pageIndex = 1)
{
AjaxPageResult <IQueryable <Company> > result = new AjaxPageResult <IQueryable <Company> >();
IQueryable <Company> data = _CompanyDAL.Get();
if (!string.IsNullOrWhiteSpace(name))
{
data = data.Where(o => o.CompanyName.Contains(name));
}
int total = data.Count();
data = data.OrderByDescending(o => o.CreateTime)
.Skip(pageSize * (pageIndex - 1))
.Take(pageSize);
result.data = data;
result.total = total;
return(Json(result));
}
