CN106372987A - Activity display and good selling method data processing device - Google Patents

Abstract

The present invention discloses an activity display and good selling method data processing device, belonging to the culture and sports and e-commerce fields. The activity display and good selling method data processing device is applied to the modern network platforms and websites. Each activity is reported, displayed and live through the modern network platforms and websites such as the Internet, the mobile Internet, the Internet of Things and the like, and the online sale of goods is prompted through the mode of associating with the e-business of the goods and the service. The online buying functions or related links of related goods are immediately supplied for audiences who are passionate when the audiences and net friends are browsing the related information content of the activities with the rhythm and the climax fluctuation of the activities so as to realize online sale of related goods in good time; and moreover, the successful holding of one activity allows the popularity of the website to improve to a new step even reach the target of successfully shaping a famous website so as to greatly improve the social effect of the activity itself and the promoting function of the activity for the economy and consumption, and therefore, the beneficial social effect is very obvious.

Description

A kind of Activity Show and the selling method data processing equipment of commodity

Technical field

The invention belongs to culture and sports and e-commerce field.

Background technology

All kinds of recreation and sports meetings: athletic meeting, match, fair, theatrical performances, all kinds of party, concert, music The activity descriptions such as meeting, art exhibition, trade fair, commodity sales exhibition are shown, are publicized and commodity, service (hereafter referred to collectively as commodity) Sale separately carry out always in the past.Traditional match, the common practice of all kinds of activity are the business that takes money from special interests in activity, by Sponsor advertisements are beaten, by the spreading effect of advertisement and media at the pin realizing dependent merchandise afterwards on site of activity or TV Sell, but As time goes on, the passion of spectators also goes far gradually and progressively weakens, this its shortcoming of traditional mode is activity Disconnect and the climax of spectators, passion and the sale of commodity between, waste the optimal sale opportunity of commodity in vain, simultaneously Promoting with activity the sale of commodity and the effect of social consumption amount can have a greatly reduced quality thus losing many business opportunities, which results in one Its potentiality are not given full play of, with abundant by the waste of kind of social resources at cultural activity aspect of promoting economic development Using all kinds of recreation and sports, social power of influence is promoted with the development sold with social economy of commodity.

Content of the invention

Problem to be solved by this invention is: realizes to all kinds of style meetings, sports meet, match, fair, literature and art The relevant information promotional display of activity and the business such as performance, all kinds of party, concert, concert, exhibition art exhibition, commodity sales exhibition The integrated docking of product ecommerce, using the enthusiasm of site of activity atmosphere and public audience, online friend immediately realize dependent merchandise Line is sold.Herein by website platform carry out activity show publicity, the ecommerce of commodity is all respectively existing ripe skill Art, the present invention be these scattered modules are reconfigured integrated, realize to movable promotional display, report alive and related business The organic integration that the online real-time sale of product is ordered, makes Activity Show combine together or set up with electronic article commercial affairs and associates, and allows sight Many, online friend attends by the climax of activity and the fluctuating of rhythm, spectators also in passion when browsing viewing correlated activation information content When immediately provide the on-line purchase function of dependent merchandise or peer link for it, realize the online pin of dependent merchandise in good time Sell, the success of this activity simultaneously is held and shown that also the popularity of this website being risen to a new height even can reach To the target successfully moulding a famous Web site, this will greatly promote the movable social effect of itself and activity to economic, consumption Pulling function, therefore its beneficial social effect is clearly.The present invention is achieved by following technical scheme.

A kind of Activity Show and the selling method data processing equipment of commodity, are related to a kind of website platform and include movable official Net, e-commerce platform, described activity official website, e-commerce platform include Website server, Database Systems, user client End, the side of holding, merchant client, further relate to a kind of on-the-spot broadcasting module of modern network and the playing module of picture recording video, mutually Networking Sales module, client's registration and login module；Described Website server, Database Systems, subscription client, hold Side or merchant client are connected by the modern network such as the Internet or mobile Internet or Internet of Things；Described e-commerce platform bag Electronic fare payment system containing expense of taking over；Described merchant client comprises uploading information data module, sale and toll administration module, It is characterized in that: this device comprises movable display unit and electronic article commerce arrangement；Movable display unit passes through the Internet, shifting The modern network platform such as dynamic the Internet, Internet of Things, website (hereafter referred to collectively as website) come to report displaying, live all kinds of activity and with Electronic article commerce arrangement is associated:

Association its feature or be of the present invention:

The online sales of commodity are carried out on the promotional display of various activities or live official website simultaneously；Or in activity Set up relevant or parameter transmission between displayed page and each page of e-commerce system, or comprise by following several One of mode or the combination in any between them are realizing: using the advertisement foundation in foreground activity displayed page and advertisement phase The link of the e-business capability of underlying commodity or redirect；On advertisement interface, one ecommerce leading to dependent merchandise of setting is led The boat page or the link at interface (hereinafter referred to as s1 interface) or redirect, realize the electricity with the commodity involved by advertisement in s1 interface Son commercial affairs navigation, online friend clicks on this advertisement and may have access to s1 interface, and the information that online friend clicks on any one commodity in s1 interface is May have access to the information displayed page of this commodity, or also realize the ordering function that places an order online to this commodity；Or in Activity Show The classified navigation mark of ecommerce commodity is set in related pages, and online friend clicks on these classified navigations mark and may have access to accordingly The electronic article commercial affairs navigation interface of classification or the page (hereinafter referred to as s2 interface), online friend clicks on any one commodity in s2 interface Information may have access to the information displayed page of this commodity, or also realize the ordering function that places an order online to this commodity；Or Setting electronic article commercial affairs navigation identification in the Activity Show page, the ecommerce navigation identification that online friend clicks on commodity may have access to This platform electronic article commercial affairs page, online friend passes through this ecommerce page and its related pages can achieve dependent merchandise Retrieve, navigate, browsing, place an order one of shopping etc. or its combination in any；Or in a certain specific Activity Show page setup commodity Ecommerce navigation；Or the ecommerce clearing mark of commodity is set in the page of show activity participant's relevant information Know；

Or it is provided with the data storage processing device of above content, or this dress in the server database system of website Put and also include one of following data processing table or the combination in any between them, or each data processing table field it Between containing corresponding or incidence relation: regular member's registration information record table, movable participant and team's registration registration form, Or above two tables are merged into a table；Notice, notification data log；Movable venue situation information data recording table；Live Dynamic participating agency (comprising the businessman of dependent merchandise) register information log；Movable participating agency (comprising the businessman of dependent merchandise) Qualification picture record table；Campaign item arranges log；Activity schedule information record table；Movable participant's information record table； Movable participating agency and movable participant's basic demand information record table；Games results log；Merchandise news log；Turn round and look at Objective order data log；Website finance turnover day-to-day account log；Mechanism or businessman's finance turnover day-to-day account log；Commonly Member's finance turnover day-to-day account log；Consumer's calling information and disposition data logger；Activity correlation news information Data logger；The pictorial information log related to news；Flow-medium performance listings data information record table etc.；

Or it is provided with Business Portal in movable official website or be provided with businessman's background work space；Or after businessman Upload device or attending device or electronic commerce affair managing device or the financial management of commodity data is comprised in platform work space Device or process customer order's device or process consumer complain device etc.；Or wrap in the Back Administration Module of movable official website Uploading information data device containing commodity or management service device or customer order's managing device or consumer's complaint management dress Put；

Or outside movable official website display platform (abbreviation a module), it is separately provided a commodity online sales module (referred to as B module), b module uses another set of server；By arranging correlated identities on the platform page of movable official website, online friend passes through Click on or select these marks on the platform of official website, the related pages accessing b module carry out browsing or SUBSCRIBE Operation of merchandise news； Or the entrance of movable participating agency and businessman is provided separately；

Or it is provided with one of following data processing table or the combination in any between them in the data base of a module, Or contain corresponding or incidence relation: movable participant and team's registration registration form between the field of each data processing table； Notice, notification data log；Movable venue situation information data recording table；Movable participating agency register information log；Live Dynamic participating agency qualification picture record table；Campaign item arranges log；Activity schedule information record table；Movable participant's letter Breath log；Movable participating agency and movable participant's basic demand information record table；Games results log；Web site activity Project finance passes in and out day-to-day account log；Mechanism's finance turnover day-to-day account log；Movable participant's finance turnover day-to-day account Log；Activity correlation news information data logger；The pictorial information log related to news；Flow-medium performance inventory number It is believed that breath log；Or it is provided with image data storage folder；

Or it is provided with one of following data processing table or the combination in any between them in the data base of b module, Or contain corresponding or incidence relation: ordinary consumer member registration register information record between the field of each data processing table Table；Businessman's register information log of dependent merchandise；Businessman's qualification picture record table of dependent merchandise；Merchandise news log； Client's order data log；Web side E commerce finance turnover day-to-day account log；Businessman's finance turnover day-to-day account log； Consumer member finance turnover day-to-day account log；Consumer's calling information and disposition data logger；Or it is provided with Image data storage folder；

Or it is that activity special show space is set up in this activity in third party website, mainly show in this special show space This activity and its related content or the electronic commerce affair content going back display of commodity, or by special show page space set up with The access relation of the ecommerce of commodity, or the online sales of commodity are realized by special show page space, or in activity special show The commodity classification navigation identification of ecommerce is set in the page of space correlation, or online friend clicks on navigation identification therein Access the ecommerce related interfaces in commodity or the page；

Or by the displaying of movable dependent merchandise and sell the general goods online sales device including third party website, and it is Online friend can be differentiated when browsing merchandise news for the correlated identities of its setting activity in the merchandise display on foreground, or provides logical Cross the device of these commodity of keyword retrieval of activity correlation or the retrieval device of offer activity correlation to retrieve commodity, or and then Realize the online sales to commodity；Or in electric business platform, setting action message shows that mark is linked with outer, is linked to this activity The website shown is shown with the information realizing activity description；Or the show area of setting activity Related product, online friend is by browsing this The information of commodity or related commodity can be found using to the function of search of movable dependent merchandise etc. in individual show area, or and then Realize online ordering；

The activity of the present invention comprises: one of recreation and sports, commodity sales exhibition, trade fair etc. or theirs is any Combination；Described recreation and sports comprise various style meetings, sports meet, match, fair, theatrical performances, various evening One of meeting, concert, concert, culture and arts exhibition etc. or their combination in any；

The commodity bundle of the present invention contains common tangible physical commodity, intangible goods, all kinds of service etc., but event ticket is removed Outward；

The movable official website of the present invention refers to that authority's report is shown the website of this action message content or sponsored by activity Side or undertaker sponsors or its entrusted agent sponsors or is mainly used in showing the website platform of this action message content.

Its feature of movable dependent merchandise of the present invention or be: this commodity and activity have certain and associate but be not Event ticket, its correlation form or comprise following one of all kinds of or their combination in any: or its line relevant with activity description Upper exhibition method is in same category, the commodity of same industry and movable participant with movable related commodity or with activity The related commodity of member, can be used for activity during the commodity of consumer spending and campaign owners or undertaker related Commodity and the movable related commodity of sponsor and the related commodity of walking advertisement, showed in movable official website Commodity of the correlated identities or website contacting such as establish the link, redirect, showing commodity of sale etc. in platform with official website

Above solution can be illustrated by following example on more more one step ground:

Scheme one

The former promotional activities that online displaying Sales module with movable dependent merchandise is directly integrated into movable official website are shown In plateform system, form a kind of comprehensive service platform showing the online sales driving dependent merchandise with promotional activities, comprise: be flat The activity related content promotional display module on platform foreground, dependent merchandise display module, the module that places an order, payment and settlement module, spectators The order management module (watch order situation for consumer and the function such as complain, return goods) on foreground, spectators, the registration of online friend Login module, businessman enter entrance, businessman's back-stage management space, website operation side back-stage management space etc., and the present invention will solve Problem certainly is how to carry out being integrated to form a new synthesis system by the e-commerce module of this Activity Show module and commodity System, detailed in Example one.

When being embodied as, first design site home page, the top a line be used for arrange the relevant news picture in this website and Link, second largest row is used for arranging the navigation identification of each sub-module and linking, the third line is used for arranging search in Website function, below All kinds of navigation identifications are placed on the left side of each row, start the content relevant with activity for category tissue distribution arrangement from fourth line Title is made a summary or the linking of the picture character of the living broadcast of programs that will carry out etc. or multimedia messages and its detailed content, or phase The information of underlying commodity is shown and navigation feature.Commercial advertisement element and commodity electric business is added in movable official website display platform Clearing mark and its link, the data of dependent merchandise and ecommerce content, simultaneously to improvement of matched data base etc..

The information setting up activity related content in the platform desk module of official website shows and the publicity page have the two schemes can Selective；

The first selects the mode of static page, in advance related content is directly placed in the page, i.e. the display of the page Content just together completes when designing the page, and the advantage of this mode is easy for the page is carried out artistic technique, obtains preferably Artistic Render effect, shortcoming is later maintenance inconvenience, need to be operated by professional and technical personnel；

It two is using dynamic web page scheme, carries out Frame Design to the displayed page of relevant information in advance, designs and needs The typesetting scheme of displaying promotional content is putting position and size, and arranges picture control or character area in relevant position, so Afterwards related data is retrieved from server and data base formation data set (or data source, hereafter referred to collectively as data set, phase Close data, after software development successfully issues operation, back-end data upload device passed through by staff and uploaded), then by number Carry out dynamic binding according to the field concentrated with corresponding picture control or character area, when there being the mass data of identical category, Also need it is carried out multiple data and repeat display design, the advantage of this method is that website later maintenance is not required to software developer behaviour Make, common staff can be competent at therefore more convenient, simultaneously by entering to activity data such as picture, multi-medium data in advance Upload again after row art processed and also can reach more satisfactory rendering effect；

Set up matched data base and the picture corresponding to setting related data, multi-medium data are deposited in the server Storage file, the tables of data of setting record corresponding data information in data base；When website is run, by undertaker staff Or preprepared action message data is included the content uploadings such as picture, word to server database by software developer ?；Foundation activity participating agency, personnel's registration and examination ＆ verification managing device, first foreground subscription client arrange participating agency, Personnel's registration entrance and operation interface, allow user fill in setting registration information, are then uploaded to Platform Server number by network According to storehouse and arrange registration result feedback interface, undertaker staff or webmaster personnel pass through portal management backstage, enter registration In work management module, with personnel, title examination is carried out to the mechanism of registration, register successfully to arrange to satisfactory giving, right Undesirable beaming back again is registered and is given reasons；

The related service of setting activity, the order module that places an order of commodity.In website front end, one ordering page that places an order is set, The page comprises: the data information content such as the lot-size of commodity, time, the amount of money, consumer identification information or contact details And submitting button；

Setting activity participating agency and dependent merchandise businessman stage door and work space, make them empty in respective work Between in complete its corresponding work.As movable participating agency need to arrange submission, registration and the management function of related data, businessman's work Make upload and maintenance, electronic commerce affair and financial management, process customer order, the process needing in space to arrange commodity data The functional modules such as consumer's complaint.

Setting portal management background module, comprises activity description information and the data of related warm up content uploads and number According to maintenance module, safeguard and include the editor to data and change, again upload etc., about bulletin, issue of notice etc.；Activity ginseng Plus the registration management module of mechanism and participant；The data of logistics support situation uploads and maintenance module, and service, related business The uploading information data of product and management service module；Customer order's management module；Consumer's complaint management module etc..

Scheme two

Using concurrent development technology, outside movable official website display platform (hereinafter referred to as a module), individually develop a phase The online sales module (hereinafter referred to as b module) of underlying commodity, b module is used alone a set of server space and data base, passes through Online sales navigation identification and the external connecting of dependent merchandise are arranged on the platform page of movable official website, is connected to the interconnection of b module On net ip address, by above sale navigation identification is clicked on the platform of official website, jump to the corresponding function of this b module Page browsing dependent merchandise the SUBSCRIBE Operation that carries out placing an order, the data related to ecommerce uploads and is also uploaded directly into this b In the server database of module.The advantage of this scheme is that the Activity Show system before movable official website can be completeer Site preparation remains, and only does little change, the operation of b module newly developed substantially not the operation to former official website produce too Big impact, reduces the development difficulty of whole system cost-effective simultaneously.

Scheme three

Third party website is this activity sets up the virtual shop of special events or active web pages special show space, by this Special show space realize again to the related commodity of activity and the original ecommerce in website system link with integrated；This scheme ratio It is more suited to the situation of various medium and small shape activities, the Website development operator that thing is transferred to specialty does.

Scheme four

The displaying of Activity Show and dependent merchandise is processed as the general service of third party website with selling, simply Plus activity mark in the attribute of the commodity data related to activity, and for the pass having activity in the displaying of the commodity on foreground Connection mark, or allow the key word that online friend passes through activity correlation can retrieve these commodity, thus realizing the sale to this commodity.

Specific embodiment

The specific embodiment that the following is the present invention is further described to technical scheme, in order to become apparent from Illustrate the spirit of the present invention, but the present invention is not limited to these embodiments.

Embodiment one is set up promotional activities in movable official website simultaneously and is shown the ecommerce with dependent merchandise.

Due to there is independent promotional activities display platform and e-commerce platform in the prior art, the present invention will The thing done is exactly to carry out integrated becoming a new comprehensive platform or website reaches simultaneously by this two independent platforms To the movable online real-time sale showing publicity and dependent merchandise.The content relating generally to includes: movable official website data base's Integrated design, and set up the relation between relevant parameter；Foreground each Activity Show page and the page of ecommerce related content Integrated with couple and increase Business Portal function；Businessman's background work space is set up in movable official website.It is exactly specifically:

Design matched movable official website data base first, set up in data base and comprise the tables of data of following content: Regular member registers information record table, and it is entitled to arrange corresponding head portrait picture data storage folders in the server Fpo file；Movable participant's registration registration form；Notice, notification data log；Movable venue situation information data recording Table, and set up the file hos file of storage picture concerned or multi-medium data in the server；Movable participating agency (bag Businessman containing dependent merchandise) register information log；Movable participating agency (comprising the businessman of dependent merchandise) qualification picture record Table, and the entitled dpp file of corresponding head portrait picture data storage folders is set in the server；Campaign item setting record Table；Activity schedule information record table；Movable participating agency and movable participant's basic demand information record table；Games results are remembered Record table；Arrange corresponding commodity picture data and deposit to the related online sales merchandise news log of activity and in the server Storage file pgoods file；Client's order data log；Website finance turnover day-to-day account log；Movable participating agency (businessman containing dependent merchandise) finance discrepancy day-to-day account information record table；Regular member's finance turnover day-to-day account log；Consumption Person's calling information and disposition data logger；Activity correlation news information data logger simultaneously arranges related in the server The image data storage folder newsp file pictorial information log related to news, flow-medium performance listings data letter Breath log simultaneously arranges program subject matter image data storage folder lmtp file in this Platform Server, and Streaming Media number According to storage folder lmtm file or outside this platform setting stream medium data storage server and its file (more favourable In raising reliability and security) etc..Programme and the peer link of streaming media playing.Wherein:

Regular member's registration information record table is named as al table, including at least data below record field: aid herein Field is the numbering of pieces of data record is this table major key hereinafter referred to as member registration account number, and an is used for recording member names, Csort field is used for recording the country origin at member place；Atel field is used for recording the telephone number of member；Addr is used for record meeting The home address of member；Fpoto field is used for recording member's head portrait picture address, and its picture leaves server corresponding picture number in According in storage folder fpo file；Sex field is used for recording the gender information of member；And some other is used for record meeting Field of member's identity and relevant information etc..

Movable participant and team's registration registration form are named as aj table, including at least data below record field: jid word Section is this table major key for the numbering of pieces of data record, and an field is used for the Real Name of record registration people, and ana is used for record report The occupational title of famous person such as stage name etc., the member registration account number correspondence that aid field is used for recording this registration personnel is associated with a1 table Aid field；Jsort field is used for recording the classification of activity；Utime field is used for recording the registration time；Jc1 field is used In the record explanation to correlation circumstance for the entrant；Fs field is used for record management personnel's auditing result；Jc2 field is used for record pipe Reason personnel's audit opinion situation explanation；M1 field is used for recording registration fee pays number；Mt1 field is used for recording registration fee to be paid Time；M2 field is used for recording the functional expenses number of its payment of activity management direction；Mk2 is used for recording reimbursement of expense situation and says Bright；Fid field is used for recording team's numbering that this member is subordinate to, corresponding to the jid field of team's record of this table, 0 expression This is recorded as team's record, and other data represent the team member of jid team.

Or above aj table and a1 table are merged into a table.

Notify, notification data log is named as a2 table, including at least data below record field: vid field is each bar The numbering of data record is this table major key；Cont field is used for the particular content that record notifies, notices；Tp field is used for recording this The brief title of bar record；Utime field is used for recording this information uplink time.

Movable venue situation information data recording table is named as hosed table, including at least data below record field: hid Field is the numbering of pieces of data record is this table major key；Cont field is concrete to movable venue in this record for recording Explanatory note content；Imag field is used for recording the storage address information of involved image data in this record, its figure Sheet data is stored in server corresponding store files folder hos file；H field be used for recording this article of record be attached to that Article one, No. hid of record, 0 represents that this is recorded as the first i.e. first bar record of such venue.

Movable participating agency (businessman comprising dependent merchandise) register information log is named as dep table, including at least with Lower data entry fields: did field is the numbering of pieces of data record is this table major key；Dnam field be used for recording this mechanism or Merchant name；Csort field is used for recording the country origin at this mechanism place；Pname field is used for recording the master of this mechanism or businessman Want director's name；Ptel field is used for recording the telephone number of this director；Cname field is used for recording this mechanism or businessman Working relation people's name；Ctel field is used for recording the telephone number of this contact person；Addr is used for recording home address；cont Field is used for the record registration brief information explanation to this mechanism or businessman for the people.

Movable participating agency (businessman comprising dependent merchandise) qualification picture record table is named as depp table, including at least with Lower data entry fields: pid field is the numbering of pieces of data record is this table major key；Did field is used for recording this data Affiliated mechanism registers No. id, and correspondence is associated with the did field of dep table；The picture that image field is used for recording this record is deposited Storage address, its image data correspondence is stored in the dpp file of server；When utime field is used for recording the upload of this information Between.

Campaign item setting log is named as item table, including at least data below record field: iid field is each bar The numbering of data record is this table major key；Iname field is used for recording the title of campaign item；Isort is used for recording active entry Classification belonging to mesh.

Activity schedule information record table is named as doitem table, including at least data below record field: did field is each The numbering of data record is this table major key；Iid field is used for recording this activity schedule information and is under the jurisdiction of that activity, corresponding It is associated with the iid field of item table；Cont field is used for recording movable concrete arrangement information；Utime field is used for recording this Information uplink time.

Movable participant's information record table is named as jdo table, including at least data below record field: jdid field is The numbering of pieces of data record is this table major key；The concrete activity sequence number that did field record activity participant is participated in, corresponding The did field of doitem table, the registration number of jid field record activity participant, corresponding to the jid field of aj table, uptime Field is used for record data uplink time, and k field is used for the online sales function whether record opens dependent merchandise, and 0 table is not opened Logical, 1 table is open-minded.

Movable participating agency and movable participant's basic demand information record table are named as clai table, including at least following Data entry fields: cid field is the numbering of pieces of data record is this table major key；Cont field is used for recording specific requirement letter Breath；Utime field is used for recording this information uplink time；Csort field is used for recording this and requires generic.

Games results log is named as mresult table, including at least data below record field: mid field is each bar The numbering of data record is this table major key；Iid field is used for recording sports events id belonging to achievement, and correspondence is associated with table item The iid field of table；The players numbering correspondence that jid field is used for recording belonging to achievement is associated with the jid field of table aj table；c Field is used for recording the achievement of this match；Utime field is used for recording this information uplink time；Mtime field is used for remembering Record the fixture of this games results.

Merchandise news log is named as goods table, including at least data below record field: gid field is each bar number Numbering according to record is this table major key；Gname field is used for recording trade name；Gsort field is used for recording the classification of commodity； The measurement unit information of selling that qa field is used for recording commodity is such as measured with " part "；Qb field is used for recording the metering rule of commodity Lattice, such as 2 every；Uprice field measures unit price for recording selling of commodity；Image field is used for recording commodity picture ground Location information, its image data is stored in the pgoods file of server database；Maddr field is used for recording the product of commodity Ground information；Qs field is used for recording the credit rating information of commodity；Did field is used for recording the businessman id belonging to this commodity, Correspondence is associated with the did field of dep table；K field is used for recording the added distribution state of this commodity, is divided into added sale, undercarriage For sale；Flag field is used for recording the management examination ＆ verification state of this commodity, is divided into pending trial to be represented with 0, has passed through examination ＆ verification and represented with 1, Do not pass through examination ＆ verification to be represented with 2, three kinds of states；Fk field is used for recording the movable participant's registration number associated by this commodity, right Should be in the jid field of aj table.

Client's order data log is named as dean table, including at least data below record field: nid field is each bar The numbering of data record is this table major key；Gid field is used for recording the commodity id corresponding to this order, and correspondence is associated with goods The gid field of table；Oprice field is used for recording this single conclusion of the business unit price (unit is: RMB￥/part)；Q field is used for remembering Record conclusion of the business quantity (unit is: part)；Sprice field is for recording the freight charges that this singly be should bear；Qa field is dealt with always for record Through volume；Qb field is used for recording the actual payment amount of consumer；K is used for recording consumer's payment status, be divided into unpaid, do not close, Pay off；Kp field is used for recording the condition of delivery of this order, is divided into non-shipment, shipped, consumer signs for；Sp field is used In the acknowledgement of consignment enterprise name recording this order goods, spid field is used for recording the acknowledgement of consignment Air Way Bill No. of this order commodity；Tona word Section is used for recording this order addressee's name；Toaddr field is used for recording addressee's better address；Totel field is used for recording Order addressee's phone；Tocode field is used for recording the on-site postcode of addressee；Cs field is used for recording addressee ground institute Country origin；Sen field is used for the province being located with recording addressee；Si field is used for the prefecture-level city being located with recording addressee； Xian is used for the district being located with recording addressee, and xi field is used for township, the street being located with recording addressee.Utime field is used for Record placing an order the time of this order；Otime field is used for recording the ETCD estimated time of commencing discharging that of this order, and btime field is used for recording this to be ordered Single receive me sign for the time.

Website finance turnover day-to-day account log is named as ac table, including at least data below record field: acid field Numbering for pieces of data record is this table major key；Nid field is used for recording corresponding order number during income, corresponding association In the nid field of dean table, qid field is used for recording No. id from other items during income；Csort field is used for recording The classification information of income item；Qa field is used for recording income number；Qo field is entered an item of expenditure in the accounts number for record；Cont field is used for Record the item explanation of this record；Aid field is used for record and occurs regular member's registration account number of this business to correspond to al The aid field of table；Did field is used for mechanism or the businessman's registration number that record occurs this business, corresponding to the did word of dep table Section；Utime field is used for recording time of origin.

Mechanism or businessman's finance turnover day-to-day account log are named as dac table, including at least data below record field: Did field is the numbering of pieces of data record is this table major key；Nid field is used for recording into corresponding order when entering an item of expenditure in the accounts Number, correspondence is associated with the nid field of dean table, qid field be used for recording into when entering an item of expenditure in the accounts from No. id of other items； Csort field is used for recording the classification information into item of entering an item of expenditure in the accounts；Qa field is used for recording income number；Qo field is used for recording out Account number；Cont field is used for recording the item explanation of this record；Aid field is used for the common meeting that record occurs this business Member's registration account number corresponds to the aid field of a1 table；Did field is used for mechanism or the businessman's registration number that record occurs this business, Did field corresponding to dep table；Utime field is used for recording time of origin.

Regular member's finance turnover day-to-day account log is named as aac table, including at least data below record field: cid Field is the numbering of pieces of data record is this table major key；Aid field is used for recording the registration account number of this member, and correspondence is associated with The aid field of al table, nid field is used for recording into corresponding order number when entering an item of expenditure in the accounts, and correspondence is associated with the nid word of dean table Section, qid field be used for record into when entering an item of expenditure in the accounts from No. id of other items；Csort field is used for recording into item of entering an item of expenditure in the accounts Classification information；Qa field is used for recording income number；Qo field is entered an item of expenditure in the accounts number for record；Cont field is used for recording this note The item explanation of record；Utime field is used for recording time of origin.

Consumer's calling information and disposition data logger are named as dosu table, including at least data below record word Section: sid field is the numbering of pieces of data record is this table major key；Aid field is used for recording complainant member id, corresponding association Aid field in a1 table；Bid field is used for recording the registration id of defendant；Cont field is used for recording complaint； Cimage field is used for record and complains evidence picture address information, sets up a complaint evidence picture in Platform Server simultaneously Data storage folders dosu file, the evidence picture that consumer submits to when complaining will be uploaded storage here；contb Field is used for recording the measure that defendant replys complainant and solves dispute；Contm field is used for recording portal management side Handling suggestion；Ba field is used for recording the information record whether complainant is satisfied with to result；Fb field is used for record and is thrown Whether the side of telling is processed, and 0 table is untreated, and 1 table is treated；Fbtime field is used for recording defendant's process time of origin；fm It is endlessly treated that field is used for recording portal management side, and 0 table is untreated, and 1 table is treated；Fmtime field is used for recording net Station administration side processes time of origin, and f field is used for whether the complaint of minute book bar is disposed and winds up the case, 0 table present, and 1 Table has been disposed and has wound up the case, and to be controlled the renewal of this field information of this record by portal management personnel.

Activity correlation news information data logger is named as news table, including at least data below record field: nid word Section is this table major key for the numbering of pieces of data record；Cont field is used for recording news content；Image field is used for recording newly Hear the picture address of subject picture, its image data is stored in the newsp file of server；Utime field is used for recording Data uplink time, upid field is used for recording uploader member No. id；Usort field is used for recording the identity class of uploader Not；F field is used for the audit logging of record management personnel, and 0 table is not audited, and 1 table passes through examination ＆ verification, and 2 tables could not be by examination ＆ verification.

The pictorial information log related to news is named as cnews table, including at least data below record field: pid Field is the numbering of pieces of data record is this table major key；Nid field is used for recording this news picture to the theme news being subordinate to Id, corresponding to the nid field of news table；Cont field is used for the record news narration explanation related to picture；Image field is used In the picture address of record news picture, its image data is stored in the newsp file of server；Utime field is used for Record data uplink time, upid field is used for recording uploader member No. id；Usort field is used for recording the identity of uploader Classification；F field is used for the audit logging of record management personnel, and 0 table is not audited, and 1 table passes through examination ＆ verification, and 2 tables could not be by examination ＆ verification.

Flow-medium performance listings data information record table is named as lmt table, including at least data below record field: mid Field is the numbering of pieces of data record is this table major key；Cont field is used for recording flow-medium performance inventory information；Caddr uses In record stream medium data storage address, stream medium data storage folder lmtm file is set in Platform Server simultaneously Folder；Image field is used for recording flow-medium performance subject picture address, and its image data is stored in the Streaming Media of Platform Server Subject picture storage folder lmtp file；Have two schemes a kind of is exactly that the above content of this table is arranged in platform herein On server and data base；Another kind of is exactly that this table and its corresponding stream medium data storage folder are arranged in another clothes So as to be physically isolated with Platform Server on business device, to reduce Platform Server load thus improving platform reliability, The client setting program navigating mark of Platform Server is linked with outer, and online friend accesses these stream matchmakers by clicking on navigation identification Body programme content.

The page of foreground each Activity Show page and ecommerce related content is integrated and reality that increase Business Portal function Existing:

The realization of Business Portal function: one businessman or organization are set in the Activity Show homepage appropriate position on foreground Entrance mark and the link leading to entrance navigation page, online friend clicks on this entrance mark, you can access the navigation leading to entrance The page (or interface), comprises in this navigation page (or interface): new mechanism registers mark and link and I am to be logged in Mark or link, need to select to click on " new mechanism registration " mark for unregistered businessman, go to the institute registration registration page to enter Row registration, the mechanism for registered registration or businessman need to select the mark clicking on " I will log in " to go to login page to step on Record enters respective work space.Each activity participates in mechanism or businessman's work space of dependent merchandise broadly falls into prior art, no It is the technical problem to be solved, the technical problem to be solved is by the data money of mechanism or businessman herein Material integrates, and the present invention solves front, will this this data information unified by the dep tables of data of data base to store with Process, each mechanism or businessman are managed by the value that its registration number is did field.

E-commerce system due to Activity Show platform and commodity is prior art, and this place is in this two existing skills On the basis of art, this two sets of system integrations are linked up.

First with prior art, the Activity Show homepage of traverser and related displayed page are designed, simultaneously flat In platform, each page of the e-commerce module of commodity is also designed, due to there being aforementioned data association and the integrated data realized Storehouse, foreground function collection achievement herein has excellent basis and realizes condition, herein need to be in Activity Show homepage and electronics business Set up incidence relation between each page of business module and the transmission of corresponding parameter recycles data retrieval technology expected to reach Integrated result, its implementation includes following several ways:

1st, using the collection of the advertisement foundation in foreground activity displayed page and the e-business capability of advertisement dependent merchandise Become, implementation method is the dynamic page of ecommerce navigation or the interface that dependent merchandise is led in setting one on advertisement interface The link at (hereinafter referred to as s1 interface), realizes the ecommerce navigation with the commodity involved by advertisement, Wang Youdian in s1 interface Hit this advertisement and may have access to s1 interface, the arbitrary commodity sign in online friend's click s1 interface or brief information show that block can redirect To the details displayed page of this commodity, and and then realize the ordering function that places an order online to this commodity.Key herein exists Coupling between the advertisement in the Activity Show page and the e-business capability of corresponding goods is the realization at s1 interface and is counting Have with advertisement according to the field record guaranteeing or increasing a record ad data feature in the commodity data log goods table in storehouse The data characteristicses closed, are illustrated with an example below, and such as advertisement herein is the advertisement beaten for certain sponsor, and this sponsor exists No. id of this platform registration is 200 (corresponding to the did fields of the dep table of platform database), and we are just located at s1 interface Affiliated for this businessman commodity will be met the commodity data of added requirement from the merchandise news log goods table of data base by the page It is retrieved the dynamic data forming data set (as being named as dataset2 herein) and then carrying out video data in display interface Bind, the key code of its data set retrieval is:

Select*, (' pgoods/ '+image) as rface_image from dbo.goods where pid=@pid The added sale of and k=' ' and flag=1

Wherein@pid is the registration id of this businessman passing over when front advertising page redirects, the added sale of k=' ' represent This commodity processes added sale state, and flag=1 represents that this commodity is audited it is allowed to sell by portal management personnel.

Then design the data display at s1 interface: at navigation interface display location, first insert the table of string several rows Lattice, insert a picture control in the first row for display of commodity image picture, are used for showing in the second row and following a few row Commodity important information, the such as information such as trade name, price, then by the picture control of the data field in data set and display or Display location carry out data bind and formed a display unit block display content as at picture setting one lead to this commodity Details page (as the detail.aspx page) link, then this cell block is carried out multiple data repeat display design , what it designed realizes code schematically as follows:

The 2nd, the classified navigation mark of ecommerce commodity is set in Activity Show related pages, and online friend clicks on these classification Navigation identification can jump to electronic article commercial affairs navigation interface or the page (hereinafter referred to as s2 interface) of respective classes, Wang Youdian Hit the arbitrary commodity sign in s2 interface or brief information shows that block can jump to the details displayed page of this commodity, and And then realize the ordering function that places an order online to this commodity.Its implementation is to arrange one towards next to each class indication The s2 interface of the navigation identification dynamic page of universal classification navigation, the sorting parameter of different class indication transmission is different, to this The implementation at s2 interface is that s1 skins are essentially the same with the navigation dynamic interface of above-mentioned advertisement, and different is page The retrieval key code of face data set is different, and search key herein comprises the classification of commodity, and its code is:

Select*, (' pgoods/ '+image) as rface_image from dbo.goods where gsort=@ The added sale of gsort and k=' ' and flag=1

Wherein gsort is the classification parameter of the commodity classification passing over from prevpage face, and remaining is ibid.

3rd, setting electronic article commercial affairs navigation identification and its link in Activity Show homepage, online friend clicks on the electronics of commodity Commercial navigation identification can jump to this platform electronic article commercial affairs homepage, is provided with complete in this ecommerce homepage Electronic article business function, such as search in Website, commodity classification navigation, commodity classification show etc., online friend passes through this commodity electricity Business's homepage and its related pages can achieve dependent merchandise retrieval, navigate, browse, place an order shopping.

4th, in the ecommerce navigation feature of a certain specific Activity Show page setup activity participant's dependent merchandise, Realize the online sales with movable participant's dependent merchandise.As, on a certain theatrical items displayed page, arranged this program Sale shown online by the commodity that middle correlation performer star represents；And for example in the website of a certain athletic competition activity, in a certain tool The athlete taking part in game is set in the event information displayed page of body and represents online displaying sale of commodity etc..It is realized Method be in the concrete displaying interface of this activity the related electronic article commercial affairs navigation identification of setting activity participant and Link, online friend clicks on the navigation interface that these navigation identifications may have access to the related commodity online sales of this movable participant (hereinafter referred to as s3 interface), the merchandise news clicking on correlation in s3 interface may have access to the details displayed page of this commodity And and then realize the order that places an order online to this commodity.This sentences as a example certain star's floor show displayed page concrete in addition more Further instruction: navigation identification and the chain that this star represents commodity is set in the page of the displaying of this programme information or broadcasting Connect as " checking the commodity that so-and-so likes, recommends ".Wherein " so-and-so " this information can adopt data binding scheme with reality Existing multiple similar interfaces share the effect at an interface, Static Design may also be employed, be directly placed on this star's name Herein and arrange link the identity information of this personnel such as registration number is transmitted as parameter, different mouthpieces need to set respectively Put the different pages to realize.The implementation method of data binding scheme herein: first the identity of movable participant is believed Breath such as name, registration number is retrieved formation data set from data base:

Select ana, jid from dbo.aj where jid=(select jid from dbo.jdo where did =@did)

Wherein did is this concrete activity registration number passing over from prevpage such as navigation page, corresponding to table doitem table did Field.

Then the ana field in data set is carried out data binding in so-and-so name display location, and in display field Setting one is led to the link of electronic article commercial affairs navigation page and is passed on the jid parameter of this personnel.Online friend clicks on During this mark, you can accessing the electronic article commercial affairs navigation page related to this star is s3 interface, and it is bright to represent this The registration id of the parameter of star identity such as this star passes over, and this s3 interface is essentially identical with aforementioned s1 interface, and online friend clicks on Related commodity picture can view details and then the order that places an order of this commodity.Difference is electronics business herein In business navigation interface, the retrieval coding of the commodity data information of display is different: the key word of its retrieval comprises this star's identity ginseng Number, the key code that this sentences its retrieval as a example its registration number is:

Select*, (' pgoods/ '+image) as rface_image from dbo.goods where fk=@jid and The added sale of k=' ' and flag=1

Wherein jid is the jid field that the movable participant's registration number passing over from prevpage face corresponds to aj table, remaining Ibid.

If there being the several online sales demands with dependent merchandise in the personnel of participation activity, also can achieve several activities The online sales of personnel's dependent merchandise, implementation with aforementioned single difference less, simply represents commodity in this star of setting Navigation identification at changed, will the former mark showing a movable participant be changed to show multidigit personnel's Mark and link, need to carry out to display mark many that Data duplication shows design herein on aforesaid basis, distinguish simultaneously The transmission corresponding personnel identity information parameter of each mark such as jid to s3 interface be can achieve and is connected with the effective of aforementioned schemes, connects The function of going down is just the same with aforesaid.

5 or be in the page of show activity participant's relevant information arrange dependent merchandise ecommerce navigation Mark and link, online friend clicks on ecommerce navigation page or the interface that dependent merchandise navigation identification may have access to dependent merchandise (hereinafter referred to as s4 interface), its implementation has: the first arranges one in movable participant's overview display page and leads to The mark of this platform clectronic commercial affairs homepage and link, online friend clicks on this mark and can go to this platform clectronic commercial affairs homepage Face, online friend can find content and dependent merchandise and then the order that places an order of oneself needs by this electric business homepage；Another Plant the electronics business that implementation method is the dependent merchandise arranging this personnel in the page of show activity participant's details Business mark and link, online friend clicks on the ecommerce navigation page that this mark may have access to the dependent merchandise with regard to this personnel I.e. s4 interface, and s4 interface is essentially identical with aforementioned, its implementation is essentially identical with aforesaid s1, is not repeated to chat herein State.

Embodiment two

Using concurrent development technology, outside former activity official website display platform (hereinafter referred to as a module), individually exploitation one Online sales module (hereinafter referred to as b module) with regard to dependent merchandise, b module is used alone a set of server space and data Storehouse, its foreground display interface adopts the scheme basically identical with embodiment one, by arranging phase on the platform page of movable official website The online sales navigation identification of underlying commodity with couple (simply here be linked as outer link), be connected to the Internet ip of b module On address, by above online sales navigation identification is clicked on the platform of official website, then branch to the module of this address The page of corresponding function carries out goods browse and associative operation, and simultaneously related to ecommerce data uploads and is also uploaded directly into In the server database of this b module.Compare from scheme one and different essentially consist at following 2 points:

The mechanism on movable official website foreground for the one or Business Portal mark should be divided into two and be divided into movable participating agency and enter Mouth and Business Portal two mark, by the inlet function of Liang Lei mechanism separately, the entrance of movable participating agency adopts interior connection, and The entrance of businessman adopts external connecting, is connected to the Login Register navigation interface in b module by the ip address in the Internet, guiding Businessman is registered in b module or is carried out register, and the data of its registration is also the data being submitted to b module In storehouse.

Its two be in the related pages on movable official website foreground setting the e-commerce platform being connected to dependent merchandise Mark and link, will be changed to outer link by the interior connection of embodiment one, and the displaying scheme on its foreground are basic with embodiment one Unanimously, the data connection of its foreground correlation function, adopts connection b module during the business being related to ecommerce commodity online sales Server database, then couples data base's (interior connection) of a module, simultaneously when remaining is with regard to Activity Show related content Here it is also noted that will resolve during Website development between the data base's design to two server databases and each data Related question, its solution is described as follows:

Need for the data logger of the data base in scheme one to be divided into two groups, be respectively used to a module b module i.e. in a, b It is respectively provided with corresponding data logger in module, wherein has part data logger that table is divided into two, respectively in a, b two mould Be provided for recording the related data information in this module in block simultaneously and in particular to comprise: movable participating agency registration Information record table, website finance turnover day-to-day account log ac table, mechanism or businessman's finance turnover day-to-day account log are named as Dac table, the accounts of finance turnover data logger of individual member are that aac table is divided into aac1 table and aac2 table etc..Wherein activity ginseng Plus mechanism's (comprising the businessman of dependent merchandise) register information log dep table, it is divided into two tables, one is used for a module database In its title can be constant, for recording movable participating agency (without businessman) register information, another be used for b module service Device and its data base, its title is still dep table, for recording businessman's register information of dependent merchandise；Movable participating agency (comprises The businessman of dependent merchandise) qualification picture record table depp table etc..

Setting is concretely needed to include data below log in the data base of a module:

Movable participant and team's registration registration form are named as aj table, including at least data below record field: jid word Section is this table major key for the numbering of pieces of data record, and an field is used for the Real Name of record registration people, and ana is used for record report The occupational title of famous person such as stage name etc., aid field is used for recording the a1 table of the corresponding b module of member registration account number of this registration personnel Aid field；Jsort field is used for recording the classification of activity；Utime field is used for recording the registration time；Jc1 field is used for The record explanation to correlation circumstance for the entrant；Fs field is used for record management personnel's auditing result；Jc2 field is used for record management Personnel's audit opinion situation explanation；M1 field is used for recording registration fee pays number；Mt1 field is used for recording registration fee when paying Between；M2 field is used for recording the functional expenses number of its payment of activity management direction；Mk2 is used for recording reimbursement of expense situation and says Bright；Fid field is used for recording team's numbering that this member is subordinate to, corresponding to the jid field of team's record of this table, 0 expression This is recorded as team's record, and other data represent the team member of jid team.

Notify, notification data log is named as a2 table, including at least data below record field: vid field is each bar The numbering of data record is this table major key；Cont field is used for the particular content that record notifies, notices；Tp field is used for recording this The brief title of bar record；Utime field is used for recording this information uplink time.

Movable venue situation information data recording table is named as hosed table, including at least data below record field: hid Field is the numbering of pieces of data record is this table major key；Cont field is concrete to movable venue in this record for recording Explanatory note content；Imag field is used for recording the storage address information of involved image data in this record, its figure Sheet data is stored in server corresponding store files folder hos file；H field be used for recording this article of record be attached to that Article one, No. hid of record, 0 represents that this is recorded as the first i.e. first bar record of such venue.

Movable participating agency (without the businessman of dependent merchandise) register information log is named as dep table, including at least with Lower data entry fields: did field is the numbering of pieces of data record is this table major key；Dnam field is used for recording this mechanism's name Claim；Csort field is used for recording the country origin at this mechanism place；Pname field is used for recording chief leading cadre's name of this mechanism； Ptel field is used for recording the telephone number of this director；Cname field is used for recording working relation people's name of this mechanism； Ctel field is used for recording the telephone number of this contact person；Addr is used for recording home address；Cont field is used for record registration The brief information explanation to this mechanism for the people.

Movable participating agency qualification picture record table is named as depp table, including at least data below record field: pid word Section is this table major key for the numbering of pieces of data record；The mechanism that did field is used for recording belonging to this data registers No. id, right The did field of dep table should be associated with；Image field is used for recording the picture storage address of this record, and its image data corresponds to It is stored in the dpp file of server；Utime field is used for recording this information uplink time.

Campaign item setting log is named as item table, including at least data below record field: iid field is each bar The numbering of data record is this table major key；Iname field is used for recording the title of campaign item；Isort is used for recording active entry Classification belonging to mesh.

Activity schedule information record table is named as doitem table, including at least data below record field: did field is each The numbering of data record is this table major key；Iid field is used for recording this activity schedule information and is under the jurisdiction of that activity, corresponding It is associated with the iid field of item table；Cont field is used for recording movable concrete arrangement information；Utime field is used for recording this Information uplink time.

Movable participant's information record table is named as jdo table, including at least data below record field: jdid field is The numbering of pieces of data record is this table major key；The concrete activity sequence number that did field record activity participant is participated in, corresponding The did field of doitem table, the registration number of jid field record activity participant, corresponding to the jid field of aj table, uptime Field is used for record data uplink time, and k field is used for the online sales function whether record opens dependent merchandise, and 0 table is not opened Logical, 1 table is open-minded.

Movable participating agency and movable participant's basic demand information record table are named as clai table, including at least following Data entry fields: cid field is the numbering of pieces of data record is this table major key；Cont field is used for recording specific requirement letter Breath；Utime field is used for recording this information uplink time；Csort field is used for recording this and requires generic.

Games results log is named as mresult table, including at least data below record field: mid field is each bar The numbering of data record is this table major key；Iid field is used for recording sports events id belonging to achievement, and correspondence is associated with table item The iid field of table；The players numbering correspondence that jid field is used for recording belonging to achievement is associated with the jid field of table aj table；c Field is used for recording the achievement of this match；Utime field is used for recording this information uplink time；Mtime field is used for remembering Record the fixture of this games results.

Web site activity project finance turnover day-to-day account log is named as ac1 table, including at least data below record field: Acid field is the numbering of pieces of data record is this table major key；Qid field is used for recording No. id of business item during income； Csort field is used for recording the classification information of income item；Qa field is used for recording income number；Qo field is entered an item of expenditure in the accounts for record Number；Cont field is used for recording the item explanation of this record；Jid field is used for the activity participation that record occurs this business The registration number of personnel corresponds to the jid field of aj table；Did field is used for mechanism's registration number that record occurs this business, corresponding Did field in dep table；Utime field is used for recording time of origin.

Mechanism's finance turnover day-to-day account log is named as dac table, including at least data below record field: did field Numbering for pieces of data record is this table major key；Did field is used for mechanism's registration number that record occurs this business, corresponds to The did field of dep table；Nid field is used for recording into corresponding business odd numbers when entering an item of expenditure in the accounts,；Csort field be used for recording into The classification information of item of entering an item of expenditure in the accounts；Qa field is used for recording income number；Qo field is entered an item of expenditure in the accounts number for record；Cont field is used for Record the item explanation of this record；Utime field is used for recording time of origin.

Movable participant's finance turnover day-to-day account log is named as aac1 table, including at least data below record word Section: cid field is the numbering of pieces of data record is this table major key；Aid field is used for recording the registration of this movable participant Number, correspondence is associated with the jid field of aj table, and nid field is used for recording into corresponding business odd numbers when entering an item of expenditure in the accounts, csort word Section is for recording the classification information into item of entering an item of expenditure in the accounts；Qa field is used for recording income number；Qo field is entered an item of expenditure in the accounts number for record； Cont field is used for recording the item explanation of this record；Utime field is used for recording time of origin.

Activity correlation news information data logger is named as news table, including at least data below record field: nid word Section is this table major key for the numbering of pieces of data record；Cont field is used for recording news content；Image field is used for recording newly Hear the picture address of subject picture, its image data is stored in the newsp file of server；Utime field is used for recording Data uplink time, upid field is used for recording uploader member No. id；Usort field is used for recording the identity class of uploader Not；F field is used for the audit logging of record management personnel, and 0 table is not audited, and 1 table passes through examination ＆ verification, and 2 tables could not be by examination ＆ verification.

The pictorial information log related to news is named as cnews table, including at least data below record field: pid Field is the numbering of pieces of data record is this table major key；Nid field is used for recording this news picture to the theme news being subordinate to Id, corresponding to the nid field of news table；Cont field is used for the record news narration explanation related to picture；Image field is used In the picture address of record news picture, its image data is stored in the newsp file of server；Utime field is used for Record data uplink time, upid field is used for recording uploader member No. id；Usort field is used for recording the identity of uploader Classification；F field is used for the audit logging of record management personnel, and 0 table is not audited, and 1 table passes through examination ＆ verification, and 2 tables could not be by examination ＆ verification.

Flow-medium performance listings data information record table is named as lmt table, including at least data below record field: mid Field is the numbering of pieces of data record is this table major key；Cont field is used for recording flow-medium performance inventory information；Caddr uses In record stream medium data storage address, stream medium data storage folder lmtm file is set in Platform Server simultaneously Folder；Image field is used for recording flow-medium performance subject picture address, and its image data is stored in the Streaming Media of Platform Server Subject picture storage folder lmtp file；Have two schemes a kind of is exactly that the above content of this table is arranged in platform herein On server and data base；Another kind of is exactly that this table and its corresponding stream medium data storage folder are arranged in another clothes So as to be physically isolated with Platform Server on business device, to reduce Platform Server load thus improving platform reliability, The client setting program navigating mark of Platform Server is linked with outer, clicks on navigation identification by online friend and accesses these stream matchmakers Body programme content.

Setting is needed to include data below log in the data base of b module:

Ordinary consumer member registration register information log is named as a1 table herein, including at least data below record word Section: aid field is the numbering of pieces of data record is this table major key hereinafter referred to as member registration account number, and an is used for recording member Name, csort field is used for recording the country origin at member place；Atel field is used for recording the telephone number of member；Addr is used for The home address of record member；Fpoto field is used for recording member's head portrait picture address, and it is corresponding that its picture leaves server in In image data storage folder fpo file；Sex field is used for recording the gender information of member；And some other is used for Field of record membership and relevant information etc..

Businessman's register information log of dependent merchandise is named as dep table, including at least data below record field: did Field is the numbering of pieces of data record is this table major key；Dnam field is used for recording this mechanism or Merchant name；Csort field For recording the country origin at this mechanism place；Pname field is used for recording chief leading cadre's name of this mechanism or businessman；Ptel word Section is for recording the telephone number of this director；Cname field is used for recording working relation people's name of this mechanism or businessman； Ctel field is used for recording the telephone number of this contact person；Addr is used for recording home address；Cont field is used for record registration The brief information explanation to this mechanism or businessman for the people.

Businessman's qualification picture record table of dependent merchandise is named as depp table, including at least data below record field: pid Field is the numbering of pieces of data record is this table major key；The mechanism that did field is used for recording belonging to this data registers No. id, Correspondence is associated with the did field of dep table；Image field is used for recording the picture storage address of this record, its image data pair The dpp file of server should be stored in；Utime field is used for recording this information uplink time.

The online sales merchandise news log related to activity is named as goods table, including at least data below record Field: gid field is the numbering of pieces of data record is this table major key；Gname field is used for recording trade name；Gsort word Section is for recording the classification of commodity；The measurement unit information of selling that qa field is used for recording commodity is such as measured with " part "；Qb field For recording the gauge of commodity, such as 2 every；Uprice field measures unit price for recording selling of commodity；Image word Section is used for recording commodity picture address information, and its image data is stored in the pgoods file of server database；maddr Field is used for recording the place of production information of commodity；Qs field is used for recording the credit rating information of commodity；Did field is used for recording this Businessman belonging to commodity id, correspondence is associated with the did field of dep table；K field is used for recording the added sale shape of this commodity State, is divided into added sale, and undercarriage is for sale；Flag field is used for recording the management examination ＆ verification state of this commodity, is divided into pending trial 0 table Show, passed through examination ＆ verification and represented with 1, do not pass through examination ＆ verification and represented with 2, three kinds of states；Fk field is used for recording associated by this commodity Movable participant's registration number, corresponding to the jid field of aj table.

Client's order data log is named as dean table, including at least data below record field: nid field is each bar The numbering of data record is this table major key；Gid field is used for recording the commodity id corresponding to this order, and correspondence is associated with goods The gid field of table；Oprice field is used for recording this single conclusion of the business unit price (unit is: RMB￥/part)；Q field is used for remembering Record conclusion of the business quantity (unit is: part)；Sprice field is for recording the freight charges that this singly be should bear；Qa field is dealt with always for record Through volume；Qb field is used for recording the actual payment amount of consumer；K is used for recording consumer's payment status, be divided into unpaid, do not close, Pay off；Kp field is used for recording the condition of delivery of this order, is divided into non-shipment, shipped, consumer signs for；Sp field is used In the acknowledgement of consignment enterprise name recording this order goods, spid field is used for recording the acknowledgement of consignment Air Way Bill No. of this order commodity；Tona word Section is used for recording this order addressee's name；Toaddr field is used for recording addressee's better address；Totel field is used for recording Order addressee's phone；Tocode field is used for recording the on-site postcode of addressee；Cs field is used for recording addressee ground institute Country origin；Sen field is used for the province being located with recording addressee；Si field is used for the prefecture-level city being located with recording addressee； Xian is used for the district being located with recording addressee, and xi field is used for township, the street being located with recording addressee.Utime field is used for Record placing an order the time of this order；Otime field is used for recording the ETCD estimated time of commencing discharging that of this order, and btime field is used for recording this to be ordered Single receive me sign for the time.

Web side E commerce finance turnover day-to-day account log is named as ac2 table, including at least data below record field: Acid field is the numbering of pieces of data record is this table major key；Nid field is used for recording corresponding order number during income, Correspondence is associated with the nid field of dean table；Qid field is used for recording No. id from other items during income；Csort field For recording the classification information of income item；Qa field is used for recording income number；Qo field is entered an item of expenditure in the accounts number for record；cont Field is used for recording the item explanation of this record；Aid field is used for consumer's member registration account that record occurs this business Number corresponding to a1 table aid field；Did field is used for businessman's registration number that record occurs this business, corresponding to dep table Did field；Utime field is used for recording time of origin.

Businessman's finance turnover day-to-day account log is named as dac table, including at least data below record field: did field Numbering for pieces of data record is this table major key；Nid field is used for recording into corresponding order number when entering an item of expenditure in the accounts, corresponding pass Be coupled to the nid field of dean table, qid field be used for record into when entering an item of expenditure in the accounts from No. id of other items；Csort field is used for Record the classification information into item of entering an item of expenditure in the accounts；Qa field is used for recording income number；Qo field is entered an item of expenditure in the accounts number for record；Cont word Section is for recording the item explanation of this record；Aid field is used for consumer's member registration account number that record occurs this business Aid field corresponding to al table；Did field is used for mechanism or the businessman's registration number that record occurs this business, corresponding to dep table Did field；Utime field is used for recording time of origin.

Consumer member finance turnover day-to-day account log is named as aac2 table, including at least data below record field: Cid field is the numbering of pieces of data record is this table major key；Aid field is used for recording the registration account number of this member, corresponding pass It is coupled to the aid field of a1 table, nid field is used for recording into corresponding order number when entering an item of expenditure in the accounts, and correspondence is associated with dean table Nid field, qid field be used for record into when entering an item of expenditure in the accounts from No. id of other items；Csort field is used for recording into thing of entering an item of expenditure in the accounts The classification information of item；Qa field is used for recording income number；Qo field is entered an item of expenditure in the accounts number for record；Cont field is used for recording this The item explanation of bar record；Utime field is used for recording time of origin.

Consumer's calling information and disposition data logger are named as dosu table, including at least data below record word Section: sid field is the numbering of pieces of data record is this table major key；Aid field is used for recording complainant member id, corresponding association Aid field in al table；Bid field is used for recording the registration id of defendant；Cont field is used for recording complaint； Cimage field is used for record and complains evidence picture address information, sets up a complaint evidence picture in Platform Server simultaneously Data storage folders dosu file, the evidence picture that consumer submits to when complaining will be uploaded storage here；contb Field is used for recording the measure that defendant replys complainant and solves dispute；Contm field is used for recording portal management side Handling suggestion；Ba field is used for recording the information record whether complainant is satisfied with to result；Fb field is used for record and is thrown Whether the side of telling is processed, and 0 table is untreated, and 1 table is treated；Fbtime field is used for recording defendant's process time of origin；fm It is endlessly treated that field is used for recording portal management side, and 0 table is untreated, and 1 table is treated；Fmtime field is used for recording net Station administration side processes time of origin, and f field is used for whether the complaint of minute book bar is disposed and winds up the case, 0 table present, and 1 Table has been disposed and has wound up the case, and to be controlled the renewal of this field information of this record by portal management personnel.

Embodiment three

Third party website is to set up the virtual shop of special events be active web pages special show space for this activity；This scheme It is relatively more suitable for the situation of various middle-size and small-size activities, the Website development operator that thing is transferred to specialty does (in ecommerce Setting up general special show page space in website is another patent of invention declared in person, Application No. 201610368083.9, This place is only to carry out illustrating its difference for special case here).Its implementation:

First third party website related pages for example homepage setting lead to this activity special show space navigation identification and Link, online friend clicks on the special show space that this navigation identification may have access to activity.

Secondly the foreground that can access in the online friend of this third party website is activity setting special show page space, at this In setting embodiment two in special show page space, the content of a module (need to be added in a module in server or data base Hold it is assumed that the homepage of page space is actmark.aspx), and improved formation c module in following several respects: in a module The middle link realized towards movable dependent merchandise electric business business, has two kinds of implementations: one kind adopts interior connection scheme herein, real Now integrated with the ecommerce of this third party website, if there is the electronics business of commodity in this third party website Business module, we can realize the work(of the online sales of the commodity related to activity using the function of this e-commerce module Can, now we only need to improve to the server of this website and its data base, sets up a picture literary composition in the server Part folder act file is used for storing activation flag image data, increases a record activity navigation information in site databases Log such as acty table, this table include at least data below record field: atid field be pieces of data record numbering be The hereinafter referred to as activity id of this table major key, aname is used for recording activity name, and atime field is used for recording activity holds the time, Photo field be used for record activity mark picture address information, its image data record in the act file of server, Uptime field is used for recording activity data uplink time, and f field is used for recording the examination ＆ verification situation of this data, and 0 table is not audited, 1 table passes through examination ＆ verification, and 2 tables could not be by examination ＆ verification.Data logger described in simultaneously in the content of a module and the ecommerce of website The related every table of data logger of business all adds a field such as mar field, whether belongs to this for minute book data The data of activity, 0 table is not belonging to, n (n at this place belongs to the natural number being 0), and representing that this data belongs to movable No. id is n The related data message of this activity.So we can be realized in activity special show by the value of this mar field Foreground is shown with the process of online trading and the managing related data on backstage thus realizing corresponding function, specifically a little says, We need to process the data related to this activity in setting activity special show related pages, and now we can pass through When data retrieval or process, the search condition of one mar=n of increase can reach the process to special show number, for example: if any One physical culture game, its register in the navigation identification log of website No. id is 2, and designer sets in website homepage Put the navigation identification message display area of this kind of activity, this message display area adopts the method for designing of data binding, will believe The picture for show activity mark that breath is shown is realized with picture control, and design one simultaneously includes movable Navigation Picture number The data set of No. id registering according to the sequence number with this data is named as dataset1 herein, by the image data of data set with Picture control carries out data binding, and arranges a link leading to activity special show space, by this number in this link According to registration number carry out binding being passed on, then carry out again multiple data repeat show setting, you can realize at this One or more activity navigation identification is shown, online friend clicks on any one navigation identification therein and can visit in the homepage of individual website Ask this movable sales field page space.The crucial retrieval coding of its data set is schematically as follows:

Select*, (' act/ '+photo) as pic_addr from dbo.acty where f=1

Wherein f=represents that this activity is met the condition that website specifies and audited by manager.

Activity mark picture binds code schematically as follows:

< a href=" actmark.aspx？Atid=< %#dataset1.fieldvalue (" atid ", container) % > " target=" _ blank " >

< asp:image height=" 150 " id=" ttphoto " imageurl=< %#

Dataset1.fieldvalue (" pic_addr ", container) % > runat=" server " tooltip=" clicks on Picture access activity special show space "/&gt &lt ;/a>

And the Correlation method for data processing in the homepage of its special show page space, different from the data processing method of above-mentioned a module , in data retrieval and the condition that a mar=n need to be increased when submitting to, originally sentence in the homepage of activity special show space and electricity be set Son commercial affairs commodity classified navigation mark as a example be illustrated, remaining by that analogy,

Homepage in Activity Show special show space arranges the classified navigation mark of ecommerce commodity, and online friend clicks on corresponding Mark can jump to the respective classes electronic article commercial affairs navigation interface related to this activity, and its implementation is to each point Class mark setting one is led to next classified navigation and is identified dynamic page, and the sorting parameter of different class indication transmission is different, Similar to the implementation of this dynamic navigation page and the navigation dynamic interface scheme of aforesaid advertisement, different is The key code of retrieval is different, and search key herein comprises classification and activity navigation registration id, its code of commodity For:

The added sale of select*from dbo.goods where gsort=@gsort and k=' ' and flag=1and Mar=@mar

Wherein gsort is the classification parameter of the commodity classification passing over from prevpage face, and mar is to transmit from prevpage face The activity No. id i.e. above-mentioned n of navigation registration coming.

For another example: in showing of activity special show space, the electronic article commercial affairs navigation related to this activity can be set in homepage Mark and its link, online friend clicks on the electronic article commercial affairs page that this navigation identification accesses special show space, in this electronics business Be provided with complete special show electronic article business function in the business page, such as in field search search for the commodity related to this activity, Commodity (i.e. the commodity related to this activity) classified navigation in, commodity i.e. commodity with this activity correlation in field) displaying of classifying Pass through this commodity electric business page Deng, online friend and its related pages can achieve dependent merchandise retrieval, browse, place an order shopping. The condition of mar=n, its implementation all should be increased in the Correlation method for data processing that it is searched for inside, classified navigation, classification are shown There is data processing method consistent with above-mentioned merchandise classification navigation identification dynamic page, software developer with reference to this scheme is Data processing problem herein can be handled well..

Another kind of scheme is the realization activity Related product on the other internet platforms outside this website using outer link Ecommerce, have herein two kinds of implementations a kind of be other internet electronic business websites outside realizing this website (with Lower abbreviation x website) link, only increase by need to remember in the data logger of the commodity related to this activity in x website Record this movable field by activity and the relation records of commodity get off can easily realization activity dependent merchandise online pin Sell, its implementation is identical with the aforementioned internal chaining scheme of the present embodiment；Another kind of scheme is that independent exploitation one ecommerce is put down Platform, the e-commerce platform that this is individually developed is just the same with foregoing embodiments two, is not repeated to describe herein..

Example IV

Using movable dependent merchandise show with sale processed as the general service of third party website, simply with work Increase a field in the dynamic related data logger of commodity data to be used for recording the relating attribute of this commodity and activity, and In the displaying of the commodity on foreground, online friend can be differentiated when browsing merchandise news for the association identification of setting activity, or offer is passed through The related function of these commodity of keyword retrieval of activity or pass through lipuid goods show area, thus realizing online to this commodity Browse, sell, key word both can have been inputted by client and automatically can have been given according to each column by system.

Or in common electric business platform plus action message shows that mark is linked with outer, it is linked to this Activity Show Website is shown with the information realizing activity description, arranges a commercial articles searching related to activity simultaneously or is further added by a work The show area of dynamic Related product, online friend is by browsing this special show area or using the function of search with movable dependent merchandise The commodity related to activity can be found, thus realizing online ordering.Realizing this function need to be in the commodity of site databases In data logger such as goods table herein, increase a field arts field and be used for recording the title such as " the youth of the nation of activity Athletic meeting " or other activity name, 0 represents that general goods is unrelated with these activities, and other records have this note of activity name With regard to the commodity that table is with the activity of this title, foreground will be realized with the relevant electronic article commercial affairs of this activity, as long as sharp for record With the value of this field, it is entered with line retrieval and process.As when searching for it is simply that on the basis of original search keyword again Value plus an arts field is activity name.

Those skilled in the art can be understood that technology in the embodiment of the present application can be by software plus necessary General hardware platform mode realizing.Based on such technical scheme understanding in the embodiment of the present application in other words to existing The part that technology contributes can embody in the form of software, and this computer software is desirably integrated into the Internet, movement Among the website platform system of the modern network system such as the Internet and dispose issue and enter practical field.

Above-described the application embodiment or mode are only explanation for example to present invention spirit, and it is right not constitute The restriction of the application protection domain, any modification made within spirit herein and principle, equivalent, supplement and change Enter etc. to should be included within the application protection domain.

Claims (2)

1. the selling method data processing equipment of a kind of Activity Show and commodity, be related to a kind of website platform include movable official website, E-commerce platform, described activity official website, e-commerce platform include Website server, Database Systems, subscription client, act The side of doing, merchant client, further relate to a kind of on-the-spot broadcasting module of modern network and the playing module of picture recording video, interconnection network sale Sell module, client's registration and login module；Described Website server, Database Systems, subscription client, the side of holding or business Family's client is connected by the modern network such as the Internet or mobile Internet or Internet of Things；Described e-commerce platform comprises to take over The electronic fare payment system taking；Described merchant client comprises uploading information data module, sale and toll administration module, its feature It is:

This device comprises movable display unit and electronic article commerce arrangement；Movable display unit passes through the Internet, mobile interchange The modern network platform such as net, Internet of Things, website (hereafter referred to collectively as website) come to report displaying, live all kinds of activity and with commodity electricity Sub- commerce arrangement is associated:

Its feature of described association or be:

The online sales of commodity are carried out on the promotional display of various activities or live official website simultaneously；Or in Activity Show Set up relevant or parameter transmission between the page and each page of e-commerce system, or comprise by following several ways One of or the combination in any between them realizing: using the advertisement foundation business related to advertisement in foreground activity displayed page The link of the e-business capability of product or redirect；One ecommerce navigation page leading to dependent merchandise of setting on advertisement interface The link at face or interface (hereinafter referred to as s1 interface) or redirect, realizes the electronics business with the commodity involved by advertisement in s1 interface Business navigation, online friend clicks on this advertisement and may have access to s1 interface, and the information that online friend clicks on any one commodity in s1 interface can be visited Ask the information displayed page of this commodity, or also realize the ordering function that places an order online to this commodity；Or it is related in Activity Show The classified navigation mark of ecommerce commodity is set in the page, and online friend clicks on these classified navigations mark and may have access to respective classes The electronic article commercial affairs navigation interface or page (hereinafter referred to as s2 interface), online friend clicks on the letter of any one commodity in s2 interface Breath may have access to the information displayed page of this commodity, or also realizes the ordering function that places an order online to this commodity；Or in activity Setting electronic article commercial affairs navigation identification in displayed page, the ecommerce navigation identification of online friend's click commodity may have access to this and puts down Tianwan businessman's product ecommerce page, online friend passes through this ecommerce page and its related pages can achieve the inspection of dependent merchandise Rope, navigate, browse, place an order shopping etc. one of or its combination in any；Or in a certain specific Activity Show page setup commodity Ecommerce is navigated；Or the ecommerce clearing mark of commodity is set in the page of show activity participant's relevant information Know；

Or be provided with the data storage processing device of above content in the server database system of website, or this device is also Include one of following data processing table or the combination in any between them, or contain between the field of each data processing table There are corresponding or incidence relation: regular member's registration information record table, movable participant and team's registration registration form, or Above two tables are merged into a table；Notice, notification data log；Movable venue situation information data recording table；Activity ginseng Plus mechanism's (comprising the businessman of dependent merchandise) register information log；Movable participating agency (comprising the businessman of dependent merchandise) qualification Picture record table；Campaign item arranges log；Activity schedule information record table；Movable participant's information record table；Activity Participating agency and movable participant's basic demand information record table；Games results log；Merchandise news log；Client orders Forms data log；Website finance turnover day-to-day account log；Mechanism or businessman's finance turnover day-to-day account log；Regular member Finance turnover day-to-day account log；Consumer's calling information and disposition data logger；Activity correlation news information data Log；The pictorial information log related to news；Flow-medium performance listings data information record table etc.；

Or it is provided with Business Portal in movable official website or be provided with businessman's background work space；Or in businessman's backstage work Make in space, to comprise the upload device of commodity data or attending device or electronic commerce affair managing device or financial management device Or process customer order's device or process consumer's complaint device etc.；Or comprise business in the Back Administration Module of movable official website The uploading information data device of product or management service device or customer order's managing device or consumer's complaint management device etc.；

Or outside movable official website display platform (abbreviation a module), it is separately provided a commodity online sales module (abbreviation b mould Block), b module uses another set of server；By arranging correlated identities on the platform page of movable official website, online friend passes through in official website Click on or select these marks on platform, the related pages accessing b module carry out browsing or SUBSCRIBE Operation of merchandise news；Or The entrance of movable participating agency and businessman is provided separately；

Or it is provided with one of following data processing table or the combination in any between them in the data base of a module, or Corresponding or incidence relation: movable participant and team's registration registration form is contained between the field of each data processing table；Notify, Notification data log；Movable venue situation information data recording table；Movable participating agency register information log；Activity is participated in Mechanism's qualification picture record table；Campaign item arranges log；Activity schedule information record table；Movable participant's information record Table；Movable participating agency and movable participant's basic demand information record table；Games results log；Web site activity project wealth Business turnover day-to-day account log；Mechanism's finance turnover day-to-day account log；Movable participant's finance turnover day-to-day account log； Activity correlation news information data logger；The pictorial information log related to news；Flow-medium performance listings data information Log；Or it is provided with image data storage folder；

Or it is provided with one of following data processing table or the combination in any between them in the data base of b module, or Corresponding or incidence relation: ordinary consumer member registration register information log is contained between the field of each data processing table； Businessman's register information log of dependent merchandise；Businessman's qualification picture record table of dependent merchandise；Merchandise news log；Client Order data log；Web side E commerce finance turnover day-to-day account log；Businessman's finance turnover day-to-day account log；Consumption Person member's finance turnover day-to-day account log；Consumer's calling information and disposition data logger；Or it is provided with picture Data storage folders；

Or it is that activity special show space is set up in this activity in third party website, this special show space mainly shows this work Move and its related content or the electronic commerce affair content going back display of commodity, or set up and commodity by special show page space Ecommerce access relation, or realize the online sales of commodity by special show page space, or in activity special show space The commodity classification navigation identification of ecommerce is set in the related page, or online friend clicks on navigation identification therein and may have access to Ecommerce related interfaces in commodity or the page；

Or the displaying of movable dependent merchandise is included the general goods online sales device of third party website with selling, and for its In the merchandise display on foreground, online friend can be differentiated when browsing merchandise news for the correlated identities of setting activity, or provides by living Move the device of these commodity of keyword retrieval of correlation or the retrieval device of offer activity correlation to retrieve commodity, or and then realize Online sales to commodity；Or in electric business platform, setting action message shows that mark is linked with outer, is linked to this Activity Show Website with realize activity description information show；Or the show area of setting activity Related product, online friend is by browsing this exhibition Show in area the information of commodity or related commodity can be found using to the function of search of movable dependent merchandise etc., or and then realization Online ordering；

Described activity comprises: one of recreation and sports, commodity sales exhibition, trade fair etc. or their combination in any；

Described recreation and sports comprise various style meetings, sports meet, match, fair, theatrical performances, various evening One of meeting, concert, concert, culture and arts exhibition etc. or their combination in any；

Described commodity bundle contains common tangible physical commodity, intangible goods, all kinds of service etc., but except event ticket；

Described activity official website refers to that authority's report shows the website of this action message content or by campaign owners or undertaking Side sponsors or its entrusted agent sponsors or is mainly used in showing the website platform of this action message content.

2. activity its feature of dependent merchandise or be as claimed in claim 1: this commodity and activity presence certain associate but not Event ticket, its correlation form or comprise following one of all kinds of or their combination in any: relevant with activity description or its On line, exhibition method is in same category, the commodity of same industry and activity participation with movable related commodity or with activity The related commodity of personnel, can be used for activity during the commodity of consumer spending and campaign owners or undertaker relevant Commodity and the movable related commodity of sponsor and the related commodity of walking advertisement, show in movable official website Cross the commodity of correlated identities or the website contacting such as establish the link, redirect, showing the commodity of sale in platform with official website Deng.