1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Web;
 5using System.Web.Security;
 6using System.Web.UI;
 7using System.Web.UI.WebControls;
 8using System.Web.UI.WebControls.WebParts;
 9using System.Web.UI.HtmlControls;
10using Web2ASPNET2.OperateSqlServer;
11using System.Data.SqlClient;
12
13namespace Web2ASPNET2.WebTags
14...{
15    public class Role
16    ...{
17        public Role()
18        ...{
19            /**////
20        }
21
22        public SqlDataReader GetRoles(int projectID)
23        ...{
24            /**////定义保存数据的SqlDataReader对象
25            SqlDataReader dr = null;
26            /**////添加存储过程参数
27            SqlParameter[] parameters = ...{
28                OperateDatabase.CreateInParam("@ProjectID",SqlDbType.Int,4,projectID)
29            };
30            /**////执行存储过程
31            OperateDatabase.RunProc("Pr_GetRoles",out dr,parameters);
32            /**////返回结果
33            return dr;
34        }
35
36        public SqlDataReader GetSingleRole(int roleID)
37        ...{
38            return DataCommon.GetDataByReaderIDParam("Pr_GetSingleRole",roleID);
39        }
40
41        public int AddRole(string roleName,int projectID)
42        ...{
43            SqlParameter[] parameters = ...{
44                OperateDatabase.CreateInParam("@RoleName",SqlDbType.VarChar,50,roleName),
45                OperateDatabase.CreateInParam("@ProjectID",SqlDbType.Int,4,projectID)
46            };
47            return (OperateDatabase.RunProc("Pr_AddRole",parameters));
48        }
49
50        public int UpdateRole(int roleID,string roleName)
51        ...{
52            SqlParameter[] parameters = ...{
53                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,roleID),
54                OperateDatabase.CreateInParam("@RoleName",SqlDbType.VarChar,50,roleName)            
55            };
56            return (OperateDatabase.RunProc("Pr_UpdateRole",parameters));
57        }
58
59        public int DeleteRole(int roleID)
60        ...{
61            return DataCommon.QueryDataIDParam("Pr_DeleteRole",roleID);
62        }
63    }
64}
65