--ÏúÊÛºÏÍ¬
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
--ÊÕ¿îµ¥£¬ÓëÓ¦ÊÕÏµÍ³Ïà¹Ø£¬ÐèÈ·ÈÏºóÔÙÉ¾³ý£¬É¾³ýºóÐèÒªÉ¾³ýÓà¶î£¬½¨ÒéÓ¦ÊÕÓ¦¸¶Ò»Æð´¦Àí
--ÐèÈ«²¿É¾³ýºó£¬Ðè¸üÐÂÆôÓÃÆÚ¼äºóÕËÌ×²ÅÄÜ¿ªÊ¼Ê¹ÓÃ