123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156 |
- using System;
- using System.Collections.Generic;
- using System.Text;
- using System.Data;
- namespace FPER
- {
- public class DacPosition : DacBase
- {
- public DacPosition(int ID)
- : base(ID)// cyim 2015.7.30 데이타베이스 접속 루틴 변경
- {
- //try {
- // base.Connect();
- //}
- //catch (Exception ex) {
- // Util.UErrorMessage(ex, 0, 0);
- //}
- }
- ~DacPosition()
- {
- //try {
- // base.DisConnect();
- //}
- //catch (Exception ex) {
- // Util.UErrorMessage(ex, 0, 0);
- //}
- }
- public DataTable Position_Select(string POSITION_CODE)
- {
- DataTable dt = null;
- try
- {
- String SQL = "";
- if (POSITION_CODE == null)
- {
- SQL += "SELECT POSITION_CODE,POSITION_NAME ";
- SQL += " FROM TB_POSITION_CODE ORDER BY POSITION_CODE";
- }
- else
- {
- SQL += "SELECT POSITION_CODE,POSITION_NAME ";
- SQL += " FROM TB_POSITION_CODE WHERE POSITION_CODE = '{0}' ";
- SQL = String.Format(SQL, POSITION_CODE);
- }
- DataSet dao = Select(SQL);
- dt = dao.Tables[0];
- }
- catch (Exception ex)
- {
- Util.UErrorMessage(ex, 0, 0);
- throw ex;
- }
- return dt;
- }
- public void Position_Update(QUERYMode cmd, String POSITION_CODE, String POSITION_NAME)
- {
- try
- {
- DataTable dt = Position_Select(POSITION_CODE);
- if (cmd == QUERYMode.insert || cmd == QUERYMode.update || cmd == QUERYMode.InsertAndUpdate)
- {
- String SQL = "";
- if (dt.Rows.Count > 0)
- {
- SQL = "UPDATE TB_POSITION_CODE SET POSITION_NAME = '{0}'";
- SQL += ", UPDATE_USER_ID = 'FPER', UPDATE_TIME = current_timestamp";
- SQL += " WHERE POSITION_CODE = '{1}'";
- SQL = String.Format(SQL, POSITION_NAME, POSITION_CODE);
- }
- else
- {
- SQL = "INSERT INTO TB_POSITION_CODE ( ";
- SQL += " POSITION_CODE,POSITION_NAME";
- SQL += ",UPDATE_USER_ID,UPDATE_TIME";
- SQL += ") VALUES ('{0}','{1}','FPER',current_timestamp)";
- SQL = String.Format(SQL, POSITION_CODE, POSITION_NAME);
- }
- ExecuteNonQuery(SQL);
- }
- else if (cmd == QUERYMode.delete)
- {
- if (dt.Rows.Count < 1)
- {
- throw new Exception("해당 자료를 찾을수 없습니다.");
- }
- String SQL = "DELETE FROM TB_POSITION_CODE WHERE POSITION_CODE = '{0}'";
- SQL = String.Format(SQL, POSITION_CODE);
- ExecuteNonQuery(SQL);
- }
- }
- catch (Exception ex)
- {
- Util.UErrorMessage(ex, 0, 0);
- throw ex;
- }
- }
- public void PositionCode_Clear()
- {
- try
- {
- String SQL = "DELETE FROM TB_POSITION_CODE ";
- ExecuteNonQuery(SQL);
- }
- catch (Exception ex)
- {
- Util.UErrorMessage(ex, 0, 0);
- throw ex;
- }
- }
- }
- }
|