internal IQueryable <object> ThongKeTiTrong(DateTime?froms, DateTime?tos) { CongNghePhanMemEntities db = new CongNghePhanMemEntities(); var s = from p in db.ChiTietDonHangs where p.DonDatHang.NgayDat >= froms && p.DonDatHang.NgayDat <= tos group p by p.Sach.TenSach into gro select new { TenSP = gro.Key, SL = gro.Sum(r => r.SoLuong) }; return(s); }
internal IQueryable <object> ThongKeDoanhThu(DateTime?froms, DateTime?tos) { CongNghePhanMemEntities db = new CongNghePhanMemEntities(); var s = from p in db.DonDatHangs where p.NgayDat >= froms && p.NgayDat <= tos group p by EntityFunctions.TruncateTime(p.NgayDat) into gro select new { ngaymua = gro.Key.Value, tongtien = gro.Sum(r => r.Tongtien) }; return(s); }