protected void btnNewTopicSet_Click(object sender, EventArgs e)
{
if (txtJump2.Text != "" && imgbtnTopic.ImageUrl != "" && myEditor.InnerHtml != "")
{
using (var db = new HuXiuEntities())
{
Topic newTopic = new Topic();
newTopic.topic_name = txtNewTopicName.Text;
newTopic.topic_cover = imgbtnTopic.ImageUrl;
newTopic.topic_content = Server.HtmlDecode(myEditor.InnerHtml);
db.Topic.Add(newTopic);
db.SaveChanges();
}
Response.Write("<script>alert('添加成功！');location='Activity_system.aspx'</script>");
}
else
{
Response.Write("<script>alert('请填写完全！')</script>");
}
}
protected void btnRumor_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["id"].ToString());
if (txtRumorTitle.Text != "" && txtRumorTime.Text != "" && txtRumorHot.Text != "" && txtRumorState.Text != "" && myEditor.InnerHtml != "" && txtRumorLike.Text != "")
{
using (var db = new HuXiuEntities())
{
Rumor rumor = db.Rumor.SingleOrDefault(a => a.rumor_id == id);
rumor.rumor_title = txtRumorTitle.Text;
rumor.rumor_content = Server.HtmlDecode(myEditor.InnerHtml);
rumor.rumor_hot = Convert.ToInt32(txtRumorHot.Text);
rumor.rumor_like = Convert.ToInt32(txtRumorLike.Text);
rumor.rumor_state = Convert.ToInt32(txtRumorState.Text);
rumor.rumor_time = Convert.ToDateTime(txtRumorTime.Text);
db.SaveChanges();
}
}
else
{
Response.Write("<script>alert('请填写完全！')</script>");
}
}
protected void btnRumor_Click(object sender, EventArgs e)
{
if (txtRumorTitle.Text != "" && txtRumorTime.Text != "" && txtRumorHot.Text != "" && txtRumorState.Text != "" && myEditor.InnerHtml != "" && txtRumorLike.Text != "")
{
using (var db = new HuXiuEntities())
{
Rumor rumor = new Rumor();
rumor.rumor_title = txtRumorTitle.Text;
rumor.rumor_content = Server.HtmlDecode(myEditor.InnerHtml);
rumor.rumor_hot = Convert.ToInt32(txtRumorHot.Text);
rumor.rumor_like = Convert.ToInt32(txtRumorLike.Text);
rumor.rumor_state = Convert.ToInt32(txtRumorState.Text);
rumor.rumor_time = Convert.ToDateTime(txtRumorTime.Text);
db.Rumor.Add(rumor);
db.SaveChanges();
}
}
else
{
Response.Write("<script>alert('请填写完全！')</script>");
}
}
/* private DataTable transToDataTable(IQueryable<MyDataInfo> ans)
* {
*
* string[] column = new string[] { "news_id", "news_class", "news_content", "news_cover", "news_title", "news_time", "new_author", "new_column", "news_hot", "news_top" };
* DataTable dt = new DataTable();
* //为新标建立列明
* for (int i = 0; i < column.Length ; i++)
* {
* DataColumn dc = new DataColumn(column[i], Type.GetType("System.String")); //第一个参数 列名，第二个参数 列的类型
* dt.Columns.Add(dc); ///把列添加到新建表中
* }
*
* //向 DT 中添加数据
* foreach (var item in ans)
* {
* DataRow dr = dt.NewRow();
* dr["news_id"] = item.news_id.ToString();
* dr["news_class"] = item.news_class.ToString();
* dr["news_content"] = item.news_content.ToString();
* dr["news_cover"] = item.news_cover.ToString();
* dr["news_title"] = item.news_title.ToString();
* //dr["news_hot"] = item.news_time.ToString();
* dr["new_author"] = item.news_time.ToString();
* dr["new_column"] = item.news_time.ToString();
* dr["news_hot"] = item.news_time.ToString();
* dr["news_top"] = item.news_time.ToString();
* dr["news_time"] = item.news_time.ToString();
* dt.Rows.Add(dr);
* }
* return dt;
* }
*
* public class MyDataInfo
* {
* public int news_id { get; set; }
*
* public string news_title { get; set; }
*
* public string news_content { get; set; }
*
* public DateTime news_time { get; set; }
*
* public int news_top { get; set; }
*
* public string news_cover { get; set; }
*
* public int news_class { get; set; }
*
* public int news_like { get; set; }
*
* public int news_hot { get; set; }
*
* public int new_column { get; set; }
*
* public string new_author { get; set; }
*
* }*/
void DataBindToRepeater(int currentPage)
{
using (var db = new HuXiuEntities())
{
var news = from it in db.News select it;
//news.ToList();
news.ToList();
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = 10;
pds.DataSource = news.ToList();
lbTotal.Text = pds.PageCount.ToString();
pds.CurrentPageIndex = currentPage - 1;
rptNews.DataSource = pds;
rptNews.DataBind();
}
}
protected void btnInterest_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["id"].ToString());
if (txtInterestTitle.Text != "" && txtLike.Text != "" && txtTime.Text != "" && txtUrl.Text != "" && myEditor.InnerHtml != "")
{
using (var db = new HuXiuEntities())
{
Interest interest = db.Interest.SingleOrDefault(a => a.interest_id == id);
interest.interest_title = txtInterestTitle.Text;
interest.interest_like = Convert.ToInt32(txtLike.Text);
interest.interest_time = Convert.ToDateTime(txtTime.Text);
interest.interest_url = txtUrl.Text;
interest.interest_content = Server.HtmlDecode(myEditor.InnerHtml);
db.SaveChanges();
}
}
else
{
Response.Write("<script>alert('请填写完全！')</script>");
}
}
protected void RptDataBind(int currentPage)
{
int class1 = Convert.ToInt32(Session["class1"].ToString());
using (var db = new HuXiuEntities())
{
var datascore = from it in db.Activity select it;
if (Session["class1"] != null && Session["class1"].ToString() != "0")
{
datascore = from it in db.Activity where it.activity_class == class1 select it;
}
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = 5;
pds.DataSource = datascore.ToList();
lbTotal.Text = pds.PageCount.ToString();
pds.CurrentPageIndex = currentPage - 1;//当前页数从零开始，故把接受的数减一
rptActivity.DataSource = pds;
rptActivity.DataBind();
}
}
protected void btnInterestNew_Click(object sender, EventArgs e)
{
if (txtInterstTitle != null && txtUrl != null && myEditor.InnerHtml != null)
{
using (var db = new HuXiuEntities())
{
Interest interest = new Interest();
interest.interest_time = DateTime.Now;
interest.interest_title = txtInterstTitle.Text;
interest.interest_content = Server.HtmlDecode(myEditor.InnerHtml);
interest.interest_url = txtUrl.Text;
db.Interest.Add(interest);
db.SaveChanges();
}
Response.Write("<script>alert('添加成功！');location=Interest_new.aspx</script>");
}
else
{
Response.Write("<script>alert('请填写完全！')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Write("<script>alert('尚未登录!');location='../Login/Login.aspx'</script>");
}
if (!IsPostBack)
{
int id = Convert.ToInt32(Request.QueryString["id"].ToString());
using (var db = new HuXiuEntities())
{
Activity activity = db.Activity.SingleOrDefault(a => a.activity_id == id);
txtTitle.Text = activity.activity_name;
myEditor.InnerHtml = activity.activity_content;
ibtnChangeiamge.ImageUrl = activity.activity_cover;
txtTopicName.Text = activity.activity_topicname;
txtActivityBeginTime.Text = activity.activity_start.ToString();
txtActivityEndTime.Text = activity.activity_end.ToString();
txtCoverLabel.Text = activity.activity_coverlable;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Write("<script>alert('尚未登录!');location='../Login/Login.aspx'</script>");
}
if (!IsPostBack)
{
int id = Convert.ToInt32(Request.QueryString["id"].ToString());
using (var db = new HuXiuEntities())
{
Rumor rumor = db.Rumor.SingleOrDefault(a => a.rumor_id == id);
txtRumorTitle.Text = rumor.rumor_title;
myEditor.InnerHtml = rumor.rumor_content;
txtRumorTime.Text = rumor.rumor_time.ToShortDateString();
txtRumorHot.Text = rumor.rumor_hot.ToString();
txtRumorState.Text = rumor.rumor_state.ToString();
txtRumorLike.Text = rumor.rumor_like.ToString();
}
}
}
void DataBindToRepeater(int currentPage)
{
int id = Convert.ToInt32(Request.QueryString["column_id"].ToString());
using (var db = new HuXiuEntities())
{
var news = from it in db.News where it.news_class == id select it;
news.ToList();
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = 10;
pds.DataSource = news.ToList();
lbTotal.Text = pds.PageCount.ToString();
pds.CurrentPageIndex = currentPage - 1;
rptHave.DataSource = pds;
rptHave.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Write("<script>alert('尚未登录!');location='../Login/Login.aspx'</script>");
}
if (!IsPostBack)
{
using (var db = new HuXiuEntities())
{
int id = Convert.ToInt32(Request.QueryString["column_id"].ToString());
Column column = db.Column.SingleOrDefault(a => a.column_id == id);
txtName.Text = column.column_title;
myEditor.InnerHtml = column.column_content;
var news = from it in db.News where it.new_column == id select it;
rptHave.DataSource = news.ToList();
rptHave.DataBind();
if (news.ToList().Count == 0)
{
divHave.Visible = false;
}
rptNews.DataSource = news.ToList();
rptNews.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Write("<script>alert('尚未登录!');location='../Login/Login.aspx'</script>");
}
if (!IsPostBack)
{
int id = Convert.ToInt32(Request.QueryString["id"].ToString());
using (var db = new HuXiuEntities())
{
Interest interest = db.Interest.SingleOrDefault(a => a.interest_id == id);
txtInterestTitle.Text = interest.interest_title;
myEditor.InnerHtml = interest.interest_content;
txtTime.Text = interest.interest_time.ToString();
txtUrl.Text = interest.interest_url;
txtLike.Text = interest.interest_like.ToString();
}
}
}
protected void RptDataBind(int currentPage)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
using (var db = new HuXiuEntities())
{
var datascore = from it in db.Activity where it.activity_topicid == id select it;
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = 5;
pds.DataSource = datascore.ToList();
lbTotal.Text = pds.PageCount.ToString();
pds.CurrentPageIndex = currentPage - 1;//当前页数从零开始，故把接受的数减一
rptActivity_topic.DataSource = pds;
rptActivity_topic.DataBind();
}
}
protected void BtnFound_Click2(object sender, EventArgs e)
{
Random ran = new Random();
int id = ran.Next(1, 4);
string name = username.Text;
Session["name2"] = name;
using (var db = new HuXiuEntities())
{
Admin admin = db.Admin.SingleOrDefault(a => a.username == name);
if (admin != null)
{
Question question = db.Question.SingleOrDefault(a => a.user_id == admin.id && a.question_id == id);
question1.Text = question.question1;
Session["answer"] = question.answer;
divfoundback2.Visible = false;
divfoundback3.Visible = true;
}
else
{
Response.Write("<script>alert('用户名不正确!')</script>");
}
}
}
protected void BtnFound_Click(object sender, EventArgs e)
{
string username = txtName.Text;
Session["name2"] = username;
string email = txtPho.Text;
using (var db = new HuXiuEntities())
{
Admin admin = db.Admin.SingleOrDefault(a => a.username == txtName.Text && a.email == txtPho.Text);
try
{
if (admin != null)
{
divfoundback1.Visible = false;
divfoundback5.Visible = true;
}
else
{
Response.Write("<script>alert('用户名或邮箱错误！')</script>");
}
}
catch (Exception ex)
{
Response.Write(ex);
}
}
}
protected void btnGetNumber_Click(object sender, EventArgs e)
{
Random rd = new Random();
int number = rd.Next(1000, 10000);
Session["number"] = number;
Session["time"] = DateTime.Now.ToString();
using (var db = new HuXiuEntities())
{
string username = Session["name2"].ToString();
Admin admin = db.Admin.SingleOrDefault(a => a.username == username);
try
{
Library.DAL.Send.Sendemails("*****@*****.**", admin.email, "修改密码", "本次操作验证码为'" + number + "'请在30分钟内完成验证！");
}
catch (Exception ex)
{
Response.Write("<script>alert('未联网');location='../Login/Login.aspx'</script>");
}
}
}
//添加新专题
protected void Unnamed_Click(object sender, EventArgs e)
{
try
{
if (fup.PostedFile.FileName == "")
{
lblInfo.Text = "请选择文件！";
}
else
{
if (!IsAllowedExtension(fup) == false)
{
lblInfo.Text = "上传文件格式不正确！";
}
if (IsAllowedExtension(fup) == true)
{
string filepath = fup.PostedFile.FileName;
string filename = filepath.Substring(filepath.LastIndexOf("\\") + 1);
string serverpath = Server.MapPath("picture/") + filename;
fup.PostedFile.SaveAs(serverpath);
serverpath = "picture/" + filename;
if (txtName.Text == "" || Server.HtmlDecode(myEditor.InnerHtml) == "")
{
Response.Write("<script>alert('输入不能为空！')</script>");
}
else
{
using (var db = new HuXiuEntities())
{
var column = new Column();
column.column_title = txtName.Text;
column.column_content = Server.HtmlDecode(myEditor.InnerHtml);
column.column_cover = serverpath;
column.column_time = DateTime.Now;
db.Column.Add(column);
db.SaveChanges();
}
lblInfo.Text = "上传成功！";
Response.Write("<script>alert('添加成功！');location='Column_Add.aspx'</script>");
}
}
else
{
lblInfo.Text = "请上传图片！";
}
}
}
catch (Exception ex)
{
lblInfo.Text = DateTime.Now.ToString() + "上传发生错误！原因是：" + ex.ToString();
}
}
//修改是否为首页
protected void btnChangeTop_Click(object sender, EventArgs e)
{
int newsid = Convert.ToInt32(Request.QueryString["news_id"]);
using (var db = new HuXiuEntities())
{
News news = db.News.SingleOrDefault(a => a.news_id == newsid);
news.news_top = Convert.ToInt32(radlTop.SelectedValue);
db.SaveChanges();
Response.Write("<script>alert('修改成功！');location='News_Delete.aspx'</script>");
}
}
//修改分类资讯
protected void btnChangeClass_Click(object sender, EventArgs e)
{
int newsid = Convert.ToInt32(Request.QueryString["news_id"]);
using (var db = new HuXiuEntities())
{
News news = db.News.SingleOrDefault(a => a.news_id == newsid);
News_class newsclass = db.News_class.SingleOrDefault(a => a.news_classname == dropClass.SelectedItem.ToString());
news.news_id = newsclass.news_classid;
db.SaveChanges();
Response.Write("<script>alert('修改成功！');location='News_Delete.aspx'</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Write("<script>alert('尚未登录!');location='../Login/Login.aspx'</script>");
}
using (var db = new HuXiuEntities())
{
var newsclass = from it in db.News_class select it;
rptActivity_begin.DataSource = newsclass.ToList();
rptActivity_begin.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Write("<script>alert('尚未登录!');location='../Login/Login.aspx'</script>");
}
if (!IsPostBack)
{
using (var db = new HuXiuEntities())
{
int topid = Convert.ToInt32(Request.QueryString["top_id"].ToString());
Top top = db.Top.SingleOrDefault(a => a.top_id == topid);
imgTop.ImageUrl = top.top_path;
imgCover.ImageUrl = top.top_cover;
News topnews = db.News.SingleOrDefault(a => a.news_id == top.top_news);
lbTitle.Text = topnews.news_title;
string simplify = System.Text.RegularExpressions.Regex.Replace(topnews.news_content, @"<[///!]*?[^<>]*?>", "").Replace("\n", "").Replace(" ", "").Replace("\t", "").Replace("\r", "").Replace(" ", "");
if (simplify.Length > 50)
{
simplify = simplify.Substring(0, 50) + "....";
}
lbContent.Text = simplify;
var news = from it in db.News where it.news_id != top.top_news select it;
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = 10;
pds.DataSource = news.ToList();
lbTotal.Text = pds.PageCount.ToString();
pds.CurrentPageIndex = 1 - 1;
rptNews.DataSource = pds;
rptNews.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Write("<script>alert('尚未登录!');location='../Login/Login.aspx'</script>");
}
using (var db = new HuXiuEntities())
{
var column = from it in db.Column where it.column_id != 1 select it;
rptColumn.DataSource = column.ToList();
rptColumn.DataBind();
DataBindToRepeater(1);
}
}
//删除专题
protected void rptColumn_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
int id = Convert.ToInt32(e.CommandArgument.ToString());
using (var db = new HuXiuEntities())
{
Column column = db.Column.SingleOrDefault(a => a.column_id == id);
db.Column.Remove(column);
db.SaveChanges();
Response.Write("<script>alert('删除成功！');location='Column_Delete.aspx'</script>");
}
}
}
protected void rptNews_ItemCommand(object source, RepeaterCommandEventArgs e)
{
//将资讯添加到专题
if (e.CommandName == "Add")
{
int id = Convert.ToInt32(e.CommandArgument.ToString());
using (var db = new HuXiuEntities())
{
var news = db.News.SingleOrDefault(a => a.news_id == id);
news.new_column = Convert.ToInt32(Request.QueryString["column_id"].ToString());
db.SaveChanges();
Response.Write("<script>alert('添加成功！');location='Column_Delete.aspx'</script>");
}
}
}
//删除资讯
protected void rptNews_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
int newsid = Convert.ToInt32(e.CommandArgument.ToString());
using (var db = new HuXiuEntities())
{
News del = db.News.SingleOrDefault(a => a.news_id == newsid);
db.News.Remove(del);
db.SaveChanges();
//rptNews.DataBind();
Response.Write("<script>alert('删除成功！');location='News_Delete.aspx'</script>");
}
}
}
protected void rptHave_ItemCommand(object source, RepeaterCommandEventArgs e)
{
//将已有资讯从专题中移出
if (e.CommandName == "Delete")
{
int id = Convert.ToInt32(e.CommandArgument.ToString());
using (var db = new HuXiuEntities())
{
News news = db.News.SingleOrDefault(a => a.news_id == id);
news.new_column = 1;
db.SaveChanges();
Response.Write("<script>alert('修改成功！');location='Column_Delete.aspx'</script>");
rptHave.DataBind();
}
}
}
protected void rptActivity_topic_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument.ToString());
if (e.CommandName == "Delete")
{
using (var db = new HuXiuEntities())
{
Activity activity = db.Activity.SingleOrDefault(a => a.activity_id == id);
db.Activity.Remove(activity);
db.SaveChanges();
}
}
}
protected void rptActivity_begin_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument.ToString());
if (e.CommandName == "Delete")
{
using (var db = new HuXiuEntities())
{
Activity activity = db.Activity.SingleOrDefault(a => a.activity_id == id);
db.Activity.Remove(activity);
db.SaveChanges();
}
Response.Write("<script>alert('删除成功！');location='Activity_begin.aspx'</script>");
}
}
protected void lbtDetail_Click(object sender, EventArgs e)
{
using (var db = new HuXiuEntities())
{
int topid = Convert.ToInt32(Request.QueryString["top_id"].ToString());
Top top = db.Top.SingleOrDefault(a => a.top_id == topid);
News topnews = db.News.SingleOrDefault(a => a.news_id == top.top_news);
lbContent.Text = topnews.news_content;
lbtDetail.Visible = false;
lbtBrief.Visible = true;
}
}
//删除资讯
protected void rptNews_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Set")
{
int newsid = Convert.ToInt32(e.CommandArgument.ToString());
int topid = Convert.ToInt32(Request.QueryString["top_id"]);
using (var db = new HuXiuEntities())
{
Top top = db.Top.SingleOrDefault(a => a.top_id == topid);
top.top_news = newsid;
db.SaveChanges();
}
Response.Write("<script>alert('设置成功！');location='Top.aspx'</script>");
}
}
