//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); }