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"];//有待改善不安全
WorkdtArticle da = new WorkdtArticle();
WorkdtArticleBLL workdtarticlebll = new WorkdtArticleBLL();
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.Trim();
string name = this.Image1.ImageUrl.Substring(14);
if (workdtarticlebll.Update(da))
{
Response.Write("<script>alert('修改成功');window.location.href='WorkdtMgr.aspx';</script>");
}
else
{
Response.Write("<script>alert('更新失败');history.back();</script>");
}
}
public IList <WorkdtArticle> FindALLByHits()
{
List <WorkdtArticle> list = new List <WorkdtArticle>();
sql = "select top 12 * from WorkdtArticle order by hits desc";
ds = DbHelperSQL.GetDataSet(sql);
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
WorkdtArticle a = new WorkdtArticle();
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();
a.Url = dr["Url"].ToString();
list.Add(a);
}
return(list);
}
}
public IList <WorkdtArticle> FindALL(object cid, int num)//找到cid的类中前num的列表
{
List <WorkdtArticle> list = new List <WorkdtArticle>();
if (cid != null && cid.ToString() != "")
{
sql = "select top " + num + " * from WorkdtArticle where cid=" + cid + " order by id desc";
}
else
{
sql = "select top " + num + " * from WorkdtArticle order by id desc";
}
ds = DbHelperSQL.GetDataSet(sql);
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
WorkdtArticle a = new WorkdtArticle();
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();
a.Url = dr["Url"].ToString();
list.Add(a);
}
return(list);
}
}
public IList <WorkdtArticle> Getlist(object num)//取WorkdtArticle表中前num个记录,以列表的形式返回
{
List <WorkdtArticle> list = new List <WorkdtArticle>();
if (num != null && num.ToString() != "")
{
sql = "select top " + num + " * from WorkdtArticle order by id desc";
}
else
{
sql = "select * from WorkdtArticle order by id desc";
}
ds = DbHelperSQL.GetDataSet(sql);
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
WorkdtArticle a = new WorkdtArticle();
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();
a.Url = dr["Url"].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;
}
WorkdtArticle da = new WorkdtArticle();
WorkdtArticleBLL workdtarticlebll = new WorkdtArticleBLL();
string newname = "";
da.Url = newname;
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 (workdtarticlebll.Add(da))
{
Response.Write("<script>alert('添加成功');window.location.href='WorkdtMgr.aspx';</script>");
}
else
{
Response.Write("<script>alert('添加失败');history.back();</script>");
}
}
public bool Update(WorkdtArticle a)
{
if (DbHelperSQL.Update(a))
{
return(true);
}
else
{
return(false);
}
}
public bool Add(WorkdtArticle a)
{
if (DbHelperSQL.Insert(a))
{
return(true);
}
else
{
return(false);
}
}
public void DateBind(object id)//绑定要修改的信息
{
WorkdtArticleBLL workdtarticlebll = new WorkdtArticleBLL();
WorkdtArticle da = new WorkdtArticle();
da = workdtarticlebll.GetNewsArticle(id);
TxtTitle.Text = da.Title;
TxtWriter.Text = da.Writer;
TxtDate.Text = da.AddDate.ToString("d");
txtContent.Text = da.Content.ToString();
this.Image1.ImageUrl = "~/IndexImages/" + da.Url;
}
public WorkdtArticle Find(object id)//从WorkdtArticle找到该id的数据，返回一个WorkdtArticle类生成的对象
{
a = new WorkdtArticle();
string sql = string.Format("select * from WorkdtArticle 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();
a.Url = dr["Url"].ToString();
return(a);
}
catch
{
return(null);
}
}
public IList <WorkdtArticle> search(string cid)//搜索该表中，所有与关键字匹配的记录，当cid为空时，搜索整个表
{
if (cid == "" || cid == null)
{
sql = "select * from WorkdtArticle order by id desc";
ds = DbHelperSQL.GetDataSet(sql);
}
else
{
sql = "select * from WorkdtArticle where title like '%" + cid + "%' order by id desc";
SqlParameter par = new SqlParameter("@titlesea", SqlDbType.NVarChar, 50);
par.Value = cid;
SqlParameter tablename = new SqlParameter("@tablename", SqlDbType.NVarChar, 50);
tablename.Value = "WorkdtArticle";
SqlParameter[] cmdParms = { tablename, par };
ds = DbHelperSQL.RunProcedure("WorkdtSearch", cmdParms, "WorkdtArticle");
}
List <WorkdtArticle> list = new List <WorkdtArticle>();
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
WorkdtArticle a = new WorkdtArticle();
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 bool Update(WorkdtArticle news)//更新数据
{
return(WorkdtArticleDao.Update(news));
}
public bool Add(WorkdtArticle news)//加数据
{
return(WorkdtArticleDao.Add(news));
}