110,534
社区成员
发帖
与我相关
我的任务
分享
string number =DateTime.Now.ToString("yMMdd")+numb;
private void Num()
{
SqlConnection Conn = new SqlConnection(customSetting);
Conn.Open();
try
{
SqlDataAdapter da=new SqlDataAdapter("select top 1 OrderID from orderlist order by [ID] desc",Conn);
DataSet ds=new DataSet();
da.Fill(ds);
DataTable tb=new DataTable();
tb=ds.Tables[0];
numb=Convert.ToInt32(tb.Rows[0]["OrderID"].ToString().Substring(5,5));
if(numb!=25680)
{
numb=numb+1;
}
else
{
numb=25680;
}
}
catch
{
numb=25680;
}
Conn.Close();
}