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