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