コード例 #1
0
        public void GenerateEmissionsReport()
        {
            string plantList = "";

            foreach (RadComboBoxItem item in SQMBasePage.GetComboBoxCheckedItems(ddlExportPlantSelect))
            {
                if (radExportDateSelect1.SelectedDate != null)
                {
                    if (plantList.Length > 0)
                    {
                        plantList += ", ";
                    }
                    plantList += item.Value;
                }
            }
            try
            {
                decimal[]    plantArray = Array.ConvertAll(plantList.Split(','), new Converter <string, decimal>(decimal.Parse));
                SQMMetricMgr metricMgr  = new SQMMetricMgr().CreateNew(SessionManager.PrimaryCompany(), "E", radExportDateSelect1.SelectedDate.Value, radExportDateSelect2.SelectedDate.Value, plantArray);
                metricMgr.Load(DateIntervalType.month, DateSpanOption.SelectRange);
                CalcsResult            rslt     = metricMgr.CalcsMethods(plantArray, "E", "ghg|co2,ch4,n2o", "gwp100|sum", 22, (int)EHSCalcsCtl.SeriesOrder.YearMeasurePlant);
                EHSModel.GHGResultList ghgTable = (EHSModel.GHGResultList)rslt.ResultObj;
                uclGHGReport.BindGHGReport(ghgTable);
            }
            catch { }
        }
コード例 #2
0
        private void GenerateDataExport()
        {
            uclProgress.BindProgressDisplay(100, "Exporting...");
            DateTime fromDate = (DateTime)radDateFrom.SelectedDate;

            fromDate = new DateTime(fromDate.Year, fromDate.Month, 1);
            DateTime toDate = (DateTime)radDateTo.SelectedDate;

            toDate = new DateTime(toDate.Year, toDate.Month, DateTime.DaysInMonth(toDate.Year, toDate.Month));

            if (divInputs.Visible)
            {
                uclProgress.UpdateDisplay(2, 50, "Exporting...");
                uclExport.ExportProfileInputsExcel(entities, PlantIDS[0].ToString(), fromDate, toDate);
            }
            else
            {
                uclProgress.UpdateDisplay(2, 50, "Exporting...");
                if (LocalDataset() is SQMMetricMgr)
                {
                    uclExport.GenerateExportHistoryExcel(entities, ((SQMMetricMgr)LocalDataset()).ehsCtl.MetricHst, false);
                }
                else
                {
                    SQMMetricMgr metricMgr = new SQMMetricMgr().CreateNew(SessionManager.PrimaryCompany(), "E", fromDate, toDate, 0, PlantIDS);
                    metricMgr.Load(DateIntervalType.month, DateSpanOption.SelectRange);
                }
            }

            uclProgress.ProgressComplete();
        }
コード例 #3
0
        protected int GenerateEmissionsReport()
        {
            int status = 0;

            try
            {
                DateTime fromDate = (DateTime)radDateFrom.SelectedDate;
                fromDate = new DateTime(fromDate.Year, fromDate.Month, 1);
                DateTime toDate = (DateTime)radDateTo.SelectedDate;
                toDate = new DateTime(toDate.Year, toDate.Month, DateTime.DaysInMonth(toDate.Year, toDate.Month));

                SQMMetricMgr metricMgr = new SQMMetricMgr().CreateNew(SessionManager.PrimaryCompany(), "E", fromDate, toDate, PlantIDS);
                //metricMgr.Load(DateIntervalType.month, DateSpanOption.SelectRange);
                //CalcsResult rslt = metricMgr.CalcsMethods(PlantIDS, "E", "ghg|co2,ch4,n2o", "gwp100|sum", 22, (int)EHSCalcsCtl.SeriesOrder.YearMeasurePlant);
                metricMgr.Load(DateIntervalType.span, DateSpanOption.SelectRange);
                CalcsResult            rslt     = metricMgr.CalcsMethods(PlantIDS, "E", "ghg|co2,ch4,n2o", "gwp100|sum", 22, (int)EHSCalcsCtl.SeriesOrder.MeasurePlant, "", "");
                EHSModel.GHGResultList ghgTable = (EHSModel.GHGResultList)rslt.ResultObj;
                uclGHG.BindGHGReport(ghgTable);
                divGHG.Visible = true;

                SetLocalDataset(metricMgr);
            }
            catch { status = -1; }

            return(status);
        }
コード例 #4
0
        public void LoadIncidentExportInput()
        {
            string   searchcriteria = "";
            string   plantList      = "";
            DateTime dtFrom         = DateTime.Today;
            DateTime dtTo           = DateTime.Today;

            uclProgress.BindProgressDisplay(100, "Exporting: ");
            uclProgress.UpdateDisplay(1, 10, "Exporting...");

            try
            {
                dtFrom = new DateTime(radExportDateSelect1.SelectedDate.Value.Year, radExportDateSelect1.SelectedDate.Value.Month, 1);
            }
            catch { dtFrom = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1); }
            try
            {
                dtTo = new DateTime(radExportDateSelect2.SelectedDate.Value.Year, radExportDateSelect2.SelectedDate.Value.Month, 1).AddMonths(1).AddDays(-1);
            }
            catch { dtTo = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1).AddMonths(1).AddDays(-1); }

            List <decimal> plantIDS = SQMBasePage.GetComboBoxCheckedItems(ddlExportPlantSelect).Select(i => Convert.ToDecimal(i.Value)).ToList();
            List <decimal> typeList = ddlExportIncidentType.Items.Where(i => i.Checked == true).Select(i => Convert.ToDecimal(i.Value)).ToList();

            HSCalcs        = new SQMMetricMgr().CreateNew(SessionManager.PrimaryCompany(), "0", dtFrom, dtTo, new decimal[0]);
            HSCalcs.ehsCtl = new EHSCalcsCtl().CreateNew(1, DateSpanOption.SelectRange);
            HSCalcs.ehsCtl.SelectIncidentList(plantIDS, typeList, dtFrom, dtTo, ddlExportStatusSelect.SelectedValue, false);
            GenerateIncidentExportExcel(HSCalcs.ehsCtl.IncidentHst);
            uclProgress.ProgressComplete();
        }
コード例 #5
0
        private int DisplayResults(string cmdID)
        {
            int          status    = 0;
            SQMMetricMgr metricMgr = null;

            try
            {
                if (!string.IsNullOrEmpty(cmdID))
                {
                    EHS_PROFILE_MEASURE metric      = EHSModel.LookupEHSProfileMeasure(new PSsqmEntities(), Convert.ToDecimal(cmdID));
                    decimal             calcScopeID = EHSModel.ConvertPRODMeasure(metric.EHS_MEASURE, metric.PRMR_ID);
                    decimal             plantID     = Convert.ToDecimal(hfInputsListPlantID.Value);
                    DateTime            periodDate  = Convert.ToDateTime(hfInputsListPeriodDate.Value);

                    divInputsListReviewArea.Visible       = true;
                    divInputsListReviewArea.ViewStateMode = System.Web.UI.ViewStateMode.Disabled;
                    if (metricMgr == null)
                    {
                        metricMgr = new SQMMetricMgr().CreateNew(SessionManager.PrimaryCompany(), "I", periodDate.AddMonths(-12), periodDate, new decimal[1] {
                            plantID
                        });
                        metricMgr.Load(DateIntervalType.month, DateSpanOption.SelectRange);
                    }

                    GaugeDefinition ggCfg = new GaugeDefinition().Initialize();
                    ggCfg.Title         = metric.EHS_MEASURE.MEASURE_NAME.Trim() + " - Input History";
                    ggCfg.Height        = 250; ggCfg.Width = 650;
                    ggCfg.NewRow        = true;
                    ggCfg.DisplayLabel  = true;
                    ggCfg.DisplayLegend = false;

                    ggCfg.LabelV = "Quantity";
                    status       = uclGauge.CreateControl(SQMChartType.MultiLine, ggCfg, metricMgr.CalcsMethods(new decimal[1] {
                        plantID
                    }, "I", calcScopeID.ToString(), "sum", 32, (int)EHSCalcsCtl.SeriesOrder.PeriodMeasure), divInputsListReviewArea);

                    if (string.IsNullOrEmpty(metric.EHS_MEASURE.PLANT_ACCT_FIELD) && metric.EHS_MEASURE.MEASURE_CATEGORY != "FACT")
                    {
                        ggCfg.Height       = 165; ggCfg.Width = 650;
                        ggCfg.Title        = "";
                        ggCfg.DisplayLabel = false;
                        ggCfg.LabelV       = "Cost";
                        status             = uclGauge.CreateControl(SQMChartType.MultiLine, ggCfg, metricMgr.CalcsMethods(new decimal[1] {
                            plantID
                        }, "I", calcScopeID.ToString(), "cost", 32, (int)EHSCalcsCtl.SeriesOrder.PeriodMeasure), divInputsListReviewArea);
                    }
                }
            }
            catch
            {
                ;
            }

            return(status);
        }
コード例 #6
0
        public static LoginStatus InitializeUser(string SSOID, string pwd, bool activeOnly, bool calcStatOfTheDay)
        {
            LoginStatus sessionStatus = LoginStatus.Success;

            SessionManager.UserContext = new UserContext().Initialize(SSOID, pwd, true);
            if (SessionManager.UserContext.LoginStatus == LoginStatus.Success)
            {
                try
                {
                    if (calcStatOfTheDay)
                    {
                        // only option is currently # days since lost time case
                        SQMMetricMgr stsmgr = new SQMMetricMgr().CreateNew(SessionManager.PrimaryCompany(), "0", DateTime.UtcNow, DateTime.UtcNow, new decimal[1] {
                            SessionManager.UserContext.HRLocation.Plant.PLANT_ID
                        });
                        stsmgr.ehsCtl = new EHSCalcsCtl().CreateNew(1, DateSpanOption.SelectRange, "0");
                        stsmgr.ehsCtl.ElapsedTimeSeries(new decimal[1] {
                            SessionManager.UserContext.HRLocation.Plant.PLANT_ID
                        }, new decimal[1] {
                            8
                        }, new decimal[1] {
                            63
                        }, "YES", true);
                        if (stsmgr.ehsCtl.Results.ValidResult)
                        {
                            SessionManager.StatOfTheDay = new AttributeValue().CreateNew("", stsmgr.ehsCtl.Results.metricSeries[0].ItemList[0].YValue ?? 0);
                        }
                    }
                    else
                    {
                        SessionManager.StatOfTheDay = null;
                    }
                }
                catch (Exception ex)
                {
                    SessionManager.StatOfTheDay = null;
                    //SQMLogger.LogException(ex);
                }
            }
            else
            {
                ;
            }

            return(SessionManager.UserContext.LoginStatus);
        }
コード例 #7
0
        protected int GeneratePerspectiveView(decimal viewID)
        {
            int status = 0;

            //hfViewOption.Value = viewID.ToString();
            divView.ViewStateMode = System.Web.UI.ViewStateMode.Disabled;
            divView.Controls.Clear();

            PERSPECTIVE_VIEW view = LocalViewList.Where(v => v.VIEW_ID == viewID).FirstOrDefault();

            if (view == null)
            {
                lblReportTitle.CssClass = "promptAlert";
                lblReportTitle.Text     = hfViewOpenErr.Value;
                return(-1);
            }

            lblReportTitle.CssClass = "labelTitle";
            lblReportTitle.Text     = PlantSelect + " - " + view.VIEW_DESC;

            DateTime fromDate = (DateTime)radDateFrom.SelectedDate;

            fromDate = new DateTime(fromDate.Year, fromDate.Month, 1);
            DateTime toDate = (DateTime)radDateTo.SelectedDate;

            toDate = new DateTime(toDate.Year, toDate.Month, DateTime.DaysInMonth(toDate.Year, toDate.Month));

            SQMMetricMgr metricMgr = new SQMMetricMgr().CreateNew(SessionManager.PrimaryCompany(), "E", fromDate, toDate, ViewModel.AddFromYear(view), PlantIDS);

            metricMgr.Load(DateIntervalType.month, DateSpanOption.SelectRange);

            foreach (PERSPECTIVE_VIEW_ITEM vi in view.PERSPECTIVE_VIEW_ITEM.OrderBy(i => i.ITEM_SEQ).ToList())
            {
                if (vi.STATUS != "I")
                {
                    GaugeDefinition cfg = new GaugeDefinition().Initialize().ConfigureControl(vi, null, "", false, !string.IsNullOrEmpty(hfwidth.Value) ? Convert.ToInt32(hfwidth.Value) - 62 : 0, 0);
                    uclView.CreateControl((SQMChartType)cfg.ControlType, cfg, metricMgr.CalcsMethods(PlantIDS, vi.CALCS_METHOD, vi.CALCS_SCOPE, vi.CALCS_STAT, vi.CONTROL_TYPE, (int)vi.SERIES_ORDER, vi.FILTER, vi.OPTIONS), divView);
                }
            }

            SetLocalDataset(metricMgr);
            divView.Visible = true;
            return(status);
        }
コード例 #8
0
        public CalcsResult DaysElapsedLTC(COMPANY company, decimal[] plantArray)
        {
            CalcsResult results = new CalcsResult().Initialize();

            SQMMetricMgr metricMgr = new SQMMetricMgr().CreateNew(company, "HS", DateTime.Now, DateTime.Now, plantArray).Load(DateIntervalType.fuzzy, DateSpanOption.SelectRange);

            metricMgr.CalcsMethods(plantArray, "HS", "63", SStat.deltaDy.ToString(), 5, 1);
            results = metricMgr.ehsCtl.Results;
            if (!results.ValidResult)
            {
                PLANT plant = SQMModelMgr.LookupPlant(plantArray[0]);
                if (plant != null && plant.PLANT_START_DT.HasValue)
                {
                    results.Result      = (decimal)Math.Truncate(DateTime.Now.Subtract((DateTime)plant.PLANT_START_DT).TotalDays);
                    results.ValidResult = true;
                }
            }
            return(results);
        }
コード例 #9
0
 SQMMetricMgr SetHSCalcs(SQMMetricMgr hscalcs)
 {
     SessionManager.CurrentObject = hscalcs;
     return(HSCalcs());
 }
コード例 #10
0
        private int DisplayResults(string cmdID)
        {
            int          status    = 0;
            SQMMetricMgr metricMgr = null;

            foreach (RepeaterItem item in rptProfilePeriod.Items)
            {
                try
                {
                    LinkButton lnk = (LinkButton)item.FindControl("lnkMetricCD");
                    CheckBox   cb  = (CheckBox)item.FindControl("cbMetricSelect");
                    if (cb.Checked) //  ||  cmdID == "0")
                    {
                        EHS_PROFILE_MEASURE metric      = LocalProfile().GetMeasure(Convert.ToDecimal(lnk.CommandArgument));
                        decimal             calcScopeID = EHSModel.ConvertPRODMeasure(metric.EHS_MEASURE, metric.PRMR_ID);
                        System.Web.UI.HtmlControls.HtmlGenericControl reviewArea = (System.Web.UI.HtmlControls.HtmlGenericControl)item.FindControl("divReviewArea");
                        LinkButton lnkClose = (LinkButton)item.FindControl("lnkReviewAreaClose");
                        lnkClose.Visible         = reviewArea.Visible = true;
                        lnk.Visible              = false;
                        reviewArea.ViewStateMode = System.Web.UI.ViewStateMode.Disabled;
                        if (metricMgr == null)
                        {
                            metricMgr = new SQMMetricMgr().CreateNew(SessionManager.PrimaryCompany(), "I", LocalProfile().InputPeriod.PeriodDate.AddMonths(-12), LocalProfile().InputPeriod.PeriodDate, new decimal[1] {
                                LocalProfile().Profile.PLANT_ID
                            });
                            metricMgr.Load(DateIntervalType.month, DateSpanOption.SelectRange);
                        }

                        GaugeDefinition ggCfg = new GaugeDefinition().Initialize();
                        ggCfg.Title         = metric.EHS_MEASURE.MEASURE_NAME.Trim() + " - Input History";
                        ggCfg.Height        = 250; ggCfg.Width = 700;
                        ggCfg.NewRow        = true;
                        ggCfg.DisplayLabel  = true;
                        ggCfg.DisplayLegend = false;

                        ggCfg.LabelV = "Quantity";
                        status       = uclGauge.CreateControl(SQMChartType.MultiLine, ggCfg, metricMgr.CalcsMethods(new decimal[1] {
                            LocalProfile().Profile.PLANT_ID
                        }, "I", calcScopeID.ToString(), "sum", 32, (int)EHSCalcsCtl.SeriesOrder.PeriodMeasure), reviewArea);

                        if (string.IsNullOrEmpty(metric.EHS_MEASURE.PLANT_ACCT_FIELD) && metric.EHS_MEASURE.MEASURE_CATEGORY != "FACT")
                        {
                            ggCfg.Height       = 180; ggCfg.Width = 700;
                            ggCfg.Title        = "";
                            ggCfg.DisplayLabel = false;
                            ggCfg.LabelV       = "Cost";
                            status             = uclGauge.CreateControl(SQMChartType.MultiLine, ggCfg, metricMgr.CalcsMethods(new decimal[1] {
                                LocalProfile().Profile.PLANT_ID
                            }, "I", calcScopeID.ToString(), "cost", 32, (int)EHSCalcsCtl.SeriesOrder.PeriodMeasure), reviewArea);
                        }
                    }
                }
                catch
                {
                    ;
                }
            }

            BindSharedCalendars();

            return(status);
        }
コード例 #11
0
        protected void Page_Load(object sender, EventArgs e)
        {
            SETTINGS sets = null;

            if (IsPostBack)
            {
                // Save the current view port width (used for responsive design later)
                var vpWidth = viewPortWidth.Value;
                if (!string.IsNullOrEmpty(vpWidth))
                {
                    Session["vpWidth"] = vpWidth;
                }
                else
                {
                    Session["vpWidth"] = "1000";
                }
            }
            else
            {
                // if (LoginAttempts == 0)
                //     SessionManager.Clear();
                try
                {
                    string info = System.Configuration.ConfigurationManager.AppSettings["MainInfo"];
                    if (!string.IsNullOrEmpty(info))
                    {
                        lblMainInfo.Text    = info;
                        lblMainInfo.Visible = true;
                    }

                    System.Web.HttpBrowserCapabilities browser = Request.Browser;

                    // url format login.aspx/?t=ltc:60&p=EHS
                    // execOverride == override query params to force ticker and image posting

                    System.Collections.Specialized.NameValueCollection qry = new System.Collections.Specialized.NameValueCollection();
                    string execOverride = System.Configuration.ConfigurationManager.AppSettings["LoginOverride"];
                    if (execOverride != null && execOverride == "QAI")
                    {
                        qry.Add("t", "ltc");
                        qry.Add("p", "EHS,QS");
                    }
                    else
                    {
                        sets = SQMSettings.GetSetting("ENV", "LOGINIMAGE");                          // force login splash page display
                        if (sets != null && sets.VALUE.ToUpper() == "Y")
                        {
                            qry.Add("p", "EHS,QS");
                        }
                        sets = SQMSettings.GetSetting("ENV", "LOGINSTAT");
                        if (sets != null && sets.VALUE.ToUpper() == "LTC")
                        {
                            qry.Add("t", "ltc");
                        }
                    }

                    sets = SQMSettings.GetSetting("ENV", "LOGINMESSAGE");
                    if (sets != null && !string.IsNullOrEmpty(sets.VALUE))
                    {
                        lblLoginMessage.Text    = sets.VALUE;
                        divLoginMessage.Visible = true;
                    }


                    if (Request.QueryString.Count > 0)
                    {
                        qry = Request.QueryString;
                    }

                    if (qry.Get("t") != null)
                    {
                        string[] args = qry.Get("t").ToString().Split(':');

                        COMPANY      company  = new COMPANY();
                        decimal[]    plantIDS = SQMModelMgr.SelectPlantList(entities, 1, 0).Where(l => l.LOCATION_TYPE == "P").OrderBy(l => l.PLANT_NAME).Select(l => l.PLANT_ID).ToArray();
                        SQMMetricMgr stsmgr   = new SQMMetricMgr().CreateNew(company, "0", DateTime.Now, DateTime.Now, plantIDS);
                        stsmgr.ehsCtl = new EHSCalcsCtl().CreateNew(1, DateSpanOption.SelectRange);
                        stsmgr.ehsCtl.ElapsedTimeSeries(plantIDS, new decimal[1] {
                            8
                        }, new decimal[1] {
                            63
                        }, "YES", true);

                        GaugeDefinition tikCfg = new GaugeDefinition().Initialize();
                        tikCfg.Width       = 0;
                        tikCfg.Unit        = args.Length > 1 ? Convert.ToInt32(args[1]) : 80;
                        tikCfg.Position    = "none";
                        tikCfg.NewRow      = false;
                        pnlPosting.Visible = true;
                        divTicker.Visible  = true;
                        uclGauge.CreateTicker(tikCfg, stsmgr.ehsCtl.Results.metricSeries, divTicker);
                    }

                    if (qry.Get("p") != null)
                    {
                        string[] args = qry.Get("p").ToString().Split(',');
                        if (args.Contains("EHS"))
                        {
                            pnlPosting.Visible = true;
                            imgPostingEHS.Style.Add("MARGIN-TOP", "8px");
                            imgPostingEHS.Src = SQM.Website.Classes.SQMDocumentMgr.GetImageSourceString(SQM.Website.Classes.SQMDocumentMgr.FindCurrentDocument("SYS", 31));
                        }
                        if (args.Contains("QS"))
                        {
                            pnlPosting.Visible = true;
                            imgPostingQS.Style.Add("MARGIN-TOP", "8px");
                            imgPostingQS.Src = SQM.Website.Classes.SQMDocumentMgr.GetImageSourceString(SQM.Website.Classes.SQMDocumentMgr.FindCurrentDocument("SYS", 32));
                        }
                    }

                    string externalLinks = System.Configuration.ConfigurationManager.AppSettings["ExternalLinks"];
                    if (!string.IsNullOrEmpty(externalLinks))
                    {
                        string[] linkArray = externalLinks.Split(',');
                        foreach (string link in linkArray)
                        {
                            divLinks.Controls.Add(new LiteralControl("&nbsp;&nbsp;&nbsp;"));
                            HyperLink hlk = new HyperLink();
                            hlk.NavigateUrl = hlk.Text = link;
                            hlk.Target      = "_blank";
                            hlk.CssClass    = "linkUnderline";
                            divLinks.Controls.Add(hlk);
                        }
                        divLinks.Visible = true;
                    }
                }
                catch
                {
                    divAnnouncements.Visible = false;
                }

                if (Request.QueryString["rdp"] != null)
                {
                    ViewState["RedirectPath"] = Request.QueryString["rdp"];
                }
            }
        }