protected void Save_Click(object sender, EventArgs e)
{
if (txtContent.Text.Trim().Length == 0)
{
Response.Write("<script>alert('内容不能为空！');</script>");
return;
}
object id = Request.QueryString["id"];//有待改善不安全
NoticeArticle da = new NoticeArticle();
NoticeArticleBLL noticearticle = new NoticeArticleBLL();
da.AddDate = Convert.ToDateTime(TxtDate.Text);
da.Writer = Server.HtmlEncode(TxtWriter.Text.Trim());
da.Title = Server.HtmlEncode(TxtTitle.Text.Trim());
da.Id = id;
da.Content = txtContent.Text;
if (noticearticle.Update(da))
{
Response.Write("<script>alert('修改成功');window.location.href='NoticeMgr.aspx';</script>");
}
else
{
Response.Write("<script>alert('更新失败');history.back();</script>");
}
}
public IList <NoticeArticle> Getlist(object num)//取NoticeArticle表中前num个记录,以列表的形式返回
{
List <NoticeArticle> list = new List <NoticeArticle>();
if (num != null && num.ToString() != "")
{
sql = "select top " + num + " * from NoticeArticle order by id desc";
}
else
{
sql = "select * from NoticeArticle order by id desc";
}
ds = DbHelperSQL.GetDataSet(sql);
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
NoticeArticle a = new NoticeArticle();
a.AddDate = Convert.ToDateTime(dr["addDate"].ToString());
a.Content = dr["Content"].ToString();
a.Id = dr["id"];
a.Title = dr["Title"].ToString();
a.Writer = dr["Writer"].ToString();
list.Add(a);
}
return(list);
}
}
public IList <NoticeArticle> FindALLByHits()
{
List <NoticeArticle> list = new List <NoticeArticle>();
sql = "select top 12 * from NoticeArticle order by hits desc";
ds = DbHelperSQL.GetDataSet(sql);
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
NoticeArticle a = new NoticeArticle();
a.AddDate = Convert.ToDateTime(dr["addDate"].ToString());
a.Content = dr["Content"].ToString();
a.Id = dr["id"];
a.Title = dr["Title"].ToString();
a.Writer = dr["Writer"].ToString();
list.Add(a);
}
return(list);
}
}
public IList <NoticeArticle> FindALL(object cid, int num)//找到cid的类中前num的列表
{
List <NoticeArticle> list = new List <NoticeArticle>();
if (cid != null && cid.ToString() != "")
{
sql = "select top " + num + " * from NoticeArticle where cid=" + cid + " order by id desc";
}
else
{
sql = "select top " + num + " * from NoticeArticle order by id desc";
}
ds = DbHelperSQL.GetDataSet(sql);
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
NoticeArticle a = new NoticeArticle();
a.AddDate = Convert.ToDateTime(dr["addDate"].ToString());
a.Content = dr["Content"].ToString();
a.Id = dr["id"];
a.Title = dr["Title"].ToString();
a.Writer = dr["Writer"].ToString();
list.Add(a);
}
return(list);
}
}
public void DateBind(object id)//绑定要修改的信息
{
NoticeArticleBLL noticearticle = new NoticeArticleBLL();
NoticeArticle da = new NoticeArticle();
da = noticearticle.GetNewsArticle(id);
TxtTitle.Text = da.Title;
TxtWriter.Text = da.Writer;
TxtDate.Text = da.AddDate.ToString("d");
txtContent.Text = da.Content.ToString();
}
public bool Update(NoticeArticle a)
{
if (DbHelperSQL.Update(a))
{
return(true);
}
else
{
return(false);
}
}
public bool Add(NoticeArticle a)
{
if (DbHelperSQL.Insert(a))
{
return(true);
}
else
{
return(false);
}
}
public NoticeArticle Find(object id)//从NoticeArticle找到该id的数据，返回一个NoticeArticle类生成的对象
{
a = new NoticeArticle();
string sql = string.Format("select * from NoticeArticle where id='{0}'", id);
dr = DbHelperSQL.GetDateRow(sql);
try
{
a.AddDate = Convert.ToDateTime(dr["AddDate"].ToString());
a.Content = dr["Content"].ToString();
a.Id = dr["id"];
a.Title = dr["Title"].ToString();
a.Writer = dr["Writer"].ToString();
return(a);
}
catch
{
return(null);
}
}
public IList <NoticeArticle> search(string cid)//搜索该表中，所有与关键字匹配的记录，当cid为空时，搜索整个表
{
if (cid == "" || cid == null)
{
sql = "select * from NoticeArticle order by id desc";
ds = DbHelperSQL.GetDataSet(sql);
}
else
{
SqlParameter par = new SqlParameter("@titlesea", SqlDbType.NVarChar, 50);
par.Value = cid;
SqlParameter tablename = new SqlParameter("@tablename", SqlDbType.NVarChar, 50);
tablename.Value = "NoticeArticle";
SqlParameter[] cmdParms = { tablename, par };
ds = DbHelperSQL.RunProcedure("NoticeSearch", cmdParms, "NoticeArticle");
}
List <NoticeArticle> list = new List <NoticeArticle>();
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
NoticeArticle a = new NoticeArticle();
a.AddDate = Convert.ToDateTime(dr["addDate"].ToString());
a.Content = dr["Content"].ToString();
a.Id = dr["id"];
a.Title = dr["Title"].ToString();
a.Writer = dr["Writer"].ToString();
list.Add(a);
}
return(list);
}
}
protected void Add_Click(object sender, EventArgs e)
{
if (txtContent.Text.Trim().Length == 0)
{
Response.Write("<script>alert('内容不能为空！');</script>");
return;
}
NoticeArticle da = new NoticeArticle();
NoticeArticleBLL noticearticlebll = new NoticeArticleBLL();
da.AddDate = Convert.ToDateTime(TxtDate.Text);
da.Writer = Server.HtmlEncode(TxtWriter.Text.Trim());
da.Title = Server.HtmlEncode(TxtTitle.Text.Trim());
da.Content = txtContent.Text;
if (noticearticlebll.Add(da))
{
Response.Write("<script>alert('添加成功');window.location.href='NoticeMgr.aspx';</script>");
}
else
{
Response.Write("<script>alert('添加失败');history.back();</script>");
}
}
public bool Update(NoticeArticle news)//更新数据
{
return(NoticeArticleDao.Update(news));
}
public bool Add(NoticeArticle news)//加数据
{
return(NoticeArticleDao.Add(news));
}
