T+13.0进货单上面的选单按钮被客户误删了

进货单上面的选单按钮被客户误删了，可以弄回来吗。

问题回复：

备份账套，执行一下脚本： 

SET IDENTITY_INSERT EAP_BusOperation ON SELECT * INTO EAP_BusOperation_bak_20201013 FROM dbo.EAP_BusOperation INSERT INTO dbo.EAP_BusOperation ( OperationName, FunctionCode, Description, Code, ViewType, TabIndex, IsSplit, SourceKey, IsAuthControl, Title, Visibility, ShortCut, ToolTip, issystem, IsHasAction, IsEnd, ExpressionName, CreatedTime, id, ParentID, idbusoperationmain, idfunctionauth, viewid, Position, Icon, Args, CanSetDefault ) SELECT OperationName, FunctionCode, Description, Code, ViewType, 2, IsSplit, SourceKey, IsAuthControl, Title, Visibility, ShortCut, ToolTip, issystem, IsHasAction, IsEnd, ExpressionName, CreatedTime, id, ParentID, idbusoperationmain, idfunctionauth , viewid, Position, Icon, Args, CanSetDefault FROM dbo.EAP_BusOperation_bak WHERE id = 5702 SET IDENTITY_INSERT EAP_BusOperation OFF；

执行后，在执行下边的脚本： 

SELECT * INTO EAP_BusOperation_User_20201015 FROM EAP_BusOperation_User DELETE EAP_BusOperation_User WHERE [UserID] IN (SELECT DISTINCT UserID FROM EAP_BusOperation_User Where [Code]= N'PU03')