//根据病床号查询病床信息
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);
}
