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; }