コード例 #1
0
        public static object Acc(Station1.ConfigFile cfg, List <Station1.InputItem> rawdata, Expression expression, int CountAcc)
        {
            var result = CountAcc;

            // init 計算式
            Expression _e         = new Expression(expression.ParsedExpression, EvaluateOptions.NoCache);
            DateTime   currentTIM = cfg.CurrentTIM;

            List <Station1.InputItem> lastrawdata = rawdata.Where(x => x.TIM <= currentTIM).Select(s => s).OrderByDescending(t => t.TIM).Take(CountAcc + 1).ToList();

            Station1.InputItem lastDataItem = lastrawdata.FirstOrDefault();

            // 處理客制 function
            _e.EvaluateFunction += delegate(string name, FunctionArgs args)
            {
                switch (name)
                {
                case "diff":
                    args.Result = Diff(lastrawdata, args.Parameters[0], currentTIM);
                    break;
                }
            };

            return(_e.Evaluate());
        }
コード例 #2
0
        private void DoOutputMonth(Station1.ConfigFile cfg, string staOutputPath)
        {
            logView.Add("執行寫入 Month 檔案程式: " + cfg.Tag);

            if (cfg.Lines.Count > 0)
            {
                // 2.正式寫入檔案 HH
                DateTime MinTIM   = cfg.Lines.Min(x => x.TIM);
                DateTime MaxTIM   = cfg.Lines.Max(x => x.TIM);
                TimeSpan timeSpan = MaxTIM - MinTIM;

                for (int imonth = 0; imonth <= E1Functions.GetMonthDifference(MaxTIM, MinTIM); imonth++)
                {
                    string   filename = MinTIM.AddMonths(imonth).ToString("yyyyMM") + ".txt";
                    DateTime dtFrom   = MinTIM.AddMonths(imonth).TruncateToMonthStart();
                    DateTime dtTo     = MinTIM.AddMonths(imonth + 1).TruncateToMonthStart();

                    List <List <string> > lines = (cfg.Lines.Where(x => x.TIM >= dtFrom && x.TIM < dtTo).Select(l => l.ColItems)).ToList();

                    if (lines.Count > 0)
                    {
                        CSVWriteFile(cfg.Title, lines, staOutputPath + @"\" + cfg.OutputPath + @"\" + filename);
                    }
                }
                logView.Add("寫入 Month 檔案完成: " + cfg.Tag);
            }
            else
            {
                logView.Add("無 Month 資料更新: " + cfg.Tag);
            }
        }
コード例 #3
0
        private void DoOutputHH(Station1.ConfigFile cfg, string staOutputPath)
        {
            logView.Add("執行寫入HH檔案程式: " + cfg.Tag);

            if (cfg.Lines.Count > 0)
            {
                // 2.正式寫入檔案 HH
                DateTime MinTIM   = cfg.Lines.Min(x => x.TIM);
                DateTime MaxTIM   = cfg.Lines.Max(x => x.TIM);
                TimeSpan timeSpan = MaxTIM - MinTIM;

                for (int ihour = 0; ihour <= Math.Ceiling((MaxTIM - MinTIM).TotalHours); ihour++)
                {
                    string   filename = MinTIM.AddHours(ihour).ToString("yyyyMMddHH") + ".txt";
                    DateTime dtFrom   = MinTIM.AddHours(ihour).TruncateToHourStart();
                    DateTime dtTo     = MinTIM.AddHours(ihour + 1).TruncateToHourStart();

                    List <List <string> > lines = (cfg.Lines.Where(x => x.TIM >= dtFrom && x.TIM < dtTo).Select(l => l.ColItems)).ToList();

                    if (lines.Count > 0)
                    {
                        CSVWriteFile(cfg.Title, lines, staOutputPath + @"\" + cfg.OutputPath + @"\" + filename);
                    }
                }
                logView.Add("寫入 HH 檔案完成: " + cfg.Tag);
            }
            else
            {
                logView.Add("無 HH 資料更新: " + cfg.Tag);
            }
        }
コード例 #4
0
        private static List <Station1.ConfigFile.Line> DoAcc(Station1 sta, string tag)
        {
            List <Station1.InputItem> processInputItem = sta.InputItems.Where(x => string.Compare(x.FileName, sta.LastFileName) > 0).ToList();

            Station1.ConfigFile cfg = sta.ConfigFiles.Where(x => x.Tag == tag).FirstOrDefault();
            cfg.Lines.Clear(); // 先清空, 避免累積

            // 無資料返回
            if (cfg == null)
            {
                return(null);
            }

            // 1.讀取資料
            foreach (Station1.InputItem inputitem in processInputItem)
            {
                List <string> outputline = new List <string>();
                DateTime      tim        = default(DateTime);
                // 處理 TIM
                if (inputitem.Header.IndexOf("TIM") != -1)
                {
                    DateTime.TryParseExact(inputitem.Line[inputitem.Header.IndexOf("TIM")], "yyyy-MM-ddTHH:mm:ss+08:00", null, System.Globalization.DateTimeStyles.None, out tim);
                    cfg.CurrentTIM = tim;
                }

                foreach (string col in cfg.Col)
                {
                    int    colIndex = inputitem.Header.IndexOf(col);
                    string colData  = "";

                    // 處理特殊欄位
                    if (col == "TIMD")
                    {
                        colIndex = inputitem.Header.IndexOf("TIM");
                        colData  = inputitem.Line[colIndex].Substring(0, 10);
                    }
                    else if (col == "TIMT")
                    {
                        colIndex = inputitem.Header.IndexOf("TIM");
                        colData  = inputitem.Line[colIndex].Substring(11, 8);
                    }
                    else if (col == "TIM")
                    {
                        // 特別客製, TIM 產生二個欄位
                        colIndex = inputitem.Header.IndexOf("TIM");
                        colData  = inputitem.Line[colIndex].Substring(0, 10);
                        outputline.Add(colData);

                        colData = inputitem.Line[colIndex].Substring(11, 8);
                    }
                    else if (colIndex == -1)
                    {
                        // 關鍵字 calc() 為
                        string exp = Regex.Match(col, @"(?<=calc\()(.*)(?=\))").Groups[1].Value;

                        if (string.IsNullOrEmpty(exp))
                        {   // 輸入文字,直接輸入
                            colData = col;
                        }
                        else
                        {
                            // 檢查是否為 acc, 得到 #筆數
                            bool isAcc    = (Regex.Match(col, @"(?<=acc\()(.*)(?=\))").Groups[1].Value != "");
                            int  countAcc = 0;
                            if (isAcc)
                            {
                                countAcc = int.TryParse(Regex.Match(col, @"(?<=#)([^\)]*)").Groups[1].Value, out countAcc) ? countAcc : 0;
                                exp      = exp.Replace("#" + countAcc.ToString(), "");
                            }

                            // init 計算式
                            Expression e = new Expression(exp, EvaluateOptions.NoCache);

                            // 處理參數
                            e.EvaluateParameter += delegate(string name, ParameterArgs args)
                            {
                                int _colIndex = inputitem.Header.IndexOf(name);
                                if (_colIndex != -1)
                                {
                                    args.Result = inputitem.Line[_colIndex].Trim();
                                }
                            };

                            // 處理客制 function
                            e.EvaluateFunction += delegate(string name, FunctionArgs args)
                            {
                                switch (name)
                                {
                                case "diff":
                                    //args.Result = Diff(pe, sta.DataItems, args.Parameters[0]);
                                    DateTime currentTIM = cfg.CurrentTIM;
                                    List <Station1.InputItem> lastrawdata  = sta.InputItems.Where(x => x.TIM <= currentTIM).Select(s => s).OrderByDescending(t => t.TIM).Take(2).ToList();
                                    Station1.InputItem        lastDataItem = lastrawdata.FirstOrDefault();
                                    args.Result = Diff(lastrawdata, args.Parameters[0], currentTIM);
                                    break;

                                case "acc":
                                    args.Result = Acc(cfg, sta.InputItems, args.Parameters[0], countAcc);
                                    break;
                                }
                            };

                            // 計算式,數字去尾數 0.100 -> 0.1
                            colData = DoExpressionEvaluate(e);
                        }
                    }
                    else
                    { // 一般取值,不計算
                        colData = inputitem.Line[colIndex].Trim();
                    }

                    outputline.Add(colData);
                }

                if (outputline.Count > 0)
                {
                    cfg.Lines.Add(new Station1.ConfigFile.Line {
                        TIM = tim, ColItems = outputline
                    });
                }
            }

            return(cfg.Lines);
        }