public void CreateTransportOrder(int type, int ctrH, int ctrD, LoadCarrier lc, int IocpId, int weight, StorageLocation sourceLocation, StorageLocation targetLocation) { //Csinálunk egy sessiont Session workSession = new Session(); //Megkeressük az erőforrásokat CommonTrHeader ctrHeader = workSession.FindObject <CommonTrHeader>(new BinaryOperator("Oid", ctrH)); CommonTrDetail cdetail = workSession.FindObject <CommonTrDetail>(new BinaryOperator("Oid", ctrD)); Iocp iocp = workSession.FindObject <Iocp>(new BinaryOperator("Oid", IocpId)); //Osztumk egy új sorszámot ushort UjTransportID = GetNewSorszam("TPO"); //Létrehozzuk az új transzportot az adatbázisban TransportOrder transportOrder = new TransportOrder(workSession); transportOrder.Iocp = iocp; transportOrder.TpId = UjTransportID; transportOrder.LC = lc; transportOrder.CommonTrHeader = ctrHeader; transportOrder.CommonDetail = cdetail; transportOrder.Type = type; transportOrder.TargetTag = iocp.TargetTag; transportOrder.SourceLocation = sourceLocation; transportOrder.TargetLocation = targetLocation; transportOrder.Weight = weight; transportOrder.Save(); // Hozzáadjuk a megfelelő iocp zsák queue-hoz this.opcClient.addJob(transportOrder); }
private void LogX_ItemNumUp_Execute(object sender, SimpleActionExecuteEventArgs e) { CommonTrDetail ctrd = (CommonTrDetail)e.CurrentObject; if (ctrd.ItemNum > 1) { CriteriaOperator cop = new GroupOperator(GroupOperatorType.And, new BinaryOperator("CommonTrHeader", ctrd.CommonTrHeader), new BinaryOperator("ItemNum", ctrd.ItemNum - 1)); CommonTrDetail ctrdDown = (CommonTrDetail)View.ObjectSpace.FindObject <CommonTrDetail>(cop); ctrd.ItemNum--; ctrdDown.ItemNum++; View.ObjectSpace.CommitChanges(); } }
private void LogX_ItemNumDown_Execute(object sender, SimpleActionExecuteEventArgs e) { CommonTrDetail ctrd = (CommonTrDetail)e.CurrentObject; CriteriaOperator copH = new BinaryOperator("Oid", ctrd.CommonTrHeader.Oid); CommonTrHeader ctrH = (CommonTrHeader)View.ObjectSpace.FindObject <CommonTrHeader>(copH); if (ctrd.ItemNum < ctrH.CommonTrDetails.Count()) { CriteriaOperator cop = new GroupOperator(GroupOperatorType.And, new BinaryOperator("CommonTrHeader", ctrd.CommonTrHeader), new BinaryOperator("ItemNum", ctrd.ItemNum + 1)); CommonTrDetail ctrdDown = (CommonTrDetail)View.ObjectSpace.FindObject <CommonTrDetail>(cop); ctrd.ItemNum++; ctrdDown.ItemNum--; View.ObjectSpace.CommitChanges(); } }
private void ResetCommonTrDetail() { double filterValue = 0; CriteriaOperator cTrD = new BinaryOperator("PerformedQty", filterValue, BinaryOperatorType.Greater); IList listCommonTrDetail = View.ObjectSpace.GetObjects(typeof(CommonTrDetail), cTrD, false); int counter = listCommonTrDetail.Count; for (int i = 0; i < counter; i++) { CommonTrDetail c = (CommonTrDetail)listCommonTrDetail[i]; c.PerformedQty = 0; c.CalcLcNumber = 0; } //View.ObjectSpace.CommitChanges(); }
public void BookingStorageHistory(int ctrDID) { lock (bookingLock) { DevExpress.Xpo.Session session = new Session(); CommonTrDetail commonTrDetail = session.FindObject <CommonTrDetail>(new BinaryOperator("Oid", ctrDID)); foreach (StockHistory sh in commonTrDetail.StockHistories) { if (!sh.Booked) { switch (sh.Type) { case 0: sh.Product.NormalQty = (sh.Direction == 1) ? sh.Product.NormalQty + sh.Quantity : sh.Product.NormalQty - sh.Quantity; sh.Booked = true; break; case 1: sh.Product.ReservedQty = (sh.Direction == 1) ? sh.Product.ReservedQty + sh.Quantity : sh.Product.ReservedQty - sh.Quantity; sh.Booked = true; break; case 2: sh.Product.BlockedQty = (sh.Direction == 1) ? sh.Product.BlockedQty + sh.Quantity : sh.Product.BlockedQty - sh.Quantity; sh.Booked = true; break; case 3: sh.Product.DispousedQty = (sh.Direction == 1) ? sh.Product.DispousedQty + sh.Quantity : sh.Product.DispousedQty - sh.Quantity; sh.Booked = true; break; default: break; } } } } }
// A készlet napló létrehozása még nem mozgratja a termék kélszletét, csak azt jelzi, hogy a ládába bekerült vagy kikerült a termék // A termék készlet könyvelése a transzport sor státuszváltozása alapján történik private void CreateStockHistory(int direction, int LoadCarrierId, int ProductId, int ctrDId, double quantity, string section, int type) { Session workSession = new Session(); //Láda LoadCarrier Lc = workSession.FindObject <LoadCarrier>(new BinaryOperator("Oid", LoadCarrierId)); //Termék Product product = workSession.FindObject <Product>(new BinaryOperator("Oid", ProductId)); //Tételsor CommonTrDetail ctrD = workSession.FindObject <CommonTrDetail>(new BinaryOperator("Oid", ctrDId)); StockHistory stockhistory = new StockHistory(workSession); stockhistory.Product = product; stockhistory.LC = Lc; stockhistory.Section = section; stockhistory.Quantity = quantity; stockhistory.CommonDetail = ctrD; stockhistory.Time = DateTime.Now; stockhistory.Type = type; stockhistory.Direction = direction; stockhistory.Processed = false; stockhistory.Booked = false; stockhistory.Save(); }