e7ca3b0c526bff758e606f443cd6066c8d2aaa32.svn-base 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Text;
  4. using System.Data;
  5. namespace IControls_FireManager
  6. {
  7. public class DacPosition: DacBase
  8. {
  9. public DacPosition()
  10. {
  11. //try {
  12. // base.Connect();
  13. //}
  14. //catch (Exception ex) {
  15. // Util.UErrorMessage(ex, 0, 0);
  16. //}
  17. }
  18. ~DacPosition()
  19. {
  20. //try {
  21. // base.DisConnect();
  22. //}
  23. //catch (Exception ex) {
  24. // Util.UErrorMessage(ex, 0, 0);
  25. //}
  26. }
  27. public DataTable Position_Select(string POSITION_CODE)
  28. {
  29. DataTable dt = null;
  30. try
  31. {
  32. String SQL = "";
  33. if (POSITION_CODE == null)
  34. {
  35. SQL += "SELECT POSITION_CODE,POSITION_NAME ";
  36. SQL += " FROM TB_POSITION_CODE ORDER BY POSITION_CODE";
  37. }
  38. else
  39. {
  40. SQL += "SELECT POSITION_CODE,POSITION_NAME ";
  41. SQL += " FROM TB_POSITION_CODE WHERE POSITION_CODE = '{0}' ";
  42. SQL = String.Format(SQL, POSITION_CODE);
  43. }
  44. DataSet dao = Select(SQL);
  45. dt = dao.Tables[0];
  46. }
  47. catch (Exception ex)
  48. {
  49. Util.UErrorMessage(ex,0,0);
  50. throw ex;
  51. }
  52. return dt;
  53. }
  54. public void Position_Update(QUERYMode cmd, String POSITION_CODE, String POSITION_NAME)
  55. {
  56. try
  57. {
  58. DataTable dt = Position_Select(POSITION_CODE);
  59. if (cmd == QUERYMode.insert || cmd == QUERYMode.update || cmd == QUERYMode.InsertAndUpdate)
  60. {
  61. String SQL = "";
  62. if (dt.Rows.Count > 0)
  63. {
  64. SQL = "UPDATE TB_POSITION_CODE SET POSITION_NAME = '{0}'";
  65. SQL += ", UPDATE_USER_ID = 'FPER', UPDATE_TIME = current_timestamp";
  66. SQL += " WHERE POSITION_CODE = '{1}'";
  67. SQL = String.Format(SQL, POSITION_NAME, POSITION_CODE);
  68. }
  69. else
  70. {
  71. SQL = "INSERT INTO TB_POSITION_CODE ( ";
  72. SQL += " POSITION_CODE,POSITION_NAME";
  73. SQL += ",UPDATE_USER_ID,UPDATE_TIME";
  74. SQL += ") VALUES ('{0}','{1}','FPER',current_timestamp)";
  75. SQL = String.Format(SQL, POSITION_CODE, POSITION_NAME);
  76. }
  77. ExecuteNonQuery(SQL);
  78. }
  79. else if (cmd == QUERYMode.delete)
  80. {
  81. if (dt.Rows.Count < 1)
  82. {
  83. throw new Exception("해당 자료를 찾을수 없습니다.");
  84. }
  85. String SQL = "DELETE FROM TB_POSITION_CODE WHERE POSITION_CODE = '{0}'";
  86. SQL = String.Format(SQL, POSITION_CODE);
  87. ExecuteNonQuery(SQL);
  88. }
  89. }
  90. catch (Exception ex)
  91. {
  92. Util.UErrorMessage(ex,0,0);
  93. throw ex;
  94. }
  95. }
  96. public void PositionCode_Clear()
  97. {
  98. try
  99. {
  100. String SQL = "DELETE FROM TB_POSITION_CODE ";
  101. ExecuteNonQuery(SQL);
  102. }
  103. catch (Exception ex)
  104. {
  105. Util.UErrorMessage(ex,0,0);
  106. throw ex;
  107. }
  108. }
  109. }
  110. }