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; } } } }