public static List<ItemDoanhThu> GetDoanhThuFromHistory(DateTime dateTime, DaysFormat daysFormat) { List<ItemDoanhThu> result = new List<ItemDoanhThu>(); string strCommand = ""; if(daysFormat == DaysFormat.Ngay) { strCommand = " SELECT * FROM " + ClinicConstant.HistoryTable + " WHERE Day = " + Helper.ConvertToSqlString(dateTime.ToString("yyyy-MM-dd")); } if (daysFormat == DaysFormat.Thang) { strCommand = " SELECT * FROM " + ClinicConstant.HistoryTable + " WHERE month(Day) = " + dateTime.Month.ToString(); } using (DbDataReader reader = DatabaseFactory.Instance.ExecuteReader(strCommand, null) as DbDataReader) { while (reader.Read()) { ItemDoanhThu item = new ItemDoanhThu(); item.Date = reader.GetDateTime(reader.GetOrdinal(ClinicConstant.HistoryTable_Day)).ToString("dd-MM-yyyy"); item.NameOfDoctor = reader[ClinicConstant.HistoryTable_NameDoctor].ToString(); item.IdPatient = reader[ClinicConstant.HistoryTable_Id].ToString(); item.AllMedicines = reader[ClinicConstant.HistoryTable_Medicines].ToString(); string Services = ""; item.Money = CalcuMoneyFromAllMedicines(item.AllMedicines, ref Services); item.Services = Services; item.NamePatient = GetNameFromIdPatient(item.IdPatient); item.LoaiKham = reader[ClinicConstant.HistoryTable_NameLoaiKham].ToString(); item.Diagnose = reader[ClinicConstant.HistoryTable_Diagnose].ToString(); if (result.Where(x => x.IdPatient == item.IdPatient && x.Date == item.Date).FirstOrDefault() == null) { result.Add(item); } } } return result; }
internal static List<ItemDoanhThu> DoanhThuTheoThang(IDatabase db, DateTime dateTime) { List<ItemDoanhThu> result = new List<ItemDoanhThu>(); string strCommand = " SELECT * FROM doanhthu WHERE month(time) = " + dateTime.Month.ToString(); using (DbDataReader reader = db.ExecuteReader(strCommand, null) as DbDataReader) { while (reader.Read()) { ItemDoanhThu item = new ItemDoanhThu(); item.Date = reader.GetDateTime(reader.GetOrdinal(ClinicConstant.DoanhThuTable_Time)).ToString("dd-MM-yyyy"); item.NameOfDoctor = reader[ClinicConstant.DoanhThuTable_Namedoctor].ToString(); item.Money = (int)reader[ClinicConstant.DoanhThuTable_Money]; item.IdPatient = reader[ClinicConstant.DoanhThuTable_IdPatient].ToString(); item.NamePatient = reader[ClinicConstant.DoanhThuTable_NamePatient].ToString(); item.Services = reader[ClinicConstant.DoanhThuTable_Services].ToString(); item.LoaiKham = reader[ClinicConstant.DoanhThuTable_LoaiKham].ToString(); try { int idHistory = (int)reader[ClinicConstant.HistoryTable_IdHistory]; item.Diagnose = GetDiagnoseFromHistoryByIdHistory(idHistory, DatabaseFactory.Instance2); } catch { item.Diagnose = ""; } if (result.Where(x => x.IdPatient == item.IdPatient && x.Date == item.Date).FirstOrDefault() == null) { result.Add(item); } } } return result; }