小品生成自动编号

小品：使用数据集创建日期编号using System;using CreatAutoID.DsShortTableAdapters;//----------------------------------------------------------------------------------------// 本小品使用数据集创建10位日期自动编号字段：//----------------------------------------------------------------------------------------// 第一个例子创建基于当天日期的自动编号：// 凭证表：为凭证创建日期编号，要求单日自动累计，每天最多100条，即00到99// 格式为：yyyy + MM + dd + 00，如：2012120101// ---------------------------------------------------------------------------------------// 第二个例子创建基于年月，但编号年内累计的十位编号：// 工票表：工票要求带年月，但编号累计4位，下年重新开始，每年最多10000条，即0000到9999 // 格式为：yyyy + MM + dd + 00，如：2012120101// ---------------------------------------------------------------------------------------// 数据库Short DB中有两个表// 凭证表：// Evidence：字段：EviID(int), EviDate(datetim e), EviName(nvarchar(50))// 工票表：// WorkNotes：字段：WorkID(int), WorkDate(datetim e), WorkName(nvarchar(50)) //----------------------------------------------------------------------------------------nam espace CreatAutoID{public class GetAutoIDByDate{//---------------------------------------// 创建数据集：DsShort// 并将两个表拖入设计窗口//---------------------------------------EvidenceTableAdapter eviAd;WorkNotesTableAdapter workAd;public GetAutoIDByDate(){eviAd =new EvidenceTableAdapter();workAd =new WorkNotesTableAdapter();}#region凭证自动编号：10位日期编号// 在Evidence表上创建两个方法// -----------------------------------------------------------// GetCountByDate 方法：// SELECT COUNT(*)// FROM Evidence// WHERE (CONVERT(nvarchar(10), EviDate, 120) = @EviDate)//------------------------------------------------------------// GetMaxID 方法：// SELECT MAX(EviID)// FROM Evidence// WHERE (CONVERT(nvarchar(10), EviDate, 120) = @EviDate) //------------------------------------------------------------///<summary>///获取日期自动编号，一天内只能添加100个凭证///</summary>public int GetEviAutoID(DateTim e dteCurrent){string strCurDate = dteCurrent.Date.ToString("yyyyMMdd");string strInputDate = dteCurrent.Date.ToString("yyyy-MM-dd");strCurDate += "00";// 设置起始编号int intStartID =Convert.ToInt32(strCurDate);// 获取当天的单据数int dcount = GetCountByDate(strInput Date);if (dcount == 0){return intStartID;}else{int intMaxID = GetMaxID(strInputDate);if (intMaxID >= intStartID){return intMaxID + 1;}else{return intStartID;}}}///<summary>///获取当前日期的单据数///</summary>private int GetCountByDate(string strCurDate){try{int count = eviAd.GetCountByDate(strCurDate).Value;return count;}catch (Exception){return 0;}}///<summary>///获取当前日期的最大单据号///</summary>private int GetMaxID(string strCurDate){try{int count = eviAd.GetMaxID(strCurDate).Value;return count;}catch (Exception){return 0;}}#endregion#region工票自动编号// 在WorkNotes表上创建两个方法// ------------------------------------------------------------------------------// GetCountByYear 方法：// SELECT COUNT(*)// FROM WorkNotes// HAVING (MAX(YEAR(WorkDate)) = @Year)//-------------------------------------------------------------------------------// GetMaxID 方法：// SELECT MAX(CONVERT(int, SUBSTRING(CONVERT(nvarchar(10), WorkID), 7, 4)))// FROM WorkNotes// WHERE (YEAR(WorkDate) = @Year)//-------------------------------------------------------------------------------///<summary>///获取工票ID的自动编号,格式：2012 01 0000///</summary>///<returns></returns>public int GetWorkAutoID(DateTim e dteWorkDate){string strYM = dteWorkDate.Date.ToString("yyyyMM");int intYear = dteWorkDate.Year;string strOrder = GetOrderID(intYear).ToString("D4");string strAutoID = strYM + strOrder;return Convert.ToInt32(strAutoID);}///<summary>///截取最大的序号///</summary>private int GetOrderID(int intYear){int intStartID = 0;if (GetCountByYear(intYear) == 0){return intStartID;}else{int intMaxID = GetMaxID(intYear);if (intMaxID >= intStartID){return intMaxID + 1;}else{return intStartID;}}}///<summary>///获取当前年的单据数///</summary>private int GetCountByYear(int intYear){try{int count = workAd.GetCountByYear(intYear).Value;return count;}catch (Exception){return 0;}}///<summary>///获取当前年的最大单据号///</summary>private int GetMaxID(int intYear){try{int count = workAd.GetMaxID(intYear).Value;return count;}catch (Exception){return 0;}}#endregion}}。