EXCEL导入InventTable的Job
static void axd_importinventtable_excel(Args _args)
{
sysexcelapplication m_application;
sysexcelworkbooks m_workbooks;
sysexcelworkbook m_workbook;
sysexcelworksheets m_worksheets;
sysexcelworksheet m_worksheet;
sysexcelcells m_cells;
//enum type
ItemType m_ItemType;
NoYes m_NoYes;
SalesPriceModel m_SalesPriceModel;
SalesPriceModelBasic m_SalesPriceModelBasic;
ItemNumAlternative m_ItemNumAlternative;
ABC m_ABC;
NoYesCombo m_NoYesCombo;
XPS_ItemStatus m_XPS_ItemStatus;
XPS_ItemOwner m_XPS_ItemOwner;
XPS_Zone m_XPS_Zone;
//
int m_row;
comvarianttype m_type;
inventtable m_inventtable;
;
m_application=sysexcelapplication::construct();
m_workbooks=m_application.workbooks();
m_workbooks.open("c:\\replacement\\inventtable.xls");
m_workbook=m_workbooks.item(1);
m_worksheets=m_workbook.worksheets();
m_worksheet=m_worksheets.itemfromnum(1);
m_cells=m_worksheet.cells();
m_type=m_cells.item(m_row+1,1).value().varianttype();
while (m_type!=comvarianttype::vt_empty)
{
m_row++;
info(strfmt("itemid:%1,itemname:%2",
m_cells.item(m_row,1).value().bstr(),
m_cells.item(m_row,2).value().bstr()));
m_inventtable.ItemGroupId=m_cells.item(m_row,1).value().bstr();
m_inventtable.ItemId=m_cells.item(m_row,2).value().bstr();
m_inventtable.ItemName=m_cells.item(m_row,3).value().bstr();
m_inventtable.ItemType=str2enum(m_ItemType,m_cells.item(m_row,4).value().bstr());
m_inventtable.PurchModel=str2enum(m_NoYes,m_cells.item(m_row,5).value().bstr());
m_inventtable.Height=m_cells.item(m_row,6).value().double();
m_inventtable.Width=m_cells.item(m_row,7).value().double();
m_inventtable.SalesModel=str2enum(m_SalesPriceModel,m_cells.item(m_row,8).value().bstr());
m_inventtable.CostGroupId=m_cells.item(m_row,9).value().bstr();
m_inventtable.ReqGroupId=m_cells.item(m_row,10).value().bstr();
m_inventtable.PrimaryVendorId=m_cells.item(m_row,11).value().bstr();
m_inventtable.NetWeight=m_cells.item(m_row,12).value().double();
m_inventtable.Depth=m_cells.item(m_row,13).value().double();
m_inventtable.UnitVolume=m_cells.item(m_row,14).value().double();
m_inventtable.BOMUnitId=m_cells.item(m_row,15).value().bstr();
m_inventtable.Density=m_cells.item(m_row,16).value().double();
m_inventtable.Dimension[1]=m_cells.item(m_row,17).value().bstr();
m_inventtable.Dimension[2]=m_cells.item(m_row,18).value().bstr();
m_inventtable.Dimension[3]=m_cells.item(m_row,19).value().bstr();
m_inventtable.CostModel=str2enum(m_noyes,m_cells.item(m_row,20).value().bstr());
m_inventtable.UseAltItemId=str2enum(m_ItemNumAlternative,m_cells.item(m_row,21).value().bstr());
m_inventtable.AltItemId=m_cells.item(m_row,22).value().bstr();
m_inventtable.Intracode=m_cells.item(m_row,23).value().bstr();
m_inventtable.BOMManualConsump=str2enum(m_noyes,m_cells.item(m_row,24).value().bstr());
m_inventtable.BOMManualReceipt=str2enum(m_noyes,m_cells.item(m_row,25).value().bstr());
m_inventtable.StopExplode=str2enum(m_noyes,m_cells.item(m_row,26).value().bstr());
m_inventtable.Phantom=str2enum(m_noyes,m_cells.item(m_row,27).value().bstr());
m_inventtable.IntraUnit=m_cells.item(m_row,28).value().double();
m_inventtable.BOMLevel=str2int(m_cells.item(m_row,29).value().bstr());
m_inventtable.BatchNumGroupId=m_cells.item(m_row,30).value().bstr();
m_inventtable.AutoReportFinished=str2enum(m_noyes,m_cells.item(m_row,31).value().bstr());
m_inventtable.OrigCountryId=m_cells.item(m_row,32).value().bstr();
m_inventtable.StatisticsFactor=m_cells.item(m_row,33).value().double();
m_inventtable.AltConfigId=m_cells.item(m_row,34).value().bstr();
m_inventtable.StandardConfigId=m_cells.item(m_row,35).value().bstr();
m_inventtable.ProdPoolId=m_cells.item(m_row,37).value().bstr();
m_inventtable.PropertyId=m_cells.item(m_row,38).value().bstr();
m_inventtable.ABCTieUp=str2enum(m_ABC,m_cells.item(m_row,39).value().bstr());
m_inventtable.ABCRevenue=str2enum(m_ABC,m_cells.item(m_row,40).value().bstr());
m_inventtable.ABCValue=str2enum(m_ABC,m_cells.item(m_row,41).value().bstr());
m_inventtable.ABCContributionMargin=str2enum(m_ABC,m_cells.item(m_row,42).value().bstr());
m_inventtable.CommissionGroupId=m_cells.item(m_row,43).value().bstr();
//m_inventtable.DEL_BarCode=m_cells.item(m_row,44).value().bstr();
//m_inventtable.DEL_BarCodeType=m_cells.item(m_row,45).value().bstr();
m_inventtable.Configurable=str2enum(m_noyes,m_cells.item(m_row,46).value().bstr());
m_inventtable.SalesPercentMarkup=m_cells.item(m_row,47).value().double();
m_inventtable.SalesContributionRatio=m_cells.item(m_row,48).value().double();
m_inventtable.SalesPriceModelBasic=str2enum(m_SalesPriceModelBasic,m_cells.item(m_row,49).value().bstr());
m_inventtable.MinAverageSettle=m_cells.item(m_row,50).value().double();
m_inventtable.NameAlias=m_cells.item(m_row,51).value().bstr();
m_inventtable.ProdGroupId=m_cells.item(m_row,52).value().bstr();
m_inventtable.projCategoryId=m_cells.item(m_row,53).value().bstr();
m_inventtable.grossDepth=m_cells.item(m_row,54).value().double();
m_inventtable.grossWidth=m_cells.item(m_row,55).value().double();
m_inventtable.grossHeight=m_cells.item(m_row,56).value().double();
m_inventtable.standardPalletQuantity=m_cells.item(m_row,57).value().double();
m_inventtable.qtyPerLayer=m_cells.item(m_row,58).value().double();
m_inventtable.sortCode=str2int(m_cells.item(m_row,59).value().bstr());
m_inventtable.ConfigSimilar=str2enum(m_noyes,m_cells.item(m_row,60).value().bstr());
m_inventtable.SerialNumGroupId=m_cells.item(m_row,61).value().bstr();
m_inventtable.DimGroupId=m_cells.item(m_row,62).value().bstr();
m_inventtable.ModelGroupId=m_cells.item(m_row,63).value().bstr();
m_inventtable.ItemBuyerGroupId=m_cells.item(m_row,64).value().bstr();
m_inventtable.TaxPackagingQty=m_cells.item(m_row,65).value().double();
//m_inventtable.DEL_Template=m_cells.item(m_row,66).value().bstr();
m_inventtable.WMSPalletTypeId=m_cells.item(m_row,67).value().bstr();
m_inventtable.OrigStateId=m_cells.item(m_row,68).value().bstr();
m_inventtable.StopExplodePrice=str2enum(m_noyes,m_cells.item(m_row,69).value().bstr());
//
m_inventtable.WMSPickingQtyTime=m_cells.item(m_row,70).value().time();
//
m_inventtable.TaraWeight=m_cells.item(m_row,71).value().double();
m_inventtable.PackagingGroupId=m_cells.item(m_row,72).value().bstr();
m_inventtable.ScrapVar=m_cells.item(m_row,73).value().double();
m_inventtable.ScrapConst=m_cells.item(m_row,74).value().double();
m_inventtable.StandardInventColorId=m_cells.item(m_row,75).value().bstr();
m_inventtable.StandardInventSizeId=m_cells.item(m_row,76).value().bstr();
m_inventtable.ItemDimCombinationAutoCreate=str2enum(m_noyes,m_cells.item(m_row,77).value().bstr());
m_inventtable.ItemDimCostPrice=str2enum(m_noyes,m_cells.item(m_row,78).value().bstr());
m_inventtable.ItemIdCompany=m_cells.item(m_row,79).value().bstr();
m_inventtable.AltInventSizeId=m_cells.item(m_row,80).value().bstr();
m_inventtable.AltInventColorId=m_cells.item(m_row,81).value().bstr();
m_inventtable.ForecastDMPInclude=str2enum(m_noyes,m_cells.item(m_row,82).value().bstr());
m_inventtable.PBAItemConfigurable=str2enum(m_noyes,m_cells.item(m_row,83).value().bstr());
m_inventtable.PBAInventItemGroupId=m_cells.item(m_row,84).value().bstr();
m_inventtable.PAE_ProductFamily=m_cells.item(m_row,85).value().bstr();
m_inventtable.PAE_Consigned=str2enum(m_noyes,m_cells.item(m_row,86).value().bstr());
m_inventtable.PAE_CustAccount=m_cells.item(m_row,87).value().bstr();
m_inventtable.GrossWeight=m_cells.item(m_row,88).value().double();
m_inventtable.PAE_RomanianArt=str2enum(m_noyes,m_cells.item(m_row,89).value().bstr());
m_inventtable.PAE_Boxtype=m_cells.item(m_row,90).value().bstr();
m_inventtable.PAE_FinProd=str2enum(m_NoYesCombo,m_cells.item(m_row,91).value().bstr());
m_inventtable.XPS_PalletRent=str2enum(m_noyes,m_cells.item(m_row,92).value().bstr());
m_inventtable.PAE_CostPrice=m_cells.item(m_row,93).value().double();
m_inventtable.PAE_AverageCostprice=m_cells.item(m_row,94).value().double();
m_inventtable.XPS_GeneralItem=str2enum(m_noyes,m_cells.item(m_row,95).value().bstr());
m_inventtable.XPS_PlanningNotes=m_cells.item(m_row,96).value().bstr();
m_inventtable.XPS_ProdArea=m_cells.item(m_row,97).value().bstr();
m_inventtable.XPS_DetailGroupId=m_cells.item(m_row,98).value().bstr();
m_inventtable.PAE_DirectDelivery=str2enum(m_noyes,m_cells.item(m_row,99).value().bstr());
m_inventtable.PAE_AutoSales2Purchase=str2enum(m_noyes,m_cells.item(m_row,100).value().bstr());
m_inventtable.PAE_Synchronise=str2enum(m_noyes,m_cells.item(m_row,101).value().bstr());
m_inventtable.XPS_ItemTypeConversion=str2enum(m_noyes,m_cells.item(m_row,102).value().bstr());
m_inventtable.XPS_Label=m_cells.item(m_row,103).value().bstr();
m_inventtable.XPS_ProductionNotes=m_cells.item(m_row,104).value().bstr();
m_inventtable.XPS_NeedsInspection=str2enum(m_noyes,m_cells.item(m_row,105).value().bstr());
m_inventtable.XPS_InspectionSampleSize=m_cells.item(m_row,106).value().bstr();
m_inventtable.XPS_InspectionNote=m_cells.item(m_row,107).value().bstr();
m_inventtable.XPS_ProductCode=m_cells.item(m_row,108).value().bstr();
m_inventtable.XPS_QualityCode=m_cells.item(m_row,109).value().bstr();
m_inventtable.XPS_YieldCode=m_cells.item(m_row,110).value().bstr();
m_inventtable.XPS_ProductCodeId=m_cells.item(m_row,111).value().bstr();
m_inventtable.XPS_QualityCodeId=m_cells.item(m_row,112).value().bstr();
m_inventtable.XPS_YieldCodeId=m_cells.item(m_row,113).value().bstr();
m_inventtable.XPS_CRSReceiveBadQty=str2enum(m_noyes,m_cells.item(m_row,114).value().bstr());
m_inventtable.XPS_PriceCalcGroupId=m_cells.item(m_row,115).value().bstr();
m_inventtable.XPS_ItemStatus=str2enum(m_XPS_ItemStatus,m_cells.item(m_row,116).value().bstr());
m_inventtable.XPS_ItemStatusInstruction=m_cells.item(m_row,117).value().bstr();
m_inventtable.XPS_ItemOwner=str2enum(m_XPS_ItemOwner,m_cells.item(m_row,118).value().bstr());
m_inventtable.XPS_Empties=str2enum(m_noyes,m_cells.item(m_row,119).value().bstr());
m_inventtable.XPS_Priority=str2int(m_cells.item(m_row,120).value().bstr());
m_inventtable.XPS_Zone=str2enum(m_XPS_Zone,m_cells.item(m_row,121).value().bstr());
m_inventtable.XPS_CustUniqueItem=m_cells.item(m_row,122).value().bstr();
m_inventtable.XPSPlanningItemGroupId=m_cells.item(m_row,123).value().bstr();
m_inventtable.insert();
m_type=m_cells.item(m_row+1,1).value().varianttype();
}
m_application.quit();
}
自己写的
static void KY_importInventTable_Excel(Args _args)
{
sysexcelapplication m_application;
sysexcelworkbooks m_workbooks;
sysexcelworkbook m_workbook;
sysexcelworksheets m_worksheets;
sysexcelworksheet m_worksheet;
sysexcelcells m_cells;
//enum type
ItemType m_ItemType;
NoYes m_NoYes;
SalesPriceModel m_SalesPriceModel;
SalesPriceModelBasic m_SalesPriceModelBasic;
ItemNumAlternative m_ItemNumAlternative;
ABC m_ABC;
NoYesCombo m_NoYesCombo;
int m_row;
comvarianttype m_type;
inventTable m_inventTable;
;
m_application = sysexcelapplication::construct();
m_workbooks = m_application.workbooks();
m_workbooks.open("***File_Path***"); //For example:("c:\\replacement\\inventTable.xls")
m_workbook =
m_workbooks.item(1);
m_worksheets = m_workbook.worksheets();
m_worksheet = m_worksheets.itemFromNum(1);
m_cells = m_worksheet.cells();
m_type = m_cells.item(m_row+1,1).value().variantType();
while (m_type != comvariantType::VT_EMPTY)
{
m_row++;
info(strfmt("ItemId:%1,ItemName:%2",
m_cells.item(m_row,1).value().bStr()));
m_inventTable.ItemGroupId = m_cells.item(m_row,1).value().bStr();
m_inventTable.ItemId = m_cells.item(m_row,2).value().bStr();
m_inventTable.ItemName = m_cells.item(m_row,3).value().bStr();
m_inventTable.ItemType = str2enum(m_ItemType,m_cells.item(m_row,4).value().bStr());
m_inventTable.PurchModel = str2enum(m_NoYes,m_cells.item(m_row,5).value().bStr());
m_inventTable.Height = m_cells.item(m_row,6).value().double();
m_inventTable.Width = m_cells.item(m_row,7).value().double();
m_inventTable.SalesModel = str2enum(m_SalesPriceModel,m_cells.item(m_row,8).value().bStr());
m_inventTable.CostGroupId = m_cells.item(m_row,9).value().bStr();
m_inventTable.ReqGroupId = m_cells.item(m_row,10).value().bStr();
m_inventTable.EPCManager = m_cells.item(m_row,11).value().double();
m_inventTable.PrimaryVendorId = m_cells.item(m_row,12).value().bStr();
m_inventTable.NetWeight = m_cells.item(m_row,13).value().double();
// .
// .
// .
// .
// .
// .
m_inventTable.Dimension[1] = m_cells.item(m_row,14).value().bStr();
m_inventTable.Dimension[2] = m_cells.item(m_row,15).value().bStr();
m_inventTable.Dimension[3] = m_cells.item(m_row,16).value().bStr();
m_inventTable.insert();
m_type = m_cells.item(m_row+1,1).value().variantType();
}
m_application.quit();
浙公网安备 33010602011771号