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