| | |
| | | val = dw_exchangefile.GetItemString(1, col); |
| | | val = val.trim(); |
| | | if (val == L"")continue; |
| | | if (val.find(L"(L") >= 0) val = val.left(val.find(L"(L")); |
| | | if (val.find(L"(") >= 0) val = val.left(val.find(L"(")); |
| | | if (val.find(L"(") >= 0) val = val.left(val.find(L"(")); |
| | | if (val.find(L"[") >= 0) val = val.left(val.find(L"[")); |
| | | if (val.find(L"【") >= 0) val = val.left(val.find(L"【")); |
| | |
| | | { |
| | | p += L"&"; |
| | | int i = 1; |
| | | while (p.find(L"=L", 0) > 0) |
| | | while (p.find(L"=", 0) > 0) |
| | | { |
| | | xstring name = p.mid(0, p.find(L"=L", 0)); |
| | | xstring value = p.mid(p.find(L"=L", 0) + 1, p.find(L"&", 0) - p.find(L"=L", 0) - 1); |
| | | xstring name = p.mid(0, p.find(L"=", 0)); |
| | | xstring value = p.mid(p.find(L"=", 0) + 1, p.find(L"&", 0) - p.find(L"=", 0) - 1); |
| | | if (name == n) return L"" + value; |
| | | i += 1; |
| | | p = p.mid(p.find(L"&", 0) + 1, p.length()); |
| | |
| | | { |
| | | p += L"&"; |
| | | int i = 1; |
| | | while (p.find(L"=L", 0) > 0) |
| | | while (p.find(L"=", 0) > 0) |
| | | { |
| | | xstring name = p.mid(0, p.find(L"=L", 0)); |
| | | xstring value = p.mid(p.find(L"=L", 0) + 1, p.find(L"&", 0) - p.find(L"=L", 0) - 1); |
| | | xstring name = p.mid(0, p.find(L"=", 0)); |
| | | xstring value = p.mid(p.find(L"=", 0) + 1, p.find(L"&", 0) - p.find(L"=", 0) - 1); |
| | | if (name == n) return L"" + value; |
| | | i += 1; |
| | | p = p.mid(p.find(L"&", 0) + 1, p.length()); |
| | |
| | | { |
| | | |
| | | int i = 1; |
| | | while (p.find(L"=L",0)>0) |
| | | while (p.find(L"=",0)>0) |
| | | { |
| | | xstring name = p.mid(0, p.find(L"=L",0)); |
| | | xstring value = p.mid(p.find(L"=L",0) + 1, p.find(L"=L",0) - 1); |
| | | xstring name = p.mid(0, p.find(L"=",0)); |
| | | xstring value = p.mid(p.find(L"=",0) + 1, p.find(L"=",0) - 1); |
| | | return ""+value; |
| | | i += 1; |
| | | } |
| | |
| | | { |
| | | |
| | | int i = 1; |
| | | while (p.find(L"=L",0)>0) |
| | | while (p.find(L"=",0)>0) |
| | | { |
| | | xstring name = p.mid(0, p.find(L"=L",0)); |
| | | xstring value = p.mid(p.find(L"=L",0) + 1, p.find(L"=L",0) - 1); |
| | | xstring name = p.mid(0, p.find(L"=",0)); |
| | | xstring value = p.mid(p.find(L"=",0) + 1, p.find(L"=",0) - 1); |
| | | return ""+value; |
| | | i += 1; |
| | | } |
| | |
| | | { |
| | | arg.AddArg(L"CustomerID",e.getAttribute(L"id")); |
| | | xstring name = e.getAttribute(L"name"); |
| | | if(name.find(L"(L")>=0) name = name.left(name.find(L"(L")); |
| | | if(name.find(L"(")>=0) name = name.left(name.find(L"(")); |
| | | arg.AddArg(L"CustomerName",name); |
| | | } |
| | | } |
| | |
| | | { |
| | | arg.AddArg(L"CustomerID", e.getAttribute(L"id")); |
| | | xstring name = e.getAttribute(L"name"); |
| | | if (name.find(L"(L") >= 0) name = name.left(name.find(L"(L")); |
| | | if (name.find(L"(") >= 0) name = name.left(name.find(L"(")); |
| | | arg.AddArg(L"CustomerName", name); |
| | | } |
| | | return 1; |
| | |
| | | |
| | | //if(dw_base.GetItemString(1,L"GoodsSource") == L"") |
| | | //{ |
| | | // alert(L"请选择货物产地(货物产地:开票工厂金额最大的工厂所属地)L"); |
| | | // alert(L"请选择货物产地(货物产地:开票工厂金额最大的工厂所属地)"); |
| | | // return 0; |
| | | // } |
| | | |
| | |
| | | xstring ClassifyID = dw_custom.GetItemString(k, L"ClassifyID"); |
| | | xstring ClassifyName = dw_custom.GetItemString(k, L"CustName"); |
| | | xstring GroupNo = dw_custom.GetItemString(k, L"GroupNo"); |
| | | if (GroupNo != L"") ClassifyName += ClassifyName + L"(L" + GroupNo + L")L"; |
| | | if (GroupNo != L"") ClassifyName += ClassifyName + L"(" + GroupNo + L")"; |
| | | |
| | | double LegalQty = dw_custom.GetItemDouble(k, L"LegalQty"); |
| | | |
| | |
| | | xstring ClassifyID = dw_custom.GetItemString(k, L"ClassifyID"); |
| | | xstring ClassifyName = dw_custom.GetItemString(k, L"CustName"); |
| | | xstring GroupNo = dw_custom.GetItemString(k, L"GroupNo"); |
| | | if (GroupNo != L"") ClassifyName += ClassifyName + L"(L" + GroupNo + L")L"; |
| | | if (GroupNo != L"") ClassifyName += ClassifyName + L"(" + GroupNo + L")"; |
| | | double VQuantity = dw_custom.GetItemDouble(k, L"Quantity"); |
| | | double VAmount = dw_custom.GetItemDouble(k, L"Amount"); |
| | | double qty = 0.0; |
| | |
| | | |
| | | int colBuyerRemark = getItemCol(cell, startRow - 1, L"采购To业务备注"); |
| | | int colFactoryImage = getItemCol(cell, startRow - 1, L"工厂图片"); |
| | | int colGWT = getItemCol(cell, startRow - 1, L"毛重,毛重(KG)L"); |
| | | int colNWT = getItemCol(cell, startRow - 1, L"净重,净重(KG)L"); |
| | | int colVolDesc = getItemCol(cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)L"); |
| | | int colVol = getItemCol(cell, startRow - 1, L"体积,体积(M3)L"); |
| | | int col40HQ = getItemCol(cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int colGWT = getItemCol(cell, startRow - 1, L"毛重,毛重(KG)"); |
| | | int colNWT = getItemCol(cell, startRow - 1, L"净重,净重(KG)"); |
| | | int colVolDesc = getItemCol(cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)"); |
| | | int colVol = getItemCol(cell, startRow - 1, L"体积,体积(M3)"); |
| | | int col40HQ = getItemCol(cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | |
| | | int colSupplier1 = getItemCol(cell, startRow - 1, L"供应商1"); |
| | | int colSupplier = getItemCol(cell, startRow - 1, L"供应商"); |
| | | int colPOPrice1 = getItemCol(cell, startRow - 1, L"价格1"); |
| | | int colPOPrice = getItemCol(cell, startRow - 1, L"价格"); |
| | | |
| | | int colInnerOuter = getItemCol(cell, startRow - 1, L"装箱数(内/外)L"); |
| | | int colInnerOuter = getItemCol(cell, startRow - 1, L"装箱数(内/外)"); |
| | | int colItemQty = getItemCol(cell, startRow - 1, L"数量,Qty"); |
| | | int colPackage = getItemCol(cell, startRow - 1, L"Package,包装方式"); |
| | | int colBuyer = getItemCol(cell, startRow - 1, L"采购人员"); |
| | |
| | | |
| | | int colBuyerRemark = getItemCol(cell, startRow - 1, L"采购To业务备注"); |
| | | int colFactoryImage = getItemCol(cell, startRow - 1, L"工厂图片"); |
| | | int colGWT = getItemCol(cell, startRow - 1, L"毛重,毛重(KG)L"); |
| | | int colNWT = getItemCol(cell, startRow - 1, L"净重,净重(KG)L"); |
| | | int colVolDesc = getItemCol(cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)L"); |
| | | int colVol = getItemCol(cell, startRow - 1, L"体积,体积(M3)L"); |
| | | int col40HQ = getItemCol(cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int colGWT = getItemCol(cell, startRow - 1, L"毛重,毛重(KG)"); |
| | | int colNWT = getItemCol(cell, startRow - 1, L"净重,净重(KG)"); |
| | | int colVolDesc = getItemCol(cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)"); |
| | | int colVol = getItemCol(cell, startRow - 1, L"体积,体积(M3)"); |
| | | int col40HQ = getItemCol(cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | |
| | | int colPOPrice = getItemCol(cell, startRow - 1, L"价格"); |
| | | int colSupplier = getItemCol(cell, startRow - 1, L"供应商"); |
| | |
| | | int colBOMType2 = getItemCol(cell, startRow - 1, L"类型2"); |
| | | int colBOMType3 = getItemCol(cell, startRow - 1, L"类型3"); |
| | | |
| | | int colInnerOuter = getItemCol(cell, startRow - 1, L"装箱数(内/外)L"); |
| | | int colInnerOuter = getItemCol(cell, startRow - 1, L"装箱数(内/外)"); |
| | | int colItemQty = getItemCol(cell, startRow - 1, L"数量,Qty"); |
| | | int colPackage = getItemCol(cell, startRow - 1, L"Package,包装方式"); |
| | | int colBuyer = getItemCol(cell, startRow - 1, L"采购人员"); |
| | |
| | | |
| | | int colBuyerRemark = getItemCol(dw_cell, startRow - 1, L"采购To业务备注"); |
| | | int colFactoryImage = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int colGWT = getItemCol(dw_cell, startRow - 1, L"毛重,毛重(KG)L"); |
| | | int colNWT = getItemCol(dw_cell, startRow - 1, L"净重,净重(KG)L"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)L"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)L"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int colGWT = getItemCol(dw_cell, startRow - 1, L"毛重,毛重(KG)"); |
| | | int colNWT = getItemCol(dw_cell, startRow - 1, L"净重,净重(KG)"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商"); |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1"); |
| | |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyer = getItemCol(dw_cell, startRow - 1, L"采购人员"); |
| | | int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | |
| | | int colGW = getItemCol(dw_cell, startRow - 1, L"毛重(KG)L"); |
| | | int colNW = getItemCol(dw_cell, startRow - 1, L"净重(KG)L"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"长X宽X高(CM)L"); |
| | | int colGW = getItemCol(dw_cell, startRow - 1, L"毛重(KG)"); |
| | | int colNW = getItemCol(dw_cell, startRow - 1, L"净重(KG)"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"长X宽X高(CM)"); |
| | | |
| | | int colPrice = getItemCol(dw_cell, startRow - 1, L"采购价"); |
| | | |
| | |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyer = getItemCol(dw_cell, startRow - 1, L"采购人员"); |
| | | int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | |
| | | int colGW = getItemCol(dw_cell, startRow - 1, L"毛重(KG)L"); |
| | | int colNW = getItemCol(dw_cell, startRow - 1, L"净重(KG)L"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"长X宽X高(CM)L"); |
| | | int colGW = getItemCol(dw_cell, startRow - 1, L"毛重(KG)"); |
| | | int colNW = getItemCol(dw_cell, startRow - 1, L"净重(KG)"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"长X宽X高(CM)"); |
| | | |
| | | int colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | |
| | | int colItemSpec = getItemCol(dw_cell,startRow - 1,L"Specifications,规格,产品规格"); |
| | | int colBuyer = getItemCol(dw_cell,startRow - 1,L"采购人员"); |
| | | int colPackage = getItemCol(dw_cell,startRow - 1,L"Package,包装方式"); |
| | | int col40HQ= getItemCol(dw_cell,startRow - 1,L"40HQ,QTY(40HQ)L"); |
| | | int col40HQ= getItemCol(dw_cell,startRow - 1,L"40HQ,QTY(40HQ)"); |
| | | int colBuyer = getItemCol(dw_cell,startRow - 1,L"采购人员"); |
| | | |
| | | xstring items=L"<data>"; |
| | |
| | | |
| | | int colBuyerRemark = getItemCol(dw_cell, startRow - 1, L"采购To业务备注"); |
| | | int colFactoryImage = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int colGWT = getItemCol(dw_cell, startRow - 1, L"毛重,毛重(KG)L"); |
| | | int colNWT = getItemCol(dw_cell, startRow - 1, L"净重,净重(KG)L"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)L"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)L"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int colGWT = getItemCol(dw_cell, startRow - 1, L"毛重,毛重(KG)"); |
| | | int colNWT = getItemCol(dw_cell, startRow - 1, L"净重,净重(KG)"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1"); |
| | | int colPOPrice1 = getItemCol(dw_cell, startRow - 1, L"价格1"); |
| | |
| | | { |
| | | head = dw_cell.GetItemString(row, col); |
| | | if (head == L"Product Name" || head == L"Product Description") namecol = col; |
| | | if (head == L"FOB Price" || head == L"Fob Price" || head == L"FOB Price(USD)L") pricecol = col; |
| | | if (head == L"FOB Price" || head == L"Fob Price" || head == L"FOB Price(USD)") pricecol = col; |
| | | if (head == L"采购To业务备注") purchremarkcol = col; |
| | | if (head == L"采购人员") purchercol = col; |
| | | } |
| | |
| | | int colItemQty = getItemCol(dw_cell, headrow, L"数量,Qty"); |
| | | //int colItemSpec = getItemCol(dw_cell,headrow,L"Specifications,规格,产品规格"); |
| | | int colItemPurchDate = getItemCol(dw_cell, headrow, L"业务发送采购时间"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int colInnerOuter = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)L"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | int colInnerOuter = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)"); |
| | | int col = 0; |
| | | int namecol = 0; |
| | | int pricecol = 0; |
| | |
| | | { |
| | | head = dw_cell.GetItemString(row, col); |
| | | if (head == L"Product Name" || head == L"Product Description") namecol = col; |
| | | if (head == L"FOB Price" || head == L"Fob Price" || head == L"FOB Price(USD)L") pricecol = col; |
| | | if (head == L"FOB Price" || head == L"Fob Price" || head == L"FOB Price(USD)") pricecol = col; |
| | | if (head == L"采购To业务备注") purchremarkcol = col; |
| | | if (head == L"采购人员") purchercol = col; |
| | | } |
| | |
| | | int colItemQty = getItemCol(dw_cell, headrow, L"数量,Qty"); |
| | | //int colItemSpec = getItemCol(dw_cell,headrow,L"Specifications,规格,产品规格"); |
| | | int colItemPurchDate = getItemCol(dw_cell, headrow, L"业务发送采购时间"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int colInnerOuter = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)L"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | int colInnerOuter = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)"); |
| | | int colSalebackDate = getItemCol(dw_cell, startRow - 1, L"采购提交业务时间"); |
| | | |
| | | int col = 0; |
| | |
| | | { |
| | | head = dw_cell.GetItemString(row, col); |
| | | if (head == L"Product Name" || head == L"Product Description") namecol = col; |
| | | if (head == L"FOB Price" || head == L"Fob Price" || head == L"FOB Price(USD)L") pricecol = col; |
| | | if (head == L"FOB Price" || head == L"Fob Price" || head == L"FOB Price(USD)") pricecol = col; |
| | | if (head == L"采购To业务备注") purchremarkcol = col; |
| | | if (head == L"采购人员") purchercol = col; |
| | | } |
| | |
| | | int colItemQty = getItemCol(dw_cell, headrow, L"数量,Qty"); |
| | | //int colItemSpec = getItemCol(dw_cell,headrow,L"Specifications,规格,产品规格"); |
| | | int colItemPurchDate = getItemCol(dw_cell, headrow, L"业务发送采购时间"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int colInnerOuter = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)L"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | int colInnerOuter = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)"); |
| | | |
| | | int col = 0; |
| | | int namecol = 0; |
| | |
| | | { |
| | | head = dw_cell.GetItemString(row, col); |
| | | if (head == L"Product Name" || head == L"Product Description") namecol = col; |
| | | if (head == L"FOB Price" || head == L"Fob Price" || head == L"FOB Price(USD)L") pricecol = col; |
| | | if (head == L"FOB Price" || head == L"Fob Price" || head == L"FOB Price(USD)") pricecol = col; |
| | | if (head == L"采购To业务备注") purchremarkcol = col; |
| | | if (head == L"采购人员") purchercol = col; |
| | | } |
| | |
| | | //int colToPODate = getItemCol(dw_cell,startRow - 1,L"业务发送采购时间"); |
| | | |
| | | |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)L"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)L"); |
| | | int colQtyPerPack = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外),装箱数(外/内)L"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)"); |
| | | int colQtyPerPack = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外),装箱数(外/内)"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | int colSKUID = getItemCol(dw_cell, startRow - 1, L"SKUID"); |
| | | |
| | | int colPONote = getItemCol(dw_cell, startRow - 1, L"采购To业务备注"); |
| | | int colPOPhoto = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int colPOPrice = getItemCol(dw_cell, startRow - 1, L"采购价"); |
| | | int colNW = getItemCol(dw_cell, startRow - 1, L"毛重(KG)L"); |
| | | int colGW = getItemCol(dw_cell, startRow - 1, L"净重(KG)L"); |
| | | int colNW = getItemCol(dw_cell, startRow - 1, L"毛重(KG)"); |
| | | int colGW = getItemCol(dw_cell, startRow - 1, L"净重(KG)"); |
| | | int colSKUNo = getItemCol(dw_cell, startRow - 1, L"SKUID,SKUNo"); |
| | | |
| | | if (col == colFOBPrice) |
| | |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | int colPackage = getItemCol(dw_cell, startRow - 1, L"Package"); |
| | | int colPurchor = getItemCol(dw_cell, startRow - 1, L"采购员,采购人员"); |
| | | int colQtyPerPack = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)L"); |
| | | int colQtyPerPack = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)"); |
| | | int colFOBPrice = getItemCol(dw_cell, startRow - 1, L"FOB Price,FOB Price(USD),Fob Price"); |
| | | int colQuantity = getItemCol(dw_cell, startRow - 1, L"数量,Qty"); |
| | | |
| | | int colBuyerRemark = getItemCol(dw_cell, startRow - 1, L"采购To业务备注"); |
| | | int colFactoryImage = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int colGWT = getItemCol(dw_cell, startRow - 1, L"毛重,毛重(KG)L"); |
| | | int colNWT = getItemCol(dw_cell, startRow - 1, L"净重,净重(KG)L"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)L"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)L"); |
| | | int colHQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int colGWT = getItemCol(dw_cell, startRow - 1, L"毛重,毛重(KG)"); |
| | | int colNWT = getItemCol(dw_cell, startRow - 1, L"净重,净重(KG)"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)"); |
| | | int colHQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | int colSKUNo = getItemCol(dw_cell, startRow - 1, L"SKUID,SKUNo"); |
| | | |
| | | |
| | |
| | | |
| | | int colSaler = getItemCol(dw_cell, startRow - 1, L"业务员"); |
| | | |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)L"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)L"); |
| | | int colQtyPerPack = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外),装箱数(外/内)L"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)"); |
| | | int colQtyPerPack = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外),装箱数(外/内)"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | int colSKUID = getItemCol(dw_cell, startRow - 1, L"SKUID"); |
| | | |
| | | int colPONote = getItemCol(dw_cell, startRow - 1, L"采购To业务备注"); |
| | |
| | | |
| | | int colPOPhoto = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int colPOPrice = getItemCol(dw_cell, startRow - 1, L"采购价"); |
| | | int colNW = getItemCol(dw_cell, startRow - 1, L"毛重(KG)L"); |
| | | int colGW = getItemCol(dw_cell, startRow - 1, L"净重(KG)L"); |
| | | int colNW = getItemCol(dw_cell, startRow - 1, L"毛重(KG)"); |
| | | int colGW = getItemCol(dw_cell, startRow - 1, L"净重(KG)"); |
| | | int colSKUNo = getItemCol(dw_cell, startRow - 1, L"SKUID,SKUNo"); |
| | | |
| | | int purchremarkcol = getItemCol(dw_cell, startRow - 1, L"采购To业务备注"); |
| | |
| | | //int colToPODate = getItemCol(dw_cell,startRow - 1,L"业务发送采购时间"); |
| | | |
| | | |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)L"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)L"); |
| | | int colQtyPerPack = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外),装箱数(外/内)L"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)"); |
| | | int colQtyPerPack = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外),装箱数(外/内)"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | int colSKUID = getItemCol(dw_cell, startRow - 1, L"SKUID"); |
| | | |
| | | int colPONote = getItemCol(dw_cell, startRow - 1, L"采购To业务备注"); |
| | | int colPOPhoto = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int colPOPrice = getItemCol(dw_cell, startRow - 1, L"采购价"); |
| | | int colNW = getItemCol(dw_cell, startRow - 1, L"毛重(KG)L"); |
| | | int colGW = getItemCol(dw_cell, startRow - 1, L"净重(KG)L"); |
| | | int colNW = getItemCol(dw_cell, startRow - 1, L"毛重(KG)"); |
| | | int colGW = getItemCol(dw_cell, startRow - 1, L"净重(KG)"); |
| | | int colSKUNo = getItemCol(dw_cell, startRow - 1, L"SKUID,SKUNo"); |
| | | |
| | | dwhdr.idFrom = 0; |
| | |
| | | |
| | | int colBuyerRemark = getItemCol(dw_cell, startRow - 1, L"采购To业务备注"); |
| | | int colFactoryImage = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int colGWT = getItemCol(dw_cell, startRow - 1, L"毛重,毛重(KG)L"); |
| | | int colNWT = getItemCol(dw_cell, startRow - 1, L"净重,净重(KG)L"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)L"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)L"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L"); |
| | | int colGWT = getItemCol(dw_cell, startRow - 1, L"毛重,毛重(KG)"); |
| | | int colNWT = getItemCol(dw_cell, startRow - 1, L"净重,净重(KG)"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)"); |
| | | int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)"); |
| | | int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)"); |
| | | int colPurchedDate = getItemCol(dw_cell, startRow - 1, L"采购提交业务时间"); |
| | | int colPhoto1 = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | //int colProductInfo = getItemCol(dw_cell,startRow - 1,L"产品信息"); |
| | |
| | | { |
| | | arg.AddArg(L"CustomerID", e.getAttribute(L"id")); |
| | | xstring name = e.getAttribute(L"name"); |
| | | if (name.find(L"(L") >= 0) name = name.left(name.find(L"(L")); |
| | | if (name.find(L"(") >= 0) name = name.left(name.find(L"(")); |
| | | arg.AddArg(L"CustomerName", name); |
| | | } |
| | | return 1; |
| | |
| | | end if |
| | | |
| | | if ls_comName <> '产品部' then |
| | | this.setitem(row,'billamt',dec(this.Describe(L"evaluate('notifybuyamt - if(isnull(kkamt),0,kkamt) + if(isnull(dkamt),0,dkamt)',L"+xstring(row)+L")L"))) |
| | | this.setitem(row,'billamt',dec(this.Describe(L"evaluate('notifybuyamt - if(isnull(kkamt),0,kkamt) + if(isnull(dkamt),0,dkamt)',L"+xstring(row)+L")"))) |
| | | else |
| | | this.setitem(row,'billamt',dec(this.Describe(L"evaluate('prd_nbuyamt - if(isnull(kkamt),0,kkamt) + if(isnull(dkamt),0,dkamt)',L"+xstring(row)+L")L"))) |
| | | this.setitem(row,'billamt',dec(this.Describe(L"evaluate('prd_nbuyamt - if(isnull(kkamt),0,kkamt) + if(isnull(dkamt),0,dkamt)',L"+xstring(row)+L")"))) |
| | | end if |
| | | |
| | | ll_decrate = this.getitemdecimal(row,'retax') |
| | |
| | | x.load(L"cache\\config.xml"); |
| | | if (x.xml() == L"") |
| | | { |
| | | //alert(L"<config><home "+att+L"=L"+value+L"/></config>"); |
| | | //alert(L"<config><home "+att+L"="+value+L"/></config>"); |
| | | x.loadXML(L"<config><home " + att + L"='" + value + L"'/></config>"); |
| | | } |
| | | else |