protected void Page_Load(object sender, EventArgs e) { teaid = Convert.ToInt32(Session["teacherid"].ToString()); if (!IsPostBack) { initDDL(); using (var db = new CstwebEntities()) { var tea = db.teachers.FirstOrDefault(a => a.id == teaid); Txtname.Text = tea.name; TxtID.Text = db.accounts.FirstOrDefault(a => a.teacherid == teaid).account; TxtHome.Text = tea.home; Txtfield.Text = tea.field; Txtetc.Text = rstrp(tea.etc); TxtCourse.Text = tea.course; TxtMail.Text = tea.mail; TxtOffice.Text = tea.office; TxtPaper.Text = rstrp(tea.paper); TxtStudy.Text = rstrp(tea.education); TxtReward.Text = rstrp(tea.reward); TxtPartjob.Text = rstrp(tea.parttimejob); TxtProject.Text = rstrp(tea.project); TxtPhone.Text = tea.phone; //DDLLevel.SelectedValue = tea.teacherlevel.ToString(); //DDLTitle.SelectedValue = tea.title.ToString(); ImgIco.ImageUrl = tea.photo; } } }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "del") { using (var db = new CstwebEntities()) { int id = Convert.ToInt32(e.CommandArgument); var le1 = db.lesrelation.Where(a => a.lesson == id).ToList(); try { db.lesrelation.Remove(le1[0]); db.SaveChanges(); } catch { } try { db.lesrelation.Remove(le1[1]); db.SaveChanges(); } catch { } try { db.lesrelation.Remove(le1[2]); db.SaveChanges(); } catch { } lesson les = db.lesson.FirstOrDefault(a => a.id == id); db.lesson.Remove(les); db.SaveChanges(); Response.Write("<script>alert('删除成功');window.location = 'lessons.aspx';</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { try { neid = Convert.ToInt32(Request.QueryString["id"]); if (!IsPostBack) { using (var db = new CstwebEntities()) { news ne = db.news.First <news>(a => a.id == neid); newsclass = ne.@class; TxtTitle.Text = ne.title; myEditor.InnerHtml = ne.body; } } } catch { neid = 0; if (!Int32.TryParse(Request.QueryString["nc"], out newsclass)) { newsclass = 9; } } if (IsPostBack) { newsclass = Convert.ToInt32(DdlNew.SelectedValue); } if (!IsPostBack) { Refresh_DDlclss(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Int32.TryParse(Request.QueryString["page"], out pageNum)) { pageNum = 1; } pageSize = 10; pageCount = getPageCount(pageSize); if (!IsPostBack) { if (pageNum >= pageCount) { pageNum = pageCount; } ArticlesBind(pageNum, pageSize); using (var db = new CstwebEntities()) { var lo = (from it in db.graduate select it).ToList(); RptGame.DataSource = lo; RptGame.DataBind(); } effect(); } }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "del") { using (var db = new CstwebEntities()) { int id = Convert.ToInt32(e.CommandArgument); teachers tea = db.teachers.FirstOrDefault(a => a.id == id); accounts ac = db.accounts.FirstOrDefault(a => a.teacherid == id); db.teachers.Remove(tea); db.accounts.Remove(ac); db.SaveChanges(); Response.Write("<script>alert('删除成功');window.location = 'teachers.aspx';</script>"); } } else if (e.CommandName == "res") { using (var db = new CstwebEntities()) { int id = Convert.ToInt32(e.CommandArgument); accounts ac = db.accounts.FirstOrDefault(a => a.teacherid == id); ac.password = PasswordHash.PasswordHash.CreateHash(ac.account); db.SaveChanges(); Response.Write("<script>alert('重置成功');window.location = 'teachers.aspx';</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (var db = new CstwebEntities()) { var se1 = from it in db.news where it.@class == 14 orderby it.time descending select it; Repeater1.DataSource = se1.Take(7).ToList(); var se2 = from it in db.news where it.@class == 1 orderby it.time descending select it; Repeater2.DataSource = se2.Take(7).ToList(); var se3 = from it in db.news where it.@class == 4 orderby it.time descending select it; Repeater3.DataSource = se3.Take(7).ToList(); Repeater1.DataBind(); Repeater2.DataBind(); Repeater3.DataBind(); } } }
protected void BtnSubmit_Click(object sender, EventArgs e) { if (Txtname.Text.Trim() == "") Response.Write("<script>alert('姓名不能为空')</script>"); else if (TxtMail.Text.Trim() == "") Response.Write("<script>alert('邮箱不能为空')</script>"); else if (TxtGrade.Text.Trim() == "") Response.Write("<script>alert('入学年份不能为空')</script>"); else if (TxtPhone.Text.Trim() == "") Response.Write("<script>alert('国籍不能为空')</script>"); else if (TxtBirth.Text.Trim() == "") Response.Write("<script>alert('出生年月不能为空')</script>"); else if (TxtHome.Text.Trim() == "") Response.Write("<script>alert('毕业院校不能为空')</script>"); else if (TxtMajor.Text.Trim() == "") Response.Write("<script>alert('专业不能为空')</script>"); else using (var db = new CstwebEntities()) { try { if (teaid == 0) { var tea = new exchange(); tea.name = Txtname.Text.Trim(); tea.email = TxtMail.Text.Trim(); tea.photo = ImgIco.ImageUrl.ToString(); tea.major = TxtMajor.Text.Trim(); tea.home = TxtHome.Text.Trim(); tea.birth = TxtBirth.Text.Trim(); tea.grade = TxtGrade.Text.Trim(); tea.nation = TxtPhone.Text.Trim(); string tempstr = Server.HtmlDecode(myEditor.InnerHtml); if (tempstr != "") tea.ect = tempstr; db.exchange.Add(tea); db.SaveChanges(); Response.Write("<script language=javascript>alert('添加成功');window.location = 'exchangelist.aspx';</script>"); } else { exchange tea = db.exchange.First<exchange>(a => a.id == teaid); tea.name = Txtname.Text.Trim(); tea.email = TxtMail.Text.Trim(); tea.photo = ImgIco.ImageUrl.ToString(); tea.major = TxtMajor.Text.Trim(); tea.home = TxtHome.Text.Trim(); tea.birth = TxtBirth.Text.Trim(); tea.grade = TxtGrade.Text.Trim(); tea.nation = TxtPhone.Text.Trim(); string tempstr = Server.HtmlDecode(myEditor.InnerHtml); if (tempstr != "") tea.ect = tempstr; db.SaveChanges(); Response.Write("<script language=javascript>alert('修改成功');window.location = 'exchangelist.aspx';</script>"); } } catch { Response.Write("<script>alert('失败')</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Int16.TryParse(Request.QueryString["co"], out neid)) { neid = 1; } if (neid <= 0 && neid > 2) { neid = 1; } if (!Int32.TryParse(Request.QueryString["page"], out pageNum)) { pageNum = 1; } pageSize = 10; pageCount = getPageCount(pageSize); if (!IsPostBack) { if (pageNum >= pageCount) { pageNum = pageCount; } ArticlesBind(pageNum, pageSize); using (var db = new CstwebEntities()) { var lo = (from it in db.cooperation where it.@class == neid select it).ToList(); RptGame.DataSource = lo; RptGame.DataBind(); } effect(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { neid = Convert.ToInt16(Request.QueryString["cooperation"]); } catch { neid = 1; } int currentPage = 1; int pageSize = 10; Session["pagenum"] = 1; ArticlesBind(currentPage, pageSize); } using (var db = new CstwebEntities()) { var lo = (from it in db.cooperation where it.@class == neid select it).ToList(); RptGame.DataSource = lo; RptGame.DataBind(); } effect(); }
protected void BtnSubmit_Click(object sender, EventArgs e) { using (var db = new CstwebEntities()) { try { news new1 = db.news.FirstOrDefault(a => a.@class == 0); new1.title = TxtTitle.Text; new1.body = myEditor.InnerText; new1.time = DateTime.Now; db.SaveChanges(); Response.Write("<script language=javascript>alert('修改成功');window.location = 'introduce.aspx';</script>"); } catch { news new1 = new news(); new1.title = TxtTitle.Text; new1.body = myEditor.InnerText; new1.time = DateTime.Now; new1.@class = 0; db.news.Add(new1); db.SaveChanges(); Response.Write("<script language=javascript>alert('修改成功');window.location = 'introduce.aspx';</script>"); } } }
protected void BtnSubmit_Click(object sender, EventArgs e) { using (var db = new CstwebEntities()) { try { news new1 = db.news.FirstOrDefault(a => a.@class == 5); new1.title = TxtTitle.Text; new1.body = myEditor.InnerText; new1.time = DateTime.Now; db.SaveChanges(); Response.Write("<script language=javascript>alert('修改成功');window.location = 'training.aspx';</script>"); } catch { news new1 = new news(); new1.title = TxtTitle.Text; new1.body = myEditor.InnerText; new1.time = DateTime.Now; new1.@class = 5; db.news.Add(new1); db.SaveChanges(); Response.Write("<script language=javascript>alert('修改成功');window.location = 'training.aspx';</script>"); } } }
protected void FindSession() { try { using (var db = new CstwebEntities()) { lesson les = (lesson)Session["less"]; TxtLessonName.Text = les.classname; TxtTeach.Text = les.teach.ToString(); TxtExp.Text = les.experiment.ToString(); TxtCredits.Text = les.credits.ToString(); DDLClass.SelectedValue = les.lesscla.ToString(); int id; if (Session["First1"] == null) { Label1.Text = "0"; LinFirst1.Text = "先修课程1"; } else { Label1.Text = Session["First1"].ToString(); id = Convert.ToInt32(Label1.Text); LinFirst1.Text = db.lesson.First(a => a.id == id).classname.ToString();; } if (Session["First2"] == null) { LinFirst2.Text = "先修课程2"; Label2.Text = "0"; } else { Label2.Text = Session["First2"].ToString(); id = Convert.ToInt32(Label2.Text); LinFirst2.Text = db.lesson.First(a => a.id == id).classname.ToString();; } if (Session["First3"] == null) { LinFirst3.Text = "先修课程3"; Label3.Text = "0"; } else { Label3.Text = Session["First3"].ToString(); id = Convert.ToInt32(Label3.Text); LinFirst3.Text = db.lesson.First(a => a.id == id).classname.ToString();; } Session["FList"] = null; Session["Less"] = null; Session["First1"] = null; Session["First2"] = null; Session["First3"] = null; } } catch { } }
protected void FindSession() { try { using (var db = new CstwebEntities()) { lesson les = (lesson)Session["less"]; TxtLessonName.Text = les.classname; TxtTeach.Text = les.teach.ToString(); TxtExp.Text = les.experiment.ToString(); TxtCredits.Text = les.credits.ToString(); DDLClass.SelectedValue = les.lesscla.ToString(); int id; if (Session["First1"] == null) { Label1.Text = "0"; LinFirst1.Text = "先修课程1"; } else { Label1.Text = Session["First1"].ToString(); id = Convert.ToInt32(Label1.Text); LinFirst1.Text = db.lesson.First(a => a.id == id).classname.ToString(); ; } if (Session["First2"] == null) { LinFirst2.Text = "先修课程2"; Label2.Text = "0"; } else { Label2.Text = Session["First2"].ToString(); id = Convert.ToInt32(Label2.Text); LinFirst2.Text = db.lesson.First(a => a.id == id).classname.ToString(); ; } if (Session["First3"] == null) { LinFirst3.Text = "先修课程3"; Label3.Text = "0"; } else { Label3.Text = Session["First3"].ToString(); id = Convert.ToInt32(Label3.Text); LinFirst3.Text = db.lesson.First(a => a.id == id).classname.ToString(); ; } Session["FList"] = null; Session["Less"] = null; Session["First1"] = null; Session["First2"] = null; Session["First3"] = null; } } catch { } }
protected void databind() { using (var db = new CstwebEntities()) { var se = from it in db.friends select it; Repeater1.DataSource = se.ToList(); Repeater1.DataBind(); } }
protected void BtnSubmit_Click(object sender, EventArgs e) { if (Txtname.Text.Trim() == "") Response.Write("<script>alert('姓名不能为空')</script>"); else if (TxtMail.Text.Trim() == "") Response.Write("<script>alert('邮箱不能为空')</script>"); else if (TxtOffice.Text.Trim() == "") Response.Write("<script>alert('办公室地址不能为空')</script>"); else if (TxtPhone.Text.Trim() == "") Response.Write("<script>alert('办公室电话不能为空')</script>"); else if (Txtfield.Text.Trim() == "") Response.Write("<script>alert('研究领域不能为空')</script>"); else if (TxtCourse.Text.Trim() == "") Response.Write("<script>alert('教授课程不能为空')</script>"); else if (TxtID.Text.Trim() == "") Response.Write("<script>alert('教工号不能为空')</script>"); else using (var db = new CstwebEntities()) { try { teachers tea = db.teachers.First<teachers>(a => a.id == teaid); tea.name = Txtname.Text.Trim(); tea.mail = TxtMail.Text.Trim(); tea.office = TxtOffice.Text.Trim(); tea.photo = ImgIco.ImageUrl.ToString(); tea.phone = TxtPhone.Text.Trim(); tea.field = Txtfield.Text.Trim(); tea.course = TxtCourse.Text.Trim(); //int i = Convert.ToInt32(DDLLevel.SelectedValue); //tea.teacherlevel = i; //i = Convert.ToInt32(DDLTitle.SelectedValue); //tea.title = i; if (Txtetc.Text.Trim() != "") tea.etc = strp(Txtetc.Text.Trim()); //else tea.etc = null; if (TxtHome.Text.Trim() != "") tea.home = TxtHome.Text.Trim(); //else tea.home = null; if (TxtStudy.Text.Trim() != "") tea.education = strp(TxtStudy.Text.Trim()); //else tea.education = null; if (TxtReward.Text.Trim() != "") tea.reward = strp(TxtReward.Text.Trim()); //else tea.reward = null; if (TxtPartjob.Text.Trim() != "") tea.parttimejob = strp(TxtPartjob.Text.Trim()); //else tea.parttimejob = null; if (TxtPaper.Text.Trim() != "") tea.paper = strp(TxtPaper.Text.Trim()); //else tea.paper = null; if (TxtProject.Text.Trim() != "") tea.project = strp(TxtProject.Text.Trim()); //else tea.project = null; tea.time = System.DateTime.Now; db.SaveChanges(); Response.Write("<script language=javascript>alert('修改成功');window.location = 'index2.aspx';</script>"); } catch { Response.Write("<script>alert('失败')</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { using (var db = new CstwebEntities()) { var se = from it in db.friends orderby it.id descending select it; rpt1.DataSource = se.ToList(); rpt1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack){ using (var db = new CstwebEntities()) { var data = from it in db.labs select it; Repeater1.DataSource = data.ToList(); Repeater1.DataBind(); } } }
protected void databind2(int i, Repeater rpt1) { using (var db = new CstwebEntities()) { var t = from it in db.teachers where it.teacherlevel == i orderby it.name select it; rpt1.DataSource = t.ToList(); rpt1.DataBind(); } }
protected void BtnSubmit_Click(object sender, EventArgs e) { string str = Server.HtmlDecode(myEditor.InnerHtml); if (TxtTitle.Text.Trim() == "") { Response.Write("<script>alert('标题不能为空')</script>"); } else if (str.Trim() == "") { Response.Write("<script>alert('文章不能为空')</script>"); } else { try { using (var db = new CstwebEntities()) { games ne; if (neid == 0) { ne = new games(); } else { ne = db.games.First <games>(a => a.id == neid); } ne.gamename = TxtTitle.Text.Trim(); ne.body = str.Trim(); ne.addtime = DateTime.Now; int status = Convert.ToInt16(DdlStatus.SelectedValue); ne.status = status; if (neid == 0) { db.games.Add(ne); db.SaveChanges(); Response.Write("<script language=javascript>alert('发布成功');window.location = 'games.aspx';</script>"); } else { db.SaveChanges(); Response.Write("<script language=javascript>alert('修改成功');window.location = 'games.aspx';</script>"); } } } catch { Response.Write("<script>alert('失败')</script>"); } } }
protected void initDDL() { using (var db = new CstwebEntities()) { var d1 = (from it in db.lesclass select it).ToList(); int i = 0; for (i = 0; i < d1.Count; i++) { DDLClass.Items.Add(new ListItem(d1[i].name, d1[i].id.ToString())); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (var db = new CstwebEntities()) { var data = from it in db.labs select it; Repeater1.DataSource = data.ToList(); Repeater1.DataBind(); } } }
protected void BtnSubmit_Click(object sender, EventArgs e) { string str = Server.HtmlDecode(myEditor.InnerHtml); if (TxtTitle.Text.Trim() == "") { Response.Write("<script>alert('标题不能为空')</script>"); } else if (str.Trim() == "") { Response.Write("<script>alert('文章不能为空')</script>"); } else { try { using (var db = new CstwebEntities()) { news ne; if (neid == 0) { ne = new news(); } else { ne = db.news.First <news>(a => a.id == neid); } ne.title = TxtTitle.Text.Trim(); ne.body = str.Trim(); ne.@class = Convert.ToInt32(DdlNew.SelectedValue); ne.time = DateTime.Now; if (neid == 0) { db.news.Add(ne); db.SaveChanges(); Response.Write("<script language=javascript>alert('发布成功');window.location = 'wanttednews.aspx?nc=" + newsclass.ToString() + "';</script>"); } else { db.SaveChanges(); Response.Write("<script language=javascript>alert('修改成功');window.location = 'wanttednews.aspx?nc=" + newsclass.ToString() + "';</script>"); } } } catch { Response.Write("<script>alert('失败')</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (var db = new CstwebEntities()) { var t = from it in db.teachers where it.title == 1 orderby it.name select it; RptTitle1.DataSource = t.ToList(); RptTitle1.DataBind(); } using (var db = new CstwebEntities()) { var t = from it in db.teachers where it.title == 2 || it.title == 4 || it.title == 5 orderby it.name select it; RptTitle2.DataSource = t.ToList(); RptTitle2.DataBind(); } using (var db = new CstwebEntities()) { var t = from it in db.teachers where it.title == 3 || it.title == 6 || it.title == 7 orderby it.name select it; RptTitle3.DataSource = t.ToList(); RptTitle3.DataBind(); } using (var db = new CstwebEntities()) { var t = from it in db.teachers where it.title == 12 || it.title == 13 orderby it.name select it; RptTitle8.DataSource = t.ToList(); RptTitle8.DataBind(); } using (var db = new CstwebEntities()) { var a= from it in db.teachers orderby it.time descending select it.time; LBLTime.Text = a.First().ToString("yyyy年MM月dd日"); } } }
protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { using (var db = new CstwebEntities()) { var re = from it in db.news where it.@class == 0 select it; Repeater1.DataSource = re.ToList(); Repeater1.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { initDDL(); using (var db = new CstwebEntities()) { var s = from it in db.lessonandclass select it; Repeater1.DataSource = s.ToList(); Repeater1.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { databind2(2, RptLevel2); using (var db = new CstwebEntities()) { var a = from it in db.teachers orderby it.time descending select it.time; LBLTime.Text = a.First().ToString("yyyy年MM月dd日"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (var db = new CstwebEntities()) { var re = from it in db.news where it.@class == 5 select it; Repeater1.DataSource = re.ToList(); Repeater1.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (var db = new CstwebEntities()) { var a = from it in db.exchange orderby it.grade descending select it; Repeater1.DataSource = a.ToList(); Repeater1.DataBind(); } } }
protected void BtnSubmit_Click(object sender, EventArgs e) { using (var db = new CstwebEntities()) { int id = Convert.ToInt16(Session["teacherid"].ToString()); accounts ac = db.accounts.FirstOrDefault(a => a.teacherid == id); if (PasswordHash.PasswordHash.ValidatePassword(TxtOldPw.Text, ac.password)) { string str = PasswordHash.PasswordHash.CreateHash(NewPw1.Text); ac.password = str; db.SaveChanges(); Response.Write("<script>alert('修改成功')</script>"); } } }
protected void BtnSubmit_Click(object sender, EventArgs e) { using (var db = new CstwebEntities()) { int id = Convert.ToInt16(Session["admin"].ToString()); accounts ac = db.accounts.FirstOrDefault(a => a.id == id); if (PasswordHash.PasswordHash.ValidatePassword(TxtOldPw.Text, ac.password)) { string str = PasswordHash.PasswordHash.CreateHash(NewPw1.Text); ac.password = str; db.SaveChanges(); Response.Write("<script>alert('修改成功')</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { databind2(2, RptLevel2); using (var db = new CstwebEntities()) { var a= from it in db.teachers orderby it.time descending select it.time; LBLTime.Text = a.First().ToString("yyyy年MM月dd日"); } } }
protected void initDDL() { DDLClass.Items.Add(new ListItem("全部", "0")); using (var db = new CstwebEntities()) { var d1 = (from it in db.lesclass select it).ToList(); int i = 0; for (i = 0; i < d1.Count; i++) { DDLClass.Items.Add(new ListItem(d1[i].name, d1[i].id.ToString())); } } }
void ArticlesBind(int CurrentPage, int PageSize) //文章绑定 { using (var db = new CstwebEntities()) { var dataSource = from items in db.news where items.@class == artclass orderby items.id descending select new { items.id, items.title, items.time }; int totalAmount = dataSource.Count(); Session["pageCount"] = Math.Ceiling((double)totalAmount / (double)PageSize); //总页数,向上取整 dataSource = dataSource.Skip(PageSize * (CurrentPage - 1)).Take(PageSize); //分页 Repeater1.DataSource = dataSource.ToList(); Repeater1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (var db = new CstwebEntities()) { var a= from it in db.exchange orderby it.grade descending select it; Repeater1.DataSource = a.ToList(); Repeater1.DataBind(); } } }
protected void FindQuery() { try { int id = Convert.ToInt32(Request.QueryString["id"]); Session["lessonID"] = id.ToString(); using (var db = new CstwebEntities()) { lesson les = db.lesson.First(a => a.id == id); TxtLessonName.Text = les.classname; TxtTeach.Text = les.teach.ToString(); TxtExp.Text = les.experiment.ToString(); TxtCredits.Text = les.credits.ToString(); try { LblFilename.Text = les.lesfile; } catch { } myEditor.InnerHtml = les.etc; DDLClass.SelectedValue = les.lesclass.ToString(); var less = db.lesrelation.Where(a => a.lesson == id).ToList(); try { id = Convert.ToInt32(less[0].firstlesson); Label1.Text = id.ToString(); LinFirst1.Text = db.lesson.First(a => a.id == id).classname; try { id = Convert.ToInt32(less[1].firstlesson); Label2.Text = id.ToString(); LinFirst2.Text = db.lesson.First(a => a.id == id).classname; try { id = Convert.ToInt32(less[2].firstlesson); Label3.Text = id.ToString(); LinFirst3.Text = db.lesson.First(a => a.id == id).classname; } catch { } } catch { } } catch { } } } catch { } }
void ArticlesBind(int CurrentPage, int PageSize) //文章绑定 { using (var db = new CstwebEntities()) { var dataSource = from items in db.graduate orderby items.id descending select new { items.id, items.graduate1, items.addtime }; int totalAmount = dataSource.Count(); Session["pageCount"] = Math.Ceiling((double)totalAmount / (double)PageSize); //总页数,向上取整 dataSource = dataSource.Skip(PageSize * (CurrentPage - 1)).Take(PageSize); //分页 Repeater1.DataSource = dataSource.ToList(); Repeater1.DataBind(); LtlArticlesCount.Text = totalAmount.ToString(); } }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "del") { using (var db = new CstwebEntities()) { int id = Convert.ToInt32(e.CommandArgument); friends tea = db.friends.FirstOrDefault(a => a.id == id); db.friends.Remove(tea); db.SaveChanges(); Response.Write("<script>alert('删除成功');window.location = 'friendslist.aspx';</script>"); } } }
int getPageCount(int pageSize) //获得总页数 { using (var db = new CstwebEntities()) { var dataSource = from items in db.labs orderby items.id select new { items }; int totalAmount = dataSource.Count(); pageCount = (int)Math.Ceiling((double)totalAmount / (double)pageSize); //总页数,向上取整 } if (pageCount <= 0) { pageCount = 1; } return(pageCount); }
protected void Page_Load(object sender, EventArgs e) { try{ int id = Convert.ToInt32(Request.QueryString["id"]); using (var db = new CstwebEntities()) { var ne = from it in db.games where it.id == id select it; Repeater1.DataSource = ne.ToList(); Repeater1.DataBind(); } }catch { Response.Redirect("games-list.aspx"); } }
protected void BtnSubmit_Click(object sender, EventArgs e) { if (TxtAccount.Text.Trim() == "") { Response.Write("<script>alert('用户名不能为空')</script>"); } else if (TxtPassword.Text.Trim() == "") { Response.Write("<script>alert('密码不能为空')</script>"); } else { using (var db = new CstwebEntities()) { try { accounts ac = db.accounts.FirstOrDefault(a => a.account == TxtAccount.Text.Trim()); if (PasswordHash.PasswordHash.ValidatePassword(TxtPassword.Text.Trim(), ac.password)) { if (ac.accountlevel == 0) { Session["admin"] = ac.id; Response.Write("<script language=javascript>window.location = 'index.aspx';</script>"); } else if (ac.accountlevel == 1) { Session["teacherid"] = ac.teacherid; Response.Write("<script language=javascript>window.location = 'index2.aspx';</script>"); } else { Response.Write("<script>alert(用户名或密码错误)</script>"); } } else { Response.Write("<script>alert('用户名或密码错误')</script>"); } } catch { Response.Write("<script>alert('用户名或密码错误')</script>"); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (var db = new CstwebEntities()) { try { news new1 = db.news.FirstOrDefault(a => a.@class == 5); TxtTitle.Text = new1.title; myEditor.InnerText = new1.body; } catch { } } } }
void ArticlesBind(int CurrentPage, int PageSize) //文章绑定 { using (var db = new CstwebEntities()) { var dataSource = from items in db.labs orderby items.id descending select new { items.id, items.labname, items.addtime }; int totalAmount = dataSource.Count(); pageCount = (int)Math.Ceiling((double)totalAmount / (double)PageSize); //总页数,向上取整 dataSource = dataSource.Skip(PageSize * (CurrentPage - 1)).Take(PageSize); //分页 if (totalAmount != 0) { Repeater1.DataSource = dataSource.ToList(); Repeater1.DataBind(); } LtlArticlesCount.Text = totalAmount.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { try{ int id = Convert.ToInt32(Request.QueryString["id"]); using (var db = new CstwebEntities()) { var ne = from it in db.games where it.id == id select it; Repeater1.DataSource=ne.ToList(); Repeater1.DataBind(); } }catch{ Response.Redirect("games-list.aspx"); } }
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { int id = Convert.ToInt32(e.CommandArgument); if (e.CommandName == "del") { using (var db = new CstwebEntities()) { try { news ne = db.news.FirstOrDefault<news>(a => a.id == id); db.news.Remove(ne); db.SaveChanges(); Response.Write("<script>alert('删除成功');window.location = 'graduatenews.aspx';</script>"); } catch { Response.Write("<script>alert('删除失败')</script>"); } } } }
void ArticlesBind(int CurrentPage, int PageSize) //文章绑定 { using (var db = new CstwebEntities()) { var dataSource = from items in db.news where items.@class == neid + 6 orderby items.id descending select new { items.id, items.title, items.time }; int totalAmount = dataSource.Count(); pageCount = (int)Math.Ceiling((double)totalAmount / (double)PageSize); //总页数,向上取整 dataSource = dataSource.Skip(PageSize * (CurrentPage - 1)).Take(PageSize); //分页 if (totalAmount != 0) { Repeater1.DataSource = dataSource.ToList(); Repeater1.DataBind(); } } }
protected void databind(int i, Repeater r1) { using (var db = new CstwebEntities()) { var se = (from it in db.lesson where it.lesscla == i select it).ToList(); List <course1> co = new List <course1>(); course1 cour; string first = ""; foreach (lesson less in se) { cour = new course1(); cour.id = less.id; cour.lesscla = less.lesscla; cour.teach = less.teach; cour.experiment = less.experiment; cour.credits = less.credits; cour.classname = less.classname; var rela = (from it in db.lesrelation where it.lesson == less.id select it).ToList(); foreach (lesrelation le in rela) { first += db.lesson.First(a => a.id == le.firstlesson).classname + "、"; } if (first == "") { first = "无"; } else { first = first.Substring(0, first.Length - 1); } cour.first = first; co.Add(cour); first = ""; } r1.DataSource = co; r1.DataBind(); } }
protected void initDDL() { using (var db = new CstwebEntities()) { var d1 = (from it in db.title select it).ToList(); var d2 = (from it in db.teachlevel select it).ToList(); int i = 0; /*for (i = 0; i < d1.Count; i++) { DDLTitle.Items.Add(new ListItem(d1[i].name, d1[i].id.ToString())); } for (i = 0; i < d2.Count; i++) { DDLLevel.Items.Add(new ListItem(d2[i].name, d2[i].id.ToString())); }*/ } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (var db = new CstwebEntities()) { try { news new1 = db.news.FirstOrDefault(a => a.@class == 0); TxtTitle.Text = new1.title; myEditor.InnerText = new1.body; } catch { } } } }
protected void databind(int i, Repeater r1) { using (var db = new CstwebEntities()) { var se = (from it in db.lesson where it.lesscla == i select it).ToList(); List<course1> co = new List<course1>(); course1 cour; string first = ""; foreach (lesson less in se) { cour = new course1(); cour.id = less.id; cour.lesscla = less.lesscla; cour.teach = less.teach; cour.experiment = less.experiment; cour.credits = less.credits; cour.classname = less.classname; var rela = (from it in db.lesrelation where it.lesson == less.id select it).ToList(); foreach (lesrelation le in rela) { first += db.lesson.First(a => a.id == le.firstlesson).classname +"、"; } if (first == "") { first = "无"; } else first = first.Substring(0, first.Length - 1); cour.first = first; co.Add(cour); first = ""; } r1.DataSource = co; r1.DataBind(); } }