private void LayoutRoot_Loaded(object sender, RoutedEventArgs e) { txbSubId.Text = subjectViewInfo.SubjectInfo.SUBJECTID.ToString() + "."; txbSubContent.Text = subjectViewInfo.SubjectInfo.CONTENT; System.Linq.IOrderedEnumerable <T_OA_REQUIREDETAIL> oanswerList = subjectViewInfo.AnswerList.OrderBy(ee => ee.CODE); foreach (T_OA_REQUIREDETAIL i in oanswerList) { if (i.CONTENT != "无") { //根据答案 获取每个答案的统计结果 V_SSubjectAnswerResult v = null; if (_SubAnswerResult != null) { v = _SubAnswerResult.LstAnswer.FirstOrDefault(ee => ee.AnswerCode == i.CODE); } if (v == null) { v = new V_SSubjectAnswerResult(); } SurveyAnswer_1 sa = new SurveyAnswer_1(i.CODE, i.CONTENT, v.Count); spAnswerList.Children.Add(sa); } } }
//统计每个调查申请单的结果明细 public List <V_SatisfactionResult> Result_SurveyByRequireID(string id) { List <V_SatisfactionResult> lstSub = new List <V_SatisfactionResult>(); var v = from ent in dal.GetObjects <T_OA_REQUIRERESULT>() where ent.T_OA_REQUIRE.REQUIREID == id select ent; var subkeys = from ent in v group ent by ent.SUBJECTID into e select e; foreach (var i in subkeys) { V_SatisfactionResult sub = new V_SatisfactionResult(); List <V_SSubjectAnswerResult> lstAnswer = new List <V_SSubjectAnswerResult>(); var v2 = from ent in v where ent.SUBJECTID == i.Key select ent; var answerKeys = from ent in v2 where ent.SUBJECTID == i.Key group ent by ent.RESULT into e select e; foreach (var j in answerKeys) { V_SSubjectAnswerResult info = new V_SSubjectAnswerResult(); var v3 = (from ent in v2 where ent.RESULT == j.Key select ent).Count(); info.AnswerCode = j.Key; info.Count = int.Parse(v3.ToString()); lstAnswer.Add(info); } //sub.SubjectID = i.Key; sub.LstAnswer = lstAnswer; lstSub.Add(sub); } return(lstSub); }
private void LayoutRoot_Loaded(object sender, RoutedEventArgs e) { txbSubId.Text = subjectViewInfo.SUBJECTID.ToString() + "."; txbSubContent.Text = subjectViewInfo.CONTENT; int count = 0; //该题目总票数 int AnswerID_count = 0; // 达到答案级别的 票数 //构造一个答案组,并统计通过率 foreach (T_SYS_DICTIONARY i in _oanswer) { V_SSubjectAnswerResult v = null; if (subAnswerResult != null) { v = subAnswerResult.LstAnswer.FirstOrDefault(ee => decimal.Parse(ee.AnswerCode) == i.DICTIONARYVALUE); } if (v == null) { v = new V_SSubjectAnswerResult(); } else { if (int.Parse(AnswerID) >= int.Parse(v.AnswerCode)) { AnswerID_count = +v.Count; } count += v.Count; } SurveyAnswer_sat_1 sa = new SurveyAnswer_sat_1(i, v.Count); spAnswerList.Children.Add(sa); } //题目答案统计结果 decimal d = decimal.Round(AnswerID_count / (count == 0 ? 1 : count) * 100, 1); if (d >= PercentAge) { txtSubResult.Text = "结果:通过(" + d.ToString() + "%)"; } else { txtSubResult.Text = "结果:不通过(" + d.ToString() + "%)"; } //回传到方案 统计 SatisfactionResultEventArgs ev = new SatisfactionResultEventArgs(); ev.Count = count; ev.AnswerID_count = AnswerID_count; if (event_SatisfactionResult != null) { event_SatisfactionResult(this, ev); } }
private void LayoutRoot_Loaded(object sender, RoutedEventArgs e) { txbSubId.Text = subjectViewInfo.SubjectInfo.SUBJECTID.ToString() + "."; txbSubContent.Text = subjectViewInfo.SubjectInfo.CONTENT; System.Linq.IOrderedEnumerable<T_OA_REQUIREDETAIL> oanswerList = subjectViewInfo.AnswerList.OrderBy(ee => ee.CODE); foreach (T_OA_REQUIREDETAIL i in oanswerList) { if (i.CONTENT != "无") { //根据答案 获取每个答案的统计结果 V_SSubjectAnswerResult v = null; if (_SubAnswerResult != null) v = _SubAnswerResult.LstAnswer.FirstOrDefault(ee => ee.AnswerCode == i.CODE); if (v == null) v = new V_SSubjectAnswerResult(); SurveyAnswer_1 sa = new SurveyAnswer_1(i.CODE,i.CONTENT,v.Count); spAnswerList.Children.Add(sa); } } }