//获取额定空床数量
public List <RateEmptyBed> GetRateEmptyBed()
{
List <RateEmptyBed> list_RateEmptyBed = new List <RateEmptyBed>();
string[] Specialist = { "0", "皮肤科", "五官科", "妇科", "骨科", "内分泌科" };
Random random = new Random();
for (int i = 1; i < 6; i++)
{
RateEmptyBed rateEmptyBed = new RateEmptyBed();
rateEmptyBed.RateEmptyBedQuanty = random.Next(70, 90) - 10 * i;
rateEmptyBed.Specialist = Specialist[i];
list_RateEmptyBed.Add(rateEmptyBed);
}
return(list_RateEmptyBed);
}
//2.4获取额定空床数量
public List <RateEmptyBed> GetRateEmptyBed()
{
List <RateEmptyBed> list_RateEmptyBed = new List <RateEmptyBed>();
String command = GetCommandForRateEmptyBed();
DbCommand queryCommand = db.GetSqlStringCommand(command);
using (IDataReader reader = db.ExecuteReader(queryCommand))
{
while (reader.Read())
{
RateEmptyBed rateEmptyBed = new RateEmptyBed();
rateEmptyBed.RateEmptyBedQuanty = reader["RateEmptyBedQuanty"] is DBNull ? 0 : Convert.ToInt32(reader["RateEmptyBedQuanty"]);
rateEmptyBed.Specialist = reader["Specialist"] is DBNull ? "" : reader["Specialist"].ToString();
list_RateEmptyBed.Add(rateEmptyBed);
}
}
return(list_RateEmptyBed);
}
