62,041
社区成员
发帖
与我相关
我的任务
分享
public static class DataBaseGenerator
{
/// <summary>
///
/// </summary>
private static Int64 seed = Int64.Parse(DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1)).TotalMilliseconds.ToString("0"));
/// <summary>
///
/// </summary>
/// <returns></returns>
public static Int64 GetPrimaryKey()
{
return Interlocked.Increment(ref seed);
}
}
public static string job_no(string HeadName)//编码格式
{
SqlConnection conn = new SqlConnection(connectionString);
string s = "";
// SqlCommand cmd = new SqlCommand();
// cmd.Connection = conn;
conn.Open();
SqlCommand cmd2 = new SqlCommand();
cmd2.Connection = conn;
cmd2.CommandText = "declare @s varchar(30)" +
"set @s=convert(varchar,getdate(),111)+convert(varchar,getdate(),14)" +
" set @s=replace(@s,'/','')" +
" set @s=replace(@s,':','')" +
" set @s=replace(@s,'.','')" +
" select @s";
SqlDataReader r = cmd2.ExecuteReader();
while (r.Read())
{
//s = "CL"+r[0].ToString();
s = r[0].ToString();
}
r.Close();
conn.Close();
s = HeadName + s;
return s;
}
for(int i=0;i<10;i++)
{
string _no=jobno("TE")+i;
//这个 _no永远都不会重复
}