protected void Page_Load(object sender, EventArgs e)
        {
            setting = CY.HotelBooking.Core.Business.Settings.Load(0);

            if (!Page.IsPostBack)
            {
                if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    int newsId;

                    bool paresed = int.TryParse(Request.QueryString["id"], out newsId);

                    if (paresed)
                    {
                        CY.HotelBooking.Core.Business.Web_News news = CY.HotelBooking.Core.Business.Web_News.Load(newsId);

                        if (news != null)
                        {
                            this.Title = news.News_Title + " " + setting.HotelName;
                            LiteralNewsTitle.Text = news.News_Title;
                            LiteralNewsContent.Text = Server.HtmlDecode(news.News_Content);
                            LiteralNewsPubTime.Text = news.News_PubDate.ToString("yyyy年MM月dd日 HH点mm分");
                        }
                        else
                        {
                        }
                    }
                    else
                    {
                        throw new Exception("您访问的页面不存在");
                    }
                }
                else if (!string.IsNullOrEmpty(Request.QueryString["modulecode"]))
                {
                    moduleCode = Request.QueryString["modulecode"].ToString();
                    CY.HotelBooking.Core.Business.Web_News news = new CY.HotelBooking.Core.Business.Web_News();

                    IList<CY.HotelBooking.Core.Business.Web_News> newslist = CY.HotelBooking.Core.Business.Web_News.GetByModuleCode(moduleCode);

                    if (newslist == null || newslist.Count < 1)
                    {
                        return;
                    }

                    this.Title = newslist[0].News_Title + " " + setting.HotelName;
                    LiteralNewsTitle.Text = newslist[0].News_Title;
                    LiteralNewsContent.Text = Server.HtmlDecode(newslist[0].News_Content);
                    LiteralNewsPubTime.Text = newslist[0].News_PubDate.ToString("yyyy年MM月dd日 HH点mm分");

                }
                else
                {
                    throw new Exception("您访问的页面不存在");
                }
            }
        }
        public IList<CY.HotelBooking.Core.Business.Web_News> Search(string strModuleCode, string keyword)
        {
            IList<CY.HotelBooking.Core.Business.Web_News> list_news = new List<CY.HotelBooking.Core.Business.Web_News>();
            SqlServerUtility sqlhelper = new SqlServerUtility();
            SqlDataReader reader;

            if (!string.IsNullOrEmpty(keyword) && (keyword.Trim() != ""))
            {
                sqlhelper.AddParameter("@KeyWord", SqlDbType.VarChar, keyword.Trim(), 50);
            }

            if (!strModuleCode.Trim().Equals(""))
            {
                sqlhelper.AddParameter("@Module_Code", SqlDbType.VarChar, strModuleCode, 10);
                reader = sqlhelper.ExecuteSqlReader(strSQLSelectByModuleCodeSearch.ToString());
            }
            else
            {
                if (!string.IsNullOrEmpty(keyword) && (keyword.Trim() != ""))
                {
                    reader = sqlhelper.ExecuteSqlReader(strSQLSelectALLSearch.ToString());
                }
                else // 全部
                {
                    reader = sqlhelper.ExecuteSqlReader(strSQLSelectALL);
                }
            }

            if (reader != null && !reader.IsClosed)
            {
                while (reader.Read())
                {
                    CY.HotelBooking.Core.Business.Web_News news = new CY.HotelBooking.Core.Business.Web_News();

                    if (!reader.IsDBNull(0)) { news.Id = reader.GetInt32(0); }
                    if (!reader.IsDBNull(1)) { news.News_Title = reader.GetString(1); }
                    if (!reader.IsDBNull(2)) { news.News_Content = reader.GetString(2); }
                    if (!reader.IsDBNull(3)) { news.News_PubDate = reader.GetDateTime(3); }
                    if (!reader.IsDBNull(4)) { news.Module_Code = reader.GetString(4); }
                    if (!reader.IsDBNull(5)) { news.Manager_Code = reader.GetString(5); }
                    list_news.Add(news);
                }
                reader.Close();
                return list_news;
            }
            return null;
        }
        public CY.HotelBooking.Core.Business.Web_News Load(int id)
        {
            SqlServerUtility sqlhelper = new SqlServerUtility();
            sqlhelper.AddParameter("@News_ID", SqlDbType.Int, id);

            SqlDataReader reader = sqlhelper.ExecuteSqlReader(strSQLSelect.ToString());

            if (reader != null && !reader.IsClosed)
            {
                if (reader.Read())
                {
                    CY.HotelBooking.Core.Business.Web_News news = new CY.HotelBooking.Core.Business.Web_News();

                    if (!reader.IsDBNull(0)) { news.Id = reader.GetInt32(0); }
                    if (!reader.IsDBNull(1)) { news.News_Title = reader.GetString(1); }
                    if (!reader.IsDBNull(2)) { news.News_Content = reader.GetString(2); }
                    if (!reader.IsDBNull(3)) { news.News_PubDate = reader.GetDateTime(3); }
                    if (!reader.IsDBNull(4)) { news.Module_Code = reader.GetString(4); }
                    if (!reader.IsDBNull(5)) { news.Manager_Code = reader.GetString(5); }
                    reader.Close();
                    return news;
                }
                reader.Close();
            }
            return null;
        }
        public IList<CY.HotelBooking.Core.Business.Web_News> Load(string strModuleCode, int top)
        {
            string strSQLSelectTopByModuleCode = "SELECT Top "+top+" [News_ID], [News_Title], [News_Content], [News_PubDate], [Module_Code], [Manager_Code] "
                                                  + "FROM [dbo].[Web_News] where Module_Code = '" + strModuleCode + "' order by News_PubDate desc";
              string strSQLSelectALLTop = "SELECT Top "+top+" [News_ID], [News_Title], [News_Content], [News_PubDate], [Module_Code], [Manager_Code] "
                                                  + "FROM [dbo].[Web_News] order by News_PubDate desc";

            IList<CY.HotelBooking.Core.Business.Web_News> list_news = new List<CY.HotelBooking.Core.Business.Web_News>();
            SqlServerUtility sqlhelper = new SqlServerUtility();
            SqlDataReader reader;
            if (!strModuleCode.Trim().Equals(""))
            {
                reader = sqlhelper.ExecuteSqlReader(strSQLSelectTopByModuleCode.ToString());
            }
            else
            {
                reader = sqlhelper.ExecuteSqlReader(strSQLSelectALLTop.ToString());
            }

            if (reader != null && !reader.IsClosed)
            {
                while (reader.Read())
                {
                    CY.HotelBooking.Core.Business.Web_News news = new CY.HotelBooking.Core.Business.Web_News();

                    if (!reader.IsDBNull(0)) { news.Id = reader.GetInt32(0); }
                    if (!reader.IsDBNull(1)) { news.News_Title = reader.GetString(1); }
                    if (!reader.IsDBNull(2)) { news.News_Content = reader.GetString(2); }
                    if (!reader.IsDBNull(3)) { news.News_PubDate = reader.GetDateTime(3); }
                    if (!reader.IsDBNull(4)) { news.Module_Code = reader.GetString(4); }
                    if (!reader.IsDBNull(5)) { news.Manager_Code = reader.GetString(5); }
                    list_news.Add(news);
                }
                reader.Close();
                return list_news;
            }
            return null;
        }