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

//--------------------------------------------------------------------//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();

}

}