package com.data;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.dev.base.data.Dynamicload_button;
import com.dev.base.data.Dynamicload_control;
import com.sql.MysqlConnPool;
import com.sql.Sql_Mysql;

public class PowerArk_SocketClient_Thread_SQL {

	/**
	 * 	¶ÁÈ¡µ±Ç°É豸¿ØÖƲÙ×÷
	 * @param conn_pool
	 * @param dev_id
	 * @return
	 */
	public static void queryPowerArkControl(MysqlConnPool conn_pool,Dynamicload_control control) {
		String sql_str = " SELECT * FROM " + Sql_Mysql.Tb_Dynamicload_Control + " WHERE dev_id = " + control.dev_id;
		Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
		ResultSet res = null;
		try {
			res = sql.sqlMysqlQuery(sql_str);
			if(res.next()) {
				control.setFZ_b1(res.getInt("fZ_b1"));						//FZ°´Å¥1
				control.setFZ_b2(res.getInt("fZ_b2"));       					//FZ°´Å¥2	   
				control.setFZ_b3(res.getInt("FZ_b3"));							//FZ°´Å¥3
				control.setFZ_b4(res.getInt("FZ_b4"));							//FZ°´Å¥4
				control.setFZ_b5(res.getInt("FZ_b5"));							//FZ°´Å¥5
				control.setFZ_b6(res.getInt("FZ_b6"));							//FZ°´Å¥6
				control.setFZ_b7(res.getInt("FZ_b7"));							//FZ°´Å¥7
				control.setFZ_b8(res.getInt("FZ_b8"));							//FZ°´Å¥8
				control.setFZ_b9(res.getInt("FZ_b9"));							//FZ°´Å¥9
				control.setFZ_b10(res.getInt("FZ_b10"));						//FZ°´Å¥10
				control.setFZ_b11(res.getInt("FZ_b11"));						//FZ°´Å¥11
				control.setStart_auto(res.getInt("start_auto")); 				//Æô¶¯×Ô¶¯¼ÓÔØ
				control.setStop_auto(res.getInt("stop_auto")); 	 				//Í£Ö¹×Ô¶¯¼ÓÔØ
				control.setSudden_crease(res.getInt("sudden_crease"));  		//Í»¼Óͻж
				control.setAll_open(res.getInt("all_open"));            		//È«²¿·ÖÕ¢
				control.setFZ_autostate1(res.getInt("fZ_autostate1"));  		//FZ×Ô¶¯×´Ì¬1
				control.setFZ_autostate2(res.getInt("fZ_autostate2"));  		//FZ×Ô¶¯×´Ì¬2
				control.setFZ_autostate3(res.getInt("fZ_autostate3"));  		//FZ×Ô¶¯×´Ì¬3
				control.setFZ_autostate4(res.getInt("fZ_autostate4"));			//FZ×Ô¶¯×´Ì¬4
				control.setFZ_autostate5(res.getInt("fZ_autostate5"));  		//FZ×Ô¶¯×´Ì¬5
				control.setLocal_control(res.getInt("local_control")); 			//¾ÍµØ¿ØÖÆ
				control.setBack_control(res.getInt("back_control"));    		//ºǫ́¿ØÖÆ
				control.setCentral_control(res.getInt("central_control"));  	//Öмä¿ØÖÆ
				control.setInter_volume_M200(res.getInt("inter_volume_M200"));	//ÖмäÁ¿M200
				control.setFan_button(res.getInt("fan_button"));                //·ç»ú°´Å¥
				control.setSet_power(res.getFloat("set_power")); 				//É趨¹¦ÂÊ
				control.setInterval_time(res.getInt("interval_time"));          //¼ä¸ôʱ¼ä
				//control.fan_output = res.getInt("fan_output");				//·ç»úÊä³ö
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if(res != null) {
				try {
					res.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			sql.close_con();
		}
	}
}