# ============================================================== # -*- 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()
流水编号生成模拟
最新推荐文章于 2023-11-21 02:01:57 发布