//insert
public static bool Insert(string sid, string rid, string sbool, string dename)
{
string deid = Department_C.DE_seekid(dename);
string sql = "insert into `hospital`.`sickbed` (`S_ID`,`R_ID`,`S_Bool`,`DE_ID`) values('" + sid + "','" + rid + "','" + sbool + "','" + deid + "')";
return(Tool.ExecuteSQL.ExecuteNonQuerySQL_GetBool(sql));
}
//update
public static bool UpdateSickbed(string sid, string rid, int sbool, string dename)
{
string deid = Department_C.DE_seekid(dename);
string sql = "UPDATE `hospital`.`sickbed` SET `R_ID`='" + rid + "', `S_Bool`='" + sbool + "'," +
" `DE_ID`='" + deid + "' WHERE `S_ID`='" + sid + "'";
return(Tool.ExecuteSQL.ExecuteNonQuerySQL_GetBool(sql));
}
//根据科室名称查询病床信息
public static List <Sickbed> Getinfobydename(string dename = "")
{
string deid = Department_C.DE_seekid(dename);
OdbcConnection odbcConnection = DB.DBManager.GetOdbcConnection();
odbcConnection.Open();
string sql = "SELECT * FROM `hospital`.`sickbed` "
+ "WHERE `DE_ID`= '" + deid + "'";
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 <Employee> SelectEmployee(string dename)
{
string deid = Department_C.DE_seekid(dename);
string sql = "SELECT * FROM `hospital`. `employee` WHERE `DE_ID`='" + deid + "' and `E_Position`='3'";
OdbcConnection odbcConnection = DBManager.GetOdbcConnection();
odbcConnection.Open();
OdbcCommand odbcCommand = new OdbcCommand(sql, odbcConnection);
OdbcDataReader odbcDataReader = odbcCommand.ExecuteReader(CommandBehavior.CloseConnection);
if (odbcDataReader.HasRows)
{
List <Employee> list = Employee.getList(odbcDataReader);
odbcConnection.Close();
return(list);
}
else
{
odbcConnection.Close();
}
return(null);
}
