33f12a4f23088ccc050095d94cb101b4410c1f39.svn-base 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383
  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(통신보드) 설정 관련 Dac
  11. *******************************************************************************************/
  12. public class DacBoardConfig: DacBase
  13. {
  14. public DacBoardConfig()
  15. {
  16. //try {
  17. // base.Connect();
  18. //}
  19. //catch (Exception ex) {
  20. // Util.UErrorMessage(ex, 0, 0);
  21. //}
  22. }
  23. ~DacBoardConfig()
  24. {
  25. //try {
  26. // base.DisConnect();
  27. //}
  28. //catch (Exception ex) {
  29. // Util.UErrorMessage(ex, 0, 0);
  30. //}
  31. }
  32. // RECEIVER_ID INTEGER NOT NULL, /* RECEIVER ID (1 - 32) */
  33. //COMM_ID INTEGER NOT NULL, /* COMM ID (1 - 4) */
  34. //BOARD_ID INTEGER NOT NULL, /* BOARD ID (1 - 16) */
  35. //BOARD_NAME VARCHAR(40), /* BOARD NAME */
  36. //USE_FLAG VARCHAR(1), /* USE FLAG (Y/N) */
  37. //UPDATE_USER_ID VARCHAR(10), /* UPDATE USER ID */
  38. //UPDATE_TIME TIMESTAMP, /* UPDATE TIME */
  39. //// cyim 2016.09.21 : TB_BOARD 에 루프 0~3 저장 하도록 한다
  40. //public DataTable SelectBoard_BigReceiver(int RECEIVER_ID)
  41. //{
  42. // DataTable dt = null;
  43. // try
  44. // {
  45. // String SQL = "";
  46. // SQL += "SELECT BOARD_ID,BOARD_NAME,LOOP0_USE_FLAG,LOOP1_USE_FLAG,LOOP2_USE_FLAG,LOOP3_USE_FLAG,USE_FLAG";
  47. // SQL += " ,MAIN_VERSION,SUB_VERSION,BAUD_RATE,LOOP0_BAUD_RATE,LOOP1_BAUD_RATE,LOOP2_BAUD_RATE,LOOP3_BAUD_RATE";
  48. // SQL += " ,LOOP0_CUT_FLAG,LOOP1_CUT_FLAG,LOOP2_CUT_FLAG,LOOP3_CUT_FLAG ,COMM_ID";
  49. // SQL += " FROM TB_BOARD WHERE RECEIVER_ID = {0} ";
  50. // SQL += " ORDER BY BOARD_ID";
  51. // SQL = String.Format(SQL, RECEIVER_ID);
  52. // DataSet dao = Select(SQL);
  53. // dt = dao.Tables[0];
  54. // }
  55. // catch (Exception ex)
  56. // {
  57. // Util.UErrorMessage(ex, 0, 0);
  58. // throw ex;
  59. // }
  60. // return dt;
  61. //}
  62. //public DataTable Board_Select(int RECEIVER_ID, int BOARD_ID, String UseFlag)
  63. //{
  64. // DataTable dt = null;
  65. // try
  66. // {
  67. // String SQL = "";
  68. // if (BOARD_ID == 0)
  69. // {
  70. // SQL += "SELECT BOARD_ID,BOARD_NAME,LOOP0_USE_FLAG,LOOP1_USE_FLAG,USE_FLAG";
  71. // SQL += " ,MAIN_VERSION,SUB_VERSION,BAUD_RATE,LOOP0_BAUD_RATE,LOOP1_BAUD_RATE";
  72. // SQL += " ,LOOP0_CUT_FLAG,LOOP1_CUT_FLAG ";
  73. // SQL += " FROM TB_BOARD WHERE RECEIVER_ID = {0} AND COMM_ID = 1 ";
  74. // if (UseFlag != null) SQL += " AND USE_FLAG = '" + UseFlag + "'";
  75. // SQL += " ORDER BY BOARD_ID";
  76. // SQL = String.Format(SQL, RECEIVER_ID);
  77. // }
  78. // else
  79. // {
  80. // SQL += "SELECT BOARD_ID,BOARD_NAME,LOOP0_USE_FLAG,LOOP1_USE_FLAG,USE_FLAG";
  81. // SQL += " ,MAIN_VERSION,SUB_VERSION,BAUD_RATE,LOOP0_BAUD_RATE,LOOP1_BAUD_RATE";
  82. // SQL += " ,LOOP0_CUT_FLAG,LOOP1_CUT_FLAG ";
  83. // SQL += " FROM TB_BOARD WHERE RECEIVER_ID = {0} AND COMM_ID = 1 AND BOARD_ID = {1}";
  84. // if (UseFlag != null) SQL += " AND USE_FLAG = '" + UseFlag + "'";
  85. // SQL = String.Format(SQL, RECEIVER_ID, BOARD_ID);
  86. // }
  87. // DataSet dao = Select(SQL);
  88. // dt = dao.Tables[0];
  89. // }
  90. // catch (Exception ex)
  91. // {
  92. // Util.UErrorMessage(ex,0,0);
  93. // throw ex;
  94. // }
  95. // return dt;
  96. //}
  97. // cyim 2016.09.21 : TB_BOARD 에 루프 0~3 저장 하도록 한다 // cyim 2016.12.05 : 수신기 모델별 내부 로직 변경
  98. public DataTable Board_Select_BigReceiver(int RECEIVER_ID, int BOARD_ID, String UseFlag)
  99. {
  100. DataTable dt = null;
  101. try
  102. {
  103. String SQL = "";
  104. if (BOARD_ID == 0)
  105. {
  106. SQL += "SELECT BOARD_ID,BOARD_NAME,LOOP0_USE_FLAG,LOOP1_USE_FLAG,LOOP2_USE_FLAG,LOOP3_USE_FLAG,USE_FLAG";
  107. SQL += " ,MAIN_VERSION,SUB_VERSION,BAUD_RATE,LOOP0_BAUD_RATE,LOOP1_BAUD_RATE,LOOP2_BAUD_RATE,LOOP3_BAUD_RATE";
  108. SQL += " ,LOOP0_CUT_FLAG,LOOP1_CUT_FLAG,LOOP2_CUT_FLAG,LOOP3_CUT_FLAG ";
  109. SQL += " FROM TB_BOARD WHERE RECEIVER_ID = {0} AND COMM_ID = 1 ";
  110. if (UseFlag != null) SQL += " AND USE_FLAG = '" + UseFlag + "'";
  111. SQL += " ORDER BY BOARD_ID";
  112. SQL = String.Format(SQL, RECEIVER_ID);
  113. }
  114. else
  115. {
  116. SQL += "SELECT BOARD_ID,BOARD_NAME,LOOP0_USE_FLAG,LOOP1_USE_FLAG,LOOP2_USE_FLAG,LOOP3_USE_FLAG,USE_FLAG";
  117. SQL += " ,MAIN_VERSION,SUB_VERSION,BAUD_RATE,LOOP0_BAUD_RATE,LOOP1_BAUD_RATE,LOOP2_BAUD_RATE,LOOP3_BAUD_RATE";
  118. SQL += " ,LOOP0_CUT_FLAG,LOOP1_CUT_FLAG,LOOP2_CUT_FLAG,LOOP3_CUT_FLAG ";
  119. SQL += " FROM TB_BOARD WHERE RECEIVER_ID = {0} AND COMM_ID = 1 AND BOARD_ID = {1}";
  120. if (UseFlag != null) SQL += " AND USE_FLAG = '" + UseFlag + "'";
  121. SQL = String.Format(SQL, RECEIVER_ID, BOARD_ID);
  122. }
  123. DataSet dao = Select(SQL);
  124. dt = dao.Tables[0];
  125. }
  126. catch (Exception ex)
  127. {
  128. Util.UErrorMessage(ex,0,0);
  129. throw ex;
  130. }
  131. return dt;
  132. }
  133. //통신보드 ID 최고값 리턴
  134. //public int BoardID_Max(int RECEIVER_ID)
  135. //{
  136. // int BoardId = 0;
  137. // try
  138. // {
  139. // String SQL = String.Format("SELECT MAX(BOARD_ID) FROM TB_BOARD WHERE RECEIVER_ID = {0} AND COMM_ID = 1", RECEIVER_ID);
  140. // DataSet dao = Select(SQL);
  141. // DataTable dt = dao.Tables[0];
  142. // if (dt.Rows.Count > 0)
  143. // {
  144. // foreach (DataRow dr in dt.Rows)
  145. // {
  146. // if (!dr[0].ToString().Equals(""))
  147. // BoardId = int.Parse(dr[0].ToString());
  148. // }
  149. // }
  150. // }
  151. // catch (Exception ex)
  152. // {
  153. // Util.UErrorMessage(ex,0,0);
  154. // throw ex;
  155. // }
  156. // return ++BoardId;
  157. //}
  158. //// cyim 2016.09.21 : TB_BOARD 에 루프 0~3 저장 하도록 한다
  159. //public void Board_Cut_Update_BigReceiver(int RECEIVER_ID, int BOARD_ID, String LOOP0_CUT_FLAG, String LOOP1_CUT_FLAG, String LOOP2_CUT_FLAG, String LOOP3_CUT_FLAG)
  160. //{
  161. // try
  162. // {
  163. // DataTable dt = null;
  164. // // cyim 2016.12.05 : 수신기 모델별 내부 로직 변경
  165. // if (((_RECEIVER)_Data.HASH_RECEIVER[RECEIVER_ID]).MODEL == "IFC3300")
  166. // {
  167. // dt = Board_Select_BigReceiver(RECEIVER_ID, BOARD_ID, null);
  168. // }
  169. // else
  170. // {
  171. // }
  172. // String SQL = "";
  173. // if (dt.Rows.Count > 0)
  174. // {
  175. // SQL = "UPDATE TB_BOARD SET LOOP0_CUT_FLAG = '{0}'";
  176. // SQL += ", LOOP1_CUT_FLAG = '{1}'";
  177. // SQL += ", LOOP2_CUT_FLAG = '{2}'";
  178. // SQL += ", LOOP3_CUT_FLAG = '{3}'";
  179. // SQL += ", UPDATE_USER_ID = 'FPER', UPDATE_TIME = current_timestamp";
  180. // SQL += " WHERE RECEIVER_ID = {4} AND COMM_ID = 1 AND BOARD_ID = {5}";
  181. // SQL = String.Format(SQL, LOOP0_CUT_FLAG, LOOP1_CUT_FLAG, LOOP2_CUT_FLAG, LOOP3_CUT_FLAG, RECEIVER_ID, BOARD_ID);
  182. // ExecuteNonQuery(SQL);
  183. // }
  184. // else
  185. // {
  186. // throw new Exception("해당 자료를 찾을수 없습니다.");
  187. // }
  188. // }
  189. // catch (Exception ex)
  190. // {
  191. // Util.UErrorMessage(ex,0,0);
  192. // throw ex;
  193. // }
  194. //}
  195. //// cyim 2016.09.21 : TB_BOARD 에 루프 0~3 저장 하도록 한다
  196. //public void Board_Update_BigReceiver(QUERYMode cmd, int RECEIVER_ID, int BOARD_ID, String BOARD_NAME, String USE_FLAG
  197. // , String LOOP0_USE_FLAG, String LOOP1_USE_FLAG, String LOOP2_USE_FLAG, String LOOP3_USE_FLAG, int BAUD_RATE
  198. // , int LOOP0_BAUD_RATE, int LOOP1_BAUD_RATE, int LOOP2_BAUD_RATE, int LOOP3_BAUD_RATE
  199. // , int MAIN_VERSION, int SUB_VERSION)
  200. //{
  201. // try
  202. // {
  203. // DataTable dt = null;
  204. // // cyim 2016.12.05 : 수신기 모델별 내부 로직 변경
  205. // if (((_RECEIVER)_Data.HASH_RECEIVER[RECEIVER_ID]).MODEL == "IFC3300")
  206. // {
  207. // dt = Board_Select_BigReceiver(RECEIVER_ID, BOARD_ID, null);
  208. // }
  209. // else
  210. // {
  211. // }
  212. // if (cmd == QUERYMode.insert || cmd == QUERYMode.update || cmd == QUERYMode.InsertAndUpdate)
  213. // {
  214. // String SQL = "";
  215. // if (dt.Rows.Count > 0)
  216. // {
  217. // SQL = "UPDATE TB_BOARD SET BOARD_NAME = '{0}'";
  218. // SQL += ", USE_FLAG = '{1}'";
  219. // SQL += ", LOOP0_USE_FLAG = '{2}', LOOP1_USE_FLAG = '{3}'";
  220. // SQL += ", LOOP2_USE_FLAG = '{4}', LOOP3_USE_FLAG = '{5}'";
  221. // SQL += ", BAUD_RATE = {6}, LOOP0_BAUD_RATE = {7}";
  222. // SQL += ", LOOP1_BAUD_RATE = {8}";
  223. // SQL += ", LOOP1_BAUD_RATE = {9}";
  224. // SQL += ", LOOP1_BAUD_RATE = {10}";
  225. // SQL += ", MAIN_VERSION = {11}, SUB_VERSION = {12}";
  226. // SQL += ", UPDATE_USER_ID = 'FPER', UPDATE_TIME = current_timestamp";
  227. // SQL += " WHERE RECEIVER_ID = {13} AND COMM_ID = 1 AND BOARD_ID = {14}";
  228. // SQL = String.Format(SQL, BOARD_NAME, USE_FLAG, LOOP0_USE_FLAG, LOOP1_USE_FLAG, LOOP2_USE_FLAG, LOOP3_USE_FLAG
  229. // , BAUD_RATE, LOOP0_BAUD_RATE, LOOP1_BAUD_RATE, LOOP2_BAUD_RATE, LOOP3_BAUD_RATE, MAIN_VERSION, SUB_VERSION
  230. // , RECEIVER_ID, BOARD_ID);
  231. // }
  232. // else
  233. // {
  234. // SQL = "INSERT INTO TB_BOARD ( ";
  235. // SQL += " RECEIVER_ID,COMM_ID,BOARD_ID,BOARD_NAME,LOOP0_USE_FLAG,LOOP1_USE_FLAG,LOOP2_USE_FLAG,LOOP3_USE_FLAG";
  236. // SQL += ",BAUD_RATE,LOOP0_BAUD_RATE,LOOP1_BAUD_RATE,LOOP2_BAUD_RATE,LOOP3_BAUD_RATE,MAIN_VERSION,SUB_VERSION";
  237. // SQL += ",USE_FLAG,UPDATE_USER_ID,UPDATE_TIME";
  238. // SQL += ") VALUES ({0},1,{1},'{2}','{3}','{4}','{5}','{6}',{7},{8},{9},{10},{11},{12},{13},'{14}','FPER',current_timestamp)";
  239. // SQL = String.Format(SQL, RECEIVER_ID, BOARD_ID, BOARD_NAME, LOOP0_USE_FLAG, LOOP1_USE_FLAG, LOOP2_USE_FLAG, LOOP3_USE_FLAG
  240. // , BAUD_RATE, LOOP0_BAUD_RATE, LOOP1_BAUD_RATE, LOOP2_BAUD_RATE, LOOP3_BAUD_RATE, MAIN_VERSION, SUB_VERSION
  241. // , USE_FLAG);
  242. // }
  243. // ExecuteNonQuery(SQL);
  244. // }
  245. // else if (cmd == QUERYMode.delete)
  246. // {
  247. // if (dt.Rows.Count < 1)
  248. // {
  249. // throw new Exception("해당 자료를 찾을수 없습니다.");
  250. // }
  251. // String SQL = "UPDATE TB_BOARD SET USE_FLAG = 'N' ";
  252. // SQL += ", UPDATE_USER_ID = 'FPER', UPDATE_TIME = current_timestamp";
  253. // SQL += " WHERE RECEIVER_ID = {0} AND COMM_ID = 1 AND BOARD_ID = {1}";
  254. // SQL = String.Format(SQL, RECEIVER_ID, BOARD_ID);
  255. // ExecuteNonQuery(SQL);
  256. // }
  257. // }
  258. // catch (Exception ex)
  259. // {
  260. // Util.UErrorMessage(ex,0,0);
  261. // throw ex;
  262. // }
  263. //}
  264. //통신보드
  265. //public ArrayList Board_List_BigReceiver(int RECEIVER_ID)
  266. //{
  267. // ArrayList ary = null;
  268. // try
  269. // {
  270. // DataTable dt = null;
  271. // // cyim 2016.12.05 : 수신기 모델별 내부 로직 변경
  272. // if (((_RECEIVER)_Data.HASH_RECEIVER[RECEIVER_ID]).MODEL == "IFC3300")
  273. // {
  274. // dt = Board_Select_BigReceiver(RECEIVER_ID, 0, "Y");
  275. // }
  276. // else
  277. // {
  278. // }
  279. // if (dt.Rows.Count > 0)
  280. // {
  281. // ary = new ArrayList();
  282. // foreach (DataRow dr in dt.Rows)
  283. // {
  284. // String BOARD_ID = Convert.ToString(dr["BOARD_ID"]);
  285. // String BOARD_NAME = Convert.ToString(dr["BOARD_NAME"]);
  286. // }
  287. // }
  288. // }
  289. // catch (Exception ex)
  290. // {
  291. // Util.UErrorMessage(ex,0,0);
  292. // throw ex;
  293. // }
  294. // return ary;
  295. //}
  296. }
  297. }