852存货核算生成凭证互斥
我们单位存货核算记账会计多人，用的是u852标准版，现在发现存货核算同时生成凭证互斥，以前851A打上SQL补丁就解决了，现在还有这个补丁吗？我们已经打上了852hotfix和852DBHOTFIX，请教大家了。看到用友下载中确实有该补丁，可惜不能下载，大家谁有啊？ 在存货核算的补丁中找到了，问题解决了。
--2005-3-8 add for 新增需求，要求能够并发制凭证。
--编写人：张巍
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[IA_PzMutex]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[IA_PzMutex]
GO
CREATE TABLE [dbo].[IA_PzMutex] (
[iMutexCode] [int] IDENTITY (1, 1) NOT NULL ,
[cComputerName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[cPersonName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[iMutexGroup] [int] NULL ,
[cMutexType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[cMutexValue] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[tMutexTime] [datetime] NULL ,
[bMutexResule] [int] NULL ,
[cStation] [nvarchar] (50) NULL,
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[IA_PzMutex] WITH NOCHECK ADD
CONSTRAINT [PK_IA_PzMutex] PRIMARY KEY CLUSTERED
(
[iMutexCode]
) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT cAuth_id FROM ufsystem..ua_auth WHERE cAuth_id=N'IA0399')
INSERT INTO ufsystem..UA_Auth (cAuth_id,cAuth_Name,cSub_id,iGrade,cSupAuth_id,bEndGrade,iOrder)
Values (N'IA0399',N'清除凭证互斥',N'IA',2,N'IA03',1,416 )
GO
if exists (select * from ufsystem..ua_control where cauth_id = N'IASCPZ' and crepellent = N'IASCPZ')
delete from ufsystem..ua_control where cauth_id = N'IASCPZ' and crepellent = N'IASCPZ'
GO 楼上的太强悍了！
页:
[1]