public void DeleteDeviceSwitch(Device_Switch ds) { string cmd = "DELETE " + TABLE_NAME + " WHERE " + COLUMN_DEVICE_ID + "=" + PARAM_DEVICE_ID;// DT WHERE DeviceId=@DeviceId"; using (DbConnection conn = di.getDbConnection(Config.Instance.ConnectString)) { try { DbCommand comm = di.getDbCommand(cmd); comm.Parameters.Add(Utility.GetDbParameter(comm, PARAM_DEVICE_ID, DbType.String, 16, ds.DeviceID, ParameterDirection.Input)); //comm.Parameters.Add(Utility.GetDbParameter(comm, "@LastUpdate", DbType.String, 16, d.LastUpdate, ParameterDirection.Input)); comm.Connection = conn; conn.Open(); comm.ExecuteNonQuery(); } finally { if (conn != null) { conn.Close(); } } } }
public void UpdateDeviceSwitch(Device_Switch ds) { string cmd = "UPDATE " + TABLE_NAME + " SET " + COLUMN_DEVICE_ID + "=" + PARAM_DEVICE_ID + "," + COLUMN_ON_OFF_CONFIG + "=" + PARAM_ON_OFF_CONFIG + " WHERE " + COLUMN_DEVICE_ID + "=" + PARAM_DEVICE_ID;// DT SET deviceid=@DeviceId, lastupdate=@LastUpdate Where deviceid=@DeviceId"; using (DbConnection conn = di.getDbConnection(Config.Instance.ConnectString)) { try { DbCommand comm = di.getDbCommand(cmd); comm.Parameters.Add(Utility.GetDbParameter(comm, PARAM_DEVICE_ID, DbType.String, 16, ds.DeviceID, ParameterDirection.Input)); comm.Parameters.Add(Utility.GetDbParameter(comm, PARAM_ON_OFF_CONFIG, DbType.String, 60, ds.OnOffConfig, ParameterDirection.Input)); comm.Connection = conn; conn.Open(); comm.ExecuteNonQuery(); } finally { if (conn != null) { conn.Close(); } } } }
public void AddDeviceSwitch(Device_Switch ds) { string cmd = "INSERT INTO " + TABLE_NAME + " (" + COLUMN_DEVICE_ID + ", " + COLUMN_ON_OFF_CONFIG + ") VALUES (" + PARAM_DEVICE_ID + ", " + PARAM_ON_OFF_CONFIG + ")"; using (DbConnection conn = di.getDbConnection(Config.Instance.ConnectString)) { try { DbCommand comm = di.getDbCommand(cmd); comm.Parameters.Add(Utility.GetDbParameter(comm, PARAM_DEVICE_ID, DbType.String, 16, ds.DeviceID, ParameterDirection.Input)); comm.Parameters.Add(Utility.GetDbParameter(comm, PARAM_ON_OFF_CONFIG, DbType.String, 60, ds.OnOffConfig, ParameterDirection.Input)); comm.Connection = conn; conn.Open(); comm.ExecuteNonQuery(); } finally { if (conn != null) { conn.Close(); } } } }
public Device_Switch GetDevice(string deviceid) { string cmd = "SELECT * FROM " + TABLE_NAME + " WHERE " + COLUMN_DEVICE_ID + "=" + PARAM_DEVICE_ID; DbDataReader reader = null; Device_Switch d = new Device_Switch(); using (DbConnection conn = di.getDbConnection(Config.Instance.ConnectString)) { try { DbCommand comm = di.getDbCommand(cmd); comm.Parameters.Add(Utility.GetDbParameter(comm, PARAM_DEVICE_ID, DbType.String, 16, d.DeviceID, ParameterDirection.Input)); comm.Connection = conn; conn.Open(); reader = comm.ExecuteReader(); if (reader.Read()) { d.LoadReader(reader); } } finally { if (reader != null) { reader.Close(); } if (conn != null) { conn.Close(); } } } return(d); }