{
string strSQL="select * from users";
connection.Open();
List<users> list = new List<users>();
users user=null;
OleDbCommand command = new OleDbCommand(strSQL, AccessHelper.connection);
OleDbDataReader dr = command.ExecuteReader();
try
{
while(dr.Read())
{
user= new users();
user.Id = Convert.ToInt16(dr["Id"].ToString());
user.Time = Convert.ToDateTime(dr["time"].ToString());
user.Remarks = dr["remarks"].ToString();
imi.UserRoleInfo = UserRoleInfoService.GetUserRoleById(Convert.ToInt16(dr["rid"].ToString()));
// UserRoleInfoService.GetUserRoleById中查询根据rid查询用户角色
//我调试进去GetUserRoleById这个方法，执行后dr关闭了
// 执行完这句话后再回来dr就不再循环了，难道这ACCESS数据库的 OleDbDataReader和SQL的reader不同？
list.Add(user);
}
}
catch(Exception e)
{}
finally
{
dr.Close();
if (connection.State == System.Data.ConnectionState.Open)
connection.Close();
}
return list;
