生成像这样得编号 XX2007032100001

    /**//// <summary>
    /// 最后一个编号 XX200703060001
    /// </summary>
    /// <param name="fieldName">字段ID号</param>
    /// <param name="tableName">表得名字</param>
    /// <returns></returns>
    public static object GetLastCode(string fieldName, string tableName, int autoBuildCodeLength)
    ...{
        string executeString = "SELECT " + fieldName + " FROM " + tableName + " WHERE LEN(" + fieldName + ") = " + autoBuildCodeLength + " ORDER BY ID DESC";
        return Common.GetDatabase().GetFirstData(executeString, CommandType.Text);
    }

    /**//// <summary>
    /// 第一位为0
    /// </summary>
    private static int _autoBuildCount = 0;

    /**//// <summary>
    /// 自动生成编号 如 "XXXX" + 2007030600001 这样的
    /// "XXXX" 传来的
    /// </summary>
    /// <param name="codeFormat">编号得格式</param>
    /// <param name="fieldName">字段ID号</param>
    /// <param name="tableName">表得名字</param>
    /// <param name="autoBuildCodeLength">自动生成编号得长度</param>
    /// <returns></returns>
    public static string GetAutomatismBuildCode(string codeFormat, string fieldName, string tableName,int autoBuildCodeLength)
    ...{
        string yearMonthDay1 = "";
        string yearMonthDay2 = codeFormat + DateTime.Now.Year.ToString() +
            NumberIsLessThan10(DateTime.Now.Month) +
            NumberIsLessThan10(DateTime.Now.Day);
        object autoBuildCode;
        string AutomatismNumber = "";

        autoBuildCode = GetLastCode(fieldName, tableName, autoBuildCodeLength);
        if (autoBuildCode == null)
        ...{
            _autoBuildCount = 1;
        }
        else
        ...{
            yearMonthDay1 = autoBuildCode.ToString().Substring(0, autoBuildCodeLength-5);
            if (yearMonthDay2 == yearMonthDay1)
            ...{
                _autoBuildCount = int.Parse(autoBuildCode.ToString().Substring(autoBuildCodeLength-5, 5));
            }
            ++_autoBuildCount;
        }
        AutomatismNumber = yearMonthDay2 + _autoBuildCount.ToString("00000");

        _autoBuildCount = 0;
        return AutomatismNumber;
    }

    /**//// <summary>
    /// 判断月日是一位还是两位数
    /// </summary>
    /// <param name="aa"></param>
    /// <returns></returns>
    private static string NumberIsLessThan10(int monthOrDay)
    ...{
        if (monthOrDay < 10)
        ...{
            return "0" + monthOrDay.ToString();
        }
        return monthOrDay.ToString();
    }

 
XX2007032100001

这个每添加完一条记录时最后一位都自动加一

Trackback: http://tb.blog.youkuaiyun.com/TrackBack.aspx?PostId=1536936