//Select statement
public List <text_data_list> Select(string dgTagID)
{
MySqlConnectA();
// Console.WriteLine("dgTagID" + dgTagID);
// string SQL = "select DISTINCT(TagID) as TagID from ChinNum_Reader_data where TagID='" + dgTagID+"'";
string SQL = "select DISTINCT(" + tagField + ") as TagID," + dateField + " as date," + timeField + " as time ," + reField + " as result from " + table + " where " + tagField + "='" + dgTagID + "'";
// SqlDataAdapter da = new SqlDataAdapter(SQL,connection);
MySqlCommand myCommand = new MySqlCommand(SQL, connection);
MySqlDataReader myDataReader = myCommand.ExecuteReader();
// SqlCommand myCommand = new SqlCommand(SQL, connection);
// SqlDataReader myDataReader = myCommand.ExecuteReader();
//讀取結果
List <text_data_list> selectresult = new List <text_data_list>();
while (myDataReader.Read())
{
if (myDataReader["TagID"].ToString() != "")
{
text_data_list data = new text_data_list();
data.TagID = myDataReader["TagID"].ToString();
data.date = Convert.ToDateTime(myDataReader["date"]).ToString("yyyy/MM/dd");
data.time = myDataReader["time"].ToString();
data.result = myDataReader["result"].ToString();
selectresult.Add(data);
}
}
//close connection
this.CloseConnection();
return(selectresult);
}
//Select statement
public List <text_data_list> selectdoublecheck(string tagID)
{
MySqlConnectA();
// SqlDataAdapter da = new SqlDataAdapter(SQL,connection);
// MySqlCommand myCommand = new MySqlCommand("SELECT * FROM `ChinNum_Reader_data` WHERE chinID=(SELECT MAX(id) FROM chinNum_Reader)", connection);
// Console.WriteLine("SELECT * FROM `" + table + "` WHERE " + tagField + "=" + tagID + "");
MySqlCommand myCommand = new MySqlCommand("SELECT * FROM `" + table + "` WHERE " + tagField + "='" + tagID + "'", connection);
MySqlDataReader myDataReader = myCommand.ExecuteReader();
// SqlCommand myCommand = new SqlCommand(SQL, connection);
// SqlDataReader myDataReader = myCommand.ExecuteReader();
//讀取結果
List <text_data_list> selectresult = new List <text_data_list>();
while (myDataReader.Read())
{
if (myDataReader["id"].ToString() != "")
{
text_data_list data = new text_data_list();
if (myDataReader["date"].ToString() != "")
{
data.date = Convert.ToDateTime(myDataReader["date"]).ToString("yyyy/MM/dd");
}
if (myDataReader["time"].ToString() != "")
{
data.time = myDataReader["time"].ToString();
}
data.TagID = myDataReader["TagID"].ToString();
data.result = myDataReader["result"].ToString();
data.chinID = Convert.ToInt32(myDataReader["chinID"]);
selectresult.Add(data);
}
}
//close connection
// Console.WriteLine("selectresult" + selectresult.Count);
this.CloseConnection();
return(selectresult);
}
//Select statement
public List <text_data_list> chinLastestData()
{
MySqlConnectA();
// SqlDataAdapter da = new SqlDataAdapter(SQL,connection);
// MySqlCommand myCommand = new MySqlCommand("SELECT * FROM `ChinNum_Reader_data` WHERE chinID=(SELECT MAX(id) FROM chinNum_Reader)", connection);
MySqlCommand myCommand = new MySqlCommand("SELECT * FROM `" + table + "` WHERE " + tableSumID + "=(SELECT MAX(" + tableID2 + ") FROM " + table2 + ") ORDER BY " + dateField + "," + timeField + "", connection);
MySqlDataReader myDataReader = myCommand.ExecuteReader();
// SqlCommand myCommand = new SqlCommand(SQL, connection);
// SqlDataReader myDataReader = myCommand.ExecuteReader();
//讀取結果
List <text_data_list> selectresult = new List <text_data_list>();
while (myDataReader.Read())
{
if (myDataReader["id"].ToString() != "")
{
text_data_list data = new text_data_list();
if (myDataReader["date"].ToString() != "")
{
data.date = Convert.ToDateTime(myDataReader["date"]).ToString("yyyy/MM/dd");
}
if (myDataReader["time"].ToString() != "")
{
data.time = myDataReader["time"].ToString();
}
data.TagID = myDataReader["TagID"].ToString();
data.result = myDataReader["result"].ToString();
data.chinID = Convert.ToInt32(myDataReader["chinID"]);
selectresult.Add(data);
}
}
//close connection
this.CloseConnection();
return(selectresult);
}
