public static bool AddSignal(SignalInfo info)
{
con.Open();
cmd.Connection = con;
cmd.CommandText = "INSERT INTO DataSetInfo(cardname, name, sensortype, detectequipment,position,signalrange,resolution,resolutiondouble,basevalue,remark) " +
"VALUES(@cardname, @name, @sensortype, @detectequipment,@position,@signalrange,@resolution,@resolutiondouble,@basevalue,@remark)";
cmd.Parameters.Add("cardname", System.Data.DbType.String).Value = info.cardname;
cmd.Parameters.Add("name", System.Data.DbType.String).Value = info.name;
cmd.Parameters.Add("sensortype", System.Data.DbType.String).Value = info.sensortype;
cmd.Parameters.Add("detectequipment", System.Data.DbType.String).Value = info.detectequipment;
cmd.Parameters.Add("position", System.Data.DbType.String).Value = info.position;
cmd.Parameters.Add("signalrange", System.Data.DbType.String).Value = info.signalrange;
cmd.Parameters.Add("resolution", System.Data.DbType.UInt32).Value = info.resolution;
cmd.Parameters.Add("resolutiondouble", System.Data.DbType.Double).Value = info.resolutiondouble;
cmd.Parameters.Add("basevalue", System.Data.DbType.Double).Value = info.basevalue;
cmd.Parameters.Add("remark", System.Data.DbType.String).Value = info.remark;
cmd.ExecuteNonQuery();
cmd.CommandText = string.Format("CREATE TABLE IF NOT EXISTS {0}(id INTEGER PRIMARY KEY AUTOINCREMENT, " +
"time DOUBLE, increase DOUBLE, value UNSIGNEDINTEGER16, remark UNSIGNEDINTEGER16)", info.name);
cmd.ExecuteNonQuery();
cmd.CommandText = string.Format("CREATE TABLE IF NOT EXISTS {0}Time (starttime DOUBLE, stoptime DOUBLE)", info.name);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
public static SignalInfo GetSignal(string name)
{
SignalInfo info = new SignalInfo();
info.name = name;
con.Open();
cmd.Connection = con;
string sql = string.Format("select * from DataSetInfo where name='{0}'", name);
SQLiteCommand command = new SQLiteCommand(sql, con);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
info.position = reader["position"] == DBNull.Value ? "" : (string)reader["position"];
info.detectequipment = reader["detectequipment"] == DBNull.Value ? "" : (string)reader["detectequipment"];
info.remark = (reader["remark"] == DBNull.Value) ? "" : (string)reader["remark"];
info.resolution = (ushort)int.Parse(reader["resolution"].ToString());
info.resolutiondouble = Double.Parse(reader["resolutiondouble"].ToString());
info.basevalue = Double.Parse(reader["basevalue"].ToString());
info.sensortype = (string)reader["sensortype"];
info.signalrange = (string)reader["signalrange"];
}
con.Close();
return(info);
}
public static bool ChgSignal(SignalInfo preinfo, SignalInfo info)
{
con.Open();
cmd.Connection = con;
string sql = "update DataSetInfo set ";
sql += string.Format("cardname='{0}', ", info.cardname);
sql += string.Format("name='{0}', ", info.name);
sql += string.Format("detectequipment='{0}', ", info.detectequipment);
sql += string.Format("position='{0}', ", info.position);
sql += string.Format("remark='{0}', ", info.remark);
sql += string.Format("resolution={0}, ", info.resolution);
sql += string.Format("resolutiondouble={0}, ", info.resolutiondouble);
sql += string.Format("basevalue={0}, ", info.basevalue);
sql += string.Format("sensortype='{0}', ", info.sensortype);
sql += string.Format("signalrange='{0}' ", info.signalrange);
sql += string.Format("where name='{0}'", preinfo.name);
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
sql = string.Format("alter table {0} rename to {1}", preinfo.name, info.name);
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
sql = string.Format("alter table {0}Time rename to {1}Time", preinfo.name, info.name);
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
