public List <RuntimeStationData> SelectRuntimeStationData(int StationID, DateTime TargetDate) { connect(); DateTime TimeStart = TargetDate.Date; DateTime TimeEnd = TimeStart + TimeSpan.FromDays(1) - TimeSpan.FromSeconds(1); List <RuntimeStationData> DataList = new List <RuntimeStationData>(); string sql = String.Format("SELECT * FROM `runtime_station_data` WHERE `StationID`={0} AND `Time` BETWEEN '{1}' AND '{2}';", StationID, TimeStart.ToString("yyyy-MM-dd HH:mm:ss"), TimeEnd.ToString("yyyy-MM-dd HH:mm:ss")); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { RuntimeStationData Record = new RuntimeStationData() { ID = (int)rdr["ID"], StationID = (int)rdr["StationID"], ActivePower = double.Parse((string)rdr["ActivePower"]), ReactivePower = double.Parse((string)rdr["ReactivePower"]), Time = (DateTime)rdr["Time"] }; DataList.Add(Record); } rdr.Close(); return(DataList); }
public int AddRuntimeStationData(RuntimeStationData Record) { connect(); string sql = String.Format("INSERT INTO `runtime_station_data` (`StationID`,`ActivePower`,`ReactivePower`,`Time`) VALUE ('{0}','{1}','{2}','{3}');", Record.StationID, Record.ActivePower, Record.ReactivePower, Record.Time.ToString("yyyy-MM-dd HH:mm:ss")); MySqlCommand cmd = new MySqlCommand(sql, conn); int result = cmd.ExecuteNonQuery(); return result; }
public int AddRuntimeStationData(RuntimeStationData Record) { connect(); string sql = String.Format("INSERT INTO `runtime_station_data` (`StationID`,`ActivePower`,`ReactivePower`,`Time`) VALUE ('{0}','{1}','{2}','{3}');", Record.StationID, Record.ActivePower, Record.ReactivePower, Record.Time.ToString("yyyy-MM-dd HH:mm:ss")); MySqlCommand cmd = new MySqlCommand(sql, conn); int result = cmd.ExecuteNonQuery(); return(result); }
public RuntimeStationData FindRuntimeStationData(int ID) { connect(); string sql = String.Format("SELECT * FROM `runtime_station_data` WHERE `ID`={0};", ID); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); rdr.Read(); RuntimeStationData Record = new RuntimeStationData() { ID = (int)rdr["ID"], StationID = (int)rdr["StationID"], ActivePower = double.Parse((string)rdr["ActivePower"]), ReactivePower = double.Parse((string)rdr["ReactivePower"]), Time = (DateTime)rdr["Time"] }; rdr.Close(); return(Record); }
public List <RuntimeStationData> UpdateRuntimeStationData(int StartID, int StationID) { connect(); List <RuntimeStationData> DataList = new List <RuntimeStationData>(); string sql = String.Format("SELECT * FROM `runtime_station_data` WHERE `ID`>{0} AND `StationID`={0};", StartID, StationID); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { RuntimeStationData Record = new RuntimeStationData() { ID = (int)rdr["ID"], StationID = (int)rdr["StationID"], ActivePower = double.Parse((string)rdr["ActivePower"]), ReactivePower = double.Parse((string)rdr["ReactivePower"]), Time = (DateTime)rdr["Time"] }; DataList.Add(Record); } rdr.Close(); return(DataList); }
public int AddRuntimeStationData(RuntimeStationData Record) { DatabaseConnector dc = new DatabaseConnector(); return(dc.AddRuntimeStationData(Record)); }
public List<RuntimeStationData> UpdateRuntimeStationData(int StartID, int StationID) { connect(); List<RuntimeStationData> DataList = new List<RuntimeStationData>(); string sql = String.Format("SELECT * FROM `runtime_station_data` WHERE `ID`>{0} AND `StationID`={0};", StartID,StationID); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { RuntimeStationData Record = new RuntimeStationData() { ID = (int)rdr["ID"], StationID = (int)rdr["StationID"], ActivePower = double.Parse((string)rdr["ActivePower"]), ReactivePower = double.Parse((string)rdr["ReactivePower"]), Time = (DateTime)rdr["Time"] }; DataList.Add(Record); } rdr.Close(); return DataList; }
public List<RuntimeStationData> SelectRuntimeStationData(int StationID, DateTime TargetDate) { connect(); DateTime TimeStart = TargetDate.Date; DateTime TimeEnd = TimeStart + TimeSpan.FromDays(1) - TimeSpan.FromSeconds(1); List<RuntimeStationData> DataList = new List<RuntimeStationData>(); string sql = String.Format("SELECT * FROM `runtime_station_data` WHERE `StationID`={0} AND `Time` BETWEEN '{1}' AND '{2}';", StationID, TimeStart.ToString("yyyy-MM-dd HH:mm:ss"), TimeEnd.ToString("yyyy-MM-dd HH:mm:ss")); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { RuntimeStationData Record = new RuntimeStationData() { ID = (int)rdr["ID"], StationID = (int)rdr["StationID"], ActivePower = double.Parse((string)rdr["ActivePower"]), ReactivePower = double.Parse((string)rdr["ReactivePower"]), Time = (DateTime)rdr["Time"] }; DataList.Add(Record); } rdr.Close(); return DataList; }
public RuntimeStationData FindRuntimeStationData(int ID) { connect(); string sql = String.Format("SELECT * FROM `runtime_station_data` WHERE `ID`={0};", ID); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); rdr.Read(); RuntimeStationData Record = new RuntimeStationData() { ID = (int)rdr["ID"], StationID = (int)rdr["StationID"], ActivePower = double.Parse((string)rdr["ActivePower"]), ReactivePower = double.Parse((string)rdr["ReactivePower"]), Time = (DateTime)rdr["Time"] }; rdr.Close(); return Record; }
public int AddRuntimeStationData(RuntimeStationData Record) { DatabaseConnector dc = new DatabaseConnector(); return dc.AddRuntimeStationData(Record); }