//查询平均分数4
public int AvgScore4()
{
string sql = "selectAVG(score4) from tb_grade where klass='1604班'";
DataTable dt = SQLHelper.ExecuteTableSql(sql);
return(int.Parse(dt.Rows[0][0].ToString()));
}
//获取组员按成绩
public List <User> GetPartnersbygrade(string stunum)
{
string sql = "select s.StuName from tb_student as s,tb_grade as g where s.StuNo=g.StuNo and g.groupId in (select groupId from tb_grade where StuNo=@stunum) and s.StuNo!=@stunum and g.groupIdentity !='组长' and g.klass in (select klass from tb_grade where StuNo=@stunum)";
DataTable dt = SQLHelper.ExecuteTableSql(sql, new SqlParameter("@stunum", stunum));
return(DTToList(dt));
}
//按班级统计多血质人数
public int DuoxueCount(string klass)
{
string sql = "select COUNT(*) DuoxueCount from tb_personalityTest where pattern='多血质' and klass=@klass";
DataTable dt = SQLHelper.ExecuteTableSql(sql, new SqlParameter("@klass", klass));
return(int.Parse(dt.Rows[0][0].ToString()));
}
public string GetAName(string anum)
{
string sql = "select StuName from tb_admin where AdminNum=@anum";
DataTable dt = SQLHelper.ExecuteTableSql(sql, new SqlParameter("@anum", anum));
return(dt.Rows[0][0].ToString());
}
public string GetTeaName(string teanum)
{
string sql = "select TeacherName from tb_teacher where TeacherNum=@teanum";
DataTable dt = SQLHelper.ExecuteTableSql(sql, new SqlParameter("@teanum", teanum));
return(dt.Rows[0][0].ToString());
}
public string GetStuName(string stunum)
{
string sql = "select StuName from tb_student where StuNo=@stunum";
DataTable dt = SQLHelper.ExecuteTableSql(sql, new SqlParameter("@stunum", stunum));
return(dt.Rows[0][0].ToString());
}
//插入分数
public List <QuizQuestion> Getquizquestion(string examname)
{
string sql = "select TestContent,TestAns1,TestAns2,TestAns3,TestAns4,RightAns from tb_tvideo where Videotitle=@examname";
SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@examname", examname) };
DataTable dt = SQLHelper.ExecuteTableSql(sql, paras);
return(DTToList(dt));
}
//按班级查询选择按气质类型的总票数
public int perCount(string klass)
{
string sql = "select count(*) from tb_grade where isvote=1 and klass=@klass";
SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@klass", klass) };
DataTable dt = SQLHelper.ExecuteTableSql(sql, paras);
return(int.Parse(dt.Rows[0][0].ToString()));
}
