public Paging <LoginLog> QueryPage(LoginLogCondition condition, int pagesize, int pageindex, out int total)
{
StringBuilder sql = new StringBuilder();
sql.Append("SELECT ID,UserAccount,LoginIP,LoginTime,LogoutTime,LOGFROM,Remark FROM LoginLog ");
sql.Append(" WHERE LoginTime>=@STARTCREATETIME AND LoginTime<=@ENDCREATETIME");
using (DbOperator dbOperator = ConnectionManager.CreateReadConnection())
{
dbOperator.AddParameter("STARTCREATETIME", condition.StartTime.ToString("yyyy-MM-dd HH:mm:ss"));
dbOperator.AddParameter("ENDCREATETIME", condition.EndTime.ToString("yyyy-MM-dd HH:mm:ss"));
if (!string.IsNullOrEmpty(condition.UserAccount))
{
sql.Append(" AND UserAccount=@UserAccount");
dbOperator.AddParameter("UserAccount", condition.UserAccount);
}
if (condition.LogFrom.HasValue)
{
sql.Append(" AND LOGFROM=@LOGFROM");
dbOperator.AddParameter("LOGFROM", (int)condition.LogFrom);
}
List <LoginLog> models = new List <LoginLog>();
using (DbDataReader reader = dbOperator.Paging(sql.ToString(), "LoginTime DESC", pageindex, pagesize, out total))
{
while (reader.Read())
{
models.Add(DataReaderToModel <LoginLog> .ToModel(reader));
}
}
return(new Paging <LoginLog>(models, pageindex, pagesize, total));
}
}
public static Paging <LoginLog> QueryPage(LoginLogCondition condition, int pagesize, int pageindex, out int total)
{
ILoginLog factory = LoginLogFactory.GetFactory();
return(factory.QueryPage(condition, pagesize, pageindex, out total));
}
