public SqlDataReader GetOne(string year, string term, string garde, string Class, string de)
{
string sql = "select *from CourseBuild where Year='" + year + "' and Term='" + term + "' and garde='" + garde + "' and Class='" + Class + "' and Department='" + de + "'";
SqlDB db = new SqlDB();
return(db.GetDataReader(sql));
}
/// <summary>
/// 返回数据库信息
/// </summary>
/// <returns></returns>
public SqlDataReader getWhole2()
{
SqlDB db = new SqlDB();
string sql = "select * from CourseBuild";
SqlDataReader reader = db.GetDataReader(sql);
return(reader);
}
public bool ExiseUser(string userid)//判断用户是否存在
{
bool exise = false;
string sql = string.Format("select * from Users where UsersName='{0}'", userid);
using (SqlDataReader myreader = sqlDB.GetDataReader(sql))
{
if (myreader.HasRows)//如果返回的有结果
{
exise = true;
}
}
return(exise);
}
public string getBuilding2(string Class)
{
SqlDB db = new SqlDB();
string sql = "select distinct department from Basic_Information WHERE class='" + Class + "'";
string name = "";
reader = db.GetDataReader(sql);
while (reader.Read())
{
name += reader.GetString(0);
}
reader.Close();
return(name);
}
//SqlParameter[] paras = null;
/// <summary>
/// 教学楼显示出来
/// </summary>
/// <returns></returns>
public SqlDataReader Building_IdShow(int key)
{
string sqlst = null;
if (key == 1) //找教学楼
{
sqlst = "SELECT DISTINCT ABS(Building_Id) FROM Classroom order by ABS(Building_Id)";
}
else if (key == 2) //通过教学楼找教室
{
sqlst = "SELECT DISTINCT name FROM Classroom WHERE Building_Id='" + sr2 + "' order by name";
}
SqlDataReader sr1 = db.GetDataReader(sqlst);//找出来
return(sr1);
}
