/// <summary> /// 选项统计 /// </summary> /// <param name="zyId"></param> /// <param name="schoolId"></param> /// <param name="gradeId"></param> /// <param name="classId"></param> /// <returns></returns> public ActionResult GetOptionBar(long zyId, int schoolId, int gradeId, int classId) { int id = IdNamingHelper.Decrypt(IdNamingHelper.IdTypeEnum.Zy, zyId); dto_Echart_Bar2 deb = B_Analyze.GetOptionSelectCount(id, schoolId, gradeId, classId); if (deb != null) { ViewBag.Category = string.Join(",", deb.category); ViewBag.AData = string.Join(",", deb.optiona); ViewBag.BData = string.Join(",", deb.optionb); ViewBag.CData = string.Join(",", deb.optionc); ViewBag.DData = string.Join(",", deb.optiond); } ViewBag.SubmitCount = B_Analyze.GetZySubmitCount(id, schoolId, gradeId, classId); return(PartialView()); }
public static dto_Echart_Bar2 GetOptionSelectCount(int zyId, int schoolId, int gradeId, int classId) { dto_Echart_Bar2 deb = null; List <string> category = null; List <string> optiona = null; List <string> optionb = null; List <string> optionc = null; List <string> optiond = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(AnalyzeConnString), "select QuesNumTip, OptionA, OptionB, OptionC, OptionD from T_OptionSelectCount where ZyId = @ZyId and SchoolId = @SchoolId and GradeId = @GradeId and ClassId = @ClassId order by QuesNum", "@ZyId".ToInt32InPara(zyId), "@SchoolId".ToInt32InPara(schoolId), "@GradeId".ToInt32InPara(gradeId), "@ClassId".ToInt32InPara(classId))) { if (dr != null && dr.HasRows) { deb = new dto_Echart_Bar2(); category = new List <string>(); optiona = new List <string>(); optionb = new List <string>(); optionc = new List <string>(); optiond = new List <string>(); while (dr.Read()) { category.Add(string.Concat("第", dr[0].ToString(), "题")); optiona.Add(dr[1].ToString()); optionb.Add(dr[2].ToString()); optionc.Add(dr[3].ToString()); optiond.Add(dr[4].ToString()); } deb.category = category; deb.optiona = optiona; deb.optionb = optionb; deb.optionc = optionc; deb.optiond = optiond; } } return(deb); }