public Flexigride GetJson(JObject json) { SearchMod <SYS_Dics> searchModel = new SearchMod <SYS_Dics>(); searchModel.page = Convert.ToInt32(json["page"].ToString()); //当前页 searchModel.rp = Convert.ToInt32(json["rp"].ToString()); //页面大小 searchModel.sortorder = json["sortorder"].ToString(); //排序字段 searchModel.sortname = json["sortname"].ToString(); //排序方式 var model = JsonToObject <SYS_Dics>(json); IQueryable <SYS_Dics> query = DPBase.db.SYS_Dics; //query = string.IsNullOrEmpty(searchModel.sortorder) ? query.OrderByDescending(c => searchModel.sortorder) : query.OrderBy(c => searchModel.sortorder); query = query.OrderBy(c => c.Sortnum); if (model.CategoryId != 0) { query = query.Where(c => c.CategoryId == model.CategoryId); } searchModel.query = query; Flexigride grid = new Flexigride(); grid.rows = DPBase.DPGetQueryLst(searchModel, out searchModel); grid.page = searchModel.page; grid.total = searchModel.total; return(grid); }
public Flexigride GetJson(JObject json) { SearchMod <SYS_Button> searchModel = new SearchMod <SYS_Button>(); searchModel.page = Convert.ToInt32(json["page"].ToString()); //当前页 searchModel.rp = Convert.ToInt32(json["rp"].ToString()); //页面大小 searchModel.sortorder = json["sortorder"].ToString(); //排序字段 searchModel.sortname = json["sortname"].ToString(); //排序方式 SYS_Button model = JsonToObject <SYS_Button>(json); IQueryable <SYS_Button> query = DPBase.db.SYS_Button; query = string.IsNullOrEmpty(searchModel.sortorder) ? query.OrderByDescending(c => searchModel.sortorder) : query.OrderBy(c => searchModel.sortorder); if (!string.IsNullOrEmpty(model.BTN_Name)) { query = query.Where(c => c.BTN_Name.Contains(model.BTN_Name)); } if (!string.IsNullOrEmpty(model.BTN_Name_En)) { query = query.Where(c => c.BTN_Name_En.Contains(model.BTN_Name_En)); } searchModel.query = query; Flexigride grid = new Flexigride(); grid.rows = DPBase.DPGetQueryLst(searchModel, out searchModel); grid.page = searchModel.page; grid.total = searchModel.total; return(grid); }
public Flexigride GetButtonGroup(JObject json) { SearchMod <SYS_ButtonGroup> searchModel = new SearchMod <SYS_ButtonGroup>(); searchModel.page = Convert.ToInt32(json["page"].ToString()); searchModel.rp = Convert.ToInt32(json["rp"].ToString()); SYS_ButtonGroup bGroup = (SYS_ButtonGroup)(JsonConvert.DeserializeObject(json.ToString(), typeof(SYS_ButtonGroup))); IQueryable <SYS_ButtonGroup> query = DPBase.db.SYS_ButtonGroup; query = string.IsNullOrEmpty(searchModel.sortorder) ? query.OrderByDescending(c => searchModel.sortname) : query.OrderBy(c => searchModel.sortname); if (!string.IsNullOrEmpty(bGroup.BG_Name)) { query = query.Where(c => c.BG_Name.Contains(bGroup.BG_Name)); } if (!string.IsNullOrEmpty(bGroup.BG_Name_En)) { query = query.Where(c => c.BG_Name_En.Contains(bGroup.BG_Name_En)); } //aa.query = query.Select(c => new { BG_Name = c.BG_Name, BG_Name_En = c.BG_Name_En, BG_OrderIndex = c.BG_OrderIndex, BG_Desc = c.BG_Desc,BG_Id = c.BG_Id }); searchModel.query = query.OrderBy(c => c.BG_CreatedOn); Flexigride grid = new Flexigride(); grid.rows = DPBase.DPGetQueryLst(searchModel, out searchModel); grid.page = searchModel.page; grid.total = searchModel.total; return(grid); }