天思ERP用户数自动调配方法

oaerp

针对那些买了天思ERP企业并发用户数不够的，天思本来就没有自动分配给企业内各部门用户数限制，导致各部门抢占有限的用户数，出现有些部门没有名额进入ERP工作，针对这些情况，本人特写了一个触发器，很好解决上面的问题！
主要功能：如分配制造部门5个用户名额，那么只要制造部第6个用户进入系统会被自动踢出。

在NetUser 用户表上创建触发器，代码很简单如下：

CREATE TRIGGER [TRIGGER user] ON [dbo].[Netuser]
FOR INSERT
AS
declare @UserNo nvarchar(50)
declare @dep nvarchar(50)
declare @count int
select @UserNo=UserNo from inserted
select @dep=dep  from PSWD,netuser where PSWD.USR = Netuser.UserNo and  Netuser.UserNo=@UserNo
SELECT  @count=COUNT(PSWD.DEP)
FROM PSWD INNER JOIN
      Netuser ON PSWD.USR = Netuser.UserNo AND PSWD.DEP =@dep
GROUP  BY DEP
if @dep='0000' and  @count>1
begin
delete from netuser where UserNo=@UserNo
end
if (@dep='0001'  or @dep='0003' or @dep='0004' or @dep='0010' or @dep='0011' or @dep='0020') and  @count>1
begin
delete from netuser where UserNo=@UserNo
end
if @dep='0002' and @count>3
begin
delete from netuser where UserNo=@UserNo
end
if @dep='0006' and @count>2
begin
delete from netuser where UserNo=@UserNo
end
if @dep='0014' and @count>2
begin
delete from netuser where UserNo=@UserNo
end
if @dep='0005' and @count>5
begin
delete from netuser where UserNo=@UserNo
end
if @dep='0008' and @count>1
begin
delete from netuser where UserNo=@UserNo
end
if @dep='0007' and @count>5
begin
delete from netuser where UserNo=@UserNo
end
if @dep='0009' and @count>5
begin
delete from netuser where UserNo=@UserNo
end
if @dep='0016' and @count>1
begin
delete from netuser where UserNo=@UserNo
end
if @dep='0017' and @count>1
begin
delete from netuser where UserNo=@UserNo
end
if @dep='0018' and @count>1
begin
delete from netuser where UserNo=@UserNo
end
if @dep='0021' and @count>1
begin
delete from netuser where UserNo=@UserNo
end
if @dep='0023' and @count>1
begin
delete from netuser where UserNo=@UserNo
end
if (@dep='0025' or @dep='0026') and @count>1
begin
delete from netuser where UserNo=@UserNo
end
if @dep='0015' and @count>1
begin
delete from netuser where UserNo=@UserNo
end

针对上面各部门用户数分配控制，本人写了一个小程序，在这里就不放出来，有需要可联系我：QQ：40789227