protected void ddlclass_SelectedIndexChanged(object sender, EventArgs e)
{
assen = new ASSEntities();
if (ddl_class.SelectedValue == "0")
{
panel_gv.Visible = false;
panel_nul.Visible = true;
//重置两个列表
DdlCourseLoad(0);
DdlAssLoad(0, 0);
}
else
{
panel_gv.Visible = true;
panel_nul.Visible = false;
try
{
int classid = int.Parse(ddl_class.SelectedValue);
LoadPosted(classid, 0, 0);
LoadNotPost(classid, 0, 0);
//加载进一步分类的DDL -- CourseID
DdlCourseLoad(classid);
//清空DDLAss
DdlAssLoad(0, 0);
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
}
protected void btn_ReUpload_Click(object sender, EventArgs e)
{
ASSEntities assen_repost = new ASSEntities();
//处理已上传的文件
int relatedupAssID = int.Parse(ddl_reload.SelectedValue);
var result = (from s in assen.UpAssignments
where s.UpAssID == relatedupAssID
select s).First();
string OldFilenameWithPath = Server.MapPath(@"../Uploads/Students/" + stuID.ToString() + @"/") + result.FileName;
try
{
File.Delete(OldFilenameWithPath);
}
catch (Exception ex)
{
throw new Exception(ex.ToString() + "原有提交的作业不存在");
}
//处理上传(重新上传)
string fileExt;
string FileNameWithExt;
string FileUrl;
if (file_repost.HasFile)
{
fileExt = Path.GetExtension(file_repost.FileName);
if (fileExt == ".rar" || fileExt == ".zip")
{
try
{
file_repost.SaveAs(Server.MapPath(@"..\Uploads\Students\") + stuID.ToString() + @"\" + file_repost.FileName);
FileNameWithExt = Path.GetFileName(file_repost.FileName);
FileUrl = @"../Uploads/Students/" + stuID.ToString() + @"/" + file_repost.FileName;
//重新上传完毕，将修改信息保存到数据库
var final = assen_repost.UpAssignments.Where(ua => ua.UpAssID == relatedupAssID).First();
final.FileName = FileNameWithExt;
final.FileUrl = FileUrl;
assen_repost.SaveChanges();
lb_ReSuccess.Text = "重新上传成功！";
}
catch (Exception ex)
{
lb_ReSuccess.Text = "发生错误：" + ex.Message.ToString();
}
}
else
{
lb_ReSuccess.Text = "只允许上传rar、zip文件！";
}
}
else
{
lb_ReSuccess.Text = "没有选择要上传的文件！";
}
}
protected void btn_Up_Click(object sender, EventArgs e)
{
ASSEntities assen_up = new ASSEntities();
//assen_up.
//处理上传
string fileExt;
string fileSavepath;
if (file_firstpost.HasFile)
{
fileExt = Path.GetExtension(file_firstpost.FileName);
if (fileExt == ".rar" || fileExt == ".zip")
{
try
{
fileSavepath = Server.MapPath(@"..\Uploads\Students\") + stuID.ToString() + @"\";
if (!Directory.Exists(fileSavepath))
{
Directory.CreateDirectory(fileSavepath);
}
file_firstpost.SaveAs(fileSavepath + file_firstpost.FileName);
string FileNameWithExt = Path.GetFileName(file_firstpost.FileName);
string FileUrl = @"../Uploads/Students/" + stuID.ToString() + @"/" + file_firstpost.FileName;
//保存到数据库
int relatedAssID = int.Parse(ddl_up.SelectedValue);
var stu = assen.Students.Where(s => s.StuID == stuID).First();
var ass = assen.Assignments.Where(a => a.AssID == relatedAssID).First();
UpAssignments ua = new UpAssignments();
ua.Students = stu;
ua.Assignments = ass;
ua.FileName = FileNameWithExt;
ua.FileUrl = FileUrl;
assen.AddToUpAssignments(ua);
assen.AcceptAllChanges();
assen.SaveChanges();
//结果
lb_Success.Text = "上传成功！";
}
catch (Exception ex)
{
lb_Success.Text = "发生错误：" + ex.Message.ToString();
}
}
else
{
lb_Success.Text = "只允许上传rar、zip文件！";
}
}
else
{
lb_Success.Text = "没有选择要上传的文件！";
}
}
protected void btn_EvaOk_Click(object sender, EventArgs e)
{
int uid = int.Parse(hfupaid.Value);
ASSEntities upass = new ASSEntities();
UpAssignments ua = upass.UpAssignments.Where(u => u.UpAssID == uid).First();
ua.Marks = int.Parse(tb_scores.Text);
ua.Result = tb_py.Text;
upass.SaveChanges();
pnl_Eva.Visible = false;
pnl_NotPost.Visible = true;
}
private void LoadGridview()
{
ASSEntities assen = new ASSEntities();
result = from sc in assen.SetCourses
select new myBinding {
SCID = sc.SCID, ClassName = sc.Classes.ClassName, CourseName = sc.Courses.CourseName, TeaName = sc.Teachers.TeaName
};
GridView1.DataSource = result;
GridView1.DataBind();
}
private void ValidateTea(string tname, string tpswd)
{
ASSEntities assen = new ASSEntities();
var result = (from tea in assen.Teachers
where tea.TeaName == tname && tea.Pswd == tpswd
select tea).First();
if (result == null)
{
ThrowMyException("教师不存在或密码不正确");
}
Session["tName"] = tname;
Session["TeaID"] = result.TeaID;
Response.Redirect(@"~/Teacher/Index.aspx");
}
private void ValidateStu(string tname, string tpswd)
{
ASSEntities assen = new ASSEntities();
var result = (from stu in assen.Students
where stu.StuName == tname && stu.Pswd == tpswd
select stu).First();
if (result == null)
{
ThrowMyException("学号不存在或密码不正确");
}
Session["tName"] = tname;
Session["StuID"] = result.StuID;
Response.Redirect(@"~/Students/Index.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox2.Text == "")
{
return;
}
string[] arrcourse = TextBox2.Text.Split(',');
ASSEntities assen = new ASSEntities();
foreach (string course in arrcourse)
{
Courses c = new Courses();
c.CourseName = course;
assen.AddToCourses(c);
}
assen.SaveChanges();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox1.Text == "" || TextBox2.Text == "")
{
return;
}
string[] arrclass = TextBox2.Text.Split(',');
ASSEntities assen = new ASSEntities();
foreach (string classsh in arrclass)
{
string classname = TextBox1.Text + classsh;
Classes c = new Classes();
c.ClassName = classname;
assen.AddToClasses(c);
}
assen.SaveChanges();
}
protected void btn_givesc_Click(object sender, EventArgs e)
{
if (tb_class.Text == "" || tb_course.Text == "" || tb_teaer.Text == "")
{
Exception ex = new Exception();
ex.Data["tbnull"] = "数据不完整。";
throw ex;
}
ASSEntities assen = new ASSEntities();
SetCourses sc = new SetCourses();
int ncint = int.Parse(tb_class.Text);
int ncoint = int.Parse(tb_course.Text);
int ntint = int.Parse(tb_teaer.Text);
var newclass = (from nc in assen.Classes
where nc.ClassID == ncint
select nc).First();
var newcourse = (from nco in assen.Courses
where nco.CourseID == ncoint
select nco).First();
var newteacher = (from nt in assen.Teachers
where nt.TeaID == ntint
select nt).First();
sc.SCID = 1;
sc.Classes = newclass;
sc.Courses = newcourse;
sc.Teachers = newteacher;
if (tb_semester.Text != "")
{
sc.Semester = tb_semester.Text;
}
else
{
sc.Semester = Session["schoolsemester"].ToString();
}
assen.AddToSetCourses(sc);
assen.SaveChanges();
}
protected void btn_change_Click(object sender, EventArgs e)
{
if (tb_change.Text == "")
{
return;
}
string[] inf = tb_change.Text.Split(',');
string inf_1 = inf[1].Trim();
int inf_2 = int.Parse(inf[0].Trim());
ASSEntities assen = new ASSEntities();
var teacher = (from t in assen.Teachers
where t.TeaName == inf_1
select t).First();
var setcourse = (from sc in assen.SetCourses
where sc.SCID == inf_2
select sc).First();
setcourse.Teachers = teacher;
assen.SaveChanges();
}
