Esempio n. 1
0
        /// <summary>
        /// 프로시저 실행 후 결과를 리턴한다.
        /// </summary>
        /// <param name="procIndex">프로시저번호</param>
        /// <param name="param">파라미터</param>
        protected string[] ExecuteQueryResult(string proc_nm)
        {
            CheckLogin();

            string[] result = null;

            DataSet ds = WebSql.SelectSqlByName(proc_nm);

            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                result    = new string[3];
                result[0] = ds.Tables[0].Rows[0]["RESULT_CD"].ToString();
                result[1] = ds.Tables[0].Rows[0]["RESULT_MSG"].ToString();

                if (ds.Tables[0].Columns.Contains("PROD_CD"))
                {
                    result[2] = ds.Tables[0].Rows[0]["PROD_CD"].ToString();
                }

                if (ds.Tables[0].Columns.Contains("SEQ"))
                {
                    result[2] = ds.Tables[0].Rows[0]["SEQ"].ToString();
                }
            }

            return(result);
        }
Esempio n. 2
0
        protected DataSet GetDataSet(string proc_nm)
        {
            try
            {
                // 체크 잠시 중단
                //return WebSql.SelectSql(procIndex, CSecureUtil.CheckString(param));
                return(WebSql.SelectSqlByName(proc_nm));
            }
            catch (Exception e)
            {
                CLog.debug(logger, "PageBase.GetDataSet(" + proc_nm + ") : " + e.Message);
            }

            return(null);
        }