CN103455482A

CN103455482A - Method for searching product models on SharePoint platform according to parameters

Info

Publication number: CN103455482A
Application number: CN2012101681364A
Authority: CN
Inventors: 徐筱叶
Original assignee: SHANGHAI CHINA SPRING Corp Ltd
Current assignee: SHANGHAI CHINA SPRING Corp Ltd
Priority date: 2012-05-28
Filing date: 2012-05-28
Publication date: 2013-12-18

Abstract

The invention discloses a method for searching product models on a SharePoint platform according to parameters. The method includes the steps: firstly, customizing columns in a SharePoint document library and associating the columns with product model parameters; secondly, acquiring the columns associated with the product model parameters; thirdly, adding text fields to corresponding positions of the columns associated with the product model parameters; fourthly, searching a product model library stored in the SharePoint document library according to input values inputted to the text fields by a customer; fifthly, returning search results. By the aid of the technical scheme, the customer can search the product model library based on the product parameters, search speed is high, keyword search configuration is omitted, and the search results are showed without jumping.

Description

Realize the method for product model parametrization search on the SharePoint platform

Technical field

The present invention relates to a kind of method that realizes the search of product model parametrization on the SharePoint platform.

Background technology

The Microsoft Office SharePoint Server 2007(MOSS2007 released by Microsoft) provide the platform of Content Management, information management and a work cooperation for enterprise.In MOSS2007, the self-service website based on template, can help user's Rapid Establishment portals at different levels; Webpage representation component technology based on Web parts (Webpart) provides for the user ability of organizing fast page function and content.

In the SharePoint document library, for its essence of storage of information, be the database storage, the document that is uploaded to document library all is resolved in the table that then sexadecimal be stored in the WSS_Content database.The SharePoint document library, by the reading and shine upon of WSS_Content database, is crossed the Web interface by the information exchange of database and is presented, and offers the Fileview of user with the B/S browsing mode.When the user inquires about product model, if use the search server that SharePoint carries to be climbed the net search, the memory source accounted for is a lot, and search speed is very slow, and interface is also friendly not, and parameter query product information that can't the product-based model.

Summary of the invention

Technical matters to be solved by this invention is to provide a kind of method that realizes the search of product model parametrization on the SharePoint platform, and the user can pass through the parameter of input product model.

The technical solution adopted in the present invention is: a kind of method that realizes the search of product model parametrization on the SharePoint platform comprises the following steps:

Step 1, carry out self-definedly to the hurdle in the SharePoint document library, make hurdle and product model parameter correlation connection;

Step 2, obtain the hurdle with product model parameter correlation connection;

Step 3, the text input frame is added in the position corresponding on the hurdle with product model parameter correlation connection;

Step 4, the input value according to the client in the text input frame, searched for the product model storehouse be stored in the SharePoint document library;

Step 5, return to Search Results.

After adopting technique scheme, can make the parameter that the user can product-based be searched for the product model storehouse, and search speed is fast, without the keyword search configuration, Search Results is showed without redirect.

The accompanying drawing explanation

Fig. 1 is schematic flow sheet according to an embodiment of the invention.

Fig. 2 carries out realizing the effect schematic diagram before the product model parameter search according to an embodiment of the invention.

Fig. 3 carries out realizing the effect schematic diagram after the product model parameter search according to an embodiment of the invention.

Embodiment

Below in conjunction with accompanying drawing, the present invention is made and further illustrating.

With reference to figure 1.A kind of according to an embodiment of the invention method that realizes the search of product model parametrization on the SharePoint platform comprises the following steps:

Step 1, carry out self-definedly to the hurdle in the SharePoint document library, make hurdle and product model parameter correlation connection.

Hurdle is peculiar object in SharePoint, and it comprises text, option type, numeric type, picture/mb-type etc.Can carry out self-defined modification to document library by the SharePoint hurdle, with storage and the displaying that realizes the document extraneous information.By the extraction of the Specifeca tion speeification to product, the hurdle in the SharePoint document library is carried out self-defined, for example can be by hurdle called after length, external diameter etc., make hurdle realize associated with the parameter of product model.

Step 2, obtain the hurdle with product model parameter correlation connection.

Step 3, the text input frame is added in the position corresponding on the hurdle with product model parameter correlation connection.

Step 4, the input value according to the client in the text input frame, carry out the search based on parameter to the product model storehouse be stored in the SharePoint document library.

Step 5, return to Search Results.If search the product model that the input value with the user is complementary, this product model is returned to the client, otherwise rreturn value is wrong (false).

For realizing parametrization search and the friendly echo plex mode as a result of product model, in a preferred embodiment of the invention, step 2 to step 4 is to realize by the Jquery framework of JavaScrip.In step 4, the inquiry screening washer in SharePoint (query filter) has been called in search.The Jquery framework is the project of increasing income, and has lot of advantages, and for example, very light and handy, size is only less than 30KB; Outstanding DOM operation encapsulation; Abundant plug-in unit is supported etc.In the document library of sharepoint, the parameter container customized by hurdle, carry out the displaying based on hurdle by the product model parameter.Because hurdle is the parameter of exhibiting product, so its type is textual value.By the Edition Contains device network components of sharepoint, the JSP code based on the hurdle search that jquery is write is resolved.Add corresponding text input frame on the page, after capturing the value of client's input, realize the search based on parameter.

In one embodiment, obtaining field by the Jquery framework, to add the main code of text input frame as follows:

$("table.ms-listviewtable tr.ms-viewheadertr").each(function()

{

if($("td.ms-vh-group", this).size() > 0)

{

return;

}

var tdset = "";

var colIndex = 0;

$(this).children("th,td").each(function()

{

if($(this).hasClass("ms-vh-icon"))

{

// attachment

tdset += "<td></td>";

}

else

{

// filterable

tdset += "<td><input type='text' class='vossers-filterfield' filtercolindex='" + colIndex + "' /></td>";

}

colIndex++;

});

var tr = "<tr class='vossers-filterrow'>" + tdset + "</tr>";

$ (tr) .insertAfter (this); //the position of definition search box

});

$("input.vossers-filterfield")

.css("border", "1px solid #7f9db9")

.css("width", "100%")

.css("margin", "2px")

.css (" padding ", " 2px ") //the definition search box

The parametrization function of search of product makes the client to be searched for the product model storehouse based on parameter, by the customization on model bank hurdle, realizes the displaying of product model parameter.As shown in Figure 2, have six fields, respectively: name of product, product IDs, spring inside diameter D1, spring outer diameter D2, spring pitch P and number of coils N.It is spring inside diameter D1, spring outer diameter D2, spring pitch P and number of coils N that Jquery framework by JavaScrip obtains the hurdle be associated with Closed Cylindrical spring product model parameter.Be provided with the text input frame below these four fields.Under the Moulds Based on Three-Dimensional Models storehouse of Closed Cylindrical spring, default storage all Closed Cylindrical class motor springs.When the parameter value of input expectation in the text input frame (in the present embodiment, the parameter of input is that spring inside diameter D1 is 1, spring outer diameter D2 is 2, spring pitch P be 4), the Closed Cylindrical spring model be complementary will carry out showing without redirect.It realizes that effect as shown in Figure 3.

Claims

1. a method that realizes the search of product model parametrization on the SharePoint platform, is characterized in that, comprises the following steps:

Step 2, obtain the hurdle with product model parameter correlation connection;

Step 5, return to Search Results.

2. the method that realizes the search of product model parametrization on the SharePoint platform as claimed in claim 1, is characterized in that, described step 2 to step 4 is to realize by the Jquery framework of JavaScrip.

3. the method that realizes the search of product model parametrization on the SharePoint platform as claimed in claim 2, is characterized in that, in described step 4, the inquiry screening washer in SharePoint has been called in search.

4. the method that realizes product model parametrization search on the SharePoint platform as claimed in claim 1, it is characterized in that, in described step 5, if search the product model that the input value with the user is complementary, this product model is returned to the client, otherwise rreturn value is mistake.