274deb5bc00bc056b84ffdaf1cebddea758c0404.svn-base 7.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Text;
  4. using FirebirdSql.Data.FirebirdClient;
  5. using System.Data;
  6. using System.Collections;
  7. namespace IControls_FireManager
  8. {
  9. /*******************************************************************************************
  10. * TB_BOARD(IO보드) 설정 관련 Dac
  11. *******************************************************************************************/
  12. public class DacIOBoardConfig: DacBase
  13. {
  14. public DacIOBoardConfig()
  15. {
  16. //try {
  17. // base.Connect();
  18. //}
  19. //catch (Exception ex) {
  20. // Util.UErrorMessage(ex, 0, 0);
  21. //}
  22. }
  23. ~DacIOBoardConfig()
  24. {
  25. //try {
  26. // base.DisConnect();
  27. //}
  28. //catch (Exception ex) {
  29. // Util.UErrorMessage(ex, 0, 0);
  30. //}
  31. }
  32. // cyim 2016.09.21 : TB_BOARD 에 루프 0~3 저장 하도록 한다
  33. //public DataTable Board_Select(int RECEIVER_ID, int BOARD_ID, String UseFlag)
  34. //{
  35. // DataTable dt = null;
  36. // try
  37. // {
  38. // String SQL = "";
  39. // if (BOARD_ID == 0)
  40. // {
  41. // SQL += "SELECT BOARD_ID,BOARD_NAME,LOOP0_USE_FLAG,LOOP1_USE_FLAG,LOOP2_USE_FLAG,LOOP3_USE_FLAG,USE_FLAG";
  42. // SQL += " ,MAIN_VERSION,SUB_VERSION,BAUD_RATE,LOOP0_BAUD_RATE,LOOP1_BAUD_RATE,LOOP2_BAUD_RATE,LOOP3_BAUD_RATE";
  43. // SQL += " ,LOOP0_CUT_FLAG,LOOP1_CUT_FLAG,LOOP2_CUT_FLAG,LOOP3_CUT_FLAG ";
  44. // SQL += " FROM TB_BOARD WHERE RECEIVER_ID = {0} AND COMM_ID = 3 ";
  45. // if (UseFlag != null) SQL += " AND USE_FLAG = '" + UseFlag + "'";
  46. // SQL += " ORDER BY BOARD_ID";
  47. // SQL = String.Format(SQL, RECEIVER_ID);
  48. // }
  49. // else
  50. // {
  51. // SQL += "SELECT BOARD_ID,BOARD_NAME,LOOP0_USE_FLAG,LOOP1_USE_FLAG,LOOP2_USE_FLAG,LOOP3_USE_FLAG,USE_FLAG";
  52. // SQL += " ,MAIN_VERSION,SUB_VERSION,BAUD_RATE,LOOP0_BAUD_RATE,LOOP1_BAUD_RATE,LOOP2_BAUD_RATE,LOOP3_BAUD_RATE";
  53. // SQL += " ,LOOP0_CUT_FLAG,LOOP1_CUT_FLAG,LOOP2_CUT_FLAG,LOOP3_CUT_FLAG ";
  54. // SQL += " FROM TB_BOARD WHERE RECEIVER_ID = {0} AND COMM_ID = 3 AND BOARD_ID = {1}";
  55. // if (UseFlag != null) SQL += " AND USE_FLAG = '" + UseFlag + "'";
  56. // SQL = String.Format(SQL, RECEIVER_ID, BOARD_ID);
  57. // }
  58. // DataSet dao = Select(SQL);
  59. // dt = dao.Tables[0];
  60. // }
  61. // catch (Exception ex)
  62. // {
  63. // Util.UErrorMessage(ex,0,0);
  64. // throw ex;
  65. // }
  66. // return dt;
  67. //}
  68. //통신보드 ID 최고값 리턴
  69. //public int BoardID_Max(int RECEIVER_ID)
  70. //{
  71. // int BoardId = 0;
  72. // try
  73. // {
  74. // //BOARD_ID:0은 기본 사용이므로 추가삭제 할 수 없다..
  75. // String SQL = String.Format("SELECT MAX(BOARD_ID) FROM TB_BOARD WHERE RECEIVER_ID = {0} AND COMM_ID = 3 AND BOARD_ID <> 0", RECEIVER_ID);
  76. // DataSet dao = Select(SQL);
  77. // DataTable dt = dao.Tables[0];
  78. // if (dt.Rows.Count > 0)
  79. // {
  80. // foreach (DataRow dr in dt.Rows)
  81. // {
  82. // if (!dr[0].ToString().Equals(""))
  83. // BoardId = int.Parse(dr[0].ToString());
  84. // }
  85. // }
  86. // }
  87. // catch (Exception ex)
  88. // {
  89. // Util.UErrorMessage(ex,0,0);
  90. // throw ex;
  91. // }
  92. // return ++BoardId;
  93. //}
  94. // cyim 2016.09.21 : TB_BOARD 에 루프 0~3 저장 하도록 한다
  95. //public void Board_Update(QUERYMode cmd, int RECEIVER_ID, int BOARD_ID, String BOARD_NAME, String USE_FLAG
  96. // , String LOOP0_USE_FLAG, String LOOP1_USE_FLAG, String LOOP2_USE_FLAG, String LOOP3_USE_FLAG, int BAUD_RATE, int LOOP0_BAUD_RATE, int LOOP1_BAUD_RATE, int LOOP2_BAUD_RATE, int LOOP3_BAUD_RATE
  97. // , int MAIN_VERSION, int SUB_VERSION)
  98. //{
  99. // try
  100. // {
  101. // DataTable dt = Board_Select(RECEIVER_ID, BOARD_ID, null);
  102. // if (cmd == QUERYMode.insert || cmd == QUERYMode.update || cmd == QUERYMode.InsertAndUpdate)
  103. // {
  104. // String SQL = "";
  105. // if (dt.Rows.Count > 0)
  106. // {
  107. // SQL = "UPDATE TB_BOARD SET BOARD_NAME = '{0}'";
  108. // SQL += ", USE_FLAG = '{1}'";
  109. // SQL += ", LOOP0_USE_FLAG = '{2}', LOOP1_USE_FLAG = '{3}'";
  110. // SQL += ", LOOP2_USE_FLAG = '{2}', LOOP3_USE_FLAG = '{3}'";
  111. // SQL += ", BAUD_RATE = {4}, LOOP0_BAUD_RATE = {5}";
  112. // SQL += ", LOOP1_BAUD_RATE = {6}";
  113. // SQL += ", LOOP2_BAUD_RATE = {6}";
  114. // SQL += ", LOOP3_BAUD_RATE = {6}";
  115. // SQL += ", MAIN_VERSION = {7}, SUB_VERSION = {8}";
  116. // SQL += ", UPDATE_USER_ID = 'FPER', UPDATE_TIME = current_timestamp";
  117. // SQL += " WHERE RECEIVER_ID = {9} AND COMM_ID = 3 AND BOARD_ID = {10}";
  118. // SQL = String.Format(SQL, BOARD_NAME, USE_FLAG, LOOP0_USE_FLAG, LOOP1_USE_FLAG, LOOP2_USE_FLAG, LOOP3_USE_FLAG
  119. // , BAUD_RATE, LOOP0_BAUD_RATE, LOOP1_BAUD_RATE, LOOP2_BAUD_RATE, LOOP3_BAUD_RATE, MAIN_VERSION, SUB_VERSION
  120. // , RECEIVER_ID, BOARD_ID);
  121. // }
  122. // else
  123. // {
  124. // SQL = "INSERT INTO TB_BOARD ( ";
  125. // SQL += " RECEIVER_ID,COMM_ID,BOARD_ID,BOARD_NAME,LOOP0_USE_FLAG,LOOP1_USE_FLAG,LOOP2_USE_FLAG,LOOP3_USE_FLAG";
  126. // SQL += ",BAUD_RATE,LOOP0_BAUD_RATE,LOOP1_BAUD_RATE,LOOP2_BAUD_RATE,LOOP3_BAUD_RATE,MAIN_VERSION,SUB_VERSION";
  127. // SQL += ",USE_FLAG,UPDATE_USER_ID,UPDATE_TIME";
  128. // SQL += ") VALUES ({0},3,{1},'{2}','{3}','{4}',{5},{6},{7},{8},{9},'{10}','FPER',current_timestamp)";
  129. // SQL = String.Format(SQL, RECEIVER_ID, BOARD_ID, BOARD_NAME, LOOP0_USE_FLAG, LOOP1_USE_FLAG, LOOP2_USE_FLAG, LOOP3_USE_FLAG
  130. // , BAUD_RATE, LOOP0_BAUD_RATE, LOOP1_BAUD_RATE, LOOP2_BAUD_RATE, LOOP3_BAUD_RATE, MAIN_VERSION, SUB_VERSION
  131. // , USE_FLAG);
  132. // }
  133. // ExecuteNonQuery(SQL);
  134. // }
  135. // else if (cmd == QUERYMode.delete)
  136. // {
  137. // if (dt.Rows.Count < 1)
  138. // {
  139. // throw new Exception("해당 자료를 찾을수 없습니다.");
  140. // }
  141. // String SQL = "UPDATE TB_BOARD SET USE_FLAG = 'N' ";
  142. // SQL += ", UPDATE_USER_ID = 'FPER', UPDATE_TIME = current_timestamp";
  143. // SQL += " WHERE RECEIVER_ID = {0} AND COMM_ID = 3 AND BOARD_ID = {1}";
  144. // SQL = String.Format(SQL, RECEIVER_ID, BOARD_ID);
  145. // ExecuteNonQuery(SQL);
  146. // }
  147. // }
  148. // catch (Exception ex)
  149. // {
  150. // Util.UErrorMessage(ex,0,0);
  151. // throw ex;
  152. // }
  153. //}
  154. }
  155. }