//手术信息 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); }