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