文件名称：K3启用门店管理后，回恢复主控台的方法(SQL 2005)
文件大小：2KB
文件格式：SQL
更新时间：2014-09-14 05:22:56
SQL 2005
select * from t_systemprofile where fkey='retailinuse' select * from t_DataFlowTopClass where FTopClassID NOT IN (20, 60) select * from t_UserTopClass WHERE FTopClassID NOT IN (20, 60) update t_systemprofile set fvalue=0 where fkey='retailinuse' UPDATE t_DataFlowTopClass SET FVisible = 1 WHERE FTopClassID NOT IN (20, 60) UPDATE t_UserTopClass SET FVisible = 1 WHERE FTopClassID NOT IN (20, 60) --更新主控台中二级子目录的显示,只显示"供应链"下面的"门店管理"和"基础资料"下的全部内容 UPDATE t_DataFlowSubSystem SET FVisible = 1, FRefresh = 1 - 1 WHERE NOT ((FTopClassID = 20 AND FSubSysID = 7000) OR (FTopClassID = 60 AND FSubSysID <> -1)) UPDATE t_UserSubSystem SET FVisible = 1 WHERE NOT ((FTopClassID = 20 AND FSubSysID = 7000) OR (FTopClassID = 60 AND FSubSysID <> -1)) --更新主控台中三级子目录的显示，把"基础资料"下的"公共资料"设置为自动刷新 UPDATE t_DataFlowSubFunc SET FRefresh = 1 WHERE FSubFuncID = 600201 --更新主控台中三级子目录的显示，启用门店后显示"门店管理"下所有三级子功能,以及基础资料下门店管理,公共资料,初始化下门店系统，系统设置下门店系统，用户管理下用户管理，日志信息下上机日志 UPDATE t_DataFlowSubFunc SET FVisible = 1, FRefresh = 1 - 1 WHERE NOT ((FSubFuncID BETWEEN 700001 AND 700020) OR FSubFuncID IN (600801, 601501, 600201)) UPDATE t_UserSubFunc SET FVisible = 1 WHERE NOT ((FSubFuncID BETWEEN 700001 AND 700020) OR FSubFuncID IN (600801, 601501, 600201)) --更新主控台中四级子目录的显示，显示供应链下门店下全部，基础资料下公共资料和门店管理，初始化下门店系统，系统设置下门店系统，用户管理下用户管理，日志信息下上机日志 UPDATE t_DataFlowDetailFunc SET FEnable = 1, FVisible = 1 WHERE NOT ((FSubFuncID BETWEEN 700001 AND 700020) OR FSubFuncID IN (600801, 601501)) OR (FSubFuncID=600201 AND (FDetailFuncID NOT IN (60020199, 60020115, 60020108, 60020109, 60020110, 60020111, 60020112, 60020113))) UPDATE t_Userdetailfunc SET FEnable = 1, FVisible = 1 WHERE NOT ((FSubFuncID BETWEEN 700001 AND 700020) OR FSubFuncID IN (600801, 601501)) OR (FSubFuncID = 600201 AND (FDetailFuncID NOT IN (60020199, 60020115, 60020108, 60020109, 60020110, 60020111, 60020112, 60020113))) UPDATE t_DataFlowTimeStamp SET FName = FName