/// <summary>
/// 获得数据列表
/// </summary>
public List <LearnSite.Model.DelStudents> DataTableToList(DataTable dt)
{
List <LearnSite.Model.DelStudents> modelList = new List <LearnSite.Model.DelStudents>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
LearnSite.Model.DelStudents model;
for (int n = 0; n < rowsCount; n++)
{
model = new LearnSite.Model.DelStudents();
if (dt.Rows[n]["Did"] != null && dt.Rows[n]["Did"].ToString() != "")
{
model.Did = int.Parse(dt.Rows[n]["Did"].ToString());
}
if (dt.Rows[n]["Dnum"] != null && dt.Rows[n]["Dnum"].ToString() != "")
{
model.Dnum = dt.Rows[n]["Dnum"].ToString();
}
if (dt.Rows[n]["Dyear"] != null && dt.Rows[n]["Dyear"].ToString() != "")
{
model.Dyear = int.Parse(dt.Rows[n]["Dyear"].ToString());
}
if (dt.Rows[n]["Dgrade"] != null && dt.Rows[n]["Dgrade"].ToString() != "")
{
model.Dgrade = int.Parse(dt.Rows[n]["Dgrade"].ToString());
}
if (dt.Rows[n]["Dclass"] != null && dt.Rows[n]["Dclass"].ToString() != "")
{
model.Dclass = int.Parse(dt.Rows[n]["Dclass"].ToString());
}
if (dt.Rows[n]["Dname"] != null && dt.Rows[n]["Dname"].ToString() != "")
{
model.Dname = dt.Rows[n]["Dname"].ToString();
}
if (dt.Rows[n]["Dsex"] != null && dt.Rows[n]["Dsex"].ToString() != "")
{
model.Dsex = dt.Rows[n]["Dsex"].ToString();
}
if (dt.Rows[n]["Daddress"] != null && dt.Rows[n]["Daddress"].ToString() != "")
{
model.Daddress = dt.Rows[n]["Daddress"].ToString();
}
if (dt.Rows[n]["Dphone"] != null && dt.Rows[n]["Dphone"].ToString() != "")
{
model.Dphone = dt.Rows[n]["Dphone"].ToString();
}
if (dt.Rows[n]["Dparents"] != null && dt.Rows[n]["Dparents"].ToString() != "")
{
model.Dparents = dt.Rows[n]["Dparents"].ToString();
}
if (dt.Rows[n]["Dheadtheacher"] != null && dt.Rows[n]["Dheadtheacher"].ToString() != "")
{
model.Dheadtheacher = dt.Rows[n]["Dheadtheacher"].ToString();
}
modelList.Add(model);
}
}
return(modelList);
}
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);
}
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);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(LearnSite.Model.DelStudents model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LearnSite.Model.DelStudents model)
{
return(dal.Add(model));
}
