/** * 29.员工查询商品信息 * 参数:员工Id * 返回:本店所有商品信息的集合(通过测试) */ public item[] getAllItemsOfThisShop(string staffId) { string shopId = getShopIdByStaffId(staffId); using (YMDBEntities db = new YMDBEntities()) { stock[] currentStock = db.stock.Where(p => p.shopId == shopId).ToArray(); item[] items = new item[currentStock.Length]; for (int i = 0; i < currentStock.Length; i++) { string currentItemId = currentStock[i].itemId; items[i] = db.item.Where(p => p.itemId == currentItemId).FirstOrDefault(); } return items; } }
/** * 39.Boss增加商品 * 参数:新增商品的名字、尺寸、颜色、价格 * 返回:商品实例(测试通过) */ public item addItemByBoss(string currentItemName, string currentItemSize, string currenttemColor, double currentItemPrice) { if (currentItemSize.Length > 5) { return null; } string newId = createNewId("item"); using (YMDBEntities db = new YMDBEntities()) { //decimal newItem = new item().itemPrice; item newItem = new item { itemName = currentItemName, itemSize = currentItemSize, itemPrice = (decimal)currentItemPrice, itemColor = currenttemColor, itemDate = DateTime.Now, itemId = newId, itemStatus = 1, }; db.item.Add(newItem); db.SaveChanges(); return newItem; } }