...
Code Block | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
--حذف موجودی قفسه ها delete from WM.ShelfStock delete from WM.ShelfHistory exec wm.PrepareShelfStock --برای بازسازی موجودی قفسه --حذف قبض ها و جداول وابسته delete from wm.DeliveryDetails delete from WM.InventoryFirstStockDetails delete from WM.InventoryFirstStock delete from Sale.OnLineSaleDetails delete from Sale.OnLineSale delete from WM.AdjustInventoryDetails delete from WM.AdjustInventory delete from WM.ASNDetails delete from WM.ASNPDATemp delete from WM.ASN delete from WM.StockDraftDetails delete from WM.StockDraftRecPDATemp delete from WM.StockDraft delete from wm.MojodiReview delete from wm.MojodiReviewIdentification delete from wm.MojodiReviewPDATemp delete from wm.MojodiReviewSetting delete from wm.MojodiReviewShelfs delete from wm.MojodiReviewInfo --ریست اطلاعات سبدها UPDATE WM.Basket SET IssueOrder_ID =NULL,UpdateUserID=NULL,updatedate=GETDATE(),inuse=0,StateID=3,PositionID=3,ProcessID=NULL --حذف درخواست خروج ها و جداول وابسته delete from wm.IssueOrderDetails delete from WM.BasketDiff delete from wm.BasketLog delete from wm.BasketControlItemPDATemp delete from wm.BasketControlItem --delete from WM.Basket ** DELETE FROM WM.IssueOrder_Notes DELETE FROM WM.IssueOrderDocs delete from wm.IssueOrder delete from wm.Delivery exec wm.PrepareStock --برای بازسازی موجودی --حذف قفسه ها --delete from wm.shelf --delete from wm.PurchaseInvoiceDetails --delete from wm.PurchaseInvoice -- در صورت فرایندی بودن جداول فوق ، از پروسس ها هم حذف میکند delete from task.processes where ProcessID in( select a.ProcessID from task.processes A inner join WorkFlow.ProcessDefinition B on a.ProcessDefID=b.ProcessDefID where b.TableID in (select TableID from generator.ModuleTables where TableName in ( 'AdjustInventoryDetails' ,'AdjustInventory' ,'ASNDetails' ,'ASNPDATemp' ,'ASN' ,'StockDraftDetails' ,'StockDraftRecPDATemp' ,'StockDraft' ,'Delivery' ,'IssueOrderDetails' ,'BasketDiff' ,'BasketLog' ,'BasketControlItemPDATemp' ,'BasketControlItem' ,'Basket' ,'IssueOrder' --,'PurchaseInvoiceDetails' --,'PurchaseInvoice' ,'ShelfHistory' ,'ShelfStock' ,'DeliveryDetails' ,'InventoryFirstStockDetails' ,'InventoryFirstStock' ,'OnLineSaleDetails' ,'OnLineSale' ,'MojodiReview' ,'MojodiReviewIdentification' ,'MojodiReviewPDATemp' ,'MojodiReviewSetting' ))) |
...