//根据病床号查询病床信息 public static List <Sickbed> Getinfobysid(string sid = "") { OdbcConnection odbcConnection = DB.DBManager.GetOdbcConnection(); odbcConnection.Open(); string sql = "SELECT * FROM `hospital`.`sickbed` " + "WHERE `S_ID`='" + sid + "'"; OdbcCommand odbcCommand = new OdbcCommand(sql, odbcConnection); OdbcDataReader odbcDataReader = odbcCommand.ExecuteReader(CommandBehavior.CloseConnection); if (odbcDataReader.HasRows) { List <Sickbed> list = Sickbed.getList(odbcDataReader); odbcConnection.Close(); return(list); } odbcConnection.Close(); return(null); }
public static List <Sickbed> SickBedInfobyde(string deid) { OdbcConnection sqlConnection1 = DBManager.GetOdbcConnection(); sqlConnection1.Open(); OdbcCommand odbcCommand = new OdbcCommand("select * from sickbed where `DE_ID`='" + deid + "'", sqlConnection1); OdbcDataReader odbcDataReader = odbcCommand.ExecuteReader(); if (odbcDataReader.HasRows) { List <Sickbed> list = Sickbed.getList(odbcDataReader); sqlConnection1.Close(); return(list); } else { sqlConnection1.Close(); } return(null); }