public static DataTable LayDSPhieuNhap() { string q = "select maphieunhap,ngaynhap,NHANVIEN.tennv,thanhtien, NHACUNGCAP.ten as nhacungcap " + " from PHIEUNHAPKHO left join NHANVIEN on NHANVIEN.manv = PHIEUNHAPKHO.manv left join NHACUNGCAP on NHACUNGCAP.manhacungcap = PHIEUNHAPKHO.manhacungcap ;"; return(DataProvider.query(q)); }
public static void XoaKho(int makho) { string q = "Delete from KHO where makho = '@MAKHO' "; q = q.Replace("@MAKHO", makho.ToString()); DataProvider.query(q); }
public static DataTable LayThongTinPhieuNhap(string maphieunhap) { string q = "select maphieunhap,ngaynhap,NHANVIEN.tennv,thanhtien, NHACUNGCAP.ten as nhacungcap " + " from PHIEUNHAPKHO left join NHANVIEN on NHANVIEN.manv = PHIEUNHAPKHO.manv left join NHACUNGCAP on NHACUNGCAP.manhacungcap = PHIEUNHAPKHO.manhacungcap where maphieunhap = '@MAPHIEUNHAP';"; q = q.Replace("@MAPHIEUNHAP", maphieunhap); return(DataProvider.query(q)); }
public static string Laydonvi(string manguyenlieu) { string q = "SELECT DONVI.tendonvi, NGUYENLIEU.manguyenlieu FROM NGUYENLIEU left join DONVI on NGUYENLIEU.madonvi = DONVI.madonvi WHERE manguyenlieu = '@MANGUYENLIEU' "; q = q.Replace("@MANGUYENLIEU", manguyenlieu); return((string)DataProvider.query(q).Rows[0][0]); }
public static DataTable LayDSNguyenLieuTheoNCC(string manhacungcap) { string q = "SELECT * FROM NGUYENLIEU WHERE manhacungcap = @MANHACUNGCAP "; q = q.Replace("@MANHACUNGCAP", manhacungcap); return(DataProvider.query(q)); }
public static void ThemKho(nhakho kho) { string q = "insert into KHO(tenkho,mota) values(N'@TENKHO',N'@MOTA')"; q = q.Replace("@TENKHO", kho.tenkho); q = q.Replace("@MOTA", kho.mota); DataProvider.query(q); }
public static void ChinhSuaKho(nhakho kho) { string q = "update KHO set tenkho = N'@TENKHO', mota = N'@MOTA' where makho = @MAKHO "; q = q.Replace("@TENKHO", kho.tenkho); q = q.Replace("@MOTA", kho.mota); q = q.Replace("@MAKHO", kho.makho.ToString()); DataProvider.query(q); }
public static int KiemtraTontai(string tenkho) { int result = 0; string q = "select count(*) from KHO where tenkho = N'@TENKHO' "; q = q.Replace("@TENKHO", tenkho); result = int.Parse(DataProvider.query(q).Rows[0][0].ToString()); return(result); }
public static void ThemPhieuNhap(phieunhap info) { string q = "insert into PHIEUNHAPKHO(maphieunhap,ngaynhap,manv,thanhtien,manhacungcap) VALUES" + " ('@MAPHIEUNHAP','@NGAYNHAP','@MANV','@THANHTIEN','@MANHACUNGCAP');"; q = q.Replace("@MAPHIEUNHAP", info.maphieunhap); q = q.Replace("@NGAYNHAP", info.ngaynhap.ToString()); q = q.Replace("@MANV", info.manv.ToString()); q = q.Replace("@THANHTIEN", info.thanhtien.ToString()); q = q.Replace("@MANHACUNGCAP", info.manhacungcap.ToString()); DataProvider.query(q); }
public static void ThemCTPhieuNhap(List <ctphieunhap> ct) { for (int i = 0; i < ct.Count; i++) { string q = "insert into CTPHIEUNHAPKHO(maphieunhap,manguyenlieu,soluong,thanhtien)" + " values('@MAPHIEUNHAP','@MANGUYENLIEU',@SOLUONG,@THANHTIEN)"; q = q.Replace("@MAPHIEUNHAP", ct[i].maphienhap); q = q.Replace("@MANGUYENLIEU", ct[i].manguyenlieu.ToString()); q = q.Replace("@SOLUONG", ct[i].soluong.ToString()); q = q.Replace("@THANHTIEN", ct[i].thanhtien.ToString()); DataProvider.query(q); } }
public static DataTable LayDSNhanVien() { string q = "select manv, LOAINV.tenloai , tennv, sdt, cmnd from NHANVIEN left join LOAINV on NHANVIEN.maloainv = LOAINV.maloai;"; return(DataProvider.query(q)); }
public static DataTable LayDSNhacungcap() { string q = "select * from NHACUNGCAP;"; return(DataProvider.query(q)); }
public static DataTable LayThongTinKho() { string q = "select makho,tenkho,mota from KHO"; return(DataProvider.query(q)); }