/// <summary>
/// 减少库存
/// </summary>
/// <param name="id">房间有商品表编号</param>
/// <param name="num">减少数量</param>
/// <returns></returns>
public bool ReduceCommodity(int id, int num)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
Room_Commodity rc = db.Room_Commodity.Where(s => s.Id == id).FirstOrDefault();
rc.CommodityNum = num;
db.Entry(rc).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
//throw;
}
return(false);
}
/// <summary>
/// 添加房间有商品表
/// </summary>
/// <param name="rc">房间有商品表对象</param>
/// <returns></returns>
public bool IncreaseCommodityCW(Room_Commodity rc)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
db.Room_Commodity.Add(rc);
Commodity c = db.Commodity.Where(s => s.Id == rc.CommodityId).FirstOrDefault();
c.SeparableNum = c.SeparableNum - rc.CommodityNum;
db.Entry(c).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
// throw;
}
return(false);
}
/// <summary>
/// 添加房间商品分配
/// </summary>
/// <param name="Id">房间编号</param>
/// <param name="name">商品编号</param>
/// <param name="commodityNum">添加数量</param>
/// <returns></returns>
public bool IncreaseCommodityC(int Id, int name, int commodityNum)
{
try
{
using (HotelManageDBEntities db = new HotelManageDBEntities())
{
Room_Commodity rc = db.Room_Commodity.Where(s => s.RoomId == Id && s.CommodityId == name).FirstOrDefault();
rc.CommodityNum = rc.CommodityNum + commodityNum;
db.Entry(rc).State = EntityState.Modified;
Commodity c = db.Commodity.Where(s => s.Id == name).FirstOrDefault();
c.SeparableNum = c.SeparableNum - commodityNum;
db.Entry(c).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
// throw;
}
return(false);
}
