//特检预约时长
public List <AverageTreatmentTime> GetSpecialAverageTime(DateTime startTime, DateTime endTime, String type)
{
var avgTreatmentTimes = new List <AverageTreatmentTime>();
String command = GetSpecialCommandDependOnType(startTime, endTime, type);
DbCommand queryCommand = db.GetSqlStringCommand(command);
using (IDataReader reader = db.ExecuteReader(queryCommand))
{
while (reader.Read())
{
var att = new AverageTreatmentTime
{
TimeStemp = reader.GetString(0),
Appointment = StringHandler.GetDoubleByString(reader.IsDBNull(1)?"0":reader.GetString(1), 1),
};
avgTreatmentTimes.Add(att);
}
}
return(avgTreatmentTimes);
}
public List <AverageTreatmentTime> GetAverageTime(DateTime startTime, DateTime endTime, String type)
{
var avgTreatmentTimes = new List <AverageTreatmentTime>();
String command = GetCommandDepongOnType(startTime, endTime, type);
DbCommand queryCommand = db.GetSqlStringCommand(command);
using (IDataReader reader = db.ExecuteReader(queryCommand))
{
while (reader.Read())
{
var att = new AverageTreatmentTime
{
TimeStemp = reader.GetString(0),
Appointment = reader.GetDouble(1),
AwaitingDiagnosis = reader.GetDouble(2),
PayFees = reader.GetDouble(3),
MedicineReceiving = reader.GetDouble(4)
};
avgTreatmentTimes.Add(att);
}
}
return(avgTreatmentTimes);
}
