Sakuno.KanColle.Amatsukaze.Game.Services.Records.ResourcesRecords.Load C# (CSharp) Method

        protected override void Load()
        {
            using (var rCommand = Connection.CreateCommand())
            {
                rCommand.CommandText = "SELECT * FROM resources ORDER BY time DESC LIMIT 1;";

                using (var rReader = rCommand.ExecuteReader())
                    if (rReader.Read())
                    {
                        r_Fuel = Convert.ToInt32(rReader["fuel"]);
                        r_Bullet = Convert.ToInt32(rReader["bullet"]);
                        r_Steel = Convert.ToInt32(rReader["steel"]);
                        r_Bauxite = Convert.ToInt32(rReader["bauxite"]);
                        r_InstantConstruction = Convert.ToInt32(rReader["instant_construction"]);
                        r_Bucket = Convert.ToInt32(rReader["bucket"]);
                        r_DevelopmentMaterial = Convert.ToInt32(rReader["development_material"]);
                        r_ImprovementMaterial = Convert.ToInt32(rReader["improvement_material"]);
                    }
            }
        }