CN108363708A - A kind of service order generation method - Google Patents

A kind of service order generation method Download PDF

Info

Publication number
CN108363708A
CN108363708A CN201710426549.0A CN201710426549A CN108363708A CN 108363708 A CN108363708 A CN 108363708A CN 201710426549 A CN201710426549 A CN 201710426549A CN 108363708 A CN108363708 A CN 108363708A
Authority
CN
China
Prior art keywords
storing process
service order
lpad
uspgetautoincrement
same day
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Withdrawn
Application number
CN201710426549.0A
Other languages
Chinese (zh)
Inventor
张伟荣
季统凯
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
G Cloud Technology Co Ltd
Original Assignee
G Cloud Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by G Cloud Technology Co Ltd filed Critical G Cloud Technology Co Ltd
Priority to CN201710426549.0A priority Critical patent/CN108363708A/en
Publication of CN108363708A publication Critical patent/CN108363708A/en
Withdrawn legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2282—Tablespace storage structures; Management thereof
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/06—Buying, selling or leasing transactions
    • G06Q30/0601—Electronic shopping [e-shopping]
    • G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
    • G06Q30/0635—Processing of requisition or of purchase orders

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • General Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • Development Economics (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention relates to database technical fields, and in particular to a kind of service order generation method.The present invention method and step be：1, self-propagation record sheet AutoIncrement is created；2, the storing process uspGetAutoIncrement for being generated according to different service types and not repeating ID in the same day is realized；3, the function Lpad according to the left filling designated character of designated length is realized；4, storing process uspGetAutoIncrement is called to obtain ID；5, call function Lpad fillings " 0 " left to obtained ID；6, business prefix is connected to obtain service order number plus same day date literal and ID.The present invention solves database self-propagation ID length disunities, without the problem of the readable difference of date information.

Description

A kind of service order generation method
Technical field
The present invention relates to database technical fields, and in particular to a kind of service order generation method.
Background technology
Self-propagation ID is just being widely used as the uniquely tagged of data at present.But self-propagation ID length disunities, are not wrapped It is readable poor containing business information and date information.
Invention content
Present invention solves the technical problem that being to provide a kind of service order generation method, solves original self-propagation work D length disunities do not include business information and date information, the problem of readable difference.
The present invention solve above-mentioned technical problem technical solution be：
The method includes the following steps：
Step 1: creating self-propagation record sheet AutoIncrement；
Step 2: realizing the storing process uspGetAutoInc for being generated according to different service types and not repeating ID in the same day Rement enables affairs in storing process；
Step 3: realizing the function Lpad according to the left filling designated character of designated length；
Step 4: storing process uspGetAutoIncrement is called to obtain ID；
Step 5: call function Lpad fillings " 0 " left to obtained ID；
Step 6: business prefix is connected to obtain service order number plus same day date literal and ID；
Beneficial effects of the present invention：The characteristics of according to db transaction meeting locking list, ID is generated first with storing process, Enable affairs in storing process, during generating ID, self-propagation record sheet can be locked, so the ID generated on the day of in not It can repeat, ID is stitched together to obtain service order number with business prefix and date literal again, is not weighed to reach to ensure to generate Multiple purpose comprising business prefix and date, readable good service order number.
Description of the drawings
The following further describes the present invention with reference to the drawings：
Fig. 1 is flow chart of the method for the present invention.
Specific implementation mode
As shown in Figure 1, the present invention uses following steps：
Step 1: creating self-propagation record sheet AutoIncrement；Such as：
Guid Type Value UpdateTime
Guid Type of service Value Renewal time
Step 2: realizing the storing process uspGetAutoIncr for being generated according to different service types and not repeating ID in the same day Ement enables affairs in storing process；
Step 3: realizing the function Lpad according to the left filling designated character of designated length；
Step 4: storing process uspGetAutoIncrement is called to obtain ID, type of service is 1；
declare@result nvarchar(50)
Exec@result=uspGetAutoIncrement 1
Step 5: call function Lpad fillings " 0 " left to obtained ID, length is 5；
Set@result=dbo.1pad (@result, 5, ' 0 ')
Step 6: business prefix is connected to obtain service order number plus same day date literal and ID.
Set@result=' XSD '+CONVERT (varchar (100), GETDATE (), 112)+@result.

Claims (1)

1. a kind of service order generation method, it is characterised in that：The method includes the following steps：
Step 1: creating self-propagation record sheet AutoIncrement；
Step 2: realizing the storing process for being generated according to different service types and not repeating ID in the same day UspGetAutoIncrement enables affairs in storing process；
Step 3: realizing the function Lpad according to the left filling designated character of designated length；
Step 4: storing process uspGetAutoIncrement is called to obtain ID；
Step 5: call function Lpad fillings " 0 " left to obtained ID；
Step 6: business prefix is connected to obtain service order number plus same day date literal and ID.
CN201710426549.0A 2017-06-08 2017-06-08 A kind of service order generation method Withdrawn CN108363708A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710426549.0A CN108363708A (en) 2017-06-08 2017-06-08 A kind of service order generation method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710426549.0A CN108363708A (en) 2017-06-08 2017-06-08 A kind of service order generation method

Publications (1)

Publication Number Publication Date
CN108363708A true CN108363708A (en) 2018-08-03

Family

ID=63009845

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710426549.0A Withdrawn CN108363708A (en) 2017-06-08 2017-06-08 A kind of service order generation method

Country Status (1)

Country Link
CN (1) CN108363708A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109636551A (en) * 2019-01-31 2019-04-16 上海易点时空网络有限公司 Service order generation method and device
CN112184367A (en) * 2020-09-17 2021-01-05 北京同邦卓益科技有限公司 Order processing method and device
CN112184367B (en) * 2020-09-17 2024-05-24 北京同邦卓益科技有限公司 Order processing method and device

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2012171349A1 (en) * 2011-06-15 2012-12-20 中兴通讯股份有限公司 Method, apparatus and system for implementing distributed auto-incrementing counting
CN103399945A (en) * 2013-08-15 2013-11-20 成都博云科技有限公司 Data structure based on cloud computing database system
CN106649566A (en) * 2016-11-14 2017-05-10 上海艾融软件股份有限公司 Serial number generation method and device

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2012171349A1 (en) * 2011-06-15 2012-12-20 中兴通讯股份有限公司 Method, apparatus and system for implementing distributed auto-incrementing counting
CN103399945A (en) * 2013-08-15 2013-11-20 成都博云科技有限公司 Data structure based on cloud computing database system
CN106649566A (en) * 2016-11-14 2017-05-10 上海艾融软件股份有限公司 Serial number generation method and device

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
KEY2VALUE: "流水号的生成(日期+业务码+自增序列)", 《HTTPS://BLOG.CSDN.NET/U010786672/ARTICLE/DETAILS/46680629》 *
YANGBAYKER: "DB2使用笔记--生成存储过程ID", 《HTTPS://WWW.CNBLOGS.COM/BAYKER/ARCHIVE/2009/08/29/1556356.HTML》 *

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109636551A (en) * 2019-01-31 2019-04-16 上海易点时空网络有限公司 Service order generation method and device
CN109636551B (en) * 2019-01-31 2022-02-01 上海易点时空网络有限公司 Service order generation method and device
CN112184367A (en) * 2020-09-17 2021-01-05 北京同邦卓益科技有限公司 Order processing method and device
CN112184367B (en) * 2020-09-17 2024-05-24 北京同邦卓益科技有限公司 Order processing method and device

Similar Documents

Publication Publication Date Title
Acosta et al. An optimal Poincaré inequality in 𝐿¹ for convex domains
Desvillettes et al. On the entropic structure of reaction-cross diffusion systems
US8656290B1 (en) Realtime synchronized document editing by multiple users
CN109492056A (en) A kind of method and system of business intelligence data inquiry
CN106227575B (en) A method of it generates and parsing text file
Frances et al. Conformal actions of nilpotent groups on pseudo-Riemannian manifolds
CN105450712A (en) Data transmission method and device
CN108363708A (en) A kind of service order generation method
CN105677645B (en) A kind of tables of data comparison method and device
CN111966707A (en) Query statement generation method and device, electronic equipment and computer readable medium
CN105094959A (en) Method and device for providing account checking document
CN101997643A (en) Method and system for packing electronic files
Holt et al. Some closure results for 𝒞-approximable groups
CN114862449A (en) Method and device for calculating unique natural person identifier, electronic equipment and storage medium
CN109978513A (en) Obtain method and apparatus, project task management equipment and the medium of technical standard
CN109388812B (en) Cloud computing-based modular automatic plotting method and system
CN111401023B (en) Report generation method, report generation device, server and storage medium
CN103051480B (en) The storage means of a kind of DN and DN storage device
CN108196921B (en) Document development method and device, computer equipment and storage medium
CN108833518B (en) A method of session id is generated based on nginx server
CN110874210A (en) Method for generating self-defined self-increment type unique single number
CN109672536B (en) Digital signature method and system for batch PDF files
EP3832514A1 (en) An apparatus, computer program and method
CN106951404B (en) Data format conversion method and device
CN112910923A (en) Intelligent financial big data processing system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
WW01 Invention patent application withdrawn after publication

Application publication date: 20180803

WW01 Invention patent application withdrawn after publication