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