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