• 首页
• 业界动态
• 程序设计
• 数据库
• 电脑网络
• 网站建设
• 英语园地
• 生活点滴
• 给我留言

CREATE PROCEDURE sysEmpLogin
 2
 3   @loginid varchar(50),
 4
 5   @password varchar(50),
 6
 7   @empid int output,
 8
 9   @reason varchar(50) output
10
11 
12
13AS
14
15         select EmpID from mrBaseInf where  LoginID = @loginid
16
17         if (@@RowCount<1)
18
19            begin ----1
20
21               set  @reason ='noEmp'
22
23                set   @empid=0
24
25             end------1
26
27         else
28
29                begin  ----2       
30
31   
32
33           SELECT   EmpID 
34
35            FROM mrBaseInf
36
37                   WHERE (LoginID = @loginid) AND (Password = @password )
38
39                     if (@@RowCount<1)
40
41                        begin -----3
42
43                         set  @reason ='pError'
44
45                          set   @empid=0
46
47                         end-------3
48
49                    else
50
51                                  begin  ------4
52
53                                  SELECT   @empid=EmpID 
54
55                     FROM mrBaseInf
56
57                    WHERE (LoginID = @loginid) AND (Password = @password and AllowLogin=1)
58
59                                        if (@@RowCount<1)
60
61                                    begin ---------6
62
63                                        set  @reason ='unAllow'
64
65                                      set   @empid=0
66
67                                     end------------6
68
69                                  else
70
71                                         begin -----7
72
73                                         set  @reason ='access'
74
75                                         end  ----------7
76
77                                  end -----4       
78
79                end------2
80
81       RETURN
82
83
84
85 GO