public void ProcessRequest(HttpContext context)
{
try
{
List<ExperimentToManage> ExperimentList = new List<ExperimentToManage>();
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
var experiments = LabDB.ExperimentInfo.Where(d => d.SemesterId.ToString() == context.Request.QueryString["termId"]);
foreach (var experiment in experiments)
{
ExperimentList.Add(new ExperimentToManage
{
Id = experiment.Id,
Name = experiment.Name,
});
}
}
//实例化json序列化对象。
JavaScriptSerializer JsonSerializer = new JavaScriptSerializer();
//System.Threading.Thread.Sleep(3000);
//将数据返回到Select.aspx。
context.Response.ContentType = "text/plain";
context.Response.Write(JsonSerializer.Serialize(ExperimentList));
}
catch (Exception ex)
{
context.Response.Write("<script type=\"text/javascript\">alert(" + ex.Message + ")</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
try
{
BulletinToDelete = LabDB.Bulletin.SingleOrDefault(d => d.Id.ToString() == Request.QueryString["id"]);
if (BulletinToDelete != null)
{
LabDB.Bulletin.DeleteOnSubmit(BulletinToDelete);
LabDB.SubmitChanges();
//Response.Write("<script type=\"text/javascript\"> alert('删除成功！');</script>");
//Response.Write("<script type=\"text/javascript\"> window.location='BulletinManage.aspx'</script>");
Response.Write("1");
//return;
//Response.Redirect("BulletinManage.aspx");
}
}
catch (Exception ex)
{
//Response.Write("<script type=\"text/javascript\"> alert('"+ex.Message+"');</script>");
//Response.Write("<script type=\"text/javascript\"> window.location='BulletinManage.aspx'</script>");
Response.Write("0");
//return;
//Response.Redirect("BulletinManage.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
try
{
BulletinToDelete = LabDB.Bulletin.SingleOrDefault(d => d.Id.ToString() == Request.QueryString["id"]);
if (BulletinToDelete != null)
{
LabDB.Bulletin.DeleteOnSubmit(BulletinToDelete);
LabDB.SubmitChanges();
//Response.Write("<script type=\"text/javascript\"> alert('删除成功！');</script>");
//Response.Write("<script type=\"text/javascript\"> window.location='BulletinManage.aspx'</script>");
Response.Write("1");
//return;
//Response.Redirect("BulletinManage.aspx");
}
}
catch (Exception ex)
{
//Response.Write("<script type=\"text/javascript\"> alert('"+ex.Message+"');</script>");
//Response.Write("<script type=\"text/javascript\"> window.location='BulletinManage.aspx'</script>");
Response.Write("0");
//return;
//Response.Redirect("BulletinManage.aspx");
}
}
}
public void ProcessRequest(HttpContext context)
{
try
{
List <ExperimentToManage> ExperimentList = new List <ExperimentToManage>();
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
var experiments = LabDB.ExperimentInfo.Where(d => d.SemesterId.ToString() == context.Request.QueryString["termId"]);
foreach (var experiment in experiments)
{
ExperimentList.Add(new ExperimentToManage
{
Id = experiment.Id,
Name = experiment.Name,
});
}
}
//实例化json序列化对象。
JavaScriptSerializer JsonSerializer = new JavaScriptSerializer();
//System.Threading.Thread.Sleep(3000);
//将数据返回到Select.aspx。
context.Response.ContentType = "text/plain";
context.Response.Write(JsonSerializer.Serialize(ExperimentList));
}
catch (Exception ex)
{
context.Response.Write("<script type=\"text/javascript\">alert(" + ex.Message + ")</script>");
}
}
public void ProcessRequest(HttpContext context)
{
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
ExperimentInfo experiment = LabDB.ExperimentInfo.SingleOrDefault(d=>d.Id.ToString()==context.Request.QueryString["id"]);
LabDB.ExperimentInfo.DeleteOnSubmit(experiment);
LabDB.SubmitChanges();
}
context.Response.ContentType = "text/plain";
}
public void ProcessRequest(HttpContext context)
{
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
ExperimentInfo experiment = LabDB.ExperimentInfo.SingleOrDefault(d => d.Id.ToString() == context.Request.QueryString["id"]);
LabDB.ExperimentInfo.DeleteOnSubmit(experiment);
LabDB.SubmitChanges();
}
context.Response.ContentType = "text/plain";
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.HttpMethod == "POST")
{
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
var Student = LabDB.StudentInfo.SingleOrDefault(d => d.Id == Request.Form["Id"]);
if (Student == null || Student.Name.Trim() != Request.Form["Name"].Trim())
{
Message = "该用户不存在！请检查输入！";
Response.Redirect("SendPwd.aspx");
}
if (Student.Email == null)
{
Message = "您没有设置安全邮箱！无法找回密码！请联系管理员！";
Response.Redirect("SendPwd.aspx");
}
//发送邮件。
MailMessage mail = new MailMessage(new MailAddress("*****@*****.**", "光电学院实验预约系统"), new MailAddress(Student.Email, Student.Name));
//邮件编码格式。
mail.BodyEncoding = System.Text.Encoding.UTF8;
mail.IsBodyHtml = true;
//邮件内容。
mail.Subject = "光电子科学与工程学院实验预约系统密码找回";
mail.Body = Student.Name + "：您好！ 您在光电学院实验预约系统上申请了找回密码，请点击以下链接确认更改。" + Request.Url.GetLeftPart(UriPartial.Authority) + "/ResetPwd.aspx?resetId=" + Student.Id + "请在20分钟内完成密码重置。";
//mail.Body = Student.Name + "：您好！ 您在光电学院实验预约系统上申请了找回密码，请点击以下链接确认更改。" + Request.PhysicalApplicationPath + "/ResetPwd.aspx?resetId=" + Student.Id + "请在20分钟内完成密码重置。";
mail.Priority = MailPriority.Normal;
SmtpClient client = new SmtpClient();
client.Host = "smtp.126.com";
client.UseDefaultCredentials = false;
client.Credentials = new System.Net.NetworkCredential("labbook", "~!@#$%^&*()_+");
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.Send(mail);
//设置Session。
Session["resetId"] = Student.Id;
}
}
}
//protected string Message = "";
protected void Page_Load(object sender, EventArgs e)
{
if (Request.HttpMethod == "POST")
{
if (Request.Form["Title"].isNullorWhiteSpace())
{
Response.Write("<script type=\"text/javascript\"> alert('公告标题不能为空！');</script>");
return;
}
if (Request.Form["Bulletiner"].isNullorWhiteSpace())
{
Response.Write("<script type=\"text/javascript\"> alert('发布人不能为空！');</script>");
return;
}
if (Request.Form["editorValue"].isNullorWhiteSpace())
{
Response.Write("<script type=\"text/javascript\"> alert('公告内容不能为空！');</script>");
return;
}
try
{
Bulletin bulletin = new Bulletin
{
Title = Request.Form["Title"].Trim(),
Bulletiner = Request.Form["Bulletiner"].Trim(),
Content = Request.Form["editorValue"],
Date = DateTime.Now,
};
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
LabDB.Bulletin.InsertOnSubmit(bulletin);
LabDB.SubmitChanges();
}
Response.Redirect("../Bulletin.aspx?id=" + bulletin.Id);
}
catch (Exception ex)
{
Response.Write("<script type=\"text/javascript\"> alert('" + ex.Message + "');</script>");
return;
}
}
}
//protected string Message = "";
protected void Page_Load(object sender, EventArgs e)
{
if (Request.HttpMethod == "POST")
{
if (Request.Form["Title"].isNullorWhiteSpace())
{
Response.Write("<script type=\"text/javascript\"> alert('公告标题不能为空！');</script>");
return;
} if (Request.Form["Bulletiner"].isNullorWhiteSpace())
{
Response.Write("<script type=\"text/javascript\"> alert('发布人不能为空！');</script>");
return;
}
if (Request.Form["editorValue"].isNullorWhiteSpace())
{
Response.Write("<script type=\"text/javascript\"> alert('公告内容不能为空！');</script>");
return;
}
try
{
Bulletin bulletin = new Bulletin
{
Title = Request.Form["Title"].Trim(),
Bulletiner = Request.Form["Bulletiner"].Trim(),
Content = Request.Form["editorValue"],
Date = DateTime.Now,
};
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
LabDB.Bulletin.InsertOnSubmit(bulletin);
LabDB.SubmitChanges();
}
Response.Redirect("../Bulletin.aspx?id="+bulletin.Id);
}
catch (Exception ex)
{
Response.Write("<script type=\"text/javascript\"> alert('" + ex.Message + "');</script>");
return;
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
try
{
Semester term = LabDB.Semester.SingleOrDefault(d => d.Id.ToString() == context.Request.QueryString["id"]);
LabDB.Semester.DeleteOnSubmit(term);
LabDB.SubmitChanges();
}
catch (Exception ex)
{
context.Response.Write("<script type=\"text/javascript\"> alert('发生错误！错误信息：" + ex.Message + "');</script>");
}
context.Response.Write("删除成功！");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
CourseBookInfo courseBookInfo = LabDB.CourseBookInfo.SingleOrDefault(d => d.CourseArrangeId.ToString() == Request.QueryString["arrangeId"].Trim() && d.StudentId == Request.QueryString["studentId"].Trim());
LabDB.CourseBookInfo.DeleteOnSubmit(courseBookInfo);
LabDB.SubmitChanges();
}
}
catch { }
//Response.Redirect("IndividualCenter.aspx");
Response.Write("<script type=\"text/javascript\">alert(\"取消成功\");</script>");
Response.Write(" <script> window.location.href= 'OrderState.aspx ' </script> ");
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
try
{
Semester term = LabDB.Semester.SingleOrDefault(d => d.Id.ToString() == context.Request.QueryString["id"]);
LabDB.Semester.DeleteOnSubmit(term);
LabDB.SubmitChanges();
}
catch (Exception ex)
{
context.Response.Write("<script type=\"text/javascript\"> alert('发生错误！错误信息："+ex.Message+"');</script>");
}
context.Response.Write("删除成功！");
}
}
public void ProcessRequest(HttpContext context)
{
try
{
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
string arrangeId = context.Request.QueryString["arrangeid"].Trim();
string studentId = context.Request.QueryString["studentid"].Trim();
//检查是否已经预约满。
if (LabDB.CourseBookInfo.Where(d => d.CourseArrangeId.ToString() == arrangeId).Count() >= LabDB.CourseArrange.FirstOrDefault(d => d.Id.ToString() == arrangeId).Capacity)
{
throw (new Exception("此实验已经预约满！"));
}
//检查是否已经预约过。
if (LabDB.CourseBookInfo.FirstOrDefault(d => d.CourseArrangeId.ToString() == arrangeId && d.StudentId == studentId) != null)
{
throw(new Exception("此实验你已经预约过！不能重复预约同一实验！"));
}
CourseBookInfo courseBookInfo = new CourseBookInfo
{
StudentId = context.Request.QueryString["studentid"],
CourseArrangeId = Convert.ToInt32(context.Request.QueryString["arrangeid"].Trim()),
BookTime = DateTime.Now,
UserAgent = context.Request.UserAgent.ToString(),
};
LabDB.CourseBookInfo.InsertOnSubmit(courseBookInfo);
LabDB.SubmitChanges();
}
context.Response.Write("1");
}
catch (Exception ex)
{
context.Response.Write(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
CourseInfo course = LabDB.CourseInfo.SingleOrDefault(d => d.Id.ToString() == Request.QueryString["courseId"]);
LabDB.CourseInfo.DeleteOnSubmit(course);
LabDB.SubmitChanges();
Response.Write("<script type=\"text/javascript\"> alert('删除成功！');</script>");
Response.Write("<script type=\"text/javascript\">window.location='CourseManage.aspx?id=" + Request.QueryString["experimentId"] + "';</script>");
}
}
catch
{
Response.Write("<script type=\"text/javascript\"> alert('发生错误！删除失败！请联系管理员。');</script>");
Response.Write("<script type=\"text/javascript\">window.location='CourseManage.aspx?id=" + Request.QueryString["experimentId"] + "';</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
using (LabBookDBDataContext LabDB = new LabBookDBDataContext())
{
CourseInfo course = LabDB.CourseInfo.SingleOrDefault(d => d.Id.ToString() == Request.QueryString["courseId"]);
LabDB.CourseInfo.DeleteOnSubmit(course);
LabDB.SubmitChanges();
Response.Write("<script type=\"text/javascript\"> alert('删除成功！');</script>");
Response.Write("<script type=\"text/javascript\">window.location='CourseManage.aspx?id="+Request.QueryString["experimentId"]+"';</script>");
}
}
catch
{
Response.Write("<script type=\"text/javascript\"> alert('发生错误！删除失败！请联系管理员。');</script>");
Response.Write("<script type=\"text/javascript\">window.location='CourseManage.aspx?id="+Request.QueryString["experimentId"]+"';</script>");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
StudentList = new List <Student>();
using (LabBookDBDataContext db = new LabBookDBDataContext())
{
List <StudentInfo> students = null;
if (context.Request.QueryString["class"] == "all")
{
students = db.StudentInfo.Take(50).ToList();
}
else
{
students = db.StudentInfo.Where(d => d.Class == context.Request.QueryString["class"]).ToList();
}
foreach (var student in students)
{
StudentList.Add(new Student
{
Id = student.Id,
Name = student.Name,
Sex = (student.Sex ? "男" : "女"),
College = student.College,
Class = student.Class,
Tel = student.PhoneNumber == null?"暂缺":student.PhoneNumber
});
}
}
//实例化json序列化对象。
JavaScriptSerializer JsonSerializer = new JavaScriptSerializer();
//将数据返回到StudentManage.aspx。
context.Response.ContentType = "text/plain";
context.Response.Write(JsonSerializer.Serialize(StudentList));
}
public void ProcessRequest(HttpContext context)
{
var LabDB = new LabBookDBDataContext();
var experiment = LabDB.ExperimentInfo.SingleOrDefault(d => d.Id.ToString() == context.Request.QueryString["key"]);
if (experiment == null)
{
return;
}
IEnumerable <CourseInfo> SelectCourses = LabDB.CourseInfo.Where(d => d.ExperimentId == experiment.Id);
//将取出的数据填充UI模型中。
List <CourseToShow> Courses = new List <CourseToShow>();
foreach (var course in SelectCourses)
{
Courses.Add(new CourseToShow()
{
Name = course.Name,
TeacherName = course.TeacherId == null?"暂无":course.TeacherInfo.Name,
Address = course.Address,
Id = course.Id,
});
}
//实例化json序列化对象。
JavaScriptSerializer JsonSerializer = new JavaScriptSerializer();
//将数据返回到Select.aspx。
context.Response.ContentType = "text/plain";
context.Response.Write(JsonSerializer.Serialize(Courses));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
StudentList = new List<Student>();
using (LabBookDBDataContext db = new LabBookDBDataContext())
{
List<StudentInfo> students=null;
if (context.Request.QueryString["class"] == "all")
{
students = db.StudentInfo.Take(50).ToList();
}
else
{
students = db.StudentInfo.Where(d => d.Class == context.Request.QueryString["class"]).ToList();
}
foreach (var student in students)
{
StudentList.Add(new Student
{
Id = student.Id,
Name = student.Name,
Sex = (student.Sex ? "男" : "女"),
College=student.College,
Class=student.Class,
Tel=student.PhoneNumber==null?"暂缺":student.PhoneNumber
});
}
}
//实例化json序列化对象。
JavaScriptSerializer JsonSerializer = new JavaScriptSerializer();
//将数据返回到StudentManage.aspx。
context.Response.ContentType = "text/plain";
context.Response.Write(JsonSerializer.Serialize(StudentList));
}
