/// <summary>
/// 查询院系
/// </summary>
/// <param name="queryItems"></param>
/// <returns></returns>
public static DataTable QueryYX(Hashtable queryItems)
{
string where = SqlStringConstructor.GetConditionClause(queryItems);
string sql = "Select * From [yxb] " + where;
Database db = new Database();
return(db.GetDataTable(sql));
}
/// <summary>
/// 按某个属性，升序或者降序获取所有的图书信息
/// </summary>
/// <param name="sortedColumn">排序属性</param>
/// <param name="sortType">可取{desc,asc}，分别代表降序、升序</param>
/// <returns>查询结果集</returns>
public static DataTable QueryBooks(Hashtable queryItems, string sortedColumn, string sortType)
{
if (sortType.ToUpper() != "DESC" && sortType.ToUpper() != "ASC" && sortType != "")
{
return(null);
}
string where = SqlStringConstructor.GetConditionClause(queryItems);
string constrains = " Order By " + sortedColumn + " " + sortType;
string sql = "Select * From [Book] " + where + constrains;
Database db = new Database();
return(db.GetDataTable(sql));
}
/// <summary>
/// 查询教学班
/// </summary>
/// <param name="queryItems"></param>
/// <returns></returns>
public static DataTable Query(Hashtable queryItems)
{
string where = SqlStringConstructor.GetConditionClause(queryItems);
string sql = "Select * from [js_kcsj_gxb],[jsb],[kcsjb],[jxbb] " + where;
if (where == "")
{
sql += " Where";
}
else
{
sql += " And";
}
sql += " [js_kcsj_gxb].jsbh=[jsb].jsbh And [js_kcsj_gxb].kcsjbh=[kcsjb].kcsjbh And [js_kcsj_gxb].jxbbh=[jxbb].jxbbh";
Database db = new Database();
return(db.GetDataTable(sql));
}
/// <summary>
/// 查询教师
/// </summary>
/// <param name="queryItems"></param>
/// <returns></returns>
public static DataTable QueryJS(Hashtable queryItems)
{
string where = SqlStringConstructor.GetConditionClause(queryItems);
string sql = "Select * from [jsb],[yxb],[zwb],[zcb] " + where;
if (where == "")
{
sql += " Where";
}
else
{
sql += " And";
}
sql += " [jsb].yxbh = [yxb].yxbh And [jsb].zcbh = [zcb].zcbh And [jsb].zwbh = [zwb].zwbh";
Database db = new Database();
return(db.GetDataTable(sql));
}
