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