大概格式：cz2020081500001
代码如下：（点赞哟）
1.czdjbh指的是充值单据编号的字段
2.代码：
DataSet ds = new DataSet();string czdjbh = "";SqlConnection conn = new SqlConnection(str);try{conn.Open();//创建数据提供者 string sql = "SELECT top 1 czdjbh, SUBSTRING(czdjbh,2,8) FROM czdj where SUBSTRING(czdjbh,2,8) =CONVERT(varchar(100), GETDATE(), 112) order by czdjbh desc";SqlCommand cmd = new SqlCommand(sql, conn);SqlDataReader reader = cmd.ExecuteReader();while (reader.Read()){czdjbh = reader.GetString(reader.GetOrdinal("czdjbh"));}if (czdjbh == "" && string.IsNullOrEmpty(czdjbh)){czdjbh = "0";}else{czdjbh = czdjbh.Substring(czdjbh.Length - 5);}int number = Convert.ToInt32(czdjbh);number = number + 1;string num = Convert.ToString(number);if (num.Length == 1){num = "0000" + num;}else if (num.Length == 2){num = "000" + num;}else if (num.Length == 3){num = "00" + num;}else if (num.Length == 4){num = "0" + num;}czdjbh = "xf" + DateTime.Now.ToString("yyyyMMdd") + num;}catch (Exception ex){MessageBox.Show(ex.ToString());}finally{conn.Close();conn.Dispose();ds.Dispose();}// label2.Text = inbound_no;return czdjbh;}
3.调用的时候就是编号的变量=方法
string czdjbnh = djbh();
点赞哦