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.FZ_b1 = res.getInt("FZ_b1");							//FZ°´Å¥1
				control.FZ_b2 = res.getInt("FZ_b2");							//FZ°´Å¥2
				control.FZ_b3 = res.getInt("FZ_b3");							//FZ°´Å¥3
				control.FZ_b4 = res.getInt("FZ_b4");							//FZ°´Å¥4
				control.FZ_b5 = res.getInt("FZ_b5");							//FZ°´Å¥5
				control.FZ_b6 = res.getInt("FZ_b6");							//FZ°´Å¥6
				control.FZ_b7 = res.getInt("FZ_b7");							//FZ°´Å¥7
				control.FZ_b8 = res.getInt("FZ_b8");							//FZ°´Å¥8
				control.FZ_b9 = res.getInt("FZ_b9");							//FZ°´Å¥9
				control.FZ_b10 = res.getInt("FZ_b10"); 							//FZ°´Å¥10
				control.FZ_b11 = res.getInt("FZ_b11");							//FZ°´Å¥11
				control.start_auto = res.getInt("start_auto");					//Æô¶¯×Ô¶¯¼ÓÔØ
				control.stop_auto = res.getInt("stop_auto");					//Í£Ö¹×Ô¶¯¼ÓÔØ
				control.sudden_crease = res.getInt("sudden_crease");			//Í»¼Óͻж
				control.all_open = res.getInt("all_open");						//È«²¿·ÖÕ¢
				control.FZ_autostate1 = res.getInt("FZ_autostate1");			//FZ×Ô¶¯×´Ì¬1
				control.FZ_autostate2 = res.getInt("FZ_autostate2");			//FZ×Ô¶¯×´Ì¬2
				control.FZ_autostate3 = res.getInt("FZ_autostate3");			//FZ×Ô¶¯×´Ì¬3
				control.FZ_autostate4 = res.getInt("FZ_autostate4");			//FZ×Ô¶¯×´Ì¬4
				control.FZ_autostate5 = res.getInt("FZ_autostate5");			//FZ×Ô¶¯×´Ì¬5
				control.local_control = res.getInt("local_control");			//¾ÍµØ¿ØÖÆ
				control.back_control = res.getInt("back_control");				//ºǫ́¿ØÖÆ
				control.central_control = res.getInt("central_control");		//Öмä¿ØÖÆ
				control.inter_volume_M200 = res.getInt("inter_volume_M200");	//ÖмäÁ¿M200
				control.fan_button = res.getInt("fan_button");					//·ç»ú°´Å¥
				//control.fan_output = res.getInt("fan_output");					//·ç»úÊä³ö
				control.set_power = res.getFloat("set_power");					//É趨¹¦ÂÊ
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if(res != null) {
				try {
					res.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			sql.close_con();
		}
	}
}