示例#1
0
        public DataSet GetAuthReadSearchMenu(string asEmpRefID, string asSearchStr)
        {
            DataSet lDS = new DataSet();

            IDbConnection conn = DbAgentHelper.CreateDbConnection();

            conn.Open();
            IDbTransaction trx = conn.BeginTransaction();

            try
            {
                Dac_lib_MenuControl dac = new Dac_lib_MenuControl();

                lDS = dac.GetAuthReadSearchMenu(asEmpRefID, asSearchStr);
            }
            catch (Exception)
            {
                trx.Rollback();
                conn.Close();
            }
            finally
            {
                conn.Close();
            }


            return(lDS);
        }
示例#2
0
        /// <summary>
        /// GetMenuTitle
        ///     : 해당페이지의 메뉴명을 리턴한다. (타이틀 표시시 사용)
        /// </summary>
        /// <param name="asPageUrl"></param>
        /// <returns></returns>
        public string GetMenuTitle(string asPageUrl)
        {
            string sRet = "";

            IDbConnection conn = DbAgentHelper.CreateDbConnection();

            conn.Open();
            IDbTransaction trx = conn.BeginTransaction();

            try
            {
                Dac_lib_MenuControl dac = new Dac_lib_MenuControl();

                sRet = dac.GetMenuTitle(asPageUrl);
            }
            catch (Exception)
            {
                trx.Rollback();
                conn.Close();
            }
            finally
            {
                conn.Close();
            }


            return(sRet);
        }
示例#3
0
        //--------------------------------------------------------------------------------------------
        // 추가일 : 2007.05.30
        // UserControl - LeftMenu, TopMenu의 메뉴 Data를 호출한다
        //--------------------------------------------------------------------------------------------
        #region

        public IDataReader GetAuthReadMenu(string asEmpRefID)
        {
            IDataReader dr = null;

            IDbConnection conn = DbAgentHelper.CreateDbConnection();

            conn.Open();
            IDbTransaction trx = conn.BeginTransaction();

            try
            {
                Dac_lib_MenuControl dac = new Dac_lib_MenuControl();

                dr = dac.GetAuthReadMenu(asEmpRefID);
            }
            catch (Exception)
            {
                trx.Rollback();
                conn.Close();
            }
            finally
            {
                conn.Close();
            }


            return(dr);
        }
示例#4
0
        //public string GetTopMenuHtmlString(string asEmpRefID)
        //{
        //    DataSet rDs = base.GetTreeMenuPerUser(asEmpRefID);


        //}

        /// <summary>
        /// GetFinishRate
        ///     : KPI 실적 마감율 추출
        /// </summary>
        /// <param name="asFinishMonth"></param>
        /// <returns></returns>
        public int GetFinishRate(int estterm_ref_id, string asFinishMonth)
        {
            int iRet = 0;


            IDbConnection conn = DbAgentHelper.CreateDbConnection();

            conn.Open();
            IDbTransaction trx = conn.BeginTransaction();

            try
            {
                Dac_lib_MenuControl dac = new Dac_lib_MenuControl();

                iRet = dac.GetFinishRate(estterm_ref_id, asFinishMonth);
            }
            catch (Exception)
            {
                trx.Rollback();
                conn.Close();
            }
            finally
            {
                conn.Close();
            }


            return(iRet);
        }