Ejemplo n.º 1
0
        //选中其他数据进行研究
        /*
         *
          use GuangZhou_Gb
        go
        SELECT  * into  [Gb_FlowControlx]
          FROM  gzserver.[GuangZhou_Gb].[dbo].[Gb_FlowControlx]
         * */
        private void navBarItem21_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs ee)
        {
            //var gb = new ExtendedGuangZhou_GbEntities();
            Guangzhou_GbEntities gb = new Guangzhou_GbEntities();
            gb.ContextOptions.LazyLoadingEnabled = true;
            gb.Gb_FlowControlx.MergeOption = MergeOption.NoTracking;
            //GuangZhou_GbEntities gb = new GuangZhou_GbEntities();
            //查询
            var fc = gb.Gb_FlowControlx.ToLookup(e => new
            {
                e.BeginFrameNum,
                e.PacketNum,
                //e.PacketTime,
                e.Flow_Control_time,
                e.Flow_Control_MsgType,
                e.bssgp_direction,
                //e.bssgp_tlli,
                e.bssgp_ms_bucket_size,
                e.bssgp_bucket_leak_rate,
                e.ip_len
            }, null); //为空更加能加少内存

            //MessageBox.Show(fc.Count().ToString());
            //转换
            var fcl = from p in fc.Select(e => e.Key)
                      let bucket_size = Convert.ToDouble(p.bssgp_ms_bucket_size) / 1000.0   //转换成KByte
                      let leak_rate = Convert.ToDouble(p.bssgp_bucket_leak_rate) / 1000.0  //转化成kbps
                      let Flow_Control_time = DateTime.Parse(p.Flow_Control_time)
                      select new
                      {
                          p.BeginFrameNum,
                          Flow_Control_time,
                          p.PacketNum,
                          p.ip_len,
                          p.Flow_Control_MsgType,
                          p.bssgp_direction,
                          //p.Key.bssgp_tlli,
                          bucket_size,
                          leak_rate,
                      };

            //MessageBox.Show(fcl.Count().ToString());

            string fc_msg = "BSSGP.FLOW-CONTROL-MS";
            //分组
            var query = from p in fcl
                        group p by new { p.BeginFrameNum } into ttt
                        select new FlowControlOneMs
                        {
                            _id = ttt.Key.BeginFrameNum,
                            BeginFrameNum = ttt.Key.BeginFrameNum,
                            //ttt.Key.bssgp_tlli,
                            fcontrol_cnt = ttt.Where(e => e.Flow_Control_MsgType == fc_msg).Count(),
                            packet_cnt = ttt.Count(),
                            bucket_size_avg = ttt.Where(e => e.Flow_Control_MsgType == fc_msg).Average(e => e.bucket_size),
                            bucket_size_min = ttt.Where(e => e.Flow_Control_MsgType == fc_msg).Min(e => e.bucket_size),
                            bucket_size_max = ttt.Where(e => e.Flow_Control_MsgType == fc_msg).Max(e => e.bucket_size),
                            leak_rate_avg = ttt.Where(e => e.Flow_Control_MsgType == fc_msg).Average(e => e.leak_rate),
                            leak_rate_min = ttt.Where(e => e.Flow_Control_MsgType == fc_msg).Min(e => e.leak_rate),
                            leak_rate_max = ttt.Where(e => e.Flow_Control_MsgType == fc_msg).Max(e => e.leak_rate),

                            first_delay = ttt.Where(e => e.Flow_Control_MsgType == fc_msg)
                            .OrderBy(e => e.PacketNum)
                                                .Select(e => new { fd = (e.Flow_Control_time - ttt.Min(f => f.Flow_Control_time)).TotalMilliseconds })
                                                .Select(e => (e.fd / 1000).ToString("f1"))
                                                .Aggregate((a, b) => a + "," + b),

                            leak_rate = ttt.Where(e => e.Flow_Control_MsgType == fc_msg)
                            .OrderBy(e => e.PacketNum)
                                            .Select(e => (e.leak_rate).ToString("f1"))
                                            .Aggregate((a, b) => a + "," + b),

                            bucket_size = ttt.Where(e => e.Flow_Control_MsgType == fc_msg)
                            .OrderBy(e => e.PacketNum)
                                             .Select(e => (e.bucket_size).ToString("f1"))
                                             .Aggregate((a, b) => a + "," + b),

                            //用扩展方法实现, 在fc消息之间进行ip.len的累加

                            down_total_len = ttt
                                // .Where(e => e.bssgp_direction == "Down")
                            .OrderBy(e => e.PacketNum)
                            .AggregateSum(e => (int)e.ip_len, e => e.Flow_Control_MsgType, fc_msg),

                            down_packet_rate = ttt
                                // .Where(e => e.bssgp_direction == "Down")
               .OrderBy(e => e.PacketNum)
               .AggregatePacketRate(e => (int)e.ip_len, e => e.Flow_Control_time, e => e.Flow_Control_MsgType, fc_msg),

                            fcm_time = ttt
                                // .Where(e => e.bssgp_direction == "Down")
            .OrderBy(e => e.PacketNum)
            .AggregatePacketTime(e => e.Flow_Control_time, e => e.Flow_Control_MsgType, fc_msg),

                        };

            FlowControlOneMs fcos = new FlowControlOneMs();
            fcos.BulkMongo(query.ToList());

            MessageBox.Show("OK");
        }
Ejemplo n.º 2
0
        /*
         *
        use GuangZhou_Gb
        go
        SELECT  * into  [Gb_Flow_Control_MS]
          FROM  gzserver.[GuangZhou_Gb].[dbo].[Gb_Flow_Control_MS]
        */
        private void navBarItem20_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs ee)
        {
            //var gb = new ExtendedGuangZhou_GbEntities();
            Guangzhou_GbEntities gb = new Guangzhou_GbEntities();
            //GuangZhou_GbEntities gb = new GuangZhou_GbEntities();
            //查询
            var fc = from p in gb.Gb_Flow_Control_MS
                     select new
                     {
                         p.BeginFrameNum,
                         p.PacketTime,
                         p.PacketNum,
                         p.bssgp_tlli,
                         p.bssgp_ms_bucket_size,
                         p.bssgp_bucket_leak_rate,

                     };

            //转换
            var fcl = from p in fc.ToList()
                      let bucket_size = Convert.ToInt64(p.bssgp_ms_bucket_size)
                      let leak_rate = Convert.ToInt64(p.bssgp_bucket_leak_rate)
                      select new
                      {
                          p.BeginFrameNum,
                          p.PacketTime,
                          p.PacketNum,
                          p.bssgp_tlli,
                          bucket_size,
                          leak_rate,
                      };

            //分组
            var query = from p in fcl
                        group p by new { p.BeginFrameNum, p.bssgp_tlli } into ttt
                        select new
                        {
                            ttt.Key.BeginFrameNum,
                            ttt.Key.bssgp_tlli,
                            cnt = ttt.Count(),
                            bucket_size_avg = ttt.Average(e => e.bucket_size) / 1000,
                            bucket_size_min = ttt.Min(e => e.bucket_size) / 1000,
                            bucket_size_max = ttt.Max(e => e.bucket_size) / 1000,
                            leak_rate_avg = ttt.Average(e => e.leak_rate) / 1000,
                            leak_rate_min = ttt.Min(e => e.leak_rate) / 1000,
                            leak_rate_max = ttt.Max(e => e.leak_rate) / 1000,

                            first_delay = ttt.OrderBy(e => e.PacketNum)
                                                .Select(e => new { fd = (e.PacketTime.Value - ttt.Min(f => f.PacketTime).Value).TotalSeconds })
                                                .Select(e => ((int)e.fd).ToString())
                                                .Aggregate((a, b) => a + "," + b),

                            leak_rate = ttt.OrderBy(e => e.PacketNum)
                                            .Select(e => ((int)e.leak_rate).ToString())
                                            .Aggregate((a, b) => a + "," + b),

                            bucket_size = ttt.OrderBy(e => e.PacketNum)
                                             .Select(e => ((int)e.bucket_size).ToString())
                                             .Aggregate((a, b) => a + "," + b),

                        };

            clearColumns();
            var dborder = query.OrderByDescending(e => e.cnt).Take(100);
            gridControl1.DataSource = dborder.AsParallel().ToList();
            gridView1.OptionsView.ColumnAutoWidth = false;
        }