예제 #1
0
        /// <summary>
        /// ���� ����Ʈ�� �����´�.
        /// </summary>
        /// <param name="articleNo"></param>
        /// <returns></returns>
        public static CommentBindModel GetCommentList(int articleNo)
        {
            SqlParameter[] param = { CreateInParam("@ArticleNo", SqlDbType.Int, 4, articleNo) };

            SqlCommand cmd = GetSpCommand("UBC_GetCommentList", param);
            SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

            CommentBindModel bindModel;
            try
            {
                bindModel = new CommentBindModel(articleNo);

                while (reader.Read())
                {
                    CommentModel model = new CommentModel();

                    FillComment( reader, model );

                    bindModel.Add( model );

                    model = null;
                }

                return bindModel;
            }
            catch( Exception ex )
            {
                throw  ex;
            }
            finally
            {
                ReleaseCommand(cmd);
            }
        }
예제 #2
0
        /// <summary>
        /// �ֽ� ��� ����Ʈ�� ������ŭ �����´�.
        /// </summary>
        /// <param name="count"></param>
        /// <returns></returns>
        public static CommentBindModel GetRecentCommentList(int count)
        {
            SqlParameter[] param = { CreateInParam("@Count", SqlDbType.Int,4, count ) };

            SqlCommand cmd		= GetSpCommand("UBC_GetRecentCommentList", param);
            SqlDataReader reader= cmd.ExecuteReader(CommandBehavior.CloseConnection);
            CommentBindModel bindModel	= new CommentBindModel();

            try
            {
                while(reader.Read())
                {
                    CommentModel model = new CommentModel();
                    FillComment( reader, model );
                    bindModel.Add( model );

                    model				= null;
                }

                return bindModel;
            }
            catch( Exception ex)
            {
                throw new UmcDataException("UBC_GetRecentCommentList ���ν��� ȣ���� ����", ex);
            }
            finally
            {
                ReleaseCommand(cmd);
            }
        }