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