protected void BtnLogin_Click(object sender, EventArgs e) { using (var db = new hackerEntities()) { string password = Hash.SHA512(txtPassword.Value); var query = from ad in db.Admin select ad; var qu = query.SingleOrDefault(p => p.Name == txtID.Value && p.Password == password); if (qu != null) { //HttpCookie cookie = new HttpCookie["sad"]; //cookie.Value = "灌水小鱼"; //Response.AppendCookie(cookie); ////取出Cookie值也很简单 //HttpCookie cookie2 = Request.Cookies["aspcn"]; //cookieValue = cookie.Value; ////在一个Cookie中储存多个信息,那也没有问题。比如在名为aspcn的cookie下加多个信息 //HttpCookie cookie = new HttpCookie("aspcn"); //cookie.Values.Add("webmaster","灌水小鱼"); //cookie.Values.Add("writer","beige"); //cookie.Values.Add("LinkColor","blue"); //Response.AppendCookie(cookie); Session["Log"] = "True"; Response.Redirect("Index.aspx"); } else { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('用户不存在');</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 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 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 Page_Load(object sender, EventArgs e) { string login = Session["Log"].ToString(); if (!Page.IsPostBack) { using (var db = new hackerEntities()) { //分类 ClassList.DataSource = db.VideoClass.ToList(); ClassList.DataValueField = "id"; ClassList.DataTextField = "name"; ClassList.DataBind(); //ClassList.Items.Insert(0, new ListItem("请选择一个分类", "0")); } } }
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 Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //绑定数据; using (var db = new hackerEntities()) { arclass1.DataSource = (from it in db.videoclass1 where it.@class == 1 select it).ToList(); arclass1.DataBind(); arclass2.DataSource = (from it in db.videoclass1 where it.@class == 2 select it).ToList(); arclass2.DataBind(); arclass3.DataSource = (from it in db.videoclass1 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>"); } }
protected void Page_Load(object sender, EventArgs e) { string login = Session["Log"].ToString(); if (!Page.IsPostBack) { //绑定数据; 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 Page_Load(object sender, EventArgs e) { PageList.Items.Clear(); if (!Page.IsPostBack) { using (var db = new hackerEntities()) { //分类 AClass.DataSource = db.articleclass.ToList(); AClass.DataValueField = "id"; AClass.DataTextField = "name"; AClass.DataBind(); AClass.Items.Insert(0, new ListItem("请选择一个分类", "0")); } } //页标 PagedDataSource pds = new PagedDataSource(); using (var db = new hackerEntities()) { 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 != 0) { query = query.Where(a => a.@class == aclas); } query = query.OrderByDescending(a => a.addtime); pds.DataSource = query.ToList(); } pds.AllowPaging = true; pds.PageSize = 1;//每页显示个数在此!!!!!!!!!! int m; for (m = 0; pds.IsLastPage != true; m++) { pds.CurrentPageIndex = m; } if (m != 0) { PageList.Items.Insert(0, new ListItem("请选择", "-1")); for (int i = 1; i <= m; i++) { PageList.Items.Insert(i, new ListItem(i.ToString(), i.ToString())); } PageList.SelectedValue = (n + 1).ToString(); } else { PageList.Items.Insert(0, new ListItem("1", "1")); } if (n == 0) { LastPage.Visible = false; } else { LastPage.Visible = true; } if (n == m - 1 || m == 0) { NextPage.Visible = false; } else { NextPage.Visible = true; } pds.CurrentPageIndex = n; Article.DataSource = pds; Article.DataBind(); }