public static string GetStatsClassHW_ScoreOrderDistribution(string ClassCode, string ResourceToResourceFolder_Id, string UserId)
{
try
{
DataTable dt = new DataTable();
string StrTemp = string.Empty;
string StudentsNum = string.Empty;
if (ClassCode == "-1")
{
BLL_StatsTeacherHW_ScoreLevel bllTeacherHW_ScoreLevel = new BLL_StatsTeacherHW_ScoreLevel();
List <Model_StatsTeacherHW_ScoreLevel> TeacherHW_ScoreLevelList = new List <Model_StatsTeacherHW_ScoreLevel>();
TeacherHW_ScoreLevelList = bllTeacherHW_ScoreLevel.GetModelList(" TeacherID='" + UserId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by HWScoreLevelRight desc");
foreach (var item in TeacherHW_ScoreLevelList)
{
StrTemp += string.Format("<tr><td>{0}</td><td>{1}-{2}</td><td>{3}</td><td>{4}%</td><td>{5}%-{6}%</td></tr>"
, item.HWScoreLevelName
, item.HWScoreLevelLeft.ToString().clearLastZero()
, item.HWScoreLevelRight.ToString().clearLastZero()
, item.HWScoreLevelCount.ToString().clearLastZero()
, item.HWScoreLevelCountRate.ToString().clearLastZero()
, item.HWScoreLevelRateLeft
, item.HWScoreLevelRateRight);
StudentsNum += item.HWScoreLevelCountRate.ToString().clearLastZero() + ",";
}
StudentsNum = StudentsNum.TrimEnd(',');
string[] StrArr = StudentsNum.Split(',');
string StrNum = "[ {\"y\": " + StrArr[0] + ",\"name\": \"优秀\"},{\"y\": " + StrArr[1] + ",\"name\": \"良好\"},{\"y\": " + StrArr[2] + ",\"name\": \"中等\"},{\"y\": " + StrArr[3]
+ ",\"name\": \"及格\"},{\"y\": " + StrArr[4] + ",\"name\": \"不及格\"}]";
return(StrTemp + "|" + StrNum);
}
else
{
BLL_StatsClassHW_ScoreLevel bllClassHW_ScoreLevel = new BLL_StatsClassHW_ScoreLevel();
List <Model_StatsClassHW_ScoreLevel> ClassHW_ScoreLevelList = new List <Model_StatsClassHW_ScoreLevel>();
ClassHW_ScoreLevelList = bllClassHW_ScoreLevel.GetModelList(" ClassID='" + ClassCode + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by HWScoreLevelRight desc");
foreach (var item in ClassHW_ScoreLevelList)
{
StrTemp += string.Format("<tr><td>{0}</td><td>{1}-{2}</td><td>{3}</td><td>{4}%</td><td>{5}%-{6}%</td></tr>"
, item.HWScoreLevelName
, item.HWScoreLevelLeft.ToString().clearLastZero()
, item.HWScoreLevelRight.ToString().clearLastZero()
, item.HWScoreLevelCount.ToString().clearLastZero()
, item.HWScoreLevelCountRate.ToString().clearLastZero()
, item.HWScoreLevelRateLeft
, item.HWScoreLevelRateRight);
StudentsNum += item.HWScoreLevelCountRate.ToString().clearLastZero() + ",";
}
StudentsNum = StudentsNum.TrimEnd(',');
string[] StrArr = StudentsNum.Split(',');
string StrNum = "[ {\"y\": " + StrArr[0] + ",\"name\": \"优秀\"},{\"y\": " + StrArr[1] + ",\"name\": \"良好\"},{\"y\": " + StrArr[2] + ",\"name\": \"中等\"},{\"y\": " + StrArr[3]
+ ",\"name\": \"及格\"},{\"y\": " + StrArr[4] + ",\"name\": \"不及格\"}]";
return(StrTemp + "|" + StrNum);
}
}
catch (Exception)
{
return("");
}
}
public static string StatsClassHW_ScoreLevel(string ResourceToResourceFolder_Id, string UserId, string ClassID)
{
try
{
ClassID = "";
string StrTemp = string.Empty;
string StrTempAll = string.Empty;
string StrScore = string.Empty;
string StrClassname = string.Empty;
int SumHWScoreLevelCount = 0;
string DateSour = string.Empty;
string StrScoreTemp = string.Empty;
string StrWhere = "ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id.Filter() + "' and TeacherID='" + UserId.Filter() + "'";
if (!string.IsNullOrEmpty(ClassID.Filter()))
{
StrWhere += " and ClassID=" + ClassID.Filter();
BLL_StatsClassHW_ScoreLevel bllStatsClassHW_ScoreLevel = new BLL_StatsClassHW_ScoreLevel();
List <Model_StatsClassHW_ScoreLevel> StatsClassHW_ScoreLevelList = new List <Model_StatsClassHW_ScoreLevel>();
List <Model_StatsClassHW_ScoreLevel> listAll = new List <Model_StatsClassHW_ScoreLevel>(); //所有数据
listAll = bllStatsClassHW_ScoreLevel.GetModelList(StrWhere + " order by HWScoreLevelRight desc");
List <Model_StatsClassHW_ScoreLevel> listDistict = listAll.Where((x, i) => listAll.FindIndex(z => z.ClassID == x.ClassID) == i).ToList(); //去重后数据
//{name: '1班',data: [5, 13, 12, 4, 1]},
foreach (var item in listDistict)
{
List <Model_StatsClassHW_ScoreLevel> listSub = listAll.Where(x => x.ClassID == item.ClassID).ToList();//子级数据
foreach (var itemSub in listSub)
{
StrScore += "<td>" + itemSub.HWScoreLevelCount.ToString().clearLastZero() + "</td>";
SumHWScoreLevelCount = SumHWScoreLevelCount + Convert.ToInt32(itemSub.HWScoreLevelCount.ToString().clearLastZero());
StrScoreTemp += itemSub.HWScoreLevelCount.ToString().clearLastZero() + ",";
}
StrTemp += "<tr><td>" + item.ClassName + "</td>" + StrScore + "<td>" + SumHWScoreLevelCount + "</td></tr>";
DateSour += "{\"name\":\"" + item.ClassName + "\",\"data\":[" + StrScoreTemp.TrimEnd(',') + "]},";
StrScore = "";
SumHWScoreLevelCount = 0;
StrScoreTemp = "";
}
}
else
{
BLL_StatsClassHW_ScoreLevel bllStatsClassHW_ScoreLevel = new BLL_StatsClassHW_ScoreLevel();
List <Model_StatsClassHW_ScoreLevel> StatsClassHW_ScoreLevelList = new List <Model_StatsClassHW_ScoreLevel>();
List <Model_StatsClassHW_ScoreLevel> listAll = new List <Model_StatsClassHW_ScoreLevel>(); //所有数据
listAll = bllStatsClassHW_ScoreLevel.GetModelList(StrWhere + " order by HWScoreLevelRight desc");
List <Model_StatsClassHW_ScoreLevel> listDistict = listAll.Where((x, i) => listAll.FindIndex(z => z.ClassID == x.ClassID) == i).ToList(); //去重后数据
//{name: '1班',data: [5, 13, 12, 4, 1]},
foreach (var item in listDistict)
{
List <Model_StatsClassHW_ScoreLevel> listSub = listAll.Where(x => x.ClassID == item.ClassID).ToList();//子级数据
foreach (var itemSub in listSub)
{
StrScore += "<td>" + itemSub.HWScoreLevelCount.ToString().clearLastZero() + "</td>";
SumHWScoreLevelCount = SumHWScoreLevelCount + Convert.ToInt32(itemSub.HWScoreLevelCount.ToString().clearLastZero());
StrScoreTemp += itemSub.HWScoreLevelCount.ToString().clearLastZero() + ",";
}
StrTemp += "<tr><td>" + item.ClassName + "</td>" + StrScore + "<td>" + SumHWScoreLevelCount + "</td></tr>";
DateSour += "{\"name\":\"" + item.ClassName + "\",\"data\":[" + StrScoreTemp.TrimEnd(',') + "]},";
StrScore = "";
SumHWScoreLevelCount = 0;
StrScoreTemp = "";
}
string teacherStrScore = string.Empty;
BLL_StatsTeacherHW_ScoreLevel bllStatsTeacherStudentHW_Score = new BLL_StatsTeacherHW_ScoreLevel();
List <Model_StatsTeacherHW_ScoreLevel> StatsTeacherHW_ScoreLevelList = new List <Model_StatsTeacherHW_ScoreLevel>();
StatsTeacherHW_ScoreLevelList = bllStatsTeacherStudentHW_Score.GetModelList("TeacherID='" + UserId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by HWScoreLevelRight desc");
SumHWScoreLevelCount = 0;
foreach (var item in StatsTeacherHW_ScoreLevelList)
{
teacherStrScore += "<td>" + item.HWScoreLevelCount.ToString().clearLastZero() + "</td>";
SumHWScoreLevelCount = SumHWScoreLevelCount + Convert.ToInt32(item.HWScoreLevelCount.ToString().clearLastZero());
}
StrTempAll = "<tr><td>全部班级</td>" + teacherStrScore + "<td>" + SumHWScoreLevelCount + "</td></tr>";
}
return(StrTemp + "|[" + DateSour.TrimEnd(',') + "]|" + StrTempAll);
}
catch (Exception)
{
return("");
}
}
