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
    }
}