| 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;            }        }    }}
 |