public IActionResult GetJQGridJson(Hi_Core.Domain.Pagination pagination, string queryJson = "") { #region ==查询条件== StringBuilder where = new StringBuilder(); if (!string.IsNullOrEmpty(queryJson)) { var ModelQ = Newtonsoft.Json.JsonConvert.DeserializeObject <queryJson>(queryJson); where.Append(" and Kind=" + ModelQ.Kind); if (!string.IsNullOrEmpty(ModelQ.Atitle)) { where.Append(" and Atitle like '%" + ModelQ.Atitle + "%'"); } if (!string.IsNullOrEmpty(ModelQ.Atime)) { string[] Atime = ModelQ.Atime.Split("至"); where.Append(" and DATEDIFF(DAY,Atime,'" + Atime[0].ToString().Trim() + "')<=0 and DATEDIFF(DAY,Atime,'" + Atime[1].ToString().Trim() + "')>=0"); } if (!string.IsNullOrEmpty(ModelQ.Asid)) { where.Append(" and Asid in(" + ModelQ.Asid + ")"); } if (ModelQ.Alive) { where.Append(" and Alive=0"); } if (ModelQ.Hot) { where.Append(" and Hot=1"); } if (ModelQ.Recommend) { where.Append(" and Recommend=1"); } } #endregion var data = _viewArticleService.FindPagedList(where.ToString(), pagination.sidx + " " + pagination.sord, pagination.page, pagination.rows); return(Content(JsonConvert.SerializeObject(new { page = pagination.page, total = data.total, records = data.records, rows = data }))); }
public IActionResult GetJQGridJson(Hi_Core.Domain.Pagination pagination, string queryJson = "") { #region ==查询条件== StringBuilder where = new StringBuilder(); if (!string.IsNullOrEmpty(queryJson)) { var ModelQ = Newtonsoft.Json.JsonConvert.DeserializeObject <queryJson>(queryJson); where.Append(" and Kind=" + ModelQ.Kind); if (!string.IsNullOrEmpty(ModelQ.Stitle)) { where.Append(" and Stitle like '%" + ModelQ.Stitle + "%'"); } if (ModelQ.Alive) { where.Append(" and Alive=0"); } } #endregion var data = _articleSortService.FindPagedList(where.ToString(), pagination.sidx + " " + pagination.sord, pagination.page, pagination.rows); return(Content(JsonConvert.SerializeObject(new { page = data.page, total = data.total, records = data.records, rows = data }))); }