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);
}
