//ADS_B插入一行静态数据
public static string Insert_Static(ADS_B_INFO.ADS_MessageInfo message, DateTime dateTime, string Datetime, int ChanlNo, int CRC, int Send_Flag)
{
message.AirPlaneID = (message.AirPlaneID == null ? "" : message.AirPlaneID);
message.CC_CDTI = (message.CC_CDTI == null ? "" : message.CC_CDTI);
message.CC_ARV = (message.CC_ARV == null ? "" : message.CC_ARV);
message.CC_TS = (message.CC_TS == null ? "" : message.CC_TS);
message.CC_TC = (message.CC_TC == null ? "" : message.CC_TC);
message.CC_POA = (message.CC_POA == null ? "" : message.CC_POA);
message.CC_B2Low = (message.CC_B2Low == null ? "" : message.CC_B2Low);
message.OM_RA = (message.OM_RA == null ? "" : message.OM_RA);
message.OM_IDENT = (message.OM_IDENT == null ? "" : message.OM_IDENT);
message.OM_ATC = (message.OM_ATC == null ? "" : message.OM_ATC);
message.MOPS = (message.MOPS == null ? "" : message.MOPS);
message.NACp = (message.NACp == null ? "" : message.NACp);
message.SIL = (message.SIL == null ? "" : message.SIL);
message.NIC_BARO = (message.NIC_BARO == null ? "" : message.NIC_BARO);
message.TRK_HDG = (message.TRK_HDG == null ? "" : message.TRK_HDG);
message.HRD = (message.HRD == null ? "" : message.HRD);
string sql = "insert into ads_table_static_" + dateTime.ToString("yyMM") + " (fid,ICAO,Type," +
"AirPlaneID," +
"CC_CDTI,CC_ARV,CC_TS,CC_TC,CC_POA,CC_B2Low," +
"OM_Type,OM_RA,OM_IDENT,OM_ATC,MOPS,NACp,SIL,NIC_BARO,TRK_HDG,HRD," +
"Channel,CreatDate,Error_Flag,Flag,Send_Flag) " +
"VALUE (UUID()," + message.ICAO + "," + message.Type +
",'" + message.AirPlaneID +
"','" + message.CC_CDTI + "','" + message.CC_ARV + "','" + message.CC_TS + "','" + message.CC_TC + "','" + message.CC_POA + "','" + message.CC_B2Low +
"'," + message.OM_Type + ",'" + message.OM_RA + "','" + message.OM_IDENT + "','" + message.OM_ATC + "','" + message.MOPS + "','" + message.NACp + "','" + message.SIL + "','" + message.NIC_BARO + "','" + message.TRK_HDG + "','" + message.HRD +
"','" + ChanlNo + "','" + Datetime + "'," + CRC + ",0," + Send_Flag + ")";
return(sql);
}
//ADS插入一行新数据
public static string ADS_Insert(ADS_B_INFO.ADS_MessageInfo message, DataClass RecData)
{
message.longitude = (message.longitude == null ? "181" : message.longitude);
message.latitude = (message.latitude == null ? "91" : message.latitude);
string sql = RecData.SaveDate + '\t' + message.ICAO.ToString() + '\t' + message.Height.ToString() + '\t' + message.longitude + '\t' + message.latitude +
'\t' + RecData.dLon.ToString("f4") + '\t' + RecData.dLat.ToString("f4") + '\t' + "0" + '\t' + RecData.power.ToString("f2") + '\r' + '\n';
return(sql);
}
//ADS_B更新融合数据
public static string Updata_ToTable(string FID, ADS_B_INFO.ADS_MessageInfo StaticsData, DateTime DateTime)
{
StaticsData.AirPlaneID = (StaticsData.AirPlaneID == null ? "" : StaticsData.AirPlaneID);
StaticsData.CC_CDTI = (StaticsData.CC_CDTI == null ? "" : StaticsData.CC_CDTI);
StaticsData.CC_ARV = (StaticsData.CC_ARV == null ? "" : StaticsData.CC_ARV);
StaticsData.CC_TS = (StaticsData.CC_TS == null ? "" : StaticsData.CC_TS);
StaticsData.CC_TC = (StaticsData.CC_TC == null ? "" : StaticsData.CC_TC);
StaticsData.CC_POA = (StaticsData.CC_POA == null ? "" : StaticsData.CC_POA);
StaticsData.CC_B2Low = (StaticsData.CC_B2Low == null ? "" : StaticsData.CC_B2Low);
StaticsData.L_WType = (StaticsData.L_WType == null ? "" : StaticsData.L_WType);
string sql = "update ads_table_" + DateTime.ToString("yyMM") + " set AirPlaneID='" + StaticsData.AirPlaneID + "',CC_CDTI='" + StaticsData.CC_CDTI + "',CC_ARV='" + StaticsData.CC_ARV + "',CC_TS='" + StaticsData.CC_TS + "',CC_TC='" + StaticsData.CC_TC + "',CC_POA='" + StaticsData.CC_POA + "',CC_B2Low='" + StaticsData.CC_B2Low + "',L_WType='" + StaticsData.L_WType + "',Flag=1" +
" where CreatDate >'" + DateTime.ToString("yyyy-MM-dd") + "' and CreatDate <'" + DateTime.AddDays(1).ToString("yyyy-MM-dd") + "' and fid='" + FID + "'";
return(sql);
}
//ADS_B插入一行动态数据
public static string Insert(ADS_B_INFO.ADS_MessageInfo message, DateTime dateTime, string Datetime, int ChanlNo, int CRC, int Send_Flag)
{
message.MonitorState = (message.MonitorState == null ? "" : message.MonitorState);
message.SingleAntenna = (message.SingleAntenna == null ? "" : message.SingleAntenna);
message.longitude = (message.longitude == null ? "" : message.longitude);
message.latitude = (message.latitude == null ? "" : message.latitude);
message.AirPlaneID = (message.AirPlaneID == null ? "" : message.AirPlaneID);
message.WorkingState = (message.WorkingState == null ? "" : message.WorkingState);
message.PathStateFlag = (message.PathStateFlag == null ? "" : message.PathStateFlag);
message.PathState = (message.PathState == null ? "" : message.PathState);
message.AimChange = (message.AimChange == null ? "" : message.AimChange);
message.IFR = (message.IFR == null ? "" : message.IFR);
message.AirSpeedType = (message.AirSpeedType == null ? "" : message.AirSpeedType);
message.VerticalSpeedSource = (message.VerticalSpeedSource == null ? "" : message.VerticalSpeedSource);
message.VerticalSpeedFlag = (message.VerticalSpeedFlag == null ? "" : message.VerticalSpeedFlag);
message.VerticalSpeed = (message.VerticalSpeed == null ? "" : message.VerticalSpeed);
message.AtmosphereFlag = (message.AtmosphereFlag == null ? "" : message.AtmosphereFlag);
message.Atmosphere = (message.Atmosphere == null ? "" : message.Atmosphere);
message.AtmosphereDataSource = (message.AtmosphereDataSource == null ? "" : message.AtmosphereDataSource);
message.HeightType = (message.HeightType == null ? "" : message.HeightType);
message.HeightProperty = (message.HeightProperty == null ? "" : message.HeightProperty);
message.AtmosphereMode = (message.AtmosphereMode == null ? "" : message.AtmosphereMode);
message.LevelDataSource = (message.LevelDataSource == null ? "" : message.LevelDataSource);
message.TargetDirectionFlag = (message.TargetDirectionFlag == null ? "" : message.TargetDirectionFlag);
message.LevelMode = (message.LevelMode == null ? "" : message.LevelMode);
message.PropertyCode = (message.PropertyCode == null ? "" : message.PropertyCode);
message.EmergencyCode = (message.EmergencyCode == null ? "" : message.EmergencyCode);
message.CC_CDTI = (message.CC_CDTI == null ? "" : message.CC_CDTI);
message.CC_ARV = (message.CC_ARV == null ? "" : message.CC_ARV);
message.CC_TS = (message.CC_TS == null ? "" : message.CC_TS);
message.CC_TC = (message.CC_TC == null ? "" : message.CC_TC);
message.CC_POA = (message.CC_POA == null ? "" : message.CC_POA);
message.CC_B2Low = (message.CC_B2Low == null ? "" : message.CC_B2Low);
message.OM_RA = (message.OM_RA == null ? "" : message.OM_RA);
message.OM_IDENT = (message.OM_IDENT == null ? "" : message.OM_IDENT);
message.OM_ATC = (message.OM_ATC == null ? "" : message.OM_ATC);
message.MOPS = (message.MOPS == null ? "" : message.MOPS);
message.NACp = (message.NACp == null ? "" : message.NACp);
message.SIL = (message.SIL == null ? "" : message.SIL);
message.NIC_BARO = (message.NIC_BARO == null ? "" : message.NIC_BARO);
message.L_WType = (message.L_WType == null ? "" : message.L_WType);
message.TRK_HDG = (message.TRK_HDG == null ? "" : message.TRK_HDG);
message.HRD = (message.HRD == null ? "" : message.HRD);
string sql = "insert into ads_table_" + dateTime.ToString("yyMM") + " (fid,ICAO,Type,MonitorState,SingleAntenna,Height,longitude,latitude," +
"AirPlaneID,WorkingState,PathStateFlag,PathState,SubType,AimChange,IFR,AirDirection,AirSpeedType,AirSpeed,VerticalSpeedSource,VerticalSpeedFlag," +
"VerticalSpeed,AtmosphereFlag,Atmosphere,AtmosphereDataSource,HeightType,HeightProperty,AtmosphereMode,TargetHeight,LevelDataSource,TargetDirection," +
"TargetDirectionFlag,LevelMode,PropertyCode,EmergencyCode,CC_CDTI,CC_ARV,CC_TS,CC_TC,CC_POA,CC_B2Low," +
"OM_Type,OM_RA,OM_IDENT,OM_ATC,MOPS,NACp,SIL,NIC_BARO,L_WType,TRK_HDG,HRD," +
"Channel,CreatDate,Error_Flag,Flag,Send_Flag) " +
"VALUE (UUID()," + message.ICAO + "," + message.Type + ",'" + message.MonitorState + "','" + message.SingleAntenna + "'," + message.Height + ",'" + message.longitude + "','" + message.latitude +
"','" + message.AirPlaneID + "','" + message.WorkingState + "','" + message.PathStateFlag + "','" + message.PathState + "'," + message.SubType + ",'" + message.AimChange + "','" + message.IFR + "','" + message.AirDirection + "','" + message.AirSpeedType + "','" + message.AirSpeed + "','" + message.VerticalSpeedSource + "','" + message.VerticalSpeedFlag +
"','" + message.VerticalSpeed + "','" + message.AtmosphereFlag + "','" + message.Atmosphere + "','" + message.AtmosphereDataSource + "','" + message.HeightType + "','" + message.HeightProperty + "','" + message.AtmosphereMode + "'," + message.TargetHeight + ",'" + message.LevelDataSource + "'," + message.TargetDirection +
",'" + message.TargetDirectionFlag + "','" + message.LevelMode + "','" + message.PropertyCode + "','" + message.EmergencyCode + "','" + message.CC_CDTI + "','" + message.CC_ARV + "','" + message.CC_TS + "','" + message.CC_TC + "','" + message.CC_POA + "','" + message.CC_B2Low +
"'," + message.OM_Type + ",'" + message.OM_RA + "','" + message.OM_IDENT + "','" + message.OM_ATC + "','" + message.MOPS + "','" + message.NACp + "','" + message.SIL + "','" + message.NIC_BARO + "','" + message.L_WType + "','" + message.TRK_HDG + "','" + message.HRD +
"','" + ChanlNo + "','" + Datetime + "'," + CRC + ",0," + Send_Flag + ")";
return(sql);
}
