public async Task <IActionResult> Get([FromQuery] GetHoaDonPagingRepuest repuest)
{
var data = await _managerHoaDonService.GetAllByTram(repuest);
return(Ok(data));
}
public async Task <PagedHoaDonByKyResult <HoaDonViewModel> > GetAllByTram(GetHoaDonPagingRepuest repuest)
{
var query = await(from h in _context.HoaDon
join k in _context.KhachHang on h.MaKh equals k.MaKh
join x in _context.XaPhuong on k.XaPhuong equals x.MaXaPhuong
join kt in _context.KyXuatHoaDon on h.KyTinh equals kt.MaKyTinh
where h.TongTien > 0 && h.KyTinh.Value.Year == repuest.KyHoadon.Year && h.KyTinh.Value.Month == repuest.KyHoadon.Month && h.KyTinh.Value.Day == repuest.KyHoadon.Day && k.MaTram == repuest.MaTram
select new HoaDonViewModel
{
RowId = h.RowId,
MaHoaDon = h.MaHoaDon,
KyTinh = h.KyTinh,
MaKh = h.MaKh,
TenKh = h.TenKh,
ChiSoCu = h.ChiSoCu,
ChiSoMoi = h.ChiSoMoi,
SoM3 = h.SoM3,
DonGiaTdm = h.DonGiaTdm,
TienTdm = h.TienTdm,
DonGiaVdm = h.DonGiaVdm,
//TienVdm = h.TienVdm,
//TienBaoTri = h.TienBaoTri,
//TienThueBao = h.TienThueBao,
Vat = h.Vat,
ThanhTien = h.ThanhTien,
NoKyTruoc = h.NoKyTruoc,
TongTien = h.TongTien,
//NgayLap = h.NgayLap,
//NgayThu = h.NgayThu,
//DaThanhToan = h.DaThanhToan,
//NhanVienGhiNuoc =h.NhanVienGhiNuoc,
//NhanVienThuTien = h.NhanVienThuTien,
GhiChu = k.MaTram,
//NguoiTao = h.NguoiTao,
//NgayTao = h.NgayTao,
//NguoiThayDoi = h.NguoiThayDoi,
//NgayThayDoi = h.NgayThayDoi,
//NguyenNhan = h.NguyenNhan,
PhiNuocThai = h.PhiNuocThai,
Dm10 = h.Dm10,
Dm20 = h.Dm20,
Dm30 = h.Dm30,
Dm40 = h.Dm40,
PhanLoaiNuocSd = h.PhanLoaiNuocSd,
Don_Gia_DM10 = 0.0,
Don_Gia_DM20 = 0.0,
Don_Gia_DM30 = 0.0,
Don_Gia_DM40 = 0.0,
PhanTramPhiSH = 0.0,
MSThue = k.MstKh,
So_Nha = k.SoNha,
To_KH = k.ToKh,
Ap_KH = k.ApKh,
Xa_Phuong = x.TenXaPhuong,
Ky_Tinh_TuNgay = kt.DenNgay,
Ky_Tinh_DenNgay = kt.TuNgay,
}).Take(3).ToListAsync();
var totalcount = query.Count();
var result = new PagedHoaDonByKyResult <HoaDonViewModel>()
{
Items = query,
TotalRecord = totalcount,
KyHoaDon = repuest.KyHoadon
};
return(result);
}
