public IHttpActionResult SelectCategory() { CTNEntities1 db = new CTNEntities1(); var list = db.Category .Select(c => new { c.CaID, c.CaName, c.CaQName, c.CaIcon, c.CaOrder }); return(Ok(list)); }
public IHttpActionResult Selectjob(int id) { int index = 1; int size = 5; int count = 0; dynamic data = null; if (id == 1) { CTNEntities1 db = new CTNEntities1(); { count = db.Job.Count(); data = db.Job.OrderByDescending(o => o.JID).Skip((index - 1) * size).Take(size) .Select(j => new { j.JID, Caid = j.Caid, Coid = j.Coid, j.ftime, j.Jdepict, j.JName, j.JNrank, j.Jquality, j.Jrank, j.Jsalary, j.Jzdsaldw, j.Jzdsaldy, j.Jzgsaldy, j.Place, j.Ptime }).ToList(); } int PageAll = count % size == 0 ? count / size : count / size + 1; return(Json(new { index = index, count = count, PageAll = PageAll, data = data })); } else { CTNEntities1 db = new CTNEntities1(); { count = db.Job.Count(); data = db.Job.OrderBy(o => o.JID).Skip((index - 1) * size).Take(size) .Select(j => new { j.JID, Caid = j.Caid, Coid = j.Coid, j.ftime, j.Jdepict, j.JName, j.JNrank, j.Jquality, j.Jrank, j.Jsalary, j.Jzdsaldw, j.Jzdsaldy, j.Jzgsaldy, j.Place, j.Ptime }).ToList(); } int PageAll = count % size == 0 ? count / size : count / size + 1; return(Json(new { index = index, count = count, PageAll = PageAll, data = data })); } #endregion }