public JsonResult GetLoginLog( int rows , int page , DateTime? beginTime , DateTime? endTime ) { try { int total; List<LoginLog> lstLog = logBll.GetList( OnlineUser.OnLineUserID , page , rows , beginTime , endTime , out total ); var query = from log in lstLog join adm in admBll.GetList() on log.OperateId equals adm.ID into admOnEmpty from adm in admOnEmpty.DefaultIfEmpty() select new { log.LogId , UserName = log.OperateId == -1 ? "未知" : adm.AdminName , log.LoginTime , log.LoginPlace , log.LoginIPAddress } ; return Json( new { total , rows = query.ToList() } ); } catch ( Exception ) { return Json( new { total = 0 , rows = "{}" } ); } }
/// <summary> /// 查询数据 /// </summary> private void QueryData() { int page = Request.Form["page"] != null?Convert.ToInt32(Request.Form["page"]) : 0; int size = Request.Form["rows"] != null?Convert.ToInt32(Request.Form["rows"]) : 0; string sort = Request.Form["sort"] ?? ""; string order = Request.Form["order"] ?? ""; if (page < 1) { return; } int pageCount = 0; int rowCount = 0; string orderField = sort.Replace("JSON_", ""); var strWhere = GetWhere(); var pageList = bll.GetList(page, size, out pageCount, out rowCount, strWhere); var strJSON = Serializer.JsonDate(new { rows = pageList, total = rowCount }); Response.Write(strJSON); Response.ContentType = "application/json"; Response.End(); }