/EQT_V1/EQT.DAL/DaRoleFunction.cs

 1/*
 2 * ???????????
 3 * 
 4 * 2009-5-31 SZJ
 5 * 
 6 * 
 7 * */
 8
 9using System;
10using System.Collections;
11using System.Collections.Generic;
12using System.Data;
13using System.Globalization;
14using System.Text;
15using System.Xml;
16using System.Data.Common;
17using Microsoft.Practices.EnterpriseLibrary.Data;
18using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
19//using Microsoft.Practices.EnterpriseLibrary.Logging;
20using EQT.Model;
21//using IDataLayer;
22
23namespace EQT.Dal
24{
25    public partial class DaRoleFunction
26    {
27        internal const string SQL_CLEAR_ROLE_FUNC = "DELETE FROM ROLE_FUNCTIONS WHERE ROLE_ID=@ROLE_ID";
28
29        /// <summary>
30        /// ??????????? 
31        /// </summary>
32        /// <param name="role_id"></param>
33        /// <returns></returns>
34        public int ClearRoleFuncs(string role_id)
35        {
36            DbCommand cmd_clear_role_funcs = db.GetSqlStringCommand(SQL_CLEAR_ROLE_FUNC);
37            db.AddInParameter(cmd_clear_role_funcs, "ROLE_ID", DbType.String, role_id);
38            return db.ExecuteNonQuery(cmd_clear_role_funcs);
39        }
40
41
42        /// <summary>
43        /// ??????????.
44        /// </summary>
45        /// <param name="role_id"></param>
46        /// <param name="funcIdArray"></param>
47        /// <returns></returns>
48        public int SetRoleFuncs(string role_id, string[] funcIdArray)
49        {
50            int rc = 0;
51            DbCommand cmd_clear_role_funcs = db.GetSqlStringCommand(SQL_CLEAR_ROLE_FUNC);
52            db.AddInParameter(cmd_clear_role_funcs, "ROLE_ID", DbType.String, role_id);
53
54            using (DbConnection conn = db.CreateConnection())
55            {
56                conn.Open();
57                using (DbTransaction trans = conn.BeginTransaction())
58                {
59                    //?????????
60                    db.ExecuteNonQuery(cmd_clear_role_funcs, trans);
61
62                    //????????
63                    MoRoleFunction mo = new MoRoleFunction();
64                    mo.Role_Id = role_id;
65                    foreach (string funcId in funcIdArray)
66                    {
67                        mo.Func_Id = funcId;
68                        rc+= Add(mo, trans);
69                    }
70
71                    trans.Commit();
72                }
73                conn.Close();
74
75            }
76            return rc;
77        }
78    }
79}