/// <summary>
/// 获取用户登录日记列表
/// </summary>
/// <param name="parentId">父Id</param>
/// <returns>用户登录日记列表</returns>
public ResultModel GetYH_UserLogin(SearchYH_UserLoginLogModel model)
{
var tb = _database.Db.YH_UserLoginLog;
model.BeginLoginTime = model.BeginLoginTime == null?DateTime.Now.AddDays(-30) : model.BeginLoginTime;
//查询开始登陆时间
var where = tb.LoginTime >= model.BeginLoginTime;
if (model.ID > 0)
{
//查询开始登陆时间
where = new SimpleExpression(where, tb.ID == model.ID, SimpleExpressionType.And);
}
if (model.UserID != null)
{
//查询开始登陆时间
where = new SimpleExpression(where, tb.UserID == model.UserID, SimpleExpressionType.And);
}
if (model.EndLoginTime != null)
{
//结束 时间加一天是为了查询结束当天的数据
where = new SimpleExpression(where, tb.LoginTime < model.EndLoginTime, SimpleExpressionType.And);
}
dynamic pc;
var query = tb
.Query()
.LeftJoin(_database.Db.YH_User, out pc)
.On(_database.Db.YH_User.UserID == tb.UserID)
.Select(
tb.UserID,
tb.LoginAddress,
tb.LoginTime,
tb.IP,
tb.LoginSource,
pc.Account
)
.Where(where)
.OrderByLoginTimeDescending();
var result = new ResultModel
{
Data =
new SimpleDataPagedList <YH_UserLoginLogModel>(query,
model.PagedIndex, model.PagedSize)
};
return(result);
}
public JsonResult List(SearchYH_UserLoginLogModel logmodel)
{
logmodel.PagedIndex = logmodel.PagedIndex == 0? 0:logmodel.PagedIndex;
logmodel.PagedSize = logmodel.PagedSize == 0 ? 10 : logmodel.PagedSize;
//加一天是为查询最后一天的数据
logmodel.EndLoginTime = logmodel.EndLoginTime == null?DateTime.Now.AddDays(1) : logmodel.EndLoginTime.Value.AddDays(1);
//查询用户登录日志表
var result = this._YH_userLoginLogService.GetYH_UserLogin(logmodel);
List <YH_UserLoginLogModel> ds = result.Data;
var data = new
{
rows = ds,
total = result.Data.TotalCount,
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
