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