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