public static string GetStatsClassHW_ScoreOrder(string ClassCode, string ResourceToResourceFolder_Id, string UserId)
{
try
{
CommonHandel ch = new CommonHandel();
DataTable dt = new DataTable();
string StrTemp = string.Empty;
string Num = "5";
string StrSql = string.Empty;
if (ClassCode == "-1")
{
StrSql = @"select top 5 stsh.* from StatsTeacherStudentHW_Score stsh
where stsh.StudentID in(select Student_Id from Student_HomeWork shw
inner join Student_HomeWork_Submit shwSubmit on shwSubmit.Student_HomeWork_Id=shw.Student_HomeWork_Id and shwSubmit.Student_HomeWork_Status=1
where HomeWork_Id in(select HomeWork_Id from HomeWork
where ResourceToResourceFolder_Id=stsh.ResourceToResourceFolder_Id and HomeWork_AssignTeacher=stsh.TeacherID) ) and stsh.TeacherID='" + UserId + "' and stsh.ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by stsh.StudentScoreOrder";
BLL_StatsTeacherStudentHW_Score bllTeacherStudentHW_Score = new BLL_StatsTeacherStudentHW_Score();
dt = Rc.Common.DBUtility.DbHelperSQL.Query(StrSql).Tables[0];
//dt = bllTeacherStudentHW_Score.GetList(5, "TeacherID='" + UserId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'", "StudentScoreOrder").Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows.Count < 5)
{
Num = dt.Rows.Count.ToString();
}
for (int i = 0; i < dt.Rows.Count; i++)//dt.Rows[i]["Score"]dt.Rows[i]["StudentName"]
{
StrTemp += string.Format(" <td class=\"before\"><h2>{0}</h2><p>{1}</p></td>", dt.Rows[i]["StudentScore"].ToString().clearLastZero(), dt.Rows[i]["StudentName"].ToString());
}
}
StrSql = @"select top 5 stsh.* from StatsTeacherStudentHW_Score stsh
where stsh.StudentID in(select Student_Id from Student_HomeWork shw
inner join Student_HomeWork_Submit shwSubmit on shwSubmit.Student_HomeWork_Id=shw.Student_HomeWork_Id and shwSubmit.Student_HomeWork_Status=1 where HomeWork_Id in(select HomeWork_Id from HomeWork
where ResourceToResourceFolder_Id=stsh.ResourceToResourceFolder_Id and HomeWork_AssignTeacher=stsh.TeacherID) ) and stsh.TeacherID='" + UserId + "' and stsh.ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by stsh.StudentScoreOrder desc";
dt = Rc.Common.DBUtility.DbHelperSQL.Query(StrSql).Tables[0];
//dt = bllTeacherStudentHW_Score.GetList(5, "TeacherID='" + UserId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'", "StudentScoreOrder desc").Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows.Count < 5)
{
Num = dt.Rows.Count.ToString();
}
for (int i = 0; i < dt.Rows.Count; i++)//dt.Rows[i]["Score"]dt.Rows[i]["StudentName"]
{
StrTemp += string.Format(" <td class=\"after\"><h2>{0}</h2><p>{1}</p></td>", dt.Rows[i]["StudentScore"].ToString().clearLastZero(), (dt.Rows[i]["StudentName"].ToString()));
}
}
return(StrTemp + "|" + Num);
}
else
{
BLL_StatsClassStudentHW_Score bllClassStudentHW_Score = new BLL_StatsClassStudentHW_Score();
StrSql = @"select top 5 stsh.*,shwSubmit.Student_HomeWork_Status from StatsClassStudentHW_Score stsh
left join dbo.Student_HomeWork shw on shw.HomeWork_ID=stsh.HomeWork_ID and shw.Student_Id=stsh.StudentID
inner join Student_HomeWork_Submit shwSubmit on shwSubmit.Student_HomeWork_Id=shw.Student_HomeWork_Id
where stsh.ClassID='" + ClassCode + "' and stsh.ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' and shwSubmit.Student_HomeWork_Status=1 order by stsh.StudentScoreOrder,AnswerEnd";
dt = Rc.Common.DBUtility.DbHelperSQL.Query(StrSql).Tables[0];
//dt = bllClassStudentHW_Score.GetList(5, "ClassID='" + ClassCode + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'", "StudentScoreOrder,AnswerEnd").Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows.Count < 5)
{
Num = dt.Rows.Count.ToString();
}
for (int i = 0; i < dt.Rows.Count; i++)//dt.Rows[i]["Score"]dt.Rows[i]["StudentName"]
{
StrTemp += string.Format(" <td class=\"before\"><h2>{0}</h2><p>{1}</p></td>", dt.Rows[i]["StudentScore"].ToString().clearLastZero(), (dt.Rows[i]["StudentName"].ToString()));
}
}
StrSql = @"select top 5 stsh.*,shwSubmit.Student_HomeWork_Status from StatsClassStudentHW_Score stsh
left join dbo.Student_HomeWork shw on shw.HomeWork_ID=stsh.HomeWork_ID and shw.Student_Id=stsh.StudentID
inner join Student_HomeWork_Submit shwSubmit on shwSubmit.Student_HomeWork_Id=shw.Student_HomeWork_Id
where stsh.ClassID='" + ClassCode + "' and stsh.ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' and shwSubmit.Student_HomeWork_Status=1 order by stsh.StudentScoreOrder desc ,AnswerEnd desc";
dt = Rc.Common.DBUtility.DbHelperSQL.Query(StrSql).Tables[0];
//dt = bllClassStudentHW_Score.GetList(5, "ClassID='" + ClassCode + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'", "StudentScoreOrder desc,AnswerEnd desc").Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows.Count < 5)
{
Num = dt.Rows.Count.ToString();
}
for (int i = 0; i < dt.Rows.Count; i++)//dt.Rows[i]["Score"]dt.Rows[i]["StudentName"]
{
StrTemp += string.Format(" <td class=\"after\"><h2>{0}</h2><p>{1}</p></td>", dt.Rows[i]["StudentScore"].ToString().clearLastZero(), (dt.Rows[i]["StudentName"].ToString()));
}
}
return(StrTemp + "|" + Num);
}
}
catch (Exception)
{
throw;
}
}
public static string GetStatsClassStudentHW_Score(string Class, string ResourceToResourceFolder_Id, string UserId)
{
try
{
Class = Class.Filter();
ResourceToResourceFolder_Id = ResourceToResourceFolder_Id.Filter();
UserId = UserId.Filter();
string TempDate = string.Empty;
//<td class=\"progress font_color_green\"><i class=\"fa fa-arrow-up\"></i>5</td>../student/OHomeWorkViewTT.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}
// string Temp = "<tr><td>李博</td><td>1班</td><td>80</td><td>3</td><td class=\"progress font_color_green\"><i class=\"fa fa-arrow-up\"></i>5</td><td>第一层次</td><td class=\"table_opera\"><a href=\"##\">作业详情</a><a href=\"成长趋势.html\" target=\"_blank\">成长趋势</a></td></tr>";
//string Temp = "<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td>{4}<td>{5}</td>{6}<td>第{7}层次</td><td class=\"table_opera\"><a href=\"../student/OHomeWorkViewTT.aspx?ResourceToResourceFolder_Id={8}&HomeWork_Id={9}&StudentId={10}\" target=\"_blank\">批改详情</a><a href=\"javascript:ShowPic('{10}','{11}','{9}');\">成长趋势</a></td></tr>";
string Temp = "<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td>{4}{5}</tr>";
string Tempo = "<td><a href=\"javascript:CorrectView('{0}','{1}','{2}','{4}','{8}','{9}');\" class='{3}' title='{5}'>批改详情</a><a href=\"javascript:AnalysisReport('{0}','{1}','{2}','{4}','{6}','{8}','{9}');\" class='{7}' title='{5}'>分析报告</a></td>";
if (Class == "-1")
{
HttpContext.Current.Session["StatsClassClassId"] = "-1";
BLL_StatsTeacherStudentHW_Score bllStatsTeacherStudentHW_Score = new BLL_StatsTeacherStudentHW_Score();
List <Model_StatsTeacherStudentHW_Score> TeacherStudentHW_ScoreList = new List <Model_StatsTeacherStudentHW_Score>();
TeacherStudentHW_ScoreList = bllStatsTeacherStudentHW_Score.GetModelList("TeacherID='" + UserId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by StudentScore desc,StudentScoreOrder ");
//根据资源标识+班级标识，关联出作业标识
string strSqlHW = @"select ss.StatsTeacherStudentHW_ScoreId,hw.HomeWork_Id from StatsTeacherStudentHW_Score ss
inner join HomeWork hw on hw.ResourceToResourceFolder_Id=ss.ResourceToResourceFolder_Id and hw.UserGroup_Id=ss.ClassId
where ss.TeacherID='" + UserId + "' and ss.ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'";
DataTable dtHW = Rc.Common.DBUtility.DbHelperSQL.Query(strSqlHW).Tables[0];
string strSqlSHW = @"select shw.Student_HomeWork_Id,shw.HomeWork_Id,shw.Student_Id,shw.CreateTime,shwCorrect.CorrectMode from Student_HomeWork shw
inner join Student_HomeWork_Correct shwCorrect on shwCorrect.Student_HomeWork_Id=shw.Student_HomeWork_Id
where shw.HomeWork_Id in(select hw.HomeWork_Id from StatsTeacherStudentHW_Score ss
inner join HomeWork hw on hw.ResourceToResourceFolder_Id=ss.ResourceToResourceFolder_Id and hw.UserGroup_Id=ss.ClassId
where ss.TeacherID='" + UserId + "' and ss.ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "') ";
DataTable dtSHW = Rc.Common.DBUtility.DbHelperSQL.Query(strSqlSHW).Tables[0];
foreach (var item in TeacherStudentHW_ScoreList)
{
DataRow[] drHW = dtHW.Select("StatsTeacherStudentHW_ScoreId='" + item.StatsTeacherStudentHW_ScoreID + "'");
string strHomeWork_ID = string.Empty;
if (drHW.Length > 0)
{
strHomeWork_ID = drHW[0]["HomeWork_ID"].ToString();
}
string strCorrectMode = string.Empty;
string strStudent_Homework_Id = string.Empty;
DataRow[] drSHW = dtSHW.Select("Student_Id='" + item.StudentID + "' ");
if (drSHW.Length > 0)
{
strCorrectMode = drSHW[0]["CorrectMode"].ToString();
strStudent_Homework_Id = drSHW[0]["Student_Homework_Id"].ToString();
}
string TJ = GetSubmitStudent(strHomeWork_ID, item.StudentID);
string PG = GetCorrectStudent(strHomeWork_ID, item.StudentID);
TempDate += string.Format(Temp
, item.StudentName //0
, item.ClassName //1
, item.StudentScore.ToString().clearLastZero() //2
//, item.GradeStudentScoreOrder.ToString().clearLastZero()//3
//, GetScoreImprove(item.GradeScoreImprove.ToString())//4
, item.StudentScoreOrder.ToString().clearLastZero() //5
, GetScoreImprove(item.ScoreImprove.ToString()) //6
//, item.Hierarchy.ToString().clearLastZero()//7
, string.Format(Tempo
, item.ResourceToResourceFolder_Id
, strHomeWork_ID
, item.StudentID
, TJ == "0" ? "disabled" : PG == "0" ? "danger" : ""
, TJ == "0" ? "1" : ""
, TJ == "0" ? "学生未提交" : PG == "0" ? "老师未批改" : ""
, TJ == "0" ? "" : PG == "0" ? "1" : ""
, TJ == "0" ? "disabled" : PG == "0" ? "disabled" : ""
, strCorrectMode
, strStudent_Homework_Id)
, item.ResourceToResourceFolder_Id //8
, strHomeWork_ID //9
, item.StudentID //10
); //11
}
return(TempDate);
}
else
{
HttpContext.Current.Session["StatsClassClassId"] = Class;
BLL_StatsClassStudentHW_Score bllClassStudentHW_Score = new BLL_StatsClassStudentHW_Score();
List <Model_StatsClassStudentHW_Score> ClassStudentHW_ScoreList = new List <Model_StatsClassStudentHW_Score>();
ClassStudentHW_ScoreList = bllClassStudentHW_Score.GetModelList("ClassID='" + Class + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by StudentScore desc,StudentScoreOrder ");
string strSqlSHW = @"select shw.Student_HomeWork_Id,shw.HomeWork_Id,shw.Student_Id,shw.CreateTime,shwCorrect.CorrectMode from Student_HomeWork shw
inner join Student_HomeWork_Correct shwCorrect on shwCorrect.Student_HomeWork_Id=shw.Student_HomeWork_Id
where shw.HomeWork_Id in(select HomeWork_Id from HomeWork where UserGroup_Id='" + Class
+ "' and HomeWork_AssignTeacher='" + UserId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "') ";
DataTable dtSHW = Rc.Common.DBUtility.DbHelperSQL.Query(strSqlSHW).Tables[0];
foreach (var item in ClassStudentHW_ScoreList)
{
string strCorrectMode = string.Empty;
string strStudent_Homework_Id = string.Empty;
DataRow[] drSHW = dtSHW.Select("Student_Id='" + item.StudentID + "' ");
if (drSHW.Length > 0)
{
strCorrectMode = drSHW[0]["CorrectMode"].ToString();
strStudent_Homework_Id = drSHW[0]["Student_Homework_Id"].ToString();
}
string TJ = GetSubmitStudent(item.HomeWork_ID, item.StudentID);
string PG = GetCorrectStudent(item.HomeWork_ID, item.StudentID);
TempDate += string.Format(Temp
, item.StudentName
, item.ClassName
, item.StudentScore.ToString().clearLastZero()
//, item.GradeStudentScoreOrder.ToString().clearLastZero()
//, GetScoreImprove(item.GradeScoreImprove.ToString())
, item.StudentScoreOrder.ToString().clearLastZero()
, GetScoreImprove(item.ScoreImprove.ToString())
, string.Format(Tempo
, item.ResourceToResourceFolder_Id
, item.HomeWork_ID
, item.StudentID
, TJ == "0" ? "disabled" : PG == "0" ? "danger" : ""
, TJ == "0" ? "1" : ""
, TJ == "0" ? "学生未提交" : PG == "0" ? "老师未批改" : ""
, TJ == "0" ? "" : PG == "0" ? "1" : ""
, TJ == "0" ? "disabled" : PG == "0" ? "disabled" : ""
, strCorrectMode
, strStudent_Homework_Id)
//, item.Hierarchy.ToString().clearLastZero()
, item.ResourceToResourceFolder_Id
, item.HomeWork_ID
, item.StudentID);
}
return(TempDate);
}
}
catch (Exception)
{
return("");
}
}
