protected void Button2_Click1(object sender, EventArgs e)
{
Model.Contribute contribute = new Model.Contribute();
contribute.id = s;
BLL.ContributeBLL contributeBLL = new BLL.ContributeBLL();
if (contributeBLL.DelContribute(contribute))
{
Response.Write("<script>alert('删除成功');window.location.href='contributes.aspx'</script>");
}
}
public void del()
{
Model.Contribute contribute = new Model.Contribute();
contribute.id = s;
BLL.ContributeBLL contributeBLL = new BLL.ContributeBLL();
if (contributeBLL.DelContribute(contribute))
{
Response.Write("<script>alert('删除稿件成功');window.location.href='checktougao.aspx'</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Model.Contribute contribute = new Model.Contribute();
contribute.id = s;
contribute.category = DropDownList1.SelectedItem.Text;
contribute.title = Request["ttitle"].ToString();
contribute.author = Request["author"].ToString();
contribute.contents = this.txtEditorContents.Text;
contribute.createTime = DateTime.Now.ToLocalTime().ToString();
BLL.ContributeBLL contributeBLL = new BLL.ContributeBLL();
contributeBLL.UpdateContribute(contribute);
}
//更新投稿
public bool UpdateContribute(Model.Contribute contribute)
{
string SQL = "update contribute set category = '" + contribute.category + "',title = '" + contribute.title + "',author = '" + contribute.author + "',contents = '" + contribute.contents + "',createTime = '" + contribute.createTime + "' where id = '" + contribute.id + "'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
HttpContext.Current.Response.Write("<script>alert('更新成功');location.href='contributes.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('更新失败,请重试');</script>");
return(false);
}
}
//删除投稿
public bool DelContribute(Model.Contribute contribute)
{
string SQL = "DELETE from contribute where id='" + contribute.id + "'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
// HttpContext.Current.Response.Write("<script>alert('删除成功');location.href='contributes.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('删除失败,请重试');</script>");
return(false);
}
}
public void query(string id)
{
Model.Contribute contribute = new Model.Contribute();
contribute.id = id;
BLL.ContributeBLL contributeBLL = new BLL.ContributeBLL();
if (contributeBLL.QueryContribute(contribute))
{
this.ttitle.Value = contribute.title.ToString();
this.author.Value = contribute.author.ToString();
this.txtEditorContents.Text = contribute.contents;
}
else
{
Response.Write("<script>alert('查询失败')</script>");
}
}
//添加投稿
public bool AddContribute(Model.Contribute contribute)
{
string SQL = "insert into contribute values('" + contribute.username + "','" + contribute.category + "','" + contribute.title + "','" + contribute.author + "','" + contribute.contents + "','" + contribute.createTime + "')";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
HttpContext.Current.Response.Write("<script>alert('投稿成功');location.href='contributes.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('投稿失败,请重试');</script>");
return(false);
}
}
//搜索投稿---按username
public bool SearchUsername(Model.Contribute contribute)
{
string SQL;
SQL = "select * from contribute where username like '%" + contribute.username + "%'";
contribute.sql = SQL;
DataSet ds = DBHelper.GetDataSet(SQL);
if (ds.Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
//查询投稿
public bool QueryContribute(Model.Contribute contribute)
{
string SQL = "select * from contribute where id='" + contribute.id + "'";
DataSet ds = DBHelper.GetDataSet(SQL);
if (ds.Tables[0].Rows.Count > 0)
{
contribute.username = ds.Tables[0].Rows[0][1].ToString();
contribute.category = ds.Tables[0].Rows[0][2].ToString();
contribute.title = ds.Tables[0].Rows[0][3].ToString();
contribute.author = ds.Tables[0].Rows[0][4].ToString();
contribute.contents = ds.Tables[0].Rows[0][5].ToString();
contribute.createTime = ds.Tables[0].Rows[0][6].ToString();
return(true);
}
else
{
return(false);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Model.Contribute contribute = new Model.Contribute();
BLL.ContributeBLL contributeBLL = new BLL.ContributeBLL();
if (this.DropDownList1.SelectedValue == "按标题")
{
contribute.title = Request["search"].ToString().Trim();
contributeBLL.SearchTitle(contribute);
this.SqlDataSource1.SelectCommand = contribute.sql;
}
else if (this.DropDownList1.SelectedValue == "按类别")
{
contribute.category = Request["search"].ToString().Trim();
contributeBLL.SearchCategory(contribute);
this.SqlDataSource1.SelectCommand = contribute.sql;
}
else if (this.DropDownList1.SelectedValue == "按投稿人")
{
contribute.username = Request["search"].ToString().Trim();
contributeBLL.SearchUsername(contribute);
this.SqlDataSource1.SelectCommand = contribute.sql;
}
}
public bool UpdateContribute(Model.Contribute contribute)
{
return(db.UpdateContribute(contribute));
}
public bool QueryContribute(Model.Contribute contribute)
{
return(db.QueryContribute(contribute));
}
public bool AddContribute(Model.Contribute contribute)
{
return(db.AddContribute(contribute));
}
public bool SearchUsername(Model.Contribute contribute)
{
return(db.SearchUsername(contribute));
}
public bool SearchCategory(Model.Contribute contribute)
{
return(db.SearchCategory(contribute));
}
public bool SearchTitle(Model.Contribute contribute)
{
return(db.SearchTitle(contribute));
}
public bool DelContribute(Model.Contribute contribute)
{
return(db.DelContribute(contribute));
}
