//手术信息
public SurgeryInformation GetSurgeryInformation()
{
SurgeryInformation SurgeryInfor = new SurgeryInformation();
SurgeryInfor.CompletedQuanty = 52;
SurgeryInfor.DoingQuanty = 23;
SurgeryInfor.WaitingQuanty = 12;
return(SurgeryInfor);
}
//2.3手术信息
public SurgeryInformation GetSurgeryInformation()
{
SurgeryInformation surgeryInfor = new SurgeryInformation();
String command = GetCommandForSurgeryInformation();
DbCommand queryCommand = db.GetSqlStringCommand(command);
using (IDataReader reader = db.ExecuteReader(queryCommand))
{
while (reader.Read())
{
surgeryInfor.CompletedQuanty = reader["CompletedQuanty"] is DBNull ? 0 : Convert.ToInt32(reader["CompletedQuanty"]);
surgeryInfor.WaitingQuanty = reader["WaitingQuanty"] is DBNull ? 0 : Convert.ToInt32(reader["WaitingQuanty"]);
surgeryInfor.DoingQuanty = reader["DoingQuanty"] is DBNull ? 0 : Convert.ToInt32(reader["DoingQuanty"]);
}
}
return(surgeryInfor);
}
