protected void Button1_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(TextBox1.Text) && !string.IsNullOrWhiteSpace(TextBox2.Text) && !string.IsNullOrWhiteSpace(TextBox3.Text) && !string.IsNullOrWhiteSpace(TextBox4.Text) && !string.IsNullOrWhiteSpace(TextBox5.Text) && !string.IsNullOrWhiteSpace(TextBox6.Text))
{
using (var db = new ItshowEntities2())
{
var changeMem = new Display_admin();
changeMem.Membername = TextBox1.Text;
changeMem.Hobby = TextBox2.Text;
changeMem.Speciality = TextBox3.Text;
changeMem.Experience = TextBox4.Text;
changeMem.Position = TextBox5.Text;
changeMem.Time = TextBox6.Text;
changeMem.Phtograph = Session["Image2"].ToString();
int Vf = db.SaveChanges();
db.SaveChanges();
if (Vf == 1)
{
Response.Write("<script>alert('修改成功');</script>");
}
}
}
else
{
Response.Write("<script>alert('请输入完整的信息');</script>");
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "delete")
{
using (var db = new ItshowEntities2())
{
string workName = e.CommandArgument.ToString();
var workRm = db.Display__works.SingleOrDefault(a => a.Name == workName);
if (workRm == null)
{
Response.Redirect("~/Backstage/Addadmin.aspx");
}
else
{
db.Display__works.Remove(workRm);
int Vf = db.SaveChanges();
db.SaveChanges();
if (Vf == 1)
{
Response.Write("<script>alert('删除成功');</script>");
Response.Write("<script>location.reload()</script>");
}
else
{
Response.Write("<script>alert('删除失败');</script>");
}
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string Code = Session["image"].ToString().Trim(); //验证码
string Txtbox =HttpUtility.HtmlEncode(this.TextBox2.Text).ToString().Trim();
if (TextBox1.Text != "")
{
if (Code == Txtbox.ToUpper())
{
using (var db = new ItshowEntities2())
{
string New_Message;
New_Message = HttpUtility.HtmlEncode(TextBox1.Text);
var guidebook = new Guestbook();
guidebook.Contents = New_Message;
guidebook.Puttime = DateTime.Now.ToString();
db.Guestbooks.Add(guidebook);
db.SaveChanges();
Response.Write("<script>alert('留言提交成功，请耐心等待审核结果！');</script>");
TextBox1.Text = null;
TextBox2.Text = null;
}
}
else
Response.Write("<script>alert('验证码不正确，请重新输入！');</script>");
}
else
Response.Write("<script>alert('主要内容不能为空！');</script>");
}
protected void Button1_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(TextBox1.Text) && !string.IsNullOrWhiteSpace(TextBox2.Text) && !string.IsNullOrWhiteSpace(TextBox3.Text) && !string.IsNullOrWhiteSpace(TextBox4.Text))
{
using (var db = new ItshowEntities2())
{
var changeWord = new Display__works();
changeWord.Name = TextBox1.Text;
changeWord.Contents = TextBox2.Text;
changeWord.Time = TextBox3.Text;
changeWord.Html = TextBox4.Text;
changeWord.Image = Session["Image"].ToString();
int Vf = db.SaveChanges();
db.SaveChanges();
if (Vf == 1)
{
Response.Write("<script>alert('修改成功');</script>");
}
}
}
else
{
Response.Write("<script>alert('请输入完整的信息');</script>");
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Add")
{
TextBox Reply = e.Item.FindControl("Reply") as TextBox;
string reply = Reply.Text;
if (Reply.Visible)
{
if (!string.IsNullOrEmpty(Reply.Text))
{
using (var db = new ItshowEntities2())
{
string replyer = Session["admin"].ToString();
string Head = e.CommandArgument.ToString();
var change = db.Guestbooks.SingleOrDefault(a => a.Headline == Head);
change.Pass = 1;
change.Reply = reply;
change.Replytime = DateTime.Now.ToString();
change.Replyer = replyer;
int Vf = db.SaveChanges();
if (Vf == 1)
{
Response.Write("<script>alert('操作成功');</script>");
}
}
BindGrid();
}
else
{
Response.Write("<script>alert('回复内容不能为空');location.href='#" + "Repeater1_" + Reply.ClientID + "'</script>");
}
}
else
{
Reply.Visible = true;
}
}
if (e.CommandName == "Del")
{
LinkButton Del = e.Item.FindControl("Del") as LinkButton;
using (var db = new ItshowEntities2())
{
string Head = e.CommandArgument.ToString();
var del = db.Guestbooks.SingleOrDefault(a => a.Headline == Head);
db.Guestbooks.Remove(del);
int Vf = db.SaveChanges();
if (Vf == 1)
{
Response.Write("<script>alert('操作成功');</script>");
}
}
BindGrid();
Response.Write("<script>location.href='#" + "Repeater1_" + Del.ClientID + "'</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//CKFinder.FileBrowser _FileBrowser = new CKFinder.FileBrowser();
//_FileBrowser.BasePath = "/ckfinder/";
//_FileBrowser.SetupCKEditor(CKEditor1);
CKFinder.FileBrowser _FileBrowser = new CKFinder.FileBrowser();
_FileBrowser.BasePath = "/ckfinder/";
_FileBrowser.SetupCKEditor(CKEditorControl1);
if (Request.QueryString["Headline"]!= null)
{
string Headline = Request.QueryString["Headline"].ToString();
using (var db = new ItshowEntities2())
{
var newsChange = db.Notices.SingleOrDefault(a => a.Headline == Headline);
TextBox1.Text = newsChange.Headline;
CKEditorControl1.Text = newsChange.Contents;
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (var db = new ItshowEntities2())
{
var joinVf = db.joinTimes.SingleOrDefault(a => a.joinON== 0);
if (joinVf == null)
{
Response.Write("<script>alert('报名已开启');</script>");
}
else {
joinVf.joinON = 1;
int Vf= db.SaveChanges();
if (Vf == 1)
{
Response.Write("<script>alert('成功开启报名');</script>");
}
}
}
}
protected void submit_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(TextBox1.Text) && !string.IsNullOrEmpty(CKEditorControl1.Text))
{
using (var db = new ItshowEntities2())
{
var noticeAdd = new Notice();
noticeAdd.Headline = TextBox1.Text;
noticeAdd.Puttime = DateTime.Now.ToString();
// noticeAdd.Contents = CKEditorControl1.Text;
noticeAdd.Image = "1";
noticeAdd = new Notice
{
Headline = TextBox1.Text,
Puttime = DateTime.Now.ToString(),
Contents = CKEditorControl1.Text,
Image = "1",
};
db.Notices.Add(noticeAdd);
try
{
int Vf = db.SaveChanges(); // 写数据库
db.SaveChanges();
if (Vf == 1)
{
Response.Write("<script>alert('添加成功');</script>");
}
}
catch (DbEntityValidationException Ex)
{
}
// DbEntityValidationException
// Response.Redirect("~/Frontstage/login.aspx");
}
}
else
{
Response.Write("<script>alert('标题和内容不能为空');</script>");
}
}
public void BindGrid()
{
using (var db = new ItshowEntities2())
{
var count = db.Guestbooks.Where(a => a.Pass == 1).Count();
AspNetPager1.RecordCount = count;
var selectmessage = (from mess in db.Guestbooks
where mess.Pass == 1
orderby mess.Puttime
select mess).Skip(AspNetPager1.StartRecordIndex - 1).Take(AspNetPager1.PageSize);
Repeater1.DataSource = selectmessage.ToList();
Repeater1.DataBind();
}
}
public void BindGrid()
{
using (var db = new ItshowEntities2())
{
var count = db.Notices.Count();
AspNetPager1.RecordCount = count;
var selectnews = (from n in db.Notices
orderby n.Puttime
select n).Skip(AspNetPager1.StartRecordIndex - 1).Take(AspNetPager1.PageSize);
Repeater1.DataSource = selectnews.ToList();
Repeater1.DataBind();
Repeater2.DataSource = selectnews.ToList();
Repeater2.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (var db = new ItshowEntities2())
{
if (!IsPostBack)
{
var joinVf = db.Joinus.Where(a => a.ifSeen == 1).Count();
Label2.Text = joinVf.ToString();
Label1.Text = "总访问量："+Application["counter"].ToString();
}
}
}
public void BindGrid()
{
using (var db = new ItshowEntities2())
{
var Count = db.Joinus.Where(a => a.Name != null).Count();
AspNetPager1.RecordCount = Count;
var Join = (from a in db.Joinus
orderby a.Key descending
select a).Skip(AspNetPager1.StartRecordIndex - 1).Take(AspNetPager1.PageSize);
Repeater1.DataSource = Join.ToList();
Repeater1.DataBind();
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
using (var dv = new ItshowEntities2())
{
var ifadd = (from c in dv.joinTimes
orderby c.Key descending
select c.joinON).First();
if (ifadd != 0)
{
if (addName.Text != "" && addSex.Text != "" && addMagor.Text != "" && addPhone.Text != "" && addEmail.Text != ""
&& addIntruduce.Text != "" && DropDownList1.Text != "选择方向")
{
if (AddHelper.IsEmail(addEmail.Text) == false)
Response.Write("<script>alert('邮箱格式不正确，请重新输入'); location.href='ITMain.aspx#joinus'</script>");
else if (addSex.Text != "男" && addSex.Text != "女")
Response.Write("<script>alert('请正确填写性别信息'); location.href='ITMain.aspx#joinus'</script>");
else if (AddHelper.IsPhone(addPhone.Text) == false)
Response.Write("<script>alert('请正确填写手机信息'); location.href='ITMain.aspx#joinus'</script>");
else if (AddHelper.IsName(addName.Text) == false)
Response.Write("<script>alert('请正确填写姓名信息'); location.href='ITMain.aspx#joinus'</script>");
else
{
using (var db = new ItshowEntities2())
{
var joiner = new Joinu();
joiner.Name = HttpUtility.HtmlEncode(addName.Text);
joiner.Sex = HttpUtility.HtmlEncode(addSex.Text);
joiner.Major = HttpUtility.HtmlEncode(addMagor.Text);
joiner.Phonenumber = HttpUtility.HtmlEncode(addPhone.Text);
joiner.E_mail = HttpUtility.HtmlEncode(addEmail.Text);
joiner.Introduce = HttpUtility.HtmlEncode(addIntruduce.Text);
joiner.Direction = DropDownList1.Text;
joiner.ifSeen = 0;
db.Joinus.Add(joiner);
db.SaveChanges();
Response.Write("<script>alert('提交报名信息成功！'); location.href='ITMain.aspx'</script>");
}
}
}
else
Response.Write("<script>alert('关键信息不能为空！'); location.href='ITMain.aspx#joinus'</script>");
}
else
Response.Write("<script>alert('当前时间不是有效的报名时间！'); location.href='ITMain.aspx#joinus'</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(TextBox1.Text) && !string.IsNullOrWhiteSpace(TextBox2.Text) && !string.IsNullOrWhiteSpace(TextBox3.Text) && !string.IsNullOrWhiteSpace(TextBox4.Text) && !string.IsNullOrWhiteSpace(TextBox5.Text) && !string.IsNullOrWhiteSpace(TextBox6.Text) && !string.IsNullOrWhiteSpace(Session["Image2"].ToString ()))
{
using (var db = new ItshowEntities2())
{
var addMember = new Display_admin();
addMember.Membername = TextBox1.Text;
addMember.Hobby = TextBox2.Text;
addMember.Speciality = TextBox3.Text;
addMember.Experience = TextBox4.Text;
addMember.Position = TextBox5.Text;
addMember.Time = TextBox6.Text;
addMember.Phtograph = Session["Image2"].ToString();
addMember = new Display_admin
{
Membername = TextBox1.Text,
Hobby = TextBox2.Text,
Speciality = TextBox3.Text,
Experience = TextBox4.Text,
Position = TextBox5.Text,
Time = TextBox6.Text,
Phtograph = Session["Image2"].ToString(),
};
db.Display_admin.Add(addMember);
int Vf = db.SaveChanges();
db.SaveChanges();
if (Vf == 1)
{
Response.Write("<script>alert('添加成功');</script>");
// Response.Redirect("~/Frontstage/login.aspx");
}
}
}
else
{
Response.Write("<script>alert('请输入完整的信息');</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (var db = new ItshowEntities2())
{
string personName = Request.QueryString["personName"].ToString();
var joinVf = db.Joinus.SingleOrDefault(a => a.Name == personName);
joinVf.ifSeen = 1;
int Vf = db.SaveChanges();
if (Vf == 1)
{
Response.Write("<script>alert('成功');</script>");
}
}
}
public void BindGrid()
{
using (var db = new ItshowEntities2())
{
var Count = db.Admins.Where(a => a.Adminname != null).Count();
AspNetPager1.RecordCount = Count;
var admin = (from a in db.Admins
where a.Adminname.Length > 0
orderby a.Key descending
select a).Skip(AspNetPager1.StartRecordIndex - 1).Take(AspNetPager1.PageSize);
Repeater1.DataSource = admin.ToList();
Repeater1.DataBind();
//Repeater1.DataSource = selectmessage.ToList();
//Repeater1.DataBind();
}
}
protected void submit_passWord_click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(TextBox1.Text) && !string.IsNullOrEmpty(TextBox2.Text))
{
if (TextBox1.Text == TextBox2.Text)
{
using (var db = new ItshowEntities2())
{
string adminName1= Session ["admin"].ToString();
var admin = db.Admins.SingleOrDefault(a => a.Adminname==adminName1 );
admin.Password = EncryptionMD5.EncryptionMD51(TextBox1.Text);
int Vf =db.SaveChanges();
db.SaveChanges();
if (Vf == 1)
{
Response.Write("<script>alert('修改成功');</script>");
}
else
{
Response.Write("<script>alert('修改失败');</script>");
}
}
}
else
{
Response.Write("<script>alert('两次密码输入不一致');</script>");
}
}
else {
Response.Write("<script>alert('请输入完整的密码并确认');</script>");
}
}
protected void submit_Mail_click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(TextBox3.Text))
{
string Mail1=TextBox3.Text;
if (Mail1.Contains("@") && Mail1.Contains(".com") && Mail1.Length >= 5)
{
using (var db = new ItshowEntities2())
{
string adminName1 = Session["admin"].ToString();
var admin = db.Admins.SingleOrDefault(a => a.Adminname == adminName1);
admin.Mail = TextBox3.Text;
int Vf = db.SaveChanges();
db.SaveChanges();
if (Vf == 1)
{
Response.Write("<script>alert('修改成功');</script>");
Mail .Text= TextBox3.Text;
}
else
{
Response.Write("<script>alert('修改失败');</script>");
}
}
}
else
{
Response.Write("<script>alert('请输入合法的邮箱地址');</script>");
}
}
else
{
Response.Write("<script>alert('请输入邮箱地址');</script>");
}
}
public void BindGrid()
{
using (var db = new ItshowEntities2())
{
var Count = db.Display__works.Where(a => a.Name != null).Count();
AspNetPager1.RecordCount = Count;
var Work = (from a in db.Display__works
orderby a.Key descending
select a).Skip(AspNetPager1.StartRecordIndex - 1).Take(AspNetPager1.PageSize);
//articles = db.Articles
// .Where(a => a.Category.Name.Length > 0)
// .OrderByDescending(a => a.PostDate);
Repeater1.DataSource = Work.ToList();
Repeater1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (var db = new ItshowEntities2())
{
string personName=Request.QueryString["personName"].ToString();
var Person = db.Joinus .SingleOrDefault(a => a.Name ==personName );
Label1.Text =Person.Name ;
Label2.Text =Person .Sex ;
Label3.Text = Person .Major ;
Label4.Text = Person .Direction;
Label5.Text =Person .E_mail ;
Label6.Text = Person.Phonenumber ;
Label7.Text =Person .Introduce ;
}
}
}
public void BindGrid()
{
using (var db = new ItshowEntities2())
{ //成员展示
var member = (from m in db.Display_admin
orderby m.Time
select m);
Repeater1.DataSource = member.ToList();
Repeater1.DataBind();
Repeater2.DataSource = member.ToList();
Repeater2.DataBind();
//作品展示
var proshow = (from p in db.Display__works
orderby p.Time
select p);
ProShow.DataSource = proshow.ToList();
ProShow.DataBind();
}
}
public void BindGrid()
{
using (var db = new ItshowEntities2())
{
// 查多个
{
var Count = db.Guestbooks.Where(a => a.Pass == 0).Count();
AspNetPager1.RecordCount = Count;
var selectmessage = (from message in db.Guestbooks
where message.Pass == 0
orderby message.Key descending
select message).Skip(AspNetPager1.StartRecordIndex - 1).Take(AspNetPager1.PageSize);
Repeater1.DataSource = selectmessage.ToList();
Repeater1.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Admin.Text = Session["admin"].ToString ();
using (var db = new ItshowEntities2())
{
var adminMail = db.Admins.SingleOrDefault(a => a.Adminname == Admin.Text);
if (adminMail.Mail.ToString() != null)
{ Mail.Text = adminMail.Mail.ToString(); }
else {
Mail.Text = "您还没有设置邮箱；";
}
}
// Mail.Text = .ToString();
Label1.Text = Session["admin"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (var db = new ItshowEntities2())
{
// 查多个
{
var Work = from a in db.Display__works
orderby a.Key descending
select a;
//articles = db.Articles
// .Where(a => a.Category.Name.Length > 0)
// .OrderByDescending(a => a.PostDate);
Repeater1.DataSource = Work.ToList();
Repeater1.DataBind();
}
}
}
}
//登录确定
protected void submit_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(adminName.Text) && !string.IsNullOrEmpty(passWord.Text))
{
if (!CheckCode())
{
Response.Write("<script>alert('请输入正确的验证码');</script>");
}
else {
using (var db = new ItshowEntities2())
{
string password = EncryptionMD5.EncryptionMD51(passWord.Text);
var adminVf = db.Admins.SingleOrDefault(a => a.Adminname == adminName.Text && a.Password == password);
if (adminVf != null)
{
Session["admin"] = adminName.Text;
Session["passWord"] = password;
Response.Redirect("~/Backstage/adminMessage.aspx");
}
else
{
Response.Write("<script>alert('用户名或密码错误');</script>");
}
}
} }
else
{
Response.Write("<script>alert('请输入完整的用户名或密码');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
if( Request.QueryString["workName"].ToString()!=null )
{
string workName= Request.QueryString["workName"].ToString();
using ( var db =new ItshowEntities2() )
{
var changeWork = db.Display__works.SingleOrDefault(a => a.Name == workName); ;
TextBox1.Text = changeWork.Name;
TextBox2.Text =changeWork.Contents;
TextBox3.Text=changeWork.Time;
TextBox4.Text = changeWork.Html;
Image1.ImageUrl = changeWork.Image;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["memberName"].ToString() != null)
{
string workName = Request.QueryString["memberName"].ToString();
using (var db = new ItshowEntities2())
{
var changeMem= db.Display_admin.SingleOrDefault(a => a.Membername == workName); ;
TextBox1.Text = changeMem.Membername;
TextBox2.Text = changeMem.Hobby;
TextBox3.Text = changeMem.Speciality ;
TextBox4.Text = changeMem.Experience;
TextBox5.Text = changeMem.Position;
TextBox6.Text = changeMem.Time;
Image1.ImageUrl = changeMem.Phtograph;
}
}
}
}
//protected void cancel_Click(object sender, EventArgs e)
//{
// Response.Redirect("~/Backstage/Addadmin.aspx");
//}
protected void submit_Click(object sender, EventArgs e)
{
if (name.Text == "" || password.Text == "" || again.Text == "" || name.Text == null || password.Text == null || again.Text == null)
{
Response.Write("<script>alert('请输入完整的账号密码');</script>");
}
else if (!IsNumAndEnCh(name.Text)&&!IsNumAndEnCh(name.Text))
{
Response.Write("<script>alert('用户名和密码只能由4到8位的字母和数字组成');</script>");
}
else if (name.Text.Length >= 8 && name.Text.Length <= 4 && password.Text.Length >= 8 && password.Text.Length <= 4)
{
Response.Write("<script>alert('用户名和密码只能由4到8位的字母和数字组成');</script>");
}
else if (password.Text != again.Text)
{
Response.Write("<script>alert('请输入一致的密码');</script>");
}
else
{
using (var db = new ItshowEntities2())
{
//var adminVf = from a in db.Admins
// where a.Adminname == name.Text
// select a;
var adminVf = db.Admins.SingleOrDefault(a => a.Adminname == name.Text);
string ADMIN = Session["admin"].ToString();
var adminVf1 = db.Admins.SingleOrDefault(a => a.Adminname == ADMIN);
if (adminVf1.Rank == "2")
{
Response.Write("<script>alert('您的权限不足');</script>");
}
else if (adminVf != null)
{
Response.Write("<script>alert('用户名重复');</script>");
}
else
{
var adminAdd = new Admin();
adminAdd.Adminname = name.Text;
adminAdd.Password = EncryptionMD5.EncryptionMD51(password.Text);
adminAdd.Rank = "2";
// adminAdd.Password = db.ArticleCategories.SingleOrDefault(a => a.ID == 1);
//artilce.CategoryID = db.ArticleCategories.SingleOrDefault(a => a.ID == 1).ID;
adminAdd = new Admin
{
Adminname = name.Text,
Password = EncryptionMD5.EncryptionMD51(password.Text),
Rank = "2",
};
db.Admins.Add(adminAdd);
int Vf = db.SaveChanges();
db.SaveChanges();
if (Vf == 1)
{
Response.Write("<script>alert('添加成功');</script>");
// Response.Redirect("~/Frontstage/login.aspx");
}
// Response.Redirect("~/Frontstage/login.aspx");
}
}
//Response.Write("<script>alert('添加成功');</script>");
//Response.Redirect("~/Frontstage/login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (var db = new ItshowEntities2())
{
// 查多个
{
var Join = from a in db.Joinus
orderby a.Key descending
select a;
Repeater1.DataSource = Join.ToList();
Repeater1.DataBind();
var Count1 = db.Joinus.Where(a => a.Direction == "程序").Count();
Label1 .Text = Count1.ToString ();
var Count2 = db.Joinus.Where(a => a.Direction == "美工").Count();
Label2.Text = Count1.ToString();
var Count3 = db.Joinus.Where(a => a.Direction == "维护").Count();
Label3.Text = Count1.ToString();
var Join1 = from a in db.Joinus
orderby a.Key descending
select a;
GridView1.DataSource = Join1.ToList();
GridView1.DataBind();
}
}
}
}