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