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