public DataSet DoTaiKhoan1(string user, string pass, string Quyen)
{
return(db.ExecuteQueryDataSetWithPra("dbo.spDoTkQuyen", CommandType.StoredProcedure,
new SqlParameter("@user", user),
new SqlParameter("@pass", pass),
new SqlParameter("@Quyen", Quyen)));
}
public DataSet KiemTraMaDH(string MaDH)
{
return(db.ExecuteQueryDataSetWithPra("spKiemTraMaHDNH", CommandType.StoredProcedure,
new SqlParameter("@MaDH", MaDH)));
}
public DataSet DoMaBH(string MaBH)
{
return(db.ExecuteQueryDataSetWithPra("spDoMaBH", CommandType.StoredProcedure,
new SqlParameter("@MaBH", MaBH)));
}
public DataSet LayThongKeTheoThangNam(int Thang, int Nam)
{
return(db.ExecuteQueryDataSetWithPra("spThongKeChiPhiBanTheoThangNam", CommandType.StoredProcedure,
new SqlParameter("@Thang", Thang),
new SqlParameter("@Nam", Nam)));
}
public DataSet KiemTraMaThahHToan(string MaThanhToan)
{
return(db.ExecuteQueryDataSetWithPra("spKiemTraMaThanhToan", CommandType.StoredProcedure, new SqlParameter("@MaThanhToan", MaThanhToan)));
}
public DataSet InHoaDon(string MaDH)
{
return(db.ExecuteQueryDataSetWithPra("spInHoaDonBanHang", CommandType.StoredProcedure,
new SqlParameter("@MaHD", MaDH)));
}
public DataSet ThongKeSLTheoLoai(string MaLoai)
{
return(db.ExecuteQueryDataSetWithPra("spThongKeSoLuongSPBanRaTheoLoai", CommandType.StoredProcedure,
new SqlParameter("@MaLoai", MaLoai)));
}
public DataSet LayListSanPhamTheoLoai(string MaLoai)
{
return(db.ExecuteQueryDataSetWithPra("spLayListSanPhamTheoLoai", CommandType.StoredProcedure, new SqlParameter("@MaLoai", MaLoai)));
}
// Lấy giá trị HĐ bán hàng
public DataSet GiaTriDonBan(string maHoaDon)
{
return(db.ExecuteQueryDataSetWithPra("spLayGiaTriHDBan", CommandType.StoredProcedure, new SqlParameter("@MaDon", maHoaDon)));
}
// Lấy chi tiết nhập theo mã đơn nhập
public DataSet LayChiTietNhapTheoMaDon(string MaDonNhap)
{
return(db.ExecuteQueryDataSetWithPra("spLayChiTietNhapTheoMaHD", CommandType.StoredProcedure, new SqlParameter("@MaDonNhap", MaDonNhap)));
}
// lấy chi tiết hóa đơn theo mã hóa đơn
public DataSet LayChiTietHDBanHangTheoMaHD(string maHoaDon)
{
return(db.ExecuteQueryDataSetWithPra("spLayChiTietHDBanHangTheoMa", CommandType.StoredProcedure,
new SqlParameter("@MaHD", maHoaDon)));
}
