protected void delete(object sender, RepeaterCommandEventArgs e) { string id = e.CommandName.ToString(); if (id == "delete") { int DeletedID = Convert.ToInt32(e.CommandArgument); int result = 0; try { using (var db = new hackerEntities()) { var Dc = new videoclass1(); Dc = db.videoclass1.SingleOrDefault(a => a.id == DeletedID); db.videoclass1.Remove(Dc); db.SaveChanges(); } result = 1; } catch { } if (result == 1) { Response.Write("<script>alert('删除成功');window.location.href='VideoClass.aspx';</script>"); } else { Response.Write("<script>alert('删除失败');window.location.href='VideoClass.aspx';</script>"); } } }
protected void Select_Click(object sender, EventArgs e) { if (myTitle.Text != "" && ue.Value != "") { using (var db = new hackerEntities()) { var vid = new Video(); vid.Title = myTitle.Text; vid.Author = ""; vid.AddTime = DateTime.Now.ToString(); vid.Class = ClassList.Text; vid.Url = ue.Value; vid.ViewNum = 0; db.Video.Add(vid); db.SaveChanges(); } ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功');</script>"); } else if (myTitle.Text == "" && ue.Value == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('标题不能为空\\n视频不能为空');</script>"); } else if (myTitle.Text == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('标题不能为空');</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('视频不能为空');</script>"); } }
protected void Add_Click(object sender, EventArgs e) { using (var db = new hackerEntities()) { string password = Hash.SHA512(PasswordText.Text); var ad = new Admin(); ad.Account = AccountText.Text; ad.Password = password; ad.Name = NameText.Text; db.Admin.Add(ad); db.SaveChanges(); } ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功');</script>"); }
protected void Select_Click(object sender, EventArgs e) { if (myTitle.Text != "" && Author.Text != "" && ue.Value != "") { using (var db = new hackerEntities()) { var art = new Article(); art.Title = myTitle.Text; art.Author = Author.Text; art.Addtime = DateTime.Now.ToString(); art.Class = ClassList.Text; art.Article1 = ue.Value; art.ViewNum = 0; db.Article.Add(art); db.SaveChanges(); } ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功');</script>"); } else if (myTitle.Text == "" && Author.Text == "" && ue.Value == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('标题不能为空\\n作者不能为空\\n文章不能为空');</script>"); } else if (myTitle.Text == "" && Author.Text == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('标题不能为空\\n作者不能为空');</script>"); } else if (myTitle.Text == "" && ue.Value == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('标题不能为空\\n文章不能为空');</script>"); } else if (Author.Text == "" && ue.Value == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('作者不能为空\\n文章不能为空');</script>"); } else if (myTitle.Text == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('标题不能为空');</script>"); } else if (Author.Text == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('作者不能为空');</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('文章不能为空');</script>"); } }
protected void delete(object sender, RepeaterCommandEventArgs e) { string id = e.CommandName.ToString(); if (id == "delete") { int DeletedID = Convert.ToInt32(e.CommandArgument); int result = 0; try { using (var db = new hackerEntities()) { var Dc = new VideoClass(); Dc = db.VideoClass.SingleOrDefault(a => a.ID == DeletedID); db.VideoClass.Remove(Dc); db.SaveChanges(); } result = 1; } catch { } if (result == 1) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除成功');</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除失败');</script>"); } using (var db = new hackerEntities()) { arclass1.DataSource = (from it in db.VideoClass where it.Class == 1 select it).ToList(); arclass1.DataBind(); arclass2.DataSource = (from it in db.VideoClass where it.Class == 2 select it).ToList(); arclass2.DataBind(); arclass3.DataSource = (from it in db.VideoClass where it.Class == 3 select it).ToList(); arclass3.DataBind(); } } }
protected void AddClass_Click(object sender, EventArgs e) { if (CName.Text.Trim() == "") { Response.Write("<script>alert('类名不能为空')</script>"); } else if (AClass.SelectedItem.Text == "请选择一个专题") { Response.Write("<script>alert('请选择一个专题')</script>"); } else { using (var db = new hackerEntities()) { var vc = new VideoClass(); vc.Name = CName.Text; vc.Class = Convert.ToInt32(AClass.SelectedItem.Value); db.VideoClass.Add(vc); db.SaveChanges(); } using (var db = new hackerEntities()) { arclass1.DataSource = (from it in db.VideoClass where it.Class == 1 select it).ToList(); arclass1.DataBind(); arclass2.DataSource = (from it in db.VideoClass where it.Class == 2 select it).ToList(); arclass2.DataBind(); arclass3.DataSource = (from it in db.VideoClass where it.Class == 3 select it).ToList(); arclass3.DataBind(); } Response.Write("<script>alert('添加成功');window.location.href='VideoClass.aspx';</script>"); } }
protected void AddClass_Click(object sender, EventArgs e) { if (CName.Text.Trim() == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('类名不能为空');</script>"); } else if (AClass.SelectedItem.Text == "请选择一个专题") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请选择一个专题');</script>"); } else { using (var db = new hackerEntities()) { var ac = new ArticleClass(); ac.Name = CName.Text; ac.Class = Convert.ToInt32(AClass.SelectedItem.Value); db.ArticleClass.Add(ac); db.SaveChanges(); } using (var db = new hackerEntities()) { arclass1.DataSource = (from it in db.ArticleClass where it.Class == 1 select it).ToList(); arclass1.DataBind(); arclass2.DataSource = (from it in db.ArticleClass where it.Class == 2 select it).ToList(); arclass2.DataBind(); arclass3.DataSource = (from it in db.ArticleClass where it.Class == 3 select it).ToList(); arclass3.DataBind(); } Response.Write("<script>alert('添加成功')</script>"); } }
protected void Article_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "delete") { if (true) { int id = Convert.ToInt32(e.CommandArgument); using (var db = new hackerEntities()) { Article art = db.Article.FirstOrDefault(p => p.ID == id); db.Article.Remove(art); db.SaveChanges(); ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除成功');</script>"); PagedDataSource pds = new PagedDataSource(); var query = from it in db.Article select it; if (name != "") { query = query.Where(a => a.Title.Contains(name)); } if (author != "") { query = query.Where(a => a.Author.Contains(author)); } if (aclas != "") { query = query.Where(a => a.Class == aclas); } query = query.OrderByDescending(a => a.Addtime); pds.DataSource = query.ToList(); pds.AllowPaging = true; pds.PageSize = 6; Article.DataSource = pds; Article.DataBind(); } } } }
protected void AddClass_Click(object sender, EventArgs e) { if (CName.Text.Trim() == "") { Response.Write("<script>alert('类名不能为空')</script>"); } else if (AClass.SelectedItem.Text == "请选择一个专题") { Response.Write("<script>alert('请选择一个专题')</script>"); } else { using (var db = new hackerEntities()) { var ac = new videoclass1(); ac.name = CName.Text; ac.@class = Convert.ToInt32(AClass.SelectedItem.Value); db.videoclass1.Add(ac); db.SaveChanges(); } Response.Write("<script>alert('添加成功');window.location.href='VideoClass.aspx';</script>"); } }