using System; using System.Collections.Generic; using System.Text; using FirebirdSql.Data.FirebirdClient; using System.Data; using System.Collections; using System.Diagnostics; namespace FPER { public class DacUIProcess : DacBase { static int iDACUiProcess = 0; public DacUIProcess(int ID) : base(ID)// cyim 2015.7.30 µ¥ÀÌŸº£À̽º Á¢¼Ó ·çƾ º¯°æ { //try { // base.Connect(); //} //catch (Exception ex) { // Util.UErrorMessage(ex, 0, 0); //} iDACUiProcess++; // cyim_debug // Debug.WriteLine("<<<<<<< DacUIProcess »ý¼ºÀÚ È£Ãâ <<<<<< " + Convert.ToString(iDACUiProcess)); } ~DacUIProcess() { //try { // base.DisConnect(); //} //catch (Exception ex) { // Util.UErrorMessage(ex, 0, 0); //} iDACUiProcess--; // cyim_debug // Debug.WriteLine("<<<<<<< DacUIProcess ¼Ò¸êÀÚ È£Ãâ <<<<<< " + Convert.ToString(iDACUiProcess)); } //ÀüüÀ̺¥Æ®¸®½ºÆ® public int Event_Log_RowCnt(int RECEIVER_ID) { int rowcnt = 0; try { String SQL = " SELECT COUNT(*) FROM TB_EVENT_LOG"; DataSet dao = Select(SQL); DataTable dt = dao.Tables[0]; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; rowcnt = Util.StrToInt(dr[0], 0); } SQL = " SELECT COUNT(*) FROM TB_COMMAND_LOG"; DataSet dao2 = Select(SQL); DataTable dt2 = dao2.Tables[0]; if (dt2.Rows.Count > 0) { DataRow dr2 = dt2.Rows[0]; rowcnt += Util.StrToInt(dr2[0], 0); } } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return rowcnt; } //ÀüüÀ̺¥Æ®¸®½ºÆ® public int Event_Log_SelectAllCnt(int RECEIVER_ID, int page, int pageSize, String EVENT_TYPE, bool EVENTTIME_YES, DateTime FROM_DATE, DateTime TO_DATE, int COMM_ID, int BOARD_ID, int LOOP_NO, int REPEATER_ID, int DEVICE_ID, String INOUT_TYPE ) { int rowcnt = 0; try { //String SQL = ""; //SQL += " SELECT COUNT(*) "; //SQL += " FROM ("; //SQL += " SELECT A.EVENT_ID,A.EVENT_TIME,A.EVENT_TYPE,A.RECEIVER_ID,A.COMM_ID,A.BOARD_ID"; //SQL += " ,A.LOOP_NO,A.REPEATER_ID,A.DEVICE_ID,A.INOUT_TYPE,A.DATA_VALUE,A.CONFIRM_FLAG,A.CONFIRM_TIME"; //SQL += " ,E.EVENT_TYPE_NAME,D.DEVICE_NAME,D.DEVICE_TYPE,D.CUT_FLAG,B.DEVICE_TYPE_NAME,C.POSITION_NAME"; //SQL += " FROM TB_EVENT_LOG A"; //SQL += " LEFT OUTER JOIN TB_EVENT_TYPE E ON A.EVENT_TYPE = E.EVENT_TYPE"; //SQL += " LEFT OUTER JOIN TB_DEVICE D ON A.RECEIVER_ID=D.RECEIVER_ID AND A.COMM_ID=D.COMM_ID AND A.BOARD_ID=D.BOARD_ID"; //SQL += " AND A.LOOP_NO=D.LOOP_NO AND A.REPEATER_ID=D.REPEATER_ID AND A.DEVICE_ID=D.DEVICE_ID AND A.INOUT_TYPE=D.INOUT_TYPE"; //SQL += " LEFT OUTER JOIN TB_DEVICE_TYPE B ON D.DEVICE_TYPE = B.DEVICE_TYPE"; //SQL += " LEFT OUTER JOIN TB_POSITION_CODE C ON D.POSITION_CODE = C.POSITION_CODE"; int tick = Environment.TickCount; String SQL = "";// sdkim, 20110406, SQL optimisation SQL += " SELECT COUNT(*) "; SQL += " FROM ("; SQL += " SELECT A.EVENT_ID,A.EVENT_TIME,A.EVENT_TYPE,A.RECEIVER_ID,A.COMM_ID,A.BOARD_ID"; SQL += " ,A.LOOP_NO,A.REPEATER_ID,A.DEVICE_ID,A.INOUT_TYPE,A.DATA_VALUE"; SQL += " FROM TB_EVENT_LOG A"; SQL += string.Format(" WHERE A.RECEIVER_ID = {0}", RECEIVER_ID); if (EVENT_TYPE != null) { if (EVENT_TYPE.Length == 2) SQL += string.Format(" AND A.EVENT_TYPE = '{0}'", EVENT_TYPE); } if (EVENTTIME_YES) { String EVENT_TIME_FROM = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}00000", FROM_DATE); String EVENT_TIME_TO = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}99999", TO_DATE); SQL += string.Format(" AND A.EVENT_TIME >= '{0}' AND A.EVENT_TIME <= '{1}' ", EVENT_TIME_FROM, EVENT_TIME_TO); } if (COMM_ID > 0) { if (COMM_ID == 1) SQL += " AND (A.COMM_ID = 1 OR A.COMM_ID = 2)"; else SQL += string.Format(" AND A.COMM_ID = {0} ", COMM_ID); if (INOUT_TYPE != null) { if (INOUT_TYPE != "") { if (COMM_ID == 1) { if (BOARD_ID > 0) { SQL += string.Format(" AND A.BOARD_ID = {0}", BOARD_ID); if (LOOP_NO == 0 || LOOP_NO == 1) { SQL += string.Format(" AND A.LOOP_NO = {0}", LOOP_NO); if (REPEATER_ID > 0) { SQL += string.Format(" AND A.REPEATER_ID = {0}", REPEATER_ID); if (DEVICE_ID > 0) SQL += string.Format(" AND A.DEVICE_ID = {0}", DEVICE_ID); } } } } else if (COMM_ID == 3) { if (BOARD_ID > 0) { SQL += string.Format(" AND A.BOARD_ID = {0}", BOARD_ID); if (DEVICE_ID > 0) SQL += string.Format(" AND A.DEVICE_ID = {0}", DEVICE_ID); } } else if (COMM_ID == 4) { if (DEVICE_ID > 0) SQL += string.Format(" AND A.DEVICE_ID = {0}", DEVICE_ID); } SQL += string.Format(" AND A.INOUT_TYPE = '{0}'", INOUT_TYPE); } } } // sdkim, 20110406, SQL optimisation //SQL += " UNION ALL"; //SQL += " SELECT A.COMMAND_ID,A.COMMAND_TIME,A.COMMAND_TYPE,A.RECEIVER_ID,A.COMM_ID,A.BOARD_ID"; //SQL += " ,A.LOOP_NO,A.REPEATER_ID,A.DEVICE_ID,A.INOUT_TYPE,0 AS DATA_VALUE,'Y' AS CONFIRM_FLAG,A.COMMAND_TIME AS CONFIRM_TIME"; //SQL += " ,E.EVENT_TYPE_NAME,D.DEVICE_NAME,D.DEVICE_TYPE,D.CUT_FLAG,B.DEVICE_TYPE_NAME,C.POSITION_NAME"; //SQL += " FROM TB_COMMAND_LOG A"; //SQL += " LEFT OUTER JOIN TB_EVENT_TYPE E ON A.COMMAND_TYPE = E.EVENT_TYPE"; //SQL += " LEFT OUTER JOIN TB_DEVICE D ON A.RECEIVER_ID=D.RECEIVER_ID AND A.COMM_ID=D.COMM_ID AND A.BOARD_ID=D.BOARD_ID"; //SQL += " AND A.LOOP_NO=D.LOOP_NO AND A.REPEATER_ID=D.REPEATER_ID AND A.DEVICE_ID=D.DEVICE_ID AND A.INOUT_TYPE=D.INOUT_TYPE"; //SQL += " LEFT OUTER JOIN TB_DEVICE_TYPE B ON D.DEVICE_TYPE = B.DEVICE_TYPE"; //SQL += " LEFT OUTER JOIN TB_POSITION_CODE C ON D.POSITION_CODE = C.POSITION_CODE"; //SQL += string.Format(" WHERE A.RECEIVER_ID = {0}", RECEIVER_ID); //if (EVENT_TYPE != null) //{ // if (EVENT_TYPE.Length == 2) SQL += string.Format(" AND A.COMMAND_TYPE = '{0}'", EVENT_TYPE); //} //if (EVENTTIME_YES) //{ // String EVENT_TIME_FROM = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}00000", FROM_DATE); // String EVENT_TIME_TO = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}99999", TO_DATE); // SQL += string.Format(" AND A.COMMAND_TIME >= '{0}' AND A.COMMAND_TIME <= '{1}' ", EVENT_TIME_FROM, EVENT_TIME_TO); //} //if (COMM_ID > 0) //{ // if (COMM_ID == 1) SQL += " AND (A.COMM_ID = 1 OR A.COMM_ID = 2)"; // else SQL += string.Format(" AND A.COMM_ID = {0} ", COMM_ID); // if (INOUT_TYPE != null) // { // if (INOUT_TYPE != "") // { // if (COMM_ID == 1) // { // if (BOARD_ID > 0) // { // SQL += string.Format(" AND A.BOARD_ID = {0}", BOARD_ID); // if (LOOP_NO == 0 || LOOP_NO == 1) // { // SQL += string.Format(" AND A.LOOP_NO = {0}", LOOP_NO); // if (REPEATER_ID > 0) // { // SQL += string.Format(" AND A.REPEATER_ID = {0}", REPEATER_ID); // if (DEVICE_ID > 0) SQL += string.Format(" AND A.DEVICE_ID = {0}", DEVICE_ID); // } // } // } // } // else if (COMM_ID == 3) // { // if (BOARD_ID > 0) // { // SQL += string.Format(" AND A.BOARD_ID = {0}", BOARD_ID); // if (DEVICE_ID > 0) SQL += string.Format(" AND A.DEVICE_ID = {0}", DEVICE_ID); // } // } // else if (COMM_ID == 4) // { // if (DEVICE_ID > 0) SQL += string.Format(" AND A.DEVICE_ID = {0}", DEVICE_ID); // } // SQL += string.Format(" AND A.INOUT_TYPE = '{0}'", INOUT_TYPE); // } // } //} SQL += " ) A"; DataSet dao = Select(SQL); DataTable dt = dao.Tables[0]; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; rowcnt = Util.StrToInt(dr[0], 0); } //Util.UDebugMessage(string.Format("[TEST] Event_Log_SelectAllCnt Proc Time = {0} rowcnt = {1}", Environment.TickCount - tick, rowcnt), 0, 0); } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return rowcnt; } //ÀüüÀ̺¥Æ®¸®½ºÆ® public DataTable Event_Log_SelectAll(int RECEIVER_ID, int page, int pageSize, String EVENT_TYPE, bool EVENTTIME_YES, DateTime FROM_DATE, DateTime TO_DATE, int COMM_ID, int BOARD_ID, int LOOP_NO, int REPEATER_ID, int DEVICE_ID, String INOUT_TYPE ) { DataTable dt = null; try { //String SQL = ""; //SQL += string.Format(" SELECT FIRST {0} SKIP {1} A.* ", pageSize, (page - 1) * pageSize); //SQL += " FROM ("; //SQL += " SELECT A.EVENT_ID,A.EVENT_TIME,A.EVENT_TYPE,A.RECEIVER_ID,A.COMM_ID,A.BOARD_ID"; //SQL += " ,A.LOOP_NO,A.REPEATER_ID,A.DEVICE_ID,A.INOUT_TYPE,A.DATA_VALUE,A.CONFIRM_FLAG,A.CONFIRM_TIME"; //SQL += " ,E.EVENT_TYPE_NAME,D.DEVICE_NAME,D.DEVICE_TYPE,D.CUT_FLAG,B.DEVICE_TYPE_NAME,C.POSITION_NAME"; //SQL += " FROM TB_EVENT_LOG A"; //SQL += " LEFT OUTER JOIN TB_EVENT_TYPE E ON A.EVENT_TYPE = E.EVENT_TYPE"; //SQL += " LEFT OUTER JOIN TB_DEVICE D ON A.RECEIVER_ID=D.RECEIVER_ID AND A.COMM_ID=D.COMM_ID AND A.BOARD_ID=D.BOARD_ID"; //SQL += " AND A.LOOP_NO=D.LOOP_NO AND A.REPEATER_ID=D.REPEATER_ID AND A.DEVICE_ID=D.DEVICE_ID AND A.INOUT_TYPE=D.INOUT_TYPE"; //SQL += " LEFT OUTER JOIN TB_DEVICE_TYPE B ON D.DEVICE_TYPE = B.DEVICE_TYPE"; //SQL += " LEFT OUTER JOIN TB_POSITION_CODE C ON D.POSITION_CODE = C.POSITION_CODE"; int tick = Environment.TickCount; String SQL = "";// sdkim, 20110406, SQL optimisation SQL += string.Format(" SELECT FIRST {0} SKIP {1} A.* ", pageSize, (page - 1) * pageSize); SQL += " FROM ("; SQL += " SELECT A.EVENT_ID,A.EVENT_TIME,A.EVENT_TYPE,A.RECEIVER_ID,A.COMM_ID,A.BOARD_ID"; SQL += " ,A.LOOP_NO,A.REPEATER_ID,A.DEVICE_ID,A.INOUT_TYPE,A.DATA_VALUE"; SQL += " FROM TB_EVENT_LOG A"; SQL += string.Format(" WHERE A.RECEIVER_ID = {0}", RECEIVER_ID); if (EVENT_TYPE != null) { if (EVENT_TYPE.Length == 2) SQL += string.Format(" AND A.EVENT_TYPE = '{0}'", EVENT_TYPE); } if (EVENTTIME_YES) { String EVENT_TIME_FROM = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}00000", FROM_DATE); String EVENT_TIME_TO = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}99999", TO_DATE); SQL += string.Format(" AND A.EVENT_TIME >= '{0}' AND A.EVENT_TIME <= '{1}' ", EVENT_TIME_FROM, EVENT_TIME_TO); } if (COMM_ID > 0) { if (COMM_ID == 1) SQL += " AND (A.COMM_ID = 1 OR A.COMM_ID = 2)"; else SQL += string.Format(" AND A.COMM_ID = {0} ", COMM_ID); if (INOUT_TYPE != null) { if (INOUT_TYPE != "") { if (COMM_ID == 1) { if (BOARD_ID > 0) { SQL += string.Format(" AND A.BOARD_ID = {0}", BOARD_ID); if (LOOP_NO == 0 || LOOP_NO == 1) { SQL += string.Format(" AND A.LOOP_NO = {0}", LOOP_NO); if (REPEATER_ID > 0) { SQL += string.Format(" AND A.REPEATER_ID = {0}", REPEATER_ID); if (DEVICE_ID > 0) SQL += string.Format(" AND A.DEVICE_ID = {0}", DEVICE_ID); } } } } else if (COMM_ID == 3) { if (BOARD_ID > 0) { SQL += string.Format(" AND A.BOARD_ID = {0}", BOARD_ID); if (DEVICE_ID > 0) SQL += string.Format(" AND A.DEVICE_ID = {0}", DEVICE_ID); } } else if (COMM_ID == 4) { if (DEVICE_ID > 0) SQL += string.Format(" AND A.DEVICE_ID = {0}", DEVICE_ID); } SQL += string.Format(" AND A.INOUT_TYPE = '{0}'", INOUT_TYPE); } } } // sdkim, 20110406, SQL optimisation // SQL += " UNION ALL"; // SQL += " SELECT A.COMMAND_ID,A.COMMAND_TIME,A.COMMAND_TYPE,A.RECEIVER_ID,A.COMM_ID,A.BOARD_ID"; // SQL += " ,A.LOOP_NO,A.REPEATER_ID,A.DEVICE_ID,A.INOUT_TYPE,0 AS DATA_VALUE,'Y' AS CONFIRM_FLAG,A.COMMAND_TIME AS CONFIRM_TIME"; //// SQL += " ,E.EVENT_TYPE_NAME,D.DEVICE_NAME,D.DEVICE_TYPE,D.CUT_FLAG,B.DEVICE_TYPE_NAME,C.POSITION_NAME"; // SQL += " FROM TB_COMMAND_LOG A"; //// SQL += " LEFT OUTER JOIN TB_EVENT_TYPE E ON A.COMMAND_TYPE = E.EVENT_TYPE"; //// SQL += " LEFT OUTER JOIN TB_DEVICE D ON A.RECEIVER_ID=D.RECEIVER_ID AND A.COMM_ID=D.COMM_ID AND A.BOARD_ID=D.BOARD_ID"; //// SQL += " AND A.LOOP_NO=D.LOOP_NO AND A.REPEATER_ID=D.REPEATER_ID AND A.DEVICE_ID=D.DEVICE_ID AND A.INOUT_TYPE=D.INOUT_TYPE"; //// SQL += " LEFT OUTER JOIN TB_DEVICE_TYPE B ON D.DEVICE_TYPE = B.DEVICE_TYPE"; //// SQL += " LEFT OUTER JOIN TB_POSITION_CODE C ON D.POSITION_CODE = C.POSITION_CODE"; // SQL += string.Format(" WHERE A.RECEIVER_ID = {0}", RECEIVER_ID); // if (EVENT_TYPE != null) // { // if (EVENT_TYPE.Length == 2) SQL += string.Format(" AND A.COMMAND_TYPE = '{0}'", EVENT_TYPE); // } // if (EVENTTIME_YES) // { // String EVENT_TIME_FROM = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}00000", FROM_DATE); // String EVENT_TIME_TO = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}99999", TO_DATE); // SQL += string.Format(" AND A.COMMAND_TIME >= '{0}' AND A.COMMAND_TIME <= '{1}' ", EVENT_TIME_FROM, EVENT_TIME_TO); // } // if (COMM_ID > 0) // { // if (COMM_ID == 1) SQL += " AND (A.COMM_ID = 1 OR A.COMM_ID = 2)"; // else SQL += string.Format(" AND A.COMM_ID = {0} ", COMM_ID); // if (INOUT_TYPE != null) // { // if (INOUT_TYPE != "") // { // if (COMM_ID == 1) // { // if (BOARD_ID > 0) // { // SQL += string.Format(" AND A.BOARD_ID = {0}", BOARD_ID); // if (LOOP_NO == 0 || LOOP_NO == 1) // { // SQL += string.Format(" AND A.LOOP_NO = {0}", LOOP_NO); // if (REPEATER_ID > 0) // { // SQL += string.Format(" AND A.REPEATER_ID = {0}", REPEATER_ID); // if (DEVICE_ID > 0) SQL += string.Format(" AND A.DEVICE_ID = {0}", DEVICE_ID); // } // } // } // } // else if (COMM_ID == 3) // { // if (BOARD_ID > 0) // { // SQL += string.Format(" AND A.BOARD_ID = {0}", BOARD_ID); // if (DEVICE_ID > 0) SQL += string.Format(" AND A.DEVICE_ID = {0}", DEVICE_ID); // } // } // else if (COMM_ID == 4) // { // if (DEVICE_ID > 0) SQL += string.Format(" AND A.DEVICE_ID = {0}", DEVICE_ID); // } // SQL += string.Format(" AND A.INOUT_TYPE = '{0}'", INOUT_TYPE); // } // } // } SQL += " ) A"; SQL += " ORDER BY A.EVENT_TIME DESC"; //SQL += " SELECT FIRST 1000 A.*,E.EVENT_TYPE_NAME,D.DEVICE_NAME,D.DEVICE_TYPE"; //SQL += " ,D.CUT_FLAG,B.DEVICE_TYPE_NAME,C.POSITION_NAME"; //SQL += " FROM TB_EVENT_LOG A"; //SQL += " LEFT OUTER JOIN TB_EVENT_TYPE E ON A.EVENT_TYPE = E.EVENT_TYPE"; //SQL += " LEFT OUTER JOIN TB_DEVICE D ON A.RECEIVER_ID=D.RECEIVER_ID AND A.COMM_ID=D.COMM_ID AND A.BOARD_ID=D.BOARD_ID"; //SQL += " AND A.LOOP_NO=D.LOOP_NO AND A.REPEATER_ID=D.REPEATER_ID AND A.DEVICE_ID=D.DEVICE_ID AND A.INOUT_TYPE=D.INOUT_TYPE"; //SQL += " LEFT OUTER JOIN TB_DEVICE_TYPE B ON D.DEVICE_TYPE = B.DEVICE_TYPE"; //SQL += " LEFT OUTER JOIN TB_POSITION_CODE C ON D.POSITION_CODE = C.POSITION_CODE"; //SQL += " WHERE A.RECEIVER_ID = {0} "; //SQL += " ORDER BY A.EVENT_TIME DESC"; DataSet dao = Select(SQL); dt = dao.Tables[0]; //Util.UDebugMessage(string.Format("[TEST] -Event_Log_SelectAll Proc Time = {0}", Environment.TickCount - tick), 0, 0); } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return dt; } //À̺¥Æ®ID·Î °Ë»ö (»ç¿ë¾ÈÇÔ) public DataTable Event_Log_Select(String EVENT_ID) { DataTable dt = null; try { //String SQL = ""; //SQL += " SELECT A.*,D.DEVICE_NAME,D.DEVICE_TYPE"; //SQL += " ,D.CUT_FLAG,B.DEVICE_TYPE_NAME,C.POSITION_NAME,E.EVENT_TYPE_NAME"; //SQL += " FROM TB_EVENT_LOG A"; //SQL += " LEFT OUTER JOIN TB_DEVICE D ON A.RECEIVER_ID=D.RECEIVER_ID AND A.COMM_ID=D.COMM_ID AND A.BOARD_ID=D.BOARD_ID"; //SQL += " AND A.LOOP_NO=D.LOOP_NO AND A.REPEATER_ID=D.REPEATER_ID AND A.DEVICE_ID=D.DEVICE_ID AND A.INOUT_TYPE=D.INOUT_TYPE"; //SQL += " LEFT OUTER JOIN TB_DEVICE_TYPE B ON D.DEVICE_TYPE = B.DEVICE_TYPE"; //SQL += " LEFT OUTER JOIN TB_POSITION_CODE C ON D.POSITION_CODE = C.POSITION_CODE"; //SQL += " LEFT OUTER JOIN TB_EVENT_TYPE E ON A.EVENT_TYPE = E.EVENT_TYPE"; //SQL += " WHERE A.EVENT_ID = '{0}'"; //SQL += " ORDER BY A.EVENT_TIME DESC"; int tick = Environment.TickCount; String SQL = ""; // sdkim, 20110406, SQL optimisation with J.S.W SQL += " SELECT A.*, B.EVENT_TYPE_NAME"; SQL += " FROM TB_EVENT_LOG A, TB_EVENT_TYPE B"; SQL += " WHERE A.EVENT_ID = '{0}' and A.EVENT_TYPE = B.EVENT_TYPE"; SQL += " ORDER BY A.EVENT_TIME DESC"; SQL = String.Format(SQL, EVENT_ID); DataSet dao = Select(SQL); // dt = dao.Tables[0]; //Util.UDebugMessage(string.Format("[TEST] -Event_Log_Select Proc Time = {0}", Environment.TickCount - tick), 0, 0); } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return dt; } //ȸ·Î À̺¥Æ®-È®ÀιÞÁö ¸øÇÑ À̺¥Æ® public DataTable Event_Log_Select_NotConfirm(String EVENT_TYPE, int RECEIVER_ID, int COMM_ID, int BOARD_ID, int LOOP_NO, int REPEATER_ID, int DEVICE_ID, String INOUT_TYPE) { DataTable dt = null; try { String SQL = ""; SQL += " SELECT A.EVENT_TYPE,A.EVENT_TIME,A.DEVICE_ID,D.DEVICE_NAME,D.DEVICE_TYPE,A.INOUT_TYPE"; SQL += " ,D.CUT_FLAG,B.DEVICE_TYPE_NAME,C.POSITION_NAME"; SQL += " ,A.DATA_VALUE,A.EVENT_REMARK"; SQL += " FROM TB_EVENT_LOG A"; SQL += " LEFT OUTER JOIN TB_DEVICE D ON A.RECEIVER_ID=D.RECEIVER_ID AND A.COMM_ID=D.COMM_ID AND A.BOARD_ID=D.BOARD_ID"; SQL += " AND A.LOOP_NO=D.LOOP_NO AND A.REPEATER_ID=D.REPEATER_ID AND A.DEVICE_ID=D.DEVICE_ID AND A.INOUT_TYPE=D.INOUT_TYPE"; SQL += " LEFT OUTER JOIN TB_DEVICE_TYPE B ON D.DEVICE_TYPE = B.DEVICE_TYPE"; SQL += " LEFT OUTER JOIN TB_POSITION_CODE C ON D.POSITION_CODE = C.POSITION_CODE"; SQL += " WHERE A.EVENT_TYPE = '{0}' AND A.RECEIVER_ID = {1} AND A.COMM_ID = {2} AND A.BOARD_ID = {3} AND A.LOOP_NO = {4} AND A.REPEATER_ID = {5}"; SQL += " AND A.DEVICE_ID = {6} AND A.INOUT_TYPE = '{7}' "; SQL += " ORDER BY A.EVENT_TIME DESC"; SQL = String.Format(SQL, EVENT_TYPE, RECEIVER_ID, COMM_ID, BOARD_ID, LOOP_NO, REPEATER_ID, DEVICE_ID, INOUT_TYPE); DataSet dao = Select(SQL); dt = dao.Tables[0]; } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return dt; } //ȸ·Î À̺¥Æ® public DataTable Event_Log_Select(String EVENT_TYPE, int RECEIVER_ID, int COMM_ID, int BOARD_ID, int LOOP_NO, int REPEATER_ID, int DEVICE_ID, String INOUT_TYPE) { DataTable dt = null; try { String SQL = ""; SQL += " SELECT A.EVENT_TYPE,A.EVENT_TIME,A.DEVICE_ID,D.DEVICE_NAME,D.DEVICE_TYPE,A.INOUT_TYPE"; SQL += " ,D.CUT_FLAG,B.DEVICE_TYPE_NAME,C.POSITION_NAME"; SQL += " ,A.DATA_VALUE,A.EVENT_REMARK"; SQL += " FROM TB_EVENT_LOG A"; SQL += " LEFT OUTER JOIN TB_DEVICE D ON A.RECEIVER_ID=D.RECEIVER_ID AND A.COMM_ID=D.COMM_ID AND A.BOARD_ID=D.BOARD_ID"; SQL += " AND A.LOOP_NO=D.LOOP_NO AND A.REPEATER_ID=D.REPEATER_ID AND A.DEVICE_ID=D.DEVICE_ID AND A.INOUT_TYPE=D.INOUT_TYPE"; SQL += " LEFT OUTER JOIN TB_DEVICE_TYPE B ON D.DEVICE_TYPE = B.DEVICE_TYPE"; SQL += " LEFT OUTER JOIN TB_POSITION_CODE C ON D.POSITION_CODE = C.POSITION_CODE"; SQL += " WHERE A.EVENT_TYPE = '{0}' AND A.RECEIVER_ID = {1} AND A.COMM_ID = {2} AND A.BOARD_ID = {3} AND A.LOOP_NO = {4} AND A.REPEATER_ID = {5}"; SQL += " AND A.DEVICE_ID = {6} AND A.INOUT_TYPE = '{7}'"; SQL += " ORDER BY A.EVENT_TIME DESC"; SQL = String.Format(SQL, EVENT_TYPE, RECEIVER_ID, COMM_ID, BOARD_ID, LOOP_NO, REPEATER_ID, DEVICE_ID, INOUT_TYPE); DataSet dao = Select(SQL); dt = dao.Tables[0]; } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return dt; } //À̺¥Æ® È®ÀÎÀúÀå public void Event_Log_UPDATE(QUERYMode cmd, String EVENT_ID, String CONFIRM_FLAG, String CONFIRM_REMARK) { try { DataTable dt = Event_Log_Select(EVENT_ID); if (cmd == QUERYMode.insert || cmd == QUERYMode.update || cmd == QUERYMode.InsertAndUpdate) { String SQL = ""; if (dt.Rows.Count > 0) { SQL = "UPDATE TB_EVENT_LOG SET CONFIRM_FLAG = '{1}'"; SQL += ", CONFIRM_REMARK = '{2}'"; SQL += ", CONFIRM_PERSON = 'FPER', CONFIRM_TIME = current_timestamp"; SQL += " WHERE EVENT_ID = '{0}'"; SQL = String.Format(SQL, EVENT_ID, CONFIRM_FLAG, CONFIRM_REMARK); ExecuteNonQuery(SQL); } else { //SQL = "INSERT INTO TB_EVENT_LOG ( "; //SQL += " EVENT_TIME,EVENT_TYPE,RECEIVER_ID,COMM_ID,BOARD_ID,LOOP_NO,REPEATER_ID,DEVICE_ID,INOUT_TYPE,DATA_VALUE,EVENT_REMARK"; //SQL += " ,CONFIRM_FLAG,CONFIRM_REMARK,CONFIRM_PERSON,CONFIRM_TIME"; //SQL += ") VALUES ({0},1,{1},{2},{3},'{4}','{5}','{6}','N','FPER',current_timestamp)"; //SQL = String.Format(SQL, RECEIVER_ID, BOARD_ID, LOOP_NO, REPEATER_ID, REPEATER_NAME, REPEATER_TYPE, USE_FLAG); } } else if (cmd == QUERYMode.delete) { if (dt.Rows.Count < 1) { throw new Exception("ÇØ´ç ÀڷḦ ãÀ»¼ö ¾ø½À´Ï´Ù."); } String SQL = "DELETE FROM TB_EVENT_LOG "; SQL += " WHERE EVENT_ID = '{0}'"; SQL = String.Format(SQL, EVENT_ID); ExecuteNonQuery(SQL); } } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } } //À̺¥Æ® ·Î±× (»ç¿ë¾ÈÇÔ) public string Event_TypeName_Select(String EVENT_TYPE) { string type_name = ""; try { String SQL = ""; SQL += " SELECT EVENT_TYPE,EVENT_TYPE_NAME"; SQL += " FROM TB_EVENT_TYPE "; SQL += " WHERE EVENT_TYPE = '{0}' "; SQL = String.Format(SQL, EVENT_TYPE); DataSet dao = Select(SQL); DataTable dt = dao.Tables[0]; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; type_name = dr["EVENT_TYPE_NAME"].ToString(); } } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return type_name; } //À̺¥Æ® ŸÀÔ¸®½ºÆ® public DataTable Event_Type_Select(String EVENT_TYPE, MDIParent mdi) // cyim 2015.8.4 ¼ö½Å¹ÝÀ» À§ÇÑ static Ŭ·¡½º Á¤¸® { DataTable dt = null; try { //String SQL = ""; //if (EVENT_TYPE == null) //{ // SQL += " SELECT EVENT_TYPE,EVENT_TYPE_NAME"; // SQL += " FROM TB_EVENT_TYPE "; //} //else //{ // SQL += " SELECT EVENT_TYPE,EVENT_TYPE_NAME"; // SQL += " FROM TB_EVENT_TYPE "; // SQL += " WHERE EVENT_TYPE = '{0}' "; // SQL = String.Format(SQL, EVENT_TYPE); //} //DataSet dao = Select(SQL); //dt = dao.Tables[0]; // cyim 2013.8.8 À̺¥Æ® ŸÀÔ¸í ÇØ½¬Å×À̺í·Î º¯È¯ (»ó´Ü ¸ðµÎ ÁÖ¼® ó¸®) dt = mdi.EventTypeName.DataTable_EventType; // cyim 2015.8.4 ¼ö½Å¹ÝÀ» À§ÇÑ static Ŭ·¡½º Á¤¸® } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return dt; } public DataTable Event_Type_Table_Select(String EVENT_TYPE, MDIParent mdi) // cyim 2015.8.4 ¼ö½Å¹ÝÀ» À§ÇÑ static Ŭ·¡½º Á¤¸® { // sdkim, 20110406, Event_Type Table Data Pre Load DataTable dt = null; try { //String SQL = ""; //if (EVENT_TYPE == null) //{ // SQL += " SELECT EVENT_TYPE,EVENT_TYPE_NAME"; // SQL += " FROM TB_EVENT_TYPE "; //} //else //{ // SQL += " SELECT EVENT_TYPE,EVENT_TYPE_NAME"; // SQL += " FROM TB_EVENT_TYPE "; // SQL += " WHERE EVENT_TYPE = '{0}' "; // SQL = String.Format(SQL, EVENT_TYPE); //} //DataSet dao = Select(SQL); //dt = dao.Tables[0]; // cyim 2013.8.8 À̺¥Æ® ŸÀÔ¸í ÇØ½¬Å×À̺í·Î º¯È¯ (»ó´Ü ¸ðµÎ ÁÖ¼® ó¸®) dt = mdi.EventTypeName.DataTable_EventType; // cyim 2015.8.4 ¼ö½Å¹ÝÀ» À§ÇÑ static Ŭ·¡½º Á¤¸® return dt; } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); return null;//throw ex; } } //command Á¶È¸ public DataTable Command_Log_Select(String COMMAND_ID) { DataTable dt = null; try { String SQL = ""; SQL += " SELECT A.*,D.DEVICE_NAME,D.DEVICE_TYPE"; SQL += " ,D.CUT_FLAG,B.DEVICE_TYPE_NAME,C.POSITION_NAME"; SQL += " FROM TB_COMMAND_LOG A"; SQL += " LEFT OUTER JOIN TB_DEVICE D ON A.RECEIVER_ID=D.RECEIVER_ID AND A.COMM_ID=D.COMM_ID AND A.BOARD_ID=D.BOARD_ID"; SQL += " AND A.LOOP_NO=D.LOOP_NO AND A.REPEATER_ID=D.REPEATER_ID AND A.DEVICE_ID=D.DEVICE_ID AND A.INOUT_TYPE=D.INOUT_TYPE"; SQL += " LEFT OUTER JOIN TB_DEVICE_TYPE B ON D.DEVICE_TYPE = B.DEVICE_TYPE"; SQL += " LEFT OUTER JOIN TB_POSITION_CODE C ON D.POSITION_CODE = C.POSITION_CODE"; SQL += " WHERE A.COMMAND_ID = '{0}' "; SQL += " ORDER BY A.COMMAND_TIME DESC"; SQL = String.Format(SQL, COMMAND_ID); DataSet dao = Select(SQL); dt = dao.Tables[0]; } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return dt; } //command È®ÀÎÀúÀå public void Command_Log_UPDATE(QUERYMode cmd, String COMMAND_ID, String COMMAND_TIME, String COMMAND_TYPE, int RECEIVER_ID , int COMM_ID, int BOARD_ID, int LOOP_NO, int REPEATER_ID, int DEVICE_ID, String INOUT_TYPE, String COMMAND_REMARK) { try { // cyim 2015.2.9 ½ÃÀ۽à ·Î±×¸¦ ÀúÀåÇÏ´Â °æ¿ì DB ºÎÇϰ¡ °É¸² Á¦°Å // COMMAND_ID ´Â ³¯Â¥¿Í½Ã°£À» Á¶ÇÕÇÑ ¾ÆÀ̵ð°ªÀÌ´Ù. Áߺ¹µÉ È®·üÀº ¹ÌºñÇϹǷÎ, ÇÏÀ§ ·çƾÀº ·Î±×¸¦ ÀúÀå½Ã¿¡ ºÎÇϰ¡ °É¸± È®·üÀÌ ³ô´Ù. //DataTable dt = Command_Log_Select(COMMAND_ID); if (cmd == QUERYMode.insert || cmd == QUERYMode.update || cmd == QUERYMode.InsertAndUpdate) { String SQL = ""; // cyim 2015.2.9 ½ÃÀ۽à ·Î±×¸¦ ÀúÀåÇÏ´Â °æ¿ì DB ºÎÇϰ¡ °É¸² Á¦°Å //if (dt.Rows.Count > 0) //{ // //SQL = "UPDATE TB_COMMAND_LOG SET CONFIRM_FLAG = '{1}'"; // //SQL += ", CONFIRM_REMARK = '{2}'"; // //SQL += ", CONFIRM_PERSON = 'FPER', CONFIRM_TIME = current_timestamp"; // //SQL += " WHERE COMMAND_ID = '{0}'"; // //SQL = String.Format(SQL, COMMAND_ID, CONFIRM_REMARK); // //ExecuteNonQuery(SQL); //} //else { SQL = "INSERT INTO TB_COMMAND_LOG ( "; SQL += " COMMAND_ID,COMMAND_TIME,COMMAND_TYPE,RECEIVER_ID,COMM_ID,BOARD_ID,LOOP_NO,"; SQL += " REPEATER_ID,DEVICE_ID,INOUT_TYPE,COMMAND_REMARK"; SQL += ") VALUES ('{0}','{1}','{2}',{3},{4},{5},{6},{7},{8},'{9}','{10}')"; SQL = String.Format(SQL, COMMAND_ID, COMMAND_TIME, COMMAND_TYPE, RECEIVER_ID, COMM_ID, BOARD_ID, LOOP_NO, REPEATER_ID, DEVICE_ID, INOUT_TYPE, COMMAND_REMARK); ExecuteNonQuery(SQL); } } else if (cmd == QUERYMode.delete) { // cyim 2015.2.9 ½ÃÀ۽à ·Î±×¸¦ ÀúÀåÇÏ´Â °æ¿ì DB ºÎÇϰ¡ °É¸² Á¦°Å //if (dt.Rows.Count < 1) //{ // throw new Exception("ÇØ´ç ÀڷḦ ãÀ»¼ö ¾ø½À´Ï´Ù."); //} String SQL = "DELETE FROM TB_COMMAND_LOG "; SQL += " WHERE COMMAND_ID = '{0}'"; SQL = String.Format(SQL, COMMAND_ID); ExecuteNonQuery(SQL); } } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } } public int GetEventLogCount(int receiverID) { int ret = -1; try { DataTable dt = null; String SQL = ""; SQL += "SELECT COUNT (*)"; SQL += " FROM TB_EVENT_LOG"; SQL += " WHERE RECEIVER_ID = {0} "; SQL = String.Format(SQL, receiverID); DataSet dao = Select(SQL); dt = dao.Tables[0]; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; } for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; ret = Int32.Parse(dr["COUNT"].ToString()); } } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return ret; } public string[] GetEventLogData(int receiverID, int count) { string[] ret = new string[count]; try { DataTable dt = null; String SQL = ""; SQL += "SELECT FIRST {1} EVENT_ID "; SQL += " FROM TB_EVENT_LOG"; SQL += " WHERE RECEIVER_ID = {0} "; SQL += " ORDER BY EVENT_TIME "; SQL = String.Format(SQL, receiverID, count); DataSet dao = Select(SQL); dt = dao.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; ret[i] = dr["EVENT_ID"].ToString(); } } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return ret; } public string GetEventLogTime(int receiverID, int count) { string ret = ""; try { DataTable dt = null; String SQL = ""; SQL += "SELECT FIRST 1 SKIP {1} EVENT_TIME "; SQL += " FROM TB_EVENT_LOG"; SQL += " WHERE RECEIVER_ID = {0} "; SQL += " ORDER BY EVENT_TIME DESC"; SQL = String.Format(SQL, receiverID, count); DataSet dao = Select(SQL); dt = dao.Tables[0]; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; ret = dr["EVENT_TIME"].ToString(); } } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return ret; } public void AddEventLogData(EventLogInfo elog) { try { string event_time = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}00000", elog.EventTime); string SQL = ""; SQL = "INSERT INTO TB_EVENT_LOG ( "; SQL += " EVENT_ID,EVENT_TIME,EVENT_TYPE,RECEIVER_ID,COMM_ID,BOARD_ID,LOOP_NO,REPEATER_ID,DEVICE_ID,INOUT_TYPE,DATA_VALUE,SEND_FLAG"; SQL += " ) VALUES ('{0}','{1}','{2}',{3},{4},{5},{6},{7},{8},'{9}',{10},'N')"; SQL = String.Format(SQL, elog.EventId, event_time, elog.EventType, elog.ReceiverID, elog.CommId, elog.BoardNo, elog.LoopNo, elog.RepeaterNo, elog.DeviceId, elog.InoutType, elog.DataValue); ExecuteNonQuery(SQL); } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } } public void DeleteEventLogDataTime(string eventTime) { try { if (eventTime != "") { String SQL = "DELETE FROM TB_EVENT_LOG "; SQL += " WHERE EVENT_TIME < '{0}'"; SQL = String.Format(SQL, eventTime); ExecuteNonQuery(SQL); } } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } } // cyim 2015.2.13 ·Î±×´Â 2³â À¯Áö public void DeleteCommandLogData(string COMMAND_TIME) { try { if (COMMAND_TIME != "") { String SQL = "DELETE FROM TB_COMMAND_LOG "; SQL += " WHERE COMMAND_TIME < '{0}'"; SQL = String.Format(SQL, COMMAND_TIME); ExecuteNonQuery(SQL); } } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } } public void DeleteEventLogData(string eventID) { try { if (eventID != "") { String SQL = "DELETE FROM TB_EVENT_LOG "; SQL += " WHERE EVENT_ID = '{0}'"; SQL = String.Format(SQL, eventID); ExecuteNonQuery(SQL); } } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } } public void DeleteEventLogData(string[] eventID) { try { if (eventID.Length > 0) { String SQL = "DELETE FROM TB_EVENT_LOG "; bool first = true; foreach (string eID in eventID) { if (first) { if (eID != "") { SQL += string.Format(" WHERE EVENT_ID = '{0}'", eID); first = false; } } else { if (eID != "") { SQL += string.Format(" AND EVENT_ID = '{0}'", eID); } } } ExecuteNonQuery(SQL); } } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } } //ȸ·ÎÁ¶È¸ public DataTable Device_Select(int RECEIVER_ID, int COMM_ID, int BOARD_ID, int LOOP_NO, int REPEATER_ID, int DEVICE_ID, String INOUT_TYPE) { DataTable dt = null; try { String SQL = ""; SQL += " SELECT A.DEVICE_ID,A.DEVICE_NAME,A.DEVICE_TYPE,A.INOUT_TYPE,A.CUT_FLAG,B.DEVICE_TYPE_NAME,A.POSITION_CODE,C.POSITION_NAME"; SQL += " FROM TB_DEVICE A "; SQL += " LEFT OUTER JOIN TB_DEVICE_TYPE B ON A.DEVICE_TYPE = B.DEVICE_TYPE"; SQL += " LEFT OUTER JOIN TB_POSITION_CODE C ON A.POSITION_CODE = C.POSITION_CODE"; SQL += " WHERE A.RECEIVER_ID = {0} AND A.COMM_ID = {1} AND A.BOARD_ID = {2} AND A.LOOP_NO = {3} AND A.REPEATER_ID = {4}"; SQL += " AND A.DEVICE_ID = {5} AND A.INOUT_TYPE = '{6}'"; SQL = String.Format(SQL, RECEIVER_ID, COMM_ID, BOARD_ID, LOOP_NO, REPEATER_ID, DEVICE_ID, INOUT_TYPE); DataSet dao = Select(SQL); dt = dao.Tables[0]; } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return dt; } public DataTable SelectLastLog(int receviceID, int commID, int boardID, int loopNO, int repeaterID, int deviceID, string inoutType, string eventtype) { DataTable dt = null; try { String SQL = ""; SQL += "SELECT FIRST 1 EVENT_ID,EVENT_TIME,EVENT_TYPE,RECEIVER_ID,COMM_ID,BOARD_ID,LOOP_NO,REPEATER_ID,DEVICE_ID,INOUT_TYPE,DATA_VALUE,EVENT_REMARK,SEND_FLAG"; SQL += " FROM TB_EVENT_LOG"; SQL += " WHERE EVENT_TYPE = '{0}' AND RECEIVER_ID = {1} AND COMM_ID = {2} AND BOARD_ID = {3} AND LOOP_NO = {4} AND REPEATER_ID = {5} AND DEVICE_ID = {6} AND INOUT_TYPE = '{7}'"; SQL += " ORDER BY EVENT_TIME DESC"; SQL = String.Format(SQL, eventtype, receviceID, commID, boardID, loopNO, repeaterID, deviceID, inoutType); DataSet dao = Select(SQL); dt = dao.Tables[0]; } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return dt; } public DataTable SelectLogEvnetID(string EventID) { DataTable dt = null; try { String SQL = ""; SQL += "SELECT EVENT_ID,EVENT_TIME,EVENT_TYPE,RECEIVER_ID,COMM_ID,BOARD_ID,LOOP_NO,REPEATER_ID,DEVICE_ID,INOUT_TYPE,DATA_VALUE,EVENT_REMARK,SEND_FLAG"; SQL += " FROM TB_EVENT_LOG"; SQL += " WHERE EVENT_ID = '{0}' "; SQL = String.Format(SQL, EventID); DataSet dao = Select(SQL); dt = dao.Tables[0]; } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return dt; } public void AddEventLogData(string EVENT_ID, string EVENT_TIME, string EVENT_TYPE, int RECEIVER_ID, int COMM_ID, int BOARD_ID, int LOOP_NO, int REPEATER_ID, int DEVICE_ID, string INOUT_TYPE, int DATA_VALUE, string EVENT_REMARK, string SEND_FLAG) { try { string SQL = ""; SQL = "INSERT INTO TB_EVENT_LOG ( "; SQL += " EVENT_ID,EVENT_TIME,EVENT_TYPE,RECEIVER_ID,COMM_ID,BOARD_ID,LOOP_NO,REPEATER_ID,DEVICE_ID,INOUT_TYPE,DATA_VALUE,EVENT_REMARK,SEND_FLAG"; SQL += " ) VALUES ('{0}','{1}','{2}',{3},{4},{5},{6},{7},{8},'{9}',{10},'{11}','{12}')"; SQL = String.Format(SQL, EVENT_ID, EVENT_TIME, EVENT_TYPE, RECEIVER_ID, COMM_ID, BOARD_ID, LOOP_NO, REPEATER_ID, DEVICE_ID, INOUT_TYPE, DATA_VALUE, EVENT_REMARK, SEND_FLAG); ExecuteNonQuery(SQL); } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } } public DataTable SelectSQL(string SQL) { DataTable dt = null; try { DataSet dao = Select(SQL); dt = dao.Tables[0]; } catch (Exception ex) { Util.UErrorMessage(ex, 0, 0); throw ex; } return dt; } } public class LogType { public bool cnt = false; public bool time = false; public DateTime startTime; public DateTime endTime; public bool eventTypeDetail = false; public string eventTypeD = ""; public bool fireOn = false; //public bool fireOff = false; public bool devOn = false; //public bool devOff = false; //public bool errorOn = false; //public bool errorOff = false; public bool controlLog = false; public bool boardError = false; public bool repeaterError = false; public bool devError = false; public int startIndex = 0; public int endIndex = 0; public bool location = false; private string SqlBase() { string sql = ""; sql += "EVENT_ID,EVENT_TIME,EVENT_TYPE,RECEIVER_ID,COMM_ID,BOARD_ID,LOOP_NO,REPEATER_ID,DEVICE_ID,INOUT_TYPE,DATA_VALUE,EVENT_REMARK "; sql += "FROM TB_EVENT_LOG "; sql += "WHERE RECEIVER_ID > 0 "; return sql; } private string SqlTime() { string sql = ""; if (time) { String strStartTime = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}00000", startTime); String strEndTime = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}99999", endTime); sql += string.Format(" AND EVENT_TIME >= '{0}' AND EVENT_TIME <= '{1}' ", strStartTime, strEndTime); } return sql; } // cyim 2013.10.10 : 1000°Ç Á¶È¸ ¼Óµµ °³¼± ÀÛ¾÷ //private string COMMANDSqlTime(DateTime StartTime, DateTime EndTime) //{ // string sql = ""; // if (time) // { // String strStartTime = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}00000", StartTime); // String strEndTime = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}99999", EndTime); // sql += string.Format(" AND COMMAND_TIME >= '{0}' AND COMMAND_TIME <= '{1}' ", strStartTime, strEndTime); // } // return sql; //} private string SqlTime(DateTime StartTime, DateTime EndTime) { string sql = ""; if (time) { String strStartTime = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}00000", StartTime); String strEndTime = String.Format("{0:yyyy}{0:MM}{0:dd}{0:HH}{0:mm}{0:ss}99999", EndTime); sql += string.Format(" AND EVENT_TIME >= '{0}' AND EVENT_TIME <= '{1}' ", strStartTime, strEndTime); } return sql; } private string SqlCount() { string sql = ""; sql += "COUNT(*) "; sql += "FROM TB_EVENT_LOG "; sql += "WHERE RECEIVER_ID > 0 "; return sql; } private string SqlIndex() { string sql = ""; if (endIndex != startIndex) { sql += string.Format("FIRST {0} ", endIndex, startIndex); } return sql; } public int receiverID = -1; public int commID = -1; // 1,2 Åë½Åº¸µå, , 3 IO º¸µå 4 ŰÆÐµå public int boardID = -1;// 0 : ŰÆÐµå, 1~16 IOº¸µå, Åë½Åº¸µå public int loopNo = -1; // 0, 1 public int repeaterID = -1; // 1~127 public int deviceID = -1; // 1~4 public string ioType = "A"; // A: Àüü, C Åë½Å(¼ö½Å±â) , B º¸µå, L ·çÇÁ, R Áß°è±â, D ȸ·Î, I ÀÔ·Â , O Ãâ·Â , E:°èÅë ·¹º§ ÀÌ¿Ü ÀüºÎ private string SqlLocation() { string sql = ""; if (this.location) { if (receiverID > 0) { sql += string.Format("AND RECEIVER_ID = {0} ", receiverID); } if (commID > 0) { sql += string.Format("AND COMM_ID = {0} ", commID); } if (boardID > 0) { sql += string.Format("AND BOARD_ID = {0} ", boardID); } if (loopNo > -1) { sql += string.Format("AND LOOP_NO = {0} ", loopNo); } if (repeaterID > 0) { sql += string.Format("AND REPEATER_ID = {0} ", repeaterID); } if (deviceID > 0) { sql += string.Format("AND DEVICE_ID = {0} ", deviceID); } if (ioType != "A") { switch (ioType) { case "L": sql += string.Format("AND ( INOUT_TYPE = 'B' OR INOUT_TYPE = 'L') "); break; case "D": sql += string.Format("AND ( INOUT_TYPE = 'I' OR INOUT_TYPE = 'O') "); break; case "E": sql += string.Format("AND COMM_ID != 1 "); break; default: sql += string.Format("AND INOUT_TYPE = '{0}' ", ioType); break; } } } return sql; } private string SqlEventTypeDetail() { string sql = ""; sql += string.Format("AND EVENT_TYPE = '{0}' ", eventTypeD); return sql; } //private string SqlCOMMANDTypeDetail() //{ // string sql = ""; // sql += string.Format("AND COMMAND_TYPE = '{0}' ", eventTypeD); // return sql; //} private string SqlEventType() { string sql = ""; if (fireOn && devOn && controlLog && boardError && repeaterError && devError) { } else if ((fireOn || devOn || controlLog || boardError || repeaterError || devError) == false) { } else { if (fireOn) { sql += "AND ( EVENT_TYPE = 'OA' "; //È­ÀçÃàÀû»óÅ ¹ß»ý sql += "OR EVENT_TYPE = 'OF' ";//È­Àç»óÅ ¹ß»ý sql += "OR EVENT_TYPE = 'OT' "; //¹ß½Å±â¼³Á¤ sql += "OR EVENT_TYPE = 'XA' "; //È­ÀçÃàÀû»óÅÂ ÇØÁ¦ sql += "OR EVENT_TYPE = 'XF' ";//È­Àç»óÅÂ ÇØÁ¦ sql += "OR EVENT_TYPE = 'XT' ";//¹ß½Å±âÇØÁ¦ } if (devOn) { if (fireOn/* || fireOff*/) { sql += "OR "; } else { sql += "AND ( "; } sql += "EVENT_TYPE = 'OE' "; //¼³ºñÀÛµ¿»óÅ ¹ß»ý sql += "OR EVENT_TYPE = 'XE' "; //¼³ºñÀÛµ¿»óÅÂ ÇØÁ¦ sql += "OR EVENT_TYPE = 'EW' "; //¼³ºñÃâ·Â»óÅ ON sql += "OR EVENT_TYPE = 'EF' "; //¼³ºñÃâ·Â»óÅ OFF } if (controlLog) { if (fireOn /*|| fireOff*/ || devOn /*|| devOff || errorOn || errorOff*/) { sql += "OR "; } else { sql += "AND ( "; } sql += "EVENT_TYPE = 'OP' ";//ÀüÈ­¼³Á¤ sql += "OR EVENT_TYPE = 'XP' ";//ÀüÈ­ÇØÁ¦ sql += "OR EVENT_TYPE = 'SP' ";//È­¸éÁÂÇ¥¼³Á¤¹öư sql += "OR EVENT_TYPE = 'MS' ";//ÁÖÀ½ÇâÁ¤Áö¹öư sql += "OR EVENT_TYPE = 'LS' ";//Áö±¸À½ÇâÁ¤Áö¹öư sql += "OR EVENT_TYPE = 'EB' ";//ºñ»ó¹æ¼ÛÁ¤Áö¹öư sql += "OR EVENT_TYPE = 'RP' ";//¿¹ºñÀü¿ø½ÃÇè¹öư sql += "OR EVENT_TYPE = 'ED' ";//¼³ºñ¿¬µ¿Á¶ÀÛ¹öư // cyim 2016.12.09 : IFC3300¿¡¼­´Â ¿¹ºñÀü¿ø¹öư -> ¼³ºñÀüü¿¬µ¿Á¶ÀÛ¹öư sql += "OR EVENT_TYPE = 'FR' ";//È­À纹±¸¹öư sql += "OR EVENT_TYPE = 'EC' ";//¼³ºñ¿¬µ¿È­¸é¹öư sql += "OR EVENT_TYPE = 'PO' ";//Åë½Å(POLLING) ½ÃÀÛ sql += "OR EVENT_TYPE = 'PF' ";//Åë½Å(POLLING) Á¾·á sql += "OR EVENT_TYPE = 'CC' ";//Åë½Å»óÅÂÀбâ sql += "OR EVENT_TYPE = 'CV' ";//Àü¾Ð»óÅÂÀбâ sql += "OR EVENT_TYPE = 'V2' ";//24 Àü¾Ð º¯°æ sql += "OR EVENT_TYPE = 'DC' ";//¼³ºñÀÛµ¿Â÷´Ü sql += "OR EVENT_TYPE = 'CS' ";//ȯ°æ¼³Á¤ sql += "OR EVENT_TYPE = 'TK' ";//ŰÆÐµåÅ×½ºÆ® sql += "OR EVENT_TYPE = 'VI' ";//Åë½ÅÇÁ·Î±×·¥¹öÀüÁ¤º¸ sql += "OR EVENT_TYPE = 'BF' ";//ºÎÀúÁ¤Áö sql += "OR EVENT_TYPE = 'EL' ";//À̺¥Æ®¸®½ºÆ® sql += "OR EVENT_TYPE = 'BS' ";//º¸µå»óÅ sql += "OR EVENT_TYPE = 'RA' ";//È­ÀçÃàÀû»óÅ Àç¼³Á¤ sql += "OR EVENT_TYPE = 'OU' ";//UIÇÁ·Î±×·¥½ÃÀÛ sql += "OR EVENT_TYPE = 'XU' ";//UIÇÁ·Î±×·¥Á¾·á sql += "OR EVENT_TYPE = 'DS' ";//¼³ºñÀÛµ¿»óÅÂÁ¶È¸ } if (boardError) { if (fireOn || devOn || controlLog) { sql += "OR "; } else { sql += "AND ( "; } sql += "EVENT_TYPE = 'XM' "; //Åë½Å¸ðµâ Åë½ÅÀÌ»ó sql += "OR EVENT_TYPE = 'XI' ";//I/O ¸ðµâ Åë½ÅÀÌ»ó sql += "OR EVENT_TYPE = 'XK' ";//ŰÆÐµå¸ðµâ Åë½ÅÀÌ»ó sql += "OR EVENT_TYPE = 'AV' ";//Ãâ·ÂÀü¾Ð ÀÌ»ó sql += "OR EVENT_TYPE = 'AR' ";//¿¹ºñÀü¿ø ÀÌ»ó sql += "OR EVENT_TYPE = 'AA' ";//±³·ùÀü¿ø ÀÌ»ó sql += "OR EVENT_TYPE = 'OD' ";//µ¥¸ó¿¬°áÀÌ»ó sql += "OR EVENT_TYPE = 'OB' ";//DB¿¬°áÀÌ»ó sql += "OR EVENT_TYPE = 'BA' ";//Åë½Åº¸µå·çÇÁ±³·ùÀü¿øÀÌ»ó sql += "OR EVENT_TYPE = 'BR' ";//Åë½Åº¸µå·çÇÁ¿¹ºñÀü¿øÀÌ»ó sql += "OR EVENT_TYPE = 'XC' ";//ºñ»ó¹æ¼Û Åë½ÅÀÌ»ó sql += "OR EVENT_TYPE = 'OM' ";//Åë½Å¸ðµâ Åë½ÅÁ¤»ó sql += "OR EVENT_TYPE = 'OI' ";//I/O ¸ðµâ Åë½ÅÁ¤»ó sql += "OR EVENT_TYPE = 'OK' ";//ŰÆÐµå¸ðµâ Åë½ÅÁ¤»ó sql += "OR EVENT_TYPE = 'NV' ";//Ãâ·ÂÀü¾Ð Á¤»ó sql += "OR EVENT_TYPE = 'NR' ";//¿¹ºñÀü¿ø Á¤»ó sql += "OR EVENT_TYPE = 'NA' ";//±³·ùÀü¿ø Á¤»ó sql += "OR EVENT_TYPE = 'XD' ";//µ¥¸ó¿¬°áÁ¤»ó sql += "OR EVENT_TYPE = 'XB' ";//DB¿¬°áÁ¤»ó sql += "OR EVENT_TYPE = 'BN' ";//Åë½Åº¸µå·çÇÁÁ¤»ó sql += "OR EVENT_TYPE = 'OC' ";//ºñ»ó¹æ¼Û Åë½ÅÁ¤»ó } if (repeaterError) { if (fireOn || devOn || controlLog || boardError) { sql += "OR "; } else { sql += "AND ( "; } sql += " EVENT_TYPE = 'XR' ";//Áß°è±â Åë½ÅÀÌ»ó sql += "OR EVENT_TYPE = 'OR' ";//Áß°è±â Åë½ÅÁ¤»ó sql += "OR EVENT_TYPE = 'OX' ";//Áß°è±âÀü¿øÀÌ»ó sql += "OR EVENT_TYPE = 'XX' ";//Áß°è±âÀü¿øÀÌ»ó ÇØÁ¦ } if (devError) { if (fireOn || devOn || controlLog || boardError || repeaterError) { sql += "OR "; } else { sql += "AND ( "; } sql += " EVENT_TYPE = 'OL' ";//Áß°è±â ´Ü¼±¹ß»ý sql += "OR EVENT_TYPE = 'XL' ";//Áß°è±â ´Ü¼±º¹±¸ } sql += " ) "; } return sql; } //private string SqlCOMMANDType() //{ // string sql = ""; // if (fireOn && devOn && controlLog && boardError && repeaterError && devError) // { // } // else if ((fireOn || devOn || controlLog || boardError || repeaterError || devError) == false) // { // } // else // { // if (fireOn) // { // sql += "AND ( COMMAND_TYPE = 'OA' "; //È­ÀçÃàÀû»óÅ ¹ß»ý // sql += "OR EVENT_TYPE = 'OF' ";//È­Àç»óÅ ¹ß»ý // sql += "OR EVENT_TYPE = 'OT' "; //¹ß½Å±â¼³Á¤ // sql += "OR EVENT_TYPE = 'XA' "; //È­ÀçÃàÀû»óÅÂ ÇØÁ¦ // sql += "OR EVENT_TYPE = 'XF' ";//È­Àç»óÅÂ ÇØÁ¦ // sql += "OR EVENT_TYPE = 'XT' ";//¹ß½Å±âÇØÁ¦ // } // if (devOn) // { // if (fireOn/* || fireOff*/) // { // sql += "OR "; // } // else // { // sql += "AND ( "; // } // sql += "EVENT_TYPE = 'OE' "; //¼³ºñÀÛµ¿»óÅ ¹ß»ý // sql += "OR EVENT_TYPE = 'XE' "; //¼³ºñÀÛµ¿»óÅÂ ÇØÁ¦ // sql += "OR EVENT_TYPE = 'EW' "; //¼³ºñÃâ·Â»óÅ ON // sql += "OR EVENT_TYPE = 'EF' "; //¼³ºñÃâ·Â»óÅ OFF // } // if (controlLog) // { // if (fireOn /*|| fireOff*/ || devOn /*|| devOff || errorOn || errorOff*/) // { // sql += "OR "; // } // else // { // sql += "AND ( "; // } // sql += "EVENT_TYPE = 'OP' ";//ÀüÈ­¼³Á¤ // sql += "OR EVENT_TYPE = 'XP' ";//ÀüÈ­ÇØÁ¦ // sql += "OR EVENT_TYPE = 'SP' ";//È­¸éÁÂÇ¥¼³Á¤¹öư // sql += "OR EVENT_TYPE = 'MS' ";//ÁÖÀ½ÇâÁ¤Áö¹öư // sql += "OR EVENT_TYPE = 'LS' ";//Áö±¸À½ÇâÁ¤Áö¹öư // sql += "OR EVENT_TYPE = 'EB' ";//ºñ»ó¹æ¼ÛÁ¤Áö¹öư // sql += "OR EVENT_TYPE = 'RP' ";//¿¹ºñÀü¿ø½ÃÇè¹öư // sql += "OR EVENT_TYPE = 'ED' ";//¼³ºñ¿¬µ¿Á¶ÀÛ¹öư // cyim 2016.12.09 : IFC3300¿¡¼­´Â ¿¹ºñÀü¿ø¹öư -> ¼³ºñÀüü¿¬µ¿Á¶ÀÛ¹öư // sql += "OR EVENT_TYPE = 'FR' ";//È­À纹±¸¹öư // sql += "OR EVENT_TYPE = 'EC' ";//¼³ºñ¿¬µ¿È­¸é¹öư // sql += "OR EVENT_TYPE = 'PO' ";//Åë½Å(POLLING) ½ÃÀÛ // sql += "OR EVENT_TYPE = 'PF' ";//Åë½Å(POLLING) Á¾·á // sql += "OR EVENT_TYPE = 'CC' ";//Åë½Å»óÅÂÀбâ // sql += "OR EVENT_TYPE = 'CV' ";//Àü¾Ð»óÅÂÀбâ // sql += "OR EVENT_TYPE = 'V2' ";//24 Àü¾Ð º¯°æ // sql += "OR EVENT_TYPE = 'DC' ";//¼³ºñÀÛµ¿Â÷´Ü // sql += "OR EVENT_TYPE = 'CS' ";//ȯ°æ¼³Á¤ // sql += "OR EVENT_TYPE = 'TK' ";//ŰÆÐµåÅ×½ºÆ® // sql += "OR EVENT_TYPE = 'VI' ";//Åë½ÅÇÁ·Î±×·¥¹öÀüÁ¤º¸ // sql += "OR EVENT_TYPE = 'BF' ";//ºÎÀúÁ¤Áö // sql += "OR EVENT_TYPE = 'EL' ";//À̺¥Æ®¸®½ºÆ® // sql += "OR EVENT_TYPE = 'BS' ";//º¸µå»óÅ // sql += "OR EVENT_TYPE = 'RA' ";//È­ÀçÃàÀû»óÅ Àç¼³Á¤ // sql += "OR EVENT_TYPE = 'OU' ";//UIÇÁ·Î±×·¥½ÃÀÛ // sql += "OR EVENT_TYPE = 'XU' ";//UIÇÁ·Î±×·¥Á¾·á // sql += "OR EVENT_TYPE = 'DS' ";//¼³ºñÀÛµ¿»óÅÂÁ¶È¸ // } // if (boardError) // { // if (fireOn || devOn || controlLog) // { // sql += "OR "; // } // else // { // sql += "AND ( "; // } // sql += "EVENT_TYPE = 'XM' "; //Åë½Å¸ðµâ Åë½ÅÀÌ»ó // sql += "OR EVENT_TYPE = 'XI' ";//I/O ¸ðµâ Åë½ÅÀÌ»ó // sql += "OR EVENT_TYPE = 'XK' ";//ŰÆÐµå¸ðµâ Åë½ÅÀÌ»ó // sql += "OR EVENT_TYPE = 'AV' ";//Ãâ·ÂÀü¾Ð ÀÌ»ó // sql += "OR EVENT_TYPE = 'AR' ";//¿¹ºñÀü¿ø ÀÌ»ó // sql += "OR EVENT_TYPE = 'AA' ";//±³·ùÀü¿ø ÀÌ»ó // sql += "OR EVENT_TYPE = 'OD' ";//µ¥¸ó¿¬°áÀÌ»ó//////////////////////////////////////// // sql += "OR EVENT_TYPE = 'OB' ";//DB¿¬°áÀÌ»ó // sql += "OR EVENT_TYPE = 'BA' ";//Åë½Åº¸µå·çÇÁ±³·ùÀü¿øÀÌ»ó // sql += "OR EVENT_TYPE = 'BR' ";//Åë½Åº¸µå·çÇÁ¿¹ºñÀü¿øÀÌ»ó // sql += "OR EVENT_TYPE = 'XC' ";//ºñ»ó¹æ¼Û Åë½ÅÀÌ»ó // sql += "OR EVENT_TYPE = 'OM' ";//Åë½Å¸ðµâ Åë½ÅÁ¤»ó // sql += "OR EVENT_TYPE = 'OI' ";//I/O ¸ðµâ Åë½ÅÁ¤»ó // sql += "OR EVENT_TYPE = 'OK' ";//ŰÆÐµå¸ðµâ Åë½ÅÁ¤»ó // sql += "OR EVENT_TYPE = 'NV' ";//Ãâ·ÂÀü¾Ð Á¤»ó // sql += "OR EVENT_TYPE = 'NR' ";//¿¹ºñÀü¿ø Á¤»ó // sql += "OR EVENT_TYPE = 'NA' ";//±³·ùÀü¿ø Á¤»ó // sql += "OR EVENT_TYPE = 'XD' ";//µ¥¸ó¿¬°áÁ¤»ó//////////////////////////////////////// // sql += "OR EVENT_TYPE = 'XB' ";//DB¿¬°áÁ¤»ó // sql += "OR EVENT_TYPE = 'BN' ";//Åë½Åº¸µå·çÇÁÁ¤»ó // sql += "OR EVENT_TYPE = 'OC' ";//ºñ»ó¹æ¼Û Åë½ÅÁ¤»ó // } // if (repeaterError) // { // if (fireOn || devOn || controlLog || boardError) // { // sql += "OR "; // } // else // { // sql += "AND ( "; // } // sql += " EVENT_TYPE = 'XR' ";//Áß°è±â Åë½ÅÀÌ»ó // sql += "OR EVENT_TYPE = 'OR' ";//Áß°è±â Åë½ÅÁ¤»ó // sql += "OR EVENT_TYPE = 'OX' ";//Áß°è±âÀü¿øÀÌ»ó // sql += "OR EVENT_TYPE = 'XX' ";//Áß°è±âÀü¿øÀÌ»ó ÇØÁ¦ // } // if (devError) // { // if (fireOn || devOn || controlLog || boardError || repeaterError) // { // sql += "OR "; // } // else // { // sql += "AND ( "; // } // sql += " EVENT_TYPE = 'OL' ";//Áß°è±â ´Ü¼±¹ß»ý // sql += "OR EVENT_TYPE = 'XL' ";//Áß°è±â ´Ü¼±º¹±¸ // } // sql += " ) "; // } // return sql; //} public string CreateSQLCount() { string sql = "SELECT "; sql += SqlCount(); sql += SqlLocation(); if (this.eventTypeDetail) { sql += SqlEventTypeDetail(); } else { sql += SqlEventType(); } sql += SqlTime(); //Util.UDebugMessage("LOG SQL : " + sql, 0, 0); return sql; } // cyim 2013.9.17 µ¥ÀÌŸº£À̽º Á¶È¸ ÄÁ¼Áº¯°æ : 50000->30000 public string CreateSQL() { string sql = "SELECT FIRST 30000 "; sql += SqlIndex(); sql += SqlBase(); sql += SqlLocation(); if (this.eventTypeDetail) { sql += SqlEventTypeDetail(); } else { sql += SqlEventType(); } sql += SqlTime(); sql += "ORDER BY EVENT_TIME DESC "; //Util.UDebugMessage("LOG SQL : " + sql, 0, 0); return sql; } // cyim 2013.9.17 µ¥ÀÌŸº£À̽º Á¶È¸ ÄÁ¼Áº¯°æ : °¡Á®¿Ã °³¼ö¸¦ ÁöÁ¤ public string CreateSQL(int FirstCount) { if (FirstCount == 0) return null; string sql = "SELECT FIRST " + FirstCount.ToString() + " "; sql += SqlIndex(); sql += SqlBase(); sql += SqlLocation(); if (this.eventTypeDetail) { sql += SqlEventTypeDetail(); } else { sql += SqlEventType(); } sql += SqlTime(); sql += "ORDER BY EVENT_TIME DESC "; //Util.UDebugMessage("LOG SQL : " + sql, 0, 0); return sql; } // cyim 2013.10.10 : 1000°Ç Á¶È¸ ¼Óµµ °³¼± ÀÛ¾÷ public string CreateSQL(int FirstCount, DateTime StartTime, DateTime EndTime) { if (FirstCount == 0) return null; string sql = "SELECT FIRST " + FirstCount.ToString() + " "; sql += SqlIndex(); sql += SqlBase(); sql += SqlLocation(); if (this.eventTypeDetail) { sql += SqlEventTypeDetail(); } else { sql += SqlEventType(); } // cyim 2013.10.10 : 1000°Ç Á¶È¸ ¼Óµµ °³¼± ÀÛ¾÷ sql += SqlTime(StartTime, EndTime); sql += "ORDER BY EVENT_TIME DESC "; //Util.UDebugMessage("LOG SQL : " + sql, 0, 0); return sql; } // cyim 2013.9.17 µ¥ÀÌŸº£À̽º Á¶È¸ ÄÁ¼Áº¯°æ : °¡Á®¿Ã µ¥ÀÌŸ °³¼ö¸¦ ¹Ì¸® Á¶È¸ public string Get_EventLogDB_Count(DateTime StartTime, DateTime EndTime) { string sql = "SELECT COUNT(*) "; sql += SqlIndex(); //sql += SqlBase(); sql += "FROM TB_EVENT_LOG "; sql += "WHERE RECEIVER_ID > 0 "; sql += SqlLocation(); if (this.eventTypeDetail) { sql += SqlEventTypeDetail(); } else { sql += SqlEventType(); } // cyim 2013.10.10 : 1000°Ç Á¶È¸ ¼Óµµ °³¼± ÀÛ¾÷ sql += SqlTime(StartTime, EndTime); return sql; } //public string Get_COMMANDLogDB_Count(DateTime StartTime, DateTime EndTime) //{ // string sql = "SELECT COUNT(*) "; // sql += SqlIndex(); // //sql += SqlBase(); // sql += "FROM TB_COMMAND_LOG "; // sql += "WHERE RECEIVER_ID > 0 "; // sql += SqlLocation(); // if (this.eventTypeDetail) // { // sql += SqlCOMMANDTypeDetail(); // } // //else // //{ // // sql += SqlCOMMANDType(); // //} // // cyim 2013.10.10 : 1000°Ç Á¶È¸ ¼Óµµ °³¼± ÀÛ¾÷ // sql += COMMANDSqlTime(StartTime, EndTime); // return sql; //} } }