--ÏúÊÛºÏͬ
|
truncate table t_RPContract
|
truncate table t_RPContractDetail
|
truncate table t_rpContractEntry
|
-- ¶©µ¥
|
truncate table dbo.SEOrder
|
truncate table dbo.SEOrderEntry
|
--·¢»õ֪ͨ,ÍË»õ֪ͨ
|
truncate table dbo.SEOutStock
|
truncate table dbo.SEOutStockEntry
|
--ÏúÊÛ·¢Æ±
|
truncate table dbo.ICSale
|
truncate table dbo.ICSaleEntry
|
DELETE FROM dbo.t_RP_Contact WHERE FType =3
|
--ÏúÊÛ³ö¿â£¬¿â´æÀàµÄµ¥¾Ý¶¼ÔÚÒ»ÕÅ±í£¬É¾³ýËùÓпâ´æµ¥¾Ýºó£¬ÐèҪɾ³ý´æ»õºËËãÓà¶î±íºÍ¼´Ê±¿â´æ±í
|
ALTER TABLE ICStockBill DISABLE TRIGGER ALL
|
DELETE FROM dbo.ICStockBill WHERE FTranType IN (21)
|
DELETE FROM dbo.ICStockBillEntry WHERE FInterID NOT IN (SELECT FInterID FROM dbo.ICStockBill)
|
ALTER TABLE ICStockBill ENABLE TRIGGER ALL
|
--ÊÕ¿îµ¥£¬ÓëÓ¦ÊÕϵͳÏà¹Ø£¬ÐèÈ·ÈϺóÔÙɾ³ý£¬É¾³ýºóÐèҪɾ³ýÓà¶î£¬½¨ÒéÓ¦ÊÕÓ¦¸¶Ò»Æð´¦Àí
|
--ÐèÈ«²¿É¾³ýºó£¬Ðè¸üÐÂÆôÓÃÆÚ¼äºóÕËÌײÅÄÜ¿ªÊ¼Ê¹ÓÃ
|
