自动生成编号-蒲公英云

自动生成编号

梦里梦外; 2022-03-21 07:24 395阅读 0赞

生成编号首先需要查询出数据库已经存在的编号

from tbEveryday in myModel.PW_Everyday
orderby tbEveryday.EverydayNumber
select tbEveryday

我的编号格式为AZ20181212001（AZ + 8位数日期 + 3位数编号），先获取数据库最后的编号后3位数转为int类型，然后加1之后转为字符串类型，利用for循环在数字前拼接0为三位数

int count = listNumber.Count;
PW_Everyday modelNumber = listNumber[count - 1];
int intNumber = Convert.ToInt32(modelNumber.EverydayNumber.Substring(10, 3));
intNumber++;
Number = intNumber.ToString();
for (int i = 0; i < 3; i++)
 {
      Number = Number.Length < 3 ? "0" + Number : Number;
 }

生成编号的方法

public ActionResult Number()
        {
            string Number = "";
            string data = DateTime.Now.ToString("yyyyMMdd");
            var listNumber = (from tbEveryday in myModel.PW_Everyday
                              orderby tbEveryday.EverydayNumber
                              select tbEveryday).ToList();
            if (listNumber.Count > 0)
            {
                int count = listNumber.Count;
                PW_Everyday modelNumber = listNumber[count - 1];
                int intNumber = Convert.ToInt32(modelNumber.EverydayNumber.Substring(10, 3));
                intNumber++;
                Number = intNumber.ToString();
                for (int i = 0; i < 3; i++)
                {
                    Number = Number.Length < 3 ? "0" + Number : Number;
                }
                Number =  "AZ" + data + Number;
            }
            else
            {
                Number = "AZ" + data + "001";
            }
            return Json(Number, JsonRequestBehavior.AllowGet);
        }