public static int insertProject(long id, string name, string addr, double lat, double lng)
 {
     using (SQLiteCommand cmd = new SQLiteCommand(
                "INSERT INTO Project values (@id, @name, @addr, @lat, @lng)"))
     {
         cmd.Parameters.Add("@id", DbType.Int64).Value    = id;
         cmd.Parameters.Add("@name", DbType.String).Value = name;
         cmd.Parameters.Add("@addr", DbType.String).Value = addr;
         cmd.Parameters.Add("@lat", DbType.Double).Value  = lat;
         cmd.Parameters.Add("@lng", DbType.Double).Value  = lng;
         return(SQLiteDBMS.execInsert(cmd));
     }
 }
 public static int insertPLC(string alias, int netid, string ip, int port, int polling_rate, long project_id)
 {
     using (SQLiteCommand cmd = new SQLiteCommand(
                "INSERT INTO PLC (net_id, net_ip, net_port, alias, polling_rate, project_id) "
                + "values (@net_id, @net_ip, @net_port, @alias, @polling_rate, @project_id)"))
     {
         cmd.Parameters.Add("@net_id", DbType.Int32).Value       = netid;
         cmd.Parameters.Add("@net_ip", DbType.String).Value      = ip;
         cmd.Parameters.Add("@net_port", DbType.Int32).Value     = port;
         cmd.Parameters.Add("@alias", DbType.String).Value       = alias;
         cmd.Parameters.Add("@polling_rate", DbType.Int32).Value = polling_rate;
         cmd.Parameters.Add("@project_id", DbType.Int64).Value   = project_id;
         return(SQLiteDBMS.execInsert(cmd));
     }
 }
 public static int insertScaling(string scale_type, double raw_hi, double raw_lo, double scale_hi, double scale_lo, long tag_id)
 {
     using (SQLiteCommand cmd = new SQLiteCommand(
                "INSERT INTO Scaling (scale_type, raw_hi, raw_lo, scale_hi, scale_lo, tag_id) "
                + "values (@scale_type, @raw_hi, @raw_lo, @scale_hi, @scale_lo, @tag_id)"))
     {
         // scale
         cmd.Parameters.Add("@scale_type", DbType.String).Value = scale_type.ToString();
         cmd.Parameters.Add("@raw_hi", DbType.Double).Value     = raw_hi;
         cmd.Parameters.Add("@raw_lo", DbType.Double).Value     = raw_lo;
         cmd.Parameters.Add("@scale_hi", DbType.Double).Value   = scale_hi;
         cmd.Parameters.Add("@scale_lo", DbType.Double).Value   = scale_lo;
         cmd.Parameters.Add("@tag_id", DbType.Int64).Value      = tag_id;
         return(SQLiteDBMS.execInsert(cmd));
     }
 }
 public static int insertTag(string alias, int addr, DataType type, string format, string unit, long plc_id)
 {
     using (SQLiteCommand cmd = new SQLiteCommand(
                "INSERT INTO Tag (alias, addr, data_type, format, unit, plc_id) "
                + "values (@alias, @addr, @data_type, @format, @unit, @plc_id)"))
     {
         cmd.Parameters.Add("@alias", DbType.String).Value     = alias;
         cmd.Parameters.Add("@addr", DbType.Int32).Value       = addr;
         cmd.Parameters.Add("@data_type", DbType.String).Value = type.ToString();
         cmd.Parameters.Add("@format", DbType.String).Value    = format;
         cmd.Parameters.Add("@unit", DbType.String).Value      = unit;
         // foreigh
         cmd.Parameters.Add("@plc_id", DbType.Int64).Value = plc_id;
         return(SQLiteDBMS.execInsert(cmd));
     }
 }