/// <summary> /// 更改酒水营业额记录 /// </summary> /// <param name="dt"></param> /// <returns></returns> public static bool UpdateDrinksTurnOver(DrinksTurnOver dt) { 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", dt.Id), new SqlParameter("@amount", dt.Amount), new SqlParameter("@discount", dt.Discount), new SqlParameter("@typeid", dt.TypeId), new SqlParameter("@adddate", dt.AddDate), new SqlParameter("@weekday", DateTime.Parse(dt.AddDate).DayOfWeek), new SqlParameter("@ownerid", dt.OwnerId), new SqlParameter("@comments", dt.Comments), new SqlParameter("@createtime", dt.CreateTime), new SqlParameter("@lastupdatetime", dt.LastUpdateTime) }; return(SqlHelper.ExecuteNonQuery(cmdline, parameters)); }
/// <summary> /// 添加酒水营业额记录 /// </summary> /// <param name="dt"></param> /// <returns></returns> public static bool AddDrinksTurnOver(DrinksTurnOver dt) { string cmdline = @"INSERT INTO [dbo].[DrinksTurnOver] ([Amount] ,[Discount] ,[TypeId] ,[AddDate] ,[WeekDay] ,[OwnerId] ,[Comments] ,[CreateTime] ,[LastUpdateTime]) VALUES (@amount, @discount, @typeid, @adddate, @weekday, @ownerid, @comments, @createtime, @lastupdatetime)"; SqlParameter[] parameters = { new SqlParameter("@amount", dt.Amount), new SqlParameter("@discount", dt.Discount), new SqlParameter("@typeid", dt.TypeId), new SqlParameter("@adddate", dt.AddDate), new SqlParameter("@weekday", DateTime.Parse(dt.AddDate).DayOfWeek), new SqlParameter("@ownerid", dt.OwnerId), new SqlParameter("@comments", dt.Comments), new SqlParameter("@createtime", dt.CreateTime), new SqlParameter("@lastupdatetime", dt.LastUpdateTime) }; return(SqlHelper.ExecuteNonQuery(cmdline, parameters)); }
public bool UpdateDrinksTurnOver([FromBody] DrinksTurnOver dt) { return(DrinksTurnOverHandler.UpdateDrinksTurnOver(dt)); }
public bool AddDrinksTurnOver([FromBody] DrinksTurnOver dt) { return(DrinksTurnOverHandler.AddDrinksTurnOver(dt)); }