public int Update(t_DM_ElementDevice model)
{
string sql = $@"UPDATE [dbo].[t_DM_ElementDevice]
SET [DeviceCode] = '{model.DeviceCode}'
,[DeviceName] = '{model.DeviceName}'
,[DeviceModel] = '{model.DeviceModel}'
,[Manufactor] = '{model.Manufactor}'
,[DID] = {model.DID}
,[PID] = {model.PID}
WHERE ID={model.ID}";
return(ExecuteSqlCommand(sql));
}
public t_DM_ElementDevice GetModelByID(int id)
{
t_DM_ElementDevice model = new t_DM_ElementDevice();
try
{
model = _dbFactory.elementDevice.GetModelByID(id);
}
catch (Exception ex)
{
throw ex;
}
return(model);
}
public int Update(t_DM_ElementDevice model)
{
int n = 0;
try
{
n = _dbFactory.elementDevice.Update(model);
}
catch (Exception ex)
{
throw ex;
}
return(n);
}
public int Add(t_DM_ElementDevice model)
{
string sql = $@"INSERT INTO [dbo].[t_DM_ElementDevice]
([DeviceCode]
,[DeviceName]
,[DeviceModel]
,[Manufactor]
,[DID]
,[PID])
VALUES
('{model.DeviceCode}','{model.DeviceName}','{model.DeviceModel}','{model.Manufactor}',{model.DID},{model.PID})";
return(ExecuteSqlCommand(sql));
}
