public static T_SysVehicle NewItem(SQ.Base.MyDataReader reader)
{
var item = new T_SysVehicle();
//车辆标识号
item.VehicleID = reader.GetInt64("F_ID");
//车牌号
if (!reader.IsDBNull("F_PLATE_CODE"))
{
item.Name = reader.GetString("F_PLATE_CODE");
}
//车牌颜色
if (!reader.IsDBNull("F_PLATE_COLOR"))
{
item.PlateColor = (JTPlateColor)Convert.ToByte(reader.GetString("F_PLATE_COLOR"));
}
if (!reader.IsDBNull("F_ENTERPRISE_CODE"))
{
item.EnterpriseCode = reader.GetString("F_ENTERPRISE_CODE");
}
else
{
item.EnterpriseCode = "";
}
return(item);
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="reader"></param>
public SupplementGpsModel(SQ.Base.MyDataReader reader)
{
RowID = reader.GetInt32("RowID");
//车牌号
PlateName = reader.GetString("PlateName");
//车牌颜色
PlateColor = reader.GetInt16("PlateColor");
var lon = reader.GetInt32("F_LONGITUDE");
var lat = reader.GetInt32("F_LATITUDE");
var GpsEncrypt = (int)reader.GetInt16("F_GpsEncrypt");
var tmpstate = reader.GetInt64("F_GPSSTATE");
var GPSSTATE = (uint)(tmpstate & 0xFFFFFFFF);
Gnss = new JTSVehicleGpsMsgDatas
{
ENCRYPT = GpsEncrypt == 1 ? JTSEncrypt.Encrypt : JTSEncrypt.NoneEncrypt,
datetime = reader.GetDateTime("F_GPS_TIME"),
LON = (uint)Math.Abs(lon),
LAT = (uint)Math.Abs(lat),
VEC1 = (UInt16)reader.GetInt16("F_SPEED"),
VEC2 = (UInt16)reader.GetInt16("F_DSPEED"),
VEC3 = (UInt32)reader.GetInt32("F_MILEAGE"),
DIRECTION = (UInt16)reader.GetInt16("F_DIRECTION"),
ALTITUDE = (UInt16)reader.GetInt16("F_HIGH"),
STATE = new JTGPSStateInfo(GPSSTATE),// GetGpsStatus(TrackID),
ALARM = (JTAlarmType)reader.GetInt32("F_ALARM_DATA")
};
}
public static CRVehicle NewItem(SQ.Base.MyDataReader reader)
{
var item = new CRVehicle();
item.VehicleName = reader.GetString("F_VIN");
item.PlateColor = (JTPlateColor)reader.GetByte("F_VEHICLE_COLOR");
return(item);
}
public static DeviceYb NewItem(SQ.Base.MyDataReader reader)
{
var item = new DeviceYb();
if (!reader.IsDBNull("F_VEHICLE_ID"))
{
item.VehicleID = reader.GetInt64("F_VEHICLE_ID");
}
if (!reader.IsDBNull("F_VEHICLE_CODE"))
{
item.YbVehicleID = reader.GetString("F_VEHICLE_CODE");
}
if (!reader.IsDBNull("F_PLATE_CODE"))
{
item.YbVehicleName = reader.GetString("F_PLATE_CODE");
}
if (!reader.IsDBNull("F_PLATE_COLOR"))
{
item.YbVehicleColor = reader.GetString("F_PLATE_COLOR");
}
if (!reader.IsDBNull("F_VEHICLE_FRAME_NO"))
{
item.VIN = reader.GetString("F_VEHICLE_FRAME_NO");
}
if (!reader.IsDBNull("F_SHENG"))
{
item.Provice = reader.GetString("F_SHENG");
}
else
{
item.Provice = "";
}
if (!reader.IsDBNull("F_SHI"))
{
item.City = reader.GetString("F_SHI");
}
else
{
item.City = "9";
}
//if (!reader.IsDBNull("F_ENTERPRISE_CODE"))
// item.CompanyCode = reader.GetString("F_ENTERPRISE_CODE");
//else
// item.CompanyCode = "";
item.ZiCompanyCode = "";
if (!reader.IsDBNull("F_LINE_NO"))
{
item.LineMark = reader.GetString("F_LINE_NO");
}
else
{
item.LineMark = "";
}
return(item);
}
public static NotSendBillInfo NewItem(SQ.Base.MyDataReader reader)
{
var item = new NotSendBillInfo();
//车牌号
item.Name = reader.GetString("Name");
//车牌颜色
item.PlateColor = reader.GetByte("PlateColor");
//运单信息
item.BillInfo = reader.GetString("BillInfo");
return(item);
}
public static NotSendAuditAlarmInfo NewItem(SQ.Base.MyDataReader reader)
{
var item = new NotSendAuditAlarmInfo();
item.ID = reader.GetInt64("F_ID");
item.Name = reader.GetString("F_PLATE_CODE");
item.PlateColor = (byte)reader.GetInt16("F_VEHICLE_COLOR");
item.AlarmType = (byte)reader.GetInt64("F_ALARM_TYPE_ID");
//报警编号
item.AlarmId = reader.GetInt64("F_ALARM_HISTORY_ID");
//报警类型
item.Status = (byte)reader.GetInt16("F_STATUS");
//车牌颜色
return(item);
}
public static MonSendFailGps NewItem(SQ.Base.MyDataReader reader)
{
var item = new MonSendFailGps();
//
item.RowID = reader.GetInt32("RowID");
//跟踪ID
item.TrackID = reader.GetInt64("TrackID");
//车牌号
item.PlateName = reader.GetString("PlateName");
//车牌颜色
item.PlateColor = reader.GetInt16("PlateColor");
return(item);
}
public static DeviceInfo NewItem(SQ.Base.MyDataReader reader)
{
var item = new DeviceInfo();
// 终端ID
item.DeviceID = reader.GetInt64("F_ID");
//终端Code
if (!reader.IsDBNull("F_CODE"))
{
item.CDeviceID = reader.GetString("F_CODE");
}
//省域ID
if (!reader.IsDBNull("F_PROVINCE"))
{
item.ProvinceID = reader.GetString("F_PROVINCE").Trim();
if (item.ProvinceID.Length > 2)
{
item.ProvinceID = item.ProvinceID.Substring(0, 2);
}
//区域ID
while (item.ProvinceID.Length < 2)
{
item.ProvinceID = "0" + item.ProvinceID;
}
}
else
{
item.ProvinceID = "00";
}
//市域ID
if (!reader.IsDBNull("F_CITY_ID"))
{
item.CityID = reader.GetString("F_CITY_ID").Trim();
if (item.CityID.Length > 2)
{
item.CityID = item.CityID.Substring(0, 2);
}
//区域ID
while (item.CityID.Length < 2)
{
item.CityID = "0" + item.CityID;
}
}
else
{
item.CityID = "00";
}
item.MakerPCID = item.ProvinceID + item.CityID + "00";
//if (!reader.IsDBNull("F_AREA_ID"))
// item.MakerPCID = reader.GetString("F_AREA_ID");
//制造商ID
if (!reader.IsDBNull("F_MANUFACTURER_ID"))
{
item.MakerID = reader.GetString("F_MANUFACTURER_ID");
}
//终端型号
if (!reader.IsDBNull("F_EQUIPMENT_MODE"))
{
item.CDeviceType = reader.GetString("F_EQUIPMENT_MODE");
}
//车牌颜色
if (!reader.IsDBNull("F_PLATE_COLOR"))
{
item.F_PLATE_COLOR = (JTPlateColor)Convert.ToByte(reader.GetString("F_PLATE_COLOR"));
}
if (!reader.IsDBNull("F_PLATE_CODE"))
{
item.VehcileName = reader.GetString("F_PLATE_CODE");
}
//手机号
if (!reader.IsDBNull("F_MOBILE_CODE"))
{
item.Sim = reader.GetString("F_MOBILE_CODE");
}
//车辆ID
if (!reader.IsDBNull("F_VEHICLE_ID"))
{
item.VehicleID = reader.GetInt64("F_VEHICLE_ID");
}
//企业编号
//if (!reader.IsDBNull("F_ENTERPRISE_CODE"))
// item.F_ENTERPRISE_CODE = reader.GetString("F_ENTERPRISE_CODE");
//else
// item.F_ENTERPRISE_CODE = string.Empty;
//注册状态
if (reader.HasCol("F_IS_LOGOUT") && !reader.IsDBNull("F_IS_LOGOUT"))
{
item.IsReg = reader.GetInt16("F_IS_LOGOUT") == 0;
}
else
{
item.IsReg = false;
}
//鉴权码
if (reader.HasCol("F_AUTH_CODE") && !reader.IsDBNull("F_AUTH_CODE"))
{
item.AuthorityID = reader.GetString("F_AUTH_CODE");
}
//协议版本 F_PROTOCOL_VERSION
if (!reader.IsDBNull("F_PROTOCOL_VERSION"))
{
item.ProtocolVersion = reader.GetInt32("F_PROTOCOL_VERSION");
}
//终端使用的CAN数据配置版本
if (!reader.IsDBNull("F_CAN_CFG_VERSION"))
{
item.CANCFGVersion = reader.GetInt64("F_CAN_CFG_VERSION");
}
if (reader.HasCol("F_PAUSE") && !reader.IsDBNull("F_PAUSE"))
{
item.Pause = reader.GetInt16("F_PAUSE") == 1;
}
else
{
item.Pause = false;
}
if (reader.HasCol("DeviceRegID") && !reader.IsDBNull("DeviceRegID"))
{
item.DeviceRegID = reader.GetInt64("DeviceRegID");
}
if (reader.HasCol("F_GATEWAY_ID") && !reader.IsDBNull("F_GATEWAY_ID"))
{
item.GatewayID = reader.GetInt64("F_GATEWAY_ID");
}
if (reader.HasCol("F_AUTH_CODE") && !reader.IsDBNull("F_AUTH_CODE"))
{
item.AuthorityID = reader.GetString("F_AUTH_CODE");
}
if (reader.HasCol("F_REGISTER_DATE") && !reader.IsDBNull("F_REGISTER_DATE"))
{
item.RegisterDate = reader.GetDateTime("F_REGISTER_DATE");
}
if (reader.HasCol("F_AUTH_DATE") && !reader.IsDBNull("F_AUTH_DATE"))
{
item.AuthDate = reader.GetDateTime("F_AUTH_DATE");
}
if (reader.HasCol("F_LOGOUT_DATE") && !reader.IsDBNull("F_LOGOUT_DATE"))
{
item.LogoutDate = reader.GetDateTime("F_LOGOUT_DATE");
}
if (reader.HasCol("F_IP_ADDRESS") && !reader.IsDBNull("F_IP_ADDRESS"))
{
item.IpAddress = reader.GetString("F_IP_ADDRESS");
}
if (reader.HasCol("F_PORT") && !reader.IsDBNull("F_PORT"))
{
item.Port = reader.GetInt32("F_PORT");
}
if (reader.HasCol("F_ONLINE") && !reader.IsDBNull("F_ONLINE"))
{
item.Online = reader.GetInt16("F_ONLINE") == 1;
}
else
{
item.Online = false;
}
if (reader.HasCol("F_CREATE_DATE") && !reader.IsDBNull("F_CREATE_DATE"))
{
item.CreateDate = reader.GetDateTime("F_CREATE_DATE");
}
if (reader.HasCol("F_UPDATE_DATE") && !reader.IsDBNull("F_UPDATE_DATE"))
{
item.UpdateDate = reader.GetDateTime("F_UPDATE_DATE");
}
if (reader.HasCol("F_CAR_COLOR") && !reader.IsDBNull("F_CAR_COLOR"))
{
item.Car_Color = reader["F_CAR_COLOR"].ToString();
}
else
{
item.Car_Color = "未知";
}
//是否启用救援
if (reader.HasCol("F_RESCUE_ENABLED") && !reader.IsDBNull("F_RESCUE_ENABLED"))
{
item.RescueEnabled = reader.GetInt16("F_RESCUE_ENABLED") == 1;
}
else
{
item.RescueEnabled = false;
}
//救援服务商
if (reader.HasCol("F_RESCUE_SP") && !reader.IsDBNull("F_RESCUE_SP"))
{
item.RescueServiceProvider = reader.GetInt16("F_RESCUE_SP");
}
else
{
item.RescueServiceProvider = 0;
}
//if (reader.HasCol("F_DP_ID") && !reader.IsDBNull("F_DP_ID"))
//{
// item.F_DP_ID = reader.GetInt64("F_DP_ID");
//}
//else
//{
// item.F_DP_ID = 0;
//}
if (reader.HasCol("F_CAR_VIN") && !reader.IsDBNull("F_CAR_VIN"))
{
item.VIN = reader.GetString("F_CAR_VIN");
}
return(item);
}