internal static List <HoaDon_View> getAll_HoaDon_TheoThoiGian(DateTime startD, DateTime endD)
{
var hd = from hoadon in Context.getInstance().db.HOADONs
where hoadon.NgayLap >= startD.Date
where hoadon.NgayLap <= endD.Date
select new HoaDon_View
{
MaHoaDon = hoadon.MaHoaDon,
NgayLap = hoadon.NgayLap,
NhanVien = hoadon.NHANVIEN1.TenNhanVien,
MaNhanVien = hoadon.MaNguoiLap,
TongTien = hoadon.TongTien,
TongLoiNhuan = hoadon.TongLoiNhuan,
TrangThai = hoadon.TrangThai,
KhachHang = hoadon.KHACHHANG.TenKhachHang,
MaKhachHang = hoadon.MaKhachHang,
SoDienThoai = hoadon.KHACHHANG.SoDienThoai,
MaNhanVienSua = hoadon.MaNguoiSua,
TenNhanVienSua = hoadon.NHANVIEN.TenNhanVien,
NgaySua = (DateTime)hoadon.NgaySua,
GhiChu = hoadon.GhiChu
};
var khp = hd.ToList();
foreach (var item in khp)
{
item.ChiTietHoaDon = CT_HoaDon_DAL.get_CTHoaDon_By_MaHD_TT01(item.MaHoaDon);
item.InitOldData();
if (item.TrangThai == 0)
{
item.Mode = TT.DELETE;
}
}
return(khp);
}
public static HoaDon_View get_HoaDon_By_MaHD(string maHD)
{
var hd = from hoadon in Context.getInstance().db.HOADONs
where hoadon.MaHoaDon == maHD
select new HoaDon_View
{
MaHoaDon = hoadon.MaHoaDon,
NgayLap = hoadon.NgayLap,
NhanVien = hoadon.NHANVIEN1.TenNhanVien,
MaNhanVien = hoadon.MaNguoiLap,
TongTien = hoadon.TongTien,
TongLoiNhuan = hoadon.TongLoiNhuan,
TrangThai = hoadon.TrangThai,
KhachHang = hoadon.KHACHHANG.TenKhachHang,
MaKhachHang = hoadon.MaKhachHang,
SoDienThoai = hoadon.KHACHHANG.SoDienThoai,
MaNhanVienSua = hoadon.MaNguoiSua,
TenNhanVienSua = hoadon.NHANVIEN.TenNhanVien,
NgaySua = (DateTime)hoadon.NgaySua,
GhiChu = hoadon.GhiChu
};
HoaDon_View hdV = hd.ToList()[0];
hdV.ChiTietHoaDon = CT_HoaDon_DAL.get_CTHoaDon_By_MaHD_TT01(hdV.MaHoaDon);
hdV.InitOldData();
if (hdV.TrangThai == 0)
{
hdV.Mode = TT.DELETE;
}
return(hdV);
}