//根据id查找数据
public Ep229News SelectById(int id)
{
Ep229News news = null;
string sql = String.Format("select * from ep229_news where news_id={0}", id);
SqlDataReader sdr = SqlHelper.ExecuteReader(sql);
if (sdr.Read())
{
news = new Ep229News();
news.NewsId = sdr.GetInt32(0);
news.NewsTitle = sdr.GetString(1);
news.NewsContent = sdr.GetString(2);
news.NewsDatetime = sdr.GetDateTime(3);
}
sdr.Close();
return(news);
}
//添加成功事件，添加成功返回管理页面，失败则停在当前页面
protected void Button1_Click(object sender, EventArgs e)
{
Ep229NewsBLL NewsBll = new Ep229NewsBLL();
Ep229News News = new Ep229News();
News.NewsTitle = title1.Text;
News.NewsContent = contain.Text;
if (NewsBll.AddNews(News) == 1)
{
this.ClientScript.RegisterClientScriptBlock(this.GetType(),
"", "alert('添加成功'); window.location.href='Manage.aspx'", true);
}
else
{
this.ClientScript.RegisterClientScriptBlock(this.GetType(),
"", "alert('添加失败'); window.location.href='Add.aspx'", true);
}
}
//查询前几条数据
public IList <Ep229News> SelectTopSome(int num)
{
IList <Ep229News> list = new List <Ep229News>();
String sql = String.Format("select top {0} * from ep229_news order by news_datetime desc ", num);
DataTable dt = SqlHelper.ExecuteQuery(sql);
Ep229News news = null;
foreach (DataRow row in dt.Rows)
{
news = new Ep229News();
news.NewsId = (int)row[0];
news.NewsTitle = (string)row[1];
news.NewsContent = (string)row[2];
news.NewsDatetime = (DateTime)row[3];
list.Add(news);
}
return(list);
}
//选出全部数据
public IList <Ep229News> SelectSome(out int total, string sortExpression, int start, int count)
{
IList <Ep229News> list = new List <Ep229News>();
String sql = String.Format("select * from ep229_news");
DataTable dt = SqlHelper.ExecuteQuery(out total, sql, sortExpression, start, count);
Ep229News news = null;
foreach (DataRow row in dt.Rows)
{
news = new Ep229News();
news.NewsId = (int)row[0];
news.NewsTitle = (string)row[1];
news.NewsContent = (string)row[2];
news.NewsDatetime = (DateTime)row[3];
list.Add(news);
}
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = "新闻详情";
int newsId = Convert.ToInt32(Request["NewsId"]);
News = NewsBll.FindNewsById(newsId);
TextBox3.Text = News.NewsTitle;
TextBox4.Text = News.NewsContent;
Uri Url = HttpContext.Current.Request.UrlReferrer;
//根据url判读返回的路径
if (String.Compare(Url.LocalPath, "Views/News/Browse") == 0)
{
Button2.PostBackUrl = "~/Views/Index.aspx";
}
else if (String.Compare(Url.LocalPath, "/Views/News/Manage") == 0)
{
Button2.PostBackUrl = "~/Views/Product/Manage.aspx";
}
else
{
Button2.PostBackUrl = "~/Views/Index.aspx";
}
}
//编辑一条新闻数据
public int EditNews(Ep229News news)
{
return(NewsDAL.Update(news));
}
//删除一条新闻数据
public int DeleteNews(Ep229News news)
{
return(NewsDAL.Delete(news.NewsId));
}
//添加一条新闻数据
public int AddNews(Ep229News news)
{
return(NewsDAL.Insert(news));
}
//插入一条数据
public int Insert(Ep229News news)
{
string sql = String.Format("insert into ep229_news(news_title,news_content) values('{0}','{1}')", news.NewsTitle, news.NewsContent);
return(SqlHelper.ExecuteNonQuery(sql));
}
//更新数据
public int Update(Ep229News news)
{
string sql = String.Format("update ep229_news set news_title='{0}' ,news_content='{1}' where news_id={2}", news.NewsTitle, news.NewsContent, news.NewsId);
return(SqlHelper.ExecuteNonQuery(sql));
}
