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