public string GetKpiTypeData(List <KPIPointDataItem> pKpiDataInfo, string pLabelPrefix, string pLabelSuffix, string pKpiText, int pTypeCount, string[] pTypeName, string[] pTypeLabel, string[] pTypeIcon, string pDefaultLegend, string pDefaultIcon)
{
var lstData = new List <KPIPointData>();
foreach (var kpiDataItem in pKpiDataInfo)
{//点 KPI
KPIPointData kpiData = new KPIPointData();
if (!string.IsNullOrWhiteSpace(kpiDataItem.StoreID))
{
kpiData.id = kpiDataItem.StoreID;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.StoreName))
{
kpiData.title = kpiDataItem.StoreName;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.StoreAddress))
{
kpiData.address = kpiDataItem.StoreAddress;
}
kpiData.xytype = kpiDataItem.GPSType;
kpiData.x = kpiDataItem.Longitude;
kpiData.y = kpiDataItem.Latitude;
if (kpiDataItem.KPIData != null)
{
kpiData.kpi = kpiDataItem.KPIData;
var tempKpiLabel = kpiDataItem.KPILabel;
if (!string.IsNullOrWhiteSpace(pLabelPrefix))
{
kpiData.kpilabel = pLabelPrefix;
}
if (string.IsNullOrWhiteSpace(tempKpiLabel))
{
kpiData.kpilabel += kpiDataItem.KPIData;
}
else
{
kpiData.kpilabel += tempKpiLabel;
}
if (!string.IsNullOrWhiteSpace(pLabelSuffix))
{
kpiData.kpilabel += pLabelSuffix;
}
;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.KPIFilter1))
{
kpiData.kpifilter1 = kpiDataItem.KPIFilter1;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.KPIFilter2))
{
kpiData.kpifilter2 = kpiDataItem.KPIFilter2;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.KPIFilter3))
{
kpiData.kpifilter3 = kpiDataItem.KPIFilter3;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.KPIFilter4))
{
kpiData.kpifilter4 = kpiDataItem.KPIFilter4;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.KPIFilter5))
{
kpiData.kpifilter5 = kpiDataItem.KPIFilter5;
}
//弹出框
kpiData.poptype = kpiDataItem.PopWindowType;
kpiData.popwidth = kpiDataItem.PopWindowWidth;
kpiData.popheight = kpiDataItem.PopWindowHeight;
kpiData.poptitle = kpiDataItem.PopWindowTitle;
kpiData.popurl = kpiDataItem.PopWindowUrl;
if (string.IsNullOrWhiteSpace(kpiData.popurl))
{
//这些先写死
//kpiData.popwidth = "500";
//kpiData.popheight = "350";
//kpiData.poptitle = string.Empty;
kpiData.popurl = string.Format(@"/Module/MapAnalysis/Common/StoreInfo.aspx?sid={0}&kpilabel={1}&kpitext={2}", kpiData.id, kpiData.kpilabel, pKpiText);
}
lstData.Add(kpiData);
}
//设置阀值
List <Threshold> lstThreshold = new List <Threshold>();
Threshold threshold1 = new Threshold();
threshold1.level = "4";
threshold1.type = "6";
threshold1.defaultimage = pDefaultIcon;
threshold1.defaulttext = pDefaultLegend;
List <ThresholdItem> lstThresholdItem = new List <ThresholdItem>();
for (int i = 0; i < pTypeCount; i++)
{
ThresholdItem thresholdItem = new ThresholdItem();
thresholdItem.image = pTypeIcon[i];
thresholdItem.text = pTypeName[i];
thresholdItem.textlabel = pTypeLabel[i];
lstThresholdItem.Add(thresholdItem);
}
threshold1.threshold = lstThresholdItem.ToArray();
lstThreshold.Add(threshold1);
var orderedItems = lstData.OrderBy(item => item.kpi);
KPIInformation kpiInformation = new KPIInformation();
kpiInformation.Data = lstData.ToArray();
kpiInformation.Thresholds = lstThreshold.ToArray();
var tempJsonString = kpiInformation.ToJSON();
return(tempJsonString);
}
/// <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);
}
public string GetKpiValueData(List <KPIPointDataItem> pKpiDataInfo, string pLabelPrefix, string pLabelSuffix, string pKpiText, string[] pValueIcon, string pDefaultLegend, string pDefaultIcon)
{
var lstData = new List <KPIPointData>();
foreach (var kpiDataItem in pKpiDataInfo)
{//点 KPI
KPIPointData kpiData = new KPIPointData();
if (!string.IsNullOrWhiteSpace(kpiDataItem.StoreID))
{
kpiData.id = kpiDataItem.StoreID;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.StoreName))
{
kpiData.title = kpiDataItem.StoreName;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.StoreAddress))
{
kpiData.address = kpiDataItem.StoreAddress;
}
kpiData.xytype = kpiDataItem.GPSType;
kpiData.x = kpiDataItem.Longitude;
kpiData.y = kpiDataItem.Latitude;
if (kpiDataItem.KPIData != null)
{
kpiData.kpi = kpiDataItem.KPIData;
var tempKpiLabel = kpiDataItem.KPILabel;
if (!string.IsNullOrWhiteSpace(pLabelPrefix))
{
kpiData.kpilabel = pLabelPrefix;
}
if (string.IsNullOrWhiteSpace(tempKpiLabel))
{
kpiData.kpilabel += kpiDataItem.KPIData;
}
else
{
kpiData.kpilabel += tempKpiLabel;
}
if (!string.IsNullOrWhiteSpace(pLabelSuffix))
{
kpiData.kpilabel += pLabelSuffix;
}
;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.KPIFilter1))
{
kpiData.kpifilter1 = kpiDataItem.KPIFilter1;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.KPIFilter2))
{
kpiData.kpifilter2 = kpiDataItem.KPIFilter2;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.KPIFilter3))
{
kpiData.kpifilter3 = kpiDataItem.KPIFilter3;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.KPIFilter4))
{
kpiData.kpifilter4 = kpiDataItem.KPIFilter4;
}
if (!string.IsNullOrWhiteSpace(kpiDataItem.KPIFilter5))
{
kpiData.kpifilter5 = kpiDataItem.KPIFilter5;
}
//这些先写死
kpiData.popwidth = "500";
kpiData.popheight = "350";
kpiData.poptitle = string.Empty;
kpiData.popurl = string.Format(@"/Module/MapAnalysis/Common/StoreInfo.aspx?sid={0}&kpilabel={1}&kpitext={2}", kpiData.id, kpiData.kpilabel, pKpiText);
lstData.Add(kpiData);
}
//设置阀值
List <Threshold> lstThreshold = new List <Threshold>();
Threshold threshold1 = new Threshold();
List <ThresholdItem> lstThresholdItem = new List <ThresholdItem>();
//找出最大最小值
double dMaxValue, dMinValue;
double dFirstValue = Convert.ToDouble(pKpiDataInfo[0].KPIData);
dMaxValue = dFirstValue;
dMinValue = dFirstValue;
foreach (var pointItem in pKpiDataInfo)
{
//KPIPointData pointItem = (KPIPointData)item;
double dCurrentValue = Convert.ToDouble(pointItem.KPIData);
if (dCurrentValue > dMaxValue)
{
dMaxValue = dCurrentValue;
}
if (dCurrentValue < dMinValue)
{
dMinValue = dCurrentValue;
}
}
double dInterval = (dMaxValue - dMinValue) / 5;
for (int i = 0; i < 5; i++)
{
ThresholdItem thresholdItem = new ThresholdItem();
thresholdItem.image = pValueIcon[i];
thresholdItem.start = (dMinValue + dInterval * i).ToString("0.00");
thresholdItem.startlabel = (dMinValue + dInterval * i).ToString("0.00");
thresholdItem.end = (dMinValue + dInterval * (i + 1)).ToString("0.00");
thresholdItem.endlabel = (dMinValue + dInterval * (i + 1)).ToString("0.00");
lstThresholdItem.Add(thresholdItem);
}
//删除重复阀值
List <ThresholdItem> lstNewThresholdItem = new List <ThresholdItem>();
lstNewThresholdItem.Add(lstThresholdItem[0]);
for (int i = 1; i < 5; i++)
{
if (lstThresholdItem[i - 1].start != lstThresholdItem[i].start || lstThresholdItem[i - 1].end != lstThresholdItem[i].end)
{
lstNewThresholdItem.Add(lstThresholdItem[i]);
}
}
threshold1.threshold = lstNewThresholdItem.ToArray();
threshold1.level = "4";
threshold1.type = "5";
threshold1.defaultcolor = "0x000000";
threshold1.defaultimage = pDefaultIcon;
threshold1.defaulttext = pDefaultLegend;
lstThreshold.Add(threshold1);
var orderedItems = lstData.OrderBy(item => item.kpi);
KPIInformation kpiInformation = new KPIInformation();
kpiInformation.Data = lstData.ToArray();
kpiInformation.Thresholds = lstThreshold.ToArray();
var tempJsonString = kpiInformation.ToJSON();
return(tempJsonString);
}
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());
}
