Esempio n. 1
0
        static void Main(string[] args)
        {
            //add 5
            //ldn c8

            int t1, t2;

            var Gross_Load_Div  = new int[] { 0, 10_000, 20_000, 30_000 };
            var Gross_Load_Dist = new List <int>();

            var StartDataTime = new DateTime(2020, 1, 21, 0, 0, 0);
            var FinishDataTime = new DateTime(2020, 2, 21, 0, 0, 0);
            int FirstMonth = StartDataTime.Month; int NextMonth = FinishDataTime.Month;

            //Expression<Func<HS_Data_201908, bool>> dataPredicate = x => x.HSData_DT >= StartDataTime && x.HSData_DT <= FinishDataTime;

            try
            {
                using (var db = new HighSpeed_JCBEntities())
                {
                    #region HS_DataForAnalysis
                    var HS_DataForAnalysis = (
                        from c in db.HS_Data_202001
                        select new MyHS_Data
                    {
                        Acceleration = c.Acceleration,
                        AxleGrp_Num = c.AxleGrp_Num,
                        Axle_Num = c.Axle_Num,
                        ExternInfo = c.ExternInfo,
                        F7Code = c.F7Code,
                        HSData_Id = c.HSData_Id,
                        Veh_Length = c.Veh_Length,
                        Veh_Type = c.Veh_Type,
                        LWheel_1_W = c.LWheel_1_W,
                        LWheel_2_W = c.LWheel_2_W,
                        LWheel_3_W = c.LWheel_3_W,
                        LWheel_4_W = c.LWheel_4_W,
                        LWheel_5_W = c.LWheel_5_W,
                        LWheel_6_W = c.LWheel_6_W,
                        LWheel_7_W = c.LWheel_7_W,
                        LWheel_8_W = c.LWheel_8_W,
                        Lane_Id = c.Lane_Id,
                        Oper_Direc = c.Oper_Direc,
                        Speed = c.Speed,
                        OverLoad_Sign = c.OverLoad_Sign,
                        RWheel_1_W = c.RWheel_1_W,
                        RWheel_2_W = c.RWheel_2_W,
                        RWheel_3_W = c.RWheel_3_W,
                        RWheel_4_W = c.RWheel_4_W,
                        RWheel_5_W = c.RWheel_5_W,
                        RWheel_6_W = c.RWheel_6_W,
                        RWheel_7_W = c.RWheel_7_W,
                        RWheel_8_W = c.RWheel_8_W,
                        Violation_Id = c.Violation_Id,
                        AxleDis1 = c.AxleDis1,
                        AxleDis2 = c.AxleDis2,
                        AxleDis3 = c.AxleDis3,
                        AxleDis4 = c.AxleDis4,
                        AxleDis5 = c.AxleDis5,
                        AxleDis6 = c.AxleDis6,
                        AxleDis7 = c.AxleDis7,
                        HSData_DT = c.HSData_DT,
                        Gross_Load = c.Gross_Load
                    }
                        ).Union(
                        from e in db.HS_Data_202002
                        select new MyHS_Data
                    {
                        Acceleration  = e.Acceleration,
                        AxleGrp_Num   = e.AxleGrp_Num,
                        Axle_Num      = e.Axle_Num,
                        ExternInfo    = e.ExternInfo,
                        F7Code        = e.F7Code,
                        HSData_Id     = e.HSData_Id,
                        Veh_Length    = e.Veh_Length,
                        Veh_Type      = e.Veh_Type,
                        LWheel_1_W    = e.LWheel_1_W,
                        LWheel_2_W    = e.LWheel_2_W,
                        LWheel_3_W    = e.LWheel_3_W,
                        LWheel_4_W    = e.LWheel_4_W,
                        LWheel_5_W    = e.LWheel_5_W,
                        LWheel_6_W    = e.LWheel_6_W,
                        LWheel_7_W    = e.LWheel_7_W,
                        LWheel_8_W    = e.LWheel_8_W,
                        Lane_Id       = e.Lane_Id,
                        Oper_Direc    = e.Oper_Direc,
                        Speed         = e.Speed,
                        OverLoad_Sign = e.OverLoad_Sign,
                        RWheel_1_W    = e.RWheel_1_W,
                        RWheel_2_W    = e.RWheel_2_W,
                        RWheel_3_W    = e.RWheel_3_W,
                        RWheel_4_W    = e.RWheel_4_W,
                        RWheel_5_W    = e.RWheel_5_W,
                        RWheel_6_W    = e.RWheel_6_W,
                        RWheel_7_W    = e.RWheel_7_W,
                        RWheel_8_W    = e.RWheel_8_W,
                        Violation_Id  = e.Violation_Id,
                        AxleDis1      = e.AxleDis1,
                        AxleDis2      = e.AxleDis2,
                        AxleDis3      = e.AxleDis3,
                        AxleDis4      = e.AxleDis4,
                        AxleDis5      = e.AxleDis5,
                        AxleDis6      = e.AxleDis6,
                        AxleDis7      = e.AxleDis7,
                        HSData_DT     = e.HSData_DT,
                        Gross_Load    = e.Gross_Load
                    }
                        );
                    #endregion
                    Expression <Func <MyHS_Data, bool> > dataPredicate = x => x.HSData_DT >= StartDataTime && x.HSData_DT < FinishDataTime;

                    var table = HS_DataForAnalysis;

                    IEnumerable <DailyTraffic> dailyTrafficData = DataProcessing.GetDailyTraffic(table, StartDataTime, FinishDataTime);
                    //var cc = table.Where(x => EntityFunctions.TruncateTime(x.HSData_DT)>= EntityFunctions.TruncateTime(StartDataTime)).Count();

                    //每日交通流量信息数据导入excel
                    var temp1 = ExportToExcelHelper.ExportDailyTrafficVolume(dailyTrafficData.ToList());

                    //重量前10的车辆数据导入excel
                    List <MyHS_Data> data = table.Where(dataPredicate).OrderByDescending(x => x.Gross_Load).Take(10).ToList();
                    var temp = ExportToExcelHelper.ExportTopGrossLoad(data);


                    var maxGross_Load_Vehicle = table.Where(dataPredicate).OrderByDescending(x => x.Gross_Load).FirstOrDefault();
                    var g1 = maxGross_Load_Vehicle.Gross_Load;
                    var c1 = maxGross_Load_Vehicle.Axle_Num;

                    var l1 = maxGross_Load_Vehicle.AxleDis1 + maxGross_Load_Vehicle.AxleDis2 + maxGross_Load_Vehicle.AxleDis3
                             + maxGross_Load_Vehicle.AxleDis4 + maxGross_Load_Vehicle.AxleDis5 + maxGross_Load_Vehicle.AxleDis6 + maxGross_Load_Vehicle.AxleDis7;


                    Console.WriteLine($"最大车重{g1},轴数{c1},轴距{l1}={maxGross_Load_Vehicle.AxleDis1}+{maxGross_Load_Vehicle.AxleDis2}" +
                                      $"+{maxGross_Load_Vehicle.AxleDis3}+{maxGross_Load_Vehicle.AxleDis4}+{maxGross_Load_Vehicle.AxleDis5 }" +
                                      $"+{maxGross_Load_Vehicle.AxleDis6}+{maxGross_Load_Vehicle.AxleDis7}");

                    //不同区间车重分布
                    for (int i = 0; i < Gross_Load_Div.Length; i++)
                    {
                        t1 = Gross_Load_Div[i];
                        if (i != Gross_Load_Div.Length - 1)
                        {
                            t2 = Gross_Load_Div[i + 1];
                            Gross_Load_Dist.Add(table.Where(x => x.Gross_Load >= t1 && x.Gross_Load < t2).Where(dataPredicate).Count());
                        }
                        else
                        {
                            Gross_Load_Dist.Add(table.Where(x => x.Gross_Load >= t1).Where(dataPredicate).Count());
                        }
                        Console.WriteLine(Gross_Load_Dist[i]);
                    }
                    try    //结果写入txt(以逗号分隔)
                    {
                        var fs          = new FileStream("不同车重区间车辆数.txt", FileMode.Create);
                        var sw          = new StreamWriter(fs, Encoding.Default);
                        var writeString = $"{Gross_Load_Dist[0]}";
                        for (int i = 1; i < Gross_Load_Div.Length; i++)
                        {
                            writeString = $"{writeString},{Gross_Load_Dist[i]}";
                        }
                        sw.Write(writeString);
                        sw.Close();
                        fs.Close();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }

                    var Speed_Div  = new int[] { 0, 30, 50, 70 };
                    var Speed_Dist = new List <int>();
                    //不同区间车速分布
                    for (int i = 0; i < Speed_Div.Length; i++)
                    {
                        t1 = Speed_Div[i];
                        if (i != Speed_Div.Length - 1)
                        {
                            t2 = Speed_Div[i + 1];
                            Speed_Dist.Add(table.Where(x => x.Speed >= t1 && x.Speed < t2).Where(dataPredicate).Count());
                        }
                        else
                        {
                            Speed_Dist.Add(table.Where(x => x.Speed >= t1).Where(dataPredicate).Count());
                        }
                        Console.WriteLine(Speed_Dist[i]);
                    }
                    try
                    {
                        var fs          = new FileStream("不同车速区间车辆数.txt", FileMode.Create);
                        var sw          = new StreamWriter(fs, Encoding.Default);
                        var writeString = $"{Speed_Dist[0]}";
                        for (int i = 1; i < Speed_Div.Length; i++)
                        {
                            writeString = $"{writeString},{Speed_Dist[i]}";
                        }
                        sw.Write(writeString);
                        sw.Close();
                        fs.Close();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }

                    //不同车道分布
                    var Lane_Div  = new int[] { 1, 2, 3, 4 };
                    var Lane_Dist = new List <int>();
                    for (int i = 0; i < Lane_Div.Length; i++)
                    {
                        t1 = Lane_Div[i];
                        Lane_Dist.Add(table.Where(x => x.Lane_Id == t1).Where(dataPredicate).Count());
                        Console.WriteLine(Lane_Dist[i]);
                    }
                    try
                    {
                        var fs          = new FileStream("不同车道车辆数.txt", FileMode.Create);
                        var sw          = new StreamWriter(fs, Encoding.Default);
                        var writeString = $"{Lane_Dist[0]}";
                        for (int i = 1; i < Lane_Div.Length; i++)
                        {
                            writeString = $"{writeString},{Lane_Dist[i]}";
                        }
                        sw.Write(writeString);
                        sw.Close();
                        fs.Close();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }

                    var Hour_Div  = new int[] { 0, 2, 4, 6, 8, 10, 12, 14, 16, 18, 20, 22 };
                    var Hour_Dist = new List <int>();

                    //不同区间小时分布
                    for (int i = 0; i < Hour_Div.Length; i++)
                    {
                        t1 = Hour_Div[i];
                        if (i != Hour_Div.Length - 1)
                        {
                            t2 = Hour_Div[i + 1];
                            //TODO:Convert.ToDateTime(x.HSData_DT)中x.HSData_DT为空时会抛出异常
                            Hour_Dist.Add(table.Where(x => x.HSData_DT.Value.Hour >= t1 && x.HSData_DT.Value.Hour < t2).Where(dataPredicate).Count());
                        }
                        else
                        {
                            Hour_Dist.Add(table.Where(x => x.HSData_DT.Value.Hour >= t1).Where(dataPredicate).Count());
                        }

                        Console.WriteLine(Hour_Dist[i]);
                    }
                    try
                    {
                        var fs          = new FileStream("不同小时区间车辆数.txt", FileMode.Create);
                        var sw          = new StreamWriter(fs, Encoding.Default);
                        var writeString = $"{Hour_Dist[0]}";
                        for (int i = 1; i < Hour_Div.Length; i++)
                        {
                            writeString = $"{writeString},{Hour_Dist[i]}";
                        }
                        sw.Write(writeString);
                        sw.Close();
                        fs.Close();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }

                    Hour_Div = new int[] { 0, 2, 4, 6, 8, 10, 12, 14, 16, 18, 20, 22 };
                    var Hour_Speed_Dist = new List <double?>();

                    //不同小时区间平均车速
                    for (int i = 0; i < Hour_Div.Length; i++)
                    {
                        t1 = Hour_Div[i];
                        if (i != Hour_Div.Length - 1)
                        {
                            t2 = Hour_Div[i + 1];
                            //TODO:Convert.ToDateTime(x.HSData_DT)中x.HSData_DT为空时会抛出异常
                            Hour_Speed_Dist.Add(table.Where(x => x.HSData_DT.Value.Hour >= t1 && x.HSData_DT.Value.Hour < t2).Where(dataPredicate).Average(x => x.Speed));
                        }
                        else
                        {
                            Hour_Speed_Dist.Add(table.Where(x => x.HSData_DT.Value.Hour >= t1).Where(dataPredicate).Average(x => x.Speed));
                        }

                        Console.WriteLine(Hour_Dist[i]);
                    }
                    try
                    {
                        var fs          = new FileStream("不同小时区间平均车速.txt", FileMode.Create);
                        var sw          = new StreamWriter(fs, Encoding.Default);
                        var writeString = $"{Math.Round(Convert.ToDecimal(Hour_Speed_Dist[0] ?? 0.0), 1)}";
                        for (int i = 1; i < Hour_Div.Length; i++)
                        {
                            writeString = $"{writeString},{Math.Round(Convert.ToDecimal(Hour_Speed_Dist[i] ?? 0.0), 1)}";
                        }
                        sw.Write(writeString);
                        sw.Close();
                        fs.Close();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }

                    //周一至周日车辆数分布
                    var Week_Div  = new int[] { 6, 0, 1, 2, 3, 4, 5 };   //上一个月份余数
                    var Week_Div2 = new int[] { 3, 4, 5, 6, 0, 1, 2 };   //这个月份余数
                    var Week_Dist = new List <int>();

                    for (int i = 0; i < Week_Div.Length; i++)
                    {
                        t1 = Week_Div[i];
                        t2 = Week_Div2[i];
                        Week_Dist.Add(table.Where(x => (x.HSData_DT.Value.Day % 7 == t1 && x.HSData_DT.Value.Month == FirstMonth) ||
                                                  (x.HSData_DT.Value.Day % 7 == t2 && x.HSData_DT.Value.Month == NextMonth)).Where(dataPredicate).Count());
                        Console.WriteLine(Week_Dist[i]);
                    }
                    try
                    {
                        var fs          = new FileStream("周一至周日车辆数.txt", FileMode.Create);
                        var sw          = new StreamWriter(fs, Encoding.Default);
                        var writeString = $"{Week_Dist[0]}";
                        for (int i = 1; i < Week_Div.Length; i++)
                        {
                            writeString = $"{writeString},{Week_Dist[i]}";
                        }
                        sw.Write(writeString);
                        sw.Close();
                        fs.Close();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }

                    Hour_Div = new int[] { 0, 2, 4, 6, 8, 10, 12, 14, 16, 18, 20, 22 };
                    var Hour_Weight = new List <int>();

                    //不同区间小时大于40t车数量
                    for (int i = 0; i < Hour_Div.Length; i++)
                    {
                        t1 = Hour_Div[i];
                        if (i != Hour_Div.Length - 1)
                        {
                            t2 = Hour_Div[i + 1];
                            //TODO:Convert.ToDateTime(x.HSData_DT)中x.HSData_DT为空时会抛出异常
                            Hour_Weight.Add(table.Where(x => x.HSData_DT.Value.Hour >= t1 && x.HSData_DT.Value.Hour < t2).Where(dataPredicate).Where(x => x.Gross_Load > 40000).Count());
                        }
                        else
                        {
                            Hour_Weight.Add(table.Where(x => x.HSData_DT.Value.Hour >= t1).Where(dataPredicate).Where(x => x.Gross_Load > 40000).Count());
                        }

                        Console.WriteLine(Hour_Weight[i]);
                    }
                    try
                    {
                        var fs          = new FileStream("不同区间小时大于40t车数量.txt", FileMode.Create);
                        var sw          = new StreamWriter(fs, Encoding.Default);
                        var writeString = $"{Hour_Weight[0]}";
                        for (int i = 1; i < Hour_Div.Length; i++)
                        {
                            writeString = $"{writeString},{Hour_Weight[i]}";
                        }
                        sw.Write(writeString);
                        sw.Close();
                        fs.Close();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }
                }
                Console.WriteLine($"计算完成!");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

            Console.ReadKey();
        }
Esempio n. 2
0
        static void Main(string[] args)
        {
            //add 4
            //ldn c8

            int t1, t2;

            var Gross_Load_Div  = new int[] { 0, 10_000, 20_000, 30_000 };
            var Gross_Load_Dist = new List <int>();

            var StartDataTime  = new DateTime(2019, 8, 14, 0, 0, 0);
            var FinishDataTime = new DateTime(2019, 8, 20, 23, 59, 59);

            try
            {
                using (var db = new HighSpeed_JCBEntities())
                {
                    //不同区间车重分布
                    for (int i = 0; i < Gross_Load_Div.Length; i++)
                    {
                        t1 = Gross_Load_Div[i];
                        if (i != Gross_Load_Div.Length - 1)
                        {
                            t2 = Gross_Load_Div[i + 1];
                            Gross_Load_Dist.Add(db.HS_Data.Where(x => x.Gross_Load >= t1 && x.Gross_Load < t2 && x.HSData_DT >= StartDataTime && x.HSData_DT <= FinishDataTime).Count());
                        }
                        else
                        {
                            Gross_Load_Dist.Add(db.HS_Data.Where(x => x.Gross_Load >= t1 && x.HSData_DT >= StartDataTime && x.HSData_DT <= FinishDataTime).Count());
                        }
                        Console.WriteLine(Gross_Load_Dist[i]);
                    }
                    try    //结果写入txt(以逗号分隔)
                    {
                        var fs          = new FileStream("不同车重区间车辆数.txt", FileMode.Create);
                        var sw          = new StreamWriter(fs, Encoding.Default);
                        var writeString = $"{Gross_Load_Dist[0]}";
                        for (int i = 1; i < Gross_Load_Div.Length; i++)
                        {
                            writeString = $"{writeString},{Gross_Load_Dist[i]}";
                        }
                        sw.Write(writeString);
                        sw.Close();
                        fs.Close();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }

                    var Speed_Div  = new int[] { 0, 20, 30, 40 };
                    var Speed_Dist = new List <int>();
                    //不同区间车速分布
                    for (int i = 0; i < Speed_Div.Length; i++)
                    {
                        t1 = Speed_Div[i];
                        if (i != Speed_Div.Length - 1)
                        {
                            t2 = Speed_Div[i + 1];
                            Speed_Dist.Add(db.HS_Data.Where(x => x.Speed >= t1 && x.Speed < t2 && x.HSData_DT >= StartDataTime && x.HSData_DT <= FinishDataTime).Count());
                        }
                        else
                        {
                            Speed_Dist.Add(db.HS_Data.Where(x => x.Speed >= t1 && x.HSData_DT >= StartDataTime && x.HSData_DT <= FinishDataTime).Count());
                        }
                        Console.WriteLine(Speed_Dist[i]);
                    }
                    try
                    {
                        var fs          = new FileStream("不同车速区间车辆数.txt", FileMode.Create);
                        var sw          = new StreamWriter(fs, Encoding.Default);
                        var writeString = $"{Speed_Dist[0]}";
                        for (int i = 1; i < Speed_Div.Length; i++)
                        {
                            writeString = $"{writeString},{Speed_Dist[i]}";
                        }
                        sw.Write(writeString);
                        sw.Close();
                        fs.Close();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }

                    //不同车道分布
                    var Lane_Div  = new int[] { 1, 2, 3, 4 };
                    var Lane_Dist = new List <int>();
                    for (int i = 0; i < Lane_Div.Length; i++)
                    {
                        t1 = Lane_Div[i];
                        Lane_Dist.Add(db.HS_Data.Where(x => x.Lane_Id == t1 && x.HSData_DT >= StartDataTime && x.HSData_DT <= FinishDataTime).Count());
                        Console.WriteLine(Lane_Dist[i]);
                    }
                    try
                    {
                        var fs          = new FileStream("不同车道车辆数.txt", FileMode.Create);
                        var sw          = new StreamWriter(fs, Encoding.Default);
                        var writeString = $"{Lane_Dist[0]}";
                        for (int i = 1; i < Lane_Div.Length; i++)
                        {
                            writeString = $"{writeString},{Lane_Dist[i]}";
                        }
                        sw.Write(writeString);
                        sw.Close();
                        fs.Close();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }

                    var Hour_Div  = new int[] { 0, 2, 4, 6, 8, 10, 12, 14, 16, 18, 20, 22 };
                    var Hour_Dist = new List <int>();
                    //不同区间小时分布
                    for (int i = 0; i < Hour_Div.Length; i++)
                    {
                        t1 = Hour_Div[i];
                        if (i != Hour_Div.Length - 1)
                        {
                            t2 = Hour_Div[i + 1];
                            //TODO:Convert.ToDateTime(x.HSData_DT)中x.HSData_DT为空时会抛出异常
                            Hour_Dist.Add(db.HS_Data.Where(x => x.HSData_DT.Value.Hour >= t1 && x.HSData_DT.Value.Hour < t2 && x.HSData_DT >= StartDataTime && x.HSData_DT <= FinishDataTime).Count());
                        }
                        else
                        {
                            Hour_Dist.Add(db.HS_Data.Where(x => x.HSData_DT.Value.Hour >= t1 && x.HSData_DT >= StartDataTime && x.HSData_DT <= FinishDataTime).Count());
                        }
                        Console.WriteLine(Hour_Dist[i]);
                    }
                    try
                    {
                        var fs          = new FileStream("不同小时区间车辆数.txt", FileMode.Create);
                        var sw          = new StreamWriter(fs, Encoding.Default);
                        var writeString = $"{Hour_Dist[0]}";
                        for (int i = 1; i < Hour_Div.Length; i++)
                        {
                            writeString = $"{writeString},{Hour_Dist[i]}";
                        }
                        sw.Write(writeString);
                        sw.Close();
                        fs.Close();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

            Console.ReadKey();
        }