/// <summary> /// 反馈信息按反馈类别统计(Advice表的类别) /// 统计标准为Advice表State = (int)AdviceState.Finished /// </summary> protected void AdviceTypeStatistics() { List <AdviceRate> items = CreateAdviceRateList(); if (items != null) { if (AdviceReplyStatisticsPager.Count < 0) { AdviceReplyStatisticsPager.PageIndex = 0; } AdviceReplyStatisticsPager.FreshMyself(); AdviceReplyStatisticsPager.RecorderCount = items.Count; if (AdviceReplyStatisticsPager.RecorderCount < 1) { StatisticsDataGridView.DataSource = null; } else { AdviceReplyStatisticsPager.FreshMyself(); int tmpCount = 0; int start = AdviceReplyStatisticsPager.Begin; int size = AdviceReplyStatisticsPager.PageSize; int itmCount = items.Count - start; if (itmCount > size) { tmpCount = size; } else { tmpCount = itmCount; } StatisticsDataGridView.DataSource = items.GetRange(start, tmpCount); } StatisticsDataGridView.DataBind(); } }
/// <summary> /// 反馈信息按反馈模型统计(AdviceType表) /// 统计标准为Advice表State = (int)AdviceState.Finished /// </summary> protected void AdviceModuleStatistics() { //1.获取所有的反馈模型 adTypeList List <AdviceType> adTypeList = new List <AdviceType>(); adTypeList = AdviceTypeHelper.GetAdviceTypes(); if (adTypeList != null) { //翻页控件属性赋值 if (AdviceReplyStatisticsPager.Count < 0) { AdviceReplyStatisticsPager.PageIndex = 0; } AdviceReplyStatisticsPager.FreshMyself(); AdviceReplyStatisticsPager.RecorderCount = adTypeList.Count; if (AdviceReplyStatisticsPager.RecorderCount < 1) { StatisticsDataGridView.DataSource = null; } else { //反馈统计对象 List <AdviceRate> adRateList = new List <AdviceRate>(); foreach (AdviceType adType in adTypeList) { AdviceRate adRate = new AdviceRate(); if (adType != null && adType.ID != "") { adRate.AdviceTypeID = CurrentQuery.AdviceTypeID = adType.ID; adRate.AdviceTypeTitle = adType.Title; //2.根据条件循环获取每个模型的反馈信息数据 adList List <Advice> adList = AdviceHelper.GetAdviceByQuery(CurrentQuery, 0, 0); adRate.AdviceCount = adList.Count; for (int i = 0; i < adList.Count; i++) { if (adList != null && adList.Count != 0) { //根据获取到的反馈信息数据给反馈统计对象赋值 if (adList[i].MustHandle == 1) { adRate.HandleNumber += 1; } if (adList[i].State == (int)AdviceState.Finished) { adRate.HandleCount += 1; if (adList[i].EnumState != EnumLibrary.AdviceEnum.AdminHandle.ToString())//管理员办理的除去 { adRate.NoAdminHandleCount += 1; if (adList[i].MustHandle == 1) { adRate.NotAdminMustHandleCount += 1; } } } if (adList[i].State != (int)AdviceState.Finished && adList[i].MustHandle == 1) { adRate.NoHandleCount += 1; } } } } adRate.NoHandleNumber = adRate.AdviceCount - adRate.HandleNumber; int count = 0; if (adRate.NoAdminHandleCount > 0 && adRate.HandleNumber > 0) { count = (int)(((double)adRate.NotAdminMustHandleCount / (double)adRate.HandleNumber) * 100); } if (count > 100) { count = 100; } adRate.HandleRate = count + "%"; adRateList.Add(adRate); } StatisticsDataGridView.DataSource = adRateList; } } StatisticsDataGridView.DataBind(); }