203 lines
9.4 KiB
203 lines
9.4 KiB
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);
|
|
// }
|
|
//}
|
|
}
|
|
}
|
|
|