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