protected void LinkBtnDel_Click(object sender, EventArgs e) { int Sid = Int32.Parse(Request.QueryString["Sid"].ToString()); LearnSite.BLL.Students stu = new LearnSite.BLL.Students(); //将删除的学生添加到删除列表中,以便将来恢复 LearnSite.Model.Students smodel = new LearnSite.Model.Students(); smodel = stu.GetModel(Sid);//获取要删除的学生实体 LearnSite.Model.DelStudents dmodel = new LearnSite.Model.DelStudents(); dmodel.Daddress = smodel.Saddress; dmodel.Dclass = smodel.Sclass; dmodel.Dgrade = smodel.Sgrade; dmodel.Dheadtheacher = smodel.Sheadtheacher; dmodel.Dname = smodel.Sname; dmodel.Dnum = smodel.Snum; dmodel.Dparents = smodel.Sparents; dmodel.Dphone = smodel.Sphone; dmodel.Dsex = smodel.Sex; dmodel.Dyear = smodel.Syear; LearnSite.BLL.DelStudents dbll = new LearnSite.BLL.DelStudents(); dbll.Add(dmodel); //在学生删除表增加该学生 stu.Delete(Sid); //学生表中删除该学生 System.Threading.Thread.Sleep(500); string url = "~/Teacher/student.aspx?Sgrade=" + Request.QueryString["Sgrade"].ToString() + "&&Sclass=" + Request.QueryString["Sclass"].ToString(); Response.Redirect(url, false); }
/// <summary> /// 自动设置学号最大值 /// </summary> private void SetSnum() { int Sgrade = Int32.Parse(DDLgrade.SelectedValue); int Sclass = Int32.Parse(DDLclass.SelectedValue); LearnSite.BLL.Students stubbl = new LearnSite.BLL.Students(); long NewSnum = stubbl.GetMaxSnum(Sgrade, Sclass); LearnSite.BLL.DelStudents dbll = new LearnSite.BLL.DelStudents(); Tsnum.Text = dbll.GetNewSnum(NewSnum);//获取删除列表中不存在的新学号 }
private void showDelstudents() { if (Request.QueryString["Sgrade"] != null && Request.QueryString["Sclass"] != null) { int Dgrade = Int32.Parse(Request.QueryString["Sgrade"].ToString()); int Dclass = Int32.Parse(Request.QueryString["Sclass"].ToString()); LearnSite.BLL.DelStudents dbll = new LearnSite.BLL.DelStudents(); GVStudent.DataSource = dbll.GetListLimit(Dgrade, Dclass); GVStudent.DataBind(); Labelgradeclass.Text = Dgrade.ToString() + "年级" + Dclass.ToString() + "班"; } }
protected void GVStudent_RowCommand(object sender, GridViewCommandEventArgs e) { string getDid = e.CommandArgument.ToString(); LearnSite.BLL.DelStudents dbll = new LearnSite.BLL.DelStudents(); if (e.CommandName.Equals("Revive")) { LearnSite.Model.DelStudents dmodel = new LearnSite.Model.DelStudents(); dmodel = dbll.GetModel(Int32.Parse(getDid));//获取该删除学生实体 LearnSite.Model.Students student = new LearnSite.Model.Students(); string Snum = dmodel.Dnum; student.Snum = Snum; student.Syear = dmodel.Dyear; student.Sgrade = dmodel.Dgrade; student.Sclass = dmodel.Dclass; student.Sname = dmodel.Dname; student.Sex = dmodel.Dsex; student.Spwd = "12345"; student.Saddress = dmodel.Daddress; student.Sphone = dmodel.Dphone; student.Sparents = dmodel.Dparents; student.Sheadtheacher = dmodel.Dheadtheacher; student.Sscore = 0; student.Sattitude = 0; LearnSite.BLL.Students stubll = new LearnSite.BLL.Students(); int newSid = stubll.AddStudent(student); //恢复该学生 dbll.Delete(Int32.Parse(getDid)); //在删除列表中去除该学生 System.Threading.Thread.Sleep(200); LearnSite.DBUtility.DbHelperSQL.UpdateStudentNewSid(Snum, newSid); showDelstudents(); } if (e.CommandName.Equals("Del")) { dbll.Delete(Int32.Parse(getDid));//永久删除该学生账号 showDelstudents(); LearnSite.Common.WordProcess.Alert("永久删除该学生账号后,请不要重用这个学生学号以防作品等数据关联。因为作品等关联学号并未作删除!", this.Page); } }
protected void BtnRegister_Click(object sender, EventArgs e) { string g = DDLgrade.SelectedValue; string c = DDLclass.SelectedValue; string x = DDLsex.SelectedValue; string n = Tsname.Text.Trim(); if (g.Length > 0 && c.Length > 0 && x.Length > 0 && n.Length > 0 && n.Length < 10) { if (LearnSite.Common.WordProcess.IsChina(n)) { int Sgrade = Int32.Parse(g); int Sclass = Int32.Parse(c); LearnSite.BLL.Students stubll = new LearnSite.BLL.Students(); long NewSnum = stubll.GetMaxSnum(Sgrade, Sclass); LearnSite.BLL.DelStudents dbll = new LearnSite.BLL.DelStudents(); string mySyear = stubll.GetYear(Sgrade); int Syear = Int32.Parse(mySyear); LearnSite.Model.Students student = new LearnSite.Model.Students(); student.Syear = Syear; student.Sgrade = Sgrade; student.Sclass = Sclass; student.Sname = n; student.Sex = DDLsex.SelectedValue; string myPwd = LearnSite.Common.WordProcess.GetRandomNumber(3); student.Spwd = myPwd; student.Saddress = ""; student.Sphone = ""; student.Sparents = ""; student.Sheadtheacher = "在线注册"; student.Sscore = 0; student.Sattitude = 0; string Tsnum = dbll.GetNewSnum(NewSnum);//获取删除列表中不存在的新学号 student.Snum = Tsnum; int Sid = stubll.AddStudent(student); if (Sid > 1) { student.Sid = Sid;//修正注册后cookies中的Sid值 2014-9-28号 System.Threading.Thread.Sleep(200); LearnSite.Common.WordProcess.Alert("注册成功,你的学号为" + Tsnum + "密码为" + myPwd + "请牢记!", this.Page); string lbip = Page.Request.UserHostAddress; int Qterm = Int32.Parse(LearnSite.Common.XmlHelp.GetTerm()); if (LearnSite.Common.CookieHelp.SetStudentCookies(student, lbip))//写cookies { DateTime LoginTime = DateTime.Now; LearnSite.BLL.Signin gbll = new LearnSite.BLL.Signin(); gbll.SigninToday(Tsnum, LoginTime, lbip, Sgrade, Qterm, Sid, n, Sclass, Syear); //签到 System.Threading.Thread.Sleep(200); OpenJump(Sgrade, Sclass); //跳转选择 } } else { labelmsg.Text = "自动申请的学号已被使用,请点击注册继续申请!"; } } else { labelmsg.Text = "注册名必须为中文!"; } } else { labelmsg.Text = "注册失败!<br/>(当前无班级可注册或姓名长度超过限制!)"; } }