public DataTable SelectByDateTime(DateTime dateTime)
{
String sql = "SELECT * FROM tb_plane_kingdata where `DateTime`=\"" + dateTime.ToString("yyyy-MM-dd HH:mm:ss") + "\";";
DataTable dataTable = MySqlDatabaseUtil.ExecuteQuery(sql);
return(dataTable);
}
//不建议使用
public DataTable SelectAll()
{
String sql = "SELECT * FROM tb_plane_kingdata;";
DataTable dataTable = MySqlDatabaseUtil.ExecuteQuery(sql);
return(dataTable);
}
public DataTable SelectByLimit(int start, int count)
{
String sql = String.Format("SELECT * FROM tb_plane_kingdata LIMIT {0},{1}", start, count);
DataTable dataTable = MySqlDatabaseUtil.ExecuteQuery(sql);
return(dataTable);
}
public long getTotal()
{
String sql = "SELECT COUNT(*) FROM tb_plane_kingdata";
object data = MySqlDatabaseUtil.ExecuteScalar(sql);
long val = 0;
if (long.TryParse(data.ToString(), out val))
{
return(val);
}
else
{
throw new Exception(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "Formmater Error in getTotal");
}
}
/// <summary>
/// 批量导入数据库
/// </summary>
/// <param name="tableName"></param>
/// <param name="folder"></param>
public static void ImportTableBatch(String tableName, String folder)
{
List <String> strSql = Procedure.MergeCsvFile2InsertSql(tableName, folder);
StringBuilder stringBuilder = new StringBuilder();
int count = 500;
int currentSize = 0;
int Count = strSql.Count;
while (strSql.Count > 0)
{
for (int i = 0; i < count && currentSize < strSql.Count; ++i, ++currentSize)
{
stringBuilder.Append(strSql[i] + "\n");
}
strSql.RemoveRange(0, currentSize < count ? currentSize : count);
currentSize = 0;
MySqlDatabaseUtil.ExecuteNoQuery(stringBuilder.ToString());
Console.WriteLine("已处理{0},剩余{1}.", Count - strSql.Count, strSql.Count);
stringBuilder.Clear();
}
}
public static void CreateTable(String csvfilepath, String renamefilepath, String tableName)
{
//1 read csv
//2 预处理字段名 ，将空格去掉，-改为_
//3 检测重名， 重名的采用 先加_filename ,如果在重复 加_i
//4 没有重名后，写入 文件，原来 以及改完后的，对于那4个30行，需要处理
//5 拼接sql，并执行
//1
List <String[]> headers = CSVUtil.ReadCsv(csvfilepath);
//2
List <String[]> renameHeaders = PerProcessingFieldName(headers);
//3
#region 检测重名， 重名的采用 先加_filename ,如果在重复 加_i
ISet <String> set = new HashSet <String>();
foreach (String[] strs in renameHeaders)
{
String fieldName = strs[0];
if (set.Contains(fieldName.ToLower()))
{
//rename
fieldName += "_" + strs[3];
int i = 0;
String temp = null;
do
{
i++;
temp = fieldName + "_" + i;
} while (set.Contains(temp.ToLower()));
fieldName = temp;
strs[0] = fieldName;
}
set.Add(fieldName.ToLower());
}
#endregion
//4 没有重名后，写入 文件，原来 以及改完后的，对于那4个30行，需要处理
StringBuilder stringBuilder = new StringBuilder();
using (StreamWriter sw = new StreamWriter(renamefilepath))
{
for (int i = 0; i < headers.Count(); ++i)
{
foreach (String str in headers[i])
{
stringBuilder.Append(str + " ");
}
foreach (String str in renameHeaders[i])
{
stringBuilder.Append(str + " ");
}
sw.WriteLine(stringBuilder.ToString());
stringBuilder.Clear();
}
}
//5
List <AscField> fieldHeaders = new List <AscField>();
foreach (String[] strs in renameHeaders)
{
AscField field = new AscField();
//special
if (strs[2] == "F10039" || strs[2] == "F10040" || strs[2] == "F10041" || strs[2] == "F10043" || strs[2] == "F10044")
{
String formula = strs[2];
String type = null;
if (formula == "F10039")
{
type = "DOUBLE(12,6)";
}
else
{
type = "FLOAT(12,6)";
}
for (int i = 0; i < 30; ++i)
{
field = new AscField();
field.FieldName = strs[0] + "_" + (i + 1);
field.Type = type;
field.Formula = strs[2];
fieldHeaders.Add(field);
}
}
else
{
//ordinary
field.FieldName = strs[0];
field.Type = strs[1].Replace("\"", "");
field.Formula = strs[2];
fieldHeaders.Add(field);
}
}
//output last rename field -> .last file
using (StreamWriter sw = new StreamWriter(renamefilepath + ".last"))
{
foreach (AscField f in fieldHeaders)
{
stringBuilder.Append(f.FieldName + " " + f.Type + " " + f.Formula);
sw.WriteLine(stringBuilder.ToString());
stringBuilder.Clear();
}
}
String strSql = GenerateCreateTableSql(tableName, fieldHeaders.ToArray());
Console.WriteLine("创建表sql语句\n" + strSql);
MySqlDatabaseUtil.ExecuteNoQuery(strSql);
}
//hardcode
public static void CreatTableByDefault(String tableName)
{
String str = "CREATE TABLE `" + tableName + "` ( id int NOT NULL auto_increment ,`DateTime` datetime ,`Latitude` FLOAT(12,6) ,`Longitude` FLOAT(12,6) ,`TAS` FLOAT(12,6) ,`Id0Count` DOUBLE(12,6) ,`Time` VARCHAR(200) ,`Temp` FLOAT(12,6) ,`RH` FLOAT(12,6) ,`BaroPress` FLOAT(12,6) ,`WindFlowNS` FLOAT(12,6) ,`WindFlowEW` FLOAT(12,6) ,`WindSpeed` FLOAT(12,6) ,`WindDir` FLOAT(12,6) ,`WindSolution` VARCHAR(200) ,`BaroPress_aimms_1` FLOAT(12,6) ,`WindSpeed_aimms_1` FLOAT(12,6) ,`Altitude` FLOAT(12,6) ,`Id1Count` DOUBLE(12,6) ,`Time_aimms_1` VARCHAR(200) ,`Latitude_aimms_1` FLOAT(12,6) ,`Longitude_aimms_1` FLOAT(12,6) ,`Altitude_aimms_1` FLOAT(12,6) ,`VelocityNS` FLOAT(12,6) ,`VelocityEW` FLOAT(12,6) ,`VelocityUD` FLOAT(12,6) ,`Roll` FLOAT(12,6) ,`Pitch` FLOAT(12,6) ,`Yaw` FLOAT(12,6) ,`TAS_aimms_1` FLOAT(12,6) ,`VerticalWind` FLOAT(12,6) ,`Sideslip` FLOAT(12,6) ,`AOAPressDiff` FLOAT(12,6) ,`SideslipDiff` FLOAT(12,6) ,`Latitude_aimms_2` VARCHAR(200) ,`Longitude_aimms_2` VARCHAR(200) ,`Altitude_aimms_2` FLOAT(12,6) ,`Id2Count` DOUBLE(12,6) ,`Time_aimms_2` FLOAT(12,6) ,`Latitude_aimms_3` FLOAT(12,6) ,`Longitude_aimms_3` FLOAT(12,6) ,`Altitude_aimms_3` FLOAT(12,6) ,`GroundSpeed` FLOAT(12,6) ,`GroundTrack` FLOAT(12,6) ,`HFOM` FLOAT(12,6) ,`VFOM` FLOAT(12,6) ,`NavMode` DOUBLE(12,6) ,`Satellites` FLOAT(12,6) ,`DatumNumber` FLOAT(12,6) ,`SolConfLevel` VARCHAR(200) ,`GPSTimeAlign` VARCHAR(200) ,`NavModeStatus` VARCHAR(200) ,`Latitude_aimms_4` VARCHAR(200) ,`Longitude_aimms_4` VARCHAR(200) ,`Altitude_aimms_4` FLOAT(12,6) ,`Latitude_aimms_5` FLOAT(12,6) ,`Longitude_aimms_5` FLOAT(12,6) ,`DateTime_arinc429_1` datetime ,`StaticPSSECorrected` FLOAT(12,6) ,`ImpactPressure` FLOAT(12,6) ,`Altitude_arinc429_1` FLOAT(12,6) ,`BaroCorrectedAltitude` FLOAT(12,6) ,`Mach` FLOAT(12,6) ,`Airspeed` FLOAT(12,6) ,`TrueAirSpeed` FLOAT(12,6) ,`Totaltemp` FLOAT(12,6) ,`StaticTemp` FLOAT(12,6) ,`veritcalSpeed` FLOAT(12,6) ,`magheadingdeg` FLOAT(12,6) ,`Date` datetime ,`AIMMSTime` VARCHAR(200) ,`Latitude_bjwmo_1` FLOAT(12,6) ,`Longitude_bjwmo_1` FLOAT(12,6) ,`LWC` FLOAT(12,6) ,`TWC` FLOAT(12,6) ,`Hygrometer` FLOAT(12,6) ,`RICEMsoFreqHz` FLOAT(12,6) ,`RMTTotalTempC` FLOAT(12,6) ,`RMTStaticTempC` FLOAT(12,6) ,`DewPointC` FLOAT(12,6) ,`TAS_bjwmo_1` FLOAT(12,6) ,`Temp_bjwmo_1` FLOAT(12,6) ,`RH_bjwmo_1` FLOAT(12,6) ,`WindFlowNS_bjwmo_1` FLOAT(12,6) ,`WindFlowEW_bjwmo_1` FLOAT(12,6) ,`WindSpeed_bjwmo_1` FLOAT(12,6) ,`WindDir_bjwmo_1` FLOAT(12,6) ,`WindSolution_bjwmo_1` VARCHAR(200) ,`BaroPress_bjwmo_1` FLOAT(12,6) ,`WindSpeed_bjwmo_2` FLOAT(12,6) ,`Altitude_bjwmo_1` FLOAT(12,6) ,`Latitude_bjwmo_2` FLOAT(12,6) ,`Longitude_bjwmo_2` FLOAT(12,6) ,`Altitude_bjwmo_2` FLOAT(12,6) ,`VelocityNS_bjwmo_1` FLOAT(12,6) ,`VelocityEW_bjwmo_1` FLOAT(12,6) ,`VelocityUD_bjwmo_1` FLOAT(12,6) ,`Roll_bjwmo_1` FLOAT(12,6) ,`Pitch_bjwmo_1` FLOAT(12,6) ,`Yaw_bjwmo_1` FLOAT(12,6) ,`TAS_bjwmo_2` FLOAT(12,6) ,`VerticalWind_bjwmo_1` FLOAT(12,6) ,`Sideslip_bjwmo_1` FLOAT(12,6) ,`AOAPressDiff_bjwmo_1` FLOAT(12,6) ,`SideslipDiff_bjwmo_1` FLOAT(12,6) ,`Latitude_bjwmo_3` VARCHAR(200) ,`Longitude_bjwmo_3` VARCHAR(200) ,`Altitude_bjwmo_3` FLOAT(12,6) ,`StaticPSSECorrected_bjwmo_1` FLOAT(12,6) ,`StaticPSSECorrected_bjwmo_2` FLOAT(12,6) ,`DateTime_icedet_1` datetime ,`ID_W` VARCHAR(200) ,`OnTimeCntr` DOUBLE(12,6) ,`Power` DOUBLE(12,6) ,`PermErr1` VARCHAR(200) ,`PermErr2` VARCHAR(200) ,`PermErr3` VARCHAR(200) ,`TotIceCnt` DOUBLE(12,6) ,`ID_X` VARCHAR(200) ,`MsoFreq` DOUBLE(12,6) ,`IceCycCnt` DOUBLE(12,6) ,`SigState` VARCHAR(200) ,`OprState` VARCHAR(200) ,`BitErr1` VARCHAR(200) ,`BitErr2` VARCHAR(200) ,`BitErr3` VARCHAR(200) ,`ID_Y` VARCHAR(200) ,`TotFailCnt` DOUBLE(12,6) ,`MsoFailCnt` DOUBLE(12,6) ,`IceFailCnt` DOUBLE(12,6) ,`StaFailCnt` DOUBLE(12,6) ,`HtrFailCnt` DOUBLE(12,6) ,`ID_Z` VARCHAR(200) ,`FaultLog1` VARCHAR(200) ,`FaultLog2` VARCHAR(200) ,`FaultLog3` VARCHAR(200) ,`FaultLog4` VARCHAR(200) ,`FaultLog5` VARCHAR(200) ,`FaultLog6` VARCHAR(200) ,`FaultLog7` VARCHAR(200) ,`DateTime_inletcontroldata_1` datetime ,`tip_flow` FLOAT(12,6) ,`tipfltrg` FLOAT(12,6) ,`airspeed_inletcontroldata_1` FLOAT(12,6) ,`oat_temp` FLOAT(12,6) ,`instflow` FLOAT(12,6) ,`inltpres` FLOAT(12,6) ,`blwrflow` FLOAT(12,6) ,`blwrtarg` FLOAT(12,6) ,`blwr_tmp` FLOAT(12,6) ,`blwr_pwr` FLOAT(12,6) ,`throtpos` FLOAT(12,6) ,`fconetmp` FLOAT(12,6) ,`rconetmp` FLOAT(12,6) ,`pylontmp` FLOAT(12,6) ,`sensrtmp` FLOAT(12,6) ,`fconepwr` FLOAT(12,6) ,`rconepwr` FLOAT(12,6) ,`pylonpwr` FLOAT(12,6) ,`sensrpwr` FLOAT(12,6) ,`DateTime_m300TAS_1` datetime ,`ARINCTAS` FLOAT(12,6) ,`DateTime_nev_1` datetime ,`ARINCAltitudeft` FLOAT(12,6) ,`NevTWC` FLOAT(12,6) ,`NevLWC` FLOAT(12,6) ,`DateTime_pcasp_1` datetime ,`Analog0` FLOAT(12,6) ,`Analog1` FLOAT(12,6) ,`Analog2` FLOAT(12,6) ,`Analog3` FLOAT(12,6) ,`Analog4` FLOAT(12,6) ,`Analog5` FLOAT(12,6) ,`Analog6` FLOAT(12,6) ,`Analog7` FLOAT(12,6) ,`HighGainBaselinev` FLOAT(12,6) ,`MidGainBaselinev` FLOAT(12,6) ,`LowGainBaselinev` FLOAT(12,6) ,`SampleFlow` FLOAT(12,6) ,`LaserReferencev` FLOAT(12,6) ,`Analog1v` FLOAT(12,6) ,`SheathFlow` FLOAT(12,6) ,`InternalTemp` FLOAT(12,6) ,`AvgTransit` FLOAT(12,6) ,`AvgTransit_pcasp_1` FLOAT(12,6) ,`FIFOFull` FLOAT(12,6) ,`ResetFlag` FLOAT(12,6) ,`SynsErrorA` FLOAT(12,6) ,`SyncErrorB` FLOAT(12,6) ,`SyncErrorC` FLOAT(12,6) ,`Overrange` FLOAT(12,6) ,`SPPSamples` FLOAT(12,6) ,`RangeValue` FLOAT(12,6) ,`RangeControl` FLOAT(12,6) ,`Range` FLOAT(12,6) ,`LasereReferencev` FLOAT(12,6) ,`Channel_1` DOUBLE(12,6) ,`Channel_2` DOUBLE(12,6) ,`Channel_3` DOUBLE(12,6) ,`Channel_4` DOUBLE(12,6) ,`Channel_5` DOUBLE(12,6) ,`Channel_6` DOUBLE(12,6) ,`Channel_7` DOUBLE(12,6) ,`Channel_8` DOUBLE(12,6) ,`Channel_9` DOUBLE(12,6) ,`Channel_10` DOUBLE(12,6) ,`Channel_11` DOUBLE(12,6) ,`Channel_12` DOUBLE(12,6) ,`Channel_13` DOUBLE(12,6) ,`Channel_14` DOUBLE(12,6) ,`Channel_15` DOUBLE(12,6) ,`Channel_16` DOUBLE(12,6) ,`Channel_17` DOUBLE(12,6) ,`Channel_18` DOUBLE(12,6) ,`Channel_19` DOUBLE(12,6) ,`Channel_20` DOUBLE(12,6) ,`Channel_21` DOUBLE(12,6) ,`Channel_22` DOUBLE(12,6) ,`Channel_23` DOUBLE(12,6) ,`Channel_24` DOUBLE(12,6) ,`Channel_25` DOUBLE(12,6) ,`Channel_26` DOUBLE(12,6) ,`Channel_27` DOUBLE(12,6) ,`Channel_28` DOUBLE(12,6) ,`Channel_29` DOUBLE(12,6) ,`Channel_30` DOUBLE(12,6) ,`MidSizes_1` FLOAT(12,6) ,`MidSizes_2` FLOAT(12,6) ,`MidSizes_3` FLOAT(12,6) ,`MidSizes_4` FLOAT(12,6) ,`MidSizes_5` FLOAT(12,6) ,`MidSizes_6` FLOAT(12,6) ,`MidSizes_7` FLOAT(12,6) ,`MidSizes_8` FLOAT(12,6) ,`MidSizes_9` FLOAT(12,6) ,`MidSizes_10` FLOAT(12,6) ,`MidSizes_11` FLOAT(12,6) ,`MidSizes_12` FLOAT(12,6) ,`MidSizes_13` FLOAT(12,6) ,`MidSizes_14` FLOAT(12,6) ,`MidSizes_15` FLOAT(12,6) ,`MidSizes_16` FLOAT(12,6) ,`MidSizes_17` FLOAT(12,6) ,`MidSizes_18` FLOAT(12,6) ,`MidSizes_19` FLOAT(12,6) ,`MidSizes_20` FLOAT(12,6) ,`MidSizes_21` FLOAT(12,6) ,`MidSizes_22` FLOAT(12,6) ,`MidSizes_23` FLOAT(12,6) ,`MidSizes_24` FLOAT(12,6) ,`MidSizes_25` FLOAT(12,6) ,`MidSizes_26` FLOAT(12,6) ,`MidSizes_27` FLOAT(12,6) ,`MidSizes_28` FLOAT(12,6) ,`MidSizes_29` FLOAT(12,6) ,`MidSizes_30` FLOAT(12,6) ,`Counts_1` FLOAT(12,6) ,`Counts_2` FLOAT(12,6) ,`Counts_3` FLOAT(12,6) ,`Counts_4` FLOAT(12,6) ,`Counts_5` FLOAT(12,6) ,`Counts_6` FLOAT(12,6) ,`Counts_7` FLOAT(12,6) ,`Counts_8` FLOAT(12,6) ,`Counts_9` FLOAT(12,6) ,`Counts_10` FLOAT(12,6) ,`Counts_11` FLOAT(12,6) ,`Counts_12` FLOAT(12,6) ,`Counts_13` FLOAT(12,6) ,`Counts_14` FLOAT(12,6) ,`Counts_15` FLOAT(12,6) ,`Counts_16` FLOAT(12,6) ,`Counts_17` FLOAT(12,6) ,`Counts_18` FLOAT(12,6) ,`Counts_19` FLOAT(12,6) ,`Counts_20` FLOAT(12,6) ,`Counts_21` FLOAT(12,6) ,`Counts_22` FLOAT(12,6) ,`Counts_23` FLOAT(12,6) ,`Counts_24` FLOAT(12,6) ,`Counts_25` FLOAT(12,6) ,`Counts_26` FLOAT(12,6) ,`Counts_27` FLOAT(12,6) ,`Counts_28` FLOAT(12,6) ,`Counts_29` FLOAT(12,6) ,`Counts_30` FLOAT(12,6) ,`ValidCounts` FLOAT(12,6) ,`MinSizes_1` FLOAT(12,6) ,`MinSizes_2` FLOAT(12,6) ,`MinSizes_3` FLOAT(12,6) ,`MinSizes_4` FLOAT(12,6) ,`MinSizes_5` FLOAT(12,6) ,`MinSizes_6` FLOAT(12,6) ,`MinSizes_7` FLOAT(12,6) ,`MinSizes_8` FLOAT(12,6) ,`MinSizes_9` FLOAT(12,6) ,`MinSizes_10` FLOAT(12,6) ,`MinSizes_11` FLOAT(12,6) ,`MinSizes_12` FLOAT(12,6) ,`MinSizes_13` FLOAT(12,6) ,`MinSizes_14` FLOAT(12,6) ,`MinSizes_15` FLOAT(12,6) ,`MinSizes_16` FLOAT(12,6) ,`MinSizes_17` FLOAT(12,6) ,`MinSizes_18` FLOAT(12,6) ,`MinSizes_19` FLOAT(12,6) ,`MinSizes_20` FLOAT(12,6) ,`MinSizes_21` FLOAT(12,6) ,`MinSizes_22` FLOAT(12,6) ,`MinSizes_23` FLOAT(12,6) ,`MinSizes_24` FLOAT(12,6) ,`MinSizes_25` FLOAT(12,6) ,`MinSizes_26` FLOAT(12,6) ,`MinSizes_27` FLOAT(12,6) ,`MinSizes_28` FLOAT(12,6) ,`MinSizes_29` FLOAT(12,6) ,`MinSizes_30` FLOAT(12,6) ,`MaxSizes_1` FLOAT(12,6) ,`MaxSizes_2` FLOAT(12,6) ,`MaxSizes_3` FLOAT(12,6) ,`MaxSizes_4` FLOAT(12,6) ,`MaxSizes_5` FLOAT(12,6) ,`MaxSizes_6` FLOAT(12,6) ,`MaxSizes_7` FLOAT(12,6) ,`MaxSizes_8` FLOAT(12,6) ,`MaxSizes_9` FLOAT(12,6) ,`MaxSizes_10` FLOAT(12,6) ,`MaxSizes_11` FLOAT(12,6) ,`MaxSizes_12` FLOAT(12,6) ,`MaxSizes_13` FLOAT(12,6) ,`MaxSizes_14` FLOAT(12,6) ,`MaxSizes_15` FLOAT(12,6) ,`MaxSizes_16` FLOAT(12,6) ,`MaxSizes_17` FLOAT(12,6) ,`MaxSizes_18` FLOAT(12,6) ,`MaxSizes_19` FLOAT(12,6) ,`MaxSizes_20` FLOAT(12,6) ,`MaxSizes_21` FLOAT(12,6) ,`MaxSizes_22` FLOAT(12,6) ,`MaxSizes_23` FLOAT(12,6) ,`MaxSizes_24` FLOAT(12,6) ,`MaxSizes_25` FLOAT(12,6) ,`MaxSizes_26` FLOAT(12,6) ,`MaxSizes_27` FLOAT(12,6) ,`MaxSizes_28` FLOAT(12,6) ,`MaxSizes_29` FLOAT(12,6) ,`MaxSizes_30` FLOAT(12,6) ,`DateTime_pcasp_simple2_1` datetime ,`Counts_pcasp_simple2_1_1` FLOAT(12,6) ,`Counts_pcasp_simple2_1_2` FLOAT(12,6) ,`Counts_pcasp_simple2_1_3` FLOAT(12,6) ,`Counts_pcasp_simple2_1_4` FLOAT(12,6) ,`Counts_pcasp_simple2_1_5` FLOAT(12,6) ,`Counts_pcasp_simple2_1_6` FLOAT(12,6) ,`Counts_pcasp_simple2_1_7` FLOAT(12,6) ,`Counts_pcasp_simple2_1_8` FLOAT(12,6) ,`Counts_pcasp_simple2_1_9` FLOAT(12,6) ,`Counts_pcasp_simple2_1_10` FLOAT(12,6) ,`Counts_pcasp_simple2_1_11` FLOAT(12,6) ,`Counts_pcasp_simple2_1_12` FLOAT(12,6) ,`Counts_pcasp_simple2_1_13` FLOAT(12,6) ,`Counts_pcasp_simple2_1_14` FLOAT(12,6) ,`Counts_pcasp_simple2_1_15` FLOAT(12,6) ,`Counts_pcasp_simple2_1_16` FLOAT(12,6) ,`Counts_pcasp_simple2_1_17` FLOAT(12,6) ,`Counts_pcasp_simple2_1_18` FLOAT(12,6) ,`Counts_pcasp_simple2_1_19` FLOAT(12,6) ,`Counts_pcasp_simple2_1_20` FLOAT(12,6) ,`Counts_pcasp_simple2_1_21` FLOAT(12,6) ,`Counts_pcasp_simple2_1_22` FLOAT(12,6) ,`Counts_pcasp_simple2_1_23` FLOAT(12,6) ,`Counts_pcasp_simple2_1_24` FLOAT(12,6) ,`Counts_pcasp_simple2_1_25` FLOAT(12,6) ,`Counts_pcasp_simple2_1_26` FLOAT(12,6) ,`Counts_pcasp_simple2_1_27` FLOAT(12,6) ,`Counts_pcasp_simple2_1_28` FLOAT(12,6) ,`Counts_pcasp_simple2_1_29` FLOAT(12,6) ,`Counts_pcasp_simple2_1_30` FLOAT(12,6) ,`SampleFlow_pcasp_simple2_1` FLOAT(12,6) ,`Altitudeft` FLOAT(12,6) ,`DateTime_tracegas_1` datetime ,`DateTime_tracegas_2` datetime ,`ARINCAltitudeft_tracegas_1` FLOAT(8,1) ,`ARINCStaticPmb` FLOAT(8,1) ,`RMTStaticC` FLOAT(8,1) ,`DPC` FLOAT(8,1) ,`O3` FLOAT(9,3) ,`NOX` FLOAT(9,3) ,`SO2` FLOAT(9,3) ,`H2O2` FLOAT(9,3) ,`CO` FLOAT(9,3) ,`O3_tracegas_1` FLOAT(9,0) ,`NOX_tracegas_1` FLOAT(9,0) ,`SO2_tracegas_1` FLOAT(9,0) ,`H2O2_tracegas_1` FLOAT(9,0) ,`CO_tracegas_1` FLOAT(9,0) ,PRIMARY KEY (`id`) )ENGINE=InnoDB DEFAULT CHARSET=utf8";
MySqlDatabaseUtil.ExecuteNoQuery(str);
}
public DataTable CustomQuery(string sql)
{
DataTable dataTable = MySqlDatabaseUtil.ExecuteQuery(sql);
return(dataTable);
}