1using System;
  2using System.Data;
  3using System.Collections;
  4using System.Data.SqlClient;
  5
  6using OnLineExam.DataAccessLayer;
  7using OnLineExam.DataAccessHelper;
  8
  9namespace OnLineExam.BusinessLogicLayer
 10...{    
 11    public class Department
 12    ...{
 13        私有成员#region 私有成员
 14
 15        private int _departmentId;            //部门ID
 16        private string _departmentName;        //部门名       
 17
 18        #endregion 私有成员
 19
 20        属性#region 属性
 21
 22        public int DepartmentId
 23        ...{
 24            set
 25            ...{
 26                this._departmentId = value;
 27            }
 28            get
 29            ...{
 30                return this._departmentId;
 31            }
 32        }
 33        public string DepartmentName
 34        ...{
 35            set
 36            ...{
 37                this._departmentName = value;
 38            }
 39            get
 40            ...{
 41                return this._departmentName;
 42            }
 43        }
 44   
 45        #endregion 属性
 46
 47        方法#region 方法
 48
 49        /**//// <summary>
 50        /// 根据参数departmentId，获取部门详细信息
 51        /// </summary>
 52        /// <param name="topicID">部门ID</param>
 53        public bool LoadData(int DepartmentId)
 54        ...{
 55            SqlParameter[] Params = new SqlParameter[1];
 56            DataBase DB = new DataBase();
 57
 58            Params[0] = DB.MakeInParam("@DepartmentId", SqlDbType.Int, 4, DepartmentId);                  //用户编号            
 59
 60            DataSet ds = DB.GetDataSet("Proc_DepartmentDetail", Params);
 61            ds.CaseSensitive = false;
 62            DataRow DR;
 63            if (ds.Tables[0].Rows.Count > 0)
 64            ...{
 65                DR = ds.Tables[0].Rows[0];
 66                this._departmentId = GetSafeData.ValidateDataRow_N(DR, "DepartmentId");
 67                this._departmentName = GetSafeData.ValidateDataRow_S(DR, "DepartmentName");
 68
 69                return true;
 70            }
 71            else
 72            ...{
 73                return false;
 74            }
 75        }
 76        public bool CheckDepartment(int XDepartmentId)
 77        ...{
 78            SqlParameter[] Params = new SqlParameter[1];
 79            DataBase DB = new DataBase();
 80
 81            Params[0] = DB.MakeInParam("@DepartmentId", SqlDbType.Int, 4, XDepartmentId);                
 82
 83            SqlDataReader DR = DB.RunProcGetReader("Proc_DepartmentDetail", Params);
 84            if (!DR.Read())
 85            ...{
 86                return false;
 87            }
 88            else
 89            ...{
 90                return true;
 91            }
 92        }
 93        public bool InsertByProc()
 94        ...{
 95            SqlParameter[] Params = new SqlParameter[2];
 96
 97            DataBase DB = new DataBase();
 98
 99            Params[0] = DB.MakeInParam("@DepartmentId", SqlDbType.Int, 4, DepartmentId);             
100            Params[1] = DB.MakeInParam("@DepartmentName", SqlDbType.VarChar, 50, DepartmentName);         
101           
102
103            int Count = -1;
104            Count = DB.RunProc("Proc_DepartmentAdd", Params);
105            if (Count > 0)
106                return true;
107            else return false;
108        }
109        public bool UpdateByProc(string DepartmentId)
110        ...{
111            SqlParameter[] Params = new SqlParameter[2];
112
113            DataBase DB = new DataBase();
114
115            Params[0] = DB.MakeInParam("@DepartmentId", SqlDbType.Int, 4, DepartmentId);
116            Params[1] = DB.MakeInParam("@DepartmentName", SqlDbType.VarChar, 50, DepartmentName);            
117           
118
119            int Count = -1;
120            Count = DB.RunProc("Proc_DepartmentModify", Params);
121            if (Count > 0)
122                return true;
123            else return false;
124        }
125        public bool DeleteByProc(string DepartmentId)
126        ...{
127            SqlParameter[] Params = new SqlParameter[1];
128
129            DataBase DB = new DataBase();
130
131            Params[0] = DB.MakeInParam("@DepartmentId", SqlDbType.Int, 4, DepartmentId);               //用户编号          
132
133            int Count = -1;
134            Count = DB.RunProc("Proc_DepartmentDelete", Params);
135            if (Count > 0)
136                return true;
137            else return false;
138        }
139        public DataSet QueryDepartment()
140        ...{
141            DataBase DB = new DataBase();
142            return DB.GetDataSet("Proc_DepartmentList");
143        }
144       
145        public static DataTable Query(Hashtable queryItems)
146        ...{
147            string where = SQLString.GetConditionClause(queryItems);
148            string sql = "Select * From [Department]" + where;
149            DataBase db = new DataBase();
150            return db.GetDataTable(sql);
151        }
152       
153        #endregion 方法
154    }
155}
156