_ExternalInitial.cs 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Collections;
  4. using System.Text;
  5. using System.Data;
  6. using System.Windows.Forms;
  7. namespace FPER
  8. {
  9. public class _ExternalInitial
  10. {
  11. // 초기화 작업 중 특별처리 부분만 정리함
  12. public void Setup(int ReceiverID)
  13. {
  14. //
  15. // cyim 2016.12.06 : 강제쿼리 - 추가로 필요한 데이타베이스 정리
  16. //
  17. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "EW", ReceiverID) == false)
  18. {
  19. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  20. 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");
  21. DB_Query.ExecuteNonQuery(sql);
  22. }
  23. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "EF", ReceiverID) == false)
  24. {
  25. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  26. 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");
  27. DB_Query.ExecuteNonQuery(sql);
  28. }
  29. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "ED", ReceiverID) == false) // cyim 2016.12.09 : IFC3300에서는 예비전원버튼 -> 설비전체연동조작버튼
  30. {
  31. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  32. 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");
  33. DB_Query.ExecuteNonQuery(sql);
  34. }
  35. // cyim 2017.02.14 : 강제쿼리
  36. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "A1", ReceiverID) == false)
  37. {
  38. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  39. 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");
  40. DB_Query.ExecuteNonQuery(sql);
  41. }
  42. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "A2", ReceiverID) == false)
  43. {
  44. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  45. 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");
  46. DB_Query.ExecuteNonQuery(sql);
  47. }
  48. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "A3", ReceiverID) == false)
  49. {
  50. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  51. 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");
  52. DB_Query.ExecuteNonQuery(sql);
  53. }
  54. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "A4", ReceiverID) == false)
  55. {
  56. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  57. 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");
  58. DB_Query.ExecuteNonQuery(sql);
  59. }
  60. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "A5", ReceiverID) == false)
  61. {
  62. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  63. 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");
  64. DB_Query.ExecuteNonQuery(sql);
  65. }
  66. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "A6", ReceiverID) == false)
  67. {
  68. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  69. 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");
  70. DB_Query.ExecuteNonQuery(sql);
  71. }
  72. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "PA", ReceiverID) == false)
  73. {
  74. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  75. 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");
  76. DB_Query.ExecuteNonQuery(sql);
  77. }
  78. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "PB", ReceiverID) == false)
  79. {
  80. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  81. 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");
  82. DB_Query.ExecuteNonQuery(sql);
  83. }
  84. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "PC", ReceiverID) == false)
  85. {
  86. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  87. 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");
  88. DB_Query.ExecuteNonQuery(sql);
  89. }
  90. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "PD", ReceiverID) == false)
  91. {
  92. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  93. 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");
  94. DB_Query.ExecuteNonQuery(sql);
  95. }
  96. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "SA", ReceiverID) == false)
  97. {
  98. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  99. 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");
  100. DB_Query.ExecuteNonQuery(sql);
  101. }
  102. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "SB", ReceiverID) == false)
  103. {
  104. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  105. 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");
  106. DB_Query.ExecuteNonQuery(sql);
  107. }
  108. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "SC", ReceiverID) == false)
  109. {
  110. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  111. 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");
  112. DB_Query.ExecuteNonQuery(sql);
  113. }
  114. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "SD", ReceiverID) == false)
  115. {
  116. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  117. 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");
  118. DB_Query.ExecuteNonQuery(sql);
  119. }
  120. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "O3", ReceiverID) == false)
  121. {
  122. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  123. 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");
  124. DB_Query.ExecuteNonQuery(sql);
  125. }
  126. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "O4", ReceiverID) == false)
  127. {
  128. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  129. 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");
  130. DB_Query.ExecuteNonQuery(sql);
  131. }
  132. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "O5", ReceiverID) == false)
  133. {
  134. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  135. 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");
  136. DB_Query.ExecuteNonQuery(sql);
  137. }
  138. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "O6", ReceiverID) == false)
  139. {
  140. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  141. 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");
  142. DB_Query.ExecuteNonQuery(sql);
  143. }
  144. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "AO", ReceiverID) == false)
  145. {
  146. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  147. 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");
  148. DB_Query.ExecuteNonQuery(sql);
  149. }
  150. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "AF", ReceiverID) == false)
  151. {
  152. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  153. 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");
  154. DB_Query.ExecuteNonQuery(sql);
  155. }
  156. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "HM", ReceiverID) == false)
  157. {
  158. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  159. 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");
  160. DB_Query.ExecuteNonQuery(sql);
  161. }
  162. if (Data_Check("TB_EVENT_TYPE", "EVENT_TYPE", "RM", ReceiverID) == false)
  163. {
  164. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  165. 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");
  166. DB_Query.ExecuteNonQuery(sql);
  167. }
  168. if (Column_Check("LOOP2_USE_FLAG", "TB_BOARD", ReceiverID) == false) DB_Excute("ALTER TABLE TB_BOARD ADD LOOP2_USE_FLAG VARCHAR(1)", ReceiverID);
  169. if (Column_Check("LOOP3_USE_FLAG", "TB_BOARD", ReceiverID) == false) DB_Excute("ALTER TABLE TB_BOARD ADD LOOP3_USE_FLAG VARCHAR(1)", ReceiverID);
  170. if (Column_Check("LOOP2_BAUD_RATE", "TB_BOARD", ReceiverID) == false) DB_Excute("ALTER TABLE TB_BOARD ADD LOOP2_BAUD_RATE VARCHAR(1)", ReceiverID);
  171. if (Column_Check("LOOP3_BAUD_RATE", "TB_BOARD", ReceiverID) == false) DB_Excute("ALTER TABLE TB_BOARD ADD LOOP3_BAUD_RATE VARCHAR(1)", ReceiverID);
  172. if (Column_Check("LOOP2_CUT_FLAG", "TB_BOARD", ReceiverID) == false) DB_Excute("ALTER TABLE TB_BOARD ADD LOOP2_CUT_FLAG VARCHAR(1)", ReceiverID);
  173. if (Column_Check("LOOP3_CUT_FLAG", "TB_BOARD", ReceiverID) == false) DB_Excute("ALTER TABLE TB_BOARD ADD LOOP3_CUT_FLAG VARCHAR(1)", ReceiverID);
  174. if (Column_Check("MODEL", "TB_RECEIVER", ReceiverID) == false) DB_Excute("ALTER TABLE TB_RECEIVER ADD MODEL VARCHAR(20)", ReceiverID);
  175. }
  176. // cyim 2016.12.06 : 강제쿼리
  177. public bool Column_Check(string ColumnName, string TableName, int ReceiverID)
  178. {
  179. try
  180. {
  181. string SQL = string.Format("SELECT Count({0}) FROM {1} WHERE RECEIVER_ID = '{2}'", ColumnName, TableName, ReceiverID);
  182. DacUIProcess dacUIProcess = new DacUIProcess(ReceiverID);// cyim 2015.7.30 데이타베이스 접속 루틴 변경
  183. dacUIProcess.ExecuteNonQuery(SQL);
  184. return true;
  185. }
  186. catch
  187. {
  188. return false;
  189. }
  190. }
  191. public bool Data_Check(string TableName, string ColumnName, string Value, int ReceiverID)
  192. {
  193. try
  194. {
  195. string SQL = string.Format("SELECT * FROM {0} WHERE {1}='{2}'", TableName, ColumnName, Value);
  196. DacUIProcess dacUIProcess = new DacUIProcess(ReceiverID);// cyim 2015.7.30 데이타베이스 접속 루틴 변경
  197. DataSet dao = dacUIProcess.Select(SQL);
  198. DataTable dt = dao.Tables[0];
  199. if (dt.Rows.Count > 0) return true;
  200. else return false;
  201. }
  202. catch
  203. {
  204. return false;
  205. }
  206. }
  207. public void DB_Excute(string sql, int ReceiverID)
  208. {
  209. DacUIProcess DB_Query = new DacUIProcess(ReceiverID);
  210. DB_Query.ExecuteNonQuery(sql);
  211. }
  212. public string Data_Get(string TableName, string DataName, int ReceiverID)
  213. {
  214. try
  215. {
  216. string SQL = string.Format("SELECT {0} FROM {1} WHERE RECEIVER_ID = '{2}'", DataName, TableName, ReceiverID);
  217. DacUIProcess dacUIProcess = new DacUIProcess(ReceiverID);// cyim 2015.7.30 데이타베이스 접속 루틴 변경
  218. DataSet dao = dacUIProcess.Select(SQL);
  219. DataTable dt = dao.Tables[0];
  220. if (dt.Rows.Count != 0)
  221. {
  222. return ((DataRow)dt.Rows[0])[DataName].ToString();
  223. }
  224. else return null;
  225. }
  226. catch
  227. {
  228. return null;
  229. }
  230. }
  231. }
  232. }