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); }