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