Sharepoint ECMAScript对象模型系列使用ECMA操作列表项对象(listitem)

最新推荐文章于 2020-06-25 15:15:42 发布

王智强

最新推荐文章于 2020-06-25 15:15:42 发布

阅读量1.2k

点赞数

首先需要在我们的Sharepoint网站上创建一个名为product的list，如下图:

一、添加List Item--新增一个product(Add Product)

< input id ="btnNewProduct" type ="button" value ="Add Product" onclick ='addProduct("AsusLapTop4", "Asus AX44H4 Laptop2", "2011-12-16", "46", "Computer")' />

按 Ctrl+C 复制代码

//If you look a bit closer in the above code snippet you can find that ClientContext.executeQueryAsync
    // takes two function delegates. The first one will be invoked when the ECMAScript get executed successfully. 
    //The second one will be invoked otherwise. The two methods are defined below:

function addProductsuccess() { alert('add Product success'); }
    function addProductfailed(sender, args) {
        alert('failed. Message:' + args.get_message());
    }

</script>

按 Ctrl+C 复制代码

二、删除List Item--删除一个product(Delete Product)

< input id ="btnDeleteProduct" type ="button" value ="Delete Product" onclick ='deleteProduct(1)' />

按 Ctrl+C 复制代码

三、检索List Item--根据ProductID来获取一个product(Get Item By ProductID)

< input id ="btnGetItemByID" type ="button" value ="Get Item By ProductID" onclick ='getProductById(2)' />

按 Ctrl+C 复制代码

function getProductByIdfailed(sender, args) {
        alert('failed. Message:' + args.get_message());
    }

function gotProduct(item) {
        alert("ProductName: " + item.get_item("ProductName") + "\r\ProductDescription: " + item.get_item("ProductDescription"));
    }

</script>

按 Ctrl+C 复制代码

四、查找list Item--在product列表中查找product(search Item By ProductTitle)

< input id ="btnSearchItem" type ="button" value ="Search Item By ProductTitle" onclick ='getProducts("AsusLapTop4")' />

按 Ctrl+C 复制代码

debugger;
    var productcollection;
    function getProducts(title) {
        try {
            var context = new SP.ClientContext.get_current();
            var web = context.get_web();
            var list = web.get_lists().getByTitle('product');

var query = '<View Scope=\'RecursiveAll\'>' + '<Query>' + '<Where>' +
                            '<Contains>' + '<FieldRef Name=\'ProductName\'/>' +
                                '<Value Type=\'Text\'>' + title + '</Value>' +
                            '</Contains>' +
                            '</Where>' + '</Query>' +
                               '</View>';

var query2 = '<View Scope=\'RecursiveAll\'>' + '<Query>' + '<Where>' +
                            '<Contains>' + '<FieldRef Name=\'ProductName\'/>' +
                                '<Value Type=\'Text\'>' + title + '</Value>' +
                            '</Contains>' +
                            '</Where>' + '</Query>' +
                             '<ViewFields><FieldRef Name="ProductName"/><FieldRef Name="ProductDescription"/></ViewFields>';

var query3 = '<View Scope=\'RecursiveAll\'>' + '<Query>' + '<Where>' +
                            '<Contains>' + '<FieldRef Name=\'ProductName\'/>' +
                                '<Value Type=\'Text\'>' + title + '</Value>' +
                            '</Contains>' +
                            '</Where>' + '</Query>' +
                               '</View>';

var camlQuery = new SP.CamlQuery();
            camlQuery.set_viewXml(query3);

this.productcollection = list.getItems(camlQuery);
            context.load(this.productcollection, 'Include(ProductName, ProductDescription, ProductType, LaunchDate, AvailableQuantity)');
            context.executeQueryAsync(Function.createDelegate(this, this.getProductsproductsReceived),
            Function.createDelegate(this, this.getProductsfailed));
        } catch (e) { alert(e); }
    }

function getProductsproductsReceived() {
        // alert('got products');
        var listEnumerator = this.productcollection.getEnumerator();
        prcessProducts(this.productcollection);
        // prcessProducts(listEnumerator);
        //onQuerySucceeded(this.productcollection);

}

function prcessProducts(items) {
        var count = 0;
        var TextFiled = '';
        var ListEnumerator = items.getEnumerator();
        while (ListEnumerator.moveNext()) {
            count = count + 1;
            var currentItem = ListEnumerator.get_current();
            // do something with this here. Coupled with a platform like jQuery, you could do all kinds of great things 
            TextFiled += currentItem.get_item('ProductName').toString();

}
        alert(TextFiled);
        alert(count);

}

function getProductsfailed(sender, args) {
        alert('failed. Message:' + args.get_message());
    }

function onQuerySucceeded(collList) {

var listInfo = '';
        for (var i = 0; i < this.productcollection.length; i++) {
            var oList = this.productcollection[i];
            //listInfo += 'Title: ' + oList.get_title() + ' ID: ' + oList.get_id().toString();
            listInfo += "ProductName: " + oList.get_item("ProductName") + "\r\ProductDescription: " + oList.get_item("ProductDescription");
        }
        listInfo += this.product.length;
        alert(listInfo.toString());

//        var listInfo = '';
        //        var listEnumerator = collList.getEnumerator();
        //        for (var i = 0; i < this.listEnumerator.length; i++) {
        //            var oList = this.listEnumerator[i];
        //            listInfo += 'Title: ' + oList.get_title() + ' Created: ' + oList.get_created().toString() + '\n';
        //        }
        //        while (listEnumerator.moveNext()) {
        //            var oList = listEnumerator.get_current();
        //            //listInfo += 'Title: ' + oList.get_title() + ' Created: ' + oList.get_created().toString() + '\n';
        //            listInfo += "ProductName: " + oList.get_item("ProductName") + "\r\ProductDescription: " + oList.get_item("ProductDescription");
        //        }
        //        alert(listInfo);
    }

</script>

按 Ctrl+C 复制代码

五、更新List Item--更新product(Update Items for a List)

< input id ="btnUpdateItem" type ="button" value ="Update a Product" onclick ='updateProduct(3, "AsusLapTopNew3", "Asus Lap Top New Desc3", "2011-12-18", "100", "Computer") ' />

按 Ctrl+C 复制代码

function updateProduct(productid, productName, productDesc, productLaunchDate, productAvailQty, productType) {
        var context = new SP.ClientContext.get_current();
        var web = context.get_web();
        var list = web.get_lists().getByTitle('product');
        var product = list.getItemById(productid);
        product.set_item('ProductName', productName);
        product.set_item('ProductDescription', productDesc);
        product.set_item('ProductType', productType);
        product.set_item('LaunchDate', productLaunchDate);
        product.set_item('AvailableQuantity', productAvailQty);
        product.update();
        context.executeQueryAsync(Function.createDelegate(this, this.updateProductsuccess), Function.createDelegate(this, this.updateProductfailed));

}

function updateProductsuccess() {
        alert('Update products');
    }
    function updateProductfailed(sender, args) {
        alert('failed. Message:' + args.get_message());
    }

</script>

按 Ctrl+C 复制代码