CN105956679A

CN105956679A - Network booking tour guide service providing method

Info

Publication number: CN105956679A
Application number: CN201610527500.XA
Authority: CN
Inventors: 邹春秋
Original assignee: Individual
Current assignee: Individual
Priority date: 2016-07-01
Filing date: 2016-07-01
Publication date: 2016-09-21
Also published as: CN106355260A

Abstract

The invention discloses a network booking tour guide service providing method, and belongs to the field of the tourism industry, the internet and the mobile internet. According to the method, tour guide staff information is collected or a network booking tour guide service is provided by utilizing the platform and the website of the internet and the mobile internet. Netizens can inquire network booking tour guide related tourism product packages and tourism group plans performed by the tour guide through website client side equipment and place an order to join the group plans, or tourists upload their own tourism plans and tour guide service requirements and the tour guide places the order and then the netizens confirm. According to the method, a new way can be provided for the tour guide staff for directly entering the tourism market so that the enthusiasm of improving work of the tour guide staff can be enhanced, the tourists can select the tour guide satisfying themselves, the tourism experience of the tourists can be enhanced and the development of tourism and economic transformation and upgrading can be facilitated.

Description

A kind of net about guide service provides method

Technical field

The invention belongs to tourism industry and e-commerce field.

Background technology

Tourism guide practitioner always takes service in the enterprises of service in tourism such as travel agency in the past, enterprise dispatch officers to provide to visitor to lead Trip service, each travel service enterprise descends online or issues travelling products set meal on line, and visitor participates in.The situation of reality is guide Personal work quality, the experience interests with itself of visitor do not have direct correlation, and the main body of association is the tourist corporation at her place, by Service quality in each guide practitioner usually exists with the demand for experience of visitor and disconnects or can not in real time and market alternately and accepts market Supervision, various places often occur visitor taken pressure shopping or the unsatisfied situation of tour-guide's service quality visitor happen occasionally, and another The good service that aspect high-quality guide provides is submerged in again among the boundless ocean in market, it is impossible to show one's talent.This can not adjust well Dynamic guide practitioner puies forward business's professional ability and improves the enthusiasm of service quality, the most also increases the employment cost of guide practitioner, But along with country's obtain employment guide practitioner adjustment of policy is relaxed, it is directly entered guide service market for guide practitioner and provides More channel and selection.

Summary of the invention

Problem to be solved by this invention is: a kind of net about guide service of invention provides method, the method be in the Internet, movement The Internet, Internet of Things website platform on set up net and about conduct a sightseeing tour module or directly set up a net about guide service platform, guide is by flat Guide's entrance of platform client proposes service request to platform to be handled corresponding entries and uploads related data, audits through the long staff in website Net about guide service is provided by backward visitor.Online friend can utilize networking client to set by the Internet, mobile Internet, Internet of Things For such as: the online such as PC, notebook, panel computer, mobile phone, domestic electric appliance, mobile unit accesses and provides net about guide service Or the website platform of related content, the related pages that online friend about conducts a sightseeing tour into or by navigation entrance net in website platform is checked wherein The data of every guide, visitor's information, qualification information and service content, the vacation packages product of release, design to its service evaluation Organized tour circuit, plan of forming a team etc. can place an order and add the offer plan of forming a team of its travelling route released, or online friend oneself sends out Cloth tour plan, is thrown single online friend by guide and confirms, visitor pays dues, and guide is confirmed adding application, goes on a tour the time to agreement, Visitor concentrates report trip to accept net about guide service by about ordering place, and online friend can check the order of management oneself at any time, at any time to certainly Oneself Tourist Experience gives opinion and includes the complaint to service and evaluation；Business is managed by guide by the work space of oneself；Net The related service that net is about conducted a sightseeing tour by station administration personnel by background work space is managed and controls.The invention of the method can significantly facilitate The travelling that visitor is oneself promotes the Tourist Experience of oneself from main separation guide, facilitates the employment of guide practitioner simultaneously and improves guide Improve its services, the enthusiasm of lifting professional skill, promote that the service level of tourist market improves beneficially economic turning further Type is upgraded.The present invention is achieved by following technical scheme.

Platform website in the Internet, mobile Internet, Internet of Things is improved, the function or module that adding networks about conducts a sightseeing tour Or the website platform that one net of stand-alone development construction is about conducted a sightseeing tour, mainly comprise: visitor applies for registration of with the online service of guide practitioner, The foreground message of each tourist attractions and travelling route is shown, guide's practitioner's information is submitted to and collects；Guide's practitioner's title examination With management；Uploading of guide service business datum；Show on foreground that online friend can access guide's practitioner's qualification and working information, The vacation packages that the information contenies such as services performance information, visitor's evaluation, guide release and service content, guide's identity, contact method letter The displaying of breath, the forming a team plan about conducted a sightseeing tour of net, online friend's line surf the Net about guide place an order addition its released the tourism plan of forming a team；Visitor Uploading the plan of going on a tour and guide's demand, guide service supplier throws single quotation；Visitor to join the Youth League application order management and function of paying dues, Online friend's accounts of finance manages, and visitor is thrown application manages function, visitor is complained by guide the management function of singly joining the Youth League, guide couple by guide Function is stated in the throwing of uncivil visitor, guide pays dues function, guide's accounts of finance manages, guide exchanges mailbox with webmaster.Website is to guide Practitioner's title examination and management, website to guide management and examination；The process that visitor is complained by website.It is divided into three in client Individual function part completes: the displaying on foreground and online friend operate part, guide practitioner's work space, webmaster background work space. Database Systems are carried out reform strengthening simultaneously, adds and comprise following data logger and the file use of correspondence is set in the server In storing corresponding picture, multi-medium data, membership information log (recording common visitor and guide's identity information), tourist service Enterprise and guide's practitioner's register information table of starting the business keep accounts out with picture concerned data information storage folder, operating unit's finance Account log, account enterprise of service in tourism and guide's practitioner's annual fee of opening for business pay situation log；Enterprise of service in tourism and guide from Industry personnel quality of service guarantee gold of opening for business pays information log；Travelling route vacation packages product data registration form and picture concerned data Data storage file, sight spot and service product contingency table, travelling products are formed a team planning chart, each sight spot, hotel information data registration form With picture concerned data information storage folder, each sight spot and hotel details picture, multimedia data information log and picture, Multi-medium data storage folder, online friend add tourist group and form a team application information log, customer complaint information and disposition data note Record table, visitor's evaluating data log to study of tourism itinerary production, visitor to guide service quality evaluation table, the charge record of website Table, the advertising pictures address information of homepage title position about conducted a sightseeing tour by net and a record stores the picture concerned of this advertisement module, many matchmakers The file of volume data, the extension of advertisement of homepage title position about conducted a sightseeing tour by net or details comprise picture address information and believe with word Breath log and its picture or multimedia data recorder file etc..Product online is issued after running, and online friend passes through the Internet, moves mutually Internet interview, log in related web site platform, entered or be directly entered net by navigation and about navigate homepage, check the trip relevant to guide The tourism plan of forming a team that trip set meal product, selection guide release, throws list and adds its tourist group being responsible for conducting a sightseeing tour, or online friend uploads oneself Tour plan and guide service demand, guide throws single online friend and confirms, pays dues and honour an agreement its schematic flow sheet as shown in Figure 1 by the both sides that about go on a journey.

Accompanying drawing explanation

Fig. 1 is the schematic flow sheet that online friend's net of the present invention is about conducted a sightseeing tour.

Fig. 2 is that net is about conducted a sightseeing tour the homepage composition diagram of module.

Fig. 3 is that net is about conducted a sightseeing tour the homepage designing view of module.

Fig. 4 is that vacation packages product detail information shows interface composition diagram.

Fig. 5 is that vacation packages product detail information shows interface layout drawing.

Fig. 6 is the application submission circle page Design view that application adds vacation packages product group travel plan.

Fig. 7 is order management page composition diagram

Fig. 8 is that order shows that interface order brief information shows content graph

Detailed description of the invention

The specific embodiment that the following is the present invention is created with the basis of prior art development platform Dreamweaver+sql2000 As a example by newly developed and combine accompanying drawing technical scheme is further described, in order to more clearly illustrate the spirit of the present invention, But the invention is not limited in these embodiments.

Embodiment

Initially setting up the Database Systems supporting with platform, then each page of design platform or interface, set up in data base Include at least with following table in interior tables of data, set up associated picture, the file of multi-medium data storage in the server.First The membership information log of Zhang Mingwei U (records common visitor and guide's identity information), comprise following field uID, na, pn, cname, C, tel, qq, sl, p, pask, pans, flag, f1, oks, oksp, ma, face, mad etc., wherein uID is used for Record member's login ID is this table major key；Na is for recording the name information of member；Pn is for recording the user name information of member；cname For recording its identity document name information；C is used for recording its identification card number information；Tel is used for recording member's contact method information Such as telephone number；Qq is for recording the social account account such as No. QQ of member；Sl is for recording the social platform such as wechat of member Account number；P is for recording the login password of member；Pask Security Question pans when password given for change in record is for record The answer etc. of Security Question；Flag is divided into visitor consumer member and ISP to lead for the identity category information recording member Trip member；F1 is for recording whether member opens the management qualification of guide service, and 0 table is the most open-minded, and 1 table is the most open-minded, and 2 expressions are not passed through Examination & verification；Oks is used for identifying outstanding guides, and 1 represents it is that 0 table is not；Oksp field is for recording the weighted value of guide's sequence； Ma field is for recording title and the account information of the Third-party payment platform of this member；Face field is used for recording this member's head portrait address Information, other field can be used for recording client other identity data information or other relevant information etc. set up one in the server simultaneously FU file is used for storing member's head image data；

The table of second entitled dp is used for recording guide practitioner and starts the business register information table, comprises data below record word Section: dpid, uid, dpname, addr, tel, uname, c, d, acc, f1, fc etc., wherein dpid field is used for record It is this table major key that registration number is managed in working；Uid field is for recording guide's member registration number and the corresponding association of uid field in u table； Dpname field is for recording the service organization of tourist guide or the title of enterprise of service in tourism；Addr field is used for recording address of the applicant； Tel field is used for writing task contact phone number；Uname field is used for writing task name of contact person；C field is used for recording Shen The main business range content information asking someone managed；D field is used for recording applicant's qualification and work biographic information；Acc field is used for Record this registration unit or guide in third-party financial account, the financial transaction i.e. conducted a sightseeing tour with this operation member for website platform, account Number provided in the lump when application is started the business by client；F1 field is used for recording opening status indicator, be divided into 0,1,2,3 four kind State, 0 represents that new application etc. is pending, and 1 represents and allows opening by examination & verification, and 2 tables are undesirable not by auditing, and 3 tables are by by force System is closed；Fc field is used for writing task personnel's audit opinion explanation.

3rd entitled dpphote table, for recording the qualification pictorial information that application opening is submitted to, comprises data below record Field: dppid, dpid, pname, addr, c, wherein this table of dppid field serial number this table major key；Dpid field is used for remembering Record the managerial setup registered account number of this guide；Pname field is for recording the title of this picture；Addr field is used for recording this this picture Storage address in the server；C field is for recording the explanation of this qualification file.An entitled dpw is set in the server simultaneously File for recording the image data that this table record is corresponding.

The table of the 4th entitled pick, is used for recording member and withdraws deposit request for data, comprise data below record field: pkid, Uid, dpid, c, q, k, uptime, f, wherein pkid field is for serial number this table major key of one, minute book table record；uid Field is used for recording submission applicant member's account number, corresponding to the uid field of U table；Dpid field is withdrawn deposit for record and is applied for indication Managerial setup account number, corresponding to the dpid field of dp table；C field is used for recording application documents content and explanation；Q field is used for record Application is withdrawn deposit number；Whether k field has paper document to be sent to by line under type for record, is divided into and sending to, without sending to two kinds of feelings Condition；Uptime field is used for recording application time submission date；F field is used for recording applicant's membership class, is divided into ordinary consumer Member represents with 1, and provides the operator member such as guides of service to represent with 2.

5th entitled Uinto table is used for recording consumer's visitor member's finance and keeps accounts log of entering an item of expenditure in the accounts, and comprises data below note Record field: inid, Uid, in, ain, atime, out, uptime, c, wherein inid field is used for one record of minute book table Serial number this table major key；Uid field is for recording the account No. id of this consumer member, and correspondence is associated with the uID field of U table； In field is for recording the data that formally keep accounts of this member；When ain consumer supplements with money, number is submitted in application to；Atime submits to and supplements application with money Time；Out field is for recording the expenditure data of formally entering an item of expenditure in the accounts of this member；Uptime field formally goes out, for recording, the data that keep accounts Time of origin；C field is for recording the explanation to this business.

6th entitled Ubalance table is used for recording consumer's visitor's accounts of finance regular balance data information, comprises following number According to record field: Ubid, Uid, bal, dyear, uptime, wherein Ubid field is used for the serial number of one, minute book table record originally Table major key；Uid field is for recording the account number of this consumer member, and correspondence is associated with the Uid field of U table；Bal field is used for record This member account balance in this in period；Dyear field is for recording the time period corresponding to this record；Uptime field is used for recording this Bar record time of origin；

7th entitled dpinto table is used for recording managerial setup finance and keeps accounts log of entering an item of expenditure in the accounts, and comprises data below record word Section: inid, dpid, in, out, uptime, y, m, c, wherein inid field is used for the serial number of one, minute book table record originally Table major key；Dpid field is for recording the operation id of this operation member, and correspondence is associated with the dpid field of dp table；In field is used In the data that keep accounts recording this operation member；Out field is for recording the expenditure data of this operation member；Uptime field is used for record The time of origin of this data；Time belonging to the submission of y field record data；M field is for recording the month belonging to data submission；c Field is for recording the explanation to this business.

8th entitled balance table is used for recording managerial setup finance fixed account balance data information and (monthly records one Secondary), comprise data below record field: dpbid, dpid, bal, dyear, dmonth, uptime, wherein dpbid field is used Serial number this table major key in one, minute book table record；Dpid field is for recording the operation id of this operation member, and correspondence associates Dpid field in dp table；Bal field is used for recording this month account balance of this operation member；Dyear field is used for recording this record The corresponding time；Dmonth field is for recording the concrete time period corresponding to this record；Uptime field is used for recording this note Record time of origin；

9th entitled yfee table is used for recording tourist service mechanism practitioner's annual fee of opening for business of i.e. conducting a sightseeing tour and pays situation, comprise with Lower data entry fields: yfid, dpid, m0, m1, fyear, uptime, upuid, c etc., wherein this table of yfid field references Article one, serial number this table major key of record；Dpid field is for registration account number id of the operating unit corresponding to minute book bar payment record； I.e. corresponding product is associated with the dpid field of dp table；M0 field is for recording the annual fee number through appraising and deciding；M1 field is paid dues people for record Actual pay number；Fyear field is paid dues corresponding year for record；Uptime field is used for recording actual time of origin of paying dues； Upuid field is for recording member's account number of the actual people that pays dues；C field is used for record case explanation.

Tenth entitled qfee table is used for recording tourist service mechanism practitioner's service guarantees gold of opening for business of i.e. conducting a sightseeing tour and pays information, Comprise data below record field: qid, dpid, m0, m1, uptime, upuid, c: wherein one, this table of qid field references note Serial number this table major key of record；Dpid field is for account number id of the operating unit corresponding to minute book bar payment record；I.e. corresponding product It is associated with the dpid field of dp table；M0 field should pay guarantee fund's number for record that this operating unit appraises and decides；M1 field is used for record The actual guarantee fund's number paid of this operating unit；Uptime field is for recording the time of actual paying；Upuid field is used for Record member's account number of actual paying people i.e. corresponding to the uID field of U table；C field is used for recording relevant situation explanation.

11st entitled tourgoods table is used for recording vacation packages product data, arranges and this table the most in the server Corresponding picture, multimedia data storage folder tourgoodsp file, comprise data below record in tourgoods table Field: ID, content, content1, paddr, guideid1, guideid2, guideid3, guideid4, f, sort, Uptime, upid, wherein id is for recording serial number this table major key of travelling products；Content is for recording the content of travelling products Introduce；Content1 is used for recording this travelling products brief textual introduction；Paddr is for the representative sight spot of minute book travelling products Picture address, its image data is by being stored in tourgoodsp file when system is uploaded；guideid1、guideid2、guideid3、 Guideid4, for member's account number id of the guide of minute book travelling products, can record altogether several guides, wherein guideid1 For director；F has passed through the examination & verification of portal management side for recording this product, and 0 table is not audited, and 1 table passes through to audit, and 2 Table is not by examination & verification；Sort is for recording the retrieval classification of this vacation packages product, corresponding, as herein by class with homepage navigation classification It is not divided into: Southeast Asia tourism, Northern Europe tourism, island trip, Canada of the U.S., the northern scenery, grass garden landscape, western plateau, the south of the River The big class such as the region of rivers and lakes, modern metropolitan cities, the south of Fujian Province scene, red tourism, Peasants Joy, classification can be arranged when typing by the member submitting data to, Also can be arranged by auditor；Uptime is for recording the design uplink time of this product, and upid uploads personnel id for record Number.

12nd entitled tourspot table is used for recording sight spot and travelling products contingency table, comprises data below record field: TsID, tgoodsid, spotid, upid, uptime, f, wherein tsID is serial number this table major key of one, this table record, tgoodsid No. id of vacation packages product in record one record, association is corresponding to the id field in tourgoods table, and spotid is used for Record sight spot or No. id of hotel, corresponding to the spotid field in view_spot table, upid field uploads personnel id for record Number corresponding to the Uid field in U table, uptime field is for recording the uplink time of this product, and f is used for whether recording this record Having passed through the examination & verification of portal management side, 0 table is not audited, and 1 table is by examination & verification, and 2 tables are not by examination & verification.

13rd entitled tourTeam table is used for recording travelling products and forms a team planning chart, comprises data below record field: ttID、f、fd、c1、c2、goodsid、uid1、uid2、uid3、q、q1、process、t、tot、toaddr、tocity、 Cost0, cost1, cost2, ins, upid, uptime, k, flag, the wherein sequence number of one, this table of ttID field references record For this table major key；F field record is formed a team plan classification, is divided into guide to initiate class and represents with 1, and consumer visitor initiates class and represents with 2； The service need status that fd field initiates class for record for consumer is divided into: is not required to competition for orders such as guide and initiates class and represent with 0,1 table In showing that competition for orders is carried out, 2 represent that competition for orders terminates；C1 field is formed a team explanatory note for record, and such as this plan of forming a team is sent out by consumer Rise, then perhaps requirement in tourism route and hotel, the sight spot lodging dining etc. that this plan comprised can be here described；It is right that c2 is used for recording The component content that comprised of quotation: such as whether comprise guide service expense, admission fee, hotel expense, transportation expenses, by dinner cost etc.；goodsid Field is for recording vacation packages product id corresponding to this plan of forming a team corresponding to table tourgoods table id field；uid1、uid2、 Uid3 field is for recording the member id wherein uid1 serving as guide of this plan of forming a team for recording director member id；Q field is used In recording visitor's number that this group appraises and decides；The number of the actual application of q1 field record；Process field is formed a team process status for record, 0 table is formed a team in carrying out, and 1 table is formed a team and terminated to close；T field is for recording the planned time section of embarking on journey of this plan；Tot field is used for remembering Record the rows of concrete set time of this plan；Toaddr field is for recording the initial assemble place of setting out this time formed a team；tocity Field is for recording the city, place, assemble place setting out initial this time formed a team；Cost0 field is used for recording guide's promotion price；cost1 Field is for recording the price data of organized tour of this time conducting a sightseeing tour；Cost2 field is for recording the bid valency of this consumer's organized tour Lattice data；Ins field is for recording the insurance product information that this organized tour is comprised；Upid field is used for recording this plan of forming a team Member's account number id uploaded is corresponding to the uID field of U table；Uptime field is for recording the time that this plan of forming a team is uploaded；k Field is used for recording price category, is divided into common fare, promotion price；Flag field is used for recording whether the plan of this time forming a team passes through net Pipe examination & verification mark, 0 represents unexamined, and 1 table is by examination & verification, and 2 tables are not by examination & verification.

14th entitled view_spot table is for recording sight spot and hotel and the detailed letter of leisure cuisines etc. provided thereof Breath picture, multimedia data information log arrange the picture multimedia document data record folder corresponding with this table the most in the server View_spotp file, tables of data comprises data below record field: spotid, sname, content, paddr, cy, sen, Si, addr, uptime, upid, wherein spotid be one LSN of this table be this table major key, sname field is sight spot Or the title in hotel, content field is the character introduction in this sight spot or hotel, paddr field be this sight spot or hotel shape As picture stores address, its image data is stored in view_spotp file when system is uploaded；Cy field is used for recording sight spot The country origin at place, sen field is for recording the province (municipality directly under the Central Government etc.) at place, sight spot, and si field is for recording the region at place, sight spot City, addr field is for recording the concrete number at place, sight spot, and uptime field is used for recording uplink time, upid field Personnel No. id are uploaded for record.

15th entitled ttdrop table is for recording the throwing odd number of guide's offer that guide practitioner initiates for consumer According to, comprise data below record field: tdid, ttID, upuid, q, c, uptime, f, wherein tdid field is used for remembering Record serial number this table major key of this table this data record；TtID field throws the guide service corresponding to unirecord for minute book bar The sequence number of offer (plan of i.e. forming a team)；Upuid field throws single member's account number i.e. No. UID for recording；Q field is used for remembering Single quotation is thrown in record；C field is for recording the service content thrown included in single quotation；Uptime field is used for recording throwing single time； F field is used for recording throws single state, is divided into: wait pending, single successful, single failed three kinds of the throwing of throwing.

16th entitled team_Apply table is used for recording online friend and adds form a team application information, i.e. net of tourist group and about conduct a sightseeing tour mould The order record table of block, comprise data below record field: taid, ttid, goodsid, upuid, pname, ptel, psex, Page, q, mq, wq, orf, cf, uptime, accept, c, s1, s2, s3, etc. field, wherein taid field is used for Serial number this table major key of minute book data record, ttid field is for the plan of forming a team corresponding to minute book data record Sequence number in tourTeam table, goodsid field is associated with for the sequence number i.e. correspondence recording corresponding vacation packages product The id field of tourgoods table, upuid field corresponds to U table uID field for recording the member's account number submitting applicant to, Pname field submits the name of applicant to for recording, and ptel field submits the telephone number such as cell-phone number of applicant to for recording Code, psex field is for recording the sex of submission applicant, and page field submits the age of applicant to for recording, and q field is used In the apllied number of joining the Youth League of minute book application, mq field is used for the apllied male's number of joining the Youth League of minute book application, and wq field is used In the apllied women number of joining the Youth League of minute book application, orf field is divided into normally for minute book order status, needs updates Two states, cf field in the consumption status of minute book order such as is divided into carry out to be consumed, the consumption, consumption terminate three kinds, Uptime field is used for recording the time that order (application of i.e. joining the Youth League) is submitted to, and accept field accepts shape for record this order State, be divided into pending, accept, abandoned three kinds of states, c field is for recording the explanation suggestion that order is audited by guide, s1 Field is used for recording client and should pay the fees volume, and s2 field record intersection number volume, s3 field returns number when registration-cancellation order.

17th entitled team_ApplyP table is used for recording online friend and adds tourist group and form a team application composition of personnel information note Record, comprise data below record field: tapid, taid, name, sex, age, date, cname, code, Tel, addr, htel, wsort, wherein tapid field is for serial number this table major key of minute book bar record, Taid is associated with this table for a LSN correspondence of minute book bar record be under the jurisdiction of team_Apply table Taid field, name field is used for recording visitor's name, and sex field is used for recording visitor's sex, and age field is used for remembering At record visitor's age, date field is used for recording visitor's date of birth information, and cname field is used for recording visitor's identity Certificate title, code field is used for recording visitor's identification card number, and tel field is used for recording visitor Telephone number, addr field is used for recording visitor address, htel field record visitor household's telephone number, wsort field record visitor Occupational information.

18th entitled complained table is used for recording guides, visitor's calling information and disposition data record, Comprise data below record field: id, content, title, appeal, upuid, utel, uptime, tuid, tutel, toteamid、tanswer1、tanswer2、tte1、ub1、ub2、mcont、proof、sort、f1、f2、f3、qb.Its Middle id field is for serial number this table major key of minute book bar record；Content field is for recording the particular content of complaint；title Field is used for recording complaint content title；Appeal field is for recording the demand of complainant；Upuid field is used for recording complainant's meeting Member's account is corresponding to the uID field of u table；Utel field is used for recording complainant's telephone number；When uptime field is used for recording complaint Between；Tuid field is for recording member's account number uID field corresponding to u table of defendant；Tutel field is used for recording complained People's telephone number；Toteamid field is for recording complained plan of forming a team sequence number；Tanswer1 field is used for recording defendant and returns The content of multiple complainant；Tanswer2 is used for recording defendant and appeals content to portal management side；Ttel field is used for recording complainant Telephone number；Ub1 field is used for recording complainant and defendant being replied, whether handling suggestion is satisfied with；Ub2 field is used for recording complainant Portal management side is replied whether handling suggestion is satisfied with；Mcont field is used for recording portal management side's handling suggestion content；Proof field For recording whether complaint content have submitted evidence, 0 table does not submit to evidence, 1 table to have been filed on evidence；Sort field is used for recording throwing Tell classification be divided into visitor to complain, the class such as guides's complaint；F1 field is used for recording defendant the most processed complaint response complainant； 0 represents untreated, and 1 represents processed reply complainant；F2 field is used for recording webmaster and the most processes this complaint, and 0 Representing untreated, 1 represents processed reply complainant and defendant；F3 field is used for recording this complains whether process terminates, and 0 Table reason processes in carrying out, and 1 expression process terminates；The qb field fund number that defendant pays in time processing complaint or reimbursement number.

The picture evidence deposit position information that 19th entitled cpproof table was submitted to when visitor complains, comprises following number According to record field: id, dsid, paddr, when setting up the file of an entitled proofp in the server for recording complaint simultaneously The evidence image data submitted to, wherein id field is for serial number this table major key of minute book bar record, and dsid field is used for recording this Which bar record belongs to is complained, and the complaint sequence number being i.e. subordinate to is used for record corresponding to the id field of complained table, paddr field The address information of evidence picture.

20th entitled assess table, for recording visitor's evaluating data information to study of tourism itinerary production, comprises data below Record field: id, goodsid, c, k, uid, uptime, f, wherein serial number this table major key of this record of id field record, The sequence number of the vacation packages product that goodsid field record is corresponding, corresponding to the id field of tourgoods table, represents that the evaluation done is Being made for this vacation packages product, c field is used for records appraisal content information, and k field is divided into for records appraisal grade: Very well, good, passable, poor, very poor, uid for member's account number of records appraisal people corresponding to the uID field of u table, uptime Field is for the time of records appraisal content uploading, and f field is for recording whether this valency has already been through the examination of webmaster, and 0 table is unexamined, 1 table is by examining, 2 tables could not be by examining.

21st entitled atourserve table, for recording visitor's service quality evaluation to guide, comprises data below note Record field: id, taid, uname, f, c, uid, uptime, k, wherein serial number this table major key of this record of id field record； Taid field is which time to consume the i.e. order number made based on for recording consumer and making an appraisal, and correspondence is associated with table team_Apply The taid field of table；Uname field is used for records appraisal people's Real Name；F field is used for recording this opinion rating, such as, be divided into Good, qualified, differ from three kinds；C field is for recording this concrete evaluation content；Uid field is for recording the member of this appraiser Account number correspondence is associated with the UID field of table U table；Uptime field, for recording this time of origin evaluated, is automatically generated by system； K field is used for recording this and evaluates whether effectively, webmaster personnel determine after auditing, be divided into 0 table not audit, and 1 table has through examination & verification confirmation Effect, 2 tables are invalid through examination and determination.

22nd entitled cmoney table is used for recording website consumer payment tables of data, comprises data below record field: Id, taid, q, uid, uptime, c, wherein serial number this table major key of this record of id field record；Taid field is used for remembering The order number of record consumer, taid correspondence is associated with the taid field of table team_Apply table；Q field is used for recording gold of this time paying dues Volume；Uid field is associated with the UID field of table U table for the member's account number correspondence recording this payer, and uptime field is used for remembering Record this time of origin paid dues, system automatically generate；C field is for recording this brief description paid dues.

23rd entitled adv1 table is about conducted a sightseeing tour the advertising pictures information of homepage title position for recording net, comprise with Lower data entry fields: aid, paddr, uptime, c, wherein serial number this table major key of this record of aid field record, paddr This advertising pictures address information of field record, this advertising pictures uplink time of uptime field record, c field record comment.

24th entitled adv2 table is about conducted a sightseeing tour the extension of advertisement of homepage title position or details for recording net, Comprise data below record field: adid, aid, paddr, uptime, c, wherein serial number of this record of adid field record This table major key, aid field is associated with the aid field of table adv1 table, paddr for recording affiliated title advertising pictures sequence number correspondence Field is used for recordable picture address information, this advertising pictures uplink time of uptime field record, c field record comment.

Above adv1, adv2 tables of data share the server folder of an entitled advp to store picture, multi-medium data.

25th entitled tletter table is used for recording mail data in member's mailbox, comprises data below record field: Id, touid, fromuid, content, uptime, Lid, s, f, read, ans, wherein id field is used for recording this note Serial number this table major key of record；Touid field is for recording this letter addressee's register account number uID field corresponding to u table；fromuid Field registers the account number uID field corresponding to u table for recording addresser, and 1 expression is transmitted by webmaster；Content field is used for record Communications content information；Uptime field is used for recording transmitting time；Lid field is used for recording whether this mail is to reply part, n institute's generation This letter in reply of the digitized representation of table be for the id of former mail, 0 represents it is initial first envelope；S field is used for recording mail classification, point For consumer's letter, guide writes letters, three classes write letters by webmaster；F field record communications content is audited by webmaster the most, and 0 table is unexamined, 1 table is by examination & verification, and 2 tables are not by examination & verification；Whether read field record reads, and 0 table mail is not read, 1 table oneself read；ans Field is used for recording whether this mail has responded to, and 0 table is not replied, and 1 table is replied.

26th entitled transfer table, for recording the transfer information record of webmaster approval, comprises data below record word Section: id, udid, f, q, acc, co, wid, uptime, wherein id field is for recording serial number this table major key of this record； The registration account number of this consumer of udid field record member or trade company's registration number of operating service class member, f field record membership class, q Field record is withdrawn deposit, and transfer amounts, acc field record proceed to account row and title, co field record proceeds to the account of account, wid word Segment record is responsible for website staff's job number of examination & verification, uptime field record audit time.

27th entitled examine table, for recording the website examination data to every net about guides, comprises following Data entry fields: id, uid, content, rank, tlimit, sort, uptime, mid, wherein id field is used for record Serial number this table major key of this record；Uid field record is examined member's account number of guide；Content field is used for recording examination and comments Language data；Rank field is used for recording examination grade；Tlimit field is used for recording the examination time limit；Sort field is used for recording examination Classification, is divided into monthly appraisal, quarterly review, annual screening three class；Uptime field is for recording the time that examination occurs；Mid word Section is for recording the job number of examination personnel.

The punishment record that net is about conducted a sightseeing tour by the 28th entitled punish table for record, comprises data below record field: Id, uid, conetnt, rank, uptime, mid wherein id field is for recording serial number this table major key of this record；uid Field record is punished member's account number of guide corresponding to the uID field of u table；Content field is used for recording punishment detailed content number According to；Rank field is used for recording punishment level；Uptime field is for recording the time that punishment occurs；Mid field is used for recording pipe The job number of reason personnel.

The bonus record that net is about conducted a sightseeing tour by the 29th entitled award table for record, comprises data below record field: Id, uid, conetnt, rank, uptime, mid wherein id field is for recording serial number this table major key of this record；uid Guide member's account number that field record is commended；Content field is used for recording bonus detailed content data；Rank field is used for record Bonus grade；Uptime field is for recording the time that bonus occurs；Mid field is for the job number of record management personnel.

Secondly the related pages that design grid platform net is about conducted a sightseeing tour.

The homepage of module of first about conducting a sightseeing tour net is designed, and first selects a Page Template or designed, designed one in development platform Page layout framework, then by the technical characteristic of the present invention with realize content by layout framework form classify layout in this page also Write relevant background program and perform code.At this, we utilize form to carry out the fast layout page, and its Design view is as it is shown on figure 3, first Inserting the table of multirow three row in the page, the width of table is exactly the width showing information during page operation, takes 1100, by table herein The first row three row of lattice are merged into a line string, and this journey is that the title of full page is for showing website logo or relevant to net about guide Advertisement and news picture also arrange corresponding link, allow online friend one click on depth information that picture could forward or check that this picture is relevant to or Details display interface, the realization that picture shows a: first picture control is set in the first hurdle, then from data base adv1 In tables of data by up-to-date advertising pictures data retrieval out, then picture control is bound with the image data retrieved, the most again Being linked to details interface plus a hyperlink, first entitled adv1 table is for recording the advertising pictures address letter uploaded every time Breath, when uploading, advertising pictures data are stored in this advp file by system simultaneously, and second Zhang Mingwei adv2 table is for record The extension of advertisement of homepage title position about conducted a sightseeing tour by net or details comprise picture address information and Word message, its picture or many matchmakers Volume data information with different file name records, is capped to prevent file from bearing the same name, uploads storage writing in advp file Can be plus the content such as table code name and service code number being under the jurisdiction of tables of data in the naming rule of filename when depositing code.Uploading of data Can be arranged in background net management work space, first upload advertising pictures, picture address information record in first table adv1 table, picture, Multimedia data recorder is in advp file, and after success, system records this picture sequence number in tables of data i.e. No. aid, then Upload the extension picture belonging to this advertisement and Word message again, together No. aid is recorded in the aid field of adv2 table when uploading, table Show that No. aID all with first table adv1 of each data information that second table adv2 table recorded associates.

Arrange to show the content of five aspects in a second row: content 1, displaying log in the identity information of member, as " you get well certain Certain！", its implementation: registered members's name is retrieved from its log-on message log u table, is then bundled in this position Put；Content 2 shows that " guide practitioner with service enterprise's entrance ", guide click here and i.e. may have access to website guide and work sky Between, enter work space and carry out the operation be correlated with, when to have any to illustrate be exactly to enter work space after related personnel clicks on, be herein System is provided with such a safety measure: when entering work space system first according to the identity information of this member from the u table of data base In retrieve the value of identity category flag field of this member and the value of management qualification f1 and the f1 of dp table whether opening guide service Value and check, only when its identity category is guide and has opened visitor (i.e. u table f1=1, the dp table of online management qualification F1=1) this work space of being allowed for access, otherwise jump to conduct a sightseeing tour practitioner's information submit to collect interface；Content 3 arranges mine Account identification, online friend clicks on the account displayed page that can jump to he or she, checks that the account balance of oneself or the account for oneself are filled Value, application etc. of withdrawing deposit；Content 4 arranges my order note identification, and webpage, by clicking on this mark, can jump to show this net The navigation page of the order that friend once submitted to, it is possible to click on " I guide to be looked for " in this page and enter tourism offer initiation interface, The tour plan uploading oneself allows guide to throw list；The navigation information block clicking on order can check the details of this order.Content 5 Guidance path bar is set and i.e. shows the position " so-and-so website > > net about conduct a sightseeing tour homepage " being presently in.

Tourism offer about online friend initiates interface, comprises tour plan content, touring line, number of forming a team, assemble place, The typing window (can realize with style frame control) of the information such as plan browsing time and a submission button, promoter is by information above Clicking on after typing in typing window and submit button to, system data above will upload to platform together with the registration account number i.e. UID of submitter Under field name corresponding in tourTeam table in data base, the value of f field is set to 2 expressions simultaneously and is initiated by consumer visitor, The value of fd field is set to represent competition for orders ongoing 1.

About consumer visitor member account displayed page, display content comprises: the remaining sum of the previous year, the transaction details in the current year, Withdrawing deposit application or charging function etc., the remaining sum of its previous year records at the end of each year and once records in the Ubalance table of platform database, when The treasury trade information record in year is in the Uinto table of platform database.The wherein Display Realization of balance data the previous year: first depend on It is retrieved according to account number Uid balance data of the previous year from the Ubalance table of platform database of this member and ties up in display position Fixed, its retrieval coding is: SELECT bal FROM dbo.Ubalance WHERE Uid=@ID and dyear=@y

Wherein ID represents this consumer member account number value, and y represents the year angle value of previous year

The transaction details in the current year shows, is also that account number Uid being first depending on this member will from the Uinto table of platform database The transaction details data retrieval in this consumer current year out forms data set, then at display one detailed displaying block of Position Design, bag Contain: the date, income number, the payment display content such as number, explanation, the most again the field data in data set is moved with display position State is bound, and displaying block carries out multiple data the most again and repeats display and design.Its data retrieval key code is:

SELECT*FROM dbo.Uinto WHERE Uid=@ID and dyear=@y1

Wherein ID represents this consumer member account number value, and y1 represents the year angle value in the current year.

About member withdraw deposit application realization: operator click on " application is withdrawn deposit " mark after can forward to apply for interface, at this Being provided with typing window or the interface of application content in boundary's page, content comprises: number of transferring accounts of withdrawing deposit, and situation illustrates, submits button, Shen to Asking someone to click on after input application documents content to submit button to, application related data is uploaded and is stored in pick in platform database by system In table, website staff checks these applications of withdrawing deposit in background work space, website by managing customer end, by registering account Contact details and applicant proceed to cash by regulation to its account specified being reserved in log-on message after contacting, and perform record of transferring accounts, By managing customer end, record of transferring accounts is uploaded in the Uinto table being stored in platform database.

Realization about account charging function: applicant clicks on " supplementing with money " mark, can jump to supplement interface with money, at this interface In show the points for attention etc. that website receives the accounts information of fund and online friend pays dues and supplement required information with money, arrange simultaneously wired under fill It is worth and by the option of Third-party payment platform payment top.When supplementing with money under online friend selects line, online friend need to submit to online and supplement number (its with money During submission, according to the value of its member's account number UID, system is applied for that number uploads the ain word in the Uinto table being stored in platform database Section records its time of origin under atime field name under one's name, simultaneously), simultaneously by remittance of transferring accounts in the account that website is specified under line, Indicate registration account number i.e. UID or its cash account in this website of applicant simultaneously, website staff according to its application information and Receipt on account data, by under its charging information record in field name in Uinto table, record under uptime field name simultaneously and keep accounts the time, Record declaration word under c field name.When online friend selects by Third-party payment platform payment top, system utilizes prior art real Now with the coupling of Third-party payment platform, online friend is allowed to pay, by Third-party payment platform, the expense of supplementing with money, after expense is paid according to it in website The number actually received, by under its charging information record in field name in Uinto table, is recorded under uptime field name simultaneously The account time, record declaration word under c field name.

The third line: arrange the function of search in Website, the way of search function that one online friend of position arrangement commonly uses herein is as by tourism The entitled key word in sight spot that set meal comprises scans for, and other way of search can be navigate to another page by Advanced Search mark Advanced search page goes realize.The implementation method of function of search herein: a style frame control is first set, inputs search for online friend Key word, then arranges a Confirmation Controls, for verifying in style frame, whether the information of online friend's input meets the requirements, to have prevented people Input malicious code intrusion base, then arranges an operation button such as " searching ", and online friend clicks on this button, and system is i.e. according to input Sight name from data base be used for record sight spot and service product contingency table tourgoods table and produce for recording travelling route tourism The vacation packages comprising these tourist attractions is retrieved by product data registration form tourgoods table and forwards another page to and show, Wang Youdian Hit the vacation packages taken a fancy to and can view the details of this set meal, and the tourism of set meal is conducted a sightseeing tour or the enterprise of service in tourism at place, as Really satisfaction can submit application of joining the Youth League to.In advanced search page, multiple key word can be arranged to scan for, as by price, by group Group's number, qualification grade by guide, temporally by specifying guide etc. to scan for, its implementation is similar with said method, Software programmers can thinking as above can be realized by software code.

Fourth line: being used for arranging vacation packages navigation classification logotype, its classification can arrange according to market situation, arrange bag herein Contain: Southeast Asia tourism, Northern Europe tourism, island trip, Canada of the U.S., the northern scenery, grass garden landscape, western plateau, the south of the lower reaches of the Yangtze River, Modern metropolitan cities, the south of Fujian Province scene, red tourism, Peasants Joy etc..Mark has the link towards lower one page and arranges one for this link simultaneously Individual Transfer Parameters, online friend clicks on relevant classification can view the vacation packages product of the category, and online friend clicks on vacation packages therein Product can view details and the sight spot of association, the hotel information of this set meal, and the relevant information and this product conducted a sightseeing tour of travelling The tourism plan of forming a team, if satisfaction can be thrown list and be submitted application of joining the Youth League to.

Implementation herein: when online friend clicks on mark, the page forwards another page to simultaneously (also can be just with mark by the parameter of this mark Knowledge content is parameter) it is passed on, using the parameter passed over as searching for key word by vacation packages product from data in lower one page Qualified vacation packages is retrieved by the vacation packages product data registration form tourgoods table in storehouse and shows as navigation information (its display packing is identical with the 6th row B2 display packing), browses selection for online friend.When online friend clicks on set meal product therein, by Linking the now page and will jump to next page in being provided with herein and the sequence number of set meal product transmitted simultaneously, lower one page will be according to this The details of this set meal product are retrieved formation data set from the tourgoods table of data base by related data by one parameter, so After in the page show, show details and the information of relevant sight spot, hotel information and guide thereof of this vacation packages product.Tool First product serial number foundation passed in lower one page when body realizes is by the details of this product, guide member's account of this product Number be retrieved from tourgoods table simultaneously according to the guide member's account number retrieved from U table, dp table, dpphoto table, Atourserve table, complained table hand over the related information retrieval of this guide out to show in the page, and foundation passes over simultaneously Product serial number sight spot relevant for this product, hotel sequence number are retrieved from contingency table simultaneously according to the data herein retrieved by sight spot, Hotel data are retrieved from view_spot table, form data set, then by the data that retrieve above in the display position of the page Show after carrying out data binding.Also can show the tourism the formed a team plan of forming a team of this product further, online friend also can be to wherein Arbitrary plan of forming a team carry out throwing single submission to and add application, its relevant implementation sees relevant narration below.

Fifth line is for showing the relevant information data of outstanding guide, and a middle A2 hurdle, hurdle is for showing the head of these outstanding guides As picture and brief character introduction, online friend clicks on selected tour guide information and shows that block can forward the business interface of this guide to, in this industry Business interface is shown the evaluation of travelling route set meal that this guide once directed and visitor and feedback information and the tourism guide pin bushing released With the information of forming a team, online friend clicks on these vacation packages released and the information of forming a team, can check the details of these travelling products with Depth information is introduced, and the submission that can place an order adds the application of tourist group.Implementation method be by website set high-quality guide choose way from Selecting standard compliant personnel in numerous guides of entering to be given to concentrate displaying, the personnel portal management personnel being selected are existed by backstage The value of the oks field of the registration information log U table in this meeting changes 1 into, and provides a ranking value and be recorded in U table Oksp field (the operation interface herein being arranged a backstage by software work personnel is uploaded to the typing completing data above with submission). The realization that the high-quality guides of website front end shows: from the value of the oks field of the member registration log U table foundation U table of data base Be 1 member's head phase and related text information retrieval out, by the oksp field of U table value sort, then in high-quality guides's exhibition Show one Image control of position arrangement and bind with the head image data retrieved, carry out after relevant display position at word binding together simultaneously Composition display unit also leads to another display details and the hyperlink of the depth information page plus one, and carry out many to displaying block Weight Data duplication display design, uses the method for data list to carry out as can be, i.e. can reach display multidigit high-quality guides, Can design herein and be shown as 30, be configured when arranging data list.More high-quality guides can be by this place " more ... " mark navigates to another page and shows, can be satisfactory guides is whole or paging divides in this page Showing with criticizing, browse selection for online friend, online friend clicks on selected tour guide information and shows that block can forward the business interface of this guide to, The evaluation of travelling route set meal that this guide once directed and visitor and feedback information and the trip released is shown in this business interface Trip guide pin bushing and the information of forming a team, online friend clicks on these vacation packages released and the information of forming a team, can check the detailed of these travelling products Information and depth information introduction, and can place an order and submit the application adding tourist group to.The implementation method of its implementation and herein continuous item The related data of this guide is retrieved from the relative recording table of data base by guide's member's account number that basically identical i.e. foundation passes over Rear formation data set, then carries out dynamic binding by data set field in display position, i.e. can reach the purpose of display.

On the A1 hurdle, hurdle, the left side one of fifth line for show vacation packages product that outstanding guide directs by venue navigation of setting out Lookup mode, viewing area can be listed some main concentration cities of setting out, such as Beijing, Shanghai and Nanjing etc., online friend clicks on The city chosen then can forward another page of display to all tourism sets directed by outstanding guide formed a team choosing city as departure place Meal product, clicks on the vacation packages product chosen, can check being discussed in detail of this set meal product in another interface, and can place an order and carry Accompany each other into the application of tourist group." more ... " at click A1 hurdle then forward another to and show by the page of more city navigations, at this page Can show in batches with city, place, departure place or the paging of all vacation packages products of record in display system in face, online friend clicks on choosing In city then can forward to another page display with all vacation packages directed by outstanding guide formed a team choosing city as departure place Product, clicks on the vacation packages product chosen, can check being discussed in detail of this set meal product, and the submission that can place an order in another interface Adding the application of tourist group, the display of data herein relates to tourgoods table i.e. travelling products set meal data logger and tourTeam Form a team planning chart.

On the A3 hurdle, hurdle, the right one of fifth line for showing the preferential promotional items of vacation packages that outstanding guide releases, online friend clicks on The promotional items chosen, can check being discussed in detail and the information of outstanding guide of this set meal product in another interface, and can place an order and carry Accompany each other into the addition application of tourist group of this set meal product." more ... " in click A3 hurdle then forward another to and lead by more promotional items The display page of boat, in this page can with display system in the tourism set directed by high-quality guide of all sales promotion that coming into force of record Meal product item or paging show in batches, and online friend clicks on the promotional items chosen, and can forward the tourism of another page of display selected item to Being discussed in detail and outstanding tour guide information of set meal product, and the addition application of the tourist group submitting this set meal product of addition to that can place an order.

On the information data of each vacation packages product that the 6th row is released for the guide member showing this website, a middle hurdle B2 hurdle is used for showing that each vacation packages product item is fixed tentatively as showing 30 projects herein, and more project is by " more ... " of this column Mark navigates to go display in another page, and display packing can add related text composition by the sight spot representative image comprised in product and show letter Breath block carries out the display of multi-group data and shows, online friend clicks on selected exhibition information block can forward the details of these set meal travelling products to With depth information introduction and this project tour guide information introduction and the information offer information page of forming a team, and under the offer of forming a team chosen can being carried out Single application adds the tourist group set by offer that forms a team.Implementation method: i.e. first with me as aforesaid related content display packing The display packing (number of patent application: 201510537300.8) of a kind of data message of previous patented technology designs tourism set in B2 hurdle The displaying scheme of meal product item, the displaying block first using form quickly to design a vacation packages product (is shown with word by picture control Show that district is constituted), then design data source or data set (hereafter referred to collectively as data set) are by the picture control in displaying block and text importing Corresponding with the data set respectively data in region are bound, and then related content in displaying block adds a page jumping to details The hyperlink in face, and displaying block is carried out multiple data repeat display design, herein use data list design (its key code For:

< asp:DataList ID=" DataList1 "

Runat=" server "

RepeatColumns=" 4 "

RepeatDirection=" Horizontal "

RepeatLayout=" Table "

DataSource="<%#DataSet2.DefaultView%>">

<tr>

<td width=" 210 "><div align=" center "><a href=" tour_goods2.aspx？Id=< %#

DataSet2.FieldValue (" id ", Container) % > " target=" _ blank " >

< asp:Image width=" 210 " ID=" face_image " ImageUrl=< %#

DataSet2.FieldValue (" rFace_image ", Container) % > runat=" server " ToolTip=" clicks on picture to check In detail "/>

</a></div></td>

</tr>

<tr>

</tr>

</table>

</itemtemplate>

</asp：DataList>

And the design of data set be by this platform database about the related data of vacation packages product from server and data Being retrieved formation data acquisition system in storehouse, relate to tourgoods table and tourgoodsp file, the key code of its retrieval is: SELECT top 30*, (' tourgoodsp/ '+paddr) as rFace_image FROM dbo.tourgoods WHERE f=1 Details and depth information introduction and this project tour guide information introduction and the information offer information page of forming a team, this page about travelling products Bread contains: the detailed depth information of vacation packages product shows, for this set meal offer of forming a team etc. as shown in Figure 4, its concrete implementation Mode provides an example herein as it is shown in figure 5, the banner part of the i.e. page in the first row A hurdle, that is first hurdle, is used for placing website and puts down The related information content of platform, if any relevant advertisements news etc., its implementation is shown in above homepage part.

Fig. 5 the second behavior B district, point two subregions of B1, B2, the B1 subregion on the left side is used for placing vacation packages product and has generation The sight spot picture of table, the B2 subregion on the right is used for placing the related introduction of vacation packages product, its implementation and master herein Page display packing is similar to, and i.e. to picture to be shown, first arranges a picture control in its position, then examines with from data base Picture address information field in the data set that rope goes out carries out dynamic binding, also will retrieve text importing district from data base Word message field in data set carries out dynamic binding, and retrieve is for recording travelling products data in data base herein Tourgoods table, relates to the image data in tourgoodsp file simultaneously, and its search condition is based on prevpage and transmitted Sequence number i.e. No. ID of the vacation packages product come is carried out, and key code is:

SELECT*, (' tourgoodsp/ '+paddr) as rFace_image FROM dbo.tourgoods WHERE ID=@ID

@ID represents sequence number i.e. No. ID of the vacation packages product passed over according to prevpage

Arrange mark and the link of " checking that visitor evaluates " in the bottom in B1 district, the evaluation page that can forward to of online friend's click is looked into See that oneself, through experiencing experience and the evaluation of the visitor of this vacation packages product, evaluates page implementation method: first click on online friend and " look into See that visitor evaluates " time page jump pass over to this page and by No. ID of this set meal product, this page is by the ID passed over Evaluation content is retrieved formation data set from the assess table of server database by evaluation information by parameter, the pass of its retrieval Key code is:

SELECT*FROM dbo.assess WHERE goodsid=@ID and f=1

Then in the page, insert a form be quickly evaluated the display design of information, the first behavior page platform of form Head, for arranging the related content of website, the second behavior title, the third line for the displaying of evaluation information, its implementation be by Opinion rating, evaluation content field and time field in this place data set, the id field of appraiser is in the relevant position of display Carry out binding one display unit of composition, then display unit is carried out multiple data and repeats display design, can realize this trip Relevant visitor's evaluation information of trip set meal product displays, and browses for online friend.

The C district of Fig. 5 the third line is for showing the sight spot or the leisure cuisines data letter of hotel and offer thereof that travelling products are relevant Breath, arrangement is the explanatory note on left side picture+the right, and its implementation is essentially identical with the above, is all i.e. to show The picture shown, first arranges a picture control in its position, then with the picture address in the data set retrieved from data base Information field is bound, and is also that the Word message field in the data set that will retrieve from data base is tied up to text importing district Fixed, what its difference was to retrieve herein is for recording sight spot and hotel details picture, multimedia data information in data base View_spot log is provided with the picture multimedia document data record folder corresponding with this table simultaneously in the server View_spotp file, its search condition be based on the vacation packages product that prevpage passes over sequence number i.e. No. ID retrieves One nested subquery of No. id of hotel, sight spot, finally retrieves this sight spot or the picture in hotel and character introduction key code is:

SELECT*, (' view_spotp/ '+paddr) as rFace_image FROM dbo.view_spot WHERE spotid= (SELECT spotid FROM dbo.tourspot WHERE tgoodsid=@ID)

Fig. 5 fourth line i.e. D district, for being shown as the group travel plan of this vacation packages product design, is used for showing up-to-date Going on a tour the plan of forming a team, a set meal product can have multiple plan of going on a tour, and can release again new going on a tour after front implementing plan of going on a tour Plan, local area only shows the most rows of part of forming a team, its displaying scheme also with described above almost, will form a team plan from Being retrieved in the tourTeam table of server database, the key code of its retrieval is:

SELECT*FROM dbo.tourTeam WHERE goodsid=@id and process=0

Process=0 represents that retrieval is formed a team this part plan of forming a team of well afoot, and not here it is shown that complete to form a team.

Then the main information formed a team in display interface arrangement is shown and adds the link jumping to details interface, aobvious Show that content includes: guide director, number of forming a team, departure time, set address price etc., it is achieved method: with above method class Seemingly, first carry out the data binding of relevant field in viewing area, form displaying block, then displaying block is carried out multiple data and repeats display and set Counting, when program is run, all plans of forming a team being among recruitment of this vacation packages product all can show, online friend clicks on choosing In the plan of forming a team, the details that can jump to this plan are shown that interface is checked, and can be placed an order and submit the application into travel party to.

INTERFACE DESIGN and the design applying for submitting to of joining the Youth League that places an order is shown: its details are shown about plan details of forming a team The implementation method at interface is basically identical with exhibition information method above, inserts a form and quickly arrange interfacial structure, so in the page After the information that need to show carried out data with the data that retrieve from server database in display position bind, its pass retrieved Just the same with above of key code: SELECT*FROM dbo.tourTeam WHERE ttID=@ttID

This interface requirements shows some more detailed information contenies that the plan of forming a team is relevant, comprises: the guide of tourist group briefly believes Breath (such as main guide head phase, name, qualification etc.) lead to the link at details interface, form a team plan number, number of applicants, Residue name specified number (implementation method: be planned out visitor's number one number of applicants by forming a team and draw), planned time of going on a tour, finally determine Go on a tour venue and time, the information of the insurance products included in price, price, the time that originally plan of forming a team is issued, this plan Publisher be who etc. information, wherein click on guide's head portrait or Word message can view the details of this guide, can be by arranging Hyperlink jumps to go in another interface to show to realize.The identity information of guide, working letter can be shown at the details interface of guide The contents such as breath introduction and qualification information, visitor's evaluation information and website examination information.

Design about adding tourist group's application: being first required to be visitor and design an application submission little module, its Design view is such as Shown in Fig. 6, comprise: number of applicants (wherein male how many people, women how many people), telephone number, full name of applicant, applicant The contents such as the item that sex, applicant's age etc., prompting client note, above essential information typing is clicked on and is submitted button to by online friend, page Face forwards page 2 to, and submission function herein is that the information collected by above input interface and the application are under the jurisdiction of the plan of forming a team Sequence number i.e. ttid, the team_Apply table being committed in platform database, charge to and store under the field name of correspondence.Data are submitted to successfully The rear page goes to page 2, and the information that upper page is committed in this page data base shows that confession applicant checks verification, goes back as wrong Can submit to after this page editor, this page arrange simultaneously pay dues mark or button and go on a tour personnel individual's relevant information submit to mark or button, Enter related interfaces for online friend after clicking on to carry out paying dues and submission is gone on a tour personnel's personal information.Wherein online friend enters after clicking on mark of paying dues and hands over Taking interface, interface of paying dues has been listed many families third-party payment platform mark and has linked or the confession online friend's selection of other way to pay dues, herein Module of paying dues is to utilize existing electricity business's technology of paying dues to realize, and is the common knowledge being engaged in electricity business development field technical staff, is herein Save space and narration is not repeated；About the submission of the personnel associated personal information that goes on a tour, an input interface can be separately provided and carry out, Allowing online friend enter after clicking on respective identification or button in this interface and input submission after relevant information, information is uploaded record data base by system In team_ApplyP table corresponding field under one's name, content comprises: visitor's name, visitor's sex, age, visitor's identity document name Claim and the data such as passport NO., visitor's telephone number, visitor address, visitor household's telephone number, visitor's occupational information, simultaneously should be by The sequence number of the application record corresponding to this visitor i.e. taid together submits to, and record is under the taid field name of team_ApplyP table.

About order management, online friend can enter order management page by clicking on about conduct a sightseeing tour " my order " mark of homepage of net The order of facial canal reason oneself, its content comprises: checks the order of oneself, cancels an order, and edits order, comments order consumption experience Valency is shared with sense of reality, client the unhappiness occurred in consumption is complained (also can be arranged in platform other local) with Complain the contents such as feedback, as shown in Figure 7.Its specific implementation, arranges an order management page, and in the page, every order is pressed Order display unit shows, comprises in each of which display unit: product set meal brief information displaying that order is corresponding, order status, Consumption status, wherein order status is divided into normally, needs two kinds of situations of updates, during consumption status such as is divided into carry out to be consumed, the consumption, Consumption terminates three kinds of situations, and during the design page, we first set up data set, according to the log-on message such as member ID of this online friend, by this member Sequence information be retrieved from the team_Apply table and tourgoods table of platform database, its key code is:

SELECT a.taid, a.upuid, a.uptime, a.orf, a.cf, t.content FROM dbo.team_Apply a,

Dbo.tourgoods t WHERE a.upuid=@uID and a.goodsid=t.ID

Wherein@uID represents member's account number uID of online friend, and system can pass through Session (uid) variable record in addition when this member logs in, In case using at any time.

Then in the page, insert a form quickly arrange that the page shows structure, as shown in Figure 8, be respectively provided with order sequence Number, order set meal, the date that places an order, order status, consumption status, check and wait in detail column, then in the corresponding position on the second hurdle Carry out data binding respectively with corresponding field in data set, and " checking in detail " mark under checking detailed column arrange a link, Program is issued online friend's click when running and can be jumped to the details displayed page of this part order and the sequence number of this order be passed on, Then the binding data to the second hurdle carry out multiple data repeat display design (using the method for designing of repeat region) herein, i.e. up to To in this page, the vacation packages product order of this member is all shown.

Its content shown of order details interface comprises: add the detailed content of tourist group's application, such as application submitter's letter Breath, adds the number of tourist group's application, wherein each how many people of men and women, and personal information of respectively joining the Youth League submits situation, reserved phone number to, Application submission time, paying information, guide audits situation information；The related content of this plan of forming a team: the tour guide information of this plan of forming a team, The plan travel time, the set time specifically determined and assemble place, number of forming a team, the number the most registered, incidental insurance Product situation；The information of this vacation packages product of going on a tour is such as: the particular content of this vacation packages product or with access this vacation packages product The link at details interface and correlated identities information.Wherein reserved phone number provides amendment editting function, simultaneously in this page Following mark and link be set: checks personnel's data of joining the Youth League, supplement personnel's data of joining the Youth League, additionally buy tourist insurance, pay dues, its In check join the Youth League personnel's data mark, online friend click on after can jump to the detailed interface of personnel's data of joining the Youth League, show in this page and join the Youth League Personnel's data, editor's change of its related data, its implementation can be by personnel's data team_ApplyP from data base that joins the Youth League Table is retrieved item by item according to order sequence number, the then style frame control bundle that show position corresponding to displayed page, if needing to repair Reorganization volume, then submit to data base to store the content after amendment editor；Supplement and join the Youth League personnel's data, be for there being online friend to place an order after Also not submitting to and join the Youth League member's data or situation about all not submitting to and set up, now click on and supplement personnel's data mark of joining the Youth League, the page is i.e. Jump to the submission interface of the aforementioned personnel associated personal information that goes on a tour, carry out typing and the submission of data.For additionally buying tourist insurance, Be for indivedual visitors to set meal outside the demand of insurance products and design, outer chain third party insurance product electricity business's platform chain provided herein Connecing, online friend forwards third-party platform to after clicking on and buys required insurance products voluntarily.About paying dues, it is for having submitted to order the most not The consumer that pays dues and design, a link is set herein, allows consumer click on mark of paying dues and can jump to the aforesaid boundary that pays dues Face carries out operation of paying dues.Cancelling an order function, visitor clicks on cancel button mark, and this order can be added tourist group Shen online friend by system The value of accept field of information team_Apply table please change into " abandoning ", situation illustrated record in c field under one's name simultaneously, Now consumer is as paid dues, then return consumer after being examined by website staff or supplement with money in its account.

To the evaluation of order consumption experience and sharing of sense of reality, the reality that the unhappiness occurred in consumption is complained by client Existing scheme is essentially identical, it is achieved method is Input and the files passe being respectively provided with at operation interface and collecting this this content Asp:FileUpload control and submission button, during running software, operator inputs related content in the text box of corresponding every content (as complained content, complainant's phone, the sequence number of forming a team plan involved by complaint, defendant's account number i.e. uid, complained People's phone, evaluation content, evaluate the sequence number etc. of targeted vacation packages product), or be correlated with by document uploading control selection File to be uploaded such as pictures etc., then click on submission button, and it is corresponding that the content in text box is then committed to server database by system Table in store, or submit the data such as picture to server folder, then picture address information be stored in platform database corresponding In tables of data, the upload code of its concrete file content has been the common knowledge of electricity business software programmers, differs for saving space herein One describes in detail, and the evaluation content only evaluated consumption therein provides critical data storage code as a example by submitting to as follows:

Insert into assess (goodsid, c, uid) values (' " &textBox1.text& " ', ' " &textBox2.Text & " ', ' " &session (" uid ") & " ') "

Wherein goodsid field is for storing the sequence number of the targeted vacation packages product of this evaluation corresponding to Input In textBox1, the content of institute's typing, is inputted by operator herein；C field is for storing the particular content of this evaluation, corresponding to literary composition In this frame control textBox2, the content of institute's typing, is inputted by operator；Uid field is for storing the author of this evaluation, by being Submitter member's account number that system session (" uid ") variable is recorded provides.The realization complained can refer to herein below to the most civilian Bright visitor complains implementation method to realize.

Complaint feedback information is checked by submitter: can arrange a calling information feedback interface in order management module, should Interface comprises: show the content complained, and complained person's reply content shows, the statement suggestion replying handling suggestion is uploaded, Whether portal management side processes the contents such as termination to handling suggestion, this complaint of complaint.The implementation method that its information is shown: with aforementioned The data displaying scheme said is essentially identical, will be retrieved formation data set, then by phase by related data from platform database The field closing data is showing that position carries out binding and can realize the display to information above.To in the statement suggestion replying handling suggestion Passing, can be carried out by a radio button control and a submission button, radio button selects " satisfaction " or " no for user Satisfied ", then by submitting to button to realize uploading of data, it is stored in putting down with the serial number storage condition that this complains record The ub1 (storing the statement information replying defendant) of the complained table of platform data base or ub2 (stores and replys webmaster Statement information) under field name, this sentences as a example by being stored under ub1 field name, key code of its storage is as follows:

UPDATE complained set ub1=' "+DropDownListXueli.selecteditem.Text.ToString+ " ' Where Id=" &DataSet1.DefaultView.Table.Rows (0) (" id ")

Wherein id takes the value of this sequence number complaining record.

The work space about conducted a sightseeing tour about net, comprises: guide service business datum is uploaded and managed, processes visitor's complaint, throws Tell uncivil visitor, pay dues, accounts of finance management exchange mailbox, order management etc. with webmaster, visitor.

Wherein guide service business datum is uploaded and is comprised with management: vacation packages product data are uploaded, to the tourism uploaded Set meal product information is safeguarded and edit-modify, in the information of sight spot, hotel and the leisure provided, the cuisines etc. relevant to product Pass with safeguard edit-modify, for set meal product form a team plan upload and safeguard edit-modify, form a team plan relevant information exhibition Show and browse.Data or editor that this place is uploaded safeguard that amended uploading includes lteral data, image data or other multimedia Data, its implementation is all to arrange a Data Enter interface in client, by style frame or picture, files passe control in interface Edit operation interface is uploaded or revised to part composition, clicks on " upload button " and realize uploading after online friend's typing relevant information data.Word Data are uploaded in the data logger being stored in platform database correspondence, by file data when picture or other multi-medium data are uploaded Upload to be stored in the Photo folder that Platform Server is corresponding and then the storage location address information of this document is stored in platform number According in data logger corresponding in storehouse.In the data base that vacation packages product data are corresponding herein, data logger is tourgoods Table, corresponding file is tourgoodsp file；Data in data base corresponding to sight spot that product is relevant, hotel information Log is view_spot table, and corresponding file is view_spotp file；Plan of forming a team institute for set meal product is right In the data base answered, data logger is tourTeam table.Plan information of forming a team shows the implementation method and aforesaid Information Number browsed Substantially similar according to exhibition scheme, i.e. first pass through a brief information display interface of forming a team and show, online friend clicks on therein One display information shows block, and the page i.e. jumps to the detailed plan of forming a team and shows not only may be used in this detailed interface in interface, guide To view specific plans of forming a team, it is also possible to viewing visitor's situation of participating in for this plan of forming a team, guide can be right This is signed up with and carries out accepting or abort operation, and carries out situation explanation to applicant.Showing interface is shown in the plan of forming a team Content comprises: program content of forming a team, tour guide information, plan number of forming a team, accepted number of registering and men and women be each how much The sequence information that the number that people, registration etc. are pending, the pending sequence information such as display and display have been audited, therein etc. Pending sequence information and the displaying of sequence information audited are divided into brief information display display, and operator clicks in display Hold and i.e. jump to these order details displaying interface, and can carry out accepting and abort operation, and server count is submitted in the explanation of typing situation to According to storehouse.Wherein form a team program content, tour guide information, the realization of plan number of forming a team: pass over when first redirecting according to front page This form a team plan sequence number from plan of the forming a team log tourTeam table of platform database with member's log-on message log forming a team letter With guide's director's name searching out, then the display correspondence position at display interface carries out data binding to breath, the key generation of its retrieval Code is:

SELECT a.na, t.*FROM dbo.tourTeam t, dbo.u a WHERE t.ttID=@ID and a.uid=t.uid1

Wherein@ID is this plan sequence number of forming a team that front page passes over when redirecting.

About accepted number and each how many people of men and women, the implementation of the number that registration etc. are pending of registering: first foundation Front page pass over when redirecting this form a team plan sequence number from the registration log team_Apply table of platform database data Collecting and be retrieved, then the display correspondence position at display interface carries out data binding, and its retrieval key code is: accepted people Number collects

SELECT sum (q) as q1, sum (mq) as q2, sum (wq) as q3 FROM dbo.team_Apply WHERE ttID=@ID And accept=' accepts '

The number that registration etc. are pending is retrieved and is collected key code: SELECT sum (q) as q2 FROM dbo.team_Apply WHERE ttID=@ID and accept=' is pending '

Wherein order details show that the implementation at interface is similar with other data message display mode herein, first from platform The order record table team_Apply table of data base and order registration member's table team_ApplyP table go out related data retrieval Come, then one order brief information of design display interface, click on display information therein can view this order details and The information of participant, and corresponding operation can be completed by the acceptance in interface with abort operation button and (refer in pending trial order interface Operating function, clicks on and accepts or the operation button abandoned, system according to the sequence number of this order by team_Apply table in data base The value of accept field is rewritten into corresponding value, such as the accept button clicked on, then data rewriting is become " accepting "；If clicked on Abandon button then by data rewriting become " abandoning "), and can by style frame input guide explanation suggestion, then click on and upload Button realizes uploading of explanation opinion data, explanation data is stored under the c field name of order record table team_Apply table.If Guide selects to abandon order, and it can be paid dues the accounts of finance returned to this member that places an order by system according to the situation of paying dues of the member that places an order Middle record is in the Uinto table of platform database.The member that places an order can buy other products or the service that website provides the most again, Also can withdraw deposit to platform application.

Complain about processing visitor: a page can be separately provided in work space, first in the suitable position of homepage of work space Installing a calling information block display complaint has several to need to process (implementation method: with No. uid of this guide for search argument from complaining note Defendant's statistical data is retrieved by record table complained table and forms what then data were concentrated in display position by data set Data carry out binding, and its retrieval key code is: SELECT count (id) as c FROM dbo.complained WHERE tuid =@uid), if or being designed to complain this chunk to show, without complaining this chunk to conceal (implementation method: used by displaying block Asp:Panel control controls its display, if herein in data set complain the number of packages i.e. value of c more than 0, then asp:Panel control Display properties be that true i.e. displaying block shows, otherwise the display properties of asp:Panel control is false), staff clicks on this Individual mark can redirect this complaint handling page of entrance.

In complaint handling page homepage, displaying by the displaying block being complained navigation information to form by each bar, this displaying block has listed this The brief information that bar is complained such as complains title, complains the time, and complainant member uid etc., the homepage page is divided into three bulks and shows: quilt Complainant is the most untreated, the own reply of defendant processes but also wait that webmaster examination & verification is passed through, audited by webmaster and to have wound up the case. Defendant clicks on the content in displaying block can jump to lower one page process operation pages.Its implementation and above data display side Case is basically identical, i.e. uses the complained calling information log from data base by information retrieval complained for this member out shape Become data set, then relevant field data are bound with the corresponding position in displaying block, then add one towards next process page Link and this sequence number complained is passed on as parameter, then displaying block is carried out multiple data and repeats display and design. Except that carry out retrieving three different classes of data of formation respectively herein for three big displaying blocks according to different search keys Then three bulks are carried out display design by collection respectively.First bulk replys complainant for showing that defendant not yet processes, its inspection Rope condition is: the account number of defendant i.e. tuid=@uid and f1=0, wherein f1=0 represents untreated complaint；Second bulk Also waiting what webmaster examination & verification was passed through for showing the own reply of defendant, its search condition is: the account number of defendant i.e. tuid= @uid and f1=1 and f2=0, wherein f1=1 represents processed reply complainant, and f2=0 represents that webmaster is the most untreated；3rd Bulk is for showing the processed complete complaint wound up the case of defendant, and its search condition is: the account number of defendant i.e. tuid=uid And f3=1, wherein this complaint of f3=1 table is processed complete.

The design at complaint handling interface and realization: point two parts, i.e. complain related content display part, defendant to process The operation part complained；Related content display part is complained to comprise: to complain title, complain content, the demand of complaint, the meeting of complainant Member account number, name, telephone number, complain involved by theme form a team program content with link and vacation packages product content with link； Defendant process complaint operation part comprise: defendant reply complainant to complainant apology explain why and how operation interface, thrown Tell people to webmaster complaint and to illustrate, to the operation interface of the contents such as complainant's reimbursement.Its information display section part and the implementation of link thereof Basically identical with aforesaid information display scheme, except that following three data loggers here related in platform database: Complained table record user, visitor's calling information and disposition data；The tourTeam table record travelling products plan of forming a team； Tourgoods table is used for recording travelling products data, need to carry out multilist conjunctive query during its data retrieval, and its inquiry key code is as follows:

SELECT c.*, t.*, g.*FROM dbo.complained c, tourTeam t, tourgoods g

WHERE c.toteamid=t.ttID and t.goodsid=g.id and c.tuid=@uid

Defendant replys the realization of complainant's operating function: arrange an Input and a submission button in interface, During running software, defendant inputs the reply suggestion of oneself in this style frame, then clicks on submission button, and system is then by text Content in frame is committed to server database, is stored under the tanswer1 field name of table complained, the upload code of submission For the common knowledge of electricity business development field technical staff, narration is not repeated for saving space herein；Also quilt can be realized by same method Complainant is to the operating function of webmaster complaint with explanation, and data is uploaded and be stored in server database complained table Under tanswer2 field name.Data can be retrieved from data base by respective client and show by complainant and webmaster personnel View reply and the relevant information of defendant.

Realization to complainant's reimbursement: proposed to transfer accounts application to webmaster by mailbox by defendant, then by webmaster examination & verification together Complete after meaning to transfer accounts, account and complainant's account of defendant will complete data change, herein be related to the Uinto visitor of data base Accounts of finance discrepancy log and dpinto managerial setup finance discrepancy credit.Implement is also may be used in background net management work space In defendant's work or working place, first design one operation interface comprises: the financial account typing window that produces, the finance proceeded to Account typing window, transaction are through volume typing window, an executive button.The typing window of information can be realized by Input, is System also need to record transfer amounts after transferring accounts successfully under the qb field name of calling information log cpmplained table, and these can be by holding In the click event generation of row button, realizes.

About complaining uncivil visitor, a complaint interface need to be set in working place, comprise complaint content, complained acknowledge a debt Number, the typing window (being used herein as style frame control to realize) of defendant's telephone number etc., submit button, the evidence of second step to Picture is uploaded (being used herein as document uploading control to realize) and submits to button to realize uploading of data, is uploaded by calling information and is stored in In the complained table of platform database, when uploading evidence picture, the function that online friend utilizes document uploading control to provide selects The picture file passed, then clicks on upload button and realizes uploading, picture and file are now stored in the file of Platform Server proofp Folder, its address date is stored in the cpproof table of data base, simultaneously by the proof field of calling information log complained table Value change 1 into.

About the account management of guide, every guide practitioner is applied for providing guide service to carry out title examination by website, as Fruit is by examining, its online management qualification will be authorized in website, produces thereafter treasury trade system by its treasury trade information record at platform In the dpinto table of data base, an account management page is set in guide's work space simultaneously, comprises in this page: account balance Data query and display, pay dues, the functions such as application of transferring accounts of withdrawing deposit, and " checking mark in detail " of clicking on balance data viewing area can look into See the account contact detail in given month.The wherein Display Realization of account balance data: be first depending on the operation registration dpid of this member Number the income of this month of this member sum total collected out and shown from the dpinto table of data base with entering an item of expenditure in the accounts, simultaneously will be to upper The remaining sum at the end of month is retrieved display from the balance table of data base, and is showing that the page utilizes code to present block and calculates to inquiry Time account balance sum and shown.

Paying of expense in guide's management functions: comprise and manage paying of annual fee, service guarantees gold etc., its implementation: Pay imformation such as account is announced in website, and the pay imformation such as toll collector's name and address can utilize to be paid outside prior art employing line or online Being paid by Third-party payment platform, plateform system is paid dues by verification the paying information of people, by the paying information record respectively of the people that pays dues In data base for record enterprise of service in tourism and guide practitioner open for business annual fee yfee table in and qfee table for the trip of record Trip service enterprise and guide practitioner open for business service guarantees gold table in；Or carry out, by the safekeeping account of himself in platform, friendship of transferring accounts Receiving, situation of the paying dues record of the people that pays dues directly is entered the annual fee yfee table of data base and guarantee fund's qfee table and to running account table by system Dpinto table carries out record of transferring accounts.

Transfer accounts about withdrawing deposit application realization: operator click on " withdraw deposit and transfer accounts " mark after can forward to apply for interface, at this Being provided with typing window or the interface of application content in boundary's page, content comprises: is provided with and sends to (can use single choice to press without papery application documents Button realize), number of transferring accounts of withdrawing deposit, situation illustrate, if there being papery application documents to send to website staff, paper document need to be described Title and correlation circumstance (words input window can be realized by Input), submit button to, and applicant is at input application documents Clicking on after content and submit button to, application related data is uploaded and is stored in platform database in pick table by system, and website staff exist Background work space, website by managing customer end check this this transfer accounts application of withdrawing deposit, and specify to it by regulation after checking associated documents Account proceed to cash, and perform record of transferring accounts, by managing customer end record of transferring accounts uploaded the dpinto being stored in platform database In table.

About exchanging mailbox with webmaster, visitor: arrange " mailbox of connection " mark in the homepage of guide's practitioner's work space Knowing and linking towards lower one page, online friend clicks on the interface that can forward mailbox of connection to, and this interface comprises: transmits, check reply letter Etc. content.The realization transmitted: arrange one for it and transmit interface, is respectively provided with typing letter properties window, receiver ID in interface Button (window can be realized by style frame control) submitted to by typing window and, and during running software, operator are the most defeated Enter letter content, receiver member's account number (transmit account number to webmaster and take 1), then click on submission button and realize uploading of data, on Passing data to be stored in platform database tletter table, the packet uploaded contains: letter content, addresser's member account, mail Classifications etc., if the letter mailing to non-network management also needs to input receiver member's account number, the classification of mail can be according to the classification transmitting interface Give in software code in advance, it is also possible to radio button is selected to arrange to realize by addresser.Check the realization of letter content: first One letter content navigation interface is set, point do not read and oneself to read two classes by chunk be that unit display is out (as shown letter Front several words of content, letter time, letter people register the contents such as account number), the content in viewer's click information block i.e. adds and jumps to The detailed content of this envelope letter shows interface, checks the detailed content of letter.Implementation method: the realization of mail display and above institute The implementation that the information stated is shown is similar to, and is i.e. that condition is from data base's by member's account number of operator and read state In tletter table, the letter information retrieval belonging to this member out being formed data set, then the display position at display interface is carried out Data are bound, and add and jump the link at past detail display interface and the ID sequence number of this mail transmitted, then displaying block is carried out multiplicity Design according to repeating display.The displaying of details is the most substantially similar with aforesaid same problems implementation, will go out by data retrieval Form data set and then process row binding in display position, except that herein for sequence number ID that condition is letter of retrieval.

Realization about letter is replied: letter details can be arranged in and show the lower section of page, arrange one and reply interface, Replying interface to be made up of an Input and one " uploading " button of " reply " button, operator clicks on " reply " and presses Button, then reply interface and manifest, and then inputs reply content in style frame, clicks on upload button, it is achieved uploading of reply content.On Passing data to be stored in the tletter table of data base, addresser can check reply content in it transmits content displaying page.

Order management comprise examination & verification process visitor join the Youth League application, check to form a team and plan visitor and register the content such as situation, competition for orders, wherein Examination & verification visitor join the Youth League application, check form a team plan visitor register situation above order details displaying interface implementation in Narration, is not repeated herein.About guide's competition for orders, being the guide service demand for visitor's active upload, guide carries out throwing single one Plant operation, its implementation: guide clicks on " competition for orders " mark, can jump to rob single-page, comprise and be in competition for orders in this page Guide service demand offer order brief information block display that the visitor of state uploads and thrown single feedback result.Guide clicks on Any information block therein can jump to this offer order details show interface, in this page guide can view should will The about details of order, can click on throwing button for being in the single ongoing offer of throwing, launch to throw the input of single interface and throw wall scroll part, Then click on submission button and carry out throwing single, oneself was once thrown to single offer, then show that feedback result state is divided into: wait pending, Throw single success, throw three kinds of situations of single failure.Show with aforesaid information about the offer information display its implementation robbing single-page Method consistent the most i.e. by data retrieval, binding, add a link again after carry out multiple data and repeat to show that design realizes, data inspection herein The tables of data that rope relates to is tourTeam table.About robbing the realization of single-page, have in comprising: throw single quotation, quotation is comprised Service content, throw single member registration account number UID, throw the typing window (specific design of the data such as operation account number dpid of list person Time style frame control can be selected to realize) an and submission button, when rob single by above-mentioned competition for orders content typing after click on and submit button to, Under the field name that the ttdrop table of the data base that above-mentioned information is then uploaded to Platform Server by system is corresponding, simultaneity factor is by f field Value is set to initial value automatically: wait pending.Then system shows in the offer administration interface of offer sponsor by throwing single information data, Offeror clicks on offer information, can view all throwings about this offer single, and offeror can select one of them to throw single connecing Identified, then this offer and throw single between contract relation i.e. set up, this is thrown single state and changes " throwing single success " into simultaneously by system The uid1 field of this offer data it is recorded in the tourTeam table of data base under one's name by throwing single registration account number UID, its Its throwing single system is automatically thrown single state and is changed into throwing single failure.Then the visitor of offer can pay the bill online and go to stipulated place on time Accept guide service, throw single successfully guide can provide guide service according to the concerns that contract prepares to service on time.

About the job content in background work person works space, website, comprise: guides opens for business application examination & verification and opens on the net Exhibition service member's various management payment of fees examination & verification, process member's account charging application, process member withdraw deposit transfer accounts application, travel Member's mailbox that the examination & verification of product data, sight spot exchange with member with the examination & verification of travelling products contingency table, plan examination & verification of forming a team manages, place Reason consumer complains, processes the complaint about uncivil visitor, the website management to conducting a sightseeing tour and examination etc..The realization of above content:

Open for business application examination & verification about guides: operator click in the homepage of work space that " guides opens for business application Examination & verification " mark, page jump audits homepage to opening, pending opening application navigation information block, the point such as on view in this page The navigation block hitting any of which can jump to the examination page of this application, and this working page comprises: the application that application personnel submit to Information such as organization names, address, phone, director's name, business scope and content, the work experience of applicant, relevant qualification, Account number that third party opens an account and the picture of relevant qualification documentary evidence, guarantee fund pay the content displayings such as situation and a text box control Part for auditor input examination reports situation illustrate and two operation buttons: by approve after examination opening " passing through " button, Do not meet entry conditions and wouldn't open " not passing through " button of management qualification.Auditor clicks on above behaviour after input examination reports Make button and can complete review operations.The information exhibition scheme of above content is essentially identical with aforesaid data display scheme, does not weighs Multiple narration, the tables of data in data base the most corresponding is that the table of entitled dp is started the business register information table and entitled dpphote Qualification pictorial information table, when auditor's clicking operation button, system examination reports can be illustrated and audit conclusion upload storage to number (i.e. this record respective field is revised with sequence number dpid of this record for search condition under fc, f1 field name according to storehouse dp table Value) and the f1 field name of U table under, wherein when click " by approving opening after examination " button time, the value of the f1 field of U table is changed Being 1, the value of the f1 field of dp table changes 1 into, represents and allows opening by examination & verification；When clicking on " not meeting entry conditions wouldn't open " During button, changing the value of the f1 field of dp table into 2, it is undesirable not by examination & verification that the value of the f1 field of U table changes 2 tables into.

Carry out on the net service member's various management payment of fees examination & verification, comprise service guarantees gold with annual fee pay management, point Two kinds of situations, one is that member passes through to pay online, and another kind is that member passes through manually to pay under line.For the first situation, herein The look facility of the situation of paying should be provided, (implementation method: data paid the fees log qfee table or year from the guarantee fund of platform database Expense payment log yfee table is retrieved, then at display binding positions), and show the contact method of corresponding subscriber membership in the lump Information or transmit mark and connect, it is simple to staff and member contact communication.Member is usually by under line for the second situation Being remitted money to by expenses in the account that website specifies, the payment information record of this member should be entered platform by backstage by staff herein Data base, now should manage registration account number i.e. dpid, specified payment volume, amount paid in number, corresponding payment by inputting this member respectively The contents (can be realized by Input) such as year, then completing submission by a submission button uploads, for guarantee fund It is stored in qfee table by the data system of class, is then stored in yfee table for annual fee class data.

About processing member's account charging application, provide member's to supplement Shen with money including ordinary consumer member with the service managing class Please, in two kinds of situation, one is that member passes through to supplement with money online, and another kind is that member is supplemented with money by line servant's processing fee.For the first Situation, should provide the look facility of the situation of supplementing with money herein, (implementation method: data gone out from consumer's member's finance of platform database Keep accounts log Uinto table or manage the safekeeping account finance of member and go out to keep accounts and be retrieved in log dpinto table, then in display Binding positions, and carry out multiple data repeat display design).Member is usually by being converged by expenses under line for the second situation In the account that money is specified to website, the payment charging information record of this member should be entered platform database by backstage by staff herein, Now should be stepped on by the member registration of input consumer respectively according to the safekeeping account class that the classification supplementing member with money is consumer's class or operator The managerial setup registration account number i.e. dpid of record account number i.e. UID or operator member, actual number of supplementing with money (can be come by Input Realize), then complete submission by a submission button and upload, application is supplemented with money for consumer class member and data should be uploaded storage In Uinto table in platform database, application is supplemented with money for the safekeeping account of operator class member and then data is uploaded and be stored in platform In dpinto table in data base.

Withdraw deposit application about processing member, member can be used to submit application online to, the method manually transferred accounts after webmaster background audit, Therefore need in the working place on backstage to withdraw deposit application and associative operation information (the destiny account information as described in registering account) enter (function or link checking that application member's account contact is detailed for improving safety can arrange herein, allows staff think in row display The account contact situation of application member can be viewed easily the when of being necessary), when website staff examination & verification is thought without exception, (fund transfer system outside platform also can be used manually to transfer accounts for improving safety) by manually transferring accounts to applicant log-on data described in Destiny account in, and transfer data is uploaded in relevant member's account of this platform database.Specific implementation is withdrawn deposit data Display, can use aforesaid data display method, the most first show an application inventory navigation interface, operator clicks on therein arbitrary Application displaying block, can jump to the details display interface of this application, show the detailed content data of application in this interface, with Time be additionally provided with in this page and check mark that the applicant's account comes and goes and link, it is simple to operator check that applicant's account circulates It is provided with " agreement an is withdrawn deposit " button the most simultaneously.The display of request for data of herein withdrawing deposit is by when navigation redirects Data are retrieved from the pick table of platform database by this application serial number search condition passed over dynamically ties up in display position Show after Ding, it is intended that accounts information is based on the value of application membership class that in pick table, f field is recorded and uid, dpid field and divides (the corresponding service managing class does not provides the acc field of the ma field from tables of data U table (corresponding consumer class member) or dp table Chamber of commerce person) in be retrieved after show after display position dynamic binding.The display of the applicant's running account information, is based on foundation Application membership class that in pick table, f field is recorded and the value of uid, dpid field are respectively from (the corresponding consumption of tables of data Uinto table Person member), the dpinto table service provider member of class (corresponding manage) is retrieved, after display position carries out dynamic binding Carry out multiple data and repeat display design.When operator click on " agreement is withdrawn deposit " button, system will demonstrate in interface and proceed to Account information, click on " determination " button then system by Withdrawal Amount, accept account information, by by membership class and registration account number, examine The information such as core employee number, audit time are uploaded platform database and are stored in transfer table, and system is in the work of its finance staff Showing these information in interface, website finance staff performs to transfer accounts operation according to these information.

About the examination & verification of travelling products data, operator click on " examination & verification of travelling products data " mark in the homepage of work space Knowing, page jump to such data audits homepage, in this page on view etc. pending travelling products navigation information block (it is retrieved Condition can be carried out, such as f=0 by the value of tourgoods table f field), click on arbitrary navigation block therein and can jump to this trip The examination page of trip product data, this working page comprises: the display of this product detail information content and pressing for review operations Button: " passing through ", " not passing through ", its implementation examines essentially identical with aforesaid opening application, except that corresponding herein Table in the platform database of operation is the tourgoods table for recording travelling products data, and its examination & verification conclusion is by by navigation page Conclusion is inserted under this f field name recorded by sequence number i.e. No. ID of this data record passed over when redirecting as search condition.

About the examination & verification at sight spot Yu travelling products contingency table, operator click on " sight spot and tourism product in the homepage of work space Product incidence relation is audited " mark, page jump to such data examination & verification homepage, the pending incidence relation such as on view in this page Navigation information block (its search condition can be carried out, such as f=0 by the value of tourspot table f field), clicks on arbitrary navigation therein Block can jump to the examination page at this sight spot and the incidence relation of travelling products data, and this working page comprises: this incidence relation The display of information content and the button for review operations: " passing through ", " not passing through ", its implementation and aforesaid opening application Examine essentially identical, except that the table in the platform database of respective operations herein associates with travelling products for being used for recording sight spot The table tourspot table of system, the sequence number i.e. tsID of this data record passed over when its examination & verification conclusion is by being redirected by navigation page Number as search condition conclusion is inserted under f field name of this record.

About plan examination & verification of forming a team, operator click on " the examination & verification plan of forming a team " mark in the homepage of work space, and the page is jumped Forwarding such data examination & verification homepage to, plan of forming a team navigation information block on view etc. pending in this page (can pass through by its search condition The value of tourTeam table flag field is carried out, such as f=0), click on arbitrary navigation block therein and can jump to examining of this plan of forming a team Core working page, this working page comprises: the display of the details content of this plan of forming a team and for the button of review operations: " logical Cross ", " not passing through ", its implementation and aforesaid opening application examine essentially identical, except that respective operations herein is flat Table in platform data base is formed a team planning chart tourTeam table, when its examination & verification conclusion is by being redirected by navigation page for being used for recording travelling products Conclusion is inserted under this flag field name recorded by sequence number i.e. No. ttID of this data record passed over as search condition.

Processing consumer, the realization of ISP's complaint, operator click on " complaint handling " in the homepage of work space Mark, page jump to complaint handling homepage, the pending complaint navigation information block such as on view in this page, it is divided at webmaster Managed (its search condition can be carried out, such as f2=0 by the value of complained table f2 field) and webmaster processed autre action pendante (its Search condition can be carried out by the value of complained table f2, f3 field, such as f2=1 and f3=0) two part classification displayings, Click on arbitrary navigation block therein can jump to this complaint content the examination page, for this working page of untreated complaint Bread contains: this complaint content, relevant evidence picture, the demand of complainant, defendant reply complainant's information, defendant to net Defendant is replied the attitude of suggestion, (uses style for processing the handling suggestion typing window of operation by the content of pipe complaint, complainant Frame control realizes) and a handling suggestion upload button；Processed but autre action pendante this working page of complaint is comprised: this complaint Content, relevant evidence picture, the demand of complainant, defendant replys complainant's information, defendant appeals to webmaster content, Defendant is replied the attitude of suggestion, webmaster handling suggestion, complainant to the statement of webmaster handling suggestion, for processing behaviour by complainant The handling suggestion editor (realizing with style frame control) made and a handling suggestion upload button；The displaying scheme of its information is with front The information stated shows essentially identical, is not repeated herein, suggestion upload button herein, and after operator clicks on, system is then with this complaint Sequence number id of record is the mcont that handling suggestion is uploaded this record of the complained table of platform database by retrieval insertion condition Store under field name.

Realization about the management of member's mailbox: operator click on " member's mailbox " mark, page in the homepage of work space Face jumps to member's mailbox management homepage, letter navigation information block (its retrieval that is on view etc. to be viewed or that reply of classifying in this page Condition can form data set by the retrieval of the value of tletter table read field, and such as read=0, or the value retrieval of ans forms data Collection is such as ans=0), to click on arbitrary navigation block therein and can jump to this letter reading working page, this working page comprises: this letter The display of the detailed content of letter and the button for operation: " reply ", operator clicks on reply button, then reply interface is showed, Reply interface comprises a reply content input interface (can be realized by an Input) and a radio button is used for selecting Select this mail to click on aforesaid information navigation displaying the need of reply and a submission button, displaying implementation method of its letter display Enter detailed interface essentially identical, except that the table in the platform database of respective operations herein is record member's mail data Tletter table, operator's submission to reply content after writing letter in reply, system is uploaded is inserted in platform as a new record The value that in the tletter table of data base, each field is recorded is respectively as follows: and transmits artificial webmaster, value 1 fromuid field record； Receiver is responded the letter people of mail, uses touid field record；Reply content is replying in typing is entered in text box in interface Hold, use content field record；Being responded the ID Lid fields record of letter, letter classification is webmaster letter, uses s Field record, f field record value is " by examination & verification ", and read field record value is that 0 expression is not read by receiver, ans word The value that segment record radio button selects, 0 represents and needs to reply, and 3 represent and need not reply, simultaneously in this record being responded mail The value that ans field is recorded is rewritten as 1 expression and has responded to that (this is completed to be not required to program code artificial by software programmers Operation).Additionally when the reading working page of letter is opened, system is automatically by the read field by this data record of reading letter Value note be written as 1, represent that this letter has been opened by addressee and read.

Additionally clicking on " transmitting to this member " mark as webmaster staff at its working interface, the page can jump to transmit boundary Face.Transmit interface to be made up of a letter content typing window, a radio button the need of reply and a submission button.Soft When part runs, staff inputs letter content at letter typing window, selects to reply to require to click on and submits button to, and system is now By information content in conjunction with other related data of this mail (as No. ID of receiver, No. ID of addresser be 1, mail classification) together Being inserted in the tletter table of platform database as a new record, the value peopleware of each field can refer to implementation above method Spirit determine.Wherein receiver No. ID by click on previous mark " transmit to this member " time be transmitted to.The classification of mail is divided Transmit with to service provider member for transmitting class to consumer member, operator when clicking on different working interfaces, system is given not Same parameter determines.

About website, the management of guide is comprised with examination: guide's achievement statistical summaries, market feedback are added up, to the bonus conducted a sightseeing tour Data process, guide punish the execution that data process and process data to this this.Wherein guide's achievement collects, and is to data The data that keep accounts of the fund in affiliated safekeeping account of conducting a sightseeing tour in storehouse discrepancy detail record table dpinto table are converged by section preset time Always, then cohersive and integrated data being shown in webmaster background work interface, its retrieval collects key code and is:

SELECT sum (in) as q1 FROM dbo.dpinto WHERE dpid=@dpid and y=@y

Wherein@dpid represents that the operation account number of the guide member being aggregated corresponds to dp table dpid field, and@y table collects the time.

Market feedback is added up: mainly add up the statistics that service is visitor's evaluating data that this guide is directed, including to visitor couple The evaluating data statistics that the evaluation table atourserve table of tour-guide's service quality is recorded, and in visitor's calling information complained table Relating to the part of this guide, its implementation is essentially identical with above-mentioned.

The bonus data of guide are processed: portal management side by the examination conducted a sightseeing tour or temporal events, determining involved according to bonus And guides, upload in the award table being stored in data base by everyone each record.

The punishment data of guide are processed: portal management side is by the examination conducted a sightseeing tour or temporal events, involved by decision for punishment And guides, upload in the punish table being stored in data base by everyone each record.

Portal management root is according to the result of appraisal of periodically knot guide simultaneously, will record result of appraisal data by by everyone each one Upload in the examine table being stored in data base, when relating to adjust guide's foreground ranking value, the relevant guide of reply data base In the value of U table oksp field.

Background net management work space arranges the operation module of function above.

Those skilled in the art is it can be understood that the technology in the embodiment of the present application can add necessary general by software The mode of hardware platform realizes.In other words prior art is contributed based on such technical scheme understood in the embodiment of the present application Part can embody in the form of software, this computer software is desirably integrated among website platform system and is deployed to the Internet Or a part of function as web station system is issued, to realize method of the present invention among the server of mobile Internet.Visitor Then can be by the equipment such as the Internet or the subscriber terminal equipment such as PC of mobile Internet, handheld device, mobile unit, television set Net accesses and includes the website of this method technology to accept net about guide service.

Above-described the application embodiment is only to present invention spirit explanation for example, is not intended that and protects the application The restriction of scope, any made within spirit herein and principle amendment, equivalent, supplement should be included in improvement etc. Within the application protection domain.

Claims

1. net about guide service provides a method, particularly relates to a kind of tourism electric business including a kind of e-commerce website Business website, comprises the display module of information, the on-line payments and the 3rd such as travelling route, tourist attractions, hotel The connection etc. of side's payment platform；Described e-business website comprises server, Database Systems, client； Described client is connected with server, Database Systems, it is characterised in that:

The modern network platforms such as the Internet, mobile Internet, Internet of Things, website is utilized to collect guide and obtain employment people Member's relevant information or offer net about guide service；Or realized by below step:

Guides or guide service supplier by platform website client end to platform propose service request, Uploading related data, handle opening formality, through portal management side, examination & verification provides net about to conduct a sightseeing tour by backward visitor Service；Online friend can utilize network client devices by the Internet, mobile Internet, Internet of Things: PC, The online such as notebook, panel computer, mobile phone, domestic electric appliance, mobile unit accesses provides net about to conduct a sightseeing tour Service or the website platform of related content, enter, into or by navigation, the phase that net is about conducted a sightseeing tour in website platform Close vacation packages product organized tour circuit, every guide service that the page checks that net about guide is correlated with wherein The data of person, visitor qualification information and the net about guide of the evaluation of its guide service, guide are provided other The contents such as information on services, the net about guide plan of forming a team and adequate and systematic service information thereof this guide of addition that can place an order hold The offer plan of forming a team of the travelling route led, guide is confirmed adding application, or online friend oneself issues Tour plan, is thrown single online friend by guide and confirms, concentrates by stipulated place report out to the agreement time visitor that goes on a tour Row accepts net about guide service；Online friend can check the order of management oneself, the tourism to oneself at any time at any time Experiencing gives opinion includes the complaint to guide service and evaluation；Or guide by its work space to oneself Business is managed；Or net is about conducted a sightseeing tour practitioner and phase thereof by portal management personnel by background work space Pass business is managed and controls；

Or in website platform, be provided with the functional device that net about guide is correlated with comprise:

Guide practitioner's information search and managing device, tourism guiding service data upload device, tourism guiding service management What device, net about conducted a sightseeing tour that related data and service product exhibiting device thereof, online friend add that guide releases goes on a tour The plan of forming a team place an order device, online friend submit to form a team plan guide throw single device, visitor's accounts of finance managing device, Website managing device, the website management to conducting a sightseeing tour and one of checking device etc. or any group to tourism guiding service Close；Or it is provided with Database Systems or the server that the data that function above device is relevant are carried out storage process Related data storage folder；

Wherein:

Guide's practitioner's information search comprises with managing device: the online service application of guide practitioner Calling mechanism and its examination & verification is confirmed device, guide's practitioner's information search and issuing means；

The device of uploading of tourism guiding service data comprises: the travelling products set meal data that guide service is relevant are uploaded The uploading device, lead of the information datas such as sight spot that device is relevant to travelling products, hotel, cuisines, leisure Device is uploaded in the trip plan of forming a team；

Tourism guiding service managing device comprises: managing device that visitor is complained by guide, guide are to uncivil trip Visitor complaint device, guide pay dues withdraw deposit device, guide accounts of finance managing device, guide with webmaster mailbox Ac equipment；Visitor is thrown the management function of application of singly joining the Youth League by guide；

Related data about conducted a sightseeing tour by net and service product exhibiting device comprises: guide's practitioner's qualification and working Device for displaying information, services performance device for displaying information, visitor evaluate the identity information of exhibiting device, guide The travelling products set meal exhibiting device relevant to contact method exhibiting device, net about guide and relevant sight spot are shown Travel device for displaying information, net of device, hotel information exhibiting device, cuisines exhibiting device, leisure is about conducted a sightseeing tour Plan of forming a team exhibiting device etc.；

Online friend adds the plan of forming a team of the going on a tour device that places an order that guide releases and comprises: online friend's line is surfed the Net about under guide Single its tourism released plan of forming a team of addition；Visitor's order management to application of joining the Youth League；Visitor complains, trip Visitor is to service and the evaluation etc. of guide practitioner；

Online friend submits to the plan of forming a team, guide to throw single device and comprise: visitor uploads the plan of going on a tour and needs with guide Asking, guide service supplier throws single quotation, and visitor therefrom selects guide；

The managing device of tourism guiding service is comprised by website: website is to guide's practitioner's title examination and management The processing means that visitor is complained by device, website；

The management of guide is comprised by website with checking device: guide achievement statistical summaries device, market feedback Statistic device, guide is commended data processing equipment, to guide punishment data processing equipment and to this This processes the execution device of data；

Database Systems or server related data storage folder comprise: record guide practitioner open for business warp Seek register information table, the qualification file, picture information note table table of application opening and be used for storing this table correspondence picture The file of data；Manage member to withdraw deposit request for data log；Operating unit's finance keep accounts log of entering an item of expenditure in the accounts； Operating unit's finance fixed account balance data information log；Guide's practitioner's annual fee of opening for business pays situation Log；Guide's practitioner's service guarantees gold of opening for business pays information log；Net is about conducted a sightseeing tour travelling products set Meal data logger and store this table correspondence picture, file of multimedia data；Record sight spot and clothes Business product contingency table；Net travelling products of about conducting a sightseeing tour are formed a team plan log；The scape relevant to net about guide service Point and hotel details picture, multimedia data information log and the picture multimedia number corresponding with this table Press from both sides according to log file；The throwing forms data log of guide's offer that guide practitioner initiates for consumer； Online friend adds the about guide that networks application information i.e. net of forming a team and about conducts a sightseeing tour order record table；Visitor and guide's calling information And disposition data logger；Relevant evidence image data information log and storage are relevant to complaining The file of image data；Visitor's evaluating data information log to study of tourism itinerary production；Visitor is to net about The service quality evaluation log of guide；Member's mailbox mail data logger；Visitor member's finance keep accounts out Account log；Visitor member's finance fixed account balance data information table；Website is to every net about guides Examination data table；The punishment log that net is about conducted a sightseeing tour；The bonus log etc. that net is about conducted a sightseeing tour；

Or show or store in Platform Server data base have following data to believe in website platform client One of breath or its combination in any data message: the Professional qualification of net about guide service person, work experience, evaluation The travelling products package information data that information data is relevant to net about guide, plan information data of forming a team, net About guide provided service content information data, online friend provide net about conduct a sightseeing tour order data, Wang Youti The tour plan of confession and to its offer data of conducting a sightseeing tour；The offer for online friend of conducting a sightseeing tour throws single information data etc..

2. as claimed in claim 1 guide's practitioner's relevant information of collecting, its feature or be: or client Arrange in client or mobile device display screen guide practitioner's relevant information typing window or interface or Person's information submit to function or guide's practitioner's authentication information, relevant certificate, the picture of qualification file, Multi-medium data the function such as upload.

3. online friend as claimed in claim 1 can check its feature of order of management oneself at any time or be its content Comprise: check order, cancel the order of oneself, edit the order of oneself, oneself order is consumed The evaluation experienced is shared with sense of reality, and the unhappiness occurred in consumption is complained and throws by client Tell the contents such as feedback.

4. guide as claimed in claim 1 by its work space the business of oneself is managed its feature or In the inner hold comprise: guide service business datum upload with manage, process visitor complain, complain the most civilian Bright visitor, accounts of finance management exchange mailbox, order management etc. with webmaster, visitor；

Wherein:

Guide service business datum is uploaded and is comprised with management: vacation packages product data are uploaded, to uploading Vacation packages product information safeguard and edit-modify, to the relevant sight spot of product, hotel information upload with Safeguard edit-modify, for set meal product form a team plan upload and safeguard edit-modify, plan phase of forming a team Pass information displaying browses；

Process visitor's complaint to comprise: display is complained related content, replied apology to complainant, to portal management Side explains the situation, appeals, reimbursement etc. of transferring accounts to complainant；Or enter complaints department by a guider navigation The reason page or interface；

Accounts of finance management comprises: transaction details record and query display, account balance record and query display, Pay dues, withdraw deposit and transfer accounts；

Order management comprises: examination & verification process visitor join the Youth League application, check form a team plan visitor register situation, rob Single etc..

5. portal management personnel as claimed in claim 1 by background work space net is about conducted a sightseeing tour practitioner and Its related service is managed and controls its feature or be to comprise: guides open for business application examination & verification, Management payments of fees various with the member carrying out service on the net examination & verification, process member's account charging application, Process member withdraw deposit application, the examination & verification of travelling products data, the examination & verification of sight spot and travelling products contingency table, The management of member's mailbox, process consumer that plan examination & verification of forming a team exchanges with member complain, process about right The complaint of uncivil visitor, the website management to conducting a sightseeing tour and checking device etc..