package urt;
import BaoWen.Stac;
import DataBase.DatabaseManagement;
import Method.GetNowTime;
import tbDataModel.Tb_gps;
/**¸Ã·½·¨ÓÃÓÚ½«GNGGA×ø±ê²åÈëÀúÊ·¹ì¼£Êý¾Ý¿â*/
public class HistoryGNGGA {

	static StringBuffer suffix = new StringBuffer(); // ±£´æsqlºó׺
	static int jishu=0;
	/**gps_utc_time  
	 * gps_weidu
	 * gsp_jingdu 
	 * gps_num  
	 * gps_haiba_gao
	 * tagid    
	 * gps_power  
	 * gps_sos  
	 * addtime**/

	public static void putInHistory(
			Tb_gps gps,
			String gps_utc_time,  
			String gps_weidu,
			String gsp_jingdu, 
			String gps_num,  
			String gps_haiba_gao,
			String tagid,    
			String gps_power,  
			String gps_sos,
			String gps_state,
			String gps_hdop,
			String gps_chafen_time,
			String addtime
			) {
		if(Stac.isSaveguiji()) {
			String tb_track="tb_gps_track_"+GetNowTime.getyearmd();
			String prefix = "INSERT INTO "+tb_track+" (gps_utc_time,"
					+ "gps_weidu,"
					+ "gsp_jingdu,"
					+ "gps_num,"
					+ "gps_haiba_gao,"
					+ "tagid,"
					+ "gps_power,"
					+ "gps_sos,"
					+ "gps_state,"
					+ "gps_hdop,"
					+ "gps_chafen_time,"
					+ "addtime)  VALUES ";

			//½«±êGNGGAʱλÖòåÈëÀúÊ·¹ì¼£Êý¾Ý¿âÖÐ
			jishu++;					 
			suffix.append("('"+gps_utc_time+"','"
					+gps_weidu+"','"
					+gsp_jingdu+"','"
					+gps_num+"','"
					+gps_haiba_gao+"','"
					+tagid+"','"
					+gps_power+"','"
					+gps_sos+"','"
					+gps_state+"','"
					+gps_hdop+"','"
					+gps_chafen_time+"','"
					+addtime+"'),");
			if(jishu==100) {
				StringBuffer sql =new StringBuffer(prefix + suffix.substring(0, suffix.length() - 1)) ; // ¹¹½¨ÍêÕûsql
				DatabaseManagement.insert_fast(sql.toString(),6);
				suffix.setLength(0); 
				jishu=0;
			}

			tb_track=null;
			prefix =null;
		}
	}

}