حذف کل موجودی و جداول وابسته

--حذف موجودی قفسه ها
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'
)))