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/>（当前无班级可注册或姓名长度超过限制！）";
}
}
