DacTableCopy.cs 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132
  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 FPER
  8. {
  9. class DacTableCopy : DacBase
  10. {
  11. public DacTableCopy(int ID)
  12. : base(ID) // cyim 2015.7.30 데이타베이스 접속 루틴 변경
  13. {
  14. //try {
  15. // base.Connect();
  16. //}
  17. //catch (Exception ex) {
  18. // Util.UErrorMessage(ex, 0, 0);
  19. //}
  20. }
  21. ~DacTableCopy()
  22. {
  23. //try {
  24. // base.DisConnect();
  25. //}
  26. //catch (Exception ex) {
  27. // Util.UErrorMessage(ex, 0, 0);
  28. //}
  29. }
  30. public Boolean TableCopy(string tableName)
  31. {
  32. string tableNameBackUp = "";
  33. string SQL = "";
  34. Boolean BackUpTableOk = false;
  35. try
  36. {
  37. tableName = tableName.ToUpper();
  38. tableNameBackUp = string.Format("{0}_BACKUP", tableName, DateTime.Now);
  39. switch (tableName)
  40. {
  41. case "TB_BOARD": BackUpTableOk = true; break;
  42. case "TB_DEVICE": BackUpTableOk = true; break;
  43. case "TB_DEVICE_TYPE": BackUpTableOk = true; break;
  44. case "TB_GROUP": BackUpTableOk = true; break;
  45. case "TB_GROUP_DEVICE": BackUpTableOk = true; break;
  46. case "TB_MAP": BackUpTableOk = true; break;
  47. case "TB_MAP_PROCESS": BackUpTableOk = true; break;
  48. case "TB_POSITION_CODE": BackUpTableOk = true; break;
  49. case "TB_REPEATER": BackUpTableOk = true; break;
  50. case "TB_CONFIG": break;
  51. case "TB_COMM": break;
  52. case "TB_RECEIVER": break;
  53. case "TB_COMMAND_LOG": break;
  54. case "TB_COMM_LOG": break;
  55. }
  56. if (BackUpTableOk)
  57. {
  58. SQL = string.Format("DELETE FROM {0};", tableNameBackUp);
  59. ExecuteNonQuery(SQL);
  60. SQL = string.Format("INSERT INTO {0} SELECT * FROM {1};", tableNameBackUp, tableName);
  61. ExecuteNonQuery(SQL);
  62. }
  63. else
  64. {
  65. throw new Exception("백업을 지원하지 않는 테이블입니다.");
  66. }
  67. }
  68. catch (Exception ex)
  69. {
  70. Util.UErrorMessage(ex, 0, 0);
  71. throw ex;
  72. }
  73. return BackUpTableOk;
  74. }
  75. public string TableRestore(string tableName)
  76. {
  77. string tableNameBackUp = "";
  78. string SQL = "";
  79. Boolean BackUpTableOk = false;
  80. try
  81. {
  82. tableName = tableName.ToUpper();
  83. tableNameBackUp = string.Format("{0}_BACKUP", tableName, DateTime.Now);
  84. switch (tableName)
  85. {
  86. case "TB_BOARD": BackUpTableOk = true; break;
  87. case "TB_DEVICE": BackUpTableOk = true; break;
  88. case "TB_DEVICE_TYPE": BackUpTableOk = true; break;
  89. case "TB_GROUP": BackUpTableOk = true; break;
  90. case "TB_GROUP_DEVICE": BackUpTableOk = true; break;
  91. case "TB_MAP": BackUpTableOk = true; break;
  92. case "TB_MAP_PROCESS": BackUpTableOk = true; break;
  93. case "TB_POSITION_CODE": BackUpTableOk = true; break;
  94. case "TB_REPEATER": BackUpTableOk = true; break;
  95. case "TB_CONFIG": break;
  96. case "TB_COMM": break;
  97. case "TB_RECEIVER": break;
  98. case "TB_COMMAND_LOG": break;
  99. case "TB_COMM_LOG": break;
  100. }
  101. if (BackUpTableOk)
  102. {
  103. SQL = string.Format("DELETE FROM {0};", tableName);
  104. ExecuteNonQuery(SQL);
  105. SQL = string.Format("INSERT INTO {0} SELECT * FROM {1};", tableName, tableNameBackUp);
  106. ExecuteNonQuery(SQL);
  107. }
  108. else
  109. {
  110. throw new Exception("복원을 지원하지 않는 테이블입니다.");
  111. }
  112. }
  113. catch (Exception ex)
  114. {
  115. Util.UErrorMessage(ex, 0, 0);
  116. throw ex;
  117. }
  118. return tableNameBackUp;
  119. }
  120. }
  121. }