/// <summary>
/// 生成自动编号
/// </summary>
/// <param name="prefix">自动生成编号的前缀</param>
/// <param name="numberFormat">自动生成的编号中自增序列号的长度</param>
/// <param name="type">自动编号的类型</param>
/// <returns></returns>
public string CreateNumber(string prefix, int serialLen, string type)
{
try
{
DataContext dc = DataContextFactory.CreateDataContext(ConnectStr, _MappingSource);
AutoCreateNumber num = dc.GetTable <AutoCreateNumber>().SingleOrDefault(item => item.Prefix == prefix && item.NumberType == type);
if (num == null)
{
num = new AutoCreateNumber()
{
Prefix = prefix,
Number = 1,
NumberType = type
};
dc.GetTable <AutoCreateNumber>().InsertOnSubmit(num);
}
else
{
num.Number += 1;
}
dc.SubmitChanges();
return(num.Prefix + num.Number.ToString("D" + serialLen));
}
catch (Exception ex)
{
LJH.GeneralLibrary.ExceptionHandling.ExceptionPolicy.HandleException(ex);
}
return(null);
}
/// <summary>
/// 生成自动编号
/// </summary>
/// <param name="prefix">自动生成编号的前缀</param>
/// <param name="numberFormat">自动生成的编号中自增序列号的长度</param>
/// <param name="type">自动编号的类型</param>
/// <returns></returns>
public string CreateNumber(string prefix, string dateFormat, int serialLen, string type)
{
try
{
string head = string.Format("{0}{1}", prefix, DateTime.Now.ToString(dateFormat));
DataContext dc = DataContextFactory.CreateDataContext(ConnectStr, _MappingSource);
AutoCreateNumber num = dc.GetTable<AutoCreateNumber>().SingleOrDefault(item => item.Prefix == head && item.NumberType == type);
if (num == null)
{
num = new AutoCreateNumber()
{
Prefix = head,
Number = 1,
NumberType = type
};
dc.GetTable<AutoCreateNumber>().InsertOnSubmit(num);
}
else
{
num.Number += 1;
}
dc.SubmitChanges();
return num.Prefix + num.Number.ToString("D" + serialLen);
}
catch (Exception ex)
{
LJH.GeneralLibrary.ExceptionHandling.ExceptionPolicy.HandleException(ex);
}
return null;
}