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(""); } }