| | |
| | | int rowCount = dw_obj.GetValidRow(); |
| | | for (int row = 1; row <= rowCount; row++) |
| | | { |
| | | if (dw_obj.GetItemString(row, 0) == L"标题") return row; |
| | | if (dw_obj.GetItemString(row, 0) == L"标题") return row; |
| | | if (dw_obj.GetItemString(row, 1) == L"SKUID" || dw_obj.GetItemString(row, 2) == L"SKUID") return row; |
| | | } |
| | | return -1; |
| | |
| | | } |
| | | if (guid != L"") |
| | | { |
| | | xstring goodno = L"客户图片"; |
| | | if (tm == L"supplier-photo") goodno = L"供应商图片"; |
| | | xstring goodno = L"客户图片"; |
| | | if (tm == L"supplier-photo") goodno = L"供应商图片"; |
| | | xstring picname = GetImageUrl(guid);//"/business/products/chanpin/"+guid.left(2)+L"/"+guid+L".jpg"; |
| | | im.AddImages(picname, goodno); |
| | | } |
| | |
| | | { |
| | | xstring content = L""; |
| | | xstring base = L""; |
| | | base += L"<QuoteNo>" + getBaseItem(cell, L"报价单号:") + L"</QuoteNo>"; |
| | | base += L"<ExpDate>" + getBaseItem(cell, L"报价截止日期:") + L"</ExpDate>"; |
| | | base += L"<PrjName>" + getBaseItem(cell, L"项目名称:") + L"</PrjName>"; |
| | | base += L"<QuoteNo>" + getBaseItem(cell, L"报价单号:") + L"</QuoteNo>"; |
| | | base += L"<ExpDate>" + getBaseItem(cell, L"报价截止日期:") + L"</ExpDate>"; |
| | | base += L"<PrjName>" + getBaseItem(cell, L"项目名称:") + L"</PrjName>"; |
| | | base += L"<QuoteDate>" + dw_base.GetItemString(1, L"QuoteDate") + L"</QuoteDate>"; |
| | | |
| | | int startRow = getItemHeadRow(cell); |
| | | |
| | | //没有找到商品行的标题 |
| | | //没有找到商品行的标题 |
| | | if (startRow < 1) return L""; |
| | | startRow++; |
| | | |
| | | int colItemNo = getItemCol(cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemNo = getItemCol(cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(cell, startRow - 1, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = getItemCol(cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(cell, startRow - 1, L"采购价,采购价格"); |
| | | int colCustomerImage = getItemCol(cell, startRow - 1, L"Photo,图片"); |
| | | int colItemCName = getItemCol(cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(cell, startRow - 1, L"采购价,采购价格"); |
| | | int colCustomerImage = getItemCol(cell, startRow - 1, L"Photo,ͼƬ"); |
| | | int colSKUID = getItemCol(cell, startRow - 1, L"SKUID"); |
| | | int colSaleRemark = getItemCol(cell, startRow - 1, L"业务To采购备注"); |
| | | int colSaleRemark = getItemCol(cell, startRow - 1, L"业务To采购备注"); |
| | | |
| | | 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 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 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 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 colItemQty = getItemCol(cell, startRow - 1, L"数量,Qty"); |
| | | int colPackage = getItemCol(cell, startRow - 1, L"Package,包装方式"); |
| | | int colBuyer = getItemCol(cell, startRow - 1, L"采购人员"); |
| | | int colInnerOuter = getItemCol(cell, startRow - 1, L"装箱数(内/外)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 colRemark = getItemCol(cell, startRow - 1, L"Remarks"); |
| | | int colFOBPrice = getItemCol(cell, startRow - 1, L"FOB Price,FOB Price(USD),Fob Price"); |
| | | |
| | |
| | | { |
| | | xstring content = L""; |
| | | xstring base = L""; |
| | | base += L"<QuoteNo>" + getBaseItem(cell, L"报价单号:") + L"</QuoteNo>"; |
| | | base += L"<ExpDate>" + getBaseItem(cell, L"报价截止日期:") + L"</ExpDate>"; |
| | | base += L"<PrjName>" + getBaseItem(cell, L"项目名称:") + L"</PrjName>"; |
| | | base += L"<QuoteNo>" + getBaseItem(cell, L"报价单号:") + L"</QuoteNo>"; |
| | | base += L"<ExpDate>" + getBaseItem(cell, L"报价截止日期:") + L"</ExpDate>"; |
| | | base += L"<PrjName>" + getBaseItem(cell, L"项目名称:") + L"</PrjName>"; |
| | | base += L"<QuoteDate>" + dw_base.GetItemString(1, L"QuoteDate") + L"</QuoteDate>"; |
| | | |
| | | int startRow = getItemHeadRow(cell); |
| | | |
| | | //没有找到商品行的标题 |
| | | //没有找到商品行的标题 |
| | | if (startRow < 1) return L""; |
| | | startRow++; |
| | | |
| | | int colItemNo = getItemCol(cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemNo = getItemCol(cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(cell, startRow - 1, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = getItemCol(cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(cell, startRow - 1, L"采购价,采购价格"); |
| | | int colCustomerImage = getItemCol(cell, startRow - 1, L"Photo,图片"); |
| | | int colItemCName = getItemCol(cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(cell, startRow - 1, L"采购价,采购价格"); |
| | | int colCustomerImage = getItemCol(cell, startRow - 1, L"Photo,ͼƬ"); |
| | | int colSKUID = getItemCol(cell, startRow - 1, L"SKUID"); |
| | | int colSaleRemark = getItemCol(cell, startRow - 1, L"业务To采购备注"); |
| | | int colSaleRemark = getItemCol(cell, startRow - 1, L"业务To采购备注"); |
| | | |
| | | 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 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 colPOPrice = getItemCol(cell, startRow - 1, L"价格"); |
| | | int colSupplier = getItemCol(cell, startRow - 1, L"供应商"); |
| | | int colPOPrice1 = getItemCol(cell, startRow - 1, L"价格1"); |
| | | int colSupplier1 = getItemCol(cell, startRow - 1, L"供应商1"); |
| | | int colPOPrice2 = getItemCol(cell, startRow - 1, L"价格2"); |
| | | int colSupplier2 = getItemCol(cell, startRow - 1, L"供应商2"); |
| | | int colPOPrice3 = getItemCol(cell, startRow - 1, L"价格3"); |
| | | int colSupplier3 = getItemCol(cell, startRow - 1, L"供应商3"); |
| | | int colBOMType = getItemCol(cell, startRow - 1, L"类型"); |
| | | int colBOMType1 = getItemCol(cell, startRow - 1, L"类型1"); |
| | | int colBOMType2 = getItemCol(cell, startRow - 1, L"类型2"); |
| | | int colBOMType3 = getItemCol(cell, startRow - 1, L"类型3"); |
| | | int colPOPrice = getItemCol(cell, startRow - 1, L"价格"); |
| | | int colSupplier = getItemCol(cell, startRow - 1, L"供应商"); |
| | | int colPOPrice1 = getItemCol(cell, startRow - 1, L"价格1"); |
| | | int colSupplier1 = getItemCol(cell, startRow - 1, L"供应商1"); |
| | | int colPOPrice2 = getItemCol(cell, startRow - 1, L"价格2"); |
| | | int colSupplier2 = getItemCol(cell, startRow - 1, L"供应商2"); |
| | | int colPOPrice3 = getItemCol(cell, startRow - 1, L"价格3"); |
| | | int colSupplier3 = getItemCol(cell, startRow - 1, L"供应商3"); |
| | | int colBOMType = getItemCol(cell, startRow - 1, L"类型"); |
| | | int colBOMType1 = getItemCol(cell, startRow - 1, L"类型1"); |
| | | 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 colItemQty = getItemCol(cell, startRow - 1, L"数量,Qty"); |
| | | int colPackage = getItemCol(cell, startRow - 1, L"Package,包装方式"); |
| | | int colBuyer = getItemCol(cell, startRow - 1, L"采购人员"); |
| | | int colInnerOuter = getItemCol(cell, startRow - 1, L"装箱数(内/外)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 colRemark = getItemCol(cell, startRow - 1, L"Remarks"); |
| | | int colFOBPrice = getItemCol(cell, startRow - 1, L"FOB Price,FOB Price(USD),Fob Price"); |
| | | |
| | |
| | | extStr += L"<BOMType2>" + cell.GetItemString(row, colBOMType2) + L"</BOMType2>"; |
| | | extStr += L"<BOMType3>" + cell.GetItemString(row, colBOMType2) + L"</BOMType3>"; |
| | | |
| | | itemStr += L"<ExtItem>" + extStr + L"</ExtItem>"; //备用采购信息 |
| | | itemStr += L"<ExtItem>" + extStr + L"</ExtItem>"; //备用采购信息 |
| | | xstring eid = GetGuid(); |
| | | setRowTerm(cell, row, L"EnquiryLineID", eid); |
| | | itemStr += L"<EnquiryLineID>" + getRowTerm(cell, row, L"EnquiryLineID") + L"</EnquiryLineID>"; |
| | |
| | | |
| | | if (dw_base.GetItemString(1, L"QuoteNo") == L"") |
| | | { |
| | | alert(L"请先保存数据!"); |
| | | alert(L"请先保存数据!"); |
| | | return 1; |
| | | } |
| | | |
| | |
| | | im.Reset(); |
| | | |
| | | int startRow = getItemHeadRow(dw_cell); |
| | | //没有找到商品行的标题 |
| | | //没有找到商品行的标题 |
| | | if (startRow < 1) return 1; |
| | | if (row <= startRow) return 1; |
| | | |
| | |
| | | int ensureRowID() |
| | | { |
| | | int startRow = getItemHeadRow(dw_cell); |
| | | //没有找到商品行的标题 |
| | | //没有找到商品行的标题 |
| | | if (startRow < 1) return 0; |
| | | startRow++; |
| | | |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell, startRow - 1, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | |
| | | int LastRow = dw_cell.GetValidRow(); |
| | | for (int row = startRow; row <= LastRow; row++) |
| | |
| | | int LookupCellRow(xcell cell, xstring rowid) |
| | | { |
| | | int startRow = getItemHeadRow(cell); |
| | | //没有找到商品行的标题 |
| | | //没有找到商品行的标题 |
| | | if (startRow < 1) return 0; |
| | | startRow++; |
| | | |
| | |
| | | return 1; |
| | | } |
| | | |
| | | //生成返回销售人员的采购产品信息 |
| | | //生成返回销售人员的采购产品信息 |
| | | xstring makeMessageBacktoSaler(xstring myurl) |
| | | { |
| | | int startRow = getItemHeadRow(dw_cell); |
| | | |
| | | //没有找到商品行的标题 |
| | | //没有找到商品行的标题 |
| | | if (startRow < 1) return L""; |
| | | startRow++; |
| | | |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell, startRow - 1, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_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 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 colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商"); |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1"); |
| | | int colPOPrice = getItemCol(dw_cell, startRow - 1, L"价格"); |
| | | int colPOPrice1 = getItemCol(dw_cell, startRow - 1, L"价格1"); |
| | | int colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商"); |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1"); |
| | | int colPOPrice = getItemCol(dw_cell, startRow - 1, L"价格"); |
| | | int colPOPrice1 = getItemCol(dw_cell, startRow - 1, L"价格1"); |
| | | int colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | |
| | | int LastRow = dw_cell.GetValidRow(); |
| | | xstring content = L""; |
| | |
| | | itemStr += L"<ProductInfo>" + dw_cell.GetItemString(row, colProductInfo) + L"</ProductInfo>"; |
| | | itemStr += L"<ProductInfo1>" + dw_cell.GetItemString(row, colProductInfo1) + L"</ProductInfo1>"; |
| | | |
| | | if (dw_cell.GetItemString(row, colBuyerPrice) == L"") return L"采购价格没有录入"; |
| | | if (dw_cell.GetItemString(row, colGWT) == L"") return L"毛重没有录入"; |
| | | if (dw_cell.GetItemString(row, colNWT) == L"") return L"净重没有录入"; |
| | | if (dw_cell.GetItemString(row, colVolDesc) == L"") return L"长X宽X高没有录入"; |
| | | if (dw_cell.GetItemString(row, colFactoryImage) == L"") return L"图片没有录入"; |
| | | if (dw_cell.GetItemString(row, colBuyerPrice) == L"") return L"采购价格没有录入"; |
| | | if (dw_cell.GetItemString(row, colGWT) == L"") return L"毛重没有录入"; |
| | | if (dw_cell.GetItemString(row, colNWT) == L"") return L"净重没有录入"; |
| | | if (dw_cell.GetItemString(row, colVolDesc) == L"") return L"长X宽X高没有录入"; |
| | | if (dw_cell.GetItemString(row, colFactoryImage) == L"") return L"图片没有录入"; |
| | | |
| | | if (dw_cell.GetItemString(row, colSupplier) == L"")return L"供应商没有录入"; |
| | | if (dw_cell.GetItemString(row, colPOPrice) == L"")return L"采购价格没有录入"; |
| | | if (dw_cell.GetItemString(row, colSupplier) == L"")return L"供应商没有录入"; |
| | | if (dw_cell.GetItemString(row, colPOPrice) == L"")return L"采购价格没有录入"; |
| | | |
| | | if (dw_cell.GetItemString(row, colPOPrice1) != L"") |
| | | { |
| | | if (dw_cell.GetItemString(row, colSupplier1) == L"") return L"供应商1没有录入"; |
| | | if (dw_cell.GetItemString(row, colSupplier1) == L"") return L"供应商1没有录入"; |
| | | } |
| | | if (dw_cell.GetItemString(row, colSupplier1) != L"") |
| | | { |
| | | if (dw_cell.GetItemString(row, colPOPrice1) == L"") return L"采购价格1没有录入"; |
| | | if (dw_cell.GetItemString(row, colPOPrice1) == L"") return L"采购价格1没有录入"; |
| | | } |
| | | itemStr += L"<BuyerRemark>" + dw_cell.GetItemString(row, colBuyerRemark) + L"</BuyerRemark>"; |
| | | itemStr += L"<FactoryImage>" + dw_cell.GetItemString(row, colFactoryImage) + L"</FactoryImage>"; |
| | |
| | | arg.AddArg(L"FlowID",L"DCC32D5B-9FCD-4F53-B7CF-630441DE2B47"); |
| | | arg.AddArg(L"EntityID",fileid); |
| | | //arg.AddArg(L"EntityID",L"DCC32D5B-9FCD-4F53-B7CF-630441DE2B47"); |
| | | arg.AddArg(L"EntityNo",L"测试"); |
| | | arg.AddArg(L"Subject",L"---测试数据----:询以下产品价格"); |
| | | arg.AddArg(L"EntityNo",L"测试"); |
| | | arg.AddArg(L"Subject",L"---测试数据----:询以下产品价格"); |
| | | arg.AddArg(L"Content",content); |
| | | arg.AddArg(L"Status",L"采购询价"); |
| | | arg.AddArg(L"Status",L"采购询价"); |
| | | arg.AddArg(L"Category",L"QuoteEnquiry"); |
| | | arg.AddArg(L"Reciever",empno+L"|admin|00601"); |
| | | |
| | | xstring path=L"/sale/data/Thing/task/add/content1"; |
| | | if (xurl::get(path,arg.GetString(),x) != 1) |
| | | { |
| | | alert(L"发送出错了!"); |
| | | alert(L"发送出错了!"); |
| | | return -1; |
| | | }else |
| | | { |
| | | if(x.xml().find(L"error")>=0) |
| | | { |
| | | alert(L"发送出错了!"+x.xml()); |
| | | alert(L"发送出错了!"+x.xml()); |
| | | return -1; |
| | | } |
| | | trace(x.xml()); |
| | | } |
| | | trace(L"\r\n"+L"询价单已发送给"+purchor); |
| | | trace(L"\r\n"+L"询价单已发送给"+purchor); |
| | | |
| | | return 1; |
| | | */ |
| | |
| | | if (startRow < 1) return L"<data/>"; |
| | | startRow++; |
| | | |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell, startRow - 1, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = 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 colItemCName = 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 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)L"); |
| | | int colNW = getItemCol(dw_cell, startRow - 1, L"净重(KG)L"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"长X宽X高(CM)L"); |
| | | |
| | | int colPrice = getItemCol(dw_cell, startRow - 1, L"采购价"); |
| | | int colPrice = getItemCol(dw_cell, startRow - 1, L"采购价"); |
| | | |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商"); |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1"); |
| | | int colPOPrice = getItemCol(dw_cell, startRow - 1, L"价格"); |
| | | int colPOPrice1 = getItemCol(dw_cell, startRow - 1, L"价格1"); |
| | | int colBOMType = getItemCol(dw_cell, startRow - 1, L"类型"); |
| | | int colBOMType1 = getItemCol(dw_cell, startRow - 1, L"类型1"); |
| | | int colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商"); |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1"); |
| | | int colPOPrice = getItemCol(dw_cell, startRow - 1, L"价格"); |
| | | int colPOPrice1 = getItemCol(dw_cell, startRow - 1, L"价格1"); |
| | | int colBOMType = getItemCol(dw_cell, startRow - 1, L"类型"); |
| | | int colBOMType1 = getItemCol(dw_cell, startRow - 1, L"类型1"); |
| | | int colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | |
| | | xstring items = L"<data>"; |
| | | int LastRow = dw_cell.GetValidRow(); |
| | |
| | | if (startRow < 1) return L"<data/>"; |
| | | startRow++; |
| | | |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell, startRow - 1, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = 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 colItemCName = 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 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)L"); |
| | | int colNW = getItemCol(dw_cell, startRow - 1, L"净重(KG)L"); |
| | | int colVolDesc = getItemCol(dw_cell, startRow - 1, L"长X宽X高(CM)L"); |
| | | |
| | | int colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | int colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | |
| | | xstring items = L"<data>"; |
| | | int LastRow = dw_cell.GetValidRow(); |
| | |
| | | if(startRow < 1) return L"<data/>"; |
| | | startRow++; |
| | | |
| | | int colItemNo = getItemCol(dw_cell,startRow - 1,L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell,startRow - 1,L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemNo = getItemCol(dw_cell,startRow - 1,L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell,startRow - 1,L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell,startRow - 1,L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = 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 colItemCName = 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 colBuyer = getItemCol(dw_cell,startRow - 1,L"采购人员"); |
| | | int colBuyer = getItemCol(dw_cell,startRow - 1,L"采购人员"); |
| | | |
| | | xstring items=L"<data>"; |
| | | int LastRow = dw_cell.GetValidRow(); |
| | |
| | | |
| | | if (row >= rowCount) |
| | | { |
| | | alert(L"找不到商品行!"); |
| | | alert(L"找不到商品行!"); |
| | | return 1; |
| | | } |
| | | |
| | | headrow = row; |
| | | int startRow = headrow + 1; |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell, startRow - 1, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | int colPurchor = getItemCol(dw_cell, startRow - 1, L"采购员,采购人员"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | int colPurchor = getItemCol(dw_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 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 colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1"); |
| | | int colPOPrice1 = getItemCol(dw_cell, startRow - 1, L"价格1"); |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商"); |
| | | int colPOPrice = getItemCol(dw_cell, startRow - 1, L"价格"); |
| | | int colSupplier2 = getItemCol(dw_cell, startRow - 1, L"供应商2"); |
| | | int colPOPrice2 = getItemCol(dw_cell, startRow - 1, L"价格2"); |
| | | int colSupplier3 = getItemCol(dw_cell, startRow - 1, L"供应商3"); |
| | | int colPOPrice3 = getItemCol(dw_cell, startRow - 1, L"价格3"); |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1"); |
| | | int colPOPrice1 = getItemCol(dw_cell, startRow - 1, L"价格1"); |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商"); |
| | | int colPOPrice = getItemCol(dw_cell, startRow - 1, L"价格"); |
| | | int colSupplier2 = getItemCol(dw_cell, startRow - 1, L"供应商2"); |
| | | int colPOPrice2 = getItemCol(dw_cell, startRow - 1, L"价格2"); |
| | | int colSupplier3 = getItemCol(dw_cell, startRow - 1, L"供应商3"); |
| | | int colPOPrice3 = getItemCol(dw_cell, startRow - 1, L"价格3"); |
| | | |
| | | int colSalebackDate = getItemCol(dw_cell, startRow - 1, L"采购提交业务时间"); |
| | | int colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | int colSalebackDate = getItemCol(dw_cell, startRow - 1, L"采购提交业务时间"); |
| | | int colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | |
| | | int LastRow = dw_cell.GetValidRow(); |
| | | int count = 0; |
| | |
| | | /* |
| | | if(dw_cell.GetItemString(row, colBuyerPrice)==L"") |
| | | { |
| | | alert(L"采购价格没有录入"); |
| | | alert(L"采购价格没有录入"); |
| | | return 1; |
| | | } |
| | | if(dw_cell.GetItemString(row, colGWT)==L"") |
| | | { |
| | | alert(L"毛重没有录入"); |
| | | alert(L"毛重没有录入"); |
| | | return 1; |
| | | } |
| | | if(dw_cell.GetItemString(row, colNWT)==L"") |
| | | { |
| | | alert(L"净重没有录入"); |
| | | alert(L"净重没有录入"); |
| | | return 1; |
| | | } |
| | | if(dw_cell.GetItemString(row, colVolDesc)==L"") |
| | | { |
| | | alert(L"长X宽X高没有录入"); |
| | | alert(L"长X宽X高没有录入"); |
| | | return 1; |
| | | } |
| | | if(dw_cell.GetItemString(row, colFactoryImage)==L"") |
| | | { |
| | | alert(L"工厂图片没有录入"); |
| | | alert(L"工厂图片没有录入"); |
| | | return 1; |
| | | } |
| | | if(dw_cell.GetItemString(row, colSupplier)==L"") |
| | | { |
| | | alert(L"供应商没有录入"); |
| | | alert(L"供应商没有录入"); |
| | | return 1; |
| | | } |
| | | if(dw_cell.GetItemString(row, colPOPrice)==L"") |
| | | { |
| | | alert(L"采购价格没有录入"); |
| | | alert(L"采购价格没有录入"); |
| | | return 1; |
| | | }*/ |
| | | |
| | |
| | | { |
| | | if(dw_cell.GetItemString(row, colSupplier1)==L"") |
| | | { |
| | | alert(L"供应商1没有录入"); |
| | | alert(L"供应商1没有录入"); |
| | | return 1; |
| | | } |
| | | } |
| | |
| | | { |
| | | if(dw_cell.GetItemString(row, colPOPrice1)==L"") |
| | | { |
| | | alert(L"采购价格1没有录入"); |
| | | alert(L"采购价格1没有录入"); |
| | | return 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"采购To业务备注") purchremarkcol = col; |
| | | if (head == L"采购人员") purchercol = col; |
| | | if (head == L"采购To业务备注") purchremarkcol = col; |
| | | if (head == L"采购人员") purchercol = col; |
| | | } |
| | | |
| | | xstring items = GetPurchedItems(); |
| | |
| | | |
| | | if (dw_cell.GetItemString(row, colBuyerPrice) == L"") |
| | | { |
| | | alert(L"采购价格没有录入"); |
| | | alert(L"采购价格没有录入"); |
| | | return 1; |
| | | } |
| | | if (dw_cell.GetItemString(row, colGWT) == L"") |
| | | { |
| | | alert(L"毛重没有录入"); |
| | | alert(L"毛重没有录入"); |
| | | return 1; |
| | | } |
| | | if (dw_cell.GetItemString(row, colNWT) == L"") |
| | | { |
| | | alert(L"净重没有录入"); |
| | | alert(L"净重没有录入"); |
| | | return 1; |
| | | } |
| | | if (dw_cell.GetItemString(row, colVolDesc) == L"") |
| | | { |
| | | alert(L"长X宽X高没有录入"); |
| | | alert(L"长X宽X高没有录入"); |
| | | return 1; |
| | | } |
| | | if (dw_cell.GetItemString(row, colFactoryImage) == L"") |
| | | { |
| | | alert(L"工厂图片没有录入"); |
| | | alert(L"工厂图片没有录入"); |
| | | return 1; |
| | | } |
| | | if (dw_cell.GetItemString(row, colSupplier) == L"") |
| | | { |
| | | alert(L"供应商没有录入"); |
| | | alert(L"供应商没有录入"); |
| | | return 1; |
| | | } |
| | | if (dw_cell.GetItemString(row, colPOPrice) == L"") |
| | | { |
| | | alert(L"采购价格没有录入"); |
| | | alert(L"采购价格没有录入"); |
| | | return 1; |
| | | } |
| | | |
| | |
| | | itemStr += L"<Buyer>" + dw_cell.GetItemString(row, colPurchor) + L"</Buyer>"; |
| | | |
| | | /* |
| | | if(dw_cell.GetItemString(row, colBuyerPrice)==L"") return L"采购价格没有录入"; |
| | | if(dw_cell.GetItemString(row, colGWT)==L"") return L"毛重没有录入"; |
| | | if(dw_cell.GetItemString(row, colNWT)==L"") return L"净重没有录入"; |
| | | if(dw_cell.GetItemString(row, colVolDesc)==L"") return L"长X宽X高没有录入"; |
| | | if(dw_cell.GetItemString(row, colFactoryImage)==L"") return L"图片没有录入"; |
| | | if(dw_cell.GetItemString(row, colBuyerPrice)==L"") return L"采购价格没有录入"; |
| | | if(dw_cell.GetItemString(row, colGWT)==L"") return L"毛重没有录入"; |
| | | if(dw_cell.GetItemString(row, colNWT)==L"") return L"净重没有录入"; |
| | | if(dw_cell.GetItemString(row, colVolDesc)==L"") return L"长X宽X高没有录入"; |
| | | if(dw_cell.GetItemString(row, colFactoryImage)==L"") return L"图片没有录入"; |
| | | |
| | | if(dw_cell.GetItemString(row, colSupplier)==L"") return L"供应商没有录入"; |
| | | if(dw_cell.GetItemString(row, colPOPrice)==L"") return L"采购价格没有录入"; |
| | | if(dw_cell.GetItemString(row, colSupplier)==L"") return L"供应商没有录入"; |
| | | if(dw_cell.GetItemString(row, colPOPrice)==L"") return L"采购价格没有录入"; |
| | | |
| | | if(dw_cell.GetItemString(row, colPOPrice1)!=L"") |
| | | { |
| | | if(dw_cell.GetItemString(row, colSupplier1)==L"") return L"供应商1没有录入"; |
| | | if(dw_cell.GetItemString(row, colSupplier1)==L"") return L"供应商1没有录入"; |
| | | } |
| | | if(dw_cell.GetItemString(row, colSupplier1)!=L"") |
| | | { |
| | | if(dw_cell.GetItemString(row, colPOPrice1)==L"") return L"采购价格1没有录入"; |
| | | if(dw_cell.GetItemString(row, colPOPrice1)==L"") return L"采购价格1没有录入"; |
| | | } |
| | | if(dw_cell.GetItemString(row, colGWT)!=L"") |
| | | { |
| | | if(dw_cell.GetItemString(row, colGWT)==L"") return L"毛重没有录入"; |
| | | if(dw_cell.GetItemString(row, colGWT)==L"") return L"毛重没有录入"; |
| | | } |
| | | if(dw_cell.GetItemString(row, colNWT)!=L"") |
| | | { |
| | | if(dw_cell.GetItemString(row, colNWT)==L"") return L"净重没有录入"; |
| | | if(dw_cell.GetItemString(row, colNWT)==L"") return L"净重没有录入"; |
| | | } |
| | | if(dw_cell.GetItemString(row, colVolDesc)!=L"") |
| | | { |
| | | if(dw_cell.GetItemString(row, colVolDesc)==L"") return L"体积信息没有录入"; |
| | | if(dw_cell.GetItemString(row, colVolDesc)==L"") return L"体积信息没有录入"; |
| | | } |
| | | */ |
| | | itemStr += L"<BuyerRemark>" + dw_cell.GetItemString(row, colBuyerRemark) + L"</BuyerRemark>"; |
| | |
| | | |
| | | if (row >= rowCount) |
| | | { |
| | | alert(L"找不到商品行!"); |
| | | alert(L"找不到商品行!"); |
| | | return 1; |
| | | } |
| | | |
| | | headrow = row; |
| | | int startRow = headrow + 1; |
| | | int colCustomerItemNo = getItemCol(dw_cell, headrow, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, headrow, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell, headrow, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = getItemCol(dw_cell, headrow, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, headrow, L"Specifications,规格,产品规格"); |
| | | int colItemQty = getItemCol(dw_cell, headrow, L"数量,Qty"); |
| | | //int colItemSpec = getItemCol(dw_cell,headrow,L"Specifications,规格,产品规格"); |
| | | int colItemPurchDate = getItemCol(dw_cell, headrow, L"业务发送采购时间"); |
| | | int colItemCName = getItemCol(dw_cell, headrow, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, headrow, L"Specifications,规格,产品规格"); |
| | | 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 colInnerOuter = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)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"采购To业务备注") purchremarkcol = col; |
| | | if (head == L"采购人员") purchercol = col; |
| | | if (head == L"采购To业务备注") purchremarkcol = col; |
| | | if (head == L"采购人员") purchercol = col; |
| | | } |
| | | |
| | | if (purchercol == 0) |
| | | { |
| | | alert(L"找不到采购人员数据!"); |
| | | alert(L"找不到采购人员数据!"); |
| | | return 1; |
| | | } |
| | | |
| | |
| | | |
| | | if (row >= rowCount) |
| | | { |
| | | alert(L"找不到商品行!"); |
| | | alert(L"找不到商品行!"); |
| | | return 1; |
| | | } |
| | | |
| | | headrow = row; |
| | | int startRow = headrow + 1; |
| | | int colCustomerItemNo = getItemCol(dw_cell, headrow, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, headrow, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell, headrow, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = getItemCol(dw_cell, headrow, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, headrow, L"Specifications,规格,产品规格"); |
| | | int colItemQty = getItemCol(dw_cell, headrow, L"数量,Qty"); |
| | | //int colItemSpec = getItemCol(dw_cell,headrow,L"Specifications,规格,产品规格"); |
| | | int colItemPurchDate = getItemCol(dw_cell, headrow, L"业务发送采购时间"); |
| | | int colItemCName = getItemCol(dw_cell, headrow, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, headrow, L"Specifications,规格,产品规格"); |
| | | 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 colSalebackDate = getItemCol(dw_cell, startRow - 1, L"采购提交业务时间"); |
| | | int colInnerOuter = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)L"); |
| | | int colSalebackDate = 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"采购To业务备注") purchremarkcol = col; |
| | | if (head == L"采购人员") purchercol = col; |
| | | if (head == L"采购To业务备注") purchremarkcol = col; |
| | | if (head == L"采购人员") purchercol = col; |
| | | } |
| | | if (purchercol == 0) |
| | | { |
| | | alert(L"找不到采购人员数据!"); |
| | | alert(L"找不到采购人员数据!"); |
| | | return 1; |
| | | } |
| | | |
| | |
| | | row++; |
| | | |
| | | int colCustomerPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo"); |
| | | int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式"); |
| | | int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式"); |
| | | |
| | | while (row <= rowCount) |
| | | { |
| | |
| | | } |
| | | else |
| | | { |
| | | alert(L"没有采购员:" + str); |
| | | alert(L"没有采购员:" + str); |
| | | return 1; |
| | | } |
| | | } |
| | |
| | | } |
| | | if (strs == L",L") |
| | | { |
| | | alert(L"请指定采购人员!"); |
| | | alert(L"请指定采购人员!"); |
| | | return 1; |
| | | } |
| | | |
| | |
| | | } |
| | | else |
| | | { |
| | | alert(L"没有采购员:" + str); |
| | | alert(L"没有采购员:" + str); |
| | | return 1; |
| | | } |
| | | } |
| | |
| | | } |
| | | else |
| | | { |
| | | alert(L"出现错误"); |
| | | alert(L"出现错误"); |
| | | return 1; |
| | | } |
| | | |
| | |
| | | |
| | | headrow1 = row2; |
| | | startrow1 = headrow1 + 1; |
| | | purchercol1 = getItemCol(cell1, headrow1, L"采购人员"); |
| | | purchercol1 = getItemCol(cell1, headrow1, L"采购人员"); |
| | | } |
| | | |
| | | |
| | |
| | | } |
| | | |
| | | //OnSaveEx(true); |
| | | //alert(L"询价信息已发送给:"+purchors); |
| | | //alert(L"询价信息已发送给:"+purchors); |
| | | return 1; |
| | | } |
| | | |
| | |
| | | |
| | | if (dw_base.GetItemString(1, L"CustomerID") == L"") |
| | | { |
| | | alert(L"请输入报价的客户!"); |
| | | alert(L"请输入报价的客户!"); |
| | | return 1; |
| | | } |
| | | |
| | | if (row >= rowCount) |
| | | { |
| | | alert(L"找不到商品行!"); |
| | | alert(L"找不到商品行!"); |
| | | return 1; |
| | | } |
| | | |
| | | if (getBaseItem(dw_cell, L"报价截止日期:") == L"") |
| | | if (getBaseItem(dw_cell, L"报价截止日期:") == L"") |
| | | { |
| | | if (getBaseItem(dw_cell, L"报价截止日期:") == L"") |
| | | if (getBaseItem(dw_cell, L"报价截止日期:") == L"") |
| | | { |
| | | alert(L"报价截止日期未输入!"); |
| | | alert(L"报价截止日期未输入!"); |
| | | return 1; |
| | | } |
| | | } |
| | | |
| | | if (getBaseItem(dw_cell, L"项目名称:") == L"") |
| | | if (getBaseItem(dw_cell, L"项目名称:") == L"") |
| | | { |
| | | if (getBaseItem(dw_cell, L"项目名称:") == L"") |
| | | if (getBaseItem(dw_cell, L"项目名称:") == L"") |
| | | { |
| | | alert(L"项目名称未输入!"); |
| | | alert(L"项目名称未输入!"); |
| | | return 1; |
| | | } |
| | | } |
| | | |
| | | headrow = row; |
| | | int startRow = headrow + 1; |
| | | int colCustomerItemNo = getItemCol(dw_cell, headrow, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, headrow, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell, headrow, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = getItemCol(dw_cell, headrow, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, headrow, L"Specifications,规格,产品规格"); |
| | | int colItemQty = getItemCol(dw_cell, headrow, L"数量,Qty"); |
| | | //int colItemSpec = getItemCol(dw_cell,headrow,L"Specifications,规格,产品规格"); |
| | | int colItemPurchDate = getItemCol(dw_cell, headrow, L"业务发送采购时间"); |
| | | int colItemCName = getItemCol(dw_cell, headrow, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, headrow, L"Specifications,规格,产品规格"); |
| | | 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 colInnerOuter = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)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"采购To业务备注") purchremarkcol = col; |
| | | if (head == L"采购人员") purchercol = col; |
| | | if (head == L"采购To业务备注") purchremarkcol = col; |
| | | if (head == L"采购人员") purchercol = col; |
| | | } |
| | | if (purchercol == 0) |
| | | { |
| | | alert(L"找不到采购人员数据!"); |
| | | alert(L"找不到采购人员数据!"); |
| | | return 1; |
| | | } |
| | | |
| | |
| | | row++; |
| | | |
| | | int colCustomerPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo"); |
| | | int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式"); |
| | | int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式"); |
| | | |
| | | while (row <= rowCount) |
| | | { |
| | |
| | | |
| | | /*if(dw_cell.GetItemString(row,colCustomerItemNo)==L"") |
| | | { |
| | | alert(L"第"+xstring(row)+L"行请输入客户型号!"); |
| | | alert(L"第"+xstring(row)+L"行请输入客户型号!"); |
| | | return 1; |
| | | }*/ |
| | | if (dw_cell.GetItemString(row, colItemName) == L"" || dw_cell.GetItemString(row, colItemCName) == L"") |
| | | { |
| | | alert(L"第" + xstring(row) + L"行请输入产品名称!"); |
| | | alert(L"第" + xstring(row) + L"行请输入产品名称!"); |
| | | return 1; |
| | | } |
| | | if (dw_cell.GetItemString(row, colPackage) == L"") |
| | | { |
| | | alert(L"第" + xstring(row) + L"行请输入产品包装方式!"); |
| | | alert(L"第" + xstring(row) + L"行请输入产品包装方式!"); |
| | | return 1; |
| | | } |
| | | if (dw_cell.GetItemString(row, colCustomerPhoto) == L"") |
| | | { |
| | | alert(L"第" + xstring(row) + L"行请选择客户图片!"); |
| | | alert(L"第" + xstring(row) + L"行请选择客户图片!"); |
| | | return 1; |
| | | } |
| | | if (dw_cell.GetItemString(row, colInnerOuter) == L"") |
| | | { |
| | | alert(L"第" + xstring(row) + L"行请录入内外箱装数!"); |
| | | alert(L"第" + xstring(row) + L"行请录入内外箱装数!"); |
| | | return 1; |
| | | } |
| | | /*if(dw_cell.GetItemString(row,col40HQ)==L"") |
| | | { |
| | | alert(L"第"+xstring(row)+L"行40HQ的数据是空的!"); |
| | | alert(L"第"+xstring(row)+L"行40HQ的数据是空的!"); |
| | | return 1; |
| | | }*/ |
| | | |
| | | /*if(dw_cell.GetItemString(row,colItemQty)==L"") |
| | | { |
| | | alert(L"第"+xstring(row)+L"行数量是空的!"); |
| | | alert(L"第"+xstring(row)+L"行数量是空的!"); |
| | | return 1; |
| | | }*/ |
| | | |
| | |
| | | } |
| | | else |
| | | { |
| | | alert(L"没有采购员:" + str); |
| | | alert(L"没有采购员:" + str); |
| | | return 1; |
| | | } |
| | | } |
| | |
| | | } |
| | | if (strs == L",L") |
| | | { |
| | | alert(L"找不到采购人员数据!"); |
| | | alert(L"找不到采购人员数据!"); |
| | | return 1; |
| | | } |
| | | |
| | |
| | | cell1.SetRowColumn(1, purchercol); |
| | | cell1.SetAnchorRowColumn(1, purchercol); |
| | | SendCtrlCmd(cell1, L"xmFormatCellInsertCol"); |
| | | cell1.SetItemString(headrow, purchercol, L"业务员"); |
| | | cell1.SetItemString(headrow, purchercol, L"业务员"); |
| | | |
| | | cell1.SetRowColumn(1, pricecol); |
| | | cell1.SetAnchorRowColumn(1, pricecol); |
| | |
| | | SendCtrlCmd(cell1, L"xmFormatCellInsertCol"); |
| | | SendCtrlCmd(cell1, L"xmFormatCellInsertCol"); |
| | | |
| | | cell1.SetItemString(headrow, purchremarkcol + 1, L"供应商"); |
| | | cell1.SetItemString(headrow, purchremarkcol + 2, L"类型"); |
| | | cell1.SetItemString(headrow, purchremarkcol + 3, L"价格"); |
| | | cell1.SetItemString(headrow, purchremarkcol + 4, L"供应商1"); |
| | | cell1.SetItemString(headrow, purchremarkcol + 5, L"类型1"); |
| | | cell1.SetItemString(headrow, purchremarkcol + 6, L"价格1"); |
| | | cell1.SetItemString(headrow, purchremarkcol + 1, L"供应商"); |
| | | cell1.SetItemString(headrow, purchremarkcol + 2, L"类型"); |
| | | cell1.SetItemString(headrow, purchremarkcol + 3, L"价格"); |
| | | cell1.SetItemString(headrow, purchremarkcol + 4, L"供应商1"); |
| | | cell1.SetItemString(headrow, purchremarkcol + 5, L"类型1"); |
| | | cell1.SetItemString(headrow, purchremarkcol + 6, L"价格1"); |
| | | |
| | | int colRemark = getItemCol(cell1, headrow, L"Remarks"); |
| | | cell1.SetRowColumn(1, colRemark); |
| | |
| | | } |
| | | OnUpdate(); |
| | | //OnSaveEx(true); |
| | | //alert(L"询价信息已发送给:"+purchors); |
| | | //alert(L"询价信息已发送给:"+purchors); |
| | | |
| | | return 1; |
| | | } |
| | | |
| | | //焦点激活处理函数 |
| | | //焦点激活处理函数 |
| | | int OnSetFocus(TEvent* evt, LPARAM param) |
| | | { |
| | | //重置工具条 |
| | | //重置工具条 |
| | | SetAgent(); |
| | | return 1; |
| | | } |
| | |
| | | if (ret == -1) return L""; |
| | | if (ret == 0) |
| | | { |
| | | alert(L"图片上传失败!"); |
| | | alert(L"图片上传失败!"); |
| | | return L""; |
| | | } |
| | | return GetImageUrl(guid); |
| | |
| | | ret = xaserver::DownLoadFile(GetServerUrl(),L"/business/products/chanpin/"+str+L"/"+name,name,appPath+L"/"+name); |
| | | if(ret < 0) |
| | | { |
| | | alert(L"图片下载失败1!"); |
| | | alert(L"图片下载失败1!"); |
| | | return L""; |
| | | } |
| | | |
| | |
| | | //xaserver::DeleteFile(appPath+name); |
| | | if(ret_1 != 1) |
| | | { |
| | | alert(L"上传缩略图失败!"); |
| | | alert(L"上传缩略图失败!"); |
| | | return L""; |
| | | } |
| | | return appPath+L"/"+name; |
| | |
| | | if (ret == -1) return L""; |
| | | if (ret == 0) |
| | | { |
| | | alert(L"图片上传失败!"); |
| | | alert(L"图片上传失败!"); |
| | | return L""; |
| | | } |
| | | |
| | |
| | | ret = xaserver::DownLoadFile(GetServerUrl(), L"/business/products/chanpin/" + str + L"/" + name, name, appPath + L"/" + name); |
| | | if (ret < 0) |
| | | { |
| | | alert(L"图片下载失败1!"); |
| | | alert(L"图片下载失败1!"); |
| | | return L""; |
| | | } |
| | | |
| | |
| | | //xaserver::DeleteFile(appPath+name); |
| | | if (ret_1 != 1) |
| | | { |
| | | alert(L"上传缩略图失败!"); |
| | | alert(L"上传缩略图失败!"); |
| | | return L""; |
| | | } |
| | | return appPath + L"/" + name; |
| | |
| | | str += tm + L":" + guid + L";"; |
| | | } |
| | | |
| | | xstring goodno = L"客户图片"; |
| | | if (tm == L"supplier-photo") goodno = L"供应商图片"; |
| | | xstring goodno = L"客户图片"; |
| | | if (tm == L"supplier-photo") goodno = L"供应商图片"; |
| | | xstring picname = path; |
| | | if (picname == L"") picname = L"/business/products/chanpin/" + guid.left(2) + L"/" + guid + L".jpg"; |
| | | im.AddImages(picname, goodno); |
| | |
| | | int row = dw_cell.GetRow(); |
| | | int startRow = getItemHeadRow(dw_cell); |
| | | |
| | | //没有找到商品行的标题 |
| | | //没有找到商品行的标题 |
| | | if (startRow < 1) return 0; |
| | | startRow++; |
| | | int colPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo"); |
| | | int colPhoto1 = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int colPhoto1 = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | if (row < startRow) return 0; |
| | | |
| | | xstring str = dw_cell.GetItemString(row, 0); |
| | |
| | | int row = dw_cell.GetRow(); |
| | | int startRow = getItemHeadRow(dw_cell); |
| | | |
| | | //没有找到商品行的标题 |
| | | //没有找到商品行的标题 |
| | | if (startRow < 1) return 0; |
| | | startRow++; |
| | | int colPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo"); |
| | | int colPhoto1 = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int colPhoto1 = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int LastRow = dw_cell.GetValidRow(); |
| | | if (row < startRow) return 0; |
| | | |
| | |
| | | int GetOpenFileNames(xarray<xstring>& items, xstring initFileName, xstring filter, xstring ext) |
| | | { |
| | | //xstring path = GetOpenFileName(L"", |
| | | // "JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0", |
| | | // "JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0", |
| | | // "jpg"); |
| | | |
| | | wchar_t szFileName[4096]; |
| | |
| | | ofn.hwndOwner = 0; |
| | | ofn.hInstance = 0; |
| | | ofn.lpstrFilter = filter; |
| | | //"JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0"; |
| | | //"JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0"; |
| | | ofn.lpstrCustomFilter = 0; |
| | | ofn.nMaxCustFilter = 0; |
| | | ofn.nFilterIndex = nFilterIndex; |
| | |
| | | ofn.nMaxFile = 4096; |
| | | ofn.lpstrFileTitle = szFileName; |
| | | ofn.nMaxFileTitle = 4096; |
| | | ofn.lpstrTitle = L"请指定文件名"; |
| | | ofn.lpstrTitle = L"请指定文件名"; |
| | | ofn.lpstrDefExt = ext; |
| | | //"jpg"; |
| | | ofn.lpstrInitialDir = 0; |
| | |
| | | int row = dw_cell.GetRow(); |
| | | int startRow = getItemHeadRow(dw_cell); |
| | | |
| | | //没有找到商品行的标题 |
| | | //没有找到商品行的标题 |
| | | if (startRow < 1) return 0; |
| | | startRow++; |
| | | int colPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo"); |
| | | int colPhoto1 = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int colPhoto1 = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int LastRow = dw_cell.GetValidRow(); |
| | | if (row < startRow) return 0; |
| | | |
| | | xstring appPath = xutil::GetModuleTmpPath(); |
| | | xarray<xstring> items; |
| | | GetOpenFileNames(items, L"", |
| | | L"JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0", |
| | | L"JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0", |
| | | L"jpg"); |
| | | if (items.length() < 1) return 1; |
| | | |
| | |
| | | int row = dw_cell.GetRow(); |
| | | int startRow = getItemHeadRow(dw_cell); |
| | | |
| | | //没有找到商品行的标题 |
| | | //没有找到商品行的标题 |
| | | if (startRow < 1) return 0; |
| | | startRow++; |
| | | int colPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo"); |
| | | int colPhoto1 = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int colPhoto1 = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | int LastRow = dw_cell.GetValidRow(); |
| | | if (row < startRow) return 0; |
| | | |
| | |
| | | xstring appPath = xutil::GetModuleTmpPath(); |
| | | xarray<xstring> items; |
| | | GetOpenFileNames(items, L"", |
| | | L"JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0", |
| | | L"JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0", |
| | | L"jpg"); |
| | | if (items.length() < 1) return 1; |
| | | |
| | |
| | | if (row < startRow + 1) return 1; |
| | | startRow++; |
| | | |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell, startRow - 1, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | int colBuyer = getItemCol(dw_cell, startRow - 1, L"采购人员"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | int colBuyer = getItemCol(dw_cell, startRow - 1, L"采购人员"); |
| | | int colCustomerPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo"); |
| | | int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式"); |
| | | int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式"); |
| | | int colFOBPrice = getItemCol(dw_cell, startRow - 1, L"FOB Price,FOB Price(USD),Fob Price"); |
| | | int colQty = getItemCol(dw_cell, startRow - 1, L"Qty,数量"); |
| | | //int colToPODate = getItemCol(dw_cell,startRow - 1,L"业务发送采购时间"); |
| | | int colQty = getItemCol(dw_cell, startRow - 1, L"Qty,数量"); |
| | | //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 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 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 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 colSKUNo = getItemCol(dw_cell, startRow - 1, L"SKUID,SKUNo"); |
| | | |
| | | if (col == colFOBPrice) |
| | |
| | | |
| | | if (col == colVolDesc || col == colQtyPerPack) |
| | | { |
| | | /*计算体积*/ |
| | | /*计算体积*/ |
| | | double v = 0.0; |
| | | xstring desc = dw_cell.GetItemString(row, colVolDesc); |
| | | if (desc.find(L"cm") >= 0) |
| | |
| | | |
| | | if (action == L"purch") |
| | | { |
| | | int colPrice0 = getItemCol(dw_cell, startRow - 1, L"价格"); |
| | | int colPrice1 = getItemCol(dw_cell, startRow - 1, L"价格1"); |
| | | int colPrice2 = getItemCol(dw_cell, startRow - 1, L"价格2"); |
| | | int colPrice3 = getItemCol(dw_cell, startRow - 1, L"价格3"); |
| | | int colPrice = getItemCol(dw_cell, startRow - 1, L"采购价"); |
| | | int colPrice0 = getItemCol(dw_cell, startRow - 1, L"价格"); |
| | | int colPrice1 = getItemCol(dw_cell, startRow - 1, L"价格1"); |
| | | int colPrice2 = getItemCol(dw_cell, startRow - 1, L"价格2"); |
| | | int colPrice3 = getItemCol(dw_cell, startRow - 1, L"价格3"); |
| | | int colPrice = getItemCol(dw_cell, startRow - 1, L"采购价"); |
| | | |
| | | int colTyp = getItemCol(dw_cell, startRow - 1, L"类型"); |
| | | int colTyp1 = getItemCol(dw_cell, startRow - 1, L"类型1"); |
| | | int colTyp2 = getItemCol(dw_cell, startRow - 1, L"类型2"); |
| | | int colTyp3 = getItemCol(dw_cell, startRow - 1, L"类型3"); |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商,工厂"); |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1,工厂1"); |
| | | int colSupplier2 = getItemCol(dw_cell, startRow - 1, L"供应商2,工厂2"); |
| | | int colSupplier3 = getItemCol(dw_cell, startRow - 1, L"供应商3,工厂3"); |
| | | int colTyp = getItemCol(dw_cell, startRow - 1, L"类型"); |
| | | int colTyp1 = getItemCol(dw_cell, startRow - 1, L"类型1"); |
| | | int colTyp2 = getItemCol(dw_cell, startRow - 1, L"类型2"); |
| | | int colTyp3 = getItemCol(dw_cell, startRow - 1, L"类型3"); |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商,工厂"); |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1,工厂1"); |
| | | int colSupplier2 = getItemCol(dw_cell, startRow - 1, L"供应商2,工厂2"); |
| | | int colSupplier3 = getItemCol(dw_cell, startRow - 1, L"供应商3,工厂3"); |
| | | |
| | | if (colPrice0 == col || colPrice1 == col || colPrice2 == col || colPrice3 == col) |
| | | { |
| | |
| | | price = price0; |
| | | if (price.find(L"A") < 1 && price.find(L"B") < 1 && price.find(L"C") < 1 && price.find(L"a") < 1 && price.find(L"b") < 1 && price.find(L"b") < 1) |
| | | { |
| | | alert(L"价格中没指定ABC"); |
| | | alert(L"价格中没指定ABC"); |
| | | if (pricea == L"") pricea = price; else pricea += L"+L" + price; |
| | | } |
| | | else if (price.find(L"A") > 0 || price.find(L"a") > 0) |
| | |
| | | price = price1; |
| | | if (price.find(L"A") < 1 && price.find(L"B") < 1 && price.find(L"C") < 1 && price.find(L"a") < 1 && price.find(L"b") < 1 && price.find(L"b") < 1) |
| | | { |
| | | alert(L"价格中没指定ABC"); |
| | | alert(L"价格中没指定ABC"); |
| | | if (pricea == L"") pricea = price; else pricea += L"+L" + price; |
| | | } |
| | | else if (price.find(L"A") > 0 || price.find(L"a") > 0) |
| | |
| | | price = price2; |
| | | if (price.find(L"A") < 1 && price.find(L"B") < 1 && price.find(L"C") < 1 && price.find(L"a") < 1 && price.find(L"b") < 1 && price.find(L"b") < 1) |
| | | { |
| | | alert(L"价格中没指定ABC"); |
| | | alert(L"价格中没指定ABC"); |
| | | if (pricea == L"") pricea = price; else pricea += L"+L" + price; |
| | | } |
| | | else if (price.find(L"A") > 0 || price.find(L"a") > 0) |
| | |
| | | price = price3; |
| | | if (price.find(L"A") < 1 && price.find(L"B") < 1 && price.find(L"C") < 1 && price.find(L"a") < 1 && price.find(L"b") < 1 && price.find(L"b") < 1) |
| | | { |
| | | alert(L"价格中没指定ABC"); |
| | | alert(L"价格中没指定ABC"); |
| | | if (pricea == L"") pricea = price; else pricea += L"+L" + price; |
| | | } |
| | | else if (price.find(L"A") > 0 || price.find(L"a") > 0) |
| | |
| | | if (colname == L"Project") |
| | | { |
| | | |
| | | setBaseItem(dw_cell, L"项目名称:", value); |
| | | setBaseItem(dw_cell, L"项目名称:", value); |
| | | } |
| | | return 1; |
| | | } |
| | | |
| | | int OnToQuote() |
| | | { |
| | | xstring project = getBaseItem(dw_cell, L"项目名称:"); |
| | | xstring project = getBaseItem(dw_cell, L"项目名称:"); |
| | | if (project != L"")dw_base.SetItemString(1, L"Project", project); |
| | | |
| | | int startRow = getItemHeadRow(dw_cell); |
| | | |
| | | //没有找到商品行的标题 |
| | | //没有找到商品行的标题 |
| | | if (startRow < 1) return 0; |
| | | startRow++; |
| | | |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell, startRow - 1, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | |
| | | int colTechNote = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colTechNote1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | int colTechNote = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colTechNote1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | |
| | | |
| | | |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | 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 colPurchor = getItemCol(dw_cell, startRow - 1, L"采购员,采购人员"); |
| | | int colQtyPerPack = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)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 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 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 colSKUNo = getItemCol(dw_cell, startRow - 1, L"SKUID,SKUNo"); |
| | | |
| | |
| | | startRow++; |
| | | int row = dw_cell.GetRow(); |
| | | |
| | | int colPurchPrice1 = getItemCol(dw_cell, headrow, L"价格1"); |
| | | int colPurchPrice2 = getItemCol(dw_cell, headrow, L"价格2"); |
| | | int colPurchPrice3 = getItemCol(dw_cell, headrow, L"价格3"); |
| | | int colPurchPrice1 = getItemCol(dw_cell, headrow, L"价格1"); |
| | | int colPurchPrice2 = getItemCol(dw_cell, headrow, L"价格2"); |
| | | int colPurchPrice3 = getItemCol(dw_cell, headrow, L"价格3"); |
| | | if (colPurchPrice3 > 0) return 1; |
| | | |
| | | if (colPurchPrice2 < 1) |
| | |
| | | SendCtrlCmd(dw_cell, L"xmFormatCellInsertCol"); |
| | | SendCtrlCmd(dw_cell, L"xmFormatCellInsertCol"); |
| | | |
| | | dw_cell.SetItemString(headrow, colPurchPrice1 + 1, L"供应商2"); |
| | | dw_cell.SetItemString(headrow, colPurchPrice1 + 2, L"类型2"); |
| | | dw_cell.SetItemString(headrow, colPurchPrice1 + 3, L"价格2"); |
| | | dw_cell.SetItemString(headrow, colPurchPrice1 + 1, L"供应商2"); |
| | | dw_cell.SetItemString(headrow, colPurchPrice1 + 2, L"类型2"); |
| | | dw_cell.SetItemString(headrow, colPurchPrice1 + 3, L"价格2"); |
| | | } |
| | | else |
| | | { |
| | |
| | | SendCtrlCmd(dw_cell, L"xmFormatCellInsertCol"); |
| | | SendCtrlCmd(dw_cell, L"xmFormatCellInsertCol"); |
| | | |
| | | dw_cell.SetItemString(headrow, colPurchPrice2 + 1, L"供应商3"); |
| | | dw_cell.SetItemString(headrow, colPurchPrice2 + 2, L"类型3"); |
| | | dw_cell.SetItemString(headrow, colPurchPrice2 + 3, L"价格3"); |
| | | dw_cell.SetItemString(headrow, colPurchPrice2 + 1, L"供应商3"); |
| | | dw_cell.SetItemString(headrow, colPurchPrice2 + 2, L"类型3"); |
| | | dw_cell.SetItemString(headrow, colPurchPrice2 + 3, L"价格3"); |
| | | } |
| | | return 1; |
| | | } |
| | | |
| | | //命令发布函数 |
| | | //命令发布函数 |
| | | int OnCmdDispatch(xstring comdid) |
| | | { |
| | | if (comdid == L"xmAddBOMItem") return OnAddBOMItem(); |
| | |
| | | { |
| | | if (dw_base.GetItemString(1, L"CustomerID") == L"") |
| | | { |
| | | alert(L"导出前请输入客户"); |
| | | alert(L"导出前请输入客户"); |
| | | return 1; |
| | | } |
| | | return OnPrint(); |
| | |
| | | } |
| | | else if (comdid == L"xmRefreshTask1") |
| | | { |
| | | PostMessage(GetFrameWindow().GetHWND(), 0x401, L"xmRefreshTask", 0); |
| | | PostMessage(GetFrameWindow().GetHWND(), 0x401, (WPARAM)L"xmRefreshTask", 0); |
| | | return 1; |
| | | } |
| | | else if (comdid == L"xmFileOpen" || comdid == L"xmOpen" || comdid == L"xmNew") |
| | |
| | | dw_cell.Redraw(); |
| | | filename = args.GetArgString(L"filename"); |
| | | fileid = args.GetArgString(L"ID"); |
| | | SetWindowText(GetHWND(), L"报价文件:" + filename); |
| | | SetWindowText(GetHWND(), L"报价文件:" + filename); |
| | | } |
| | | return 1; |
| | | } |
| | |
| | | dw_cell.Redraw(); |
| | | filename = L""; |
| | | fileid = L""; |
| | | SetWindowText(GetHWND(), L"报价文件:[new]"); |
| | | SetWindowText(GetHWND(), L"报价文件:[new]"); |
| | | return 1; |
| | | } |
| | | else if (comdid == L"xmFileSave" || comdid == L"xmSave") |
| | |
| | | { |
| | | xstring QuoteNo = QuoteView::MakeBillNo(); |
| | | dw_base.SetItemString(1, L"QuoteNo", QuoteNo); |
| | | setBaseItem(dw_cell, L"报价单号:", QuoteNo); |
| | | setBaseItem(dw_cell, L"报价单号:", QuoteNo); |
| | | } |
| | | if (dw_base.GetGuid(1) == L"") |
| | | dw_base.SetGuid(1, entityID); |
| | |
| | | { |
| | | dw_goods.ResetUpdateStatus(); |
| | | dw_base.ResetUpdateStatus(); |
| | | if (balert)alert(L"保存成功!"); |
| | | if (balert)alert(L"保存成功!"); |
| | | |
| | | return -1; |
| | | |
| | | } |
| | | else |
| | | { |
| | | alert(L"保存失败!"); |
| | | alert(L"保存失败!"); |
| | | return -1; |
| | | } |
| | | } |
| | |
| | | |
| | | int OnInit() |
| | | { |
| | | //公司抬头、报价人、报价日期 |
| | | //公司抬头、报价人、报价日期 |
| | | xstring sdate = publiccode::GetCurrentDate(); |
| | | dw_base.SetItemString(1, L"QuoteDate", sdate); |
| | | xstring suserid = publiccode::GetUser().id; |
| | |
| | | //dw_base.SetItemString(1,L"ExchangeRate",GetExchangeRate(L"USD")); |
| | | |
| | | dw_base.SetItemString(1, L"CompanyID", L"E9E3C542-062C-4957-B8F4-9B92C3E351FC"); |
| | | dw_base.SetItemDisplayString(1, L"CompanyID", L"宁波家尔佳进出口有限公司"); |
| | | dw_base.SetItemDisplayString(1, L"CompanyID", L"宁波家尔佳进出口有限公司"); |
| | | |
| | | /*xstring ss = L"select (select EnglishName from Party where PartyID = CompanyID) as 'CompanyID/@_displaystring',CompanyID from HR_Org where OrgID = '{$id}' for xml PATH('root'),ELEMENTS XSINIL"; |
| | | xstring scguid; |
| | |
| | | |
| | | if (tabsheet != L"tab_quote") OnToQuote(); |
| | | |
| | | if (getBaseItem(dw_cell, L"报价单号:") == L"") |
| | | setBaseItem(dw_cell, L"报价单号:", dw_base.GetItemString(1, L"QuoteNo")); |
| | | if (getBaseItem(dw_cell, L"报价单号:") == L"") |
| | | setBaseItem(dw_cell, L"报价单号:", dw_base.GetItemString(1, L"QuoteNo")); |
| | | |
| | | OnUpdate(); |
| | | if (action == L"purch") return 1; |
| | |
| | | int ret = xaserver::UploadData(suri, sguid + L".jpg", content); |
| | | if (ret < 0) |
| | | { |
| | | alert(L"上传文件出错!"); |
| | | alert(L"上传文件出错!"); |
| | | return 0; |
| | | } |
| | | |
| | |
| | | if (filename == L"" || saveas) path = L"/sale/data/TDocument3/attachment/add"; |
| | | if (xurl::get(path, args.GetString(), x) != 1) |
| | | { |
| | | alert(L"保存出错了!"); |
| | | alert(L"保存出错了!"); |
| | | return 0; |
| | | } |
| | | else |
| | | { |
| | | filename = sfilename; |
| | | SetWindowText(GetHWND(), L"报价文件:" + filename); |
| | | SetWindowText(GetHWND(), L"报价文件:" + filename); |
| | | alert(x.text()); |
| | | } |
| | | |
| | |
| | | |
| | | int SendCtrlCmd(xcontrol xc, xstring cmd) |
| | | { |
| | | SendMessage(xc.GetHWND(), 0x401, cmd, 0); |
| | | SendMessage(xc.GetHWND(), 0x401, (WPARAM)cmd.c_str(), 0); |
| | | return 1; |
| | | } |
| | | |
| | |
| | | if (row < startRow) |
| | | { |
| | | xstring val = dw_cell.GetItemString(row, col); |
| | | if (val == L"报价单号:" || val == L"报价截止日期:" || val == L"项目名称:") |
| | | if (val == L"报价单号:" || val == L"报价截止日期:" || val == L"项目名称:") |
| | | { |
| | | dwhdr.idFrom = -1; |
| | | return 1; |
| | |
| | | if (col > 1) |
| | | { |
| | | val = dw_cell.GetItemString(row, col - 1); |
| | | if (val == L"报价单号:") |
| | | if (val == L"报价单号:") |
| | | { |
| | | dwhdr.idFrom = -1; |
| | | return 1; |
| | |
| | | |
| | | trace(xstring(row) + L"---" + xstring(startRow - 1)); |
| | | |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell, startRow - 1, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | int colBuyer = getItemCol(dw_cell, startRow - 1, L"采购人员"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | int colBuyer = getItemCol(dw_cell, startRow - 1, L"采购人员"); |
| | | int colCustomerPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo"); |
| | | int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式"); |
| | | int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式"); |
| | | int colFOBPrice = getItemCol(dw_cell, startRow - 1, L"FOB Price,FOB Price(USD),Fob Price"); |
| | | int colQty = getItemCol(dw_cell, startRow - 1, L"Qty,数量"); |
| | | //int colToPODate = getItemCol(dw_cell,startRow - 1,L"业务发送采购时间"); |
| | | int colQty = getItemCol(dw_cell, startRow - 1, L"Qty,数量"); |
| | | //int colToPODate = getItemCol(dw_cell,startRow - 1,L"业务发送采购时间"); |
| | | |
| | | int colSaler = getItemCol(dw_cell, startRow - 1, L"业务员"); |
| | | 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 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 colSKUID = getItemCol(dw_cell, startRow - 1, L"SKUID"); |
| | | |
| | | int colPONote = getItemCol(dw_cell, startRow - 1, L"采购To业务备注"); |
| | | int colPONote2 = getItemCol(dw_cell, startRow - 1, L"业务To采购备注"); |
| | | int colPONote = getItemCol(dw_cell, startRow - 1, L"采购To业务备注"); |
| | | int colPONote2 = getItemCol(dw_cell, startRow - 1, L"业务To采购备注"); |
| | | |
| | | int colItemNote = getItemCol(dw_cell, startRow - 1, L"产品备注"); |
| | | int colItemNote = getItemCol(dw_cell, startRow - 1, L"产品备注"); |
| | | |
| | | 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 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 colSKUNo = getItemCol(dw_cell, startRow - 1, L"SKUID,SKUNo"); |
| | | |
| | | int purchremarkcol = getItemCol(dw_cell, startRow - 1, L"采购To业务备注"); |
| | | int purchremarkcol = getItemCol(dw_cell, startRow - 1, L"采购To业务备注"); |
| | | int colRemark = getItemCol(dw_cell, startRow - 1, L"Remarks"); |
| | | |
| | | //int colProductInfo = getItemCol(dw_cell,startRow - 1,L"产品信息"); |
| | | int colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | //int colProductInfo = getItemCol(dw_cell,startRow - 1,L"产品信息"); |
| | | int colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | |
| | | |
| | | int colItemPurchDate = getItemCol(dw_cell, startRow - 1, L"业务发送采购时间"); |
| | | int colItemPurchDate = getItemCol(dw_cell, startRow - 1, L"业务发送采购时间"); |
| | | |
| | | dwhdr.idFrom = 0; |
| | | if (action != L"purch") |
| | |
| | | xstring pitems = L""; |
| | | for (int i = 0; i < count; i++) |
| | | { |
| | | pitems += (xstring)L"<row><显示列>" + items.item(i).selectSingleNode(L"Name").text() + L"</显示列><数据列>" |
| | | + items.item(i).selectSingleNode(L"Name").text() + L"</数据列></row>"; |
| | | pitems += (xstring)L"<row><显示列>" + items.item(i).selectSingleNode(L"Name").text() + L"</显示列><数据列>" |
| | | + items.item(i).selectSingleNode(L"Name").text() + L"</数据列></row>"; |
| | | |
| | | } |
| | | xstring prop = (xstring)L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''>" + |
| | |
| | | xstring pitems = L""; |
| | | for(int i=0;i<count;i++) |
| | | { |
| | | pitems += L"<row><显示列>"+items.item(i).selectSingleNode(L"Name").text+L"</显示列><数据列>" |
| | | +items.item(i).selectSingleNode(L"Name").text + L"</数据列></row>"; |
| | | pitems += L"<row><显示列>"+items.item(i).selectSingleNode(L"Name").text+L"</显示列><数据列>" |
| | | +items.item(i).selectSingleNode(L"Name").text + L"</数据列></row>"; |
| | | |
| | | } |
| | | xstring prop=L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''>" + |
| | |
| | | }*/ |
| | | if (col == colPackage) |
| | | { |
| | | xstring proppack = L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='保护' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''><edit edittype='ddlb' ddlbdataurl='xquery:[Convert.quickcode.xq]?id=包装方式1' ddlbxml=''/></cellprop>"; |
| | | xstring proppack = L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='保护' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''><edit edittype='ddlb' ddlbdataurl='xquery:[Convert.quickcode.xq]?id=包装方式1' ddlbxml=''/></cellprop>"; |
| | | dw_cell.SetCellProps(row, col, proppack); |
| | | } |
| | | } |
| | |
| | | |
| | | if (action == L"purch") |
| | | { |
| | | int colPrice0 = getItemCol(dw_cell, startRow - 1, L"价格"); |
| | | int colPrice1 = getItemCol(dw_cell, startRow - 1, L"价格1"); |
| | | int colPrice2 = getItemCol(dw_cell, startRow - 1, L"价格2"); |
| | | int colPrice3 = getItemCol(dw_cell, startRow - 1, L"价格3"); |
| | | int colPrice = getItemCol(dw_cell, startRow - 1, L"采购价"); |
| | | int colPrice0 = getItemCol(dw_cell, startRow - 1, L"价格"); |
| | | int colPrice1 = getItemCol(dw_cell, startRow - 1, L"价格1"); |
| | | int colPrice2 = getItemCol(dw_cell, startRow - 1, L"价格2"); |
| | | int colPrice3 = getItemCol(dw_cell, startRow - 1, L"价格3"); |
| | | int colPrice = getItemCol(dw_cell, startRow - 1, L"采购价"); |
| | | |
| | | int colTyp = getItemCol(dw_cell, startRow - 1, L"类型"); |
| | | int colTyp1 = getItemCol(dw_cell, startRow - 1, L"类型1"); |
| | | int colTyp2 = getItemCol(dw_cell, startRow - 1, L"类型2"); |
| | | int colTyp3 = getItemCol(dw_cell, startRow - 1, L"类型3"); |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商,工厂"); |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1,工厂1"); |
| | | int colSupplier2 = getItemCol(dw_cell, startRow - 1, L"供应商2,工厂2"); |
| | | int colSupplier3 = getItemCol(dw_cell, startRow - 1, L"供应商3,工厂3"); |
| | | int colTyp = getItemCol(dw_cell, startRow - 1, L"类型"); |
| | | int colTyp1 = getItemCol(dw_cell, startRow - 1, L"类型1"); |
| | | int colTyp2 = getItemCol(dw_cell, startRow - 1, L"类型2"); |
| | | int colTyp3 = getItemCol(dw_cell, startRow - 1, L"类型3"); |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商,工厂"); |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1,工厂1"); |
| | | int colSupplier2 = getItemCol(dw_cell, startRow - 1, L"供应商2,工厂2"); |
| | | int colSupplier3 = getItemCol(dw_cell, startRow - 1, L"供应商3,工厂3"); |
| | | |
| | | |
| | | if (col == colSupplier || col == colSupplier1 || col == colSupplier2 || col == colSupplier3) |
| | |
| | | if (dw_cell.GetItemString(row, col) == L"") |
| | | dw_cell.SetItemString(row, col, L" "); |
| | | xstring prop2 = (xstring)L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''>" + |
| | | L"<edit edittype='query' dddwxpageurl='' dddwdataurl='xquery:[Convert.quickcode.xq]?id=Supplier' dddwtemplateurl='dev:sheet[Supplier.v3.tpl/List]' dddwdatacolumn='Name' dddwdisplaycolumn='Name' dddwwidth='' dddwheight='' dddwautoselect='N' dddwshowbutton='否' dddwcanedit='是'/>" + |
| | | L"<edit edittype='query' dddwxpageurl='' dddwdataurl='xquery:[Convert.quickcode.xq]?id=Supplier' dddwtemplateurl='dev:sheet[Supplier.v3.tpl/List]' dddwdatacolumn='Name' dddwdisplaycolumn='Name' dddwwidth='' dddwheight='' dddwautoselect='N' dddwshowbutton='否' dddwcanedit='是'/>" + |
| | | L"</cellprop>"; |
| | | dw_cell.SetCellProps(row, col, prop2); |
| | | dw_cell.Redraw(); |
| | |
| | | else if (col == colTyp1 || col == colTyp || col == colTyp2 || col == colTyp3) |
| | | { |
| | | xstring pitems1 = L""; |
| | | pitems1 += (xstring)L"<row><显示列>成品</显示列><数据列>" |
| | | + L"成品</数据列></row>"; |
| | | pitems1 += (xstring)L"<row><显示列>散货</显示列><数据列>" |
| | | + L"散货</数据列></row>"; |
| | | pitems1 += (xstring)L"<row><显示列>包装</显示列><数据列>" |
| | | + L"包装</数据列></row>"; |
| | | pitems1 += (xstring)L"<row><显示列>成品</显示列><数据列>" |
| | | + L"成品</数据列></row>"; |
| | | pitems1 += (xstring)L"<row><显示列>散货</显示列><数据列>" |
| | | + L"散货</数据列></row>"; |
| | | pitems1 += (xstring)L"<row><显示列>包装</显示列><数据列>" |
| | | + L"包装</数据列></row>"; |
| | | xstring prop1 = (xstring)L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''>" + |
| | | L"<edit edittype='ddlb' ddlbdataurl='' ddlbxml='<data>" + pitems1 + L"</data>'/>" + |
| | | L"</cellprop>"; |
| | |
| | | |
| | | trace(xstring(row) + L"---" + xstring(startRow - 1)); |
| | | |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell, startRow - 1, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | int colBuyer = getItemCol(dw_cell, startRow - 1, L"采购人员"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | int colBuyer = getItemCol(dw_cell, startRow - 1, L"采购人员"); |
| | | int colCustomerPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo"); |
| | | int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式"); |
| | | int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式"); |
| | | int colFOBPrice = getItemCol(dw_cell, startRow - 1, L"FOB Price,FOB Price(USD),Fob Price"); |
| | | int colQty = getItemCol(dw_cell, startRow - 1, L"Qty,数量"); |
| | | //int colToPODate = getItemCol(dw_cell,startRow - 1,L"业务发送采购时间"); |
| | | int colQty = getItemCol(dw_cell, startRow - 1, L"Qty,数量"); |
| | | //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 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 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 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 colSKUNo = getItemCol(dw_cell, startRow - 1, L"SKUID,SKUNo"); |
| | | |
| | | dwhdr.idFrom = 0; |
| | |
| | | xstring pitems = L""; |
| | | for (int i = 0; i < count; i++) |
| | | { |
| | | pitems += (xstring)L"<row><显示列>" + items.item(i).selectSingleNode(L"Name").text() + L"</显示列><数据列>" |
| | | + items.item(i).selectSingleNode(L"Name").text() + L"</数据列></row>"; |
| | | pitems += (xstring)L"<row><显示列>" + items.item(i).selectSingleNode(L"Name").text() + L"</显示列><数据列>" |
| | | + items.item(i).selectSingleNode(L"Name").text() + L"</数据列></row>"; |
| | | |
| | | } |
| | | xstring prop = (xstring)L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''>" + |
| | |
| | | } |
| | | if (col == colPackage) |
| | | { |
| | | xstring proppack = L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='保护' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''><edit edittype='ddlb' ddlbdataurl='xquery:[Convert.quickcode.xq]?id=包装方式1' ddlbxml=''/></cellprop>"; |
| | | xstring proppack = L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='保护' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''><edit edittype='ddlb' ddlbdataurl='xquery:[Convert.quickcode.xq]?id=包装方式1' ddlbxml=''/></cellprop>"; |
| | | dw_cell.SetCellProps(row, col, proppack); |
| | | } |
| | | } |
| | |
| | | |
| | | if (((ACol == colVolDesc && (col != colVolDesc || row != ARow)) || (ACol == colQtyPerPack && (col != colQtyPerPack || row != ARow))) && ARow >= startRow) |
| | | { |
| | | /*计算体积*/ |
| | | /*计算体积*/ |
| | | xstring desc = dw_cell.GetItemString(ARow, colVolDesc); |
| | | double v = 0.0; |
| | | if (desc == L"") |
| | |
| | | |
| | | if (action == L"purch") |
| | | { |
| | | int colPrice0 = getItemCol(dw_cell, startRow - 1, L"价格"); |
| | | int colPrice1 = getItemCol(dw_cell, startRow - 1, L"价格1"); |
| | | int colPrice = getItemCol(dw_cell, startRow - 1, L"采购价"); |
| | | int colPrice0 = getItemCol(dw_cell, startRow - 1, L"价格"); |
| | | int colPrice1 = getItemCol(dw_cell, startRow - 1, L"价格1"); |
| | | int colPrice = getItemCol(dw_cell, startRow - 1, L"采购价"); |
| | | |
| | | int colTyp = getItemCol(dw_cell, startRow - 1, L"类型"); |
| | | int colTyp1 = getItemCol(dw_cell, startRow - 1, L"类型1"); |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商,工厂"); |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1,工厂1"); |
| | | int colSupplier2 = getItemCol(dw_cell, startRow - 1, L"供应商2,工厂2"); |
| | | int colTyp = getItemCol(dw_cell, startRow - 1, L"类型"); |
| | | int colTyp1 = getItemCol(dw_cell, startRow - 1, L"类型1"); |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商,工厂"); |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1,工厂1"); |
| | | int colSupplier2 = getItemCol(dw_cell, startRow - 1, L"供应商2,工厂2"); |
| | | |
| | | |
| | | if (col == colSupplier || col == colSupplier1 || col == colSupplier2) |
| | |
| | | if (dw_cell.GetItemString(row, col) == L"") |
| | | dw_cell.SetItemString(row, col, L" "); |
| | | xstring prop2 = (xstring)L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''>" + |
| | | L"<edit edittype='query' dddwxpageurl='' dddwdataurl='xquery:[Convert.quickcode.xq]?id=Supplier' dddwtemplateurl='dev:sheet[Supplier.v3.tpl/List]' dddwdatacolumn='Name' dddwdisplaycolumn='Name' dddwwidth='' dddwheight='' dddwautoselect='N' dddwshowbutton='否' dddwcanedit='是'/>" + |
| | | L"<edit edittype='query' dddwxpageurl='' dddwdataurl='xquery:[Convert.quickcode.xq]?id=Supplier' dddwtemplateurl='dev:sheet[Supplier.v3.tpl/List]' dddwdatacolumn='Name' dddwdisplaycolumn='Name' dddwwidth='' dddwheight='' dddwautoselect='N' dddwshowbutton='否' dddwcanedit='是'/>" + |
| | | L"</cellprop>"; |
| | | dw_cell.SetCellProps(row, col, prop2); |
| | | dw_cell.Redraw(); |
| | |
| | | else if (col == colTyp1 || col == colTyp) |
| | | { |
| | | xstring pitems1 = L""; |
| | | pitems1 += (xstring)L"<row><显示列>成品</显示列><数据列>" |
| | | + L"成品</数据列></row>"; |
| | | pitems1 += (xstring)L"<row><显示列>散货</显示列><数据列>" |
| | | + L"散货</数据列></row>"; |
| | | pitems1 += (xstring)L"<row><显示列>包装</显示列><数据列>" |
| | | + L"包装</数据列></row>"; |
| | | pitems1 += (xstring)L"<row><显示列>成品</显示列><数据列>" |
| | | + L"成品</数据列></row>"; |
| | | pitems1 += (xstring)L"<row><显示列>散货</显示列><数据列>" |
| | | + L"散货</数据列></row>"; |
| | | pitems1 += (xstring)L"<row><显示列>包装</显示列><数据列>" |
| | | + L"包装</数据列></row>"; |
| | | xstring prop1 = (xstring)L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''>" + |
| | | L"<edit edittype='ddlb' ddlbdataurl='' ddlbxml='<data>" + pitems1 + L"</data>'/>" + |
| | | L"</cellprop>"; |
| | |
| | | { |
| | | if (price0.find(L"A") < 1 && price0.find(L"B") < 1 && price0.find(L"C") < 1 && price0.find(L"a") < 1 && price0.find(L"b") < 1 && price0.find(L"b") < 1) |
| | | { |
| | | alert(L"价格中没指定ABC"); |
| | | alert(L"价格中没指定ABC"); |
| | | } |
| | | } |
| | | if (price1 != L"") |
| | | { |
| | | if (price1.find(L"A") < 1 && price1.find(L"B") < 1 && price1.find(L"C") < 1 && price1.find(L"a") < 1 && price1.find(L"b") < 1 && price1.find(L"c") < 1) |
| | | { |
| | | alert(L"价格中没指定ABC"); |
| | | alert(L"价格中没指定ABC"); |
| | | } |
| | | price = price0 + L"+L" + price1; |
| | | } |
| | |
| | | return 1; |
| | | } |
| | | |
| | | //命令处理事件 |
| | | //命令处理事件 |
| | | int OnXCommand(TEvent * evt, LPARAM param) |
| | | { |
| | | return OnCmdDispatch(evt->xcommand.pStrID); |
| | |
| | | |
| | | int OnAttachListon() |
| | | { |
| | | //绑定工具条点击事件 |
| | | //绑定工具条点击事件 |
| | | AttachEvent(L"WM_XCOMMAND", (FEvent)&QuoteFileView::OnXCommand); |
| | | //获取焦点事件,用于重置工具条 |
| | | //获取焦点事件,用于重置工具条 |
| | | AttachEvent(L"WM_SETFOCUS", (FEvent)&QuoteFileView::OnSetFocus); |
| | | |
| | | AttachEvent(L"frame:im1", L"IMG_LDBCLICK", (FEvent)&QuoteFileView::OnImgDBClicked); |
| | |
| | | { |
| | | int startRow = getItemHeadRow(dw_cell); |
| | | |
| | | //没有找到商品行的标题 |
| | | //没有找到商品行的标题 |
| | | if (startRow < 1) return 0; |
| | | startRow++; |
| | | |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemNo = getItemCol(dw_cell, startRow - 1, L"我司型号,ItemNo"); |
| | | int colCustomerItemNo = getItemCol(dw_cell, startRow - 1, L"客户型号,Customer ItemNo,Customer Item No"); |
| | | int colItemName = getItemCol(dw_cell, startRow - 1, L"Product Description,Product Name,Item Name"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | int colBuyer = getItemCol(dw_cell, startRow - 1, L"采购人员"); |
| | | int colItemCName = getItemCol(dw_cell, startRow - 1, L"中文品名"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colBuyerPrice = getItemCol(dw_cell, startRow - 1, L"采购价,采购价格"); |
| | | int colBuyer = getItemCol(dw_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 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 colPurchedDate = getItemCol(dw_cell, startRow - 1, L"采购提交业务时间"); |
| | | int colPhoto1 = getItemCol(dw_cell, startRow - 1, L"工厂图片"); |
| | | //int colProductInfo = getItemCol(dw_cell,startRow - 1,L"产品信息"); |
| | | int colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | 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 colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息"); |
| | | int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息"); |
| | | |
| | | int LastRow = dw_cell.GetValidRow(); |
| | | KXMLDOMNodeList items = x.selectNodes(L"//Item"); |
| | |
| | | |
| | | dw_cell.openUrl(templateurl); |
| | | */ |
| | | //SetWindowText(GetHWND(),L"报价文件:[new]"); |
| | | //SetWindowText(GetHWND(),L"报价文件:[new]"); |
| | | } |
| | | |
| | | ARow = 0; |
| | |
| | | { |
| | | int startRow = getItemHeadRow(dw_cell); |
| | | |
| | | //没有找到商品行的标题 |
| | | //没有找到商品行的标题 |
| | | if (startRow < 1) return L"<data/>"; |
| | | startRow++; |
| | | |
| | | int colItemName = getItemCol(dw_cell, startRow - 1, L"Product Description,Product Name,Item Name"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | int colItemSpec = getItemCol(dw_cell, startRow - 1, L"Specifications,规格,产品规格"); |
| | | |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1"); |
| | | int colSupplier2 = getItemCol(dw_cell, startRow - 1, L"供应商2"); |
| | | int colSupplier3 = getItemCol(dw_cell, startRow - 1, L"供应商3"); |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商"); |
| | | int colSupplier1 = getItemCol(dw_cell, startRow - 1, L"供应商1"); |
| | | int colSupplier2 = getItemCol(dw_cell, startRow - 1, L"供应商2"); |
| | | int colSupplier3 = getItemCol(dw_cell, startRow - 1, L"供应商3"); |
| | | int colSupplier = getItemCol(dw_cell, startRow - 1, L"供应商"); |
| | | |
| | | int LastRow = dw_cell.GetValidRow(); |
| | | xstring content = L""; |
| | |
| | | xml purcher ; |
| | | xaserverarg arg ; |
| | | arg.setNativePointer(xaserverarg::CreateInstance()); |
| | | arg.AddArg(L"id", L"采购员"); |
| | | arg.AddArg(L"id", L"采购员"); |
| | | if (getUrl(L"/sale/data/Quote/Purcher", arg.GetString(), purcher) != 1) |
| | | { |
| | | alert((xstring)L"error:" + purcher.xml()); |