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
{
    public partial class mainMenu_CQMS_1 : PageBase
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //  ClientScript.RegisterClientScriptBlock(typeof(Page), "", " category_One('one1', '项目质量验收一次合格率', " + new mainMenu_CQMS().One1 + ")", true);
            }
        }
        #region 焊工总数
        protected string welderNum
        {
            get
            {
                if (CurrUser.UnitId == Const.UnitId_TCC)
                { 
                    return Funs.DB.BS_Welder.Where(x => x.ProjectId == CurrUser.LoginProjectId).Count().ToString();
                }
                else
                { 
                    return Funs.DB.BS_Welder.Where(x => x.ProjectId == CurrUser.LoginProjectId&&x.WED_Unit==CurrUser.UnitId).Count().ToString();
                }
                 
            }
        
        }
        #endregion


        #region  施工方案
        protected string ConstructSolution
        {
            get
            {
                List<Model.SingleSerie> series = new List<Model.SingleSerie>();
                Model.BusinessColumn businessColumn = new Model.BusinessColumn();
                List<string> listCategories = new List<string>();
                businessColumn.title = "施工方案";
                businessColumn.xFontNum = 14;
                var solution =  Funs.DB.Solution_CQMSConstructSolution.ToList();
                Model.SingleSerie s = new Model.SingleSerie();
                Model.SingleSerie s2 = new Model.SingleSerie();
                List<double> listdata = new List<double>();
                listdata.Add(0);
                listdata.Add(solution.Where(x=>x.State==BLL.Const.CQMSConstructSolution_Complete  && x.ProjectId==CurrUser.LoginProjectId  ).Count());
                s.data = listdata;
                s2 = new Model.SingleSerie();

                listdata = new List<double>();
               
                listdata.Add(solution.Where(x => x.State == BLL.Const.CQMSConstructSolution_Audit && x.ProjectId == CurrUser.LoginProjectId).Count());
                listdata.Add(0);
                s2.data = listdata;
                series.Add(s);
                series.Add(s2);
                businessColumn.categories = listCategories;
                businessColumn.series = series;
                return JsonConvert.SerializeObject(businessColumn);
            }
        }
        #endregion

        #region 项目质量问题整改完成率
        protected string One3
        {
            get
            {
                List<Model.View_Check_JointCheckDetail> totalCheckLists = JointCheckDetailService.GetTotalJointCheckDetailListByTime(CurrUser.LoginProjectId, DateTime.Now);
                int a = totalCheckLists.Where(x => x.OK == 1).Count();
                double result = 0.00;
                if (a > 0 && totalCheckLists.Count > 0)
                {
                    var b = Convert.ToDouble(totalCheckLists.Count);
                    result = Convert.ToDouble(decimal.Round(decimal.Parse((a / b * 100).ToString()), 2));
                }
                return JsonConvert.SerializeObject(result);
            }
        }
        #endregion

        #region  质量问题统计
        protected string Two
        {
            get
            {
                List<Model.SingleSerie> series = new List<Model.SingleSerie>();
                Model.BusinessColumn businessColumn = new Model.BusinessColumn();
                List<string> listCategories = new List<string>();
                businessColumn.title = "质量问题统计";
                businessColumn.xFontNum = 14;
                var units = BLL.ProjectUnitService.GetProjectUnitListByProjectIdUnitType(CurrUser.LoginProjectId, BLL.Const.ProjectUnitType_2);
                var checks = JointCheckDetailService.GetTotalJointCheckDetailListByTime(CurrUser.LoginProjectId, DateTime.Now);
                Model.SingleSerie s = new Model.SingleSerie();
                Model.SingleSerie s2 = new Model.SingleSerie();
                List<double> listdata = new List<double>();
                List<double> listdata2 = new List<double>();
                int okNum = 0;
                foreach (var unit in units)
                {
                    listCategories.Add(BLL.UnitService.GetUnitNameByUnitId(unit.UnitId));
                    var unitChecks = checks.Where(x => x.UnitId == unit.UnitId);
                    okNum = unitChecks.Where(x => x.OK == 1).Count();
                    listdata.Add(unitChecks.Count() - okNum);
                    listdata2.Add(okNum);
                }
                s.data = listdata;
                s2.data = listdata2;
                series.Add(s);
                series.Add(s2);
                businessColumn.categories = listCategories;
                businessColumn.series = series;
                return JsonConvert.SerializeObject(businessColumn);
            }
        }


        protected string Two2
        {
            get
            {
                List<Model.SingleSerie> series = new List<Model.SingleSerie>();
                Model.BusinessColumn businessColumn = new Model.BusinessColumn();
                List<string> listCategories = new List<string>();
                businessColumn.title = "质量问题统计";
                businessColumn.xFontNum = 2;
                var unitWorks = BLL.UnitWorkService.GetUnitWorkLists(CurrUser.LoginProjectId);
                var checks = JointCheckDetailService.GetTotalJointCheckDetailListByTime(CurrUser.LoginProjectId, DateTime.Now);
                Model.SingleSerie s = new Model.SingleSerie();
                Model.SingleSerie s2 = new Model.SingleSerie();
                List<double> listdata = new List<double>();
                List<double> listdata2 = new List<double>();
                int okNum = 0;
                foreach (var unitWork in unitWorks)
                {
                    listCategories.Add(unitWork.UnitWorkName);
                    var unitChecks = checks.Where(x => x.UnitWorkId == unitWork.UnitWorkId);
                    okNum = unitChecks.Where(x => x.OK == 1).Count();
                    listdata.Add(unitChecks.Count() - okNum);
                    listdata2.Add(okNum);
                }
                s.data = listdata;
                s2.data = listdata2;
                series.Add(s);
                series.Add(s2);
                businessColumn.categories = listCategories;
                businessColumn.series = series;
                return JsonConvert.SerializeObject(businessColumn);
            }
        }

        protected string Two3
        {
            get
            {
                List<Model.SingleSerie> series = new List<Model.SingleSerie>();
                Model.BusinessColumn businessColumn = new Model.BusinessColumn();
                List<string> listCategories = new List<string>();
                businessColumn.title = "质量问题统计";
                businessColumn.xFontNum = 4;
                var cns = BLL.CNProfessionalService.GetList();
                var checks = JointCheckDetailService.GetTotalJointCheckDetailListByTime(CurrUser.LoginProjectId, DateTime.Now);
                Model.SingleSerie s = new Model.SingleSerie();
                Model.SingleSerie s2 = new Model.SingleSerie();
                List<double> listdata = new List<double>();
                List<double> listdata2 = new List<double>();
                int okNum = 0;
                foreach (var cn in cns)
                {
                    listCategories.Add(cn.ProfessionalName);
                    var unitChecks = checks.Where(x => x.CNProfessionalCode == cn.CNProfessionalId);
                    okNum = unitChecks.Where(x => x.OK == 1).Count();
                    listdata.Add(unitChecks.Count() - okNum);
                    listdata2.Add(okNum);
                }
                s.data = listdata;
                s2.data = listdata2;
                series.Add(s);
                series.Add(s2);
                businessColumn.categories = listCategories;
                businessColumn.series = series;
                return JsonConvert.SerializeObject(businessColumn);
            }
        }

        protected string Two4
        {
            get
            {
                List<Model.SingleSerie> series = new List<Model.SingleSerie>();
                Model.BusinessColumn businessColumn = new Model.BusinessColumn();
                List<string> listCategories = new List<string>();
                businessColumn.title = "质量问题统计";
                businessColumn.xFontNum = 4;
                var checks = JointCheckDetailService.GetTotalJointCheckDetailListByTime(CurrUser.LoginProjectId, DateTime.Now);
                var questionTypes = checks.Select(x => x.QuestionTypeStr).Distinct().ToList();
                Model.SingleSerie s = new Model.SingleSerie();
                Model.SingleSerie s2 = new Model.SingleSerie();
                List<double> listdata = new List<double>();
                List<double> listdata2 = new List<double>();
                int okNum = 0;
                foreach (var questionType in questionTypes)
                {
                    listCategories.Add(questionType);
                    var unitChecks = checks.Where(x => x.QuestionTypeStr == questionType);
                    okNum = unitChecks.Where(x => x.OK == 1).Count();
                    listdata.Add(unitChecks.Count() - okNum);
                    listdata2.Add(okNum);
                }
                s.data = listdata;
                s2.data = listdata2;
                series.Add(s);
                series.Add(s2);
                businessColumn.categories = listCategories;
                businessColumn.series = series;
                return JsonConvert.SerializeObject(businessColumn);
            }
        }
        /// <summary>
        /// 单位工程
        /// </summary>
        protected string Two5
        {
            get
            {
                List<Model.SingleSerie> series = new List<Model.SingleSerie>();
                Model.BusinessColumn businessColumn = new Model.BusinessColumn();
                List<string> listCategories = new List<string>();
                businessColumn.title = "质量问题统计";
                businessColumn.xFontNum = 14;
                var units = BLL.UnitWorkService.GetUnitWorkList(CurrUser.LoginProjectId);
                var checks = JointCheckDetailService.GetTotalJointCheckDetailListByTime(CurrUser.LoginProjectId, DateTime.Now);
                Model.SingleSerie s = new Model.SingleSerie();
                Model.SingleSerie s2 = new Model.SingleSerie();
                List<double> listdata = new List<double>();
                List<double> listdata2 = new List<double>();
                int okNum = 0;
                foreach (var unit in units)
                {
                    listCategories.Add(unit.Text);
                    var unitChecks = checks.Where(x => x.UnitWorkId == unit.Value);
                    okNum = unitChecks.Where(x => x.OK == 1).Count();
                    listdata.Add(unitChecks.Count() - okNum);
                    listdata2.Add(okNum);
                }
                s.data = listdata;
                s2.data = listdata2;
                series.Add(s);
                series.Add(s2);
                businessColumn.categories = listCategories;
                businessColumn.series = series;
                return JsonConvert.SerializeObject(businessColumn);
            }
        }


        #endregion
        #region fenbao
        protected string BaoYan
        {
            get
            {
                List<Model.SingleSerie> series = new List<Model.SingleSerie>();
                Model.BusinessColumn businessColumn = new Model.BusinessColumn();
                List<string> listCategories = new List<string>();
                listCategories.Add("设备材料"); listCategories.Add("人员"); listCategories.Add("机具"); listCategories.Add("现场签证"); listCategories.Add("设计交底");
                businessColumn.title = "质量问题统计";
                businessColumn.xFontNum = 14;
                var units = BLL.ProjectUnitService.GetProjectUnitListByProjectId(CurrUser.LoginProjectId);
                var inspectionEquipment = Funs.DB.Comprehensive_InspectionEquipment.Where(u => u.ProjectId == CurrUser.LoginProjectId).Select(x => new { x.UnitId, x.InspectionEquipmentId }).ToList();
                var inspectionPerson = Funs.DB.Comprehensive_InspectionPerson.Where(u => u.ProjectId == CurrUser.LoginProjectId).Select(x => new { x.UnitId, x.InspectionPersonId }).ToList();
                var inspectionMachine = Funs.DB.Comprehensive_InspectionMachine.Where(u => u.ProjectId == CurrUser.LoginProjectId).Select(x => new { x.UnitId, x.InspectionMachineId }).ToList();
                var siteVisaManagement = Funs.DB.Comprehensive_SiteVisaManagement.Where(u => u.ProjectId == CurrUser.LoginProjectId).Select(x => new { x.UnitId, x.VisaId }).ToList();
                var designDetails = Funs.DB.Comprehensive_DesignDetails.Where(u => u.ProjectId == CurrUser.LoginProjectId).Select(x => new { x.UnitName, x.DesignDetailsId }).ToList();
                Model.SingleSerie s  ;
               
                List<double> listdata = new List<double>();
                 
                foreach (var unit in units)
                {
                    s = new Model.SingleSerie();
                    listdata = new List<double>();
                    var baseunit = Funs.DB.Base_Unit.Where(u => u.UnitId == unit.UnitId).FirstOrDefault(); 
                    listdata.Add(inspectionEquipment.Where(x => x.UnitId == unit.UnitId).Count());
                    listdata.Add(inspectionPerson.Where(x => x.UnitId == unit.UnitId).Count());
                    listdata.Add(inspectionMachine.Where(x => x.UnitId == unit.UnitId).Count());
                    listdata.Add(siteVisaManagement.Where(x => x.UnitId == unit.UnitId).Count());
                    listdata.Add(designDetails.Where(x => x.UnitName == unit.UnitId).Count());
                    
                    s.data = listdata;
                    s.name = baseunit.UnitName;
                    s.type = "bar";
                    s.barWidth = "20"; 
                    s.stack = "总数";
                 
                    
                    series.Add(s);
                }
               
               
                businessColumn.categories = listCategories;
                businessColumn.series = series;
                return JsonConvert.SerializeObject(businessColumn);
            }
        }

        #endregion
    }
}