From feb3010f6994f89c46175059731ab34b00ff66f3 Mon Sep 17 00:00:00 2001
From: 陈炜 <5856420@qq.com>
Date: 星期三, 23 九月 2020 16:47:26 +0800
Subject: [PATCH] 新增删除2020之前报表数据

---
 删除数据4.sql |    3 +++
 1 files changed, 3 insertions(+), 0 deletions(-)

diff --git "a/\345\210\240\351\231\244\346\225\260\346\215\2564.sql" "b/\345\210\240\351\231\244\346\225\260\346\215\2564.sql"
index 88d7dc9..2c89d77 100644
--- "a/\345\210\240\351\231\244\346\225\260\346\215\2564.sql"
+++ "b/\345\210\240\351\231\244\346\225\260\346\215\2564.sql"
@@ -62,6 +62,9 @@
 truncate table cbBalance
 truncate table cbCalInfo
 
+--报表
+delete FROM dbo.t_Rpt_Content  WHERE FRptType =1 AND FRptName NOT LIKE '%2020%'
+
 --设置 启用期间，当前期间,这里几月份开始用就设置为几月份
 update t_SystemProfile set FValue=9 where FCategory='gl' and FKey='startperiod'
 update t_SystemProfile set FValue=2020 where FCategory='gl' and FKey='startyear'

--
Gitblit v1.10.0