static public DataTable SelectSachAll() { string sql = "select* from SACH"; DataTable dt = DataAccess.ExcuQuery(sql); return(dt); }
static public DataTable SelectPhieuNhapChiTietAll() { string sql = "select * from CHITIETPHIEU"; DataTable dt = DataAccess.ExcuQuery(sql); return(dt); }
static public DataTable SelectPhieuNhapAll() { string sql = "select* from PHIEUNHAP"; DataTable dt = DataAccess.ExcuQuery(sql); return(dt); }
public static bool KiemTraNguoiDung(NguoiDungDTO user) { string sql = "select * from NGUOIDUNG where TenNguoiDung='" + user.TenNguoiDung + "' and MatKhauNguoiDung='" + user.MatKhau + "' and PhanQuyen='" + user.PhanQuyen + "'"; DataTable dt = DataAccess.ExcuQuery(sql); if (dt.Rows.Count != 0) { return(true); } else { return(false); } }
static public SachDTO SelectTLByName(string name) { string sql = "select * from SACH where TenSach='" + name + "'"; DataTable dt = DataAccess.ExcuQuery(sql); if (dt.Rows.Count == 0) { return(null); } else { SachDTO s = new SachDTO(); s.TenSach = dt.Rows[0].ItemArray[0].ToString(); return(s); } }
static public SachDTO SelectSachTheoMa(int ma) { string sql = "select * from SACH where MaSach=" + ma + ""; DataTable dt = DataAccess.ExcuQuery(sql); if (dt.Rows.Count == 0) { return(null); } else { SachDTO s = new SachDTO(); s.MaSach = int.Parse(dt.Rows[0].ItemArray[0].ToString()); return(s); } }
public static PhieuNhapDTO GetPhieuNhapByName(int maphieunhap, int masach) { string sql = "select * from CHITIETPHIEU where ((MaPhieuNhap=" + maphieunhap + ")AND(MaSach = " + masach + "))"; DataTable dt = DataAccess.ExcuQuery(sql); if (dt.Rows.Count == 0) { return(null); } else { PhieuNhapDTO pn = new PhieuNhapDTO(); pn.MaPhieuNhap = (int)dt.Rows[0].ItemArray[0]; return(pn); } }
static public HoaDonDTO SelectSachLikeMaSach(int mahoadon, int masach) { string sql = "select * from CHITIETHOADON where ((MaHoaDon = " + mahoadon + ")AND(MaSach like " + masach + ") )"; DataTable dt = DataAccess.ExcuQuery(sql); if (dt.Rows.Count == 0) { return(null); } else { HoaDonDTO hd = new HoaDonDTO(); hd.MaSach = int.Parse(dt.Rows[0].ItemArray[0].ToString()); return(hd); } }
public static TheLoaiDTO GetTheLoaiByMa(int Ma) { string sql = "select * from THELOAI where MaTheLoai=" + Ma + ""; DataTable dt = DataAccess.ExcuQuery(sql); if (dt.Rows.Count == 0) { return(null); } else { TheLoaiDTO tl = new TheLoaiDTO(); tl.MaTheLoai = (int)dt.Rows[0].ItemArray[0]; tl.TenTheLoai = dt.Rows[0].ItemArray[1].ToString(); return(tl); } }
public static PhieuThuDTO GetPhieuThuByMa(int Ma) { string sql = "select * from PHIEUTHU where MaPhieuThu=" + Ma + ""; DataTable dt = DataAccess.ExcuQuery(sql); if (dt.Rows.Count == 0) { return(null); } else { PhieuThuDTO pt = new PhieuThuDTO(); pt.MaPhieuThu = (int)dt.Rows[0].ItemArray[0]; //pt.NgayThu = (DateTime)dt.Rows[0].ItemArray[1]; //pt.SoTienThu = (int)dt.Rows[0].ItemArray[2]; //pt.MaKhachHang = (int)dt.Rows[0].ItemArray[3]; return(pt); } }
public static KhachHangDTO GetTheLoaiByMa(int Ma) { string sql = "select * from KHACHHANG where MaKhachHang=" + Ma + ""; DataTable dt = DataAccess.ExcuQuery(sql); if (dt.Rows.Count == 0) { return(null); } else { KhachHangDTO kh = new KhachHangDTO(); kh.MaKhachHang = (int)dt.Rows[0].ItemArray[0]; kh.HoTenKhachHang = dt.Rows[0].ItemArray[1].ToString(); kh.DienThoai = (int)dt.Rows[0].ItemArray[2]; kh.DiaChi = dt.Rows[0].ItemArray[3].ToString(); kh.Email = dt.Rows[0].ItemArray[4].ToString(); return(kh); } }
public static DataTable GetPhieuThuAll() { string sql = "select * from PHIEUTHU"; return(DataAccess.ExcuQuery(sql)); }
public static DataTable LayDanhSachNguoiDung() { string sql = "select * from NGUOIDUNG"; return(DataAccess.ExcuQuery(sql)); }
static public DataTable SelectKhachHangLikeTen(KhachHangDTO kh) { string sql = "select * from KHACHHANG where HoTenKhachHang like '%" + kh.HoTenKhachHang + "%'"; return(DataAccess.ExcuQuery(sql)); }
static public DataTable SelectKhachHangLikeEmail(KhachHangDTO kh) { string sql = "select * from KHACHHANG where Email like '%" + kh.Email + "%'"; return(DataAccess.ExcuQuery(sql)); }
static public DataTable SelectSachLikeTacGia(SachDTO s) { string sql = "select * from SACH where TacGia like '%" + s.TacGia + "%'"; return(DataAccess.ExcuQuery(sql)); }
static public DataTable SlectSoLuongTon(int masach) { string sql = "select * from SACH where MaSach=" + masach + ""; return(DataAccess.ExcuQuery(sql)); }
public static DataTable GetSachCondition(int SoLuongTon) { string sql = "select * from SACH where SoLuongTon < " + SoLuongTon; return(DataAccess.ExcuQuery(sql)); }
public static DataTable GetTheLoaiAll() { string sql = "select * from THELOAI"; return(DataAccess.ExcuQuery(sql)); }
public static DataTable SelectallHoaDonChiTiet() { string sql = "select * from CHITIETHOADON"; return(DataAccess.ExcuQuery(sql)); }
public static DataTable GetKhachHangAll() { string sql = "select * from KHACHHANG"; return(DataAccess.ExcuQuery(sql)); }
static public DataTable SlectTienNoKH(int makh) { string sql = "select * from KHACHHANG where MaKhachHang=" + makh + ""; return(DataAccess.ExcuQuery(sql)); }
public static DataTable GetPhieuThuCondition(int MaPhieuThu) { string sql = "select * from PHIEUTHU,KHACHHANG where MaPhieuThu = " + MaPhieuThu; return(DataAccess.ExcuQuery(sql)); }
static public DataTable SelectSachLikeMaTheLoai(SachDTO s) { string sql = "select * from SACH where MaTheLoai like '%" + s.MaTheLoai + "%'"; return(DataAccess.ExcuQuery(sql)); }
public static DataTable BaoCaoThang(int thang) { string sql = "select * from BAOCAOTON where Month(NgayPhatSinh) like '%" + thang + "%' "; return(DataAccess.ExcuQuery(sql)); }
public static DataTable GetThamSoAll() { string sql = "select * from THAMSO"; return(DataAccess.ExcuQuery(sql)); }