public static DataTable Query(Hashtable queryItems)
{
string where = SQLString.GetConditionClause(queryItems);
string sql = "Select * From [Departmentmr]" + where;
DataBase db = new DataBase();
return db.GetDataTable(sql);
}
/// 查询用户
public static DataTable QueryUsers(Hashtable queryItems)
{
string where = SQLString.GetConditionClause(queryItems);
string sql = "Select * From [Usersmr],[Departmentmr],[Rolemr] " + where;
if (where == "")
sql += " Where";
else
sql += " And";
sql += " [Usersmr].DepartmentId=[Departmentmr].DepartmentId"
+ " And [Usersmr].RoleId=[Rolemr].RoleId";
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 top 2 * From [Rolemr] order by RoleId" + where;
DataBase db = new DataBase();
return db.GetDataTable(sql);
}