//打开两个数据的连接
public void openconn()
{
try
{
ConnSrc.Open();
ConnTar.Open();
}
catch
{
}
}
//同步两个数据库的数据
public bool syn()
{
//定义返回变量
bool status;
status = false;
MySqlDataReader readerSrc;
MySqlCommand cmdSrc;
MySqlDataReader readerTar;
MySqlCommand cmdTar;
//获取第一个数据库的最后时间
//从数据库中读取数据流存入reader中
if (ConnSrc.State == ConnectionState.Closed)
{
try
{
ConnSrc.Open();
}
catch
{
}
}
if (ConnTar.State == ConnectionState.Closed)
{
try
{
ConnTar.Open();
}
catch
{
}
}
DateTime LastTimeSrc = new DateTime();
if (ConnTar.State == ConnectionState.Open)
{
cmdTar = ConnTar.CreateCommand();
//创建查询语句
cmdTar.CommandText = "select MAX(`BeginTime`) from `revsubdata` ";
readerTar = cmdTar.ExecuteReader();
if (readerTar.HasRows)
{
while (readerTar.Read())
{
LastTimeSrc = readerTar.GetDateTime(0);
}
readerTar.Close();
}
}
if (ConnTar.State == ConnectionState.Open && ConnSrc.State == ConnectionState.Open)
{
//获取所有大于第一个数据库最后时间的第二个数据库的10条数据条目
cmdSrc = ConnSrc.CreateCommand();
cmdSrc.CommandText = "select ID,BeginTime,EndTime,Mode,Operator,MENumber,AveFuel,SubTotal from `revsubdata` WHERE `BeginTime` > str_to_date('" + LastTimeSrc.ToString("yyyy-MM-dd HH:mm:ss") + "','%Y-%m-%d %H:%i:%s')order by `BeginTime` ASC LIMIT 0,10;";
readerSrc = cmdSrc.ExecuteReader();
DateTime BeginTime;
string tBeginTime;
DateTime EndTime;
string tEndTime;
int Mode;
int Operator;
int MENumber;
float AveFuel;
float SubTotal;
while (readerSrc.Read())
{
BeginTime = readerSrc.GetDateTime(readerSrc.GetOrdinal("BeginTime"));
tBeginTime = BeginTime.ToString("yyyy-MM-dd HH:mm:ss");
EndTime = readerSrc.GetDateTime(readerSrc.GetOrdinal("EndTime"));
tEndTime = EndTime.ToString("yyyy-MM-dd HH:mm:ss");
Mode = readerSrc.GetInt32(readerSrc.GetOrdinal("Mode"));
Operator = readerSrc.GetInt32(readerSrc.GetOrdinal("Operator"));
MENumber = readerSrc.GetInt32(readerSrc.GetOrdinal("MENumber"));
AveFuel = readerSrc.GetFloat(readerSrc.GetOrdinal("AveFuel"));
SubTotal = readerSrc.GetFloat(readerSrc.GetOrdinal("SubTotal"));
try
{
if (ConnTar.State == ConnectionState.Open)
{
MySqlCommand mycmd = new MySqlCommand("insert into revsubdata(BeginTime,EndTime,Mode,Operator,MENumber,AveFuel,SubTotal) values(STR_TO_DATE('"
+ tBeginTime + "','%Y-%m-%d %H:%i:%s'),STR_TO_DATE('"
+ tEndTime + "','%Y-%m-%d %H:%i:%s'),"
+ Mode + ","
+ Operator + ","
+ MENumber + ","
+ AveFuel + ","
+ SubTotal + ")", ConnTar);
if (mycmd.ExecuteNonQuery() > 0)
{
Console.WriteLine("数据插入成功！");
status = true;
}
}
}
catch
{
}
}
if (readerSrc.IsClosed == false)
{
readerSrc.Close();
}
}
return(status);
}
//同步两个数据库的数据
public bool syn()
{
//定义返回变量
bool status;
status = false;
MySqlDataReader readerSrc;
MySqlCommand cmdSrc;
MySqlDataReader readerTar;
MySqlCommand cmdTar;
//获取第一个数据库的最后时间
//从数据库中读取数据流存入reader中
if (ConnSrc.State == ConnectionState.Closed)
{
try
{
ConnSrc.Open();
}
catch
{
}
}
if (ConnTar.State == ConnectionState.Closed)
{
try
{
ConnTar.Open();
}
catch
{
}
}
DateTime LastTimeSrc = new DateTime();
if (ConnTar.State == ConnectionState.Open)
{
cmdTar = ConnTar.CreateCommand();
//创建查询语句
cmdTar.CommandText = "select MAX(`Time`) from `revrealdata` ";
readerTar = cmdTar.ExecuteReader();
if (readerTar.HasRows)
{
while (readerTar.Read())
{
LastTimeSrc = readerTar.GetDateTime(0);
}
readerTar.Close();
}
}
if (ConnTar.State == ConnectionState.Open && ConnSrc.State == ConnectionState.Open)
{
//获取所有大于第一个数据库最后时间的第二个数据库的10条数据条目
cmdSrc = ConnSrc.CreateCommand();
cmdSrc.CommandText = "select * from `revrealdata` WHERE `Time` > str_to_date('" + LastTimeSrc.ToString("yyyy-MM-dd HH:mm:ss") + "','%Y-%m-%d %H:%i:%s')order by `Time` ASC LIMIT 0,10;";
readerSrc = cmdSrc.ExecuteReader();
DateTime Time;
string tTime;
int MENumber;
float InstantFuel;
int InstantMESpeed;
float InstantTemp;
float InstantShipSpeed;
double InstantN;
double InstantE;
float TankLevel;
while (readerSrc.Read())
{
Time = readerSrc.GetDateTime(readerSrc.GetOrdinal("Time"));
tTime = Time.ToString("yyyy-MM-dd HH:mm:ss");
MENumber = readerSrc.GetInt32(readerSrc.GetOrdinal("MENumber"));
InstantFuel = readerSrc.GetFloat(readerSrc.GetOrdinal("InstantFuel"));
InstantMESpeed = readerSrc.GetInt32(readerSrc.GetOrdinal("InstantMESpeed"));
InstantTemp = readerSrc.GetFloat(readerSrc.GetOrdinal("InstantTemp"));
InstantShipSpeed = readerSrc.GetFloat(readerSrc.GetOrdinal("InstantShipSpeed"));
InstantN = readerSrc.GetDouble(readerSrc.GetOrdinal("InstantN"));
InstantE = readerSrc.GetDouble(readerSrc.GetOrdinal("InstantE"));
TankLevel = readerSrc.GetFloat(readerSrc.GetOrdinal("TankLevel"));
try
{
if (ConnTar.State == ConnectionState.Open)
{
MySqlCommand mycmd = new MySqlCommand("insert into revrealdata(Time,MENumber,InstantFuel,InstantMESpeed,InstantTemp,InstantShipSpeed,InstantN,InstantE,TankLevel) values(STR_TO_DATE('"
+ tTime + "','%Y-%m-%d %H:%i:%s'),"
+ MENumber + ","
+ InstantFuel + ","
+ InstantMESpeed + ","
+ InstantTemp + ","
+ InstantShipSpeed + ","
+ InstantN + ","
+ InstantE + ","
+ TankLevel + ")", ConnTar);
if (mycmd.ExecuteNonQuery() > 0)
{
Console.WriteLine("数据插入成功！");
status = true;
}
}
}
catch
{
}
}
if (readerSrc.IsClosed == false)
{
readerSrc.Close();
}
}
return(status);
}