public JsonResult AjaxHandler(jQueryDataTableParamModel param) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting QueryModel query = base.getQuery(param); string json = this.superService.FindPageList_JqueryTable<PsdBox>(param.iDisplayStart, param.iDisplayLength, query);//SuperManager.Instance.FindPageList_JqueryTable<PsdBox>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<PsdBox> data = JsonConvert.DeserializeObject<List<PsdBox>>(jobject["result"].ToString()); int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, WhereToUse = p.WhereToUse, Psd = RobinCore.Instance.EncodePassword(p.Psd), LoginKey = string.IsNullOrWhiteSpace(p.LoginKey) ? string.Empty : RobinCore.Instance.EncodePassword(p.LoginKey) }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AjaxHandler(jQueryDataTableParamModel param) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting //针对个人用户,需要加上用户过滤 QueryModel query = base.getAndQuery(param, "ScheduleContent", "like", param.sSearch, "ScheduleStartDate", "desc", new QueryInfo("RecordUser", "=", base.CurrentLoginUser().UserName)); string json = this.superService.FindPageList_JqueryTable<Schedule>(param.iDisplayStart, param.iDisplayLength, query);//SuperManager.Instance.FindPageList_JqueryTable<Schedule>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<Schedule> data = JsonConvert.DeserializeObject<List<Schedule>>(jobject["result"].ToString()); int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, ScheduleContent = p.ScheduleContent, //Status = (p.ScheduleStartDate.Date.ToLocalTime() - DateTime.Now.Date).TotalDays,//p.ScheduleDate.ToLocalTime() > DateTime.Now ? 0 : 1, ScheduleStartDate = p.ScheduleStartDate.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"), ScheduleEndDate = p.ScheduleEndDate.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss") }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AjaxHandler(jQueryDataTableParamModel param) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting QueryModel query = base.getQuery(param, "NoticeTitle", "like", param.sSearch, "NoticeDate", "desc"); //if (base.CurrentLoginUser().RoleLevel > 1)//管理员等级(1)的可以看所有 // query.AddQuery("NoticeUser", "=", base.CurrentLoginUser().UserName); string json = this.superService.FindPageList_JqueryTable<NoticeAnnouncement>(param.iDisplayStart, param.iDisplayLength, query);//NoticeAnnouncementManager.Instance.FindPageList_JqueryTable<NoticeAnnouncement>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<NoticeAnnouncement> data = JsonConvert.DeserializeObject<List<NoticeAnnouncement>>(jobject["result"].ToString()); int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, NoticeDate = p.NoticeDate.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"), RecordDate = p.RecordDate.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"), NoticeUserDisplayName = p.NoticeUserDisplayName, NoticeTitle = p.NoticeTitle, Status = p.Status //other field }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AjaxHandler(jQueryDataTableParamModel param) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting QueryModel query = base.getQuery(param, "DetailPlanNote", "like", param.sSearch, "DetailPlanStartDate", "desc"); query.AddQuery("RecordUser", "=", base.CurrentLoginUser().UserName); string json = this.superService.FindPageList_JqueryTable<DetailPlan>(param.iDisplayStart, param.iDisplayLength, query);////SuperManager.Instance.FindPageList_JqueryTable<DetailPlan>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<DetailPlan> data = JsonConvert.DeserializeObject<List<DetailPlan>>(jobject["result"].ToString()); //----------------------------------------------date类型的过滤比较特殊------------------------------------------ //if (param.sSearch != null) // data.RemoveAll(item => !item.DetailPlanDate.ToLocalTime().ToString("yyyy-MM-dd").Contains(param.sSearch)); //----------------------------------------------------------------------------------------------------------------------------- int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, DetailPlanStartDate = p.DetailPlanStartDate.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"), DetailPlanEndDate = p.DetailPlanEndDate.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"), DetailPlanTimeperiod = p.DetailPlanTimeperiod, DetailPlanNote = p.DetailPlanNote }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AjaxHandler(jQueryDataTableParamModel param) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting //只配给管理员,这里不用加上过滤用户 QueryModel query = base.getQuery(param, "DisplayName", "like", param.sSearch, "DisplayName", "asc"); string json = this.superService.FindPageList_JqueryTable<User>(param.iDisplayStart, param.iDisplayLength, query);// SuperManager.Instance.FindPageList_JqueryTable<User>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<User> data = JsonConvert.DeserializeObject<List<User>>(jobject["result"].ToString()); int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, UserName = p.UserName, CreateDate = p.CreateDate.ToLocalTime().ToString(), LastLoginDate = p.LastLoginDate.ToLocalTime().ToString(), DisplayName = p.DisplayName, Email = p.Email, Sex = p.Sex, PicPath = p.PicPath, Address = p.Address, CultrueType = p.CultrueType, Status = p.IsEnabled, UserRightLevel = p.Level == 1 ? "超级用户" : "普通用户" }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AjaxHandler(jQueryDataTableParamModel param, string parentId) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting //只配给管理员,这里不用加上过滤用户 QueryModel query = base.getAndQuery(param, "Title", "like", param.sSearch, "SortIndex", "asc", new QueryInfo("ParentId", "=", parentId)); string json = this.superService.FindPageList_JqueryTable<Menu>(param.iDisplayStart, param.iDisplayLength, query);//SuperManager.Instance.FindPageList_JqueryTable<Menu>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<Menu> data = JsonConvert.DeserializeObject<List<Menu>>(jobject["result"].ToString()); int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, ParentId = p.ParentId, Title = p.Title, ActionName = p.ActionName, AreaName = p.AreaName, ControllerName = p.ControllerName, MenuType = p.MenuType, SortIndex = p.SortIndex, Status = p.IsEnabled }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AjaxHandler(jQueryDataTableParamModel param) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting //只配给管理员,这里不用加上过滤用户 QueryModel query = base.getQuery(param, "CultureKey", "like", param.sSearch, "CultureKey", "asc"); string json = this.superService.FindPageList_JqueryTable<GloablCulture>(param.iDisplayStart, param.iDisplayLength, query); //GloablCultureManager.Instance.FindPageList_JqueryTable<GloablCulture>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<GloablCulture> data = JsonConvert.DeserializeObject<List<GloablCulture>>(jobject["result"].ToString()); int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, CultureKey = p.CultureKey, CultureEn = p.CultureEN, CultureCn = p.CultureCN //other field }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AjaxHandler(jQueryDataTableParamModel param) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting //针对个人用户,需要加上用户过滤 QueryModel query = base.getAndQuery(param, "SexualLifeDate", "like", param.sSearch, "SexualLifeDate", "desc", new QueryInfo("RecordUser", "=", base.CurrentLoginUser().UserName)); string json = this.superService.FindPageList_JqueryTable<SexualLife>(param.iDisplayStart, param.iDisplayLength, query);// SuperManager.Instance.FindPageList_JqueryTable<SexualLife>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<SexualLife> data = JsonConvert.DeserializeObject<List<SexualLife>>(jobject["result"].ToString()); int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, SexualLifeDate = p.SexualLifeDate.ToLocalTime().ToString("yyyy-MM-dd ") + " " + System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(p.SexualLifeDate.ToLocalTime().DayOfWeek), SexualLifeCount = p.SexualLifeCount.ToString(), SexualLifeContent = JsonArrayToString(p.SexualLifeContent) //other field }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AjaxHandler(jQueryDataTableParamModel param) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting QueryModel query = base.getQuery(param, "RecordUserDisplayName", "like", param.sSearch, "RecordDate", "desc"); if (base.CurrentLoginUser().RoleLevel > 1)//管理员等级的可以看所有 query.AddAndQuery("RecordUser", "=", base.CurrentLoginUser().UserName); string json = this.superService.FindPageList_JqueryTable<OperationRecord>(param.iDisplayStart, param.iDisplayLength, query);// SuperManager.Instance.FindPageList_JqueryTable<OperationRecord>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<OperationRecord> data = JsonConvert.DeserializeObject<List<OperationRecord>>(jobject["result"].ToString()); int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, RecordUser = p.RecordUser, RecordUserDisplayName = p.RecordUserDisplayName, //RobinCore.Instance.GetUserDisplayName(p.RecordUser), ControllerName = p.ControllerName, AreaName = p.AreaName, RecordDate = p.RecordDate.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"), ActionName = p.ActionName, OperateResult = p.OperateResult, MessageContent = p.MessageContent }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AjaxHandler(jQueryDataTableParamModel param) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting //针对个人用户,需要加上用户过滤 QueryModel query = base.getAndQuery(param, "RecordDate", "like", param.sSearch, "RecordDate", "desc", new QueryInfo("RecordUser", "=", base.CurrentLoginUser().UserName)); string json = this.superService.FindPageList_JqueryTable<Health>(param.iDisplayStart, param.iDisplayLength, query); //HealthManager.Instance.FindPageList_JqueryTable<Health>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<Health> data = JsonConvert.DeserializeObject<List<Health>>(jobject["result"].ToString()); //----------------------------------------------date类型的过滤比较特殊------------------------------------------ if (param.sSearch != null) data.RemoveAll(item => !item.RecordDate.ToLocalTime().ToString( ).Contains(param.sSearch)); //----------------------------------------------------------------------------------------------------------------------------- int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, RecordDate = p.RecordDate.ToLocalTime().ToString("yyyy-MM-dd "), WeightValue = p.WeightValue, WalkingCountValue = p.WalkingCountValue, HealthNote = p.HealthNote//, //RecordUser = RobinCore.Instance.GetUserDisplayName(p.RecordUser), }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AjaxHandler(jQueryDataTableParamModel param) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting //针对个人用户,需要加上用户过滤 QueryModel query = base.getAndQuery(param, "DisplayName", "like", param.sSearch, "DisplayName", "asc",new QueryInfo("RecordUser", "=", base.CurrentLoginUser().UserName)); string json = this.superService.FindPageList_JqueryTable<VideoTypeConfig>(param.iDisplayStart, param.iDisplayLength, query);//SuperManager.Instance.FindPageList_JqueryTable<VideoTypeConfig>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<VideoTypeConfig> data = JsonConvert.DeserializeObject<List<VideoTypeConfig>>(jobject["result"].ToString()); int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, DisplayName = p.DisplayName //other field }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AjaxHandler(jQueryDataTableParamModel param, string parentId) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting QueryModel query = new QueryModel("RecordUser", base.CurrentLoginUser().UserName); string json = this.superService.FindList<AlbumTypeConfig>(query);// SuperManager.Instance.FindList<AlbumTypeConfig>(query); List<AlbumTypeConfig> AlbumTypeConfigs = JsonConvert.DeserializeObject<List<AlbumTypeConfig>>(json); //针对个人用户,需要加上用户过滤 query = base.getAndQuery(param, "DisplayName", "like", param.sSearch, "RecordDate", "desc", new QueryInfo("ParentId", "=", parentId), new QueryInfo("RecordUser", "=", base.CurrentLoginUser().UserName)); json = this.superService.FindPageList_JqueryTable<AlbumFolder>(param.iDisplayStart, param.iDisplayLength, query);// SuperManager.Instance.FindPageList_JqueryTable<Album>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<AlbumFolder> data = JsonConvert.DeserializeObject<List<AlbumFolder>>(jobject["result"].ToString()); int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, ParentId = p.ParentId, DisplayName = p.DisplayName, Path = p.Path, FolderType = p.FolderType, RecordDate = p.RecordDate.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"), AlbumType = GetDisplayName(p.AlbumType, AlbumTypeConfigs) }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
/// <summary> /// /// </summary> /// <param name="param"></param> /// <returns></returns> public JsonResult AjaxHandler(jQueryDataTableParamModel param) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting QueryModel query = base.getQuery(param, "WeightDate", "desc"); string jsonString = this.superService.FindPageList_JqueryTable<Weight>(param.iDisplayStart, param.iDisplayLength, query);// SuperManager.Instance.FindPageList_JqueryTable<Weight>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(jsonString); List<Weight> data = JsonConvert.DeserializeObject<List<Weight>>(jobject["result"].ToString()); //----------------------------------------------date类型的过滤比较特殊------------------------------------------ if (param.sSearch != null) data.RemoveAll(item => !item.WeightDate.ToLocalTime().ToString("yyyy-MM-dd").Contains(param.sSearch)); //----------------------------------------------------------------------------------------------------------------------------- int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, WeightDate = p.WeightDate.ToLocalTime().ToString("yyyy-MM-dd"), WeightValue = p.WeightValue, RecordUser = p.RecordUser }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AjaxHandler(jQueryDataTableParamModel param) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting QueryModel queryModel = new QueryModel(); if (!string.IsNullOrWhiteSpace(param.sSearch)) queryModel = base.getQuery(param, "SendDate", "desc", new List<QueryInfo>() { new QueryInfo("SendUserDisplayName", "like", param.sSearch), new QueryInfo("RecUserDisplayName", "like", param.sSearch) }); // QueryModel query = base.getQuery(param, "SendUser", "like", param.sSearch, "SendDate", "desc"); if (base.CurrentLoginUser().RoleLevel > 1)//管理员等级的可以看所有 queryModel.AddAndQuery("RecUser", "=", base.CurrentLoginUser().UserName); string json = this.superService.FindPageList_JqueryTable<ChatMessage>(param.iDisplayStart, param.iDisplayLength, queryModel);// SuperManager.Instance.FindPageList_JqueryTable<UserMessage>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<ChatMessage> data = JsonConvert.DeserializeObject<List<ChatMessage>>(jobject["result"].ToString()); int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, SendUser = p.SendUser, RecUser = p.RecUser, SendUserDisplayName = p.SendUserDisplayName, RecUserDisplayName = p.RecUserDisplayName, SendDate = p.SendDate.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"), MessageContent = p.MessageContent, ReceiveStatus = p.ReceiveStatus == 0 ? "<font color=red>未接收</font>" : "<font color=green>已接收</font>", ChatMsgType = Enum.GetName(typeof(ChatMessageype), p.ChatMsgType) }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AjaxHandler(jQueryDataTableParamModel param) { //http://www.codeproject.com/Articles/155422/jQuery-DataTables-and-ASP-NET-MVC-Integration-Part#Sorting QueryModel queryModel = new QueryModel(); if (!string.IsNullOrWhiteSpace(param.sSearch)) queryModel = base.getQuery(param, "DebtDate", "desc", new List<QueryInfo>() { new QueryInfo("DebtFromUser", "like", param.sSearch), new QueryInfo("DebtToUser", "like", param.sSearch) }); //针对个人用户,需要加上用户过滤 queryModel.AddAndQuery("RecordUser", "=", base.CurrentLoginUser().UserName); string json = this.superService.FindPageList_JqueryTable<Debt>(param.iDisplayStart, param.iDisplayLength, queryModel);//DebtManager.Instance.FindPageList_JqueryTable<Debt>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<Debt> data = JsonConvert.DeserializeObject<List<Debt>>(jobject["result"].ToString()); int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, DebtDate = p.DebtDate.ToLocalTime().ToString("yyyy-MM-dd"), DebtFromUser = p.DebtFromUser, DebtToUser = p.DebtToUser, DebtType = p.DebtType, DebtContent = p.DebtContent, DebtProgress = p.DebtProgress, DebtNum = p.DebtNum//, //RecordUser = RobinCore.Instance.GetUserDisplayName(p.RecordUser) //other field }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }
public JsonResult AlbumListTableAjaxHandler(jQueryDataTableParamModel param, string parentId) { QueryModel query = base.getAndQuery(param, "FileName", "like", param.sSearch, "FileSize", "desc", new QueryInfo("FolderId", "=", parentId)); string json = this.superService.FindPageList_JqueryTable<Album>(param.iDisplayStart, param.iDisplayLength, query); //SuperManager.Instance.FindPageList_JqueryTable<Video>(param.iDisplayStart, param.iDisplayLength, query); JObject jobject = JObject.Parse(json); List<Album> data = JsonConvert.DeserializeObject<List<Album>>(jobject["result"].ToString()); int i = param.iDisplayStart; var linq = from p in data select new { RowId = ++i, Id = p.Id, FileName = p.FileName, FilePath = p.FilePath, FileExtention = p.FileExtention.ToLower(), CreationTime = p.CreationTime.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"), LastAccessTime = p.LastAccessTime.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"), Evaluation = p.Evaluation + "星", FileSize = FileExtention.Instance.GetFileSizeDescription(p.FileSize) }; return Json(new { sEcho = param.sEcho, iTotalRecords = (Int32)jobject["iTotalRecords"], iTotalDisplayRecords = (Int32)jobject["iTotalDisplayedRecords"], aaData = linq }, JsonRequestBehavior.AllowGet); }