package Method;
import DataBase.DatabaseManagement;
import tbDataModel.TbRealInWarning;
import tbDataModel_Dell.Tb_Warnig_Dell;

/**¸ÃÀàÓÃÓÚ½«Êý¾Ý²åÈëÊý¾Ý¿â*/
public class InsertData  {


	public static void insertTagStatus(String type,String id,String time) {
		String update="UPDATE tb_tag SET status='"+type+"',addtime='"+time+"' where tag_id='"+id+"'";
		DatabaseManagement.update(update);// ¸üÐÂÊý¾Ý¿â

	}

	

	/**½«±êÇ©ÀëÏß״̬²åÈëʵʱλÖÃÊý¾Ý¿âÖÐ*/
	public static void tagOffIsertData(String tagid) {
		String life="ÀëÏß";
		String update="UPDATE tb_realpositoin SET life='"+life+"' where tagid='"+tagid+"'";
		DatabaseManagement.update(update);// ¸üÐÂÊý¾Ý¿â	

	}

	/**sosÊý¾Ý»òÕß½øÈë¸æ¾¯ÇøÓòÊý¾Ý²åÈë¸æ¾¯Êý¾Ý¿â*/
	public static void sosInsertTbWarning(String taid,String type,String status,String beizhu) {		
		String time=GetNowTime.now();
		String[] ziduan = {"type", "objectid", "status", "time", "baoliu1" };
		String[] zhi = { type,taid,status,time,beizhu};
		DatabaseManagement.insertfast("tb_warning", ziduan, zhi);
		Tb_Warnig_Dell.add_tb_warning(type, taid,status,time);		
	}


	/**µÍµçÁ¿Êý¾Ý*/
	public static void porInsertTbWarning(String taid, String status, String power) {
		String time = GetNowTime.now();
		String type = "µÍµçÁ¿";
		String pwr = "µ±Ç°µçÁ¿"+power+"%";
		String[] ziduan = {"type", "status", "time", "baoliu1","objectid"};
		String[] zhi = {type, status, time, pwr, taid};
		if (Tb_Warnig_Dell.get_tbwarning(taid)!=null){
			Tb_Warnig_Dell.get_tbwarning(taid).setStatus("δ´¦Àí");
			String sqlpwr="UPDATE tb_warning SET STATUS='δ´¦Àí',baoliu1='F"+pwr+"' WHERE objectid='"+taid+"' AND `type`='µÍµçÁ¿' AND `status`='δ´¦Àí';";
			DatabaseManagement.update(sqlpwr);
		} else {
			DatabaseManagement.insertfast("tb_warning", ziduan, zhi);
			Tb_Warnig_Dell.add_tb_warning("µÍµçÁ¿", taid, "δ´¦Àí",pwr);
		}
	}

	/**SOS¸æ¾¯²åÈëÊý¾Ý¿â*/
	/**sosÊý¾Ý»òÕß½øÈë¸æ¾¯ÇøÓòÊý¾Ý²åÈë¸æ¾¯Êý¾Ý¿â*/
	public static void sosin_tbwarnig(String taid,String beizhu) {		
		String time=GetNowTime.now();
		String[] ziduan = {"type", "objectid", "status", "time", "baoliu1" };
		String[] zhi = {"SOS",taid,"δ´¦Àí",time,beizhu};
		DatabaseManagement.insertfast("tb_warning", ziduan, zhi);
	}
	
	/**Ð޸ıêÇ©±»²ð³ýÊý¾Ý²åÈëÊý¾Ý¿â*/
	public static void tagoff_into_data(String taid) {
		String[] ziduan = {"baoliu6", "p_tagid" };
		String[] zhi = {"1",taid};
		DatabaseManagement.fast_alert_dbase("tb_person", ziduan, zhi);
	}
	

	/**Ð޸ĸ澯Êý¾Ý¿â*/
	public static void alertSosTbWaring() {
		String updateSQL="UPDATE tb_warning SET  status='ÒÑ´¦Àí' ";	
		DatabaseManagement.update(updateSQL);// ´¦Àí¸æ¾¯ÐÅÏ¢ÐÅÏ¢	
	}

	/**ɾ³ýijÊý¾Ý¿âÖеÄÊý¾Ý*/
	public static void deletetData(String dataName,String id) {
		String deleteSql="DELETE FROM "+dataName+" WHERE id='"+id+"'";
		DatabaseManagement.update(deleteSql);// ɾ³ý±êÇ©ÐÅÏ¢		
	}

	/**ɾ³ýÊý¾Ý¿âÖеÄËùÓÐÄÚÈÝ*/
	public static int delteAllData(String dataName) {
		String deleteSql="TRUNCATE TABLE"+dataName+"";
		int a=DatabaseManagement.update(deleteSql);// ɾ³ýËùÓмǼ
		return a;
	}


	/**¸æ¾¯Êý¾Ý²åÈëÊý¾Ý¿â*/
	public static void into_database(String type,String area,String name,String bumen,String tagid,String intime,String outtime,String alltime) {
		String[] ziduan = {"area","name","bumen","tagid","intime","outtime","alltime"};
		String[] zhi = {area,name,bumen,tagid,intime,outtime,alltime};

		String[] ziduan2 = {"area","name","bumen","tagid","intime"};
		String[] zhi2 = {area,name,bumen,tagid,intime};

		DatabaseManagement.insertfast("tb_historyinwarning", ziduan, zhi);
		DatabaseManagement.insertfast("tb_realinwarning", ziduan2, zhi2);
		InsertData.sosInsertTbWarning(tagid,type, "δ´¦Àí",area);
	}

	/**¸üи澯Êý¾Ý¿â*/
	public static void intb_history_database(TbRealInWarning tbwn,String area,String in,String intime,String alltime) {		
		String name=tbwn.getName();
		String bumen=tbwn.getBumen();
		String tagid=tbwn.getTagid();
		String[] ziduan = {"area","name","bumen","tagid","intime","outtime","alltime"};
		String[] zhi = {area,name,bumen,tagid,in,intime,alltime};
		DatabaseManagement.insertfast("tb_historyinwarning", ziduan, zhi);	
	}

}