public DBProcessResult ModifyVehicle(EMVehicleViewModel view)
{
DBProcessResult result = new DBProcessResult();
try
{
IEMVehicleService service = new EMVehicleService();
IEMVehicleLogService logService = new EMVehicleLogService();
IdentityNoService noService = new IdentityNoService();
IEMGpsTypeService gpsTypeService = new EMGpsTypeService();
EMVehicle entity = ConvertHelper.ConvertObj<EMVehicleViewModel, EMVehicle>(view);
EMVehicle oldEntity = service.Select(view.VehicleCode);
entity.ExpireTime = oldEntity.ExpireTime;
entity.InstallTime = oldEntity.InstallTime;
entity.CreateTime = oldEntity.CreateTime;
entity.IsStop = oldEntity.IsStop;
EMGpsType gpsTypeEntity = gpsTypeService.Get(entity.GPSTypeID);
entity.GPSTypeName = gpsTypeEntity.TypeName;
//如果设备号改变，要重新获取GPSCode，添加和修改日志
if (entity.DeviceNo != oldEntity.DeviceNo)
{
bool bo = service.IsExist(view.DeviceNo);
if (bo != true)
{
EnumGPSCodeRule codeType = (EnumGPSCodeRule)gpsTypeEntity.GPSCodeRule;
entity.GPSCode = GetGPSCodeHelper.GetGPSCode(gpsTypeEntity.PrefixCode, codeType, entity.SIMNo, entity.DeviceNo);
if (entity.DeviceNo.Length == gpsTypeEntity.MachineCodeLength)
{
//修改上一个日志
DateTime now = DateTime.Now;
EMVehicleLog lastLog = logService.GetLast(entity.VehicleCode);
if (lastLog != null)
{
lastLog.EndDate = now;
logService.Update(lastLog);
}
//新增一个日志
EMVehicleLog vehicleLog = new EMVehicleLog()
{
BeginDate = now,
LogID = noService.GetVehicleLogID(),
DeviceNo = entity.DeviceNo,
EndDate = null,
GPSCode = entity.GPSCode,
GPSTypeID = entity.GPSTypeID,
InitMileage = entity.InitMileage,
LicenceNumber = entity.LicenceNumber,
Operator = view.UserName,
SIMNo = entity.SIMNo,
TenantCode = entity.TenantCode,
GroupID = entity.GroupID,
VehicleCode = entity.VehicleCode
};
logService.Insert(vehicleLog);
entity.InstallTime = DateTime.Now;
service.Update(entity);
result.IsSuccess = true;
}
else
{
result.IsSuccess = false;
result.Message = "GPS设备号长度，不在指定范围内，请重新填写！";
}
}
else
{
result.IsSuccess = false;
result.Message = "GPS设备号已存在，请重新填写！";
}
}
else
{
service.Update(entity);
result.IsSuccess = true;
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return result;
}
public DBProcessResult AddVehicle(EMVehicleViewModel view)
{
DBProcessResult result = new DBProcessResult();
try
{
EMVehicleService service = new EMVehicleService();
EHistoryDataStoreConfigService configService = new EHistoryDataStoreConfigService();
EMGpsTypeService gpsTypeService = new EMGpsTypeService();
EMVehicleLogService logService = new EMVehicleLogService();
IdentityNoService noService = new IdentityNoService();
bool licenceNumberIsExist = service.IsExist(view.TenantCode, view.LicenceNumber);
if (licenceNumberIsExist)
{
result.IsSuccess = false;
result.Message = "已经有相同车牌号的车辆";
return result;
}
EMVehicle entity = ConvertHelper.ConvertObj<EMVehicleViewModel, EMVehicle>(view);
EMGpsType gpsTypeEntity = gpsTypeService.Get(entity.GPSTypeID);
Logger.Info("code line 290: gpsTypeService.Get(entity.GPSTypeID)");
entity.GPSTypeName = gpsTypeEntity.TypeName;
bool bo = service.IsExist(view.DeviceNo);
if (bo != true)
{
//新增车辆历史数据配置
string tableName = GetTableNameByCondition(gpsTypeEntity.PrefixCode);
EHisotryDataStoreTables table = configService.GetHistoryTable(tableName);
Logger.Info("code line 299: configService.GetHistoryTable(tableName)");
if (table == null)
{
result.IsSuccess = false;
result.Message = string.Format("找不到对应的历史数据表[{0}]，请联系DBA！", tableName);
return result;
}
//新增车辆
EnumGPSCodeRule codeType = (EnumGPSCodeRule)gpsTypeEntity.GPSCodeRule;
entity.GPSCode = GetGPSCodeHelper.GetGPSCode(gpsTypeEntity.PrefixCode, codeType, entity.SIMNo, entity.DeviceNo);
if (entity.DeviceNo.Length == gpsTypeEntity.MachineCodeLength)
{
entity.CreateTime = DateTime.Now;
entity.InstallTime = DateTime.Now;
GetVehicleGroupID(entity); //客户管理中新增车辆时，没有车辆组，默认增加到顶级车辆组
service.Insert(entity);
EHistoryDataStoreConfig configEntity = new EHistoryDataStoreConfig();
configEntity.CreateDate = DateTime.Now;
configEntity.Enable = true;
configEntity.StoreTable = table;
configEntity.VehicleCode = entity.VehicleCode;
configService.Insert(configEntity);
//新增车辆Log
EMVehicleLog vehicleLog = new EMVehicleLog()
{
BeginDate = DateTime.Now,
LogID = noService.GetVehicleLogID(),
DeviceNo = entity.DeviceNo,
EndDate = null,
GPSCode = entity.GPSCode,
GPSTypeID = entity.GPSTypeID,
InitMileage = entity.InitMileage,
LicenceNumber = entity.LicenceNumber,
Operator = view.UserName,
SIMNo = entity.SIMNo,
TenantCode = entity.TenantCode,
VehicleCode = entity.VehicleCode,
GroupID = entity.GroupID,
};
logService.Insert(vehicleLog);
view.VehicleCode = entity.VehicleCode;
result.IsSuccess = true;
}
else
{
result.IsSuccess = false;
result.Message = "GPS设备号长度，不在指定范围内，请重新填写！";
}
}
else
{
result.IsSuccess = false;
result.Message = "设备号已存在，请重新填写！";
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
Logger.Info(ex.StackTrace + "【" + ex.Message + "】");
}
return result;
}
public EMGpsTypeViewModel SearchEMGpsTypeByID(ulong gpsTypeID)
{
IEMGpsTypeService service = new EMGpsTypeService();
EMGpsType entity = service.Get(gpsTypeID);
EMGpsTypeViewModel viewModel = ConvertHelper.ConvertObj<EMGpsType, EMGpsTypeViewModel>(entity);
return viewModel;
}
public List<EMGpsTypeViewModel> SearchEMGpsTypeAll(string tenantCode)
{
EMGpsTypeService service = new EMGpsTypeService();
IList<EMGpsType> entityList = service.GetAll();
List<EMGpsTypeViewModel> viewModelList = ConvertHelper.ConvertList<EMGpsType, EMGpsTypeViewModel>(entityList.ToList());
return viewModelList;
}
/// <summary>
/// 查询车辆当前信息和最近指令信息
/// </summary>
public VehicleOilControlInfoVMList SearchVehicleOilControlInfo(SearchVehicleOilControlInfoParam param)
{
EMGpsTypeService gpsTypeSve = new EMGpsTypeService();
List<EMGpsType> gpsTypeList = gpsTypeSve.GetByPeripheralList(new List<PeripheralEnum>() { PeripheralEnum.Relay });
List<ulong> gpsTypeIDList = gpsTypeList.Select(o => o.GPSTypeID).ToList();
int rowCount;
VehicleDAL veDal = new VehicleDAL();
List<EMVehicleOilInfo> veOilList = veDal.GetVehicleOil(param.VehicleCodes, gpsTypeIDList, param.RowIndex, param.PageSize, out rowCount, Param_OffLineTime);
if (rowCount == 0)
return null;
IList<VehicleOilControlInfoVM> ltVM = NewBuildVM(veOilList);
//PositioningWCFService positioningWCFServ = new PositioningWCFService();
//positioningWCFServ.GetLoaction(ltVM); //获取地址
return new VehicleOilControlInfoVMList()
{
List = ltVM.ToList(),
RowCount = rowCount
};
}
