//得分概况
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 getData(string Student_ID, string SubjectID)
{
try
{
string strScore = string.Empty;
string strScoreOrder = string.Empty;
string strHWName = string.Empty;
BLL_StatsClassStudentHW_Score bll_StatsClassStudentHW_Score = new BLL_StatsClassStudentHW_Score();
List <Model_StatsClassStudentHW_Score> list = new List <Model_StatsClassStudentHW_Score>();
list = bll_StatsClassStudentHW_Score.GetModelList("StudentID = '" + Student_ID + "' and SubjectID='" + SubjectID + "' ORDER BY HomeWorkCreateTime");
foreach (var item in list)
{
strScore += item.StudentScore.ToString() + ",";
strScoreOrder += item.StudentScoreOrder.ToString() + ",";
strHWName += ((!string.IsNullOrEmpty(item.Resource_Name.ToString())) ? item.Resource_Name.ToString().ReplaceForFilter() : "-") + ",";
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(new
{
Score = strScore.TrimEnd(','),
ScoreOrder = strScoreOrder.TrimEnd(','),
HWName = strHWName.TrimEnd(',')
}));
}
catch (Exception)
{
return("err");
}
}
protected void LoadData()
{
dtTQ_S = new BLL_TestQuestions_Score().GetList("ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by TestQuestions_Num,TestQuestions_OrderNum ").Tables[0];
DataTable dt = new BLL_StatsClassStudentHW_Score().GetList("HomeWork_ID='" + HomeWork_Id + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' and StudentId='" + StudentId + "' ").Tables[0];
if (dt.Rows.Count > 0)
{
string tempSql = string.Empty;
tempSql = string.Format(@"select COUNT(1) as icount from Student_HomeWork shw inner join Student_HomeWork_Correct shwCorrect on shwCorrect.Student_HomeWork_Id=shw.Student_HomeWork_Id where HomeWork_Id='{0}'
and Student_Id='{1}'
and shwCorrect.Student_HomeWork_CorrectStatus='{2}'", HomeWork_Id, StudentId, "1");
int i = int.Parse(Rc.Common.DBUtility.DbHelperSQL.GetSingle(tempSql).ToString());
this.ltlHomeWork_Name.Text = dt.Rows[0]["Resource_Name"].ToString().ReplaceForFilter()
+ (i > 0 ? "<span class='panel_state bg-success'>已完成批改</span>" : "<span class='panel_state bg-warning'>未完成批改</span>");
this.ltlGradeName.Text = dt.Rows[0]["GradeName"].ToString();
this.ltlClassName.Text = dt.Rows[0]["ClassName"].ToString();
this.ltlStudentName.Text = dt.Rows[0]["StudentName"].ToString();
this.ltlHWScore.Text = dt.Rows[0]["HWScore"].ToString().clearLastZero();
this.ltlStudentScore.Text = dt.Rows[0]["StudentScore"].ToString().clearLastZero();
#region 获取小题得分列表
string strSql = @"select HomeWork_Id,TestQuestions_Score_ID,Student_Id,Student_Score from Student_HomeWorkAnswer where HomeWork_Id='" + HomeWork_Id + "' and Student_Id='" + StudentId + "'";
dtStu_Score = DbHelperSQL.Query(strSql).Tables[0];
#endregion
#region 获取知识点得分列表
//,KPScoreStudentSum=(select ISNULL(SUM(Student_Score),0) from Student_HomeWorkAnswer where Student_Id=stuHW.Student_Id and HomeWork_Id=hw.HomeWork_Id and TestQuestions_Score_ID in(select TestQuestions_Score_ID from TestQuestions_Score where ContentText=tqs.ContentText))
strSql = @" select
tqs.ResourceToResourceFolder_Id
,hw.HomeWork_Id
,stuHW.Student_Id as StudentId
,left(tqs.ContentText,100) as KPName
,ISNULL(SUM(TestQuestions_Score),0) as KPScoreSum
,KPScoreStudentSum=(select ISNULL(SUM(Student_Score),0) from Student_HomeWorkAnswer t
inner join TestQuestions_Score t2 on t2.TestQuestions_Score_Id=t.TestQuestions_Score_Id and t2.ContentText=tqs.ContentText
where Student_Id=stuHW.Student_Id and HomeWork_Id=hw.HomeWork_Id )
from TestQuestions_Score tqs
left join HomeWork hw on hw.ResourceToResourceFolder_Id=tqs.ResourceToResourceFolder_Id
left join Student_HomeWork stuHW on stuHW.HomeWork_Id=hw.HomeWork_Id
where stuHW.Student_Id='" + StudentId + "' and hw.HomeWork_Id='" + HomeWork_Id + "' group by tqs.ResourceToResourceFolder_Id,hw.HomeWork_Id,stuHW.Student_Id,tqs.ContentText";
dt_KPScore = DbHelperSQL.Query(strSql).Tables[0];
#endregion
LoadDateHw_score();
LoadStatsClassHW_TQ();
LoadStatsClassHW_KP();
LoadStatsClassHW_TQ_Target();
}
else
{
IsTrue = "1";
}
}
/// <summary>
/// 获得基本信息
/// </summary>
/// <returns></returns>
protected void getCommon()
{
StringBuilder commonInfo = new StringBuilder();
DataTable dt = new DataTable();
dt = new BLL_StatsClassStudentHW_Score().GetList("StudentId = '" + Student_ID + "' and HomeWork_ID= '" + HomeWork_ID + "' ").Tables[0];
foreach (DataRow item in dt.Rows)
{
StudentName = item["StudentName"].ToString() + "的成长轨迹";
HomeWork_Name = item["Resource_Name"].ToString().ReplaceForFilter();
SubjectID = item["SubjectID"].ToString();
commonInfo.AppendFormat("<span>年级：{0}</span>", item["GradeName"].ToString());
commonInfo.AppendFormat("<span>班级：{0}</span>", item["ClassName"].ToString());
commonInfo.AppendFormat("<span>学生：{0}</span>", item["StudentName"].ToString());
commonInfo.AppendFormat("<span>满分：{0}分</span>", item["HWScore"].ToString().clearLastZero());
commonInfo.AppendFormat("<span>得分：{0}分</span>", item["StudentScore"].ToString().clearLastZero());
}
ltlCommonInfo.Text = commonInfo.ToString();
}
/// <summary>
/// 获得基本信息
/// </summary>
/// <returns></returns>
protected void getCommon()
{
StringBuilder commonInfo = new StringBuilder();
DataTable dt = new DataTable();
BLL_StatsClassStudentHW_Score bll_StatsClassStudentHW_Score = new BLL_StatsClassStudentHW_Score();
dt = bll_StatsClassStudentHW_Score.GetList("StatsClassStudentHW_ScoreID = '" + StatsClassStudentHW_ScoreID + "'").Tables[0];
foreach (DataRow item in dt.Rows)
{
PageTitle = item["StudentName"].ToString() + "的成长轨迹";
Student_ID = item["StudentID"].ToString();
SubjectID = item["SubjectID"].ToString();
ClassID = item["ClassID"].ToString();
GradeID = item["GradeID"].ToString();
commonInfo.AppendFormat("<span>年级：{0}</span>", item["GradeName"].ToString());
commonInfo.AppendFormat("<span>班级：{0}</span>", item["ClassName"].ToString());
commonInfo.AppendFormat("<span>老师：{0}</span>", item["TeacherName"].ToString());
}
ltlCommonInfo.Text = commonInfo.ToString();
}
List <Model_StatsClassHW_TQ> listHW_TQ = new List <Model_StatsClassHW_TQ>(); //小题统计数据
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Request["wrong"] == "w")
{
isShowWrong = true;
}
HomeWork_Name = Server.UrlDecode(Request.QueryString["HomeWork_Name"].Filter());
ResourceToResourceFolder_Id = Request.QueryString["ResourceToResourceFolder_Id"].Filter();
HomeWork_Id = Request.QueryString["HomeWork_Id"].Filter();
StudentId = Request.QueryString["StudentId"].Filter();
List <Model_StatsClassStudentHW_Score> listSCSHW = new BLL_StatsClassStudentHW_Score().GetModelList(" HomeWork_ID='" + HomeWork_Id + "' and StudentId='" + StudentId + "' ");
if (listSCSHW.Count > 0)
{
this.Title = this.ltlTitle.Text = listSCSHW[0].Resource_Name;
ltlGradeSubject.Text = string.Format("<span>年级：{0}</span><span>班级：{1}</span><span>学生：{2}</span><span>满分：{3}分</span><span>得分：{4}分</span>"
, listSCSHW[0].GradeName
, listSCSHW[0].ClassName
, listSCSHW[0].StudentName
, listSCSHW[0].HWScore.ToString().clearLastZero()
, listSCSHW[0].StudentScore.ToString().clearLastZero());
}
listHW_TQ = new BLL_StatsClassHW_TQ().GetModelList("ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' and HomeWork_Id='" + HomeWork_Id + "' ");
string strSql = string.Format(@"select TestQuestions_Id,TestQuestions_Score_ID,Student_Answer_Status,COUNT(1) as ICOUNT from Student_HomeWorkAnswer
where HomeWork_ID='{0}' group by TestQuestions_Id,TestQuestions_Score_ID,Student_Answer_Status", HomeWork_Id);
dtTQ_StudentAnswerCount = Rc.Common.DBUtility.DbHelperSQL.Query(strSql).Tables[0];
if (!IsPostBack)
{
}
}
catch (Exception ex)
{
//Response.Write(ex.Message.ToString());
Response.Write("页面加载失败...");
Response.End();
}
}
public static string getData(string Student_ID, string SubjectID, string ClassID, string GradeID)
{
try
{
Student_ID = Student_ID.Filter();
SubjectID = SubjectID.Filter();
ClassID = ClassID.Filter();
GradeID = GradeID.Filter();
string strScore = string.Empty;
string strScoreOrder = string.Empty;
string strHWName = string.Empty;
BLL_StatsClassStudentHW_Score bll_StatsClassStudentHW_Score = new BLL_StatsClassStudentHW_Score();
List <Model_StatsClassStudentHW_Score> list = new List <Model_StatsClassStudentHW_Score>();
list = bll_StatsClassStudentHW_Score.GetModelList("StudentID = '" + Student_ID + "' AND SubjectID='" + SubjectID + "' AND ClassID = '" + ClassID + "' AND GradeID = '" + GradeID + "' ORDER BY HomeWorkCreateTime ASC");
foreach (var item in list)
{
strScore += (Convert.ToDecimal(item.HWScore.ToString()) == 0 ? "0" : Convert.ToDecimal(item.StudentScore / item.HWScore * 100).ToString("0.00")) + ",";
strScoreOrder += item.StudentScoreOrder.ToString() + ",";
strHWName += ((!string.IsNullOrEmpty(item.Resource_Name.ToString())) ? item.Resource_Name.ToString().ReplaceForFilter() : "-") + ",";
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(new
{
err = "null",
Score = strScore.TrimEnd(','),
ScoreOrder = strScoreOrder.TrimEnd(','),
HWName = strHWName.TrimEnd(',')
}));
}
catch (Exception)
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(new
{
err = "error"
}));
}
}
public static string GetList(string GradeId, string SubjectID, string ClassID, string key, int PageIndex, int PageSize)
{
try
{
SubjectID = SubjectID.Filter();
ClassID = ClassID.Filter();
GradeId = GradeId.Filter();
key = key.Filter();
HttpContext.Current.Session["StatsGradeSubject"] = SubjectID;
string strWhere = "1=1 ";
if (!string.IsNullOrEmpty(SubjectID))
{
strWhere += " and SubjectID = '" + SubjectID + "'";
}
if (!string.IsNullOrEmpty(ClassID))
{
strWhere += " and ClassID = '" + ClassID + "'";
}
if (!string.IsNullOrEmpty(GradeId))
{
strWhere += " and GradeID = '" + GradeId + "'";
}
if (!string.IsNullOrEmpty(key))
{
strWhere += " and StudentName like '%" + key + "%'";
}
strWhere += @" AND StatsClassStudentHW_ScoreID IN(select StatsClassStudentHW_ScoreID from (
select StatsClassStudentHW_ScoreID, ROW_NUMBER() over(partition by TeacherID,SubjectID,StudentId order by HomeWorkCreateTime desc) as rowNum
from StatsClassStudentHW_Score where " + strWhere + " ) t where rowNum=1)";
DataTable dt = new DataTable();
BLL_StatsClassStudentHW_Score bll = new BLL_StatsClassStudentHW_Score();
dt = bll.GetListByPage(strWhere, "ClassName,StudentName", ((PageIndex - 1) * PageSize + 1), PageIndex * PageSize).Tables[0];
int intRecordCount = bll.GetRecordCount(strWhere);
List <object> listReturn = new List <object>();
int inum = 1;
string temp = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
listReturn.Add(new
{
ClassName = dt.Rows[i]["ClassName"].ToString(),
SubjectName = dt.Rows[i]["SubjectName"].ToString(),
StudentName = dt.Rows[i]["StudentName"].ToString(),
Resource_Name = dt.Rows[i]["Resource_Name"].ToString().ReplaceForFilter(),
StudentScore = dt.Rows[i]["StudentScore"].ToString().clearLastZero(),
StudentScoreOrder = Convert.ToDecimal(dt.Rows[i]["StudentScoreOrder"]).ToString("0"),
ScoreImprove = dt.Rows[i]["ScoreImprove"].ToString(),
ScoreImproveAbs = Math.Abs(Convert.ToInt16(dt.Rows[i]["ScoreImprove"].ToString())),
StatsClassStudentHW_ScoreID = dt.Rows[i]["StatsClassStudentHW_ScoreID"].ToString()
});
inum++;
}
if (inum > 1)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = intRecordCount,
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
err = ex.Message.ToString()
}));
}
}
public static string GetStatsClassStudentHW_Score(string Class, string ResourceToResourceFolder_Id, string GradeId)
{
try
{
Class = Class.Filter();
ResourceToResourceFolder_Id = ResourceToResourceFolder_Id.Filter();
GradeId = GradeId.Filter();
string TempDate = string.Empty;//../Evaluation/StudentAnalysisReports.aspx?ResourceToResourceFolder_Id={8}&HomeWork_Id={9}&StudentId={7}
//<td class=\"progress font_color_green\"><i class=\"fa fa-arrow-up\"></i>5</td>../student/OHomeWorkViewTT.aspx?ResourceToResourceFolder_Id={8}&HomeWork_Id={9}&StudentId={7}
// 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>";<a href=\"javascript:ShowPic('{8}','{9}','{11}');\">成长趋势</a>
string Temp = "<tr><td class='text-left'>{0}</td><td class='text-left'>{1}</td><td>{2}</td><td>{3}</td>{4}<td>{5}</td>{6}{7}</tr>";
string Tempo = "<td class=\"table_opera\"><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>";
//学生作业提交情况
string SqlSHW = @"select
shw.Student_HomeWork_Id,shw.HomeWork_Id,shw.Student_Id,shw.CreateTime,shwCorrect.CorrectTime,shwCorrect.Student_HomeWork_CorrectStatus
,shwCorrect.CorrectMode,shwSubmit.Student_HomeWork_Status,shwSubmit.OpenTime,shwSubmit.StudentIP,shwSubmit.Student_Answer_Time from StatsClassStudentHW_Score ss
inner join dbo.Student_HomeWork shw on shw.HomeWork_Id=ss.HomeWork_ID and shw.Student_Id=ss.StudentID
inner join Student_HomeWork_Submit shwSubmit on shwSubmit.Student_HomeWork_Id=shw.Student_HomeWork_Id
inner join Student_HomeWork_Correct shwCorrect on shwCorrect.Student_HomeWork_Id=shw.Student_HomeWork_Id
where ss.Gradeid='" + GradeId + "' and ss.ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' ";
DataTable dtSHW = Rc.Common.DBUtility.DbHelperSQL.Query(SqlSHW).Tables[0];
if (string.IsNullOrEmpty(Class))
{
List <Model_StatsGradeStudentHW_Score> ClassStudentHW_ScoreList = new List <Model_StatsGradeStudentHW_Score>();
ClassStudentHW_ScoreList = new BLL_StatsGradeStudentHW_Score().GetModelList("Gradeid='" + GradeId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by GradeStudentScoreOrder,StudentScoreOrder");
//根据资源标识+班级标识，关联出作业标识
string strHW = @"select ss.StatsGradeStudentHW_ScoreId,hw.HomeWork_Id from StatsGradeStudentHW_Score ss
inner join dbo.HomeWork hw on hw.ResourceToResourceFolder_Id=ss.ResourceToResourceFolder_Id and hw.UserGroup_Id=ss.ClassId
where ss.Gradeid='" + GradeId + "' and ss.ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' ";
DataTable dtHW = Rc.Common.DBUtility.DbHelperSQL.Query(strHW).Tables[0];
foreach (var item in ClassStudentHW_ScoreList)
{
DataRow[] drHW = dtHW.Select("StatsGradeStudentHW_ScoreId='" + item.StatsGradeStudentHW_ScoreID + "'");
string strHomeWork_ID = string.Empty;
if (drHW.Length > 0)
{
strHomeWork_ID = drHW[0]["HomeWork_ID"].ToString();
}
DataRow[] drPG = dtSHW.Select("Student_Id='" + item.StudentID + "' and HomeWork_Id='" + strHomeWork_ID + "' and Student_HomeWork_CorrectStatus=1 and Student_HomeWork_Status=1");
string PG = (drPG.Length > 0 ? "1" : "0");
DataRow[] drTJ = dtSHW.Select("Student_Id='" + item.StudentID + "' and HomeWork_Id='" + strHomeWork_ID + "' and Student_HomeWork_Status=1");
string TJ = (drTJ.Length > 0 ? "1" : "0");
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();
}
TempDate += string.Format(Temp
, item.StudentName
, item.ClassName
, item.StudentScore.ToString().clearLastZero()
, item.GradeStudentScoreOrder.ToString().clearLastZero()
, GetScoreImprove(item.GradeScoreImprove.ToString())
, item.StudentScoreOrder
, GetScoreImprove(item.ScoreImprove.ToString())
//, item.Hierarchy.ToString().clearLastZero()
, 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.StudentID
, item.ResourceToResourceFolder_ID
, strHomeWork_ID);
}
return(TempDate);
}
else
{
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 GradeStudentScoreOrder,StudentScoreOrder");
foreach (var item in ClassStudentHW_ScoreList)
{
DataRow[] drPG = dtSHW.Select("Student_Id='" + item.StudentID + "' and HomeWork_Id='" + item.HomeWork_ID + "' and Student_HomeWork_CorrectStatus=1 and Student_HomeWork_Status=1");
string PG = (drPG.Length > 0 ? "1" : "0");
DataRow[] drTJ = dtSHW.Select("Student_Id='" + item.StudentID + "' and HomeWork_Id='" + item.HomeWork_ID + "' and Student_HomeWork_Status=1");
string TJ = (drTJ.Length > 0 ? "1" : "0");
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();
}
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())
//, item.Hierarchy.ToString().clearLastZero()
, 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.StudentID
, item.ResourceToResourceFolder_Id
, item.HomeWork_ID);
}
return(TempDate);
}
}
catch (Exception)
{
return("");
}
}
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;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
StudentId = Request.QueryString["StudentId"].Filter();
strTestpaperViewWebSiteUrl = pfunction.GetResourceHost("TestWebSiteUrl");
if (!string.IsNullOrEmpty(StudentId) && strTestpaperViewWebSiteUrl == Rc.Common.ConfigHelper.GetConfigString("TestWebSiteUrl"))
{
strTestpaperViewWebSiteUrl = pfunction.GetResourceHost("TestWebSiteUrl", StudentId);
}
stuHomeWorkId = Request.QueryString["Student_HomeWork_Id"].Filter();
string reqWrong = Request["wrong"].Filter();
if (reqWrong == "w")
{
isShowWrong = true;
}
ResourceToResourceFolder_Id = Request.QueryString["ResourceToResourceFolder_Id"].Filter();
HomeWork_Id = Request.QueryString["HomeWork_Id"].Filter();
modelHW = new BLL_HomeWork().GetModel(HomeWork_Id);
string tempSql = string.Empty;
tempSql = string.Format(@"select COUNT(1) as icount from Student_HomeWork shw inner join Student_HomeWork_Correct shwCorrect on shwCorrect.Student_HomeWork_Id=shw.Student_HomeWork_Id where HomeWork_Id='{0}'
and Student_Id='{1}'
and shwCorrect.Student_HomeWork_CorrectStatus='{2}'", HomeWork_Id, StudentId, "1");
int i = int.Parse(Rc.Common.DBUtility.DbHelperSQL.GetSingle(tempSql).ToString());
if (i > 0)
{
//}
List <Model_StatsClassStudentHW_Score> listSCSHW = new BLL_StatsClassStudentHW_Score().GetModelList(" HomeWork_ID='" + HomeWork_Id + "' and StudentId='" + StudentId + "' ");
if (listSCSHW.Count > 0)
{
isCorrect = true;
this.Title = listSCSHW[0].Resource_Name.ReplaceForFilter();
this.ltlTitle.Text = listSCSHW[0].Resource_Name.ReplaceForFilter() + "<span class='correct_state bg-success'>已完成批改</span>";
ltlGradeSubject.Text = string.Format("<span>年级：{0}</span><span>班级：{1}</span><span>学生：{2}</span><span>满分：{3}分</span><span>得分：{4}分</span>"
, listSCSHW[0].GradeName
, listSCSHW[0].ClassName
, listSCSHW[0].StudentName
, listSCSHW[0].HWScore.ToString().clearLastZero()
, listSCSHW[0].StudentScore.ToString().clearLastZero());
}
}
else
{
#region 未批改
DataTable dtw = new DataTable();
dtw = Rc.Common.DBUtility.DbHelperSQL.Query(string.Format(@"select hw.*
,vw.GradeName,vw.GradeId,vw.ClassId,vw.ClassName
,u.UserName,u.TrueName
,HWScore=(select SUM(TestQuestions_Score) from TestQuestions_Score where ResourceToResourceFolder_Id=hw.ResourceToResourceFolder_Id)
,StudentScore=(select SUM(Student_Score) from Student_HomeWorkAnswer where Student_Id='{0}' and HomeWork_Id=hw.HomeWork_Id )
,shwCorrect.Student_HomeWork_CorrectStatus
from HomeWork hw
inner join Student_HomeWork shw on shw.Student_Id='{0}' and shw.HomeWork_Id=hw.HomeWork_Id
inner join Student_HomeWork_Correct shwCorrect on shwCorrect.Student_HomeWork_Id=shw.Student_HomeWork_Id
inner join F_User u on u.UserId=shw.Student_Id
left join VW_ClassGradeSchool vw on vw.ClassId=hw.UserGroup_Id and vw.GradeId!=''
where hw.HomeWork_Id='{1}'"
, StudentId, HomeWork_Id)).Tables[0];
this.Title = dtw.Rows[0]["HomeWork_Name"].ToString();
this.ltlTitle.Text = dtw.Rows[0]["HomeWork_Name"].ToString() + "<span class='correct_state bg-warning'>未完成批改</span>";
ltlGradeSubject.Text = string.Format("<span>年级：{0}</span><span>班级：{1}</span><span>学生：{2}</span><span>满分：{3}分</span><span>得分：{4}分</span>"
, dtw.Rows[0]["GradeName"]
, dtw.Rows[0]["ClassName"]
, string.IsNullOrEmpty(dtw.Rows[0]["TrueName"].ToString()) ? dtw.Rows[0]["UserName"] : dtw.Rows[0]["TrueName"]
, dtw.Rows[0]["HWScore"].ToString().clearLastZero()
, dtw.Rows[0]["StudentScore"].ToString().clearLastZero());
if (dtw.Rows[0]["Student_HomeWork_CorrectStatus"].ToString() == "1")
{
isCorrect = true;
}
#endregion
}
StringBuilder stbLink = new StringBuilder();
stbLink.AppendFormat("<li {3}><a href=\"ohomeworkview_clientNew.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={4}\">批改详情</a></li>"
, ResourceToResourceFolder_Id
, HomeWork_Id
, StudentId
, (isShowWrong ? "" : "class=\"active\"")
, stuHomeWorkId);
if (isCorrect)
{
//stbLink.AppendFormat("<li {3}><a href=\"ohomeworkview_client.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&wrong=w&Student_HomeWork_Id={4}\">错题详情</a></li>"
//, ResourceToResourceFolder_Id
//, HomeWork_Id
//, StudentId
//, (isShowWrong ? "class=\"active\"" : "")
//, stuHomeWorkId);
//stbLink.AppendFormat("<li><a href=\"../Evaluation/StudentAnalysisReports.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}\">分析报告</a></li>"
//, ResourceToResourceFolder_Id
//, HomeWork_Id
//, StudentId
//, stuHomeWorkId);
stbLink.AppendFormat("<li><a href=\"../Evaluation/StudentAnalysisReportsNew2.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}\">分析报告</a></li>"
, ResourceToResourceFolder_Id
, HomeWork_Id
, StudentId
, stuHomeWorkId);
// stbLink.AppendFormat("<li><a href=\"../Evaluation/StudentErrorAnalysis.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}\">错题分析</a></li>"
// , ResourceToResourceFolder_Id
// , HomeWork_Id
// , StudentId
// , stuHomeWorkId);
// stbLink.AppendFormat("<li><a href=\"../Evaluation/StudentRemedyScheme.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}\">补救方案</a></li>"
//, ResourceToResourceFolder_Id
//, HomeWork_Id
//, StudentId
//, stuHomeWorkId);
}
else
{
stbLink.AppendFormat("<li><a href=\"javascript:;\" title='老师未批改' class='disabled'>分析报告</a></li>"
, ResourceToResourceFolder_Id
, HomeWork_Id
, StudentId
, stuHomeWorkId);
// stbLink.AppendFormat("<li><a href=\"javascript:;\" title='老师未批改' class='disabled'>错题分析</a></li>"
// , ResourceToResourceFolder_Id
// , HomeWork_Id
// , StudentId
// , stuHomeWorkId);
// stbLink.AppendFormat("<li><a href=\"javascript:;\" title='老师未批改' class='disabled'>补救方案</a></li>"
//, ResourceToResourceFolder_Id
//, HomeWork_Id
//, StudentId
//, stuHomeWorkId);
}
ltlLink.Text = stbLink.ToString();
if (!IsPostBack)
{
}
}
catch (Exception)
{
Response.Write("页面加载失败...");
Response.End();
}
}
public static string GetHWList(string StudentID, string SubjectID, string HomeWorkCreateTime, string HomeWorkFinishTime, int PageIndex, int PageSize)
{
try
{
StudentID = StudentID.Filter();
SubjectID = SubjectID.Filter();
HomeWorkCreateTime = HomeWorkCreateTime.Filter();
HomeWorkCreateTime = HomeWorkCreateTime.Filter();
string strWhere = "1=1";
if (!string.IsNullOrEmpty(StudentID))
{
strWhere += " AND StudentID = '" + StudentID + "'";
}
if (!string.IsNullOrEmpty(SubjectID) && SubjectID != "-1")
{
strWhere += " AND SubjectID = '" + SubjectID + "'";
}
if (!string.IsNullOrEmpty(HomeWorkCreateTime))
{
strWhere += " and HomeWorkCreateTime > '" + HomeWorkCreateTime + "'";
}
if (!string.IsNullOrEmpty(HomeWorkFinishTime))
{
strWhere += " and HomeWorkCreateTime <= '" + HomeWorkFinishTime + "'";
}
DataTable dt = new DataTable();
BLL_StatsClassStudentHW_Score bll = new BLL_StatsClassStudentHW_Score();
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM ( ");
strSql.Append(" SELECT ROW_NUMBER() OVER ( order by HomeWorkCreateTime desc ");
strSql.Append(@")AS Row, T.*,shwCorrect.Student_HomeWork_CorrectStatus from StatsClassStudentHW_Score T
left join Student_HomeWork shw on shw.HomeWork_Id=T.HomeWork_Id and Student_Id='" + StudentID + @"'
inner join Student_HomeWork_Correct shwCorrect on shwCorrect.Student_HomeWork_Id=shw.Student_HomeWork_Id ");
if (!string.IsNullOrEmpty(strWhere.Trim()))
{
strSql.Append(" WHERE " + strWhere);
}
strSql.Append(" ) TT");
strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", ((PageIndex - 1) * PageSize + 1), (PageIndex * PageSize));
dt = Rc.Common.DBUtility.DbHelperSQL.Query(strSql.ToString()).Tables[0];
string SqlCount = @"select count(1) from StatsClassStudentHW_Score T where " + strWhere;
int intRecordCount = (int)Rc.Common.DBUtility.DbHelperSQL.GetSingle(SqlCount);
string StrSql = @"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 Student_Id='" + StudentID + "'";
DataTable dtSHW = Rc.Common.DBUtility.DbHelperSQL.Query(StrSql).Tables[0];
List <object> listReturn = new List <object>();
int inum = 1;
string temp = string.Empty;
string cProgress = string.Empty;
string gProgress = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
cProgress = dt.Rows[i]["ScoreImprove"].ToString();
gProgress = dt.Rows[i]["GradeScoreImprove"].ToString();
if (Convert.ToInt16(cProgress) > 0)
{
cProgress = "<span class='text-success'><i class='fa fa-arrow-up'></i> " + cProgress + "</span>";
}
else if (Convert.ToInt16(cProgress) < 0)
{
cProgress = "<span class='text-danger'><i class='fa fa-arrow-down'></i> " + Math.Abs(Convert.ToInt16(cProgress)) + "</span>";
}
else
{
cProgress = "-";
}
if (Convert.ToInt16(gProgress) > 0)
{
gProgress = "<span class='text-success'><i class='fa fa-arrow-up'></i> " + gProgress + "</span>";
}
else if (Convert.ToInt16(gProgress) < 0)
{
gProgress = "<span class='text-danger'><i class='fa fa-arrow-down'></i> " + Math.Abs(Convert.ToInt16(gProgress)) + "</span>";
}
else
{
gProgress = "-";
}
string strCorrectMode = string.Empty;
string strStudent_Homework_Id = string.Empty;
DataRow[] drSHW = dtSHW.Select("Homework_Id='" + dt.Rows[i]["HomeWork_ID"].ToString() + "' and Student_Id='" + dt.Rows[i]["StudentID"].ToString() + "' ");
if (drSHW.Length > 0)
{
strCorrectMode = drSHW[0]["CorrectMode"].ToString();
strStudent_Homework_Id = drSHW[0]["Student_Homework_Id"].ToString();
}
double sec = 0;
try
{
TimeSpan ts1 = Convert.ToDateTime(dt.Rows[i]["AnswerEnd"].ToString()) - Convert.ToDateTime(dt.Rows[i]["AnswerStart"].ToString());
sec = ts1.TotalSeconds;
}
catch (Exception)
{
}
listReturn.Add(new
{
HomeWork_Name = dt.Rows[i]["HomeWork_Name"].ToString(),
AnswerStart = dt.Rows[i]["AnswerStart"].ToString(),
AnswerEnd = dt.Rows[i]["AnswerEnd"].ToString(),
StudentIP = dt.Rows[i]["StudentIP"].ToString(),
StudentScore = dt.Rows[i]["StudentScore"].ToString().clearLastZero(),
StudentScoreOrder = dt.Rows[i]["StudentScoreOrder"].ToString().clearLastZero(),
ScoreImprove = "[" + cProgress + "]",
Hierarchy = dt.Rows[i]["Hierarchy"].ToString().clearLastZero() == "0" ? "-" : "第" + dt.Rows[i]["Hierarchy"].ToString() + "层次",
GradeStudentScoreOrder = dt.Rows[i]["GradeStudentScoreOrder"].ToString().clearLastZero() == "0" ? "-" : dt.Rows[i]["GradeStudentScoreOrder"].ToString().clearLastZero(),
GradeScoreImprove = "[" + gProgress + "]",
GradeHierarchy = dt.Rows[i]["GradeHierarchy"].ToString().clearLastZero() == "0" ? "-" : "第" + dt.Rows[i]["GradeHierarchy"].ToString() + "层次",
HomeWork_ID = dt.Rows[i]["HomeWork_ID"].ToString(),
StudentID = dt.Rows[i]["StudentID"].ToString(),
ResourceToResourceFolder_Id = dt.Rows[i]["ResourceToResourceFolder_Id"].ToString(),
CorrectMode = strCorrectMode,
Student_Homework_Id = strStudent_Homework_Id,
DateDiffMin = Rc.Cloud.Web.Common.pfunction.ConvertSecond(sec.ToString()),
Student_HomeWork_CorrectStatus = dt.Rows[i]["Student_HomeWork_CorrectStatus"].ToString()
});
inum++;
}
if (inum > 1)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = intRecordCount,
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
err = ex.Message.ToString()
}));
}
}
public static string GetStatsClassStudentHW_Score(string BabyId, string SubjectId, string HomeWorkCreateTime, string HomeWorkFinishTime, int PageSize, int PageIndex)
{
try
{
PageIndex = Convert.ToInt32(PageIndex.ToString().Filter());
BabyId = BabyId.Filter();
SubjectId = SubjectId.Filter();
HomeWorkCreateTime = HomeWorkCreateTime.Filter();
HomeWorkCreateTime = HomeWorkCreateTime.Filter();
DataTable dt = new DataTable();
List <object> listReturn = new List <object>();
BLL_StatsClassStudentHW_Score bllStatsClassStudentHW_Score = new BLL_StatsClassStudentHW_Score();
string strSqlCount = string.Empty;
string strWhere = " StudentID='" + BabyId + "'";
if (!string.IsNullOrEmpty(SubjectId) && SubjectId != "-1")
{
strWhere += "and SubjectID='" + SubjectId + "'";;
}
if (!string.IsNullOrEmpty(HomeWorkCreateTime))
{
strWhere += " and HomeWorkCreateTime > '" + HomeWorkCreateTime + "'";
}
if (!string.IsNullOrEmpty(HomeWorkFinishTime))
{
strWhere += " and HomeWorkCreateTime <= '" + HomeWorkFinishTime + "'";
}
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM ( ");
strSql.Append(" SELECT ROW_NUMBER() OVER ( order by HomeWorkCreateTime desc ");
strSql.Append(@")AS Row, T.* from (select scss.StudentID,scss.HomeWorkCreateTime,scss.SubjectID,scss.SubjectName,scss.ClassName,scss.HomeWork_Name,scss.StudentScore,scss.GradeStudentScoreOrder,scss.StudentScoreOrder,scs.AVGScore classavg,sgs.AVGScore as gradeavg from StatsClassStudentHW_Score scss
inner join HomeWork hw on hw.HomeWork_ID=scss.HomeWork_ID
left join dbo.StatsClassHW_Score scs on scs.ClassID=scss.ClassID and scss.HomeWork_ID=scs.HomeWork_ID and scs.ResourceToResourceFolder_Id=scss.ResourceToResourceFolder_Id
left join dbo.StatsGradeHW_Score sgs on sgs.Gradeid=scss.Gradeid and sgs.ResourceToResourceFolder_Id=scss.ResourceToResourceFolder_Id) T ");
if (!string.IsNullOrEmpty(strWhere.Trim()))
{
strSql.Append(" WHERE " + strWhere);
}
strSql.Append(" ) TT");
strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", ((PageIndex - 1) * PageSize + 1), (PageIndex * PageSize));
dt = Rc.Common.DBUtility.DbHelperSQL.Query(strSql.ToString()).Tables[0];
string SqlCount = @"select count(1) from (select scss.HomeWorkCreateTime,StudentID, scss.SubjectID from StatsClassStudentHW_Score scss
inner join HomeWork hw on hw.HomeWork_ID=scss.HomeWork_ID
left join dbo.StatsClassHW_Score scs on scs.ClassID=scss.ClassID and scss.HomeWork_ID=scs.HomeWork_ID and scs.ResourceToResourceFolder_Id=scss.ResourceToResourceFolder_Id
left join dbo.StatsGradeHW_Score sgs on sgs.Gradeid=scss.Gradeid and sgs.ResourceToResourceFolder_Id=scss.ResourceToResourceFolder_Id) t where" + strWhere;
int rCount = (int)Rc.Common.DBUtility.DbHelperSQL.GetSingle(SqlCount);
int inum = 0;
string HomeWork_NameArray = string.Empty;
string StudentScoreArray = string.Empty;
string classavgArray = string.Empty;
//string gradeavgArray = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
HomeWork_NameArray += dt.Rows[i]["HomeWork_Name"] + ",";
StudentScoreArray += dt.Rows[i]["StudentScore"].ToString().clearLastZero() + ",";
classavgArray += dt.Rows[i]["classavg"].ToString().clearLastZero() + ",";
//gradeavgArray += dt.Rows[i]["gradeavg"] + ",";
inum++;
listReturn.Add(new
{
inum = (i + 1),
ClassName = dt.Rows[i]["ClassName"].ToString(),
HomeWork_Name = dt.Rows[i]["HomeWork_Name"].ToString(),
HomeWorkCreateTime = pfunction.ConvertToLongDateTime(dt.Rows[i]["HomeWorkCreateTime"].ToString(), "yyyy-MM-dd HH:mm:ss"),
StudentScore = dt.Rows[i]["StudentScore"].ToString().clearLastZero(),
StudentScoreOrder = dt.Rows[i]["StudentScoreOrder"].ToString().clearLastZero(),
GradeStudentScoreOrder = dt.Rows[i]["GradeStudentScoreOrder"].ToString().clearLastZero() == "0" ? "-" : dt.Rows[i]["GradeStudentScoreOrder"].ToString().clearLastZero(),
SubjectName = dt.Rows[i]["SubjectName"].ToString(),
classavg = dt.Rows[i]["classavg"].ToString().clearLastZero() == "0" ? "-" : dt.Rows[i]["classavg"].ToString().clearLastZero(),
gradeavg = dt.Rows[i]["gradeavg"].ToString().clearLastZero() == "0" ? "-" : dt.Rows[i]["gradeavg"].ToString().clearLastZero()
});
}
string[] scoreArr = StudentScoreArray.TrimEnd(',').Split(',');
string[] classArr = classavgArray.TrimEnd(',').Split(',');
if (inum > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = rCount,
HomeWork_NameArray = HomeWork_NameArray.TrimEnd(','),
jsonStr = "[{\"name\": \"分数\",\"data\": [" + string.Join(",", scoreArr.Reverse()) + "]},{\"name\": \"班级平均分\",\"data\": [" + string.Join(",", classArr.Reverse()) + "]}]",
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception)
{
return(JsonConvert.SerializeObject(new
{
err = "error"//ex.Message.ToString()
}));
}
}
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("");
}
}