//注册
public bool Register(Model.User user)
{
string SQL = "select * from news_user where username='******'";
DataSet ds = DBHelper.GetDataSet(SQL);
if (ds.Tables[0].Rows.Count > 0) //存在该记录时
{
HttpContext.Current.Response.Write("<script>alert('用户名已存在，请更换用户名！');</script>");
return(false);
}
else
{
string SQL2 = "insert into news_user values('" + user.username + "','" + user.password + "','" + user.email + "','" + user.realname + "')";
bool iRet = DBHelper.ExecSql(SQL2);
if (iRet)
{
HttpContext.Current.Response.Write("<script>alert('注册成功');location.href='login.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('注册失败');</script>");
return(false);
}
}
}
//更新点击
public bool UpdateClick(Model.News news)
{
string SQL = "update news set click=click+1 where id ='" + news.id + "'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
return(true);
}
else
{
return(false);
}
}
//更新用户信息
public bool Updateinfo(Model.User user)
{
string SQL = "update news_user set email='" + user.email + "',realname='" + user.realname + "' where username='******'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('修改信息失败,请重试');</script>");
return(false);
}
}
//用户更新密码
public bool Updatepwd(Model.User user)
{
string SQL = "update news_user set password='******' where username='******'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('修改密码失败,请重试');</script>");
return(false);
}
}
//删除举报
public bool DelReport(Model.Report report)
{
string SQL = "DELETE from report where newsid='" + report.newsid + "'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
HttpContext.Current.Response.Write("<script>alert('删除成功');location.href='report_check.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('删除失败,请重试');</script>");
return(false);
}
}
//添加举报
public bool AddReport(Model.Report report)
{
string SQL = "insert into report values('" + report.newsid + "','" + report.title + "','" + report.contents + "','" + report.reportTime + "')";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
HttpContext.Current.Response.Write("<script>alert('匿名举报成功！');location.href='../../../main.aspx';</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('举报失败,请重试');</script>");
return(false);
}
}
//删除分类
public bool DelCategory(Model.Category category)
{
string SQL = "DELETE from news_categore where id='" + category.id + "'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
HttpContext.Current.Response.Write("<script>alert('删除成功');location.href='categore.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('删除失败,请重试');</script>");
return(false);
}
}
//添加分类
public bool AddCategory(Model.Category category)
{
string SQL = "insert into news_categore values('" + category.name + "')";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
HttpContext.Current.Response.Write("<script>alert('添加成功');location.href='categore.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('添加失败,请重试');</script>");
return(false);
}
}
//添加新闻
public bool AddNews(Model.News news)
{
string SQL = "insert into news values('" + news.category + "','" + news.title + "','" + news.author + "','" + news.contents + "','" + news.createTime + "','" + news.click + "')";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
HttpContext.Current.Response.Write("<script>alert('添加成功');location.href='choose.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('添加失败,请重试');</script>");
return(false);
}
}
//删除新闻
public bool DelNews(Model.News news)
{
string SQL = "DELETE from news where id='" + news.id + "'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
// HttpContext.Current.Response.Write("<script>alert('删除成功');location.href='choose.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('删除失败,请重试');</script>");
return(false);
}
}
//更新新闻
public bool UpdateNews(Model.News news)
{
string SQL = "update news set category='" + news.category + "',title='" + news.title + "',author='" + news.author + "',contents='" + news.contents + "',createTime='" + news.createTime + "' where id='" + news.id + "'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
HttpContext.Current.Response.Write("<script>alert('更新成功');location.href='choose.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('更新失败,请重试');</script>");
return(false);
}
}
//重置用户密码
public bool UpdateUser(Model.User user)
{
string SQL = "update news_user set password='******' where id='" + user.id + "'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
// HttpContext.Current.Response.Write("<script>alert('重置密码成功,新密码为:123456');location.href='user_management.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('重置密码失败,请重试');</script>");
return(false);
}
}
//删除用户
public bool DelUser(Model.User user)
{
string SQL = "DELETE from news_user where id='" + user.id + "'";
bool iRet = DBHelper.ExecSql(SQL);
if (iRet)
{
HttpContext.Current.Response.Write("<script>alert('删除成功');location.href='user_management.aspx'</script>");
return(true);
}
else
{
HttpContext.Current.Response.Write("<script>alert('删除失败,请重试');</script>");
return(false);
}
}
//添加投稿
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);
}
}
//删除投稿
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);
}
}
