DacFieldConfig.cs 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Text;
  4. using System.Data;
  5. namespace FPER
  6. {
  7. public class DacFieldConfig : DacBase
  8. {
  9. public DacFieldConfig(int ID)
  10. : base(ID)// cyim 2015.7.30 데이타베이스 접속 루틴 변경
  11. {
  12. //try {
  13. // base.Connect();
  14. //}
  15. //catch (Exception ex) {
  16. // Util.UErrorMessage(ex, 0, 0);
  17. //}
  18. }
  19. ~DacFieldConfig()
  20. {
  21. //try {
  22. // base.DisConnect();
  23. //}
  24. //catch (Exception ex) {
  25. // Util.UErrorMessage(ex, 0, 0);
  26. //}
  27. }
  28. /*
  29. public DataTable SelectMapView() {
  30. DataTable dt = null;
  31. try {
  32. String SQL = "";
  33. SQL += "SELECT SYMBOL_MAP_FILE,DEV_TYPE_FILE,FIELD_CONF_FILE";
  34. SQL += " FROM TB_MAPVIEW";
  35. DataSet dao = Select(SQL);
  36. dt = dao.Tables[0];
  37. }
  38. catch (Exception ex) {
  39. Util.UErrorMessage(ex, 0, 0);
  40. throw ex;
  41. }
  42. return dt;
  43. }
  44. */
  45. public bool SelectJumpField(int RECEIVER_ID)
  46. {
  47. bool ret = true;
  48. try
  49. {
  50. DataTable dt = null;
  51. String SQL = "";
  52. SQL += "SELECT JUMP_FIELD ";
  53. SQL += "FROM TB_CONFIG ";
  54. SQL += " WHERE RECEIVER_ID = '{0}'";
  55. SQL = String.Format(SQL, RECEIVER_ID);
  56. DataSet dao = Select(SQL);
  57. dt = dao.Tables[0];
  58. if (dt.Rows.Count > 0)
  59. {
  60. if (dt.Rows[0]["JUMP_FIELD"].ToString() == "Y")
  61. {
  62. ret = true;
  63. }
  64. else
  65. {
  66. ret = false;
  67. }
  68. }
  69. }
  70. catch (Exception ex)
  71. {
  72. Util.UErrorMessage(ex, 0, 0);
  73. //throw ex;
  74. }
  75. return ret;
  76. }
  77. public void UpdateJumpField(int RECEIVER_ID, bool Jump_Field)
  78. {
  79. try
  80. {
  81. String SQL = "UPDATE TB_CONFIG SET JUMP_FIELD = '{0}' ";
  82. SQL += ", UPDATE_USER_ID = 'FPER', UPDATE_TIME = current_timestamp";
  83. SQL += " WHERE RECEIVER_ID = {1}";
  84. SQL = String.Format(SQL, (Jump_Field ? "Y" : "N"), RECEIVER_ID);
  85. ExecuteNonQuery(SQL);
  86. //DataTable dt = Config_Select(RECEIVER_ID);
  87. //if (dt.Rows.Count == 0) {
  88. // String SQL = "INSERT INTO TB_CONFIG (RECEIVER_ID,FIRE_ACCUMULATION_MODE,FIRE_ACCUMULATION_TIME";
  89. // SQL += ",FIRE_PROCESS_MODE,SOUND_PROCESS_MODE,MASTER_USER_ID,MASTER_PASSWORD";
  90. // SQL += ",BUILDING_NAME,BACKGROUND_IMAGE,UPDATE_USER_ID,UPDATE_TIME)";
  91. // SQL += " VALUES ({0},'{1}',{2},'{3}','{4}','{5}','{6}','{7}','{8}','FPER',current_timestamp)";
  92. // SQL = String.Format(SQL, RECEIVER_ID, FIRE_ACCUMULATION_MODE, FIRE_ACCUMULATION_TIME
  93. // , FIRE_PROCESS_MODE, SOUND_PROCESS_MODE, MASTER_USER_ID, MASTER_PASSWORD, BUILDING_NAME, BACKGROUND_IMAGE);
  94. // ExecuteNonQuery(SQL);
  95. // //ExecuteNonQueryParam(SQL, BACKGROUND_IMAGE);
  96. //}
  97. //else {
  98. // String SQL = "UPDATE TB_CONFIG SET FIRE_ACCUMULATION_MODE = '{0}',FIRE_ACCUMULATION_TIME={1},FIRE_PROCESS_MODE='{2}' ";
  99. // SQL += ", SOUND_PROCESS_MODE = '{3}', MASTER_USER_ID = '{4}',MASTER_PASSWORD = '{5}'";
  100. // SQL += ", BUILDING_NAME = '{6}', BACKGROUND_IMAGE = '{7}'";
  101. // SQL += ", UPDATE_USER_ID = 'FPER', UPDATE_TIME = current_timestamp";
  102. // SQL += " WHERE RECEIVER_ID = {8}";
  103. // SQL = String.Format(SQL, FIRE_ACCUMULATION_MODE, FIRE_ACCUMULATION_TIME, FIRE_PROCESS_MODE
  104. // , SOUND_PROCESS_MODE, MASTER_USER_ID, MASTER_PASSWORD, BUILDING_NAME, BACKGROUND_IMAGE, RECEIVER_ID);
  105. // ExecuteNonQuery(SQL);
  106. // // ExecuteNonQueryParam(SQL, BACKGROUND_IMAGE);
  107. //}
  108. }
  109. catch (Exception ex)
  110. {
  111. Util.UErrorMessage(ex, 0, 0);
  112. //throw ex;
  113. }
  114. }
  115. }
  116. }