public static int DeleteContentClass(ContentClass contentclass) { string sql = "delete BBS_Class where ClassID=@ClassID"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@ClassID", contentclass.Classid) }; return(DBHelper.ExecuteCommand(sql, para)); }
public static int addContentclass(ContentClass contentclass) { string sql = "insert into BBS_Class(ClassName,Enable,ClassUrl) values(@Classname,@Enable,@ClassUrl)"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@ClassName", contentclass.Classname), new SqlParameter("@Enable", contentclass.Enable), new SqlParameter("@ClassUrl", contentclass.Classurl) }; return(DBHelper.ExecuteCommand(sql, para)); }
public static int ModifyContentclass(ContentClass contentclass) { string sql = "update BBS_Class set ClassName=@ClassName,Enable=@Enable,ClassUrl=@ClassUrl where ClassID=@ClassID"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@ClassName", contentclass.Classname), new SqlParameter("@Enable", contentclass.Enable), new SqlParameter("@ClassUrl", contentclass.Classurl), new SqlParameter("@ClassID", contentclass.Classid), }; return(DBHelper.ExecuteCommand(sql, para)); }
protected void btnOK_Click(object sender, EventArgs e) { if ((User)Session["User"] == null) { this.FreeTextBox1.Enabled = false; this.classid.Enabled = false; this.contenttitle.Enabled = false; this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请登录后发帖!')</script>"); return; } if (contenttitle.Text.Trim().Length == 0) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('标题不能为空!')</script>"); return; } if (FreeTextBox1.Text.Trim().Length == 0) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('内容不能为空!')</script>"); return; } LBBS.Model.Content content = new LBBS.Model.Content(); User user = (User)Session["User"];//如何保存当前UID ContentClass contentclass = (ContentClass)CCManager.GetContentclassById(Convert.ToInt32(classid.SelectedValue)); content.Title = contenttitle.Text.Trim(); content.Contentclass = contentclass; content.Contentery = FreeTextBox1.Text; content.Createdon = Convert.ToDateTime(DateTime.Now.ToString("")); content.Repliedon = Convert.ToDateTime(DateTime.Now.ToString("")); content.Replycount = 0; content.Isclose = "已审核"; content.User = user;//关联表数据设定 if (ContentManager.addContent(content) > 0) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('增加成功!');</script>"); return; } else { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('增加失败!');</script>"); return; } }
private static IList <ContentClass> GetContentclassBySql(string safeSql) { List <ContentClass> list = new List <ContentClass>(); DataTable table = DBHelper.GetDataSet(safeSql); foreach (DataRow row in table.Rows) { ContentClass contentclass = new ContentClass(); contentclass.Classid = (int)row["ClassID"]; contentclass.Classname = (string)row["ClassName"]; //contentclass.Enable = (Boolean)row["Enable"]; contentclass.Classurl = (string)row["ClassUrl"]; contentclass.Topiccount = (int)row["TopicCount"]; list.Add(contentclass); } return(list); }
//contentservice.cs类外键引用 public static ContentClass GetContentclassById(int classid) { string sql = "select * from BBS_Class where ClassID=@ClassID"; using (SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@ClassID", classid))) { if (reader.Read()) { ContentClass contentcalss = new ContentClass(); contentcalss.Classid = (int)reader["ClassID"]; contentcalss.Classname = (string)reader["ClassName"]; contentcalss.Classurl = (string)reader["ClassUrl"]; reader.Close(); return(contentcalss); } else { reader.Close(); return(null); } } }
public static int DeleteContentClass(ContentClass contentclass) { return(CCService.DeleteContentClass(contentclass)); }
public static int ModifyContentclass(ContentClass contentclass) { return(CCService.ModifyContentclass(contentclass)); }
public static int AddContentclass(ContentClass contentclass) { return(CCService.addContentclass(contentclass)); }