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