public DataTable getChiTietDonDatHangTheoMa(string[] param)
{
string[] name = { "@MADDH" };
DataTable dondh = Access.ExecuteQuery(SP_DS_CHITIET_DONDATHANG_THEOMA, name, param, 1);
return(dondh);
}
public DataTable getChiTietPhieuNhap(string[] param)
{
string[] name = { "@MAPN" };
DataTable pn = Access.ExecuteQuery(SP_DS_CHITIET_PHIEUNHAP, name, param, 1);
return(pn);
}
public DataTable THONGKEHANGXUAT(string[] param)
{
string[] name = { "@FromDay", "@ToDay", "@Role" };
DataTable hangxuat = Access.ExecuteQuery(SP_THONGKESOHANGXUAT, name, param, 3);
return(hangxuat);
}
//chi tiet hoa don
public DataTable getChiTietHD(String[] param)
{
String[] name = { "@MAPHIEU" };
DataTable chiTietHD = Access.ExecuteQuery(SP_CTPX, name, param, 1);
return(chiTietHD);
}
//lay chi tiet nha cung cap
public DataTable getCTNCC(string[] param)
{
string[] name = { "@MANCC" };
DataTable ctNCC = Access.ExecuteQuery(SP_DS_CT_NCC, name, param, 1);
return(ctNCC);
}
public DataTable ThongKeNhapXuat(string[] param)
{
string[] name = { "@DateFrom", "@DateTo", "@MACN" };
DataTable tonghop = Access.ExecuteQuery(SP_TONGHOPNHAPXUAT, name, param, 3);
return(tonghop);
}
public DataTable TongThu(string[] param)
{
string[] name = { "@DateFrom", "@DateTo", "@MACN" };
DataTable tongthu = Access.ExecuteQuery(SP_TONGTHU, name, param, 3);
return(tongthu);
}
public DataTable TongChi(string[] param)
{
string[] name = { "@DateFrom", "@DateTo", "@MACN" };
DataTable tongchi = Access.ExecuteQuery(SP_TONGCHI, name, param, 3);
return(tongchi);
}
public DataTable ChiTietHangXuat(string[] param)
{
string[] name = { "@DateFrom", "@DateTo", "@MACN" };
DataTable hangxuat = Access.ExecuteQuery(SP_CHITIETHANGXUAT, name, param, 3);
return(hangxuat);
}
public DataTable HoatDongNhanVien(string[] param)
{
string[] name = { "@MaNV", "@DateFrom", "@DateTo", "@MACN" };
DataTable nv = Access.ExecuteQuery(SP_HOATDONGNHANVIEN, name, param, 4);
return(nv);
}
public DataTable THONGKEHANGNHAP(string[] param)
{
string[] name = { "@FromDay", "@ToDay", "@Role" };
DataTable hangnhap = Access.ExecuteQuery(SP_THONGKESOHANGNHAP, name, param, 3);
return(hangnhap);
}
public DataTable getTimKhachHang(String[] param) //KG CAN, TRONG GRIDVIEW DA HO TRO TIM KIEM BAO NGON
{
String[] name = { "@TUKHOA" };
DataTable khachhang = Access.ExecuteQuery(SP_TIMKIEM_KHACHHANG, name, param, 1);
return(khachhang);
}
public DataTable getVatTuTheoNCC(string[] param)
{
string[] name = { "@MANCC" };
DataTable vattu = Access.ExecuteQuery(SP_DS_CT_NCC, name, param, 1);
return(vattu);
}
public DataTable getNhanVienTheoCN(string[] param)
{
string[] name = { "@MACN" };
DataTable NV = Access.ExecuteQuery("SP_LAY_NHANVIENTHEOCN", name, param, 1);
return(NV);
}
public DataTable getVatTuTrongKho(string[] param)
{
string[] name = { "@MAKHO", "@MANCC" };
DataTable vattu = Access.ExecuteQuery(SP_DS_VATTU_TRONGKHO, name, param, 2);
return(vattu);
}
public DataTable ChiTietHangNhap(string[] param)
{
string[] name = { "@DateFrom", "@DateTo", "@MACN" };
DataTable hangnhap = Access.ExecuteQuery(SP_CHITIETHANGNHAP, name, param, 3);
return(hangnhap);
}
//lay ma ko theo ten kho khi selected, sau khi lay ma kho se lay chi tiet kho co nhung vat tu nao va so luong ton
public DataTable getChiTietKho(String[] param)
{
String[] name = { "@TENKHO" };
DataTable chiTietKho = Access.ExecuteQuery(SP_LOAD_CT_KHO, name, param, 1);
return(chiTietKho);
}
public DataTable Load_REPORT_DS_NHANVIEN_THEOMA(string[] param)
{
string[] name = { "@MACN" };
DataTable nv = Access.ExecuteQuery(SP_REPORT_DS_NHANVIEN_THEOMA, name, param, 1);
return(nv);
}
public DataTable getChiTietDonDatHang(string[] param)
{
string[] name = { "@MADDH" };
Console.WriteLine(name[0]);
DataTable dondh = Access.ExecuteQuery(SP_DS_CHITIET_DONDATHANG, name, param, 1);
return(dondh);
}
public DataTable getKhachHang()
{
DataTable khachhang = Access.ExecuteQuery(SP_DS_KHACHHANG, null);
return(khachhang);
}
public DataTable getLoaiVatTu()
{
DataTable loaivattu = Access.ExecuteQuery(SP_DS_LOAIVT, null);
return(loaivattu);
}
public DataTable getVatTu() // lay nhan vien
{
DataTable vattu = Access.ExecuteQuery(SP_DS_VATTU, null);
return(vattu);
}
public DataTable getUser() // lay nhan vien để chuyển chi nhánh
{
DataTable nhanvien = Access.ExecuteQuery(SP_LOAD_USER, null);
return(nhanvien);
}
public DataTable getHoaDon() // lay hoa don (phieu xuat)
{
DataTable hoadon = Access.ExecuteQuery(SP_DANHSACHPHIEUXUAT, null);
return(hoadon);
}
public DataTable getNhanVien() // lay nhan vien
{
DataTable nhanvien = Access.ExecuteQuery(SP_LAY_NHANVIEN, null);
return(nhanvien);
}
public DataTable Load_REPORT_DS_NHANVIEN()
{
DataTable nv = Access.ExecuteQuery(SP_REPORT_DS_NHANVIEN, null);
return(nv);
}
//lay danh sach kho day vao combobox
public DataTable getKho()
{
DataTable kho = Access.ExecuteQuery(SP_DS_KHO, null);
return(kho);
}
public DataTable getNhanVienUser()
{
DataTable nhanvien = Access.ExecuteQuery(SP_LAYNHANVIEN_USER, null);
return(nhanvien);
}
public DataTable getManvtudong()
{
DataTable nhanvien = Access.ExecuteQuery(SP_LAYMA_NV_TUDONG, null);
return(nhanvien);
}
public DataTable getNhanVien_User_ChiNhanh()
{
DataTable nhanvien = Access.ExecuteQuery(SP_LAYNHANVIEN_USER_CHINHANH, null);
return(nhanvien);
}
