123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252 |
- using System;
- using System.Collections.Generic;
- using System.Collections;
- using System.Text;
- using System.Data;
- using System.Windows.Forms;
- namespace FPER
- {
- public class _ExternalInitial
- {
- // 초기화 작업 중 특별처리 부분만 정리함
- public void Setup(int ReceiverID)
- {
- //
- // cyim 2016.12.06 : 강제쿼리 - 추가로 필요한 데이타베이스 정리
- //
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "EW", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "EW", "설비출력상태 ON", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "EF", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "EF", "설비출력상태 OFF", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "ED", ReceiverID) == false) // cyim 2016.12.09 : IFC3300에서는 예비전원버튼 -> 설비전체연동조작버튼
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "ED", "설비연동조작버튼", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- // cyim 2017.02.14 : 강제쿼리
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "A1", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "A1", "가압펌프1 스위치 기동", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "A2", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "A2", "가압펌프1 스위치 정지", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "A3", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "A3", "가압펌프2 스위치 기동", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "A4", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "A4", "가압펌프2 스위치 정지", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "A5", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "A5", "비상발전기 스위치 기동", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "A6", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "A6", "비상발전기 스위치 정지", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "PA", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "PA", "PUMP1 스위치 수동", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "PB", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "PB", "PUMP2 스위치 수동", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "PC", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "PC", "PUMP3 스위치 수동", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "PD", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "PD", "PUMP4 스위치 수동", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "SA", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "SA", "PUMP5 스위치 수동", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "SB", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "SB", "PUMP6 스위치 수동", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "SC", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "SC", "PUMP7 스위치 수동", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "SD", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "SD", "PUMP8 스위치 수동", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "O3", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "O3", "화재축적모드설정(30초)", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "O4", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "O4", "화재축적모드설정(40초)", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "O5", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "O5", "화재축적모드설정50초)", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "O6", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "O6", "화재축적모드설정(60초)", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "AO", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "AO", "화재축적모드설정", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "AF", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "AF", "화재축적모드비설정", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "HM", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "HM", "화재지속모드설정", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "RM", ReceiverID) == false)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- string sql = string.Format("insert into TB_EVENT_TYPE (EVENT_TYPE,EVENT_TYPE_NAME,UPDATE_USER_ID,UPDATE_TIME) values ('{0}','{1}','{2}',{3})", "RM", "자동복구모드설정", "FireManager", "current_timestamp");
- DB_Query.ExecuteNonQuery(sql);
- }
- if (Column_Check("LOOP2_USE_FLAG", "TB_BOARD", ReceiverID) == false) DB_Excute("ALTER TABLE TB_BOARD ADD LOOP2_USE_FLAG VARCHAR(1)", ReceiverID);
- if (Column_Check("LOOP3_USE_FLAG", "TB_BOARD", ReceiverID) == false) DB_Excute("ALTER TABLE TB_BOARD ADD LOOP3_USE_FLAG VARCHAR(1)", ReceiverID);
- if (Column_Check("LOOP2_BAUD_RATE", "TB_BOARD", ReceiverID) == false) DB_Excute("ALTER TABLE TB_BOARD ADD LOOP2_BAUD_RATE VARCHAR(1)", ReceiverID);
- if (Column_Check("LOOP3_BAUD_RATE", "TB_BOARD", ReceiverID) == false) DB_Excute("ALTER TABLE TB_BOARD ADD LOOP3_BAUD_RATE VARCHAR(1)", ReceiverID);
- if (Column_Check("LOOP2_CUT_FLAG", "TB_BOARD", ReceiverID) == false) DB_Excute("ALTER TABLE TB_BOARD ADD LOOP2_CUT_FLAG VARCHAR(1)", ReceiverID);
- if (Column_Check("LOOP3_CUT_FLAG", "TB_BOARD", ReceiverID) == false) DB_Excute("ALTER TABLE TB_BOARD ADD LOOP3_CUT_FLAG VARCHAR(1)", ReceiverID);
- if (Column_Check("MODEL", "TB_RECEIVER", ReceiverID) == false) DB_Excute("ALTER TABLE TB_RECEIVER ADD MODEL VARCHAR(20)", ReceiverID);
- }
- // cyim 2016.12.06 : 강제쿼리
- public bool Column_Check(string ColumnName, string TableName, int ReceiverID)
- {
- try
- {
- string SQL = string.Format("SELECT Count({0}) FROM {1} WHERE RECEIVER_ID = '{2}'", ColumnName, TableName, ReceiverID);
- DacUIProcess dacUIProcess = new DacUIProcess(ReceiverID);// cyim 2015.7.30 데이타베이스 접속 루틴 변경
- dacUIProcess.ExecuteNonQuery(SQL);
- return true;
- }
- catch
- {
- return false;
- }
- }
- public bool Data_Check(string TableName, string ColumnName, string Value, int ReceiverID)
- {
- try
- {
- string SQL = string.Format("SELECT * FROM {0} WHERE {1}='{2}'", TableName, ColumnName, Value);
- DacUIProcess dacUIProcess = new DacUIProcess(ReceiverID);// cyim 2015.7.30 데이타베이스 접속 루틴 변경
- DataSet dao = dacUIProcess.Select(SQL);
- DataTable dt = dao.Tables[0];
- if (dt.Rows.Count > 0) return true;
- else return false;
- }
- catch
- {
- return false;
- }
- }
- public void DB_Excute(string sql, int ReceiverID)
- {
- DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
- DB_Query.ExecuteNonQuery(sql);
- }
- public string Data_Get(string TableName, string DataName, int ReceiverID)
- {
- try
- {
- string SQL = string.Format("SELECT {0} FROM {1} WHERE RECEIVER_ID = '{2}'", DataName, TableName, ReceiverID);
- DacUIProcess dacUIProcess = new DacUIProcess(ReceiverID);// cyim 2015.7.30 데이타베이스 접속 루틴 변경
- DataSet dao = dacUIProcess.Select(SQL);
- DataTable dt = dao.Tables[0];
- if (dt.Rows.Count != 0)
- {
- return ((DataRow)dt.Rows[0])[DataName].ToString();
- }
- else return null;
- }
- catch
- {
- return null;
- }
- }
- }
- }
|