| | |
| | | while (true) |
| | | { |
| | | xstring guid = guids; |
| | | if (guids.find(L",L") >= 0) |
| | | if (guids.find(L",") >= 0) |
| | | { |
| | | guid = guids.left(guids.find(L",L")); |
| | | guids = guids.mid(guids.find(L",L") + 1, 99999); |
| | | guid = guids.left(guids.find(L",")); |
| | | guids = guids.mid(guids.find(L",") + 1, 99999); |
| | | } |
| | | else |
| | | { |
| | |
| | | while (true) |
| | | { |
| | | xstring guid = guids; |
| | | if (guids.find(L",L") >= 0) |
| | | if (guids.find(L",") >= 0) |
| | | { |
| | | guid = guids.left(guids.find(L",L")); |
| | | guids = guids.mid(guids.find(L",L") + 1, 99999); |
| | | guid = guids.left(guids.find(L",")); |
| | | guids = guids.mid(guids.find(L",") + 1, 99999); |
| | | } |
| | | else |
| | | { |
| | |
| | | xstring fstr = L""; |
| | | while (strs != L"") |
| | | { |
| | | int pos = strs.find(L",L"); |
| | | int pos = strs.find(L","); |
| | | if (pos < 0) |
| | | { |
| | | str = strs; |
| | |
| | | if (fstr == L"") |
| | | fstr = GetImageUrl(str); |
| | | else |
| | | fstr += L",L" + GetImageUrl(str); |
| | | fstr += L"," + GetImageUrl(str); |
| | | } |
| | | return fstr; |
| | | } |
| | |
| | | |
| | | 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 getItemCol(xcell dw_obj, int row, xstring head) |
| | | { |
| | | xstring fullhead = L",L" + head + L",L"; |
| | | xstring fullhead = L"," + head + L","; |
| | | int headRow = row; |
| | | int colCount = dw_obj.GetValidCol(headRow); |
| | | for (int col = 1; col <= colCount; col++) |
| | | { |
| | | if (fullhead.find(L",L" + dw_obj.GetItemString(headRow, col) + L",L") >= 0) return col; |
| | | if (fullhead.find(L"," + dw_obj.GetItemString(headRow, col) + L",") >= 0) return col; |
| | | } |
| | | return -1; |
| | | } |
| | |
| | | xstring left = str.left(str.find(prop + L":") + prop.length() + 1); |
| | | if (str.find(L";") >= 0) |
| | | right = str.mid(str.find(L";") + 1, 9999); |
| | | else if (str.find(L",L") >= 0) |
| | | right = str.mid(str.find(L",L") + 1, 9999); |
| | | else if (str.find(L",") >= 0) |
| | | right = str.mid(str.find(L",") + 1, 9999); |
| | | str = left + val + L";" + right; |
| | | //alert(str); |
| | | dw_obj.SetItemString(row, 0, str); |
| | |
| | | str = str.mid(str.find(prop + L":") + prop.length() + 1, 9999); |
| | | if (str.find(L";") >= 0) |
| | | str = str.left(str.find(L";")); |
| | | else if (str.find(L",L") >= 0) |
| | | str = str.left(str.find(L",L")); |
| | | else if (str.find(L",") >= 0) |
| | | str = str.left(str.find(L",")); |
| | | return str; |
| | | } |
| | | return L""; |
| | |
| | | str = str.mid(str.find(L"rowid:") + 6, 99999); |
| | | if (str.find(L";") >= 0) |
| | | str = str.left(str.find(L";")); |
| | | else if (str.find(L",L") >= 0) |
| | | str = str.left(str.find(L",L")); |
| | | else if (str.find(L",") >= 0) |
| | | str = str.left(str.find(L",")); |
| | | return str; |
| | | } |
| | | return 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; |
| | | } |
| | | |
| | | xstring items = GetPurchedItems(); |
| | | xaserverarg arg4 ; |
| | | arg4.setNativePointer(xaserverarg::CreateInstance()); |
| | | |
| | | trace(items); |
| | | arg4.AddArg(L"value", items); |
| | | OpenWindow(L"dev:xpage[QuoteFilePurched.vx]", arg4); |
| | |
| | | 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; |
| | | } |
| | |
| | | |
| | | xstring items = GetPurchItems(); |
| | | xaserverarg arg4 ; |
| | | arg4.setNativePointer(xaserverarg::CreateInstance()); |
| | | |
| | | trace(items); |
| | | arg4.AddArg(L"value", items); |
| | | OpenWindow(L"dev:xpage[QuoteFilePurch.vx]", arg4); |
| | |
| | | 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; |
| | | } |
| | |
| | | return 1; |
| | | } |
| | | |
| | | xstring strs = L",L"; |
| | | xstring strs = L","; |
| | | row++; |
| | | |
| | | int colCustomerPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo"); |
| | |
| | | if (str == L"")break; |
| | | |
| | | //ensureRowID(dw_cell,row); |
| | | if (strs.find(L",L" + str + L",L") < 0) |
| | | if (strs.find(L"," + str + L",") < 0) |
| | | { |
| | | if (purcher.selectSingleNode(L"//Name[.='" + str + L"']")) |
| | | { |
| | | strs += str + L",L"; |
| | | strs += str + L","; |
| | | } |
| | | else |
| | | { |
| | |
| | | } |
| | | row++; |
| | | } |
| | | if (strs == L",L") |
| | | if (strs == L",") |
| | | { |
| | | alert(L"请指定采购人员!"); |
| | | return 1; |
| | |
| | | str = dw_cell.GetItemString(row, purchercol); |
| | | if (str == L"")break; |
| | | |
| | | if (strs.find(L",L" + str + L",L") < 0) |
| | | if (strs.find(L"," + str + L",") < 0) |
| | | { |
| | | if (purcher.selectSingleNode(L"//Name[.='" + str + L"']")) |
| | | { |
| | | strs += str + L",L"; |
| | | strs += str + L","; |
| | | } |
| | | else |
| | | { |
| | |
| | | xml x ; |
| | | |
| | | |
| | | if (strs.left(1) == L",L") strs = strs.mid(1, 9999); |
| | | if (strs.right(1) == L",L") strs = strs.left(strs.length() - 1); |
| | | if (strs.left(1) == L",") strs = strs.mid(1, 9999); |
| | | if (strs.right(1) == L",") strs = strs.left(strs.length() - 1); |
| | | |
| | | xstring purchors = strs; |
| | | |
| | | xstring supplier; |
| | | if (strs.find(L",L", 0) > 0) |
| | | if (strs.find(L",", 0) > 0) |
| | | { |
| | | supplier = strs.left(strs.find(L",L", 0)); |
| | | strs = strs.mid(strs.find(L",L", 0) + 1, 9999); |
| | | supplier = strs.left(strs.find(L",", 0)); |
| | | strs = strs.mid(strs.find(L",", 0) + 1, 9999); |
| | | } |
| | | else |
| | | { |
| | |
| | | if (supplier == username) len = 0; |
| | | if (len < 1) |
| | | { |
| | | if (strs.find(L",L", 0) > 0) |
| | | if (strs.find(L",", 0) > 0) |
| | | { |
| | | supplier = strs.left(strs.find(L",L", 0)); |
| | | strs = strs.mid(strs.find(L",L", 0) + 1, 9999); |
| | | supplier = strs.left(strs.find(L",", 0)); |
| | | strs = strs.mid(strs.find(L",", 0) + 1, 9999); |
| | | } |
| | | else |
| | | { |
| | |
| | | |
| | | |
| | | if (SendToPurcher(supplier, cell1.GetData()) == -1) return 1; |
| | | if (strs.find(L",L", 0) > 0) |
| | | if (strs.find(L",", 0) > 0) |
| | | { |
| | | supplier = strs.left(strs.find(L",L", 0)); |
| | | strs = strs.mid(strs.find(L",L", 0) + 1, 9999); |
| | | supplier = strs.left(strs.find(L",", 0)); |
| | | strs = strs.mid(strs.find(L",", 0) + 1, 9999); |
| | | } |
| | | else |
| | | { |
| | |
| | | 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; |
| | | } |
| | |
| | | return 1; |
| | | } |
| | | |
| | | xstring strs = L",L"; |
| | | xstring strs = L","; |
| | | row++; |
| | | |
| | | int colCustomerPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo"); |
| | |
| | | }*/ |
| | | |
| | | ensureRowID(dw_cell, row); |
| | | if (strs.find(L",L" + str + L",L") < 0) |
| | | if (strs.find(L"," + str + L",") < 0) |
| | | { |
| | | if (purcher.selectSingleNode(L"//Name[.='" + str + L"']")) |
| | | { |
| | | strs += str + L",L"; |
| | | strs += str + L","; |
| | | } |
| | | else |
| | | { |
| | |
| | | } |
| | | row++; |
| | | } |
| | | if (strs == L",L") |
| | | if (strs == L",") |
| | | { |
| | | alert(L"找不到采购人员数据!"); |
| | | return 1; |
| | |
| | | |
| | | xstring items = GetPurchItems(); |
| | | xaserverarg arg4 ; |
| | | arg4.setNativePointer(xaserverarg::CreateInstance()); |
| | | |
| | | trace(items); |
| | | arg4.AddArg(L"value", items); |
| | | OpenWindow(L"dev:xpage[QuoteFilePurch.vx]", arg4); |
| | |
| | | xml x ; |
| | | |
| | | |
| | | if (strs.left(1) == L",L") strs = strs.mid(1, 9999); |
| | | if (strs.right(1) == L",L") strs = strs.left(strs.length() - 1); |
| | | if (strs.left(1) == L",") strs = strs.mid(1, 9999); |
| | | if (strs.right(1) == L",") strs = strs.left(strs.length() - 1); |
| | | |
| | | xstring purchors = strs; |
| | | |
| | | xstring supplier; |
| | | if (strs.find(L",L", 0) > 0) |
| | | if (strs.find(L",", 0) > 0) |
| | | { |
| | | supplier = strs.left(strs.find(L",L", 0)); |
| | | strs = strs.mid(strs.find(L",L", 0) + 1, 9999); |
| | | supplier = strs.left(strs.find(L",", 0)); |
| | | strs = strs.mid(strs.find(L",", 0) + 1, 9999); |
| | | } |
| | | else |
| | | { |
| | |
| | | int len = ts.length(); |
| | | if (len < 1) |
| | | { |
| | | if (strs.find(L",L", 0) > 0) |
| | | if (strs.find(L",", 0) > 0) |
| | | { |
| | | supplier = strs.left(strs.find(L",L", 0)); |
| | | strs = strs.mid(strs.find(L",L", 0) + 1, 9999); |
| | | supplier = strs.left(strs.find(L",", 0)); |
| | | strs = strs.mid(strs.find(L",", 0) + 1, 9999); |
| | | } |
| | | else |
| | | { |
| | |
| | | } |
| | | |
| | | if (SendToPurcher(supplier, cell1.GetData()) == -1) return 1; |
| | | if (strs.find(L",L", 0) > 0) |
| | | if (strs.find(L",", 0) > 0) |
| | | { |
| | | supplier = strs.left(strs.find(L",L", 0)); |
| | | strs = strs.mid(strs.find(L",L", 0) + 1, 9999); |
| | | supplier = strs.left(strs.find(L",", 0)); |
| | | strs = strs.mid(strs.find(L",", 0) + 1, 9999); |
| | | } |
| | | else |
| | | { |
| | |
| | | { |
| | | int pos = str.find(L";", str.find(tm + L":") + 1); |
| | | if (pos < 0) return 1; |
| | | str = str.left(pos) + L",L" + guid + str.mid(pos, 99999); |
| | | str = str.left(pos) + L"," + guid + str.mid(pos, 99999); |
| | | } |
| | | else |
| | | { |
| | |
| | | if (pos > 0 && str.mid(pos - 1, 1) == L":") |
| | | str = str.left(pos) + guid + str.mid(pos, 99999); |
| | | else |
| | | str = str.left(pos) + L",L" + guid + str.mid(pos, 99999); |
| | | str = str.left(pos) + L"," + guid + str.mid(pos, 99999); |
| | | } |
| | | else |
| | | { |
| | |
| | | while (true) |
| | | { |
| | | count++; |
| | | spos = images.find(L",L", spos + 1); |
| | | spos = images.find(L",", spos + 1); |
| | | if (spos < 0) break; |
| | | } |
| | | trace(L" count:" + xstring(count)); |
| | |
| | | while (true) |
| | | { |
| | | if (i == index) break; |
| | | spos = images.find(L",L", spos + 1); |
| | | spos = images.find(L",", spos + 1); |
| | | if (spos < 0) break; |
| | | i++; |
| | | } |
| | | int epos = images.find(L",L", spos + 1); |
| | | int epos = images.find(L",", spos + 1); |
| | | if (spos >= 0) |
| | | { |
| | | if (epos < 0) |
| | |
| | | |
| | | if (im.GetImageCount() - sindex >= 1) |
| | | { |
| | | if (images.find(L",L") == 0) images = images.mid(1, 9999); |
| | | int pos1 = images.find(L",L"); |
| | | if (images.find(L",") == 0) images = images.mid(1, 9999); |
| | | int pos1 = images.find(L","); |
| | | if (pos1 < 0) pos1 = images.find(L";"); |
| | | xstring id = images; |
| | | if (pos1 >= 0) id = images.left(pos1); |
| | |
| | | return 1; |
| | | } |
| | | |
| | | int GetOpenFileNames(xarray<xstring>& items, xstring initFileName, xstring filter, xstring ext) |
| | | int GetOpenFileNames(xarray<xstring>& items, xstring initFileName, const string filter, xstring ext) |
| | | { |
| | | //xstring path = GetOpenFileName(L"", |
| | | // "JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0", |
| | |
| | | int nFilterIndex = 1; |
| | | OPENFILENAMEW ofn; |
| | | |
| | | ofn.lStructSize = 88;//sizeof(ofn); |
| | | ofn.lStructSize = sizeof(ofn); |
| | | ofn.hwndOwner = 0; |
| | | ofn.hInstance = 0; |
| | | ofn.lpstrFilter = filter; |
| | |
| | | else |
| | | { |
| | | wchar_t* start = szPath; |
| | | start += pos * 2; |
| | | start += pos;; |
| | | xstring str = start; |
| | | while (true) |
| | | { |
| | | if (str == L"")break; |
| | | items.push_back(path + L"/" + str); |
| | | start += (str.length() + 1) * 2; |
| | | start += (str.length() + 1) ; |
| | | str = start; |
| | | } |
| | | } |
| | |
| | | //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) |
| | |
| | | if (dw_cell.GetItemString(row, colItemNo) != L"") |
| | | { |
| | | xaserverarg argx ; |
| | | argx.setNativePointer(argx.CreateInstance()); |
| | | |
| | | argx.AddArg(L"GoodsNo", dw_cell.GetItemString(row, colItemNo)); |
| | | OpenWindow(L"dev:xpage[CustomerItemNoList.vx]", argx); |
| | | if (argx.GetArgString(L"action") != L"ok") return 1; |
| | |
| | | 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"); |
| | | |
| | | |
| | |
| | | { |
| | | xml xp ; |
| | | xaserverarg arg_pic ; |
| | | arg_pic.setNativePointer(arg_pic.CreateInstance()); |
| | | |
| | | arg_pic.AddArg(L"SKUNo", goodsno); |
| | | |
| | | ximageview im = GetControl(L"frame:im1"); |
| | |
| | | { |
| | | xml xp ; |
| | | xaserverarg arg_pic ; |
| | | arg_pic.setNativePointer(arg_pic.CreateInstance()); |
| | | |
| | | arg_pic.AddArg(L"GoodsNo", goodsno); |
| | | |
| | | ximageview im = GetControl(L"frame:im1"); |
| | |
| | | |
| | | 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; |
| | |
| | | if (dw_cell.GetItemString(ARow, colItemNo) != L"") |
| | | { |
| | | xaserverarg argx ; |
| | | argx.setNativePointer(argx.CreateInstance()); |
| | | |
| | | argx.AddArg(L"GoodsNo", dw_cell.GetItemString(ARow, colItemNo)); |
| | | OpenWindow(L"dev:xpage[CustomerItemNoList.vx]", argx); |
| | | if (argx.GetArgString(L"action") != L"ok") |
| | |
| | | |
| | | 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"产品信息"); |
| | |
| | | |
| | | int onload() |
| | | { |
| | | SetArg(); |
| | | Reset(); |
| | | orivalue = L""; |
| | | ARow = 1; |
| | | ACol = 1; |
| | | |
| | | |
| | | tabsheet = L"tab_bill"; |
| | | templateID = L"ECDDE57A-43EB-49DD-9287-DC5D0B29ECA1"; |
| | | xstring templ = L""; |
| | |
| | | |
| | | int LoadPurcher() |
| | | { |
| | | xml purcher ; |
| | | //xml purcher ; |
| | | xaserverarg arg ; |
| | | |
| | | arg.AddArg(L"id", L"采购员"); |