/// <summary> /// 입출고재고현황기록을 데이터베이스에 저장하고 재고현황수량에서 가감하여 재고현황을 반영한다. /// </summary> /// <param name="date"></param> /// <param name="spec"></param> /// <param name="count"></param> /// <param name="seller"></param> /// <param name="eep"></param> /// <param name="warehouse"></param> /// <param name="remark"></param> public InOutStock Save(StockType type, DateTime date, Specification spec, int count, Seller seller, Employee eep, Warehouse warehouse, string remark) { _InOutStock.StockType = type; _InOutStock.SpecificationUUID = spec.UUID; _InOutStock.Date = date; _InOutStock.ItemCount = count; _InOutStock.EnterpriseUUID = seller.UUID; _InOutStock.EmployeeUUID = eep.UUID; _InOutStock.WarehouseUUID = warehouse.UUID; _InOutStock.Remark = remark; IIndexQuery<Inventory, string> queryResult = null; using (var db = DatabaseDirector.GetDbInstance()) { queryResult = db.Table<Inventory>().IndexQueryByKey("SpecificationUUID", spec.UUID); } Inventory stockItem = queryResult.Count() == 0 ? new Inventory() { SpecificationUUID = spec.UUID, WarehouseUUID = warehouse.UUID } : queryResult.ToList().First(); switch (_InOutStock.StockType) { case StockType.IN: stockItem.ItemCount += count; break; case StockType.OUT: stockItem.ItemCount -= count; break; } stockItem.Save<Inventory>(); return _InOutStock.Save<InOutStock>(); }
public Inventory Save(Specification istd, Warehouse warehouse, int itemCount, string remark) { _stockItem.SpecificationUUID = istd.UUID; _stockItem.WarehouseUUID = warehouse.UUID; _stockItem.ItemCount = itemCount; _stockItem.Remark = remark; return _stockItem.Save<Inventory>(); }