//5.预存金额汇总
public List <IncomeByTime> GetIncomeFirst(DateTime startDateTime, DateTime endDateTime, String sfyq)
{
List <IncomeByTime> list_income = new List <IncomeByTime>();
for (var i = 0; i < 7; i++)
{
IncomeByTime income = new IncomeByTime();
income.TotolMoney = 97546 * (i + 1);
income.TimeStemp = endDateTime.AddDays(-i).ToString("yyyy-MM-dd");
list_income.Add(income);
}
return(list_income);
}
/// <summary>
/// 1门诊收入总额
/// </summary>
/// <param name="sfyq">收费院区</param>
//门诊收入总额
public List <IncomeByTime> GetIncomeAll(DateTime startDateTime, DateTime endDateTime, String sfyq)
{
List <IncomeByTime> list_income = new List <IncomeByTime>();
String command = GetCommand1(startDateTime, endDateTime, sfyq);
DbCommand queryCommand = db.GetSqlStringCommand(command);
using (IDataReader reader = db.ExecuteReader(queryCommand))
{
while (reader.Read())
{
IncomeByTime income = new IncomeByTime();
income.TotolMoney = reader["TotalMoney"] is DBNull ? 0 : Convert.ToInt64(reader["TotalMoney"]);
income.TimeStemp = reader["sj"] is DBNull ? "0" : reader["sj"].ToString();
list_income.Add(income);
}
}
return(list_income);
}
//1.门诊收入汇总
public List <IncomeByTime> GetIncomeAll(DateTime startDateTime, DateTime endDateTime, String sfyq)
{
List <IncomeByTime> list_income = new List <IncomeByTime>();
for (var i = 0; i < 7; i++)
{
IncomeByTime income = new IncomeByTime();
//income.TotolMoney = 7635*(i+1);
income.TimeStemp = endDateTime.AddDays(-i).ToString("yyyy-MM-dd");
list_income.Add(income);
}
list_income[0].TotolMoney = 5460000;
list_income[1].TotolMoney = 6790000;
list_income[2].TotolMoney = 1320000;
list_income[3].TotolMoney = 1110000;
list_income[4].TotolMoney = 5280000;
list_income[5].TotolMoney = 6470000;
list_income[6].TotolMoney = 5980000;
list_income.Reverse();
return(list_income);
}
