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