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