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 })));
}
