String sql;
SqlDataReader rd;
SqlCommand cmd;
String mydate = DateTime.Now.ToString("yyyyMMdd");
cmd = new SqlCommand("select max(right(" + str + ",3)) as big_ID from " + TableName + " where left(" + str + ",8)='" + mydate + "'", cn);
rd = cmd.ExecuteReader();
if( rd.Read() ) {
if( rd("big_ID") + "" == "" )
loveme = mydate + "-" + "001";
else
loveme = mydate + "-" + rd("big_ID").ToString("000");
}
rd.Close();
rd = null;
SqlDataReader rd;
SqlCommand cmd;
String mydate = DateTime.Now.ToString("yyyyMMdd");
cmd = new SqlCommand("select max(right(" + str + ",3)) as big_ID from " + TableName + " where left(" + str + ",8)='" + mydate + "'", cn);
rd = cmd.ExecuteReader();
if( rd.Read() ) {
if( rd("big_ID") + "" == "" )
loveme = mydate + "-" + "001";
else
loveme = mydate + "-" + rd("big_ID").ToString("000");
}
rd.Close();
rd = null;
我的目的是:比如已经有单号20040330-001
下一张单就是20040330-002
tmp = rd("big_ID") + 1;
tmp.ToString("000");
在C#里面怎么没val?两天没搞定
string s="12";
Console.WriteLine (int.Parse(s));先将它转换成数值.然后再加.