C# (CSharp) t_EE_EnergyAnnConfig Examples

Example #1

File: EnergyAnnConfigDBContext.cs Project: 123356/123

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

Example #2

File: EnergyAnnConfigDAL.cs Project: 123356/123

 public int UpdateConfig(t_EE_EnergyAnnConfig model)
 {
     try
     {
         return(_dbFactory.energyAnnConfig.Update(model));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

Example #3

File: EnergyAnnConfigDBContext.cs Project: 123356/123

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