/// <summary>
/// 删除管理员
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int delectAdmin(int id)
{
string sql = "delete from webHT_Admin where adminId='" + id + "'";
int result = DBHelp.DoSql(sql);
return(result);
}
/// <summary>
/// 修改管理员信息 (不修改密码)
/// </summary>
/// <param name="id"></param>
/// <param name="name"></param>
/// <param name="realName"></param>
/// <returns></returns>
public int UpdateAdmin(int id, string realName)
{
string sql = "update webHT_Admin set RealName='" + realName + "' where adminID='" + id + "'";
int result = DBHelp.DoSql(sql);
return(result);
}
/// <summary>
/// 添加管理员
/// </summary>
/// <returns></returns>
public int addAdmin(Administrator admin)
{
string sql = "insert into webHT_Admin(adminName,adminPassword,RealName,CreatedTime) values('" + admin.AdminName + "','" + admin.AdminPassword + "','" + admin.RealName + "','" + admin.CreatedTime + "')";
int result = DBHelp.DoSql(sql);
return(result);
}
/// <summary>
/// 修改新闻类型
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public int UpdateNewstype(News_type type)
{
string sql = "update NewsType set news_type_name='" + type.TypeName + "' where news_type_id='" + type.TypeID + "'";
int result = DBHelp.DoSql(sql);
return(result);
}
/// <summary>
/// 修改管理员信息(修改密码)
/// </summary>
/// <param name="admin"></param>
/// <returns></returns>
public int UpdateAdmin(Administrator admin)
{
string sql = "update webHT_Admin set adminPassword='******',RealName='" + admin.RealName + "' where adminID='" + admin.AdminId + "'";
int result = DBHelp.DoSql(sql);
return(result);
}
/// <summary>
/// 添加新闻类型
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public int addNewstype(News_type type)
{
string sql = "insert into NewsType (news_type_name,news_type_createTime,news_type_ParentID) values('" + type.TypeName + "','" + type.Type_createTime + "','" + type.Type_ParentID + "')";
int result = DBHelp.DoSql(sql);
return(result);
}
/// <summary>
/// 根据ID删除新闻类型
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int delectNewsType(int id)
{
string sql = "Delete from NewsType where news_type_id='" + id + "'";
int result = DBHelp.DoSql(sql);
return(result);
}
/// <summary>
/// 根据ID删除新闻
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int delNews(int id)
{
string sql = "Delete from News_detailedList where News_id='" + id + "'";
int result = DBHelp.DoSql(sql);
return(result);
}
/// <summary>
/// 修改新闻
/// </summary>
/// <param name="news"></param>
/// <returns></returns>
public int UpdateNews(News news)
{
string sql = "update News_detailedList set News_title='" + news.NewsTitle + "',News_type='" + news.NewsType + "',News_content='" + news.NewsContent + "',News_sequence='" + news.NewsSequence + "',News_author='" + news.NewsAuthor + "',News_lastModified='" + news.NewsLastModified + "',News_img='" + news.NewsImg + "',News_browseCount='" + news.NewsBrowseCount + "',News_source='" + news.NewsSource + "',News_publishTime='" + news.NewsPublishTime + "',News_isDisplay='" + news.NewsIsDisplay + "' where News_id='" + news.NewsId + "'";
int result = DBHelp.DoSql(sql);
return(result);
}
/// <summary>
/// 添加新闻
/// </summary>
/// <param name="news"></param>
/// <returns></returns>
public int addNews(News news)
{
string sql = "insert into News_detailedList (News_title,News_type,News_content,News_author,News_createTime,News_lastModified,News_img,News_source,News_publishTime) values('" + news.NewsTitle + "','" + news.NewsType + "','" + news.NewsContent + "','" + news.NewsAuthor + "','" + news.NewsCreateTime + "','" + news.NewsLastModified + "','" + news.NewsImg + "','" + news.NewsSource + "','" + news.NewsPublishTime + "')";
int result = DBHelp.DoSql(sql);
return(result);
}