public int Update(t_EE_EnergyAnnConfig model)
{
string sql = $@"UPDATE [dbo].[t_EE_EnergyAnnConfig]
SET [UID] = {model.UID}
,[UserID] = {model.UserID}
,[EneryUserTypeID] = '{model.EneryUserTypeID}'
WHERE ID={model.ID}";
return(ExecuteSqlCommand(sql));
}
public int UpdateConfig(t_EE_EnergyAnnConfig model)
{
try
{
return(_dbFactory.energyAnnConfig.Update(model));
}
catch (Exception ex)
{
throw ex;
}
}
public int Add(t_EE_EnergyAnnConfig model)
{
string sql = $@"INSERT INTO [dbo].[t_EE_EnergyAnnConfig]
([UID]
,[UserID]
,[EneryUserTypeID])
VALUES
({model.UID}
,{model.UserID}
,'{model.EneryUserTypeID}')";
return(ExecuteSqlCommand(sql));
}