using GpsModels;
using log4net;
using System;
using System.Data;
using System.Data.SqlClient;
using GPSBusiness.Sql;
using GPSServer.Helper;

namespace GPSBusiness
{
    public class MyGpsServer
    {
        public static ILog Log = LogManager.GetLogger("");

        //请查看Mongo的GpsRealTImeRepository
        ///// <summary>
        ///// 更新Gps实时数据
        ///// </summary>
        //public static void UpdateGpsRealTime(GpsModel model)
        //{
        //    try
        //    {
        //        Log.InfoFormat(
        //                "UpdateGpsRealTime:VehicleId={0},GpsTime={1},RecTime={2},Longitude={3},Latitude={4},Direct={5},Speed={6},Acc={7},ModifiedTime={8}",
        //                model.VehicleId, model.GpsTime, model.RecTime, model.Longitude, model.Latitude, model.Direct, model.Speed, model.Acc, DateTime.Now);
        //        string sql = @"UpdateGpsRealTime";
        //        SqlParameter[] parameters =
        //        {
        //            new SqlParameter("@VehicleId", SqlDbType.Int),
        //            new SqlParameter("@GpsTime", SqlDbType.DateTime),
        //            new SqlParameter("@RecTime",SqlDbType.DateTime),
        //            new SqlParameter("@Longitude", SqlDbType.Decimal, 18),
        //            new SqlParameter("@Latitude", SqlDbType.Decimal, 18),
        //            new SqlParameter("@Direct", SqlDbType.Int),
        //            new SqlParameter("@Speed", SqlDbType.Int),
        //            new SqlParameter("@Acc", SqlDbType.Int),
        //            new SqlParameter("@Address",SqlDbType.VarChar, 200),
        //            new SqlParameter("@ModifiedTime", SqlDbType.DateTime),
        //        };
        //        parameters[0].Value = model.VehicleId;
        //        parameters[1].Value = model.GpsTime;
        //        parameters[2].Value = model.RecTime;
        //        parameters[3].Value = model.Longitude;
        //        parameters[4].Value = model.Latitude;
        //        parameters[5].Value = model.Direct;
        //        parameters[6].Value = model.Speed;
        //        parameters[7].Value = model.Acc;
        //        parameters[8].Value = model.Address ?? "";
        //        parameters[9].Value = DateTime.Now;
        //        SqlHelp.ExecSPCommand(sql, parameters);
        //    }
        //    catch (Exception ex)
        //    {
        //        Log.ErrorFormat("UpdateGpsRealTime=报错=,ex.Message={0},ex.InnerException={1},ex.StackTrace={2}",
        //                ex.Message, ex.InnerException, ex.StackTrace);
        //    }
        //}

        ///// <summary>
        ///// 更新车辆gps状态：
        ///// </summary>
        //public static void UpdateGpsRealTimeGpsState(VehicleModel vehicle, int gpsState, string durationTime, string AccDurationTime)
        //{
        //    try
        //    {
        //        Log.InfoFormat(
        //                "UpdateGpsRealTimeGpsState:VehicleId={0},GpsState={1},DurationTime={2},AccDurationTime={3}",
        //                vehicle.VehicleId, gpsState, durationTime, AccDurationTime);
        //        string sql = @"UpdateGpsRealTimeState";
        //        SqlParameter[] parameters =
        //        {
        //            new SqlParameter("@VehicleId", SqlDbType.Int),
        //            new SqlParameter("@GpsState", SqlDbType.Int),
        //            new SqlParameter("@DurationTime",SqlDbType.VarChar, 20),
        //            new SqlParameter("@AccDurationTime",SqlDbType.VarChar, 20),
        //            new SqlParameter("@ModifiedTime", SqlDbType.DateTime),
        //        };
        //        parameters[0].Value = vehicle.VehicleId;
        //        parameters[1].Value = gpsState;
        //        parameters[2].Value = durationTime;
        //        parameters[3].Value = AccDurationTime;
        //        parameters[4].Value = DateTime.Now;
        //        SqlHelp.ExecSPCommand(sql, parameters);
        //    }
        //    catch (Exception ex)
        //    {
        //        Log.ErrorFormat(
        //                "UpdateGpsRealTimeGpsState=报错=,ex.Message={0},ex.InnerException={1},ex.StackTrace={2}",
        //                ex.Message, ex.InnerException, ex.StackTrace);
        //    }
        //}

        ///// <summary>
        ///// 更新车辆gps状态，沃瑞特在线车辆。此更新，只在沃瑞特心跳时进行更新。
        ///// </summary>
        //public static void UpdateGpsRealTimeGpsStateWrt(GpsModel gpsModel)
        //{
        //    try
        //    {
        //        var time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
        //        Log.InfoFormat(
        //                "UpdateGpsRealTimeGpsStateWrt:VehicleId={0},GpsState={1},GpsTime、RecTime、ModifiedTime={2},DurationTime={3},AccDurationTime={5}",
        //                gpsModel.VehicleId, gpsModel.GpsState, time, gpsModel.DurationTime, gpsModel.AccDurationTime);
        //        string sql = @"UpdateGpsRealTimeStateWrt";
        //        SqlParameter[] parameters =
        //        {
        //            new SqlParameter("@VehicleId", SqlDbType.Int),
        //            new SqlParameter("@GpsState", SqlDbType.Int),
        //            new SqlParameter("@GpsTime",SqlDbType.DateTime),
        //            new SqlParameter("@RecTime",SqlDbType.DateTime),
        //            new SqlParameter("@DurationTime",SqlDbType.VarChar, 20),
        //            new SqlParameter("@AccDurationTime",SqlDbType.VarChar, 20),
        //            new SqlParameter("@ModifiedTime", SqlDbType.DateTime),
        //        };
        //        parameters[0].Value = gpsModel.VehicleId;
        //        parameters[1].Value = gpsModel.GpsState;
        //        parameters[2].Value = time;
        //        parameters[3].Value = time;
        //        parameters[4].Value = gpsModel.DurationTime ?? "";
        //        parameters[5].Value = gpsModel.AccDurationTime ?? "";
        //        parameters[6].Value = time;
        //        SqlHelp.ExecSPCommand(sql, parameters);
        //    }
        //    catch (Exception ex)
        //    {
        //        Log.ErrorFormat(
        //                "UpdateGpsRealTimeGpsStateWrt=报错=,ex.Message={0},ex.InnerException={1},ex.StackTrace={2}",
        //                ex.Message, ex.InnerException, ex.StackTrace);
        //    }
        //}

        /// <summary>
        /// 更新订单状态：
        /// </summary>
        public static void UpdateOrderState(long orderId, int state, DateTime time)
        {
            try
            {
                Log.InfoFormat("UpdateOrderState:Id={0},State={1},Time={2:yyyy-MM-dd HH:mm:ss}",
                        orderId, state, time);
                string sql = @"UpdateOrderState";
                SqlParameter[] parameters =
                {
                    new SqlParameter("@Id", SqlDbType.Int),
                    new SqlParameter("@State", SqlDbType.Int),
                    new SqlParameter("@Time",SqlDbType.DateTime),
                };
                parameters[0].Value = orderId;
                parameters[1].Value = state;
                parameters[2].Value = time;
                SqlHelp.ExecSPCommand(sql, parameters);
            }
            catch (Exception ex)
            {
                Log.ErrorFormat(
                        "UpdateOrderState=报错=,ex.Message={0},ex.InnerException={1},ex.StackTrace={2}",
                        ex.Message, ex.InnerException, ex.StackTrace);
            }
        }

        ///// <summary>
        ///// 新增Acc持续时长记录
        ///// </summary>
        //public static void AddGpsCarAccDuration(int carId, int companyId, string code, string vehicleName, int AccState, DateTime beginTime, DateTime endTime)
        //{
        //    try
        //    {
        //        Log.InfoFormat("AddGpsCarAccDuration:VehicleId={0},CompanyId={1}",
        //                carId, companyId);
        //        var time = endTime - beginTime;
        //        var AccDurationTime = CalculationGpsHelper.TimeSpanFormat(time);
        //        string sql = @"AddGpsCarAccDuration";
        //        SqlParameter[] parameters =
        //        {
        //            new SqlParameter("@VehicleId", SqlDbType.Int),
        //            new SqlParameter("@CompanyId", SqlDbType.Int),
        //            new SqlParameter("@Code",SqlDbType.VarChar, 20),
        //            new SqlParameter("@VehicleName",SqlDbType.VarChar, 20),
        //            new SqlParameter("@AccState",SqlDbType.Int),
        //            new SqlParameter("@AccDurationTime",SqlDbType.VarChar, 20),
        //            new SqlParameter("@TimeBegin",SqlDbType.DateTime),
        //            new SqlParameter("@TimeEnd",SqlDbType.DateTime),
        //        };
        //        parameters[0].Value = carId;
        //        parameters[1].Value = companyId;
        //        parameters[2].Value = code;
        //        parameters[3].Value = vehicleName;
        //        parameters[4].Value = AccState;
        //        parameters[5].Value = AccDurationTime;
        //        parameters[6].Value = beginTime;
        //        parameters[7].Value = endTime;
        //        SqlHelp.ExecSPCommand(sql, parameters);

        //    }
        //    catch (Exception ex)
        //    {
        //        Log.ErrorFormat(
        //                "AddGpsCarAccDuration=报错=,ex.Message={0},ex.InnerException={1},ex.StackTrace={2}",
        //                ex.Message, ex.InnerException, ex.StackTrace);
        //    }
        //}
    }
}