/// <summary>
/// 【教师】保存学生成绩
/// </summary>
/// <param name="sc"></param>
/// <returns></returns>
public static int TSvaeStuScore(SelectClassInfo sc)
{
string sql = "Update SelectClassInfo set Grade1 = @Grade1 , Grade2 = @Grade2 , Grade3 = @Grade3 , Grade4 = @Grade4 , Grade = @Grade where StuNum = @stuNum and CourseNum = @CourseNum";
SqlParameter[] param =
{
new SqlParameter("@Grade1", sc.Grade1),
new SqlParameter("@Grade2", sc.Grade2),
new SqlParameter("@Grade3", sc.Grade3),
new SqlParameter("@Grade4", sc.Grade4),
new SqlParameter("@Grade", sc.Grade),
new SqlParameter("@StuNum", sc.StuNum),
new SqlParameter("@CourseNum", sc.CourseNum)
};
return(SqlHelper.ExecuteNonQuery(sql, param));
}
/// <summary>
/// 【教师】获取学生成绩信息
/// </summary>
/// <param name="stuNum">学号</param>
/// <param name="courseNum">课程号</param>
/// <returns></returns>
public static SelectClassInfo TGetStuScoreInfo(string stuNum, string courseNum)
{
string sql = "Select * from SelectClassInfo where StuNum = @StuNum and CourseNum = @CourseNum and DelFlag = 0";
SqlParameter[] param =
{
new SqlParameter("@StuNum", stuNum),
new SqlParameter("@CourseNum", courseNum)
};
DataTable dt = SqlHelper.ExecuteTable(sql, param);
SelectClassInfo sc = new SelectClassInfo();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
#region
//平时成绩
if (dr["Grade1"] is DBNull)
{
sc.Grade1 = 0;
}
else
{
sc.Grade1 = Convert.ToInt32(dr["Grade1"]);
}
//期中成绩
if (dr["Grade2"] is DBNull)
{
sc.Grade2 = 0;
}
else
{
sc.Grade2 = Convert.ToInt32(dr["Grade2"]);
}
//实验成绩
if (dr["Grade3"] is DBNull)
{
sc.Grade3 = 0;
}
else
{
sc.Grade3 = Convert.ToInt32(dr["Grade3"]);
}
//期末成绩
if (dr["Grade4"] is DBNull)
{
sc.Grade4 = 0;
}
else
{
sc.Grade4 = Convert.ToInt32(dr["Grade4"]);
}
//总评成绩
if (dr["Grade"] is DBNull)
{
sc.Grade = 0;
}
else
{
sc.Grade = Convert.ToInt32(dr["Grade"]);
}
#endregion
}
}
return(sc);
}
} //上课周数
#endregion
/// <summary>
/// 获取学生的选课信息
/// </summary>
/// <param name="stuNum">学号</param>
/// <returns>学生已选课信息表</returns>
public static List <SelectClassInfo> GetStuSelectClassInfoByStuNum(string stuNum)
{
//string sql = "Select res.*,c.CourseName,c.Credit,c.CourseType,c.ClassDate,ClassTime,c.ClassRoom,c.CheckWay from( Select sc.*,t.TeacherName from SelectClassInfo as sc Left join TeacherInfo as t on sc.TeacherNum = t.TeacherNum where StuNum = @StuNum and sc.DelFlag = 0 and sc.State =@State and sc.IsEnd = 1 ) as res Left join CourseInfo as c on res.CourseNum = c.CourseNum ";
//string sql = "Select res.*,c.CourseName,c.Credit,c.CourseType,c.ClassDate,ClassTime,c.ClassRoom,c.CheckWay from( Select sc.*,t.TeacherName from SelectClassInfo as sc Left join TeacherInfo as t on sc.TeacherNum = t.TeacherNum where StuNum = @StuNum and sc.DelFlag = 0 and sc.State =@State ) as res Left join CourseInfo as c on res.CourseNum = c.CourseNum and c.IsEnd = 1";
string sql = "select *,t.TeacherName from( Select s.*,c.CourseName,c.Credit,c.CourseType,c.ClassDate,ClassTime,c.ClassRoom,c.CheckWay from SelectClassInfo as s,CourseInfo c where s.StuNum=@StuNum and s.CourseNum = c.CourseNum and c.IsEnd = 1 and s.DelFlag = 0 and s.State = @State) as res Left join TeacherInfo as t on res.TeacherNum = t.TeacherName";
SqlParameter[] param =
{
new SqlParameter("@StuNum", stuNum),
new SqlParameter("@State", "正常")
};
List <SelectClassInfo> list = new List <SelectClassInfo>();
DataTable dt = new DataTable();
dt = SqlHelper.ExecuteTable(sql, param);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
SelectClassInfo sc = new SelectClassInfo();
#region 课程信息填装
//课程编号
if (dr["CourseNum"] is DBNull)
{
sc.CourseNum = "";
}
else
{
sc.CourseNum = dr["CourseNum"].ToString();
}
//学号
if (dr["StuNum"] is DBNull)
{
sc.StuNum = "";
}
else
{
sc.StuNum = dr["StuNum"].ToString();
}
//教师编号
if (dr["TeacherNum"] is DBNull)
{
sc.TeacherNum = "";
}
else
{
sc.TeacherNum = dr["TeacherNum"].ToString();
}
//教师名字
if (dr["TeacherName"] is DBNull)
{
sc.TeacherName = "";
}
else
{
sc.TeacherName = dr["TeacherName"].ToString();
}
//成绩信息暂时不读取
//备注
if (dr["Remark"] is DBNull)
{
sc.Remark = "";
}
else
{
sc.Remark = dr["Remark"].ToString();
}
if (dr["CourseName"] is DBNull)
{
sc.CourseName = "";
}
else
{
sc.CourseName = dr["CourseName"].ToString();
}
if (dr["CourseType"] is DBNull)
{
sc.CourseType = "";
}
else
{
sc.CourseType = dr["CourseType"].ToString();
}
if (dr["CheckWay"] is DBNull)
{
sc.CheckWay = "";
}
else
{
sc.CheckWay = dr["CheckWay"].ToString();
}
if (dr["Credit"] is DBNull)
{
sc.Credit = 0;
}
else
{
sc.Credit = Convert.ToInt32(dr["Credit"]);
}
//Count, SelectCount
if (dr["ClassDate"] is DBNull)
{
sc.ClassDate = "";
}
else
{
string str = dr["ClassDate"].ToString();
sc.LearnWeeks = str.Substring(10, 2) + " - ";
str = str.Substring(12, 2);
sc.LearnWeeks += str;
}
if (dr["ClassTime"] is DBNull)
{
sc.ClassTime = "";
}
else
{
sc.ClassTime = dr["ClassTime"].ToString();
}
if (dr["ClassRoom"] is DBNull)
{
sc.ClassRoom = "";
}
else
{
sc.ClassRoom = dr["ClassRoom"].ToString();
}
#endregion
list.Add(sc);
}
}
return(list);
}