流水编号生成模拟

# ==============================================================
# -*- coding: utf-8 -*-
# @Time    : 2018/02/24 15:15
# ==============================================================
import datetime

import pymysql
import re

conn = pymysql.connect('localhost','root','Aa111111','db_jxc',charset='utf8')
data = conn.cursor()
sql = "SELECT MAX(purchase_number) FROM t_purchase_list "
data.execute(sql)
result = data.fetchone()
print(type(result))
result = str(result)
print(type(result))

totalCount = re.sub("\D", "", result)

print(result)
print(totalCount)
print(type(totalCount))

i = datetime.datetime.now()
print("当前的日期和时间是 %s" % i)
print("ISO格式的日期和时间是 %s" % i.strftime("%Y%m%d%H%M%S"))

if totalCount == '' or totalCount is None:
    num = '0001'
else:
    num1 = totalCount[-4:-1]
    print(num1)
    num2 = totalCount[-1:]
    print(num2)
    num = int(num2) + 1
    print(num)
    print(type(str(num)))
    num9 = num1 + str(num)
    print(num9)

    num8 = num1.join(str(num))
    print(num8)
    print(type(num8))
nn = i.strftime("%Y%m%d")
n = 'CGDD' + nn + num9
print(n)

data.close()
conn.close()