public string GetKpiData(BoundLevel pLevel, List <KPIFlatDataItem> pKpiDataInfo, string pKpiLabelPrefix, string pKpiLabelSuffix, DataValueFormat pDataValueFormat, string pStyleCode, string pStyleSubCode)
{
Color[] pFlatColors = GetRenderColors(pStyleCode, pStyleSubCode);
pKpiDataInfo.Sort(KpiDataCompare);
double dMinValue = 0;// Convert.ToDouble(pKpiDataInfo[0].KPIData);
for (int i = 0; i < pKpiDataInfo.Count; i++)
{
if (pKpiDataInfo[i].KPIData != null)
{
dMinValue = Convert.ToDouble(pKpiDataInfo[i].KPIData);
break;
}
}
double dMaxValue = Convert.ToDouble(pKpiDataInfo[pKpiDataInfo.Count - 1].KPIData);
List <Threshold> lstThreshold = new List <Threshold>();
//分成5段
double dInterval = (dMaxValue - dMinValue) / 5.0;
if (dInterval < 0.01 && dInterval > 0)//最小间隔为0.1
{
dInterval = 0.01;
}
Threshold threshold1 = new Threshold();
List <ThresholdItem> lstThresholdItem = new List <ThresholdItem>();
for (int i = 0; i < 5; i++)
{
double startValue;
double endValue;
if (i == 0)
{//起始值使用最小值
startValue = dMinValue;
}
else
{
startValue = dMinValue + dInterval * i;
}
if (i == 4)
{//结束值使用最大值
endValue = dMaxValue;
}
else
{
endValue = dMinValue + dInterval * (i + 1);
}
if (startValue == 0 && endValue == 0)//忽略无数据的KPI
{
continue;
}
string startLabel = KPIBuilderUtils.GetFormatedValue(startValue.ToString(), pDataValueFormat);
string endLabel = KPIBuilderUtils.GetFormatedValue(endValue.ToString(), pDataValueFormat);
//阀值处理
ThresholdItem thresholdItem = new ThresholdItem();
if (pFlatColors.Length > i)
{
thresholdItem.color = System.Drawing.ColorTranslator.ToHtml(pFlatColors[i]).Replace("#", "0x");
}
else
{
thresholdItem.color = "0xFF0000";
}
thresholdItem.start = startValue.ToString();
thresholdItem.end = endValue.ToString();
if ((pDataValueFormat & DataValueFormat.Int) != 0)
{
if (thresholdItem.start.IndexOf(".") > -1)
{
thresholdItem.start = thresholdItem.start.Substring(0, thresholdItem.start.IndexOf("."));
}
if (thresholdItem.end.IndexOf(".") > -1)
{
thresholdItem.end = thresholdItem.end.Substring(0, thresholdItem.end.IndexOf("."));
}
}
thresholdItem.startlabel = startLabel;
thresholdItem.endlabel = endLabel;
thresholdItem.size = (20 + i * 2).ToString();
if (Convert.ToDouble(thresholdItem.start) >= dMaxValue && lstThresholdItem.Count > 0)
{
continue;//由于误差原因，可能超过最大值。
}
lstThresholdItem.Add(thresholdItem);
}
//删除重复的分段阀值
List <ThresholdItem> lstNewThresholdItem = new List <ThresholdItem>();
lstNewThresholdItem.Add(lstThresholdItem[0]);
for (int i = 1; i < lstThresholdItem.Count; i++)
{
if (lstThresholdItem[i - 1].start != lstThresholdItem[i].start || lstThresholdItem[i - 1].end != lstThresholdItem[i].end)
{
lstNewThresholdItem.Add(lstThresholdItem[i]);
}
}
threshold1.threshold = lstNewThresholdItem.ToArray();
if (pStyleCode.ToUpper() == "SB")
{
threshold1.type = "3";
//气泡渲染要添加透明效果
foreach (var item in threshold1.threshold)
{
item.alpha = "0.8";
}
threshold1.defaultalpha = "0.8";
}
else
{
threshold1.type = "1";
}
threshold1.level = ((int)pLevel).ToString();
threshold1.defaultcolor = "0xFFFFFF";
threshold1.defaultimage = "";
threshold1.defaultsize = "20";
threshold1.defaulttext = "无数据";
lstThreshold.Add(threshold1);
//计算气泡大小
var lstData = new List <KPIFlatData>();
foreach (var kpiDataItem in pKpiDataInfo)
{
//过滤无效的数据
if (string.IsNullOrWhiteSpace(kpiDataItem.KPIData) || kpiDataItem.Ignore)
{
continue;
}
//lstThreshold
double dValue = Convert.ToDouble(kpiDataItem.KPIData);
//过滤太小的数值
//if (dValue < 0.01)
// continue;
//省市县KPI
KPIFlatData kpiData = new KPIFlatData();
if (!string.IsNullOrWhiteSpace(kpiDataItem.DataID))
{
kpiData.id = kpiDataItem.DataID;
}
kpiData.kpi = kpiDataItem.KPIData;
kpiData.kpilabel = KPIBuilderUtils.GetFormatedValue(kpiData.kpi, pDataValueFormat);
kpiData.kpimark = kpiData.kpilabel;
if (!string.IsNullOrWhiteSpace(pKpiLabelPrefix))
{
kpiData.kpilabel = pKpiLabelPrefix + kpiData.kpilabel;
}
if (!string.IsNullOrWhiteSpace(pKpiLabelSuffix))
{
kpiData.kpilabel = kpiData.kpilabel + pKpiLabelSuffix;
}
lstData.Add(kpiData);
}
KPIInformation jsonKpiData = new KPIInformation();
jsonKpiData.Data = lstData.ToArray();
jsonKpiData.Thresholds = lstThreshold.ToArray();
return(jsonKpiData.ToJSON());
}
/// <summary>
/// 获取饼图Kpi数据
/// </summary>
/// <param name="pLevel">钻取层级</param>
/// <param name="pKpiDataInfo">源数据</param>
/// <param name="pPieBlockCount">饼的分块数</param>
/// <param name="pKpiLabelPrefix">Kpi数据文本的前缀</param>
/// <param name="pKpiLabelSuffix">Kpi数据文本的后缀</param>
/// <param name="pDataValueFormat">数据显示格式</param>
/// <param name="pLegendNames">图例显示文本</param>
/// <param name="pStartColors">饼图分块渐变开始颜色</param>
/// <param name="pEndColors">饼图分块渐变截止颜色</param>
/// <param name="pStyleCode">渲染样式(SI:饼,SH:柱)</param>
/// <returns>JSON格式的KPI数据</returns>
public string GetKPIData(BoundLevel pLevel, List <KPIPieDataItem> pKpiDataInfo, int pPieBlockCount, string[] pKpiLabelPrefix, string[] pKpiLabelSuffix, DataValueFormat pDataValueFormat, string[] pLegendNames, Color[] pStartColors, Color[] pEndColors, string pStyleCode)
{
List <KPIPieData> lstKPIMultipleData = new List <KPIPieData>();
#region 根据基数值设置饼的大小
//找出最大最小值
double dMaxValue, dMinValue;
double dFirstValue = Convert.ToDouble(pKpiDataInfo[0].PieSizeData);
dMaxValue = dFirstValue;
dMinValue = dFirstValue;
foreach (var kpiDataItem in pKpiDataInfo)
{
double dCurrentValue = Convert.ToDouble(kpiDataItem.PieSizeData);
if (dCurrentValue > dMaxValue)
{
dMaxValue = dCurrentValue;
}
if (dCurrentValue < dMinValue)
{
dMinValue = dCurrentValue;
}
}
//#region //按PieSizeData设置饼的大小
double dInterval = (dMaxValue - dMinValue) / 10.0;
foreach (var kpiDataItem in pKpiDataInfo)
{
if (kpiDataItem.Ignore)
{
continue;
}
KPIPieData multipleKpiData = new KPIPieData();
double dCurrentValue = Convert.ToDouble(kpiDataItem.PieSizeData);
//当前分组级别（1，2，3，4，5）
if (dCurrentValue <= (dMinValue + dInterval * 1))
{
multipleKpiData.piesize = 1;
}
else if (dCurrentValue > (dMinValue + dInterval * 1) && dCurrentValue <= (dMinValue + dInterval * 2))
{
multipleKpiData.piesize = 2;
}
else if (dCurrentValue > (dMinValue + dInterval * 2) && dCurrentValue <= (dMinValue + dInterval * 3))
{
multipleKpiData.piesize = 3;
}
else if (dCurrentValue > (dMinValue + dInterval * 3) && dCurrentValue <= (dMinValue + dInterval * 4))
{
multipleKpiData.piesize = 4;
}
else if (dCurrentValue > (dMinValue + dInterval * 4) && dCurrentValue <= (dMinValue + dInterval * 5))
{
multipleKpiData.piesize = 5;
}
else if (dCurrentValue > (dMinValue + dInterval * 5) && dCurrentValue <= (dMinValue + dInterval * 6))
{
multipleKpiData.piesize = 6;
}
else if (dCurrentValue > (dMinValue + dInterval * 6) && dCurrentValue <= (dMinValue + dInterval * 7))
{
multipleKpiData.piesize = 7;
}
else if (dCurrentValue > (dMinValue + dInterval * 7) && dCurrentValue <= (dMinValue + dInterval * 8))
{
multipleKpiData.piesize = 8;
}
else if (dCurrentValue > (dMinValue + dInterval * 8) && dCurrentValue <= (dMinValue + dInterval * 9))
{
multipleKpiData.piesize = 9;
}
else if (dCurrentValue > (dMinValue + dInterval * 9) && dCurrentValue <= (dMinValue + dInterval * 10))
{
multipleKpiData.piesize = 10;
}
multipleKpiData.piesize = 50 + multipleKpiData.piesize * 2;
multipleKpiData.id = kpiDataItem.DataID;
#region 生成Kpi数据
//格式化Kpi数据值 格式化Kpi文本的前后缀
//KPI1
if (pPieBlockCount > 0)//
{
multipleKpiData.kpi1 = kpiDataItem.KPIData1;
//multipleKpiData.kpilabel1 = multipleKpiData.kpi1;
multipleKpiData.kpilabel1 = KPIBuilderUtils.GetFormatedValue(multipleKpiData.kpi1, pDataValueFormat);
if (pKpiLabelPrefix != null && pKpiLabelPrefix.Length > 0)
{
multipleKpiData.kpilabel1 = pKpiLabelPrefix[0] + multipleKpiData.kpilabel1;
}
if (pKpiLabelSuffix != null && pKpiLabelSuffix.Length > 0)
{
multipleKpiData.kpilabel1 = multipleKpiData.kpilabel1 + pKpiLabelSuffix[0];
}
}
//KPI2
if (pPieBlockCount > 1)
{
multipleKpiData.kpi2 = kpiDataItem.KPIData2;
//multipleKpiData.kpilabel2 = multipleKpiData.kpi2;
multipleKpiData.kpilabel2 = KPIBuilderUtils.GetFormatedValue(multipleKpiData.kpi2, pDataValueFormat);
if (pKpiLabelPrefix != null && pKpiLabelPrefix.Length > 1)
{
multipleKpiData.kpilabel2 = pKpiLabelPrefix[1] + multipleKpiData.kpilabel2;
}
if (pKpiLabelSuffix != null && pKpiLabelSuffix.Length > 1)
{
multipleKpiData.kpilabel2 = multipleKpiData.kpilabel2 + pKpiLabelSuffix[1];
}
}
//KPI3
if (pPieBlockCount > 2)
{
multipleKpiData.kpi3 = kpiDataItem.KPIData3;
//multipleKpiData.kpilabel3 = multipleKpiData.kpi3;
multipleKpiData.kpilabel3 = KPIBuilderUtils.GetFormatedValue(multipleKpiData.kpi3, pDataValueFormat);
if (pKpiLabelPrefix != null && pKpiLabelPrefix.Length > 2)
{
multipleKpiData.kpilabel3 = pKpiLabelPrefix[2] + multipleKpiData.kpilabel3;
}
if (pKpiLabelSuffix != null && pKpiLabelSuffix.Length > 2)
{
multipleKpiData.kpilabel3 = multipleKpiData.kpilabel3 + pKpiLabelSuffix[2];
}
}
//KPI4
if (pPieBlockCount > 3)
{
multipleKpiData.kpi4 = kpiDataItem.KPIData4;
//multipleKpiData.kpilabel4 = multipleKpiData.kpi4;
multipleKpiData.kpilabel4 = KPIBuilderUtils.GetFormatedValue(multipleKpiData.kpi4, pDataValueFormat);
if (pKpiLabelPrefix != null && pKpiLabelPrefix.Length > 3)
{
multipleKpiData.kpilabel4 = pKpiLabelPrefix[3] + multipleKpiData.kpilabel4;
}
if (pKpiLabelSuffix != null && pKpiLabelSuffix.Length > 3)
{
multipleKpiData.kpilabel4 = multipleKpiData.kpilabel4 + pKpiLabelSuffix[3];
}
}
//KPI5
if (pPieBlockCount > 4)
{
multipleKpiData.kpi5 = kpiDataItem.KPIData5;
//multipleKpiData.kpilabel5 = multipleKpiData.kpi5;
multipleKpiData.kpilabel5 = KPIBuilderUtils.GetFormatedValue(multipleKpiData.kpi5, pDataValueFormat);
if (pKpiLabelPrefix != null && pKpiLabelPrefix.Length > 4)
{
multipleKpiData.kpilabel5 = pKpiLabelPrefix[4] + multipleKpiData.kpilabel5;
}
if (pKpiLabelSuffix != null && pKpiLabelSuffix.Length > 4)
{
multipleKpiData.kpilabel5 = multipleKpiData.kpilabel5 + pKpiLabelSuffix[4];
}
}
#endregion 生成Kpi数据
lstKPIMultipleData.Add(multipleKpiData);
}
#endregion 根据基数值设置饼的大小
#region 设置块的颜色
List <PieThreshold> lstThreshold = new List <PieThreshold>();
PieThreshold threshold = new PieThreshold();
threshold.level = ((int)pLevel).ToString();
List <PieThresholdItem> lstThresholdItem = new List <PieThresholdItem>();
for (int i = 0; i < pPieBlockCount; i++)
{
PieThresholdItem thresholdItem1 = new PieThresholdItem();
thresholdItem1.startcolor = System.Drawing.ColorTranslator.ToHtml(pStartColors[i]).Replace("#", "0x");
thresholdItem1.endcolor = System.Drawing.ColorTranslator.ToHtml(pEndColors[i]).Replace("#", "0x");
thresholdItem1.legendname = pLegendNames[i];
lstThresholdItem.Add(thresholdItem1);
}
threshold.threshold = lstThresholdItem.ToArray();
if (pStyleCode.ToUpper() == "SI")
{
threshold.type = "10";
}
else
{
threshold.type = "11";
}
lstThreshold.Add(threshold);
#endregion
KPIInformation kpiInformation = new KPIInformation();
kpiInformation.Data = lstKPIMultipleData.ToArray();
kpiInformation.Thresholds = lstThreshold.ToArray();
var tempJsonString = kpiInformation.ToJSON();
return(tempJsonString);
}
/// <summary>
/// 根据指定的格式对字符串进行格式化
/// </summary>
/// <param name="pOriginalValue">原始数据字符串</param>
/// <param name="pDataValueFormat">格式化类型</param>
/// <returns>格式化之后的字符串</returns>
public static string GetFormatedValue(string pOriginalValue, DataValueFormat pDataValueFormat)
{
string result = pOriginalValue;
double tempValue;
//处理小数位数格式化
if ((pDataValueFormat & DataValueFormat.Decimal1) != 0)
{//转换1位小数
if (double.TryParse(result, out tempValue))
{
result = tempValue.ToString("f1");
}
}
if ((pDataValueFormat & DataValueFormat.Decimal2) != 0)
{//转换2位小数
if (double.TryParse(result, out tempValue))
{
result = tempValue.ToString("f2");
}
}
if ((pDataValueFormat & DataValueFormat.Decimal3) != 0)
{//转换3位小数
if (double.TryParse(result, out tempValue))
{
result = tempValue.ToString("f3");
}
}
if ((pDataValueFormat & DataValueFormat.Decimal4) != 0)
{//转换4位小数
if (double.TryParse(result, out tempValue))
{
result = tempValue.ToString("f4");
}
}
if ((pDataValueFormat & DataValueFormat.Decimal5) != 0)
{//转换5位小数
if (double.TryParse(result, out tempValue))
{
result = tempValue.ToString("f5");
}
}
if ((pDataValueFormat & DataValueFormat.Decimal6) != 0)
{//转换6位小数
if (double.TryParse(result, out tempValue))
{
result = tempValue.ToString("f6");
}
}
if ((pDataValueFormat & DataValueFormat.Decimal7) != 0)
{//转换7位小数
if (double.TryParse(result, out tempValue))
{
result = tempValue.ToString("f7");
}
}
if ((pDataValueFormat & DataValueFormat.Decimal8) != 0)
{//转换8位小数
if (double.TryParse(result, out tempValue))
{
result = tempValue.ToString("f8");
}
}
if ((pDataValueFormat & DataValueFormat.Percentage) != 0)
{//转换成百分数
if (double.TryParse(result, out tempValue))
{
result = tempValue.ToString("p");
}
}
if ((pDataValueFormat & DataValueFormat.Permil) != 0)
{//转换成带千分位的字符串
if (double.TryParse(result, out tempValue))
{
result = tempValue.ToString("n");
}
}
if ((pDataValueFormat & DataValueFormat.Int) != 0)
{//转换成整数
if (result.IndexOf(".") >= 0)
{
result = result.Substring(0, result.IndexOf("."));
}
}
return(result);
}
