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