コード例 #1
0
        public TanahJoin FindTanahJoin(int idTanah)
        {
            TanahJoin  tanahJoin  = new TanahJoin();
            JenisTanah jenisTanah = new JenisTanah();
            Lokasi     lokasi     = new Lokasi();

            using (MySqlConnection conn = GetConnection())
            {
                conn.Open();
                MySqlCommand cmd = new MySqlCommand("SELECT * FROM tanah INNER JOIN jenis_tanah ON jenis_tanah.id_jenistanah = tanah.id_jenistanah INNER JOIN lokasi ON lokasi.id_lokasi = tanah.id_lokasi WHERE id_tanah = '" + idTanah + "'", conn);
                using (MySqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        tanahJoin.IdTanah         = reader.GetInt32("id_tanah");
                        tanahJoin.Suhu            = reader.GetInt32("suhu");
                        tanahJoin.LuasTanah       = reader.GetInt32("luas_tanah");
                        jenisTanah.IdJenisTanah   = reader.GetInt32("id_jenistanah");
                        jenisTanah.NamaJenisTanah = reader.GetString("nama_jenistanah");
                        lokasi.IdLokasi           = reader.GetInt32("id_lokasi");
                        lokasi.Kecamatan          = reader.GetString("kecamatan");
                        lokasi.Kabupaten          = reader.GetString("kabupaten");
                        lokasi.Provinsi           = reader.GetString("provinsi");
                        lokasi.KodePos            = reader.GetInt32("kode_pos");
                        lokasi.Latitude           = reader.GetDecimal("latitude");
                        lokasi.Longitude          = reader.GetDecimal("longtitude");

                        tanahJoin.JenisTanah = jenisTanah;
                        tanahJoin.Lokasi     = lokasi;
                    }
                }
            }
            return(tanahJoin);
        }
コード例 #2
0
        public JenisTanah FindJenisTanah(int idJenisTanah)
        {
            JenisTanah jenisTanah = new JenisTanah();

            using (MySqlConnection conn = GetConnection())
            {
                conn.Open();
                MySqlCommand cmd = new MySqlCommand("SELECT * FROM jenis_tanah WHERE id_jenistanah = ('" + idJenisTanah + "')", conn);
                using (MySqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        jenisTanah.IdJenisTanah   = reader.GetInt32("id_jenistanah");
                        jenisTanah.NamaJenisTanah = reader.GetString("nama_jenistanah");
                    }
                }
            }

            return(jenisTanah);
        }