/// <summary> /// 查看一个班的所有学生成员 /// </summary> /// <param name="n">选课信息实体类</param> /// <returns></returns> public DataTable SelectAllStu(stuCourse n) { SqlParameter[] paras = new SqlParameter[] { new SqlParameter ("@classId",n.ClassId ), }; return sqlhelper.ExecuteQuery("SELECT stuCourse.studentId, stuCourse.classId, students.name, students.subject,students.cellphone,students.email, students.college FROM stuCourse INNER JOIN students ON stuCourse.studentId = students.studentId WHERE stuCourse.classId=@classId", paras, CommandType.Text); }
// gridView1 绑定 public void gridviewBind1() { StuCourseManage sm = new StuCourseManage(); stuCourse n = new stuCourse(); n.ClassId = Convert.ToInt32(Request.QueryString["classId"]); DataSource = sm.SelectAllstu(n); }
//触发gridview行的删除事件 protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { stuCourse n = new stuCourse(); StuCourseManage sm = new StuCourseManage(); GridViewRow gvr = GridView1.Rows[e.RowIndex]; n.StudentId = GridView1.DataKeys[e.RowIndex].Value.ToString(); //获取当前行主键id n.ClassId = Convert.ToInt32(Label6.Text); sm.DeleteStu(n); gridviewBind1(); gridviewBind(); //Response.Write(n.StudentId.ToString()); }
/// <summary> /// 删除班级学生成员 /// </summary> /// <param name="n">选课信息实体类</param> /// <returns></returns> public bool DeleteStu(stuCourse n) { bool flag = false; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@classId",n.ClassId), new SqlParameter("@studentId",n.StudentId), }; int res = sqlhelper.ExecuteNonQuery("DELETE FROM stuCourse where classId=@classId AND studentId=@studentId", paras, CommandType.Text); if (res > 0) { flag = true; } return flag; }
/// <summary> /// 为班级新增学生成员 /// </summary> /// <param name="n">选课信息实体类</param> /// <returns></returns> public bool InsertStu(stuCourse n) { bool flag = false; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@classId",n.ClassId), new SqlParameter("@studentId",n.StudentId), new SqlParameter("@creater",n.Creater ), new SqlParameter("@modifier",n.Creater ), }; int res = sqlhelper.ExecuteNonQuery("INSERT INTO stuCourse (classId, studentId, creater, modifier) VALUES (@classId,@studentId,@creater,@creater)", paras, CommandType.Text); if (res > 0) { flag = true; } return flag; }
protected void btnmes_Click(object sender, EventArgs e) { StuCourseManage sm = new StuCourseManage(); stuCourse n = new stuCourse(); n.ClassId = Convert.ToInt32(Request.QueryString["classId"]); n.StudentId = TextBox1.Text.Trim(); n.Creater = Session["adminId"].ToString(); for (int i = 0; i < sm.SelectAllstu(n).Rows.Count; i++) { if (sm.SelectAllstu(n).Rows[i]["studentId"].ToString() == TextBox1.Text.Trim()) { return; } } sm.InsertStu(n); gridviewBind1(); gridviewBind(); }
void EntityDataSource() { StuCourseManage sm = new StuCourseManage(); stuCourse n = new stuCourse(); n.ClassId = Convert.ToInt32(Request.QueryString["classId"]); DataTable dt = sm.SelectAllstu(n); // 获取数据库中所有数据 DataSource.Rows.Clear(); // 清除数据源 for (int i = 0; i < dt.Rows.Count; i++) { DataRow row = DataSource.NewRow(); row["studentId"] = dt.Rows[i]["studentId"]; row["name"] = dt.Rows[i]["name"]; row["subject"] = dt.Rows[i]["subject"]; row["college"] = dt.Rows[i]["college"]; DataSource.Rows.Add(row); } gridviewBind(); }
/// <summary> /// 为班级新增学生成员 /// </summary> /// <param name="n">选课信息实体类</param> /// <returns></returns> public bool InsertStu(stuCourse n) { return(ndao.InsertStu(n)); }
/// <summary> /// 查看一个班所有学生成员 /// </summary> /// <param name="n">选课信息实体类</param> /// <returns></returns> public DataTable SelectAllstu(stuCourse n) { return(ndao.SelectAllStu(n)); }
/// <summary> /// 删除班级学生成员 /// </summary> /// <param name="n">选课信息实体类</param> /// <returns></returns> public bool DeleteStu(stuCourse n) { return(ndao.DeleteStu(n)); }