void load()
{
DateTime fromday = dtpfromday.Value;
DateTime today = dtptoday.Value;
dgrThongKe.DataSource = KhoHangDAO.ThongKe(fromday, today);
}
public static int SuaKhohang(KhoHangDTO kh)
{
if (string.IsNullOrEmpty(kh.TenKho))
{
return(-1);
}
KhoHangDAO.SuaKhoHang(kh);
return(0);
}
// private BindingList<KhachHangDTO> lstChiTiet;
public static bool ThemKhoHang(KhoHangDTO kh)
{
if (string.IsNullOrEmpty(kh.TenKho))
{
return(false);
}
bool test = KhoHangDAO.ThemKhoHang(kh);
if (test == true)
{
int MaKho = KhoHangDAO.LayMaKhoMoiNhat();
KhoHangDAO.ThemTatCaHangHoaVaoKho(MaKho);
}
return(test);
}
/// <summary>
/// Hiển thị danh sách hàng trong kho theo mã hàng
/// </summary>
public static DataTable GetByMaHang(string maHang)
{
return(KhoHangDAO.GetByMaHang(maHang));
}
/// <summary>
/// Hiển thị danh sách hàng trong kho theo mã kho
/// </summary>
public static DataTable GetByMaKho(string maKho)
{
return(KhoHangDAO.GetByMaKho(maKho));
}
public static DataTable XemTonKhoTheoKho(int MaKho)
{
return(KhoHangDAO.XemTonKhoTheoKho(MaKho));
}
public static DataTable LayHangHoaTheoKho(int MaKho)
{
return(KhoHangDAO.LayHangHoaTheoKho(MaKho));
}
public static bool ThemHangHoaVaoTungKho(int MaHangHoa)
{
bool test = KhoHangDAO.ThemHangHoaVaoTungKho(MaHangHoa);
return(test);
}
public static ArrayList traCuuNhaCungCapThoaYeuCauNguyenLieuCanDatHang(string sqlFROM)
{
return(KhoHangDAO.traCuuNhaCungCapThoaYeuCauNguyenLieuCanDatHang(sqlFROM));
}
public static ArrayList layDanhSachNhaCungCap(int maNhaHang, string ten)
{
return(KhoHangDAO.layDanhSachNhaCungCap(maNhaHang, ten));
}
public static ArrayList timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung(string ten, int tinhTrangGiaoDich, int maNhaHang)
{
return(KhoHangDAO.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung(ten, tinhTrangGiaoDich, maNhaHang));
}
//PHANTOM SOLVED
public static ArrayList phantomSolvedTimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichChuaTungGiaoDich(string ten, int maNhaHang)
{
return(KhoHangDAO.phantomSolvedTimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichChuaTungGiaoDich(ten, maNhaHang));
}
public static ArrayList layDanhSachNhaCungCapToiHanDuocThanhToanNoTheoDinhMucNo(int maNhaHang)
{
return(KhoHangDAO.layDanhSachNhaCungCapToiHanDuocThanhToanNoTheoDinhMucNo(maNhaHang));
}
public static KhoHangDTO layThongTinKhoHangTheoNhaHang(int maNhaHang)
{
return(KhoHangDAO.layThongTinKhoHangTheoNhaHang(maNhaHang));
}
public static List <KhoHangDTO> LayToanBoKhoHang()
{
return(KhoHangDAO.LayDanhSachKhoHang());
}
public static ArrayList layDSKhoHang_NguyenLieu(int maNhaHang, NguyenLieuDTO nguyenLieuCanTim)
{
return(KhoHangDAO.traCuuKhoHangNguyenLieuGanDung(maNhaHang, nguyenLieuCanTim));
}
public static KhoHang_NguyenLieuDTO layChiTietKhoHang_NguyenLieu(int maNhaHang, NguyenLieuDTO nguyenLieuCanTim)
{
return(KhoHangDAO.layChiTietKhoHangNguyenLieu(maNhaHang, nguyenLieuCanTim));
}
public static int XoaKhoHang(KhoHangDTO khXoa)
{
KhoHangDAO.XoaKhoHang(khXoa);
return(0);
}
public static ArrayList layDanhSachNguyenLieuDangOKhoangMucToiThieu(int maNhaHang)
{
return(KhoHangDAO.layDanhSachNguyenLieuDangOKhoangMucToiThieu(maNhaHang));
}
public static bool ThemTatCaHangHoaVaoKho(int MaKho)
{
bool test = KhoHangDAO.ThemTatCaHangHoaVaoKho(MaKho);
return(test);
}
public static List <KhoHang> DanhSach()
{
return(KhoHangDAO.DanhSach());
}
public static DataTable XemTonKho()
{
return(KhoHangDAO.XemTonKho());
}
/// <summary>
/// Hiển thị danh sách hàng trong kho hàng
/// </summary>
public static DataTable GetAll()
{
return(KhoHangDAO.GetAll());
}
static KhoHangBUS()
{
db = new KhoHangDAO();
}
void LoadKhoHang()
{
dgvHoaDonNhapMain.DataSource = KhoHangDAO.QuanLyKho();
}
