//4.预存挂号人次汇总
public List <RegisterVisitors> GetIncomeVisitors(DateTime startDateTime, DateTime endDateTime, String sfyq)
{
List <RegisterVisitors> list_income = new List <RegisterVisitors>();
for (var i = 0; i < 7; i++)
{
RegisterVisitors income = new RegisterVisitors();
//income.Visitors = 1452 * (i);
income.TimeStemp = endDateTime.AddDays(-i).ToString("yyyy-MM-dd");
list_income.Add(income);
}
double rate = 0.94;
list_income[0].Visitors = Convert.ToInt32(14325 * rate);
list_income[1].Visitors = Convert.ToInt32(13657 * rate);
list_income[2].Visitors = Convert.ToInt32(3452 * rate);
list_income[3].Visitors = Convert.ToInt32(2341 * rate);
list_income[4].Visitors = Convert.ToInt32(11345 * rate);
list_income[5].Visitors = Convert.ToInt32(14352 * rate);
list_income[6].Visitors = Convert.ToInt32(13221 * rate);
list_income.Reverse();
return(list_income);
}
//2.挂号人次汇总
public List <RegisterVisitors> GetRegisterVisitors(DateTime startDateTime, DateTime endDateTime, String sfyq)
{
List <RegisterVisitors> list_income = new List <RegisterVisitors>();
String command = GetCommand2(startDateTime, endDateTime, sfyq);
DbCommand queryCommand = db.GetSqlStringCommand(command);
using (IDataReader reader = db.ExecuteReader(queryCommand))
{
while (reader.Read())
{
RegisterVisitors income = new RegisterVisitors();
income.Visitors = reader["totalnum"] is DBNull ? 0 : Convert.ToInt64(reader["totalnum"]);
income.TimeStemp = reader["SFSJ"] is DBNull ? "0" : reader["SFSJ"].ToString();
list_income.Add(income);
}
}
return(list_income);
}
/// <summary>
/// 获得按天、月分组后的挂号人数数据
/// </summary>
/// <param name="startDateTime"></param>
/// <param name="endDateTime"></param>
/// <param name="type"></param>
/// <param name="hospitalDistrict"></param>
/// <returns></returns>
public List <RegisterVisitors> GetRegisterVisitors(DateTime startDateTime, DateTime endDateTime, string type, params String[] hospitalDistrict)
{
var visitors = new List <RegisterVisitors>();
String command = GetCommandDependOnType(startDateTime, endDateTime, type, hospitalDistrict);
DbCommand queryCommand = db.GetSqlStringCommand(command);
using (IDataReader reader = db.ExecuteReader(queryCommand))
{
while (reader.Read())
{
var rv = new RegisterVisitors();
rv.TimeStemp = reader.GetString(0);
rv.Visitors = reader.IsDBNull(1) ? 0 : reader.GetInt64(1);
visitors.Add(rv);
}
}
return(visitors);
}
//2.挂号人次汇总
public List <RegisterVisitors> GetRegisterVisitors(DateTime startDateTime, DateTime endDateTime, String sfyq)
{
List <RegisterVisitors> list_income = new List <RegisterVisitors>();
for (var i = 0; i < 7; i++)
{
RegisterVisitors income = new RegisterVisitors();
//income.Visitors = 2341 * (i + 1);
income.TimeStemp = endDateTime.AddDays(-i).ToString("yyyy-MM-dd");
list_income.Add(income);
}
list_income[0].Visitors = 14325;
list_income[1].Visitors = 13657;
list_income[2].Visitors = 3452;
list_income[3].Visitors = 2341;
list_income[4].Visitors = 11345;
list_income[5].Visitors = 14352;
list_income[6].Visitors = 13221;
list_income.Reverse();
return(list_income);
}
//6.预约人次汇总
public List <RegisterVisitors> GetFirstVisitors(DateTime startDateTime, DateTime endDateTime, String sfyq)
{
List <RegisterVisitors> list_income = new List <RegisterVisitors>();
for (var i = 0; i < 7; i++)
{
RegisterVisitors income = new RegisterVisitors();
income.Visitors = 1456 * (i + 1);
income.TimeStemp = endDateTime.AddDays(-i).ToString("yyyy-MM-dd");
list_income.Add(income);
}
//double rate = 0.74;
list_income[0].Visitors = Convert.ToInt32(14325 * 0.84);
list_income[1].Visitors = Convert.ToInt32(13657 * 0.76);
list_income[2].Visitors = Convert.ToInt32(3452 * 0.92);
list_income[3].Visitors = Convert.ToInt32(2341 * 0.81);
list_income[4].Visitors = Convert.ToInt32(11345 * 0.79);
list_income[5].Visitors = Convert.ToInt32(14352 * 0.69);
list_income[6].Visitors = Convert.ToInt32(13221 * 0.91);
list_income.Reverse();
return(list_income);
}
