public bool UpdateRadarInfo(string machine_name, RadarProtoInfo radar_info)
{
if (radar_info == null || radar_info.RadarList == null || radar_info.RadarList.Count == 0)
{
return(false);
}
string[] sqls = radar_info.RadarList.Select(radar => string.Format("update t_rcms_radarinfo_time t set t.radar_id = {3}, t.radar_name = '{4}', effective = {5}, distance = {6}, threat_level = {7}, time = sysdate where t.machine_name = '{0}' and t.ip_address = '{1}' and port = {2}", machine_name, radar.IpAddress, radar.Port, radar.Id, radar.Name, radar.Working, radar.CurrentDistance, radar.ThreatLevel)).ToArray();
return(this.provider.ExecuteSqlTrans(sqls));
}
/// <summary>
/// 更新单机姿态
/// </summary>
/// <param name="machine_name">单机名称</param>
/// <param name="radar_info">雷达信息实体</param>
/// <param name="gnss_info">GNSS信息实体</param>
/// <returns></returns>
public int UpdateMachinePosture(string machine_name, RadarProtoInfo radar_info, GnssProtoInfo gnss_info, OpcDataSource opc_source)
{
string sql = string.Format("update t_rcms_machineposture_time t set t.walking = {1}, t.pitch = {2}, t.yaw = {3}, local_tipx = {4}, local_tipy = {5}, local_tipz = {6}, walking_left_plc = {7}, walking_right_plc = {8}, pitch_plc = {9}, yaw_plc = {10}, local_tipz_abs = {11}, working = {12}, isfixed = {13}, quality = '{14}', latitude = {15}, longitude = {16}, altitude = {17}, coal_on_belt = {18}, local_antex = {19}, local_antey = {20}, local_antez = {21}, stream_per_hour = {22}, stream_total = {23}, wheel_left_dist = {24}, wheel_right_dist = {25}, belt_dist = {26}, wheel_power_raw = {27}, wheel_power_polished = {28}, wheel_left_radius = {29:f3}, wheel_right_radius = {30:f3}, wheel_left_surface_angle = {31}, wheel_right_surface_angle = {32}, beyond_stack_left = {33}, beyond_stack_right = {34}, t.time = sysdate where t.machine_name = '{0}'", machine_name, gnss_info.WalkingPosition, gnss_info.PitchAngle, gnss_info.YawAngle, gnss_info.LocalCoor_Tipx, gnss_info.LocalCoor_Tipy, gnss_info.LocalCoor_Tipz, opc_source.WalkingPosition_Plc, opc_source.WalkingPosition_Plc, opc_source.PitchAngle_Plc, opc_source.YawAngle_Plc, gnss_info.LocalCoor_Tipz + Config.HeightOffset, gnss_info.Working ? 1 : 0, gnss_info.IsFixed ? 1 : 0, gnss_info.PositionQuality, gnss_info.Longitude, gnss_info.Latitude, gnss_info.Altitude, opc_source.CoalOnBeltPlc, gnss_info.LocalCoor_Antex, gnss_info.LocalCoor_Antey, gnss_info.LocalCoor_Antez, opc_source.StreamPerHour, opc_source.StreamTotal, radar_info.DistWheelLeft, radar_info.DistWheelRight, radar_info.DistBelt, opc_source.WheelPowerRaw, opc_source.WheelPowerPolished, radar_info.RadiusAverageLeft, radar_info.RadiusAverageRight, radar_info.SurfaceAngleWheelLeft, radar_info.SurfaceAngleWheelRight, opc_source.WheelLeftBeyondStack, opc_source.WheelRightBeyondStack);
return(this.provider.ExecuteSql(sql));
}
/// <summary>
/// 更新单机落料口/斗轮下沿、回转轴本地坐标
/// </summary>
/// <param name="machine_name">单机名称</param>
/// <param name="radar_info">雷达信息实体</param>
/// <param name="gnss_info">GNSS信息实体</param>
/// <returns></returns>
public int UpdateMachinePosture2(string machine_name, RadarProtoInfo radar_info, GnssProtoInfo gnss_info)
{
string sql = string.Format("update t_rcms_machineposture2_time t set t.local_tipx = {1}, t.local_tipy = {2}, t.local_tipz = {3}, t.local_centrex = {4}, t.local_centrey = {5}, t.local_centrez = {6}, t.distances = '{7}', t.time = sysdate where t.machine_name = '{0}'", machine_name, gnss_info.LocalCoor_Tipx, gnss_info.LocalCoor_Tipy, gnss_info.LocalCoor_Tipz, gnss_info.LocalCoor_Centrex, gnss_info.LocalCoor_Centrey, gnss_info.LocalCoor_Centrez, radar_info.BlockDistances);
return(this.provider.ExecuteSql(sql));
}
/// <summary>
/// 插入雷达测距值
/// </summary>
/// <param name="radar_id">雷达ID</param>
/// <param name="dist">距离</param>
/// <returns></returns>
public int InsertRadarDistance(GnssProtoInfo gnss_info, RadarProtoInfo radar_info)
{
return(this.InsertRadarDistance(gnss_info.LocalCoor_Tipx, gnss_info.LocalCoor_Tipy, gnss_info.LocalCoor_Tipz, radar_info.DistWheelLeft, radar_info.DistWheelRight, radar_info.DistWheelAverage));
}
