C# (CSharp) t_EE_PriceEnery示例

示例#1

文件： PriceEneryDAL.cs 项目： 123356/123

 public int UpdatePriceEnery(t_EE_PriceEnery model)
 {
     try
     {
         return(_dbFactory.priceEnery.UpdatePriceEnery(model));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

示例#2

        public int UpdatePriceEnery(t_EE_PriceEnery model)
        {
            string sql = $@"UPDATE [dbo].[t_EE_PriceEnery]
   SET [UID] = {model.UID}
      ,[CollTypeID] = {model.CollTypeID}
      ,[Ladder] = {model.Ladder}
      ,[LadderValue] = '{model.LadderValue}'
      ,[Price] = {model.Price}
 WHERE ID={model.ID}";

            return(ExecuteSqlCommand(sql));
        }

示例#3

        public int InserPriceEnery(t_EE_PriceEnery model)
        {
            string sql = $@"INSERT INTO [dbo].[t_EE_PriceEnery]
           ([UID]
           ,[CollTypeID]
           ,[Ladder]
           ,[LadderValue]
           ,[Price])
     VALUES
           ({model.UID}
           ,{model.CollTypeID}
           ,{model.Ladder}
           ,'{model.LadderValue}'
           ,{model.Price})";

            return(ExecuteSqlCommand(sql));
        }