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