/// <summary>
/// 添加新闻栏目,执行成功返回true,否则返回false
/// </summary>
/// <param name="name">栏目名称</param>
/// <returns>true,false</returns>
public bool AddBigClass(string name)
{
int cindex = GetMaxCindex() + 1;
string strSQL = "insert into BigClass (name,cindex) values ('" + name + "'," + cindex + ")";
return(db.ExecuteNonQuery(false, strSQL));
}
/// <summary>
/// 添加新闻,添加成功返回true,否则返回false
/// </summary>
/// <param name="M_news">参数</param>
/// <returns>bool值</returns>
public bool AddNews(Model.news M_news)
{
string times = System.DateTime.Now.ToString();
int cindex = GetMaxCindex() + 1;
string strSQL = "insert news (title,info,BigClassID,username,infotime,cindex) values('" + M_news.title + "','" + M_news.info + "'," + M_news.BigClassID + ",'" + M_news.username + "','" + times + "', " + cindex + " )";
return(db.ExecuteNonQuery(false, strSQL));
}
/// <summary>
/// 添加管理员用户,语句执行成功返回true,否则返回false
/// </summary>
/// <param name="del_ad">实体层类的对象</param>
/// <returns>true,false</returns>
public bool AddUser(Model.admin del_ad)
{
string strSQL = "insert into admin (username,password,email,aleave) values ('" + del_ad.username + "','" + del_ad.password + "','" + del_ad.useremail + "','" + del_ad.aleave + "')";
return(db.ExecuteNonQuery(false, strSQL));
}
/// <summary>
/// 根据新闻ID删除该新闻的全部评论
/// </summary>
/// <param name="NewsID">新闻ID</param>
/// <returns>true,false</returns>
public bool DeleteAllByNewsID(int NewsID)
{
string strSQL = "delete from answer where newsID=" + NewsID;
return(db.ExecuteNonQuery(false, strSQL));
}