static internal int WriteWarehouseOrder(WarehouseOrder o) {
var operation = DataOperation.Parse("writeSNMWarehouseOrder", o.Id, o.GetEmpiriaType().Id,
o.Operation.Id, o.Number, o.Concept, o.SupplyPoint.Id, o.StorageUnit.Id,
o.RequestedBy.Id, o.Responsible.Id, o.Supervisor.Id, o.OrderAuthorizationId,
o.OrderingTime, o.ClosingTime, o.Keywords, o.BaseSupplyOrder.Id, o.ParentWarehouseOrder.Id,
o.PostedBy.Id, o.PostingTime, (char) o.Status);
return DataWriter.Execute(operation);
}
static internal int UpdateExpectedQuantitiesWithARPStock(WarehouseOrder order) {
return DataWriter.Execute(DataOperation.Parse("doUpdateCountingWithARPStock", order.Id));
}
static public FixedList<WarehouseOrderItem> GetWarehouseOrdersItems(WarehouseOrder order) {
var operation = DataOperation.Parse("qrySNMWarehouseOrderItems", order.Id);
return DataReader.GetList<WarehouseOrderItem>(operation,
(x) => BaseObject.ParseList<WarehouseOrderItem>(x)).ToFixedList();
}
static public DataView GetWarehouseOrdersItemsARPCrossed(WarehouseOrder order) {
return DataReader.GetDataView(DataOperation.Parse("qryARPWarehouseOrdersItemsARPCrossed", order.Id));
}
internal WarehouseOrderItem(WarehouseOrder order) {
this.order = order;
}
protected override void OnLoadObjectData(DataRow row) {
this.order = WarehouseOrder.Parse((int) row["WarehouseOrderId"]);
this.orderItemTypeId = (int) row["WarehouseOrderItemTypeId"];
this.concept = (string) row["WarehouseOrderItemConcept"];
this.applicationItemTypeId = (int) row["ApplicationItemTypeId"];
this.applicationItemId = (int) row["ApplicationItemId"];
this.requestedDate = (DateTime) row["RequestedDate"];
this.promisedDate = (DateTime) row["PromisedDate"];
this.deliveryTime = (DateTime) row["DeliveryTime"];
this.product = Product.Parse((int) row["ProductId"]);
this.quantity = (decimal) row["Quantity"];
this.expectedQuantity = (decimal) row["ExpectedQuantity"];
this.inputQuantity = (decimal) row["InputQuantity"];
this.outputQuantity = (decimal) row["OutputQuantity"];
this.errorsCount = (int) row["ErrorsCount"];
this.presentationUnit = PresentationUnit.Parse((int) row["PresentationId"]);
this.contentsQty = (decimal) row["ContentsQty"];
this.contentsUnit = PresentationUnit.Parse((int) row["ContentsUnitId"]);
this.identificationTag = (string) row["IdentificationTag"];
this.dutyEntryTag = (string) row["DutyEntryTag"];
this.expirationDate = (DateTime) row["ExpirationDate"];
this.repositionValue = (decimal) row["RepositionValue"];
this.binCube = (string) row["BinCube"];
this.responsible = Contact.Parse((int) row["ResponsibleId"]);
this.authorizationId = (int) row["AuthorizationId"];
this.keywords = (string) row["WarehouseOrderItemKeywords"];
this.parentWarehouseOrderItemId = (int) row["ParentWarehouseOrderItemId"];
this.supplyOrderItemId = (int) row["SupplyOrderItemId"];
this.postedBy = Contact.Parse((int) row["PostedById"]);
this.postingTime = (DateTime) row["PostingTime"];
this.status = (GeneralObjectStatus) Convert.ToChar(row["WarehouseOrderItemStatus"]);
}