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