public static HoaDonNhap_View get_HoaDonNhap_By_MaHD(string maHD) { var hd = from hoadon in Context.getInstance().db.HOADON_NHAPHANG where hoadon.MaHoaDon == maHD select new HoaDonNhap_View { MaHoaDon = hoadon.MaHoaDon, NgayLap = hoadon.NgayLap, NhanVien = hoadon.NHANVIEN1.TenNhanVien, MaNhanVien = hoadon.MaNguoiLap, TongTien = hoadon.TongTien, TrangThai = hoadon.TrangThai, NhaCungCap = hoadon.NHACUNGCAP.TenNhaCungCap, MaNhaCungCap = hoadon.MaNhaCungCap, SoDienThoai = hoadon.NHACUNGCAP.SoDienThoai, MaNhanVienSua = hoadon.MaNguoiSua, TenNhanVienSua = hoadon.NHANVIEN.TenNhanVien, NgaySua = (DateTime)hoadon.NgaySua, GhiChu = hoadon.GhiChu }; HoaDonNhap_View hdV = hd.ToList()[0]; hdV.ChiTietHoaDon = CT_HoaDonNhap_DAL.get_CTHoaDonNhap_By_MaHD_TT01(hdV.MaHoaDon); hdV.InitOldData(); if (hdV.TrangThai == 0) { hdV.Mode = TT.DELETE; } return(hdV); }
internal static List <HoaDonNhap_View> getAll_HoaDonNhap_TheoThoiGian(DateTime startD, DateTime endD) { var hd = from hoadon in Context.getInstance().db.HOADON_NHAPHANG where hoadon.NgayLap >= startD.Date where hoadon.NgayLap <= endD.Date select new HoaDonNhap_View { MaHoaDon = hoadon.MaHoaDon, NgayLap = hoadon.NgayLap, NhanVien = hoadon.NHANVIEN.TenNhanVien, MaNhanVien = hoadon.MaNguoiLap, TongTien = hoadon.TongTien, TrangThai = hoadon.TrangThai, NhaCungCap = hoadon.NHACUNGCAP.TenNhaCungCap, MaNhaCungCap = hoadon.MaNhaCungCap, SoDienThoai = hoadon.NHACUNGCAP.SoDienThoai, GhiChu = hoadon.GhiChu, MaNhanVienSua = hoadon.MaNguoiSua, TenNhanVienSua = hoadon.NHANVIEN1.TenNhanVien, NgaySua = (DateTime)hoadon.NgaySua }; var khp = hd.ToList(); foreach (var item in khp) { item.ChiTietHoaDon = CT_HoaDonNhap_DAL.get_CTHoaDonNhap_By_MaHD_TT01(item.MaHoaDon); item.InitOldData(); if (item.TrangThai == 0) { item.Mode = TT.DELETE; } } return(khp); }