public async Task <IActionResult> List(string searchContent, string seniorQueryJson, int page = 1, int limit = 10, string sidx = "CreateDt", string sord = "desc") { try { SiteInfo query = null; if (!string.IsNullOrEmpty(seniorQueryJson)) { query = Newtonsoft.Json.JsonConvert.DeserializeObject <SiteInfo>(seniorQueryJson); } System.Linq.Expressions.Expression <Func <SiteInfo, bool> > predicate = ExpressionBuilder.True <SiteInfo>(); predicate = predicate.And(b => b.Id > 0); if (searchContent != null) { predicate = predicate.And(b => b.SiteName.IndexOf(searchContent) != -1 || b.SiteName.IndexOf(searchContent) != -1); } PageInfo pageinfo = new PageInfo { }; (List <SiteInfo> list, long count)datas = await SiteInfoDAL.QueryAsync(predicate, null, pageinfo); var lists = datas.list; return(lists.GetJson <SiteInfo>(sidx, sord, page, limit, SysTool.GetPropertyNameArray <SiteInfo>())); } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> Index() { var sitelist = await SiteInfoDAL.QueryAsync(s => s.Status == 1, new List <SortInfo <SiteInfo, object> > { new SortInfo <SiteInfo, object> { Orderby = o => o.CreateDt, SortMethods = SortEnum.Desc } }); var model = sitelist.list.FirstOrDefault(); return(View(model)); }