xinjiang/SGGL/FineUIPro.Web/Person/PersonPlanChart.aspx.cs

194 lines
8.7 KiB
C#

using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BLL;
namespace FineUIPro.Web.Person
{
public partial class PersonPlanChart : PageBase
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
}
}
#region
/// <summary>
/// 按单位统计
/// </summary>
protected string Four1
{
get
{
List<Model.SingleSerie> series = new List<Model.SingleSerie>();
Model.BusinessColumn businessColumn = new Model.BusinessColumn();
List<string> listCategories = new List<string>();
Model.SingleSerie s1 = new Model.SingleSerie();
Model.SingleSerie s2 = new Model.SingleSerie();
Model.SingleSerie s3 = new Model.SingleSerie();
Model.SingleSerie s4 = new Model.SingleSerie();
Model.SingleSerie s5 = new Model.SingleSerie();
Model.SingleSerie s6 = new Model.SingleSerie();
Model.SingleSerie s7 = new Model.SingleSerie();
Model.SingleSerie s8 = new Model.SingleSerie();
Model.SingleSerie s9 = new Model.SingleSerie();
Model.SingleSerie s10 = new Model.SingleSerie();
Model.SingleSerie s11 = new Model.SingleSerie();
Model.SingleSerie s12 = new Model.SingleSerie();
List<double> listdata1 = new List<double>();
List<double> listdata2 = new List<double>();
List<double> listdata3 = new List<double>();
List<double> listdata4 = new List<double>();
List<double> listdata5 = new List<double>();
List<double> listdata6 = new List<double>();
List<double> listdata7 = new List<double>();
List<double> listdata8 = new List<double>();
List<double> listdata9 = new List<double>();
List<double> listdata10 = new List<double>();
List<double> listdata11 = new List<double>();
List<double> listdata12 = new List<double>();
var totalList = from x in Funs.DB.Person_PersonPlan where x.Years == DateTime.Now.Year select x;
businessColumn.title = "人员初步规划统计";
var items = DropListService.drpPersonTypeList();
foreach (var item in items)
{
listCategories.Add(item.Text);
var list = totalList.Where(x => x.PersonType == item.Value);
listdata1.Add(list.Count(x => x.Month1 == true));
listdata2.Add(list.Count(x => x.Month2 == true));
listdata3.Add(list.Count(x => x.Month3 == true));
listdata4.Add(list.Count(x => x.Month4 == true));
listdata5.Add(list.Count(x => x.Month5 == true));
listdata6.Add(list.Count(x => x.Month6 == true));
listdata7.Add(list.Count(x => x.Month7 == true));
listdata8.Add(list.Count(x => x.Month8 == true));
listdata9.Add(list.Count(x => x.Month9 == true));
listdata10.Add(list.Count(x => x.Month10 == true));
listdata11.Add(list.Count(x => x.Month11 == true));
listdata12.Add(list.Count(x => x.Month12 == true));
}
s1.data = listdata1;
series.Add(s1);
s2.data = listdata2;
series.Add(s2);
s3.data = listdata3;
series.Add(s3);
s4.data = listdata4;
series.Add(s4);
s5.data = listdata5;
series.Add(s5);
s6.data = listdata6;
series.Add(s6);
s7.data = listdata7;
series.Add(s7);
s8.data = listdata8;
series.Add(s8);
s9.data = listdata9;
series.Add(s9);
s10.data = listdata10;
series.Add(s10);
s11.data = listdata11;
series.Add(s11);
s12.data = listdata12;
series.Add(s12);
businessColumn.categories = listCategories;
businessColumn.series = series;
return JsonConvert.SerializeObject(businessColumn);
}
}
/// <summary>
/// 按类型统计
/// </summary>
protected string Four2
{
get
{
List<Model.SingleSerie> series = new List<Model.SingleSerie>();
Model.BusinessColumn businessColumn = new Model.BusinessColumn();
List<string> listCategories = new List<string>();
Model.SingleSerie s1 = new Model.SingleSerie();
Model.SingleSerie s2 = new Model.SingleSerie();
Model.SingleSerie s3 = new Model.SingleSerie();
Model.SingleSerie s4 = new Model.SingleSerie();
Model.SingleSerie s5 = new Model.SingleSerie();
Model.SingleSerie s6 = new Model.SingleSerie();
Model.SingleSerie s7 = new Model.SingleSerie();
Model.SingleSerie s8 = new Model.SingleSerie();
Model.SingleSerie s9 = new Model.SingleSerie();
Model.SingleSerie s10 = new Model.SingleSerie();
Model.SingleSerie s11 = new Model.SingleSerie();
Model.SingleSerie s12 = new Model.SingleSerie();
List<double> listdata1 = new List<double>();
List<double> listdata2 = new List<double>();
List<double> listdata3 = new List<double>();
List<double> listdata4 = new List<double>();
List<double> listdata5 = new List<double>();
List<double> listdata6 = new List<double>();
List<double> listdata7 = new List<double>();
List<double> listdata8 = new List<double>();
List<double> listdata9 = new List<double>();
List<double> listdata10 = new List<double>();
List<double> listdata11 = new List<double>();
List<double> listdata12 = new List<double>();
var totalList = from x in Funs.DB.Person_PersonPlan where x.Years == DateTime.Now.Year select x;
businessColumn.title = "人员初步规划统计";
var items = (from x in totalList select x.Major).Distinct().ToList();
foreach (var item in items)
{
listCategories.Add(item);
var list = totalList.Where(x => x.Major == item);
listdata1.Add(list.Count(x => x.Month1 == true));
listdata2.Add(list.Count(x => x.Month2 == true));
listdata3.Add(list.Count(x => x.Month3 == true));
listdata4.Add(list.Count(x => x.Month4 == true));
listdata5.Add(list.Count(x => x.Month5 == true));
listdata6.Add(list.Count(x => x.Month6 == true));
listdata7.Add(list.Count(x => x.Month7 == true));
listdata8.Add(list.Count(x => x.Month8 == true));
listdata9.Add(list.Count(x => x.Month9 == true));
listdata10.Add(list.Count(x => x.Month10 == true));
listdata11.Add(list.Count(x => x.Month11 == true));
listdata12.Add(list.Count(x => x.Month12 == true));
}
s1.data = listdata1;
series.Add(s1);
s2.data = listdata2;
series.Add(s2);
s3.data = listdata3;
series.Add(s3);
s4.data = listdata4;
series.Add(s4);
s5.data = listdata5;
series.Add(s5);
s6.data = listdata6;
series.Add(s6);
s7.data = listdata7;
series.Add(s7);
s8.data = listdata8;
series.Add(s8);
s9.data = listdata9;
series.Add(s9);
s10.data = listdata10;
series.Add(s10);
s11.data = listdata11;
series.Add(s11);
s12.data = listdata12;
series.Add(s12);
businessColumn.categories = listCategories;
businessColumn.series = series;
return JsonConvert.SerializeObject(businessColumn);
}
}
#endregion
}
}