费控测试数据删除方法

 

DECLARE @temtb TABLE (appt_id VARCHAR(400))
INSERT INTO @temtb (appt_id) VALUES ('32025156c12146a8adffedf1d031fe3b')
INSERT INTO @temtb (appt_id) VALUES ('3cc2618a72184b0ebc8bfd63d0c0b519')
INSERT INTO @temtb (appt_id) VALUES ('7f89833c252d419eb1890bf2728f006d')
INSERT INTO @temtb (appt_id) VALUES ('7fca7c3164f64ef49e3e18e7429ce00e')
INSERT INTO @temtb (appt_id) VALUES ('8ba3f9b9995e4f02a5bb379a558fc4fd')
INSERT INTO @temtb (appt_id) VALUES ('a133b6f66c8a48cc98e5c80e38f5a81e')
INSERT INTO @temtb (appt_id) VALUES ('bf923fdef58547f9a86c375d83d08c4c')
INSERT INTO @temtb (appt_id) VALUES ('d64167c8987146439d78a4ea13896d56')
INSERT INTO @temtb (appt_id) VALUES ('fede171d749b413fb3163ccd598524e2')

--删除流程数据
update  jhoa_approve  set del_flag=1 where appt_id in (SELECT appt_id FROM @temtb)

--删除流程实例
update  dbo.JHOA_Approve_Instance set status='deleted' WHERE Template_ID IN (SELECT appt_id FROM @temtb)

--删除业务数据
TRUNCATE TABLE [dbo].[Form_YS_MonthPool]            --月度预算
TRUNCATE TABLE [dbo].[Form_YS_SeasonPool]           --季度预算
TRUNCATE TABLE [dbo].[Form_YS_YearPool]             --年度预算
TRUNCATE TABLE [dbo].[Form_YS_PeriodBalance]        --期间结转
TRUNCATE TABLE [dbo].[Form_YS_RepaymentReg]         --还款登记
TRUNCATE TABLE [dbo].[Form_YS_BudgetAdjust]         --预算调整主表
TRUNCATE TABLE [dbo].[Form_YS_BudgetAdjustIn]       --预算调整从表
TRUNCATE TABLE [dbo].[Form_YS_BudgetAdjustOut]      --预算调整从表
TRUNCATE TABLE [dbo].[Form_YS_BudgetApply]          --预算追加主表
TRUNCATE TABLE [dbo].[Form_YS_BudgetApplySub]       --预算追加从表
TRUNCATE TABLE [dbo].[Form_YS_EvectionApply]        --差旅费申请主表
TRUNCATE TABLE [dbo].[Form_YS_EvectionApplySub]     --差旅费申请从表
TRUNCATE TABLE [dbo].[Form_YS_EvectionApplyTemp]    --差旅费申请主表(临时)
TRUNCATE TABLE [dbo].[Form_YS_EvectionApplySubTemp] --差旅费申请从表(临时)
TRUNCATE TABLE [dbo].[Form_YS_ExpenseApportion]     --费用分摊主表
TRUNCATE TABLE [dbo].[Form_YS_ExpenseApportionInfo] --费用分摊从表
TRUNCATE TABLE [dbo].[Form_YS_ExpAndAppRelation]    --申请单与报销单关联表
TRUNCATE TABLE [dbo].[Form_YS_PayApply]             --合同付款主表
TRUNCATE TABLE [dbo].[Form_YS_PayApplySub]          --合同付款从表
TRUNCATE TABLE [dbo].[Form_YS_PaymentApply]         --费用申请主表
TRUNCATE TABLE [dbo].[Form_YS_PaymentApplySub]      --费用申请从表
TRUNCATE TABLE [dbo].[Form_YS_PaymentApplyTemp]     --费用申请主表(临时)
TRUNCATE TABLE [dbo].[Form_YS_PaymentApplySubTemp]  --费用申请从表(临时)
TRUNCATE TABLE [dbo].[Form_YS_PaymentExpense]       --费用报销主表
TRUNCATE TABLE [dbo].[Form_YS_PaymentExpenseSub]    --费用报销从表
TRUNCATE TABLE [dbo].[Form_YS_ServicePay]           --行政付款主表
TRUNCATE TABLE [dbo].[Form_YS_ServicePaySub]        --行政付款从表
TRUNCATE TABLE [dbo].[Form_YS_TravelExpense]        --差旅费报销主表
TRUNCATE TABLE [dbo].[Form_YS_TravelExpenseSub]     --差旅费报销从表