/// <summary>
/// 根据查询条件哈希表,查询数据
/// </summary>
/// <param name="queryItems">查询条件哈希表</param>
/// <returns>查询结果数据DataTable</returns>
public static DataTable Query(Hashtable queryItems)
{
string where = SQLString.GetConditionClause(queryItems);
string sql = "Select top 2 * From [Role] order by RoleId" + where;
DataBase db = new DataBase();
return(db.GetDataTable(sql));
}
/// <summary>
/// 根据查询条件哈希表,查询数据
/// </summary>
/// <param name="queryItems">查询条件哈希表</param>
/// <returns>查询结果数据DataTable</returns>
public static DataTable Query(Hashtable queryItems)
{
string where = SQLString.GetConditionClause(queryItems);
string sql = "Select * From [Role] where RoleId!=1 and RoleId!=5 order by RoleId" + where;//删除了top 2限制和处理了不让admin显示，防止用户不小心更改admin权限导致进不了后台
DataBase db = new DataBase();
return(db.GetDataTable(sql));
}
public static DataTable Query(Hashtable queryItems)
{
string where = SQLString.GetConditionClause(queryItems);
string sql = "Select * From [Department]" + where;
DataBase db = new DataBase();
return(db.GetDataTable(sql));
}
/// 查询用户
public static DataTable QueryUsers(Hashtable queryItems)
{
string where = SQLString.GetConditionClause(queryItems);
string sql = "Select * From [Users],[Role] " + where;
if (where == "")
{
sql += " Where";
}
else
{
sql += " And";
}
sql += " [Users].RoleId=[Role].RoleId";
DataBase DB = new DataBase();
return(DB.GetDataTable(sql));
}
