/// <summary> /// 分页的数据 /// </summary> /// <returns></returns> public JsonResult GetData(GridSettings setting) { string requestStringPar = Request["customPar"]; string page = Request["page"]; //当前页 string rows = Request["rows"]; //每页显示 int pageIndex = Convert.ToInt32(page); //当前页 int rowsint = Convert.ToInt32(rows); //过滤参数 List <CommonSearchModel> parasD = null; if (!string.IsNullOrEmpty(requestStringPar)) { parasD = JsonConvert.DeserializeObject <List <CommonSearchModel> >(requestStringPar);; } int records = SysDataHelper <sys_action> .ResultDataCount_New(parasD); int total = (int)Math.Ceiling((float)records / (float)rowsint); var dataList = SysDataHelper <sys_action> .FindDataByPageFilter(parasD, string.IsNullOrEmpty(setting.sortColumn)? "createtime" : setting.sortColumn + " " + setting.sortOrder, pageIndex, rowsint).ToList(); var jsonData = new { total = total, page = pageIndex, records = records, rows = dataList }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 分页的数据 /// </summary> /// <returns></returns> public JsonResult GetData() { string requestStringPar = Request["customPar"]; string page = Request["page"]; //当前页 string rows = Request["rows"]; //每页显示 int pageIndex = Convert.ToInt32(page); //当前页 int rowsint = Convert.ToInt32(rows); //过滤参数 List <CommonSearchModel> parasli = null; if (!string.IsNullOrEmpty(requestStringPar)) { parasli = JsonConvert.DeserializeObject <List <CommonSearchModel> >(requestStringPar); } int records = SysDataHelper <T_Sys_DEPARTMENTINFO> .ResultDataCount_New(parasli); int total = (int)Math.Ceiling((float)records / (float)rowsint); var dataList = SysDataHelper <T_Sys_DEPARTMENTINFO> .FindDataByPageFilter(parasli, "DEPTID", pageIndex, rowsint).ToList(); var jsonData = new { total = total, page = pageIndex, records = records, rows = dataList }; return(Json(jsonData)); }
/// <summary> /// 分页的数据 /// </summary> /// <returns></returns> public JsonResult GetData(GridSettings setting) { string requestStringPar = Request["customPar"]; string page = Request["page"]; //当前页 string rows = Request["rows"]; //每页显示 int pageIndex = Convert.ToInt32(page); //当前页 int rowsint = Convert.ToInt32(rows); //过滤参数 List <CommonSearchModel> parasD = null; if (!string.IsNullOrEmpty(requestStringPar)) { parasD = JsonConvert.DeserializeObject <List <CommonSearchModel> >(requestStringPar);; } int records = SysDataHelper <T_Sys_Users> .ResultDataCount_New(parasD); int total = (int)Math.Ceiling((float)records / (float)rowsint); List <T_Sys_Users> usersList = null; try { usersList = SysDataHelper <T_Sys_Users> .FindDataByPageFilter(parasD, string.IsNullOrEmpty(setting.sortColumn)? "UserId" : setting.sortColumn + " " + setting.sortOrder, pageIndex, rowsint).ToList(); } catch (Exception ex) { throw; } var jsonData = new { total = total, page = pageIndex, records = records, rows = ( from sta in usersList select new { i = sta.UserId, cell = new object[] { sta.UserId, sta.UserName, sta.RealName, sta.Email, sta.Sex == 0?"男":"女", sta.Tel, DateTime.Parse(sta.CreateDate.ToString()).ToString("yyyy-MM-dd") } } ).ToArray() }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获得subgrid的数据 /// </summary> /// <param name="setting"></param> /// <param name="id"></param> /// <returns></returns> public JsonResult GetData(GridSettings setting, int?id = 0) { string requestStringPar = Request["customPar"]; string page = Request["page"]; //当前页 string rows = Request["rows"]; //每页显示 int pageIndex = Convert.ToInt32(page); //当前页 int rowsint = Convert.ToInt32(rows); //过滤参数 List <CommonSearchModel> parasD = null; if (!string.IsNullOrEmpty(requestStringPar)) { parasD = JsonConvert.DeserializeObject <List <CommonSearchModel> >(requestStringPar);; } int records = SysDataHelper <T_Bas_Module> .ResultDataCount_New(parasD, M => M.ParentID == id && M.ApplicationID == 1); int total = (int)Math.Ceiling((float)records / (float)rowsint); var dataList = SysDataHelper <T_Bas_Module> .FindDataByPageFilter(parasD, string.IsNullOrEmpty(setting.sortColumn)? "MouduleID" : setting.sortColumn + " " + setting.sortOrder, pageIndex, rowsint, M => M.ParentID == id && M.ApplicationID == 1).ToList(); var jsonData = new { total = total, page = pageIndex, records = records, rows = ( from sta in dataList select new { i = sta.MouduleID, cell = new object[] { sta.MouduleID, sta.MouduleName, sta.IsUse == 0?"是":"否", "<img src='../Content/ModulesImages/" + sta.IcoPath + "' width='20' height='20' alt='' />", sta.MenuUrl, sta.IsFuntion == 0?"有":"无", sta.CreateDate.Value.ToString("yyyy-MM-dd") } } ).ToArray() }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }