/// <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; } }