/// <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);
}
