/// <summary>
/// 小题得分
/// </summary>
public void LoadStatsClassHW_TQ()//小题得分
{
string StrTemp = string.Empty;
List <Model_StatsStuHW_TQ_Score> StatsStuHW_TQ_Score_list = new List <Model_StatsStuHW_TQ_Score>();
BLL_StatsStuHW_TQ_Score bll_StatsStuHW_TQ_Score = new BLL_StatsStuHW_TQ_Score();
StatsStuHW_TQ_Score_list = bll_StatsStuHW_TQ_Score.GetModelList("HomeWork_ID='" + HomeWork_Id + "' and Student_Id='" + StudentId + "' order by TestQuestions_Num,testIndex");
foreach (var item in StatsStuHW_TQ_Score_list)
{
DataRow[] drTQ_S = dtTQ_S.Select("TestQuestions_Score_ID='" + item.StatsStuHW_TQ_Score_Id + "'");
StrTemp += string.Format(TempHW_TQ
, !string.IsNullOrEmpty(item.testIndex.ToString()) ? item.topicNumber.ToString() + item.testIndex.ToString() : item.topicNumber.ToString().TrimEnd('.')
, item.TestType
, item.KPNameBasic
, item.ComplexityText
, item.TQScore.ToString().clearLastZero()
, item.Score.ToString().clearLastZero()
, item.TQScoreAvg.ToString().clearLastZero()
, item.TQScoreAvgRate.ToString().clearLastZero());
strTQNum += !string.IsNullOrEmpty(item.testIndex.ToString()) ? item.topicNumber.ToString() + item.testIndex.ToString() + "," : item.topicNumber.ToString().TrimEnd('.') + ",";
strTQScore += item.Score.ToString().clearLastZero() + ",";
}
strTQNum = strTQNum.TrimEnd(',');
strTQScore = strTQScore.TrimEnd(',');
this.ltlHW_TQScore.Text = StrTemp;
}
/// <summary>
/// 获取空的难易度占比
/// </summary>
public void GetComplexityTextData()
{
try
{
//['容易', 45.0]
string sql = string.Format(@"select count(*) countData,ComplexityText from StatsStuHW_TQ_Score t
inner join [dbo].[Common_Dict] cd on cd.D_Name=t.ComplexityText where HomeWork_Id='{0}' and Student_Id='{1}' group by ComplexityText,cd.D_Order order by D_Order", HomeWork_Id, StudentId);
DataTable dt = Rc.Common.DBUtility.DbHelperSQL.Query(sql).Tables[0];
decimal CountScore = new BLL_StatsStuHW_TQ_Score().GetRecordCount("HomeWork_Id='" + HomeWork_Id + "' and Student_Id='" + StudentId + "'");//总共多少空
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
strComplexityText += item["ComplexityText"] + "," + decimal.Round(Convert.ToDecimal(item["countData"]) / CountScore * 100, 2) + "|";
}
strComplexityText = strComplexityText.TrimEnd('|');
}
}
catch (Exception ex)
{
throw;
}
}
