How to create a number sequence in Axapta?

How to create a number sequence in Axapta?

According as a test, the below detail can create a number sequence in Axapta.

1, Basic->Setup->Number Sequences-> Number Sequence Form.

Create a NS code such as "SN_TEST" from 1 to 999999 and format is SN_######.

2, Create a job to enable InUse button.

    NumberSequenceTable  _ns ;
    ttsbegin ;
    while select forupdate  _ns where _ns.NumberSequence == 'SN_Test'
    {
        _ns.InUse = NoYes::Yes ;
        _ns.update() ;
    }
    ttscommit ;

3, Create an EDT named 'IDTest' and extends is num.

4, Create a table named HDSH_SNTest and has two field, one is IdTest (EDT is IDTest) and another is name (EDT is name)

5, Create a Form and DS is HDSH_SNTest. Display two fields in a Grid

6, First confirm which module do want to add this SN. Such as Production. Pls look for a class name 'NumberSeqReference_Production'

In protected void loadModule() method add the code as below:

 

    numRef.dataTypeId              = typeId2ExtendedTypeId(typeid(IdTest));    // from EDT
    numRef.referenceHelp           = literalstr("NS Test");
    numRef.WizardContinuous        = false;
    numRef.WizardManual            = NoYes::Yes;
    numRef.WizardAllowChangeDown   = NoYes::No;
    numRef.WizardAllowChangeUp     = NoYes::No;
    numRef.sortField               = 9;                                              // is order

    this.create(numRef);                                                                 // create a SN in parameter of production

7, In DS of HDSH_SNTest form, Add the below code:

public void initValue()
{

    super();
    HDSH_SNTest.IdTest  = Numberseq::newGetNum(prodparameters::numRefSNId()).num() ;

}

 

OK, all are OK.

posted on 2008-09-18 14:08 Jacky Xu 阅读( ...) 评论( ...)   编辑 收藏

转载于:https://www.cnblogs.com/JackyXu1981/articles/1293294.html