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