/// <summary> /// 通过ID查找用户权限表项目 /// </summary> /// <param name="ID">需要查找的ID</param> /// <returns>返回项目对象,如果ID为-1则为查找失败</returns> public static AuthPrivilege FindCustDegreeByID(int ID) { AuthPrivilege node = new AuthPrivilege(); node.AuthID = -1; string str = "select AuthID,AuthName,AuthDegree,AddNewRoom,ReadRoom,ChangeRoom,DeleteRoom,ReadRoomStatus,ChangeRoomStatus,ReadCheckLog,ChangeCheckLog,DeleteCheckLog,ReadCust,AddNewCust,ChangeCust,DeleteCust,ReadOperLog,DeleteOperLog,AddOperator,ChangeOperator,DeleteOperator,AddNewPrivilege,ChangePrivilege,DeletePrivilege from AuthPrivilege where AuthID = @index"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@index", SqlDbType.Int) }; para[0].Value = ID; SqlDataReader reader = SqlHelper.ExecuteReader(str, para); while (reader.Read()) { #region 节点赋值 node.AuthID = Convert.ToInt32(reader[0]); node.AuthName = reader[1].ToString(); node.AuthDegree = Convert.ToInt32(reader[2]); node.AddNewRoom = Convert.ToInt32(reader[3]); node.ReadRoom = Convert.ToInt32(reader[4]); node.ChangeRoom = Convert.ToInt32(reader[5]); node.DeleteRoom = Convert.ToInt32(reader[6]); node.ReadRoomStatus = Convert.ToInt32(reader[7]); node.ChangeRoomStatus = Convert.ToInt32(reader[8]); node.ReadCheckLog = Convert.ToInt32(reader[9]); node.ChangeCheckLog = Convert.ToInt32(reader[10]); node.DeleteCheckLog = Convert.ToInt32(reader[11]); node.ReadCust = Convert.ToInt32(reader[12]); node.AddNewCust = Convert.ToInt32(reader[13]); node.ChangeCust = Convert.ToInt32(reader[14]); node.DeleteCust = Convert.ToInt32(reader[15]); node.ReadOperLog = Convert.ToInt32(reader[16]); node.DeleteOperLog = Convert.ToInt32(reader[17]); node.AddOperator = Convert.ToInt32(reader[18]); node.ChangeOperator = Convert.ToInt32(reader[19]); node.DeleteOperator = Convert.ToInt32(reader[20]); node.AddNewPrivilege = Convert.ToInt32(reader[21]); node.ChangePrivilege = Convert.ToInt32(reader[22]); node.DeletePrivilege = Convert.ToInt32(reader[23]); #endregion } reader.Close(); return(node); }
/// <summary> /// 获取所有权限信息对象 /// </summary> /// <returns></returns> public static List <AuthPrivilege> GetAllPrivilegeType() { List <AuthPrivilege> list = new List <AuthPrivilege>(); string sqlstr = "select AuthID,AuthName,AuthDegree,AddNewRoom,ReadRoom,ChangeRoom,DeleteRoom,ReadRoomStatus,ChangeRoomStatus,ReadCheckLog,ChangeCheckLog,DeleteCheckLog,ReadCust,AddNewCust,ChangeCust,DeleteCust,ReadOperLog,DeleteOperLog,AddOperator,ChangeOperator,DeleteOperator,AddNewPrivilege,ChangePrivilege,DeletePrivilege from AuthPrivilege"; SqlDataReader reader = SqlHelper.ExecuteReader(sqlstr); while (reader.Read()) { AuthPrivilege node = new AuthPrivilege(); #region 节点赋值 node.AuthID = Convert.ToInt32(reader[0]); node.AuthName = reader[1].ToString(); node.AuthDegree = Convert.ToInt32(reader[2]); node.AddNewRoom = Convert.ToInt32(reader[3]); node.ReadRoom = Convert.ToInt32(reader[4]); node.ChangeRoom = Convert.ToInt32(reader[5]); node.DeleteRoom = Convert.ToInt32(reader[6]); node.ReadRoomStatus = Convert.ToInt32(reader[7]); node.ChangeRoomStatus = Convert.ToInt32(reader[8]); node.ReadCheckLog = Convert.ToInt32(reader[9]); node.ChangeCheckLog = Convert.ToInt32(reader[10]); node.DeleteCheckLog = Convert.ToInt32(reader[11]); node.ReadCust = Convert.ToInt32(reader[12]); node.AddNewCust = Convert.ToInt32(reader[13]); node.ChangeCust = Convert.ToInt32(reader[14]); node.DeleteCust = Convert.ToInt32(reader[15]); node.ReadOperLog = Convert.ToInt32(reader[16]); node.DeleteOperLog = Convert.ToInt32(reader[17]); node.AddOperator = Convert.ToInt32(reader[18]); node.ChangeOperator = Convert.ToInt32(reader[19]); node.DeleteOperator = Convert.ToInt32(reader[20]); node.AddNewPrivilege = Convert.ToInt32(reader[21]); node.ChangePrivilege = Convert.ToInt32(reader[22]); node.DeletePrivilege = Convert.ToInt32(reader[23]); #endregion list.Add(node); } reader.Close(); return(list); }
/// <summary> /// 通过关键词查找权限信息对象,支持模糊搜索 /// </summary> /// <param name="keyword">需要查找的关键词</param> /// <param name="FuzzyMode">模糊搜索模式,true为开启,false为关闭</param> /// <returns></returns> public static List <AuthPrivilege> FindAuthPrivilegeByKeyword(string keyword, bool FuzzyMode) { List <AuthPrivilege> list = new List <AuthPrivilege>(); string FindStr = ""; if (FuzzyMode == true) { FindStr = " like "; } else { FindStr = " = "; } string sqlstr = "select AuthID,AuthName,AuthDegree,AddNewRoom,ReadRoom,ChangeRoom,DeleteRoom,ReadRoomStatus,ChangeRoomStatus,ReadCheckLog,ChangeCheckLog,DeleteCheckLog,ReadCust,AddNewCust,ChangeCust,DeleteCust,ReadOperLog,DeleteOperLog,AddOperator,ChangeOperator,DeleteOperator,AddNewPrivilege,ChangePrivilege,DeletePrivilege from AuthPrivilege where AuthName" + FindStr + "@searchname"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@searchname", SqlDbType.VarChar) }; if (FuzzyMode == true) { para[0].Value = "%" + keyword + "%"; } else { para[0].Value = keyword; } SqlDataReader reader = SqlHelper.ExecuteReader(sqlstr, para); while (reader.Read()) { AuthPrivilege node = new AuthPrivilege(); #region 节点赋值 node.AuthID = Convert.ToInt32(reader[0]); node.AuthName = reader[1].ToString(); node.AuthDegree = Convert.ToInt32(reader[2]); node.AddNewRoom = Convert.ToInt32(reader[3]); node.ReadRoom = Convert.ToInt32(reader[4]); node.ChangeRoom = Convert.ToInt32(reader[5]); node.DeleteRoom = Convert.ToInt32(reader[6]); node.ReadRoomStatus = Convert.ToInt32(reader[7]); node.ChangeRoomStatus = Convert.ToInt32(reader[8]); node.ReadCheckLog = Convert.ToInt32(reader[9]); node.ChangeCheckLog = Convert.ToInt32(reader[10]); node.DeleteCheckLog = Convert.ToInt32(reader[11]); node.ReadCust = Convert.ToInt32(reader[12]); node.AddNewCust = Convert.ToInt32(reader[13]); node.ChangeCust = Convert.ToInt32(reader[14]); node.DeleteCust = Convert.ToInt32(reader[15]); node.ReadOperLog = Convert.ToInt32(reader[16]); node.DeleteOperLog = Convert.ToInt32(reader[17]); node.AddOperator = Convert.ToInt32(reader[18]); node.ChangeOperator = Convert.ToInt32(reader[19]); node.DeleteOperator = Convert.ToInt32(reader[20]); node.AddNewPrivilege = Convert.ToInt32(reader[21]); node.ChangePrivilege = Convert.ToInt32(reader[22]); node.DeletePrivilege = Convert.ToInt32(reader[23]); #endregion list.Add(node); } reader.Close(); return(list); }