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