package com.myweather.app.model;

import java.util.ArrayList;
import java.util.List;

import com.myweather.app.db.MyWeatherDbHelper;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class MyWeatherDB {
	// Êý¾Ý¿âÃû£º
	public static final String DB_NAME = "my_weather";

	// Êý¾Ý¿â°æ±¾£º
	public static final int VERSION = 1;
	
	private static MyWeatherDB myWeatherDB;
	private SQLiteDatabase db;

	// ¹¹Ôì·½·¨Ë½ÓÐ»¯£º
	private MyWeatherDB(Context context) {
		MyWeatherDbHelper dbHelper = new MyWeatherDbHelper(context, DB_NAME, null, VERSION);
		db = dbHelper.getWritableDatabase();
	}

	// »ñÈ¡¸ÃÀàÊµÀýµÄ·½·¨£º
	public synchronized static MyWeatherDB getInstance(Context context) {
		if (myWeatherDB == null) {
			myWeatherDB = new MyWeatherDB(context);
		}
		return myWeatherDB;
	}

	// ´¢´æProvinceÊµÀýµ½Êý¾Ý¿â£º
	public void saveProvince(Province province) {
		if (province != null) {
			ContentValues values = new ContentValues();
			values.put("province_name", province.getProvinceName());
			values.put("province_code", province.getProvinceCode());
			db.insert("Province", null, values);
		}
	}

	// ´ÓÊý¾Ý¿â¶ÁÈ¡ËùÓÐÊ¡·ÝµÄÐÅÏ¢£º
	public List<Province> loadProvince() {
		List<Province> list = new ArrayList<Province>();
		Cursor cursor = db.query("Province", null, null, null, null, null, null);
		if (cursor.moveToFirst()) {
			do {
				Province province = new Province();
				province.setId(cursor.getInt(cursor.getColumnIndex("id")));
				province.setProvinceName(cursor.getString(cursor.getColumnIndex("province_name")));
				province.setProvinceCode(cursor.getString(cursor.getColumnIndex("province_code")));
				list.add(province);
			} while (cursor.moveToNext());
		}
		return list;
	}

	// ´æ´¢CityÊµÀýµ½Êý¾Ý¿â£º
	public void saveCity(City city) {
		if (city != null) {
			ContentValues values = new ContentValues();
			values.put("city_name", city.getCityName());
			values.put("city_code", city.getCityCode());
			values.put("province_id", city.getProvinceId());
			db.insert("City", null, values);
		}
	}

	// ´ÓÊý¾Ý¿â¶ÁÈ¡Ä³Ê¡ËùÓÐµÄ³ÇÊÐÐÅÏ¢£º
	public List<City> loadCities(int provinceId) {
		List<City> list = new ArrayList<City>();
		Cursor cursor = db.query("City", null, "province_id=?", new String[] { String.valueOf(provinceId) }, null, null,
				null);
		if (cursor.moveToFirst()) {
			do {
				City city = new City();
				city.setId(cursor.getInt(cursor.getColumnIndex("id")));
				city.setCityName(cursor.getString(cursor.getColumnIndex("city_name")));
				city.setCityCode(cursor.getString(cursor.getColumnIndex("city_code")));
				city.setProvinceId(provinceId);
				list.add(city);
			} while (cursor.moveToNext());
		}
		return list;
	}

	// ´æ´¢CountyÊµÀýµ½Êý¾Ý¿â£º
	public void saveCounty(County county) {
		if (county != null) {
			ContentValues values = new ContentValues();
			values.put("county_name", county.getCountyName());
			values.put("county_code", county.getCountyCode());
			values.put("city_id", county.getCityId());
			db.insert("County", null, values);
		}
	}

	// ´ÓÊý¾Ý¿â¶ÁÈ¡Ä³³ÇÊÐËùÓÐÏØµÄÐÅÏ¢£º
	public List<County> loadCounties(int cityId) {
		List<County> list = new ArrayList<County>();
		Cursor cursor = db.query("County", null, "city_id=?", new String[] { String.valueOf(cityId) }, null, null,
				null);
		if (cursor.moveToFirst()) {
			do {
				County county = new County();
				county.setId(cursor.getInt(cursor.getColumnIndex("id")));
				county.setCountyName(cursor.getString(cursor.getColumnIndex("county_name")));
				county.setCountyCode(cursor.getString(cursor.getColumnIndex("county_code")));
				county.setCityId(cityId);
				list.add(county);
			} while (cursor.moveToNext());
		}
		return list;
	}

}
