//Lay ma qui cach tu ten qui cach public string LayMaQuiCachTuTenQuiCach(string ten) { dt = CDATABASE.ExecuteBang("SELECT MAQUICACH FROM QUICACH WHERE QUICACH='" + ten + "'"); s = dt.Rows[0]["MAQUICACH"].ToString(); return(s); }
//Lay qui cach public DataTable LayQuiCach() { return(CDATABASE.ExecuteBang("SELECT * FROM QUICACH")); }
public DataTable HienThiSPTheoLoaiSP(string tenloai) { return(CDATABASE.ExecuteBang("SELECT MASP, TENSP, DONGIA, QUICACH FROM SANPHAM A, LOAISANPHAM B, QUICACH C WHERE A.MALOAI=B.MALOAI AND A.MAQUICACH=C.MAQUICACH AND B.TENLOAI=N'" + tenloai + "'")); }
//CDATABASE db = new CDATABASE(); public DataTable LaySP() { return(CDATABASE.ExecuteBang("SELECT A.MASP, TENSP, MOTASP, DONGIA, TENLOAI, QUICACH FROM SANPHAM A, LOAISANPHAM B, QUICACH C WHERE A.MALOAI=B.MALOAI AND A.MAQUICACH=C.MAQUICACH")); }
//Lay ma loai san pham tu ten loai san pham public string LayMaLoaiTuTenLoai(string ten) { dt = CDATABASE.ExecuteBang("SELECT MALOAI FROM LOAISANPHAM WHERE TENLOAI=N'" + ten + "'"); s = dt.Rows[0]["MALOAI"].ToString(); return(s); }
//Lay danh sach loai san pham public DataTable LayLoaiSP() { return(CDATABASE.ExecuteBang("SELECT * FROM LOAISANPHAM")); }