using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace FPER
{
    public class DacFieldConfig : DacBase
    {
        public DacFieldConfig(int ID)
            : base(ID)// cyim 2015.7.30 데이타베이스 접속 루틴 변경
        {
            //try {
            //  base.Connect();
            //}
            //catch (Exception ex) {
            //  Util.UErrorMessage(ex, 0, 0);
            //}
        }
        ~DacFieldConfig()
        {
            //try {
            //  base.DisConnect();
            //}
            //catch (Exception ex) {
            //  Util.UErrorMessage(ex, 0, 0);
            //}
        }

        /*
            public DataTable SelectMapView() {
              DataTable dt = null;
              try {
                String SQL = "";
                SQL += "SELECT SYMBOL_MAP_FILE,DEV_TYPE_FILE,FIELD_CONF_FILE";
                SQL += " FROM TB_MAPVIEW";

                DataSet dao = Select(SQL);
                dt = dao.Tables[0];
              }
              catch (Exception ex) {
                Util.UErrorMessage(ex, 0, 0);
                throw ex;
              }
              return dt;
            }
        */


        public bool SelectJumpField(int RECEIVER_ID)
        {
            bool ret = true;
            try
            {
                DataTable dt = null;
                String SQL = "";
                SQL += "SELECT JUMP_FIELD ";
                SQL += "FROM TB_CONFIG ";
                SQL += " WHERE  RECEIVER_ID = '{0}'";
                SQL = String.Format(SQL, RECEIVER_ID);
                DataSet dao = Select(SQL);
                dt = dao.Tables[0];

                if (dt.Rows.Count > 0)
                {
                    if (dt.Rows[0]["JUMP_FIELD"].ToString() == "Y")
                    {
                        ret = true;
                    }
                    else
                    {
                        ret = false;
                    }
                }
            }
            catch (Exception ex)
            {
                Util.UErrorMessage(ex, 0, 0);
                //throw ex;
            }
            return ret;
        }

        public void UpdateJumpField(int RECEIVER_ID, bool Jump_Field)
        {
            try
            {

                String SQL = "UPDATE  TB_CONFIG SET JUMP_FIELD = '{0}' ";
                SQL += ", UPDATE_USER_ID = 'FPER', UPDATE_TIME = current_timestamp";
                SQL += " WHERE RECEIVER_ID = {1}";
                SQL = String.Format(SQL, (Jump_Field ? "Y" : "N"), RECEIVER_ID);
                ExecuteNonQuery(SQL);

                //DataTable dt = Config_Select(RECEIVER_ID);

                //if (dt.Rows.Count == 0) {
                //  String SQL = "INSERT INTO TB_CONFIG (RECEIVER_ID,FIRE_ACCUMULATION_MODE,FIRE_ACCUMULATION_TIME";
                //  SQL += ",FIRE_PROCESS_MODE,SOUND_PROCESS_MODE,MASTER_USER_ID,MASTER_PASSWORD";
                //  SQL += ",BUILDING_NAME,BACKGROUND_IMAGE,UPDATE_USER_ID,UPDATE_TIME)";
                //  SQL += " VALUES ({0},'{1}',{2},'{3}','{4}','{5}','{6}','{7}','{8}','FPER',current_timestamp)";

                //  SQL = String.Format(SQL, RECEIVER_ID, FIRE_ACCUMULATION_MODE, FIRE_ACCUMULATION_TIME
                //      , FIRE_PROCESS_MODE, SOUND_PROCESS_MODE, MASTER_USER_ID, MASTER_PASSWORD, BUILDING_NAME, BACKGROUND_IMAGE);
                //  ExecuteNonQuery(SQL);
                //  //ExecuteNonQueryParam(SQL, BACKGROUND_IMAGE);

                //}
                //else {
                //  String SQL = "UPDATE  TB_CONFIG SET FIRE_ACCUMULATION_MODE = '{0}',FIRE_ACCUMULATION_TIME={1},FIRE_PROCESS_MODE='{2}' ";
                //  SQL += ", SOUND_PROCESS_MODE = '{3}', MASTER_USER_ID = '{4}',MASTER_PASSWORD = '{5}'";
                //  SQL += ", BUILDING_NAME = '{6}', BACKGROUND_IMAGE = '{7}'";
                //  SQL += ", UPDATE_USER_ID = 'FPER', UPDATE_TIME = current_timestamp";
                //  SQL += " WHERE RECEIVER_ID = {8}";
                //  SQL = String.Format(SQL, FIRE_ACCUMULATION_MODE, FIRE_ACCUMULATION_TIME, FIRE_PROCESS_MODE
                //      , SOUND_PROCESS_MODE, MASTER_USER_ID, MASTER_PASSWORD, BUILDING_NAME, BACKGROUND_IMAGE, RECEIVER_ID);
                //  ExecuteNonQuery(SQL);
                //  // ExecuteNonQueryParam(SQL, BACKGROUND_IMAGE);

                //}

            }
            catch (Exception ex)
            {
                Util.UErrorMessage(ex, 0, 0);
                //throw ex;
            }

        }


    }
}