asp.net mysql自动编号,ASP.NET 生成唯一不重复的订单号支持多用户并发、持多数据库的实现参考...

最新推荐文章于 2023-04-11 15:48:56 发布

weixin_39955953

最新推荐文章于 2023-04-11 15:48:56 发布

阅读量314

点赞数

文章标签： asp.net mysql自动编号

本文介绍了一种基于当前日期和类别生成唯一订单编号的方法，通过不同的日期粒度（年、年月、年月日）及类别来确保每个订单编号的唯一性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

//--------------------------------------------------------------------//All Rights Reserved , Copyright (C) 2011 , Hairihan TECH, Ltd.//--------------------------------------------------------------------usingSystem;namespaceDotNet.WebForm

{usingDotNet.Service;//////OrderNumber///序号产生方式、并发序号发生、唯一编号产生//////修改纪录//////版本：1.0 2011.02.28 JiRiGaLa 初步创建。//////版本：1.0//////JiRiGaLa///2011.02.28//////publicpartialclassOrderNumber : BasePage

{protectedvoidPage_Load(objectsender, EventArgs e)

{

}privatevoidGetOrderNumber()

{stringorderName=string.Empty;//1.按年产生订单序号。orderName="Order:"+DateTime.Now.ToString("yyyy");//获取原编号//ServiceManager.Instance.SequenceService.GetOldSequence(this.UserInfo, fullName, 0, 5, true);//这里是编号增加一的动作this.txtOrderNumber1.Text=ServiceManager.Instance.SequenceService.GetNewSequence(this.UserInfo, orderName,0,5,true);//2.按年月产生订单序号。orderName="Order:"+DateTime.Now.ToString("yyyyMM");//ServiceManager.Instance.SequenceService.GetOldSequence(this.UserInfo, fullName, 0, 5, true);//这里是编号增加一的动作this.txtOrderNumber2.Text=ServiceManager.Instance.SequenceService.GetNewSequence(this.UserInfo, orderName,0,5,true);//3.按年月日产生订单序号。orderName="Order:"+DateTime.Now.ToString("yyyyMMdd");//ServiceManager.Instance.SequenceService.GetOldSequence(this.UserInfo, fullName, 0, 5, true);//这里是编号增加一的动作this.txtOrderNumber3.Text=ServiceManager.Instance.SequenceService.GetNewSequence(this.UserInfo, orderName,0,5,true);//4.按类别产生订单序号。orderName="Order:"+"StockOut";//ServiceManager.Instance.SequenceService.GetOldSequence(this.UserInfo, fullName, 0, 5, true);//这里是编号增加一的动作this.txtOrderNumber4.Text=ServiceManager.Instance.SequenceService.GetNewSequence(this.UserInfo, orderName,0,5,true);

}protectedvoidbtnGetOrderNumber_Click(objectsender, EventArgs e)

{this.GetOrderNumber();

}