public static void Load_To_AQT_Database(OPCField F, float Value, DateTime time, MySqlConnection conn) { MySqlCommand c = new MySqlCommand("INSERT INTO opc_data (Value,Time,ID) VALUES (@val,@t,@id)", conn); c.Parameters.Add(FillP("@val", Value, MySqlDbType.Float)); c.Parameters.Add(FillP("@id", F.ID, MySqlDbType.Int32)); c.Parameters.Add(FillP("@t", time, MySqlDbType.DateTime)); //c.Parameters.Add(FillParam("@st", d.fieldinfo.StationInfo.StationID, conn, System.Data.SqlDbType.TinyInt)); c.ExecuteNonQuery(); }
public static OPCField GetFieldInfo(string Name, MySqlConnection conn) { MySqlCommand c = new MySqlCommand(string.Format("SELECT * FROM fields WHERE Name ='{0}'", Name), conn); OPCField Field = null; MySqlDataReader reader = c.ExecuteReader(); try { if (reader.Read()) { Field = new OPCField(); Field.ID = (int)reader["ID"]; Field.Name = (string)reader["Name"]; Field.Scale = reader.GetFloat("Scale"); } } finally { reader.Close(); } return Field; }
public void InsertnewOPCField(OPCField F, MySqlConnection conn) { MySqlCommand c = new MySqlCommand("INSERT into fields ( Name ) VALUES ( ) " , conn); }