订单号我是由时间和5位整数组成,产生订单时,如何让numb变量变更,我这样做为什么取不到变量numb的值。请各位大侠帮忙解决!
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();
}