int getPageCount(int pageSize) //获得总页数 { try { classid = Convert.ToInt32(Request.QueryString["classid"].ToString()); titleBind(classid); } catch { classid = 0; titleBind(classid); } int pageCount = 1; if (Session["pageCount"] == null) { using (var db = new SiewebEntities()) { var se = from it in db.news where it.newclass == classid && it.lang == 0 select it; int totalAmount = se.Count(); pageCount = (int)Math.Ceiling((double)totalAmount / (double)pageSize); //总页数,向上取整 } Session["pageCount"] = pageCount; } else { pageCount = Convert.ToInt32(Session["pageCount"]); } return(pageCount); }
protected void submit_Click(object sender, EventArgs e) { using (var db = new SiewebEntities()) { if (uploadWorkPic1() != null) { var data1 = db.pics.FirstOrDefault(a => a.id == 1); string path1 = uploadWorkPic1(); data1.picname = path1; } if (uploadWorkPic2() != null) { string path2 = uploadWorkPic2(); var data2 = db.pics.FirstOrDefault(a => a.id == 2); data2.picname = path2; } if (uploadWorkPic3() != null) { string path3 = uploadWorkPic3(); var data3 = db.pics.FirstOrDefault(a => a.id == 3); data3.picname = path3; } db.SaveChanges(); bindPic(); } }
int getPageCount(int pageSize) //获得总页数 { int pageCount = 1; if (Session["pageCount"] == null) { try { int viewlevel = Convert.ToInt32(Request.QueryString["viewlevel"].ToString()); using (var db = new SiewebEntities()) { var se = from it in db.files where it.viewlevel == viewlevel && it.lang == 0 select it; int totalAmount = se.Count(); pageCount = (int)Math.Ceiling((double)totalAmount / (double)pageSize); //总页数,向上取整 } Session["pageCount"] = pageCount; } catch { } } else { pageCount = Convert.ToInt32(Session["pageCount"]); } return(pageCount); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int tid = -1; try { tid = Convert.ToInt32(Request.QueryString["tid"].ToString()); using (var db = new SiewebEntities()) { var tea = db.teacher.First(a => a.id == tid); TxtName.Text = tea.tname; TxtDes.Text = tea.describe; TxtEmail.Text = tea.email; TxtPhone.Text = tea.phone.Replace("<br/>", "\n"); TxtTitle.Text = tea.title; TxtPlace.Text = tea.place; editor.InnerHtml = tea.body; } } catch { Response.Redirect("teacherslist.aspx"); } } }
protected news PBind(int i) { news re = new news(); try { using (var db = new SiewebEntities()) { var se = from it in db.news where it.lang == 0 && it.newclass == i orderby it.updatetime descending select it; for (int j = 0; j < se.ToList().Count; j++) { if (se.ToList()[j].listpicture != "") { return(se.ToList()[j]); } } } } catch { re.id = 0; re.listpicture = ""; } return(re); }
int getPageCount(int pageSize) //获得总页数 { string searchInfo; try { searchInfo = Session["searchInfo"].ToString(); int pageCount = 1; if (Session["pageCount"] == null) { using (var db = new SiewebEntities()) { var se = from it in db.news where it.title.Contains(searchInfo) && it.lang == 1 select it; int totalAmount = se.Count(); pageCount = (int)Math.Ceiling((double)totalAmount / (double)pageSize); //总页数,向上取整 } Session["pageCount"] = pageCount; } else { pageCount = Convert.ToInt32(Session["pageCount"]); } return(pageCount); } catch { Response.Redirect("index.aspx"); return(0); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { int pid = Convert.ToInt32(Request.QueryString["pid"].ToString()); using (var db = new SiewebEntities()) { var pa = from it in db.pages where it.id == pid select it; if (pa.ToList().Count == 0) { Response.Redirect("index.aspx"); } else { Rpt.DataSource = pa.ToList(); Rpt.DataBind(); var se = pa.ToList().First(); Session["belong"] = se.belong; } } } catch { Response.Redirect("index.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { int id = 0; try { id = Convert.ToInt32(Session["adid"]); } catch { id = -1; } if (id == -1) { Response.Redirect("../login.aspx"); } else { try { using (var db = new SiewebEntities()) { var ad = db.admins.FirstOrDefault(a => a.id == id); LabName.Text = ad.account; } } catch { Response.Redirect("../login.aspx"); } } }
void ArticlesBind(int CurrentPage, int PageSize) //文章绑定 { string searchInfo; try { searchInfo = Session["searchInfo"].ToString(); using (var db = new SiewebEntities()) { var se = from items in db.news where items.title.Contains(searchInfo) && items.lang == 1 orderby items.id descending select new { items.id, items.title, items.newclass, items.createtime, items.body, items.updatetime }; int totalAmount = se.Count(); if (totalAmount > 0) { Session["pageCount"] = Math.Ceiling((double)totalAmount / (double)PageSize); //总页数,向上取整 lbTotal.Text = Math.Ceiling((double)totalAmount / (double)PageSize).ToString(); se = se.Skip(PageSize * (CurrentPage - 1)).Take(PageSize); //分页 Rpt.DataSource = se.ToList(); Rpt.DataBind(); } else { rep.Visible = false; lbNone.Text = "没有找到与" + Session["searchInfo"].ToString() + "相关的信息"; lbNone.Visible = true; } } } catch { Response.Redirect("index.aspx"); } }
void ArticlesBind(int CurrentPage, int PageSize) //文章绑定 { try { classid = Convert.ToInt32(Request.QueryString["classid"].ToString()); titleBind(classid); } catch { classid = 0; titleBind(classid); } using (var db = new SiewebEntities()) { var se = from items in db.news where items.newclass == classid && items.lang == 0 orderby items.id descending select new { items.id, items.title, items.newclass, items.createtime, items.body, items.updatetime }; int totalAmount = se.Count(); Session["pageCount"] = Math.Ceiling((double)totalAmount / (double)PageSize); //总页数,向上取整 lbTotal.Text = Math.Ceiling((double)totalAmount / (double)PageSize).ToString(); se = se.Skip(PageSize * (CurrentPage - 1)).Take(PageSize); //分页 Rpt.DataSource = se.ToList(); Rpt.DataBind(); } }
protected void BtnOk_Click(object sender, EventArgs e) { int tid = -1; try { tid = Convert.ToInt32(Request.QueryString["tid"].ToString()); using (var db = new SiewebEntities()) { string str = Server.HtmlDecode(editor.InnerHtml); var tea = db.teacher.FirstOrDefault(a => a.id == tid); tea.place = TxtPlace.Text.Trim(); tea.tname = TxtName.Text.Trim(); tea.phone = TxtPhone.Text.Replace("\n", "<br/>"); tea.title = TxtTitle.Text.Trim(); tea.body = str; tea.updatetime = DateTime.Now; tea.describe = TxtDes.Text; tea.email = TxtEmail.Text.Trim(); db.SaveChanges(); Response.Write("<script>alert('修改成功');window.location.href='teacherslist.aspx'</script>"); } } catch { Response.Write("<script>alert('修改失败');window.location.href='teacherslist.aspx'</script>"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Session["belong"] = 0; try { int tid = Convert.ToInt32(Request.QueryString["tid"].ToString()); using (var db = new SiewebEntities()) { var se = from it in db.teacher where it.id == tid select it; if (se.ToList().Count == 0) { Response.Redirect("teachers.aspx"); } Rpt.DataSource = se.ToList(); Rpt.DataBind(); } } catch { Response.Redirect("teachers.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int nid = -1; try { nid = Convert.ToInt32(Request.QueryString["nid"].ToString()); using (var db = new SiewebEntities()) { var se = from it in db.news where it.id == nid && it.lang == 0 select it; news News = db.news.SingleOrDefault(a => a.id == nid); if (se.ToList().Count == 0) { Response.Redirect("newslist.aspx"); } else { addStyle(News.newclass); Rpt.DataSource = se.ToList(); Rpt.DataBind(); } } } catch { Response.Redirect("newslist.aspx"); } } }
void ArticlesBind(int CurrentPage, int PageSize) //文章绑定 { try { int viewlevel = Convert.ToInt32(Request.QueryString["viewlevel"].ToString()); using (var db = new SiewebEntities()) { var se = from items in db.files where items.viewlevel == viewlevel && items.lang == 0 orderby items.createtime descending select new { items.id, items.title, items.filename, items.createtime }; int totalAmount = se.Count(); Session["pageCount"] = Math.Ceiling((double)totalAmount / (double)PageSize); //总页数,向上取整 lbTotal.Text = Math.Ceiling((double)totalAmount / (double)PageSize).ToString(); se = se.Skip(PageSize * (CurrentPage - 1)).Take(PageSize); //分页 Rpt.DataSource = se.ToList(); Rpt.DataBind(); // LtlArticlesCount.Text = totalAmount.ToString(); } } catch { Response.Redirect("index.aspx"); } }
protected void bindTop2() { using (var db = new SiewebEntities()) { var top = from it in db.news where it.lang == 0 && it.toppicture != "" orderby it.updatetime descending select it; RptTop2.DataSource = top.ToList().Take(3); RptTop2.DataBind(); } }
protected void NDataBind(Repeater rp, int i) { using (var db = new SiewebEntities()) { var se = from it in db.news where it.lang == 0 && it.newclass == i orderby it.updatetime descending select it; rp.DataSource = se.Take(8).ToList(); rp.DataBind(); } }
protected void BtnOk_Click(object sender, EventArgs e) { string ver = Session["ValidateNum"].ToString(); if (ver == TxtVer.Text.Trim()) { //以下注释代码为用户注册 // // //using (var db = new SiewebEntities()) //{ // var ve = from it in db.admins // where it.account == TxtAc.Text // select it; // if (ve.LongCount() == 0) // { // var ad = new admins(); // ad.account = TxtAc.Text; // ad.password = PasswordHash.PasswordHash.CreateHash(TxtPas.Text); // ad.createtime = DateTime.Now; // ad.updatetime = DateTime.Now; // db.admins.Add(ad); // db.SaveChanges(); // Response.Write("<script>alert('注册成功')</script>"); // } //} // //用户登录验证 // // using (var db = new SiewebEntities()) { var ad = from it in db.admins where it.account == TxtAc.Text.Trim() select it; var ad2 = ad.ToList(); for (int i = 0; i < ad2.Count; i++) { if (PasswordHash.PasswordHash.ValidatePassword(TxtPas.Text, ad2[i].password)) { Session["adid"] = ad.First().id; Response.Write("<script>alert('登录成功');window.location.href='index.aspx'</script>"); return; } } Response.Write("<script>alert('用户名或密码错误')</script>"); } } else { Response.Write("<script>alert('验证码错误')</script>"); } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (TxtNewPassword.Text.Trim() == "" || TxtNewPassword.Text.Trim() == "") { Response.Write("<script>alert('密码不能为空')</script>"); return; } int flag = 0; int id = Convert.ToInt32(Session["adid"]); try { using (var db = new SiewebEntities()) { var ad = from it in db.admins where it.id == id select it; var ad2 = ad.ToList(); for (int i = 0; i < ad2.Count; i++) { if (PasswordHash.PasswordHash.ValidatePassword(TxtOldPassword.Text, ad2[i].password)) { flag = 1; } } } if (flag == 0) { Response.Write("<script>alert('密码错误')</script>"); } else { using (var db2 = new SiewebEntities()) { //var newad = new admins(); admins newad = db2.admins.SingleOrDefault(a => a.id == id); //new newad.password = PasswordHash.PasswordHash.CreateHash(TxtNewPassword.Text); newad.createtime = newad.createtime; newad.updatetime = DateTime.Now; //db2.admins.Add(newad); db2.SaveChanges(); Session.Clear(); Response.Write("<script>alert('修改成功,请重新登录');location='Login.aspx'</script>"); } } } catch (Exception ex) { Response.Redirect("../Login.aspx"); //Response.Write(ex); } }
protected void bindPic() { using (var db = new SiewebEntities()) { var data = from it in db.pics orderby it.createtime descending select it; ImgCurrentWorkPic1.ImageUrl = data.ToList()[0].picname; ImgCurrentWorkPic2.ImageUrl = data.ToList()[1].picname; ImgCurrentWorkPic3.ImageUrl = data.ToList()[2].picname; } }
protected void bindTop1() { using (var db = new SiewebEntities()) { var se = from it in db.pics select it; //RptTop1.DataSource = se.ToList(); //RptTop1.DataBind(); imgtop1.ImageUrl = "admin/" + se.ToList()[0].picname; imgtop2.ImageUrl = "admin/" + se.ToList()[1].picname; imgtop3.ImageUrl = "admin/" + se.ToList()[2].picname; } }
protected void Rpt_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "del") { int id = Convert.ToInt32(e.CommandArgument); using (var db = new SiewebEntities()) { var fs = db.files.First(a => a.id == id); db.files.Remove(fs); db.SaveChanges(); Response.Write("<script>alert('删除成功');location='files.aspx'</script>"); } } }
protected void Rpt_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "del") { using (var db = new SiewebEntities()) { int nid = Convert.ToInt32(e.CommandArgument.ToString()); var ne = db.news.FirstOrDefault(a => a.id == nid); db.news.Remove(ne); db.SaveChanges(); Response.Write("<script>alert('删除成功');window.location.href='newslist.aspx'</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (var db = new SiewebEntities()) { var fs = from it in db.files where it.lang == 1 orderby it.createtime descending select it; Rpt.DataSource = fs.ToList(); Rpt.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //绑定 using (var db = new SiewebEntities()) { var teas = from it in db.teacher where it.lang == 1 select it; RptTeacher.DataSource = teas.ToList(); RptTeacher.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Session["belong"] = "0"; using (var db = new SiewebEntities()) { var se = from it in db.teacher where it.lang == 0 orderby it.updatetime descending select it; Rpt.DataSource = se.ToList(); Rpt.DataBind(); } } }
protected void BtnOk_Click(object sender, EventArgs e) { using (var db = new SiewebEntities()) { string str = Server.HtmlDecode(editor.InnerHtml); var page = new pages(); page.title = TxtTitle.Text.Trim(); page.body = str; Response.Write("<script>alert('" + str + "');</script>"); page.createtime = DateTime.Now; page.updatetime = DateTime.Now; int belo = Convert.ToInt32(DdlSelect.SelectedValue); page.belong = belo; db.pages.Add(page); db.SaveChanges(); Response.Write("<script>alert('添加成功');</script>"); } }
protected void BtnOk_Click(object sender, EventArgs e) { using (var db = new SiewebEntities()) { var tea = new teacher(); tea.place = TxtPlace.Text.Trim(); tea.tname = TxtName.Text.Trim(); tea.phone = TxtPhone.Text.Replace("\n", "<br/>"); tea.title = TxtTitle.Text.Trim(); tea.body = Server.HtmlDecode(editor.InnerHtml); tea.lang = 1; tea.createtime = DateTime.Now; tea.updatetime = DateTime.Now; tea.describe = TxtDes.Text; tea.email = TxtEmail.Text.Trim(); db.teacher.Add(tea); db.SaveChanges(); Response.Write("<script>alert('添加成功');window.location.href='teacherslist.aspx'</script>"); } }
protected void BtnOk_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { string savePath = Server.MapPath("~/admin/upload/");//指定上传文件在服务器上的保存路径 //检查服务器上是否存在这个物理路径,如果不存在则创建 if (!System.IO.Directory.Exists(savePath)) { System.IO.Directory.CreateDirectory(savePath); } string Extension = Path.GetExtension(FileUpload1.FileName); //获取后缀名 string fname = DateTime.Now.ToString("yyyyMMddHHmmssffff"); //当前时间作为文件名 string finalname = "/admin/upload/" + fname + Extension; //存在数据库中的路径 savePath = savePath + "\\" + fname + Extension; try { FileUpload1.SaveAs(savePath); using (var db = new SiewebEntities()) { var fs = new files(); fs.title = TxtTitle.Text; fs.filename = finalname; fs.lang = 0; fs.createtime = DateTime.Now; fs.viewlevel = Convert.ToInt32(DdlKind.SelectedValue.ToString()); db.files.Add(fs); db.SaveChanges(); Response.Write("<script>alert('添加成功');window.location.href='files.aspx'</script>"); } } catch { Response.Write("<script>alert('添加失败')</script>"); } } else { LabMessage.Text = "你还没有选择上传文件!"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int pageId = 0; try { pageId = Convert.ToInt32(Request.QueryString["pid"].ToString()); using (var db = new SiewebEntities()) { var page = db.pages.First(a => a.id == pageId); LabTitle.Text = page.title; editor.InnerHtml = page.body; } } catch { Response.Redirect("index.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int nid = -1; try { nid = Convert.ToInt32(Request.QueryString["nid"].ToString()); using (var db = new SiewebEntities()) { var ne = db.news.FirstOrDefault(a => a.id == nid); TxtTitle.Text = ne.title; DdlSelect.SelectedValue = ne.newclass.ToString(); editor.InnerHtml = ne.body; } } catch { Response.Redirect("newslist.aspx"); } } }