/// <summary>根據(jù)pbh生成下級的bh,自動+1,超過限制則返回文本

    /// 
    /// </summary>
    /// <param name="pbh">父編號</param>
    /// <param name="x">每一級編號的位數(shù)</param>
    /// <returns></returns>
    public string GenBH(string pbh, int x)
    {
        string sql = "select right(max(bh)," + x + ") from jfs_category where pbh=" + pbh;
        MSSQLHelper h = new MSSQLHelper();
        h.CreateCommand(sql);
        string res = h.ExecuteScalar();
        if (string.IsNullOrEmpty(res))
        {
            int a = 1;
            if (pbh != "0")
            {
                return pbh + a.ToString("d" + x);
            }
            return a.ToString("d" + x);
        }
        else
        {
            int a = int.Parse(res) + 1;
            int b = (int)Math.Pow(10, x);
            if (a >= b)
            {
                return "編號超過限制!";
            }
            if (pbh != "0")
            {
                return pbh + a.ToString("d" + x);
            }
            return a.ToString("d" + x);
        }
    }