public CommonModelDTO<Work> GetWorkByUserId(int annoucerID, int pagesize = 10, int pageindex = 1)
{
int count = db.Works.Count();
var list = db.Works.Where(x => x.AnnouncerId == annoucerID).OrderBy(x => x.Id).Skip((pageindex - 1) * pagesize).Take(pagesize).ToList();
var dto = new CommonModelDTO<Work>(list, count, pagesize, pageindex);
return dto;
}
public CommonModelDTO<Category> GetCategories(int cateid,int pagesize=10, int pageindex=1)
{
int count = db.Categories.Count();
List<Category> list;
if (cateid>0)
{
list = db.Categories.Where(x => x.ParentCateId == cateid).OrderBy(x => x.Id).Skip((pageindex - 1) * pagesize).Take(pagesize).ToList();
}
else
{
list = db.Categories.OrderBy(x => x.Id).Skip((pageindex - 1) * pagesize).Take(pagesize).ToList();
}
var dto = new CommonModelDTO<Category>(list, count, pagesize, pageindex);
return dto;
}
public CommonModelDTO<Section> GetSections(int workid,int pagesize = 10, int pageindex = 1)
{
int count = db.Sections.Count();
List<Section> list;
if (workid>0)
{
list = db.Sections.Where(x => x.WorkId == workid).OrderBy(x => x.Id).Skip((pageindex - 1) * pagesize).Take(pagesize).ToList();
}
else
{
list = db.Sections.OrderBy(x => x.Id).Skip((pageindex - 1) * pagesize).Take(pagesize).ToList();
}
var dto = new CommonModelDTO<Section>(list, count, pagesize, pageindex);
return dto;
}
public CommonModelDTO<Work> GetWorkByUserId(string keyword, int pagesize = 10, int pageindex = 1)
{
int count = db.Works.Count();
var list = db.Works.Where(x=>x.Name.Contains(keyword)||x.Breif.Contains(keyword)).OrderBy(x => x.Id).Skip((pageindex - 1) * pagesize).Take(pagesize).ToList();
var dto = new CommonModelDTO<Work>(list, count, pagesize, pageindex);
return dto;
}
public CommonModelDTO<Work> WorkByHot(int pagesize = 10, int pageindex = 1)
{
int count = db.Works.Count();
var list = db.Works.OrderByDescending(x => x.Hot).Skip((pageindex - 1) * pagesize).Take(pagesize).ToList();
var dto = new CommonModelDTO<Work>(list, count, pagesize, pageindex);
return dto;
}
public CommonModelDTO<Work> WorkByCateId(int cateid, int pagesize = 10, int pageindex = 1)
{
int count = db.Works.Count();
var list = db.Works.Where(x => x.CateId == cateid).OrderBy(x => x.Id).Skip((pageindex - 1) * pagesize).Take(pagesize).ToList();
var dto = new CommonModelDTO<Work>(list, count, pagesize, pageindex);
return dto;
}
