public static string GetStatsGradeHW_Score(string GradeId, string ResourceToResourceFolder_Id)
{
try
{
GradeId = GradeId.Filter();
ResourceToResourceFolder_Id = ResourceToResourceFolder_Id.Filter();
string TempAll = "<tr><td class='text-left'>全部</td><td class='text-left'>{8}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{0}</td><td>{9}</td><td>{6}/{7}</td></tr>";
string Temps = "<tr><td class='text-left'>{9}</td><td class='text-left'>{8}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{0}</td><td>{10}</td><td>{6}/{7}</td></tr>";
string TempDate = string.Empty;
string TempDateAll = string.Empty;
BLL_StatsGradeHW_Score bllStatsGradeHW_Score = new BLL_StatsGradeHW_Score();
List <Model_StatsGradeHW_Score> StatsGradeHW_ScoreList = new List <Model_StatsGradeHW_Score>();
StatsGradeHW_ScoreList = bllStatsGradeHW_Score.GetModelList("GradeID='" + GradeId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'");
foreach (var item in StatsGradeHW_ScoreList)
{
TempDateAll = string.Format(TempAll, item.ClassAllCount.ToString().clearLastZero(), item.HighestScore.ToString().clearLastZero(), item.LowestScore.ToString().clearLastZero(), item.AVGScore.ToString().clearLastZero(), item.Median.ToString().clearLastZero(), item.Mode, item.CommittedCount.ToString().clearLastZero(), item.UncommittedCount.ToString().clearLastZero(), "-", item.AssignedCount.ToString().clearLastZero() + "/" + (Convert.ToInt32(item.ClassAllCount) - Convert.ToInt32(item.AssignedCount)));
}
BLL_StatsClassHW_Score bllStatsClassHW_Score = new BLL_StatsClassHW_Score();
List <Model_StatsClassHW_Score> StatsClassHW_ScoreList = new List <Model_StatsClassHW_Score>();
StatsClassHW_ScoreList = bllStatsClassHW_Score.GetModelList("GradeID='" + GradeId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'");
foreach (var item in StatsClassHW_ScoreList)
{
TempDate += string.Format(Temps, item.ClassAllCount.ToString().clearLastZero(), item.HighestScore.ToString().clearLastZero(), item.LowestScore.ToString().clearLastZero(), item.AVGScore.ToString().clearLastZero(), item.Median.ToString().clearLastZero(), item.Mode, item.CommittedCount.ToString().clearLastZero(), item.UncommittedCount.ToString().clearLastZero(), item.TeacherName, item.ClassName, item.AssignedCount.ToString().clearLastZero() + "/" + (Convert.ToInt32(item.ClassAllCount) - Convert.ToInt32(item.AssignedCount)));
}
return(TempDateAll + "†" + TempDate);
}
catch (Exception)
{
return("");
}
}
//得分概况
public void LoadDateHw_score()
{
string strClassCount = "0";
string StrTemp = string.Empty;
List <Model_StatsClassHW_Score> StatsClassHW_Score_list = new List <Model_StatsClassHW_Score>();
StatsClassHW_Score_list = bll_StatsClassHW_Score.GetModelList("HomeWork_ID='" + HomeWork_Id + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'");
foreach (var item in StatsClassHW_Score_list)//
{
StrTemp = string.Format(TempHw_Score, item.AVGScore.ToString().clearLastZero(), item.LowestScore.ToString().clearLastZero(), item.HighestScore.ToString().clearLastZero());
strClassCount = item.ClassAllCount.ToString().clearLastZero();
}
BLL_StatsClassStudentHW_Score bll_StatsClassStudentHW_Score = new BLL_StatsClassStudentHW_Score();
List <Model_StatsClassStudentHW_Score> StatsClassStudentHW_Score_list = new List <Model_StatsClassStudentHW_Score>();
StatsClassStudentHW_Score_list = bll_StatsClassStudentHW_Score.GetModelList("HomeWork_ID='" + HomeWork_Id + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' and StudentID='" + StudentId + "'");
foreach (var item in StatsClassStudentHW_Score_list)
{
StrTemp += string.Format(Temp_HwStudent_Score
, item.StudentScore.ToString().clearLastZero()
, Convert.ToInt32(item.StudentScoreOrder).ToString()
, item.Hierarchy.ToString().clearLastZero()
, item.HWScoreLevelName
, strClassCount);
}
this.ltlHw_Score.Text = StrTemp;
}
public static string GetStatsGradeHW_Score(string GradeId, string ResourceToResourceFolder_Id)
{
try
{
GradeId = GradeId.Filter();
ResourceToResourceFolder_Id = ResourceToResourceFolder_Id.Filter();
string TempGrade = string.Empty;
string avgScore = string.Empty;
string Temp = " <tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td></tr>";
string TempDate = string.Empty;
BLL_StatsClassHW_Score bllStatsClassHW_Score = new BLL_StatsClassHW_Score();
List <Model_StatsClassHW_Score> StatsClassHW_ScoreList = new List <Model_StatsClassHW_Score>();
StatsClassHW_ScoreList = bllStatsClassHW_Score.GetModelList("GradeID='" + GradeId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by AVGScore desc");
int i = 0;
foreach (var item in StatsClassHW_ScoreList)
{
TempDate += string.Format(Temp, i + 1, item.ClassName, item.TeacherName, item.AVGScore.ToString().clearLastZero());
TempGrade += "" + item.ClassName + ",";
avgScore += item.AVGScore + ",";
i++;
}
if (string.IsNullOrEmpty(TempDate))
{
return("");
}
else
{
return(TempDate + "|" + TempGrade.TrimEnd(',') + "|" + avgScore.TrimEnd(',') + "");
}
}
catch (Exception)
{
return("");
}
}
public static string getData(string SubjectID, string ClassID, string GradeID)
{
try
{
SubjectID = SubjectID.Filter();
ClassID = ClassID.Filter();
GradeID = GradeID.Filter();
string strAVGScore = string.Empty;
string strAVGScoreRate = string.Empty;
string strHWScore = string.Empty;
//string strScoreOrder = string.Empty;
string strHWName = string.Empty;
BLL_StatsClassHW_Score bll_StatsClassHW_Score = new BLL_StatsClassHW_Score();
List <Model_StatsClassHW_Score> list = new List <Model_StatsClassHW_Score>();
list = bll_StatsClassHW_Score.GetModelList("SubjectID='" + SubjectID + "' AND ClassID = '" + ClassID + "'AND GradeID = '" + GradeID + "' ORDER BY HomeWorkCreateTime ASC");
foreach (var item in list)
{
strAVGScore += item.AVGScore.ToString() + ",";
strAVGScoreRate += item.AVGScoreRate.ToString() + ",";
strHWScore += item.HW_Score.ToString() + ",";
strHWName += ((!string.IsNullOrEmpty(item.Resource_Name.ToString())) ? item.Resource_Name.ToString().ReplaceForFilter() : "-") + ",";
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(new
{
AVGScore = strAVGScore.TrimEnd(','),
AVGScoreRate = strAVGScoreRate.TrimEnd(','),
HWScore = strHWScore.TrimEnd(','),
HWName = strHWName.TrimEnd(',')
}));
}
catch (Exception)
{
return("err");
}
}
public static string GetStatsClassHW_Score(string ResourceToResourceFolder_Id, string UserId, string ClassID)
{
try
{
string StrWhere = "TeacherID='" + UserId.Filter() + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id.Filter() + "'";
//if (!string.IsNullOrEmpty(ClassID))
//{
// StrWhere += "and ClassID='" + ClassID.Filter() + "'";
//}
string StrTemp = string.Empty;
BLL_StatsClassHW_Score bllcswso = new BLL_StatsClassHW_Score();
List <Model_StatsClassHW_Score> ClassScoreOverviewList = new List <Model_StatsClassHW_Score>();
ClassScoreOverviewList = bllcswso.GetModelList(StrWhere);
string Temp = "<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}/{7}</td><td>{8}/{9}</td></tr>";
foreach (var item in ClassScoreOverviewList)
{
StrTemp += string.Format(Temp, item.ClassName, item.AVGScore.ToString().clearLastZero(), item.HighestScore.ToString().clearLastZero()
, item.LowestScore.ToString().clearLastZero(), item.Median.ToString().clearLastZero(), item.Mode, item.CommittedCount.ToString().clearLastZero(), item.UncommittedCount.ToString().clearLastZero(), item.CorrectedCount.ToString().clearLastZero(), item.UnCorrectedCount.ToString().clearLastZero());
}
return(StrTemp);
}
catch (Exception)
{
return("");
}
}
public static string GetStatsClassHW_ScoreOverview(string ClassCode, string ResourceToResourceFolder_Id, string UserId)
{
try
{
ClassCode = ClassCode.Filter();
ResourceToResourceFolder_Id = ResourceToResourceFolder_Id.Filter();
UserId = UserId.Filter();
CommonHandel chbll = new CommonHandel();
BLL_StatsTeacherHW_Score bllsthwso = new BLL_StatsTeacherHW_Score();
List <Model_StatsTeacherHW_Score> teacherScoreOverviewList = new List <Model_StatsTeacherHW_Score>();
DataTable dt = new DataTable();
string StrTemp = string.Empty;
if (ClassCode == "-1")
{
HttpContext.Current.Session["StatsClassClassId"] = "-1";
teacherScoreOverviewList = bllsthwso.GetModelList(" TeacherID='" + UserId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' ");
foreach (var item in teacherScoreOverviewList)
{
StrTemp += string.Format("<tr><td>全部</td><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td><td>{7}</td><td>{8}</td><td>{9}</td></tr>"
, item.ClassAllCount
, item.HighestScore.ToString().clearLastZero()
, item.LowestScore.ToString().clearLastZero()
, item.AVGScore.ToString().clearLastZero()
, item.Median.ToString().clearLastZero()
, item.Mode
, item.StandardDeviation.ToString().clearLastZero()
, item.AssignedCount.ToString().clearLastZero() + "/" + (Convert.ToInt32(item.ClassAllCount) - Convert.ToInt32(item.AssignedCount.ToString().clearLastZero()))
, item.CommittedCount.ToString().clearLastZero() + "/" + item.UncommittedCount.ToString().clearLastZero()
, item.CorrectedCount.ToString().clearLastZero() + "/" + item.UnCorrectedCount.ToString().clearLastZero());
}
return(StrTemp);
}
else
{
HttpContext.Current.Session["StatsClassClassId"] = ClassCode;
BLL_StatsClassHW_Score bllcswso = new BLL_StatsClassHW_Score();
List <Rc.Model.Resources.Model_StatsClassHW_Score> ClassScoreOverviewList = new List <Model_StatsClassHW_Score>();
ClassScoreOverviewList = bllcswso.GetModelList("ClassID='" + ClassCode + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'");
foreach (var item in ClassScoreOverviewList)
{
StrTemp = string.Format("< ><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td><td>{7}</td><td>{8}</td><td>{9}</td><td>{10}</td></tr>", item.ClassName, item.ClassAllCount
, item.HighestScore.ToString().clearLastZero()
, item.LowestScore.ToString().clearLastZero()
, item.AVGScore.ToString().clearLastZero()
, item.Median.ToString().clearLastZero()
, item.Mode
, item.StandardDeviation.ToString().clearLastZero()
, item.AssignedCount.ToString().clearLastZero() + "/" + (Convert.ToInt32(item.ClassAllCount) - Convert.ToInt32(item.AssignedCount.ToString().clearLastZero()))
, item.CommittedCount.ToString().clearLastZero() + "/" + item.UncommittedCount.ToString().clearLastZero()
, item.CorrectedCount.ToString().clearLastZero() + "/" + item.UnCorrectedCount.ToString().clearLastZero());
}
return(StrTemp);
}
}
catch (Exception)
{
return("");
}
}
