.Net自动生成BH

public JsonResult UpdateUserInfoByBH()
        {
            String BH = "";
            String BH_max = "";
            //自动生成BH
            string year = DateTime.Now.Year.ToString().Substring(2, 2);
            string month = DateTime.Now.Month.ToString();
            if (month.Length < 2)
            {
                month = "0" + month;
            }
            string day = DateTime.Now.Day.ToString();
            if (day.Length < 2)
            {
                day = "0" + day;
            }
            String date_now = year + month + day;

            //查看当前日期在数据库的最大值
            // String sql_BH = " select top 1 BH from PDMJDDB.dbo.WeiTuoDan where BH like'%" + date_now + "%' order by Id desc ";
            // dt = DBTool.TongJiChaXun(sql_BH); 

            SqlConnection con = new SqlConnection();
            con.ConnectionString = "server=WJC-PC;database=PDMJDDB;uid=sa;pwd=123456";
            con.Open();
            ArrayList list = new ArrayList();
            //SqlCommand cmd = con.CreateCommand();
            String sql1 = "select top 1 BH from WeiTuoDan where BH like'%" + date_now + "%' order by Id desc ";
            SqlCommand myCmd = new SqlCommand(sql1, con);//生成一个SQL命令
            SqlDataAdapter myAdapter = new SqlDataAdapter(); //创建SQL数据提供者的一个实例（建立一个SQL操作接口）
            myAdapter.SelectCommand = myCmd;
            DataSet ds = new DataSet();//创建一个DataSet实例
            myAdapter.Fill(ds, "Result_Tab");
            DataTable data = ds.Tables[0];
           // BH_max =( data.Rows[0]["BH"]).ToString();
            //
            //BH_max = Convert.ToString(dt.Rows[0]["BH"]);//查询此器具编号对应的BH
            if (data.Rows.Count >0)
            {//给最大值增加1
                //给最大值增加1
                BH_max = (data.Rows[0]["BH"]).ToString();
                string subStr = BH_max.Substring(BH_max.Length - 4); //**得到后四位**
                int BH_int = Convert.ToInt32(subStr);
                BH_int++;//让它加1
                BH_max = BH_int.ToString();//再将值转为字符串
                BH_max = BH_max.PadLeft(4, '0');//给不够四位的前面补0
                //最后再进行字符串拼接
                BH = date_now + BH_max;
            }
            else
            {
                //如果没有的话，那么代表今天没有，就要生成一个编号为1的
                BH = date_now + "0001";
                 }
            //雪洁开始做    把BH插进去即可
            return Json(new Result
            {
                Total = 1,
                Flag = true,
                Text = "BH",
                Data = null
            });

          
        }