/// <summary> /// 更改料理营业额记录 /// </summary> /// <param name="ft"></param> /// <returns></returns> public static bool UpdateFoodsTurnOver(FoodsTurnOver ft) { string cmdline = @"UPDATE [dbo].[FoodsTurnOver] SET [Amount] = @amount ,[Discount] = @discount ,[TypeId] = @typeid ,[AddDate] = @adddate ,[WeekDay] = @weekday ,[OwnerId] = @ownerid ,[Comments] = @comments ,[CreateTime] = @createtime ,[LastUpdateTime] = @lastupdatetime WHERE [Id] = @id"; SqlParameter[] parameters = { new SqlParameter("@id", ft.Id), new SqlParameter("@amount", ft.Amount), new SqlParameter("@discount", ft.Discount), new SqlParameter("@typeid", ft.TypeId), new SqlParameter("@adddate", ft.AddDate), new SqlParameter("@weekday", DateTime.Parse(ft.AddDate).DayOfWeek), new SqlParameter("@ownerid", ft.OwnerId), new SqlParameter("@comments", ft.Comments), new SqlParameter("@createtime", ft.CreateTime), new SqlParameter("@lastupdatetime", ft.LastUpdateTime) }; return(SqlHelper.ExecuteNonQuery(cmdline, parameters)); }
/// <summary> /// 添加料理营业额记录 /// </summary> /// <param name="ft"></param> /// <returns></returns> public static bool AddFoodsTurnOver(FoodsTurnOver ft) { string cmdline = @"INSERT INTO [dbo].[FoodsTurnOver] ([Amount] ,[Discount] ,[TypeId] ,[AddDate] ,[WeekDay] ,[OwnerId] ,[Comments] ,[CreateTime] ,[LastUpdateTime]) VALUES (@amount, @discount, @typeid, @adddate, @weekday, @ownerid, @comments, @createtime, @lastupdatetime)"; SqlParameter[] parameters = { new SqlParameter("@amount", ft.Amount), new SqlParameter("@discount", ft.Discount), new SqlParameter("@typeid", ft.TypeId), new SqlParameter("@adddate", ft.AddDate), new SqlParameter("@weekday", DateTime.Parse(ft.AddDate).DayOfWeek), new SqlParameter("@ownerid", ft.OwnerId), new SqlParameter("@comments", ft.Comments), new SqlParameter("@createtime", ft.CreateTime), new SqlParameter("@lastupdatetime", ft.LastUpdateTime) }; return(SqlHelper.ExecuteNonQuery(cmdline, parameters)); }
public bool UpdateFoodsTurnOver([FromBody] FoodsTurnOver ft) { return(FoodsTurnOverHandler.UpdateFoodsTurnOver(ft)); }
public bool AddFoodsTurnOver([FromBody] FoodsTurnOver ft) { return(FoodsTurnOverHandler.AddFoodsTurnOver(ft)); }