public PartialViewResult GetCompanyStatusChart()
{
SimpleChartModel chartModel = new SimpleChartModel();
chartModel.ChartType = DotNet.Highcharts.Enums.ChartTypes.Pie;
chartModel.ContainerId = "companyStatusChart";
chartModel.Title = "客户状态";
YSeries series = new YSeries();
series.YName = "数量";
chartModel.ValueSuffix = "个";
//读取公司的表，group by 销售名
OtaCrmModel db = new OtaCrmModel();
var ss = from i in db.OtaCompany
where i.BusinessStatus != null
group i by i.BusinessStatus
into g
select new { count = g.Count(), businessStatus = g.Key };
List <object[]> pieDataList = new List <object[]>();
foreach (var item in ss)
{
object[] pieData = new object[] { item.businessStatus, item.count };
pieDataList.Add(pieData);
}
chartModel.pieDataList = pieDataList;
DotNet.Highcharts.Highcharts chart = GetPieChart(chartModel);
return(PartialView("_PartialChartView", chart));
}
public PartialViewResult GetCompanyCountChart()
{
SimpleChartModel chartModel = new SimpleChartModel();
chartModel.Height = 500;
chartModel.ContainerId = "companyCountChart";
chartModel.Title = "客户数量";
chartModel.SeriesList = new List <YSeries>();
YSeries series = new YSeries();
series.YSeriesList = new List <object>();
series.YName = "数量";
chartModel.YTitle = DateTime.Today.ToString("yyyy-MM-dd");
chartModel.ValueSuffix = "个";
//读取公司的表，group by 销售名
OtaCrmModel db = new OtaCrmModel();
var ss = from i in db.OtaCompany
group i by i.SalesUserName
into g
select new { count = g.Count(), userName = g.Key };
foreach (var item in ss)
{
chartModel.XList.Add(item.userName);
series.YSeriesList.Add(item.count);
}
chartModel.SeriesList.Add(series);
DotNet.Highcharts.Highcharts chart = GetChart(chartModel);
return(PartialView("_PartialChartView", chart));
}
public DotNet.Highcharts.Highcharts GetChart(SimpleChartModel chartModel)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(chartModel.ContainerId);
//初始化
DotNet.Highcharts.Options.Chart chartOption = new DotNet.Highcharts.Options.Chart();
chartOption.DefaultSeriesType = chartModel.ChartType;
chartOption.Width = chartModel.Width;
chartOption.Height = chartModel.Height;
chart.InitChart(chartOption);
//设置标题
DotNet.Highcharts.Options.Title title = new DotNet.Highcharts.Options.Title();
title.Align = DotNet.Highcharts.Enums.HorizontalAligns.Center;
title.Text = chartModel.Title;
chart.SetTitle(title);
//提示
DotNet.Highcharts.Options.Tooltip tooltip = new DotNet.Highcharts.Options.Tooltip();
tooltip.ValueSuffix = chartModel.ValueSuffix;
chart.SetTooltip(tooltip);
DotNet.Highcharts.Options.PlotOptions plotOptions = new DotNet.Highcharts.Options.PlotOptions();
plotOptions.Bar = new DotNet.Highcharts.Options.PlotOptionsBar();
plotOptions.Bar.DataLabels = new DotNet.Highcharts.Options.PlotOptionsBarDataLabels();
plotOptions.Bar.DataLabels.Enabled = true;
chart.SetPlotOptions(plotOptions);
//横坐标
DotNet.Highcharts.Options.XAxis xs = new DotNet.Highcharts.Options.XAxis();
xs.Categories = chartModel.XList.ToArray();
xs.Title = new DotNet.Highcharts.Options.XAxisTitle();
xs.Title.Text = chartModel.XTitle;
chart.SetXAxis(xs);
//纵坐标
DotNet.Highcharts.Options.YAxis ys = new DotNet.Highcharts.Options.YAxis();
ys.Title = new DotNet.Highcharts.Options.YAxisTitle();
ys.Title.Text = chartModel.YTitle;
chart.SetYAxis(ys);
//设置表现值
List <DotNet.Highcharts.Options.Series> ssList = new List <DotNet.Highcharts.Options.Series>();
foreach (YSeries yserires in chartModel.SeriesList)
{
DotNet.Highcharts.Options.Series ss = new DotNet.Highcharts.Options.Series();
ss.Data = new DotNet.Highcharts.Helpers.Data(yserires.YSeriesList.ToArray());
ss.Name = yserires.YName;
ssList.Add(ss);
}
chart.SetSeries(ssList.ToArray());
return(chart);
}
public DotNet.Highcharts.Highcharts GetPieChart(SimpleChartModel chartModel)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(chartModel.ContainerId);
//初始化
DotNet.Highcharts.Options.Chart chartOption = new DotNet.Highcharts.Options.Chart();
chartOption.DefaultSeriesType = chartModel.ChartType;
chartOption.Width = chartModel.Width;
chartOption.Height = chartModel.Height;
chart.InitChart(chartOption);
//设置标题
DotNet.Highcharts.Options.Title title = new DotNet.Highcharts.Options.Title();
title.Align = DotNet.Highcharts.Enums.HorizontalAligns.Center;
title.Text = chartModel.Title;
chart.SetTitle(title);
//提示
DotNet.Highcharts.Options.Tooltip tooltip = new DotNet.Highcharts.Options.Tooltip();
tooltip.ValueSuffix = chartModel.ValueSuffix;
tooltip.PointFormat = "{point.name}: <b>{point.y}</b>";
chart.SetTooltip(tooltip);
//饼图
DotNet.Highcharts.Options.PlotOptions plotOptions = new DotNet.Highcharts.Options.PlotOptions();
plotOptions.Pie = new DotNet.Highcharts.Options.PlotOptionsPie();
plotOptions.Pie.AllowPointSelect = true;
plotOptions.Pie.Cursor = DotNet.Highcharts.Enums.Cursors.Pointer;
plotOptions.Pie.ShowInLegend = true;
plotOptions.Pie.DataLabels = new DotNet.Highcharts.Options.PlotOptionsPieDataLabels();
plotOptions.Pie.DataLabels.Enabled = true;
plotOptions.Pie.DataLabels.Format = "<b>{point.name}</b>: {point.y}个";
chart.SetPlotOptions(plotOptions);
//设置表现值
List <DotNet.Highcharts.Options.Series> ssList = new List <DotNet.Highcharts.Options.Series>();
DotNet.Highcharts.Options.Series ss = new DotNet.Highcharts.Options.Series();
ss.Type = DotNet.Highcharts.Enums.ChartTypes.Pie;
ss.Name = chartModel.Title;
ss.Data = new DotNet.Highcharts.Helpers.Data(chartModel.pieDataList.ToArray());
ssList.Add(ss);
chart.SetSeries(ssList.ToArray());
return(chart);
}
public PartialViewResult GetMeetCountChart()
{
SimpleChartModel chartModel = new SimpleChartModel();
chartModel.ContainerId = "meetChart";
chartModel.Title = "沟通频率";
chartModel.SeriesList = new List <YSeries>();
YSeries series = new YSeries();
series.YSeriesList = new List <object>();
series.YName = "次数";
chartModel.ValueSuffix = "次";
//读取meeting表，按照时间为上一周
DateTime startWeek = DateTime.Now.AddDays(1 - Convert.ToInt32(DateTime.Now.DayOfWeek.ToString("d")));
startWeek = startWeek.AddDays(-7);
DateTime endWeek = startWeek.AddDays(6);
chartModel.YTitle = startWeek.ToString("yyyyMMdd") + "-" + endWeek.ToString("yyyyMMdd");
OtaCrmModel db = new OtaCrmModel();
var ss = from i in db.CompanyMeeting
where i.MeetDate >= startWeek && i.MeetDate <= endWeek
group i by i.CreateUserName
into g
select new { count = g.Count(), userName = g.Key };
AccountController ac = new AccountController();
foreach (var item in ss)
{
chartModel.XList.Add(ac.GetRealName(item.userName));
series.YSeriesList.Add(item.count);
}
chartModel.SeriesList.Add(series);
DotNet.Highcharts.Highcharts chart = GetChart(chartModel);
return(PartialView("_PartialChartView", chart));
}
public PartialViewResult GetCompanyTicketRangeChart()
{
SimpleChartModel chartModel = new SimpleChartModel();
chartModel.ContainerId = "companyTicketRangeChart";
chartModel.ChartType = DotNet.Highcharts.Enums.ChartTypes.Pie;
chartModel.Title = "客户票量级别";
chartModel.SeriesList = new List <YSeries>();
YSeries series = new YSeries();
series.YName = "数量";
chartModel.ValueSuffix = "个";
string level0 = "零";
string level1 = "1_50";
string level2 = "50_200";
string level3 = "200_500";
string level4 = "500_1000";
string level5 = "1000以上";
//读取公司的表，group by 销售名
OtaCrmModel db = new OtaCrmModel();
DateTime startDate = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-01"));
DateTime endDate = db.AgentGradeOperation.Max(p => p.statDate).Value;
TimeSpan ts = endDate - startDate;
int days = ts.Days;
if (days == 0)
{
days = 1;
}
var q = from p in db.AgentGradeOperation
where p.statDate == endDate
group p by p.agentName
into g
select new { sum = g.Sum(i => i.totalTicketNum.Value), company = g.Key };
//按照公司名，分组，然后求平均值，应该先算日期的天数
int countLevel0 = 0;
int countLevel1 = 0;
int countLevel2 = 0;
int countLevel3 = 0;
int countLevel4 = 0;
int countLevel5 = 0;
foreach (var item in q)
{
int everageNum = item.sum / days;
if (everageNum == 0)
{
countLevel0++;
}
if (everageNum > 0 && everageNum < 50)
{
countLevel1++;
}
if (everageNum >= 50 && everageNum < 200)
{
countLevel2++;
}
if (everageNum >= 200 && everageNum < 500)
{
countLevel3++;
}
if (everageNum >= 500 && everageNum < 1000)
{
countLevel4++;
}
if (everageNum >= 1000)
{
countLevel5++;
}
}
List <object[]> pieDataList = new List <object[]>();
object[] pieData0 = new object[] { level0, countLevel0 };
if (countLevel0 > 0)
{
pieDataList.Add(pieData0);
}
object[] pieData1 = new object[] { level1, countLevel1 };
if (countLevel1 > 0)
{
pieDataList.Add(pieData1);
}
object[] pieData2 = new object[] { level2, countLevel2 };
if (countLevel2 > 0)
{
pieDataList.Add(pieData2);
}
object[] pieData3 = new object[] { level3, countLevel3 };
if (countLevel3 > 0)
{
pieDataList.Add(pieData3);
}
object[] pieData4 = new object[] { level4, countLevel4 };
if (countLevel4 > 0)
{
pieDataList.Add(pieData4);
}
object[] pieData5 = new object[] { level5, countLevel5 };
if (countLevel5 > 0)
{
pieDataList.Add(pieData5);
}
chartModel.pieDataList = pieDataList;
DotNet.Highcharts.Highcharts chart = GetPieChart(chartModel);
return(PartialView("_PartialChartView", chart));
}
public PartialViewResult GetCompanyTicketCountChart(string companyName)
{
//调用30天的数据
DateTime startDate = DateTime.Today.AddMonths(-1);
OtaCrmModel db = new OtaCrmModel();
var a = from b in db.AgentGradeOperation
where b.agentName == companyName && b.statDate >= startDate
orderby b.statDate, b.agentDomain
select b;
SimpleChartModel chartModel = new SimpleChartModel();
chartModel.ChartType = DotNet.Highcharts.Enums.ChartTypes.Line;
chartModel.Width = 600;
chartModel.ContainerId = "companyTicketChart";
chartModel.Title = "票量";
chartModel.SeriesList = new List <YSeries>();
//分开域名，
Dictionary <string, int> agoTicketCountDict = new Dictionary <string, int>();
List <string> domainList = new List <string>();
foreach (AgentGradeOperation item in a)
{
if (!domainList.Contains(item.agentDomain))
{
domainList.Add(item.agentDomain);
}
string key = item.agentDomain + item.statDate.Value.ToString("yyyyMMdd");
if (!agoTicketCountDict.ContainsKey(key))
{
agoTicketCountDict.Add(key, item.CurDateTicketCount.Value);
}
}
TimeSpan ts = DateTime.Today - startDate;
for (int i = 0; i < ts.Days; i++)
{
DateTime curDate = startDate.AddDays(i);
string xValue = curDate.ToString("MMdd");
chartModel.XList.Add(xValue);
}
//每个域名按天统计数据，加入series
foreach (string agentDomain in domainList)
{
YSeries series = new YSeries();
series.YSeriesList = new List <object>();
series.YName = agentDomain;
for (int i = 0; i < ts.Days; i++)
{
DateTime curDate = startDate.AddDays(i);
string xValue = curDate.ToString("yyyyMMdd");
string key = agentDomain + xValue;
int ticketCount = 0;
if (agoTicketCountDict.ContainsKey(key))
{
ticketCount = agoTicketCountDict[key];
}
series.YSeriesList.Add(ticketCount);
}
chartModel.SeriesList.Add(series);
}
chartModel.ValueSuffix = "张";
DotNet.Highcharts.Highcharts chart = GetChart(chartModel);
return(PartialView("_PartialChartView", chart));
}
