public ActionResult GetTaskData(bool _search, string sidx, string sord, int page, int rows) { this.Internationalization(); try { int curUserId = 0; TugDataEntities db = new TugDataEntities(); curUserId = Session.GetDataFromSession<int>("userid"); if (_search == true) { string s = Request.QueryString["filters"]; return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE }, JsonRequestBehavior.AllowGet); } else { var objs = db.proc_needapprove(curUserId).OrderByDescending(u=>u.LastUpDate).ToList(); //List<NeedApprove> objs = new List<NeedApprove>(); //SqlParameter[] prams = new SqlParameter[1]; //prams[0] = new SqlParameter("@userID", curUserId); //objs = db.Database.SqlQuery<NeedApprove>("exec dbo.proc_needapprove @userID", prams).ToList(); int totalRecordNum = objs.Count; if (page != 0 && totalRecordNum % rows == 0) page -= 1; int pageSize = rows; int totalPageNum = (int)Math.Ceiling((double)totalRecordNum / pageSize); //var page_objs = objs.Skip((page - 1) * rows).Take(rows).ToList(); var jsonData = new { page = page, records = totalRecordNum, total = totalPageNum, rows = objs }; return Json(jsonData, JsonRequestBehavior.AllowGet); } } catch (Exception) { return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }); } }