AX2012 Import Product size dimensions

最新推荐文章于 2024-07-17 09:40:25 发布

GuanXX

最新推荐文章于 2024-07-17 09:40:25 发布

阅读量1k

点赞数

分类专栏： Dynamics AX

本文链接：https://blog.csdn.net/guanxx/article/details/17529539

版权

Dynamics AX 专栏收录该内容

27 篇文章 2 订阅

订阅专栏

void importSize()
{
    #File
    Filename                        filename;// = @'C:\Desktop\AX2012.txt';
    CommaTextIo                     iO;

    Dialog                          dialog = new Dialog();
    DialogField                     dfFileName;
    Container                       record;
    boolean                         first = true;
    EcoResProductMasterSize         masterSize;
    EcoResSize                      ecoResSize;
    ItemId                          itemId;
    EcoResSizeName                  ecoResSizeName;
    Description                     description;
    EcoResProductMaster             ecoResProductMaster;
    ;

    dfFileName = dialog.addField(extendedTypeStr(FilenameOpen));
    dialog.filenameLookupFilter(["TXT File","*.txt"]);
    dialog.run();

    if (dialog.closedOk())
    {
        ttsBegin;
        filename = dfFileName.value();
        iO = new CommaTextIo(filename,#IO_Read);
        iO.inFieldDelimiter("\t");
        if (! iO || iO.status() != IO_Status::Ok)
        {
            throw error("@SYS19358");
        }
        while (iO.status() == IO_Status::Ok)
        {
            record = iO.read();
            if (record)
            {
                if (first)  // to exclude the header
                {
                    first = false;
                }
                else
                {
                    itemId = conPeek(record,1);
                    ecoResSizeName = conPeek(record,2);
                    description = conPeek(record,3);
                    ecoResProductMaster = EcoResProduct::findByProductNumber(itemId);
                    if (ecoResProductMaster)
                    {
                        ecoResSize = EcoResSize::findByName(ecoResSizeName);
                        if (!ecoResSize)
                        {
                            ecoResSize.clear();
                            ecoResSize.Name = EcoResSizeName;
                            EcoResSize.insert();
                        }
                        if (ecoResSize)
                        {
                            if (!EcoResProductMasterSize::existByProductSize(ecoResProductMaster.RecId,5637144578,ecoResSize.RecId))
                            {
                                masterSize.clear();
                                masterSize.Size = ecoResSize.RecId;
                                masterSize.SizeProductMaster = ecoResProductMaster.RecId;
                                masterSize.SizeProductDimensionAttribute = 5637144578;
                                masterSize.Description = description;
                                masterSize.insert();
                            }
                        }
                    }
                }
            }
        }
        ttsCommit;

    }
    info("Done");
}