/// <summary> /// Phuong thuc lay thong tin tat ca danh muc san pham /// </summary> public static DataTable Thongtin_DanhMucSP() { SqlCommand cmd = new SqlCommand("Thongtin_DanhMucSP"); cmd.CommandType = CommandType.StoredProcedure; return(SQLDataBase.GetData(cmd)); }
/// <summary> /// Phuong thuc lay thong tin tat ca nhom san pham /// </summary> public static DataTable Thongtin_NhomSanPham() { SqlCommand cmd = new SqlCommand("Thongtin_NhomSanPham"); cmd.CommandType = CommandType.StoredProcedure; return(SQLDataBase.GetData(cmd)); }
/// <summary> /// Phuong thuc lay thong tin tat ca ChiTietDonHang /// </summary> public static DataTable Thongtin_ChiTietDonHang() { SqlCommand cmd = new SqlCommand("Thongtin_ChiTietDonHang"); cmd.CommandType = CommandType.StoredProcedure; return(SQLDataBase.GetData(cmd)); }
/// <summary> /// Phuong thuc lay thong tin tat ca anh quang cao /// </summary> public static DataTable Thongtin_AnhQuangCao() { SqlCommand cmd = new SqlCommand("Thongtin_AnhQuangCao"); cmd.CommandType = CommandType.StoredProcedure; return(SQLDataBase.GetData(cmd)); }
/// <summary> /// Phuong thuc lay thong tin tat ca danh muc san pham theo MaDanhMucCha /// </summary> /// <param name="MaDanhMucCha"></param> /// <returns></returns> public static DataTable Thongtin_DanhMucSP_By_MaDanhMucCha(string MaDanhMucCha) { SqlCommand cmd = new SqlCommand("Thongtin_DanhMucSP_By_MaDanhMucCha"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaDanhMucCha", MaDanhMucCha); return(SQLDataBase.GetData(cmd)); }
/// <summary> /// Phuong thuc lay thong tin tat ca tai khoan theo TenDangNhap /// </summary> /// <param name="TenDangNhap"></param> /// <returns></returns> public static DataTable Thongtin_TaiKhoan_By_TenDangNhap(string TenDangNhap) { SqlCommand cmd = new SqlCommand("Thongtin_TaiKhoan_By_TenDangNhap"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TenDangNhap", TenDangNhap); return(SQLDataBase.GetData(cmd)); }
/// <summary> /// Phuong thuc lay thong tin tat ca khach hang bang Email /// </summary> /// <returns></returns> public static DataTable Thongtin_KhachHang_By_Email(string Email) { SqlCommand cmd = new SqlCommand("Thongtin_KhachHang_By_Email"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Email", Email); return(SQLDataBase.GetData(cmd)); }
/// <summary> /// Phuong thuc lay thong tin tat ca san pham theo mã sản phẩm /// </summary> /// <param name="MaSP"></param> /// <returns></returns> public static DataTable Thongtin_SanPham_By_MaSP(string MaSP) { SqlCommand cmd = new SqlCommand("Thongtin_SanPham_By_MaSP"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaSP", MaSP); return(SQLDataBase.GetData(cmd)); }
/// <summary> /// Phuong thuc lay thong tin tat ca anh quang cao theo MaNhom /// </summary> /// <param name="MaNhom"></param> /// <returns></returns> public static DataTable Thongtin_AnhQuangCao_By_MaNhom(string MaNhom) { SqlCommand cmd = new SqlCommand("Thongtin_AnhQuangCao_By_MaNhom"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaNhom", MaNhom); return(SQLDataBase.GetData(cmd)); }
/// <summary> /// Phuong thuc lay thong tin tat ca nhom quang cao theo vitri /// </summary> /// <param name="Vitri"></param> /// <returns></returns> public static DataTable Thongtin_NhomQuangCao_By_Vitri(string Vitri) { SqlCommand cmd = new SqlCommand("Thongtin_NhomQuangCao_By_Vitri"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Vitri", Vitri); return(SQLDataBase.GetData(cmd)); }
/// <summary> /// Phuong thuc lay thong tin tat ca san pham theo mã nhóm sản phẩm /// </summary> /// <param name="MaNhom"></param> /// <returns></returns> public static DataTable Thongtin_SanPham_By_MaNhom(string MaNhom, string SoSPHienThi) { SqlCommand cmd = new SqlCommand("Thongtin_SanPham_By_MaNhom"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaNhom", MaNhom); cmd.Parameters.AddWithValue("@SoSPHienThi", SoSPHienThi); return(SQLDataBase.GetData(cmd)); }