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