public List <Thongke> ThongKe(DateTime tungay, DateTime denngay) { var dbContext = new shopContext(); var doanhthu = dbContext.Hoadon .Where(x => x.NgayTao >= tungay && x.NgayTao <= denngay) .GroupBy(x => new { x.NgayTao.Month, x.NgayTao.Year }) .OrderBy(x => x.Key.Year) .OrderBy(x => x.Key.Month) .Select(g => new { thang = g.Key.Month, nam = g.Key.Year, tong = g.Sum(x => x.TongTienThanhToan).ToString() }).ToList(); List <Thongke> DSThongKe = new List <Thongke>(); foreach (var item in doanhthu) { Thongke tk = new Thongke(); tk.Nam = item.nam; tk.Thang = item.thang; tk.DoanhThu = item.tong; DSThongKe.Add(tk); } return(DSThongKe); }
private void thốngKêToolStripMenuItem_Click(object sender, EventArgs e) { Thongke f = new Thongke(); this.Hide(); f.ShowDialog(); this.Show(); }
public static Thongke khoitao() { if (check == false) { check = true; TK = new Thongke(); } else { TK.Activate(); } return(TK); }
public static List <Thongke> thongke(DateTime tu, DateTime den) { List <Thongke> tour = new List <Thongke>(); List <int> lt = QLTOUR.load(tu, den); foreach (var temp in lt) { TOUR tt = QLTOUR.find(temp); int demd = DAO.QLTOUR.demdoan(temp, tu, den); int doanhthu = DAO.QLTOUR.doanhthu(temp, tt.GIATOUR, tu, den); int chiphi = DAO.QLTOUR.chiphi(temp, tu, den); int loi = doanhthu - chiphi; Thongke tk = new Thongke(); tk.TENTOUR = tt.TENTOUR; tk.SODOAN = demd; tk.DOANHTHU = doanhthu; tk.CHIPHI = chiphi; tk.LOI = loi; tour.Add(tk); } return(tour); }