#include <wobject/xstring.hpp>
#include <xcontrol/xtreeview.hpp>
#include <xcontrol/xdwgrid.hpp>
#include <xcontrol/ximageview.hpp>
#include <xcontrol/xcell.hpp>


#include "vbusiness/vframe/listwin.vframe.vbusiness.hpp"
#include "viewobject/view.base.hpp"
#include "viewobject/quote.view.hpp"

using xml = KXMLDOMDocument;
class __declspec(dllexport) QuoteFileView : public xframe
{

public:
	QuoteFileView(void* implPtr, HWND hWnd):xframe(implPtr, hWnd) {}
public:
	static QuoteFileView* CreateInstance(void* implPtr, void* hWnd)
	{
		QuoteFileView* pWin = new QuoteFileView(implPtr, (HWND)hWnd);
		return pWin;
	}
public:
	xcell	dw_cell;
	xnode	m_agentNode;	//Agent Condition
	xstring filename;
	xstring fileid;
	xstring templateurl;
	xstring taskid;
	xml purcher;

	xdwgrid	dw_goods;
	xdwtable dw_base;
	xstring tabsheet;

	xstring templateID;
	xstring entityID;
	xstring entityItemID;
	xstring action;
	xstring processurl;

	int ARow;
	int ACol;
	xstring orivalue;
	bool bPurchPrice;

	int SetAgent()
	{
		xstring xfNodeAgentArea = L"agentarea";
		xnode anode = GetAgentNode(xfNodeAgentArea);
		if (m_agentNode)
		{
			SetAgentNode(anode, m_agentNode);
		}
		else
		{
			xstring path = L"agent/" + xfNodeAgentArea + L"[1]/*";
			if (action == L"purch") path = L"agent/" + xfNodeAgentArea + L"[2]/*";
			KXMLDOMElement xframeElement = GetElement();
			KXMLDOMElement agent = xframeElement.selectSingleNode(path);
			if (agent)
			{
				xstring s = agent.xml();
				m_agentNode = SetAgentNode(anode, s);
			}
		}
		return 1;
	}

	xstring GetImageUrl(xstring id)
	{
		xml xp ;
		xaserverarg arg_pic;
		arg_pic.AddArg(L"id", id);

		xstring res = L"/sale/data/productlibrary3/image/url";
		if (xurl::get(res, arg_pic.GetString(), xp) != 1)
		{
			trace(xp.xml());
			return 1;
		}
		else
		{
			xstring path = xp.text();
			if (path != L"") return path;
		}

		return L"/business/products/chanpin/" + id.left(2) + L"/" + id + L".jpg";
	}

	xstring GetGuid()
	{
		return publiccode::GetGuid();
	}

	int getItemHeadRow(xcell dw_obj)
	{
		int rowHeader = -1;
		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, 1) == L"SKUID" || dw_obj.GetItemString(row, 2) == L"SKUID") return row;
		}
		return -1;
	}

	double calcVol(xstring volDesc)
	{
		xstring sl = L"";
		xstring sw = L"";
		xstring sh = L"";

		xstring val = volDesc;
		val = val.replace(L"x", L"X");
		val = val.replace(L"*", L"X");

		//parse length
		int pos = val.find(L"X");
		if (pos >= 0)
			sl = val.left(pos);
		else
			sl = val;

		//parse width
		if (pos >= 0)
		{
			val = val.mid(pos + 1, 9999);
			pos = val.find(L"X");
			if (pos >= 0)
				sw = val.left(pos);
			else
				sw = val;
		}

		//parse height
		if (pos >= 0)
		{
			val = val.mid(pos + 1, 9999);
			pos = val.find(L"X");
			if (pos >= 0)
				sh = val.left(pos);
			else
				sh = val;
		}

		double ret = 0.0;
		if (sw == L"") ret = sl.toDouble();
		else if (sh == L"") ret = sl.toDouble() * sw.toDouble();
		else ret = sl.toDouble() * sw.toDouble() * sh.toDouble();
		return ret;
	}

	int ShowImageOne(ximageview im, xstring str, xstring tm)
	{
		int spos = str.find(tm + L":");
		if (spos >= 0)
		{
			int pos = (str + L";").find(L";", spos + 1);
			int pos0 = spos + tm.length() + 1;
			xstring guids = str.mid(pos0, pos - pos0);
			while (true)
			{
				xstring guid = guids;
				if (guids.find(L",L") >= 0)
				{
					guid = guids.left(guids.find(L",L"));
					guids = guids.mid(guids.find(L",L") + 1, 99999);
				}
				else
				{
					guid = guids;
					guids = L"";
				}
				if (guid != L"")
				{
					xstring picname = GetImageUrl(guid);
					im.AddImages(picname, L"");
					return 1;
				}
				if (guids == L"") break;
			}
		}
		return 1;
	}

	int ShowImage(xstring str, xstring tm)
	{
		ximageview im = GetControl(L"frame:im1");

		int spos = str.find(tm + L":");
		if (spos >= 0)
		{
			int pos = (str + L";").find(L";", spos + 1);
			int pos0 = spos + tm.length() + 1;
			xstring guids = str.mid(pos0, pos - pos0);
			while (true)
			{
				xstring guid = guids;
				if (guids.find(L",L") >= 0)
				{
					guid = guids.left(guids.find(L",L"));
					guids = guids.mid(guids.find(L",L") + 1, 99999);
				}
				else
				{
					guid = guids;
					guids = L"";
				}
				if (guid != 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);
				}
				if (guids == L"") break;
			}
		}
		return 1;
	}

	xstring getImageList(xstring idlist)
	{
		xstring strs = idlist.trim();
		xstring str = L"";
		xstring fstr = L"";
		while (strs != L"")
		{
			int pos = strs.find(L",L");
			if (pos < 0)
			{
				str = strs;
				strs = L"";
			}
			else
			{
				str = strs.left(pos);
				strs = strs.mid(pos + 1, 9999);
			}
			if (fstr == L"")
				fstr = GetImageUrl(str);
			else
				fstr += L",L" + GetImageUrl(str);
		}
		return fstr;
	}

	xstring GetSaleFullData(xcell cell)
	{
		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"<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 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 colSKUID = getItemCol(cell, startRow - 1, L"SKUID");
		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 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 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");


		int LastRow = cell.GetValidRow();
		xstring sdate = publiccode::GetCurrentDate();

		xstring rowid = L"";
		for (int row = startRow; row <= LastRow; row++)
		{
			bool bextern = false;
			if (cell.GetItemString(row, colItemName) == L"" &&
				cell.GetItemString(row, colItemSpec) == L"")
			{

			}

			xstring itemStr = L"";
			rowid = getRowID(cell, row);
			itemStr += L"<RowID>" + getRowID(cell, row) + L"</RowID>";
			itemStr += L"<SKUID>" + cell.GetItemString(row, colSKUID) + L"</SKUID>";
			itemStr += L"<customer-photo>" + getRowTerm(cell, row, L"customer-photo") + L"</customer-photo>";
			itemStr += L"<supplier-photo>" + getRowTerm(cell, row, L"supplier-photo") + L"</supplier-photo>";
			itemStr += L"<customer-photo-url>" + getImageList(getRowTerm(cell, row, L"customer-photo")) + L"</customer-photo-url>";
			itemStr += L"<supplier-photo-url>" + getImageList(getRowTerm(cell, row, L"supplier-photo")) + L"</supplier-photo-url>";
			itemStr += L"<ItemNo>" + cell.GetItemString(row, colItemNo) + L"</ItemNo>";
			itemStr += L"<CustomItemNo>" + cell.GetItemString(row, colCustomerItemNo) + L"</CustomItemNo>";
			itemStr += L"<ItemName>" + cell.GetItemString(row, colItemName) + L"</ItemName>";
			itemStr += L"<ItemCName>" + cell.GetItemString(row, colItemCName) + L"</ItemCName>";
			itemStr += L"<ItemSpec>" + cell.GetItemString(row, colItemSpec) + L"</ItemSpec>";
			itemStr += L"<CustomerImage>" + cell.GetItemString(row, colCustomerImage) + L"</CustomerImage>";
			itemStr += L"<BuyerPrice>" + cell.GetItemString(row, colBuyerPrice) + L"</BuyerPrice>";
			itemStr += L"<SaleRemark>" + cell.GetItemString(row, colSaleRemark) + L"</SaleRemark>";

			itemStr += L"<BuyerRemark>" + cell.GetItemString(row, colBuyerRemark) + L"</BuyerRemark>";
			itemStr += L"<FactoryImage>" + cell.GetItemString(row, colFactoryImage) + L"</FactoryImage>";
			itemStr += L"<GWT>" + cell.GetItemString(row, colGWT) + L"</GWT>";
			itemStr += L"<NWT>" + cell.GetItemString(row, colNWT) + L"</NWT>";
			itemStr += L"<VolDesc>" + cell.GetItemString(row, colVolDesc) + L"</VolDesc>";
			itemStr += L"<Vol>" + cell.GetItemString(row, colVol) + L"</Vol>";
			itemStr += L"<F40HQ>" + cell.GetItemString(row, col40HQ) + L"</F40HQ>";
			itemStr += L"<Packing>" + cell.GetItemString(row, colInnerOuter) + L"</Packing>";
			itemStr += L"<Quantity>" + cell.GetItemString(row, colItemQty) + L"</Quantity>";
			itemStr += L"<Package>" + cell.GetItemString(row, colPackage) + L"</Package>";
			itemStr += L"<Buyer>" + cell.GetItemString(row, colBuyer) + L"</Buyer>";
			itemStr += L"<RemarkS>" + cell.GetItemString(row, colRemark) + L"</RemarkS>";
			itemStr += L"<FOBPrice>" + cell.GetItemString(row, colFOBPrice) + L"</FOBPrice>";


			itemStr += L"<PurchedDate>" + sdate + L"</PurchedDate>";
			itemStr += L"<EnquiryLineID>" + getRowTerm(dw_cell, row, L"EnquiryLineID") + L"</EnquiryLineID>";
			content += L"<Item>" + itemStr + L"</Item>";
		}
		content = L"<data>" + base + content + L"</data>";

		return content;
	}

	xstring GetSaleFullData(xcell cell, KXMLDOMNodeList ts)
	{
		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"<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 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 colSKUID = getItemCol(cell, startRow - 1, L"SKUID");
		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 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 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");


		int LastRow = cell.GetValidRow();
		xstring sdate = publiccode::GetCurrentDate();

		int len = ts.length();

		//xstring content = L"";
		//xstring sdate = publiccode::GetCurrentDate();
		for (int k = 0; k < len; k++)
		{
			KXMLDOMNode node = ts.item(k);
			xstring id = node.selectSingleNode(L"RowID").text();
			int row = LookupCellRow(id);
			if (row < 1) continue;

			xstring itemStr = L"";
			itemStr += L"<RowID>" + getRowID(cell, row) + L"</RowID>";
			itemStr += L"<SKUID>" + cell.GetItemString(row, colSKUID) + L"</SKUID>";
			itemStr += L"<customer-photo>" + getRowTerm(cell, row, L"customer-photo") + L"</customer-photo>";
			itemStr += L"<supplier-photo>" + getRowTerm(cell, row, L"supplier-photo") + L"</supplier-photo>";
			itemStr += L"<ItemNo>" + cell.GetItemString(row, colItemNo) + L"</ItemNo>";
			itemStr += L"<CustomItemNo>" + cell.GetItemString(row, colCustomerItemNo) + L"</CustomItemNo>";
			itemStr += L"<ItemName>" + cell.GetItemString(row, colItemName) + L"</ItemName>";
			itemStr += L"<ItemCName>" + cell.GetItemString(row, colItemCName) + L"</ItemCName>";
			itemStr += L"<ItemSpec>" + cell.GetItemString(row, colItemSpec) + L"</ItemSpec>";
			itemStr += L"<CustomerImage>" + cell.GetItemString(row, colCustomerImage) + L"</CustomerImage>";
			itemStr += L"<BuyerPrice>" + cell.GetItemString(row, colBuyerPrice) + L"</BuyerPrice>";
			itemStr += L"<SaleRemark>" + cell.GetItemString(row, colSaleRemark) + L"</SaleRemark>";

			itemStr += L"<BuyerRemark>" + cell.GetItemString(row, colBuyerRemark) + L"</BuyerRemark>";
			itemStr += L"<FactoryImage>" + cell.GetItemString(row, colFactoryImage) + L"</FactoryImage>";
			itemStr += L"<GWT>" + cell.GetItemString(row, colGWT) + L"</GWT>";
			itemStr += L"<NWT>" + cell.GetItemString(row, colNWT) + L"</NWT>";
			itemStr += L"<VolDesc>" + cell.GetItemString(row, colVolDesc) + L"</VolDesc>";
			itemStr += L"<Vol>" + cell.GetItemString(row, colVol) + L"</Vol>";
			itemStr += L"<F40HQ>" + cell.GetItemString(row, col40HQ) + L"</F40HQ>";
			itemStr += L"<Packing>" + cell.GetItemString(row, colInnerOuter) + L"</Packing>";
			itemStr += L"<Quantity>" + cell.GetItemString(row, colItemQty) + L"</Quantity>";
			itemStr += L"<Package>" + cell.GetItemString(row, colPackage) + L"</Package>";
			itemStr += L"<Buyer>" + cell.GetItemString(row, colBuyer) + L"</Buyer>";
			itemStr += L"<RemarkS>" + cell.GetItemString(row, colRemark) + L"</RemarkS>";
			itemStr += L"<FOBPrice>" + cell.GetItemString(row, colFOBPrice) + L"</FOBPrice>";

			itemStr += L"<Supplier>" + cell.GetItemString(row, colSupplier) + L"</Supplier>";
			itemStr += L"<Supplier1>" + cell.GetItemString(row, colSupplier1) + L"</Supplier1>";
			itemStr += L"<Supplier2>" + cell.GetItemString(row, colSupplier2) + L"</Supplier2>";
			itemStr += L"<Supplier3>" + cell.GetItemString(row, colSupplier3) + L"</Supplier3>";
			itemStr += L"<POPrice>" + cell.GetItemString(row, colPOPrice) + L"</POPrice>";
			itemStr += L"<POPrice1>" + cell.GetItemString(row, colPOPrice1) + L"</POPrice1>";
			itemStr += L"<POPrice2>" + cell.GetItemString(row, colPOPrice2) + L"</POPrice2>";
			itemStr += L"<POPrice3>" + cell.GetItemString(row, colPOPrice3) + L"</POPrice3>";

			itemStr += L"<BOMType>" + cell.GetItemString(row, colBOMType) + L"</BOMType>";
			itemStr += L"<BOMType1>" + cell.GetItemString(row, colBOMType1) + L"</BOMType1>";
			itemStr += L"<BOMType2>" + cell.GetItemString(row, colBOMType2) + L"</BOMType2>";
			itemStr += L"<BOMType3>" + cell.GetItemString(row, colBOMType2) + L"</BOMType3>";
			itemStr += L"<PurchedDate>" + sdate + L"</PurchedDate>";
			itemStr += L"<EnquiryLineID>" + getRowTerm(cell, row, L"EnquiryLineID") + L"</EnquiryLineID>";

			int lastrow = row;

			while (true)
			{
				row++;
				if (cell.GetItemString(row, colItemName) != L"" || cell.GetItemString(row, colItemSpec) != L"") break;
				if (cell.GetItemString(row, colSupplier) == L"")break;
				xstring extStr = L"";
				extStr += L"<Supplier>" + cell.GetItemString(row, colSupplier) + L"</Supplier>";
				extStr += L"<Supplier1>" + cell.GetItemString(row, colSupplier1) + L"</Supplier1>";
				extStr += L"<Supplier2>" + cell.GetItemString(row, colSupplier2) + L"</Supplier2>";
				extStr += L"<Supplier3>" + cell.GetItemString(row, colSupplier3) + L"</Supplier3>";
				extStr += L"<POPrice>" + cell.GetItemString(row, colPOPrice) + L"</POPrice>";
				extStr += L"<POPrice1>" + cell.GetItemString(row, colPOPrice1) + L"</POPrice1>";
				extStr += L"<POPrice2>" + cell.GetItemString(row, colPOPrice2) + L"</POPrice2>";
				extStr += L"<POPrice3>" + cell.GetItemString(row, colPOPrice3) + L"</POPrice3>";

				extStr += L"<BOMType>" + cell.GetItemString(row, colBOMType) + L"</BOMType>";
				extStr += L"<BOMType1>" + cell.GetItemString(row, colBOMType1) + L"</BOMType1>";
				extStr += L"<BOMType2>" + cell.GetItemString(row, colBOMType2) + L"</BOMType2>";
				extStr += L"<BOMType3>" + cell.GetItemString(row, colBOMType2) + L"</BOMType3>";

				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>";
			}
			content += L"<Item>" + itemStr + L"</Item>";
		}
		content = L"<data>" + base + content + L"</data>";

		return content;
	}

	int OnPrint()
	{

		if (dw_base.GetItemString(1, L"QuoteNo") == L"")
		{
			alert(L"请先保存数据!");
			return 1;
		}

		xaserverarg argx;
		argx.AddArg(L"QuoteNo", dw_base.GetItemString(1, L"QuoteNo"));
		int p1 = argx;
		if (dw_base.GetItemString(1, L"QuoteNo") != L"")
		{
			OpenWindow(L"dev:xpage[xmQuoteBillList.vx]", p1);
		}
		if (argx.GetArgString(L"action") != L"ok") return 1;

		xstring printStr = argx.GetArgString(L"items");

		xaserverarg arg ;
		
		arg.AddArg(L"DataUrl", L"/sale/data/Quote3/print/mydata");
		arg.AddArg(L"EntityName", L"Quote");
		arg.AddArg(L"EntityID", entityID + printStr);
		arg.AddArg(L"EntityNo", dw_base.GetItemString(1, L"QuoteNo"));
		trace(L"*******" + entityID + printStr + L"*******");
		openUrl(L"/sale/view/view.base/xpage/Template/PrintViewEx", &arg);

		/*	xaserverarg arg=new xaserverarg;
			
			arg.AddArg(L"EntityName",L"Quote",L"");
			arg.AddArg(L"EntityID",dw_base.GetItemString(1,L"QuoteID"),L"");
			arg.AddArg(L"EntityNo",dw_base.GetItemString(1,L"QuoteNo"),L"");
			trace(dw_base.GetItemString(1,L"QuoteID")+L"***"+dw_base.GetItemString(1,L"QuoteNo"));
			int p = arg.ptr_native_;
			openUrl(L"/sale/view/view.base/xpage/Template/PrintViewEx", p);*/

		return 1;
	}

	int RowChanged(int row)
	{
		ximageview im = GetControl(L"frame:im1");
		im.Reset();

		int startRow = getItemHeadRow(dw_cell);
		//没有找到商品行的标题
		if (startRow < 1) return 1;
		if (row <= startRow) return 1;

		int colCustomerPhoto = getItemCol(dw_cell, startRow, L"Photo,Customer Photo");
		xstring ls_photo = dw_cell.GetItemString(row, colCustomerPhoto);
		while (ls_photo == L"-")
		{
			if (row - 1 < startRow) break;
			row = row - 1;
			ls_photo = dw_cell.GetItemString(row, colCustomerPhoto);
		}
		if (row <= startRow) return 1;

		xstring str = dw_cell.GetItemString(row, 0);
		ShowImage(str, L"customer-photo");
		ShowImage(str, L"supplier-photo");

		im.Redraw();

		return 1;
	}

	xstring getBaseItem(xcell dw_cell, xstring colname)
	{
		int row = 0;
		int col = 0;
		int vcol = 0;
		int vrow = dw_cell.GetValidRow();
		int scol = dw_cell.GetValidCol();
		for (row = 1; row <= vrow; row++)
		{
			vcol = dw_cell.GetValidCol(row);
			if (vcol < scol) vcol++;
			for (col = 1; col <= vcol; col++)
			{
				if (dw_cell.GetItemString(row, col) == colname)
				{
					return dw_cell.GetItemString(row, col + 1);
				}
			}
		}
		return L"";
	}

	void setBaseItem(xcell dw_cell, xstring colname, xstring val)
	{
		int row = 0;
		int col = 0;
		int vcol = 0;
		int vrow = dw_cell.GetValidRow();
		int scol = dw_cell.GetValidCol();
		for (row = 1; row <= vrow; row++)
		{
			vcol = dw_cell.GetValidCol(row);
			if (vcol < scol) vcol++;
			for (col = 1; col <= vcol; col++)
			{
				if (dw_cell.GetItemString(row, col) == colname)
				{
					dw_cell.SetItemString(row, col + 1, val);
					dw_cell.Redraw();
				}
			}
		}
	}

	int getItemCol(xcell dw_obj, int row, xstring head)
	{
		xstring fullhead = L",L" + head + L",L";
		int headRow = row;
		int colCount = dw_obj.GetValidCol(headRow);
		for (int col = 1; col <= colCount; col++)
		{
			if (fullhead.find(L",L" + dw_obj.GetItemString(headRow, col) + L",L") >= 0) return col;
		}
		return -1;
	}


	int setRowProp(xcell dw_obj, int row, xstring prop, xstring val)
	{
		prop = prop.trim();
		if (prop.left(1) != L"[") prop = L"[" + prop + L"]";
		xstring str = dw_obj.GetItemString(row, 0);
		if (str.find(prop + L":" + val + L";") >= 0) return 1;

		if (str.find(prop + L":") < 0)
		{
			if (str == L"")
				str = prop + L":" + val + L";";
			else
				str += prop + L":" + val + L";";
			dw_obj.SetItemString(row, 0, str);
		}
		else
		{
			str = str.mid(str.find(prop + L":") + prop.length() + 1, 9999);
			xstring right = L"";
			xstring left = str.left(str.find(prop + L":") + prop.length() + 1);
			if (str.find(L";") >= 0)
				right = str.mid(str.find(L";") + 1, 9999);
			else 	if (str.find(L",L") >= 0)
				right = str.mid(str.find(L",L") + 1, 9999);
			str = left + val + L";" + right;
			//alert(str);
			dw_obj.SetItemString(row, 0, str);
		}
		return 1;
	}

	xstring getRowProp(xcell dw_obj, int row, xstring prop)
	{
		prop = prop.trim();
		if (prop.left(1) != L"[") prop = L"[" + prop + L"]";
		xstring str = dw_obj.GetItemString(row, 0);
		if (str.find(prop + L":") >= 0)
		{
			str = str.mid(str.find(prop + L":") + prop.length() + 1, 9999);
			if (str.find(L";") >= 0)
				str = str.left(str.find(L";"));
			else if (str.find(L",L") >= 0)
				str = str.left(str.find(L",L"));
			return str;
		}
		return L"";
	}

	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 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 LastRow = dw_cell.GetValidRow();
		for (int row = startRow; row <= LastRow; row++)
		{
			if (dw_cell.GetItemString(row, colItemName) == L"" &&
				dw_cell.GetItemString(row, colItemCName) == L"") break;
			ensureRowID(dw_cell, row);
		}
		return 1;
	}

	int LookupRow(xstring rowid)
	{
		int rowcount = dw_goods.GetRowCount();
		for (int row = 1; row <= rowcount; row++)
		{
			if (dw_goods.GetGuid(row) == rowid) return row;
		}
		return 0;
	}

	int LookupCellRow(xcell cell, xstring rowid)
	{
		int startRow = getItemHeadRow(cell);
		//没有找到商品行的标题
		if (startRow < 1) return 0;
		startRow++;

		int LastRow = cell.GetValidRow();
		for (int row = startRow; row <= LastRow; row++)
		{
			if (getRowID(cell, row) == rowid) return row;
		}
		return 0;
	}

	int LookupCellRow(xstring rowid)
	{
		return LookupCellRow(dw_cell, rowid);
	}

	int ensureRowID(xcell dw_obj, int row)
	{
		xstring str = dw_obj.GetItemString(row, 0);
		if (str.find(L"rowid:") < 0)
		{
			xstring rowid = ViewObject::GetGuid();
			if (str == L"")
				str = L"rowid:" + rowid + L";";
			else
				str += L";rowid:" + rowid + L";";
			//alert(str);
			dw_obj.SetItemString(row, 0, str);
		}
		return 1;
	}

	xstring getRowID(xcell dw_obj, int row)
	{
		xstring str = dw_obj.GetItemString(row, 0);
		if (str.find(L"rowid:") >= 0)
		{
			str = str.mid(str.find(L"rowid:") + 6, 99999);
			if (str.find(L";") >= 0)
				str = str.left(str.find(L";"));
			else if (str.find(L",L") >= 0)
				str = str.left(str.find(L",L"));
			return str;
		}
		return L"";
	}

	xstring getRowTerm(xcell dw_obj, int row, xstring tm)
	{
		xstring str = dw_obj.GetItemString(row, 0);
		if (str.find(tm + L":") >= 0)
		{
			str = str.mid(str.find(tm + L":") + tm.length() + 1, 99999);
			if (str.find(L";") >= 0) 	str = str.left(str.find(L";"));
			return str;
		}
		return L"";
	}

	int setRowTerm(xcell dw_obj, int row, xstring tm, xstring val)
	{
		xstring str = dw_obj.GetItemString(row, 0);
		if (str.find(tm + L":") >= 0)
		{
			int pos0 = str.find(tm + L":");
			xstring left = str.left(pos0);
			if (left != L"" && left.right(1) != L";") left += L";";

			xstring right = L"";
			int pos1 = str.find(L";", pos0 + 1);
			if (pos1 >= 0)right = str.mid(pos1, 99999);
			str = left + tm + L":" + val + right;
		}
		else
		{
			if (str.right(1) == L";")
				str += tm + L":" + val;
			else
				str += L";" + tm + L":" + val;
		}
		trace(L"\r\nterm:" + str + L"\r\n");
		dw_obj.SetItemString(row, 0, str);
		return 1;
	}

	int resetRowTerm(xcell dw_obj, int row, xstring tm)
	{
		xstring str = dw_obj.GetItemString(row, 0);
		if (str.find(tm + L":") >= 0)
		{
			int pos0 = str.find(tm + L":");
			xstring left = str.left(pos0);
			if (left != L"" && left.right(1) != L";") left += L";";

			xstring right = L"";
			int pos1 = str.find(L";", pos0 + 1);
			if (pos1 >= 0)right = str.mid(pos1, 99999);
			str = left + right;
		}
		dw_obj.SetItemString(row, 0, str);
		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 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 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 LastRow = dw_cell.GetValidRow();
		xstring content = L"";

		xstring sdate = publiccode::GetCurrentDate();
		for (int row = startRow; row <= LastRow; row++)
		{
			if (dw_cell.GetItemString(row, colItemName) == L"" &&
				dw_cell.GetItemString(row, colItemSpec) == L"") break;

			xstring itemStr = L"";
			itemStr += L"<RowID>" + getRowID(dw_cell, row) + L"</RowID>";
			itemStr += L"<ItemNo>" + dw_cell.GetItemString(row, colItemNo) + L"</ItemNo>";
			itemStr += L"<CustomerItemNo>" + dw_cell.GetItemString(row, colCustomerItemNo) + L"</CustomerItemNo>";
			itemStr += L"<ItemName>" + dw_cell.GetItemString(row, colItemName) + L"</ItemName>";
			itemStr += L"<ItemCName>" + dw_cell.GetItemString(row, colItemCName) + L"</ItemCName>";
			itemStr += L"<ItemSpec>" + dw_cell.GetItemString(row, colItemSpec) + L"</ItemSpec>";
			itemStr += L"<BuyerPrice>" + dw_cell.GetItemString(row, colBuyerPrice) + L"</BuyerPrice>";
			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, 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"")
			{
				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>";
			itemStr += L"<GWT>" + dw_cell.GetItemString(row, colGWT) + L"</GWT>";
			itemStr += L"<NWT>" + dw_cell.GetItemString(row, colNWT) + L"</NWT>";
			itemStr += L"<VolDesc>" + dw_cell.GetItemString(row, colVolDesc) + L"</VolDesc>";
			itemStr += L"<Vol>" + dw_cell.GetItemString(row, colVol) + L"</Vol>";
			itemStr += L"<F40HQ>" + dw_cell.GetItemString(row, col40HQ) + L"</F40HQ>";

			itemStr += L"<PurchedDate>" + sdate + L"</PurchedDate>";
			itemStr += L"<EnquiryLineID>" + getRowTerm(dw_cell, row, L"EnquiryLineID") + L"</EnquiryLineID>";
			content += L"<Item>" + itemStr + L"</Item>";
		}
		xstring newEntityItemID = ViewObject::GetGuid();
		content = L"<data id='" + entityID + L"' itemid='" + newEntityItemID + L"' action='purched'>" + content + L"</data>";

		return content;
	}

	int ProcessSendMessage(xstring myurl, xstring param, xstring content, xstring datacontent, bool balert = false)
	{
		xaserverarg	 arg ;
		arg.setNativePointer(xaserverarg::CreateInstance());
		arg.AddArg(L"myurl", myurl);
		arg.AddArg(L"param", param);
		arg.AddArg(L"content", content);
		arg.AddArg(L"datacontent", datacontent);

		//trace(content);

		xml x ;
		
		if (xurl::get(L"/sale/data/Thing/business/message/add", arg.GetString(), x) != 1)
		{
			xstring error = x.text();
			if (balert)alert((xstring)L"error:" + x.xml());
			trace(error);
			return -1;
		}
		else
		{
			//trace(x.xml());
			if (balert)
				alert(x.text());
		}
		return 1;
	}

	int makeMessage(xstring myurl)
	{
		if (myurl == L"/task/quote/purchar/backtosaler")
		{
			xstring content = makeMessageBacktoSaler(myurl);
			xstring datacontent = GetSaleFullData(dw_cell);
			if (content.left(1) != L"<")
			{
				alert(content);
				return 1;
			}
			if (content != L"") return  ProcessSendMessage(myurl, L"", content, datacontent, true);
			return 1;
		}
		return 1;
	}

	int SendToPurcher(xstring purchor, xstring content)
	{
		xstring empno;
		KXMLDOMNode n = purcher.selectSingleNode(L"//HrEmployee[Name='" + purchor + L"']/UserNo");
		if (n)empno = n.text();
		if (empno == L"") return 1;
		//trace(L"\r\npurchor:"+empno);

		xstring newItemID = ViewObject::GetGuid();
		xstring business = L"";
		content = content.mid(content.find(L"<xsheet"), 9999999);
		business = L"<business action='purch' id='" + entityID + L"' itemid='" + newItemID + L"' processurl='" + processurl + L"' purchor.name='" + purchor + L"' purchor.no='" + empno + L"' termid='" + templateID + L"'>";
		business += L"<content>" + content + L"</content></business>";

		xcell dw_cell1 = GetControl(L"dw_cell1");
		xstring datacontent = GetSaleFullData(dw_cell1);

		//trace(datacontent);
		int ret = ProcessSendMessage(L"/task/quote/purch", L"", business, datacontent, true);
		return ret;

		/*
		//ThingImpl:AddTask1($FlowID,$EntityID,$EntityNo,$Subject, $Content,$Status, $Category,$Reciever)
		xml x ;
		
		xaserverarg arg ;
		arg.setNativePointer(xaserverarg::CreateInstance());

		xstring empno;
		KXMLDOMNode n = purcher.selectSingleNode(L"//HrEmployee[Name='"+purchor+L"']/UserNo");
		if(n)empno=n.text();
		if(empno==L"") return 1;
		trace(L"\r\npurchor:"+empno);

		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"Content",content);
		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"发送出错了!");
			return -1;
		}else
		{
			if(x.xml().find(L"error")>=0)
			{
				alert(L"发送出错了!"+x.xml());
				return -1;
			}
			trace(x.xml());
		}
		trace(L"\r\n"+L"询价单已发送给"+purchor);

		return 1;
		*/
	}

	xstring GetPurchedItems()
	{
		int row = 1;
		int startRow = getItemHeadRow(dw_cell);
		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 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 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 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"采购部产品信息");

		xstring items = L"<data>";
		int LastRow = dw_cell.GetValidRow();
		xstring content = L"";

		for (row = startRow; row <= LastRow; row++)
		{
			if (dw_cell.GetItemString(row, colItemName) == L"" &&
				dw_cell.GetItemString(row, colItemSpec) == L"") break;
			ensureRowID(dw_cell, row);

			xstring itemStr = L"";
			xstring issend = L"1";
			itemStr += L"<RowID>" + getRowID(dw_cell, row) + L"</RowID>";
			itemStr += L"<ItemNo>" + dw_cell.GetItemString(row, colItemNo) + L"</ItemNo>";
			itemStr += L"<ItemName>" + dw_cell.GetItemString(row, colItemName) + L"</ItemName>";
			itemStr += L"<ItemCName>" + dw_cell.GetItemString(row, colItemCName) + L"</ItemCName>";
			itemStr += L"<ItemSpec>" + dw_cell.GetItemString(row, colItemSpec) + L"</ItemSpec>";
			itemStr += L"<RowNo>" + (row - startRow + 1).toString() + L"</RowNo>";
			itemStr += L"<Purchor>" + dw_cell.GetItemString(row, colBuyer) + L"</Purchor>";
			itemStr += L"<Package>" + dw_cell.GetItemString(row, colPackage) + L"</Package>";
			itemStr += L"<NWT>" + dw_cell.GetItemString(row, colNW) + L"</NWT>";
			itemStr += L"<GWT>" + dw_cell.GetItemString(row, colGW) + L"</GWT>";
			itemStr += L"<VolDesc>" + dw_cell.GetItemString(row, colVolDesc) + L"</VolDesc>";
			itemStr += L"<Supplier>" + dw_cell.GetItemString(row, colSupplier) + L"</Supplier>";
			itemStr += L"<BuyPrice>" + dw_cell.GetItemString(row, colPOPrice) + L"</BuyPrice>";
			itemStr += L"<Supplier1>" + dw_cell.GetItemString(row, colSupplier1) + L"</Supplier1>";
			itemStr += L"<BuyPrice1>" + dw_cell.GetItemString(row, colPOPrice1) + L"</BuyPrice1>";
			itemStr += L"<BOMType1>" + dw_cell.GetItemString(row, colBOMType1) + L"</BOMType1>";
			itemStr += L"<BOMType>" + dw_cell.GetItemString(row, colBOMType) + L"</BOMType>";
			itemStr += L"<POPrice>" + dw_cell.GetItemString(row, colPrice) + L"</POPrice>";
			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, colBuyer) == L"")issend = L"0";
			itemStr += L"<IsSend>" + issend + L"</IsSend>";

			items += L"<Item>" + itemStr + L"</Item>";
		}
		items += L"</data>";

		return items;
	}

	xstring GetPurchItems()
	{
		int row = 1;
		int startRow = getItemHeadRow(dw_cell);
		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 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 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 colProductInfo = getItemCol(dw_cell, startRow - 1, L"业务部产品信息");
		int colProductInfo1 = getItemCol(dw_cell, startRow - 1, L"采购部产品信息");

		xstring items = L"<data>";
		int LastRow = dw_cell.GetValidRow();
		xstring content = L"";

		for (row = startRow; row <= LastRow; row++)
		{
			if (dw_cell.GetItemString(row, colItemName) == L"" &&
				dw_cell.GetItemString(row, colItemSpec) == L"") break;
			ensureRowID(dw_cell, row);

			xstring itemStr = L"";
			xstring issend = L"1";
			itemStr += L"<RowID>" + getRowID(dw_cell, row) + L"</RowID>";
			itemStr += L"<ItemNo>" + dw_cell.GetItemString(row, colItemNo) + L"</ItemNo>";
			itemStr += L"<CustomerItemNo>" + dw_cell.GetItemString(row, colCustomerItemNo) + L"</CustomerItemNo>";
			itemStr += L"<ItemName>" + dw_cell.GetItemString(row, colItemName) + L"</ItemName>";
			itemStr += L"<ItemCName>" + dw_cell.GetItemString(row, colItemCName) + L"</ItemCName>";
			itemStr += L"<ItemSpec>" + dw_cell.GetItemString(row, colItemSpec) + L"</ItemSpec>";
			itemStr += L"<RowNo>" + xstring(row - startRow + 1) + L"</RowNo>";
			itemStr += L"<Purchor>" + dw_cell.GetItemString(row, colBuyer) + L"</Purchor>";
			itemStr += L"<Package>" + dw_cell.GetItemString(row, colPackage) + L"</Package>";
			itemStr += L"<NWT>" + dw_cell.GetItemString(row, colNW) + L"</NWT>";
			itemStr += L"<GWT>" + dw_cell.GetItemString(row, colGW) + L"</GWT>";
			itemStr += L"<VolDesc>" + dw_cell.GetItemString(row, colVolDesc) + L"</VolDesc>";
			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, colBuyer) == L"")issend = L"0";
			itemStr += L"<IsSend>" + issend + L"</IsSend>";

			items += L"<Item>" + itemStr + L"</Item>";
		}
		items += L"</data>";

		return items;
	}

	/*
	xstring GetPurchedItems()
	{
		int row = 1;
		int startRow = getItemHeadRow(dw_cell);
		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 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 col40HQ= getItemCol(dw_cell,startRow - 1,L"40HQ,QTY(40HQ)L");
		int colBuyer = getItemCol(dw_cell,startRow - 1,L"采购人员");

		xstring items=L"<data>";
		int LastRow = dw_cell.GetValidRow();
		xstring content = L"";

		for(row = startRow; row <=LastRow; row++)
		{
			if(dw_cell.GetItemString(row,colItemName)==L"" &&
				dw_cell.GetItemString(row,colItemSpec)==L"") break;
			ensureRowID(dw_cell,row);

			xstring itemStr = L"";
			xstring issend=L"1";
			itemStr += L"<RowID>"+getRowID(dw_cell,row)+L"</RowID>";
			itemStr += L"<ItemNo>"+dw_cell.GetItemString(row, colItemNo)+L"</ItemNo>";
			itemStr += L"<ItemName>"+dw_cell.GetItemString(row, colItemName)+L"</ItemName>";
			itemStr += L"<ItemCName>"+dw_cell.GetItemString(row, colItemCName)+L"</ItemCName>";
			itemStr += L"<ItemSpec>"+dw_cell.GetItemString(row, colItemSpec)+L"</ItemSpec>";
			itemStr += L"<RowNo>"+(row - startRow +1).toString()+L"</RowNo>";
			itemStr += L"<Purchor>"+dw_cell.GetItemString(row, colBuyer)+L"</Purchor>";
			itemStr += L"<Package>"+dw_cell.GetItemString(row, colPackage)+L"</Package>";
			if(dw_cell.GetItemString(row, colBuyer) ==L"")issend=L"0";
			itemStr += L"<IsSend>"+issend+L"</IsSend>";

			items += L"<Item>"+itemStr+L"</Item>";
		}
		items += L"</data>";

		return items;
	}
	*/

	int OnSaleBack()
	{
		xstring str;
		xstring head;
		int rowCount = dw_cell.GetRowCount();
		int row = 1;
		int headrow = 0;
		for (row = 1; row <= rowCount; row++)
		{
			head = dw_cell.GetItemString(row, 1);
			if (head == L"SKUID") break;
		}

		if (row >= rowCount)
		{
			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 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 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 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;

		int backedcount = 0;
		for (row = startRow; row <= LastRow; row++)
		{
			if (getRowID(dw_cell, row) == L"") continue;
			if (dw_cell.GetItemString(row, colItemName) == L"")continue;

			if (dw_cell.GetItemString(row, colSupplier) == L"" && dw_cell.GetItemString(row, colBuyerPrice) == L"") continue;
			count++;

			/*
			if(dw_cell.GetItemString(row, colBuyerPrice)==L"")
			{
				alert(L"采购价格没有录入");
				return 1;
			}
			if(dw_cell.GetItemString(row, colGWT)==L"")
			{
				alert(L"毛重没有录入");
				return 1;
			}
			if(dw_cell.GetItemString(row, colNWT)==L"")
			{
				alert(L"净重没有录入");
				return 1;
			}
			if(dw_cell.GetItemString(row, colVolDesc)==L"")
			{
				alert(L"长X宽X高没有录入");
				return 1;
			}
			if(dw_cell.GetItemString(row, colFactoryImage)==L"")
			{
				alert(L"工厂图片没有录入");
				return 1;
			}
			if(dw_cell.GetItemString(row, colSupplier)==L"")
			{
				alert(L"供应商没有录入");
				return 1;
			}
			if(dw_cell.GetItemString(row, colPOPrice)==L"")
			{
				alert(L"采购价格没有录入");
				return 1;
			}*/

			/*
			if(dw_cell.GetItemString(row, colPOPrice1)!=L"")
			{
				if(dw_cell.GetItemString(row, colSupplier1)==L"")
				{
					alert(L"供应商1没有录入");
					return 1;
				}
			}
			if(dw_cell.GetItemString(row, colSupplier1)!=L"")
			{
				if(dw_cell.GetItemString(row, colPOPrice1)==L"")
				{
					alert(L"采购价格1没有录入");
					return 1;
				}
			}*/
		}
		if (count < 1) return 1;

		int col = 0;
		int namecol = 0;
		int pricecol = 0;
		int purchremarkcol = 0;
		int purchercol = 0;

		int colCount = dw_cell.GetValidCol(row);
		for (col = 1; col <= colCount; col++)
		{
			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;
		}

		xstring items = GetPurchedItems();
		xaserverarg arg4 ;
		arg4.setNativePointer(xaserverarg::CreateInstance());
		trace(items);
		arg4.AddArg(L"value", items);
		OpenWindow(L"dev:xpage[QuoteFilePurched.vx]", cast(arg4 as int));

		if (arg4.GetArgString(L"process") != L"ok") return 1;
		items = arg4.GetArgString(L"value");

		xml x0 ;
		x0.setNativePointer(xml::CreateInstance());
		x0.loadXML(items);

		KXMLDOMNodeList ts = x0.selectNodes(L"data/Item[IsSend='1']");
		int len = ts.length();
		if (len < 1) return L"";

		xstring content = L"";
		xstring sdate = publiccode::GetCurrentDate();
		for (int k = 0; k < len; k++)
		{
			KXMLDOMNode node = ts.item(k);
			xstring id = node.selectSingleNode(L"RowID").text();
			row = LookupCellRow(id);
			if (row < 1) continue;

			if (dw_cell.GetItemString(row, colBuyerPrice) == L"")
			{
				alert(L"采购价格没有录入");
				return 1;
			}
			if (dw_cell.GetItemString(row, colGWT) == L"")
			{
				alert(L"毛重没有录入");
				return 1;
			}
			if (dw_cell.GetItemString(row, colNWT) == L"")
			{
				alert(L"净重没有录入");
				return 1;
			}
			if (dw_cell.GetItemString(row, colVolDesc) == L"")
			{
				alert(L"长X宽X高没有录入");
				return 1;
			}
			if (dw_cell.GetItemString(row, colFactoryImage) == L"")
			{
				alert(L"工厂图片没有录入");
				return 1;
			}
			if (dw_cell.GetItemString(row, colSupplier) == L"")
			{
				alert(L"供应商没有录入");
				return 1;
			}
			if (dw_cell.GetItemString(row, colPOPrice) == L"")
			{
				alert(L"采购价格没有录入");
				return 1;
			}

			//if(getRowID(dw_cell,row)==L"") continue;
			//if(dw_cell.GetItemString(row, colItemName)==L"")continue;
			xstring itemStr = L"";
			itemStr += L"<RowID>" + getRowID(dw_cell, row) + L"</RowID>";
			itemStr += L"<ItemNo>" + dw_cell.GetItemString(row, colItemNo) + L"</ItemNo>";
			itemStr += L"<ItemName>" + dw_cell.GetItemString(row, colItemName) + L"</ItemName>";
			itemStr += L"<ItemCName>" + dw_cell.GetItemString(row, colItemCName) + L"</ItemCName>";
			itemStr += L"<ItemSpec>" + dw_cell.GetItemString(row, colItemSpec) + L"</ItemSpec>";
			itemStr += L"<BuyerPrice>" + dw_cell.GetItemString(row, colBuyerPrice) + L"</BuyerPrice>";
			itemStr += L"<ProductInfo>" + dw_cell.GetItemString(row, colProductInfo) + L"</ProductInfo>";
			itemStr += L"<ProductInfo1>" + dw_cell.GetItemString(row, colProductInfo1) + L"</ProductInfo1>";
			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, 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"")
			{
				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, colNWT)!=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"体积信息没有录入";
			}
			*/
			itemStr += L"<BuyerRemark>" + dw_cell.GetItemString(row, colBuyerRemark) + L"</BuyerRemark>";
			itemStr += L"<FactoryImage>" + dw_cell.GetItemString(row, colFactoryImage) + L"</FactoryImage>";
			itemStr += L"<GWT>" + dw_cell.GetItemString(row, colGWT) + L"</GWT>";
			itemStr += L"<NWT>" + dw_cell.GetItemString(row, colNWT) + L"</NWT>";
			itemStr += L"<VolDesc>" + dw_cell.GetItemString(row, colVolDesc) + L"</VolDesc>";
			itemStr += L"<Vol>" + dw_cell.GetItemString(row, colVol) + L"</Vol>";
			itemStr += L"<F40HQ>" + dw_cell.GetItemString(row, col40HQ) + L"</F40HQ>";

			itemStr += L"<PurchedDate>" + sdate + L"</PurchedDate>";
			itemStr += L"<supplier-photo>" + getRowTerm(dw_cell, row, L"supplier-photo") + L"</supplier-photo>";

			xstring eid = GetGuid();
			setRowTerm(dw_cell, row, L"EnquiryLineID", eid);
			//alert(eid +L" "+ getRowTerm(dw_cell,row,L"EnquiryLineID"));
			itemStr += L"<EnquiryLineID>" + eid + L"</EnquiryLineID>";
			content += L"<Item>" + itemStr + L"</Item>";

			dw_cell.SetItemString(row, colSalebackDate, sdate);
		}

		xstring finished = L"1";
		for (row = startRow; row <= LastRow; row++)
		{
			if (getRowID(dw_cell, row) == L"") continue;
			if (dw_cell.GetItemString(row, colItemName) == L"")continue;
			if (dw_cell.GetItemString(row, colSalebackDate) == L"")
			{
				finished = L"0";
				break;
			}
		}

		//trace(L"\r\n******11"+sdate);
		xstring newEntityItemID = ViewObject::GetGuid();
		xstring datacontent = GetSaleFullData(dw_cell, ts);

		content = L"<data id='" + entityID + L"' itemid='" + newEntityItemID + L"' itemid.piror='" + entityItemID + L"' action='purched' taskid='" + taskid + L"' finished='" + finished + L"'>" + content + L"</data>";
		xstring myurl = L"/task/quote/purchar/backtosaler";
		if (content != L"")
		{
			trace(L"\r\ntaskid:" + taskid + L" finished:" + finished);
			ProcessSendMessage(myurl, L"", content, datacontent, true);
			win32::PostMessage(GetFrameWindow().GetHWND(), 0x401, L"xmRefreshTask", 0);
		}

		return 1;
	}

	int OnPurchEx()
	{
		xstring str;
		xstring head;
		int rowCount = dw_cell.GetRowCount();
		int row = 1;
		int headrow = 0;
		for (row = 1; row <= rowCount; row++)
		{
			head = dw_cell.GetItemString(row, 1);
			if (head == L"SKUID") break;
		}

		if (row >= rowCount)
		{
			alert(L"找不到商品行!");
			return 1;
		}

		headrow = row;
		int startRow = headrow + 1;
		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 col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L");
		int colInnerOuter = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)L");
		int col = 0;
		int namecol = 0;
		int pricecol = 0;
		int purchremarkcol = 0;
		int purchercol = 0;

		int colCount = dw_cell.GetValidCol(row);
		for (col = 1; col <= colCount; col++)
		{
			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 (purchercol == 0)
		{
			alert(L"找不到采购人员数据!");
			return 1;
		}

		xstring items = GetPurchItems();
		xaserverarg arg4 ;
		arg4.setNativePointer(xaserverarg::CreateInstance());
		trace(items);
		arg4.AddArg(L"value", items);
		OpenWindow(L"dev:xpage[QuoteFilePurch.vx]", cast(arg4 as int));
		if (arg4.GetArgString(L"process") != L"ok") return 1;
		items = arg4.GetArgString(L"value");

		return 1;
	}

	int OnNextPurch()
	{
		//dw_cell.AcceptText();

		xstring str;
		xstring head;
		int rowCount = dw_cell.GetValidRow();
		int row = 1;
		int headrow = 0;
		for (row = 1; row <= rowCount; row++)
		{
			head = dw_cell.GetItemString(row, 1);
			if (head == L"SKUID") break;
		}

		if (row >= rowCount)
		{
			alert(L"找不到商品行!");
			return 1;
		}

		headrow = row;
		int startRow = headrow + 1;
		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 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 col = 0;
		int namecol = 0;
		int pricecol = 0;
		int purchremarkcol = 0;
		int purchercol = 0;

		int colCount = dw_cell.GetValidCol(row);
		for (col = 1; col <= colCount; col++)
		{
			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 (purchercol == 0)
		{
			alert(L"找不到采购人员数据!");
			return 1;
		}

		xstring strs = L",L";
		row++;

		int colCustomerPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo");
		int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式");

		while (row <= rowCount)
		{
			str = dw_cell.GetItemString(row, purchercol);
			if (str == L"")break;

			//ensureRowID(dw_cell,row);
			if (strs.find(L",L" + str + L",L") < 0)
			{
				if (purcher.selectSingleNode(L"//Name[.='" + str + L"']"))
				{
					strs += str + L",L";
				}
				else
				{
					alert(L"没有采购员：" + str);
					return 1;
				}
			}
			row++;
		}
		if (strs == L",L")
		{
			alert(L"请指定采购人员!");
			return 1;
		}

		xstring items = GetPurchItems();
		xaserverarg arg4 ;
		arg4.setNativePointer(xaserverarg::CreateInstance());
		arg4.AddArg(L"value", items);
		OpenWindow(L"dev:xpage[QuoteFilePurch.vx]", cast(arg4 as int));
		if (arg4.GetArgString(L"process") != L"ok") return 1;
		items = arg4.GetArgString(L"value");

		xml x0 ;
		x0.setNativePointer(xml::CreateInstance());
		x0.loadXML(items);
		KXMLDOMNodeList ts1 = x0.selectNodes(L"data/Item");
		int len1 = ts1.length();
		for (int m = 0; m < len1; m++)
		{
			KXMLDOMNode node = ts1.item(m);
			xstring rowno = L"";
			xstring purchar = L"";
			if (node.selectSingleNode(L"RowNo")) rowno = node.selectSingleNode(L"RowNo").text();
			if (node.selectSingleNode(L"Purchor")) purchar = node.selectSingleNode(L"Purchor").text();
			//alert( rowno+L" "+ node.xml);
			if (rowno != L"")
			{
				int row1 = headrow + rowno.toInt();
				if (dw_cell.GetItemString(row1, purchercol) != purchar)
				{
					dw_cell.SetItemString(row1, purchercol, purchar);
				}
			}
		}

		row = headrow + 1;
		strs = L"";
		while (row <= rowCount)
		{
			str = dw_cell.GetItemString(row, purchercol);
			if (str == L"")break;

			if (strs.find(L",L" + str + L",L") < 0)
			{
				if (purcher.selectSingleNode(L"//Name[.='" + str + L"']"))
				{
					strs += str + L",L";
				}
				else
				{
					alert(L"没有采购员：" + str);
					return 1;
				}
			}
			row++;
		}
		//return 1;

		xstring cellstr = dw_cell.GetData();
		xcell cell1 = GetControl(L"dw_cell1");
		xml x ;
		

		if (strs.left(1) == L",L") strs = strs.mid(1, 9999);
		if (strs.right(1) == L",L") strs = strs.left(strs.length() - 1);

		xstring purchors = strs;

		xstring supplier;
		if (strs.find(L",L", 0) > 0)
		{
			supplier = strs.left(strs.find(L",L", 0));
			strs = strs.mid(strs.find(L",L", 0) + 1, 9999);
		}
		else
		{
			supplier = strs;
			strs = L"";
		}

		xstring username = publiccode::GetUser().name;

		while (supplier != L"")
		{
			KXMLDOMNodeList ts = x0.selectNodes(L"data/Item[IsSend='1' and Purchor='" + supplier + L"']");
			int len = ts.length();
			if (supplier == username)  len = 0;
			if (len < 1)
			{
				if (strs.find(L",L", 0) > 0)
				{
					supplier = strs.left(strs.find(L",L", 0));
					strs = strs.mid(strs.find(L",L", 0) + 1, 9999);
				}
				else
				{
					supplier = strs;
					strs = L"";
				}
				continue;
			}
			x.loadXML(cellstr);
			cell1.LoadTemplate(x);
			cell1.Redraw();

			row = headrow + 1;
			int cnt = 1;
			while (true)
			{
				str = L"";
				str = cell1.GetItemString(row, purchercol);
				if (str == L"")break;
				if (str != supplier)
				{
					cell1.SetRowColumn(row, 1);
					cell1.SetAnchorRowColumn(row, 1);
					SendCtrlCmd(cell1, L"xmFormatCellDeleteRow");
				}
				else
				{
					KXMLDOMNode n = x0.selectSingleNode(L"data/Item[IsSend='1' and Purchor='" + supplier + L"' and RowNo='" + xstring(cnt) + L"']");
					if (!n)
					{
						cell1.SetRowColumn(row, 1);
						cell1.SetAnchorRowColumn(row, 1);
						SendCtrlCmd(cell1, L"xmFormatCellDeleteRow");
					}
					else
					{
						row = row + 1;
					}
				}
				cnt++;
				if (cnt > 512)break;
			}

			cell1.SetRowColumn(1, 1);
			cell1.SetAnchorRowColumn(1, 1);

			row = headrow + 1;
			rowCount = cell1.GetValidRow();


			if (SendToPurcher(supplier, cell1.GetData()) == -1) return 1;
			if (strs.find(L",L", 0) > 0)
			{
				supplier = strs.left(strs.find(L",L", 0));
				strs = strs.mid(strs.find(L",L", 0) + 1, 9999);
			}
			else
			{
				supplier = strs;
				strs = L"";
			}
		}

		//update purch
		if (1 == 0)
		{
			//trace(L"\r\nentityID:"+entityID);
			xml x2 = ViewObject::RetrieveData(L"/sale/data/TO/business/documententity", L"BusinessID", entityID);
			if (x2)
			{
				//trace(x2.GetXml());
				cell1.LoadTemplate(x2);
				cell1.Redraw();
			}
			else
			{
				alert(L"出现错误");
				return 1;
			}

			xstring head1;
			int rowCount1 = cell1.GetValidRow();
			int row2 = 1;
			int headrow1 = 0;
			int startrow1 = 0;
			for (row2 = 1; row2 <= rowCount1; row2++)
			{
				head1 = cell1.GetItemString(row2, 1);
				if (head1 == L"SKUID") break;
			}

			headrow1 = row2;
			startrow1 = headrow1 + 1;
			int purchercol1 = getItemCol(cell1, headrow1, L"采购人员");
		}

		//Clear
		if (1 == 1)
		{
			row = headrow + 1;
			strs = L"";
			while (row <= rowCount)
			{
				str = dw_cell.GetItemString(row, purchercol);
				if (str == L"")break;
				row++;
			}
			int lastrow = row - 1;
			row = headrow + 1;
			int drow = 0;
			while (lastrow >= row)
			{
				supplier = L"";
				supplier = dw_cell.GetItemString(lastrow, purchercol);
				if (supplier != username)
				{
					KXMLDOMNode n1 = x0.selectSingleNode(L"data/Item[IsSend='1' and Purchor='" + supplier + L"' and RowNo='" + (lastrow - row + 1).toString() + L"']");
					if (n1)
					{
						xstring rowid = getRowID(dw_cell, lastrow);
						int frow = LookupCellRow(rowid);
						if (0 == 1)
						{
							if (drow > 0)cell1.SetItemString(frow, purchercol1, supplier);
						}
						dw_cell.SetRowColumn(lastrow, 1);
						dw_cell.SetAnchorRowColumn(lastrow, 1);
						SendCtrlCmd(dw_cell, L"xmFormatCellDeleteRow");
						drow++;
					}
				}
				lastrow--;
			}
		}

		xstring finished = L"1";
		for (row = startRow; row <= rowCount; row++)
		{
			if (getRowID(dw_cell, row) == L"") continue;
			if (dw_cell.GetItemString(row, colItemName) == L"")continue;
			if (dw_cell.GetItemString(row, colSalebackDate) == L"")
			{
				finished = L"0";
				break;
			}
		}

		if (0 == 1)OnUpdateEntityFile();
		OnUpdate();

		if (finished == L"1")
		{
			OnUpdateProcessed();
			alert(L"xxxxx");
		}

		//OnSaveEx(true);
		//alert(L"询价信息已发送给:"+purchors);
		return 1;
	}

	int OnPurch()
	{
		xstring str;
		xstring head;
		int rowCount = dw_cell.GetRowCount();
		int row = 1;
		int headrow = 0;
		for (row = 1; row <= rowCount; row++)
		{
			head = dw_cell.GetItemString(row, 1);
			if (head == L"SKUID") break;
		}

		if (dw_base.GetItemString(1, L"CustomerID") == L"")
		{
			alert(L"请输入报价的客户!");
			return 1;
		}

		if (row >= rowCount)
		{
			alert(L"找不到商品行!");
			return 1;
		}

		if (getBaseItem(dw_cell, L"报价截止日期：") == L"")
		{
			if (getBaseItem(dw_cell, L"报价截止日期:") == L"")
			{
				alert(L"报价截止日期未输入!");
				return 1;
			}
		}

		if (getBaseItem(dw_cell, L"项目名称:") == L"")
		{
			if (getBaseItem(dw_cell, L"项目名称：") == L"")
			{
				alert(L"项目名称未输入!");
				return 1;
			}
		}

		headrow = row;
		int startRow = headrow + 1;
		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 col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L");
		int colInnerOuter = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外)L");

		int col = 0;
		int namecol = 0;
		int pricecol = 0;
		int purchremarkcol = 0;
		int purchercol = 0;

		int colCount = dw_cell.GetValidCol(row);
		for (col = 1; col <= colCount; col++)
		{
			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 (purchercol == 0)
		{
			alert(L"找不到采购人员数据!");
			return 1;
		}

		xstring strs = L",L";
		row++;

		int colCustomerPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo");
		int colPackage = getItemCol(dw_cell, startRow - 1, L"Package,包装方式");

		while (row <= rowCount)
		{
			str = dw_cell.GetItemString(row, purchercol);
			if (str == L"")break;

			/*if(dw_cell.GetItemString(row,colCustomerItemNo)==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"行请输入产品名称!");
				return 1;
			}
			if (dw_cell.GetItemString(row, colPackage) == L"")
			{
				alert(L"第" + xstring(row) + L"行请输入产品包装方式!");
				return 1;
			}
			if (dw_cell.GetItemString(row, colCustomerPhoto) == L"")
			{
				alert(L"第" + xstring(row) + L"行请选择客户图片!");
				return 1;
			}
			if (dw_cell.GetItemString(row, colInnerOuter) == L"")
			{
				alert(L"第" + xstring(row) + L"行请录入内外箱装数!");
				return 1;
			}
			/*if(dw_cell.GetItemString(row,col40HQ)==L"")
			{
				alert(L"第"+xstring(row)+L"行40HQ的数据是空的!");
				return 1;
			}*/

			/*if(dw_cell.GetItemString(row,colItemQty)==L"")
			{
				alert(L"第"+xstring(row)+L"行数量是空的!");
				return 1;
			}*/

			ensureRowID(dw_cell, row);
			if (strs.find(L",L" + str + L",L") < 0)
			{
				if (purcher.selectSingleNode(L"//Name[.='" + str + L"']"))
				{
					strs += str + L",L";
				}
				else
				{
					alert(L"没有采购员：" + str);
					return 1;
				}
			}
			row++;
		}
		if (strs == L",L")
		{
			alert(L"找不到采购人员数据!");
			return 1;
		}

		xstring items = GetPurchItems();
		xaserverarg arg4 ;
		arg4.setNativePointer(xaserverarg::CreateInstance());
		trace(items);
		arg4.AddArg(L"value", items);
		OpenWindow(L"dev:xpage[QuoteFilePurch.vx]", cast(arg4 as int));
		if (arg4.GetArgString(L"process") != L"ok") return 1;
		items = arg4.GetArgString(L"value");

		xstring cellstr = dw_cell.GetData();
		xcell cell1 = GetControl(L"dw_cell1");
		xml x ;
		

		if (strs.left(1) == L",L") strs = strs.mid(1, 9999);
		if (strs.right(1) == L",L") strs = strs.left(strs.length() - 1);

		xstring purchors = strs;

		xstring supplier;
		if (strs.find(L",L", 0) > 0)
		{
			supplier = strs.left(strs.find(L",L", 0));
			strs = strs.mid(strs.find(L",L", 0) + 1, 9999);
		}
		else
		{
			supplier = strs;
			strs = L"";
		}

		xml x0 ;
		x0.setNativePointer(xml::CreateInstance());
		x0.loadXML(items);

		while (supplier != L"")
		{
			KXMLDOMNodeList ts = x0.selectNodes(L"data/Item[IsSend='1' and Purchor='" + supplier + L"']");
			int len = ts.length();
			if (len < 1)
			{
				if (strs.find(L",L", 0) > 0)
				{
					supplier = strs.left(strs.find(L",L", 0));
					strs = strs.mid(strs.find(L",L", 0) + 1, 9999);
				}
				else
				{
					supplier = strs;
					strs = L"";
				}
				continue;
			}
			x.loadXML(cellstr);
			cell1.LoadTemplate(x);
			cell1.Redraw();

			row = headrow + 1;
			int cnt = 1;
			while (true)
			{
				str = L"";
				str = cell1.GetItemString(row, purchercol);
				if (str == L"")break;
				if (str != supplier)
				{
					cell1.SetRowColumn(row, 1);
					cell1.SetAnchorRowColumn(row, 1);
					SendCtrlCmd(cell1, L"xmFormatCellDeleteRow");
				}
				else
				{
					trace(L"\r\ndata/Item[IsSend='1' and Purchor='" + supplier + L"' and RowNo='" + xstring(cnt) + L"']");
					KXMLDOMNode n = x0.selectSingleNode(L"data/Item[IsSend='1' and Purchor='" + supplier + L"' and RowNo='" + xstring(cnt) + L"']");
					if (!n)
					{
						cell1.SetRowColumn(row, 1);
						cell1.SetAnchorRowColumn(row, 1);
						SendCtrlCmd(cell1, L"xmFormatCellDeleteRow");
					}
					else
					{
						if (colItemPurchDate > 0)
						{
							xstring sdate = publiccode::GetCurrentDate();
							dw_cell.SetItemString(headrow + cnt, colItemPurchDate, sdate);
							cell1.SetItemString(row, colItemPurchDate, sdate);
							dw_cell.Redraw();
						}
						row = row + 1;
					}
				}
				cnt++;
				if (cnt > 512)break;
			}

			if (pricecol > 0)
			{

				cell1.SetRowColumn(1, purchercol);
				cell1.SetAnchorRowColumn(1, purchercol);
				SendCtrlCmd(cell1, L"xmFormatCellInsertCol");
				cell1.SetItemString(headrow, purchercol, L"业务员");

				cell1.SetRowColumn(1, pricecol);
				cell1.SetAnchorRowColumn(1, pricecol);
				SendCtrlCmd(cell1, L"xmFormatCellDeleteCol");


				cell1.SetRowColumn(1, purchremarkcol + 1);
				cell1.SetAnchorRowColumn(1, purchremarkcol + 1);
				SendCtrlCmd(cell1, L"xmFormatCellInsertCol");
				SendCtrlCmd(cell1, L"xmFormatCellInsertCol");
				SendCtrlCmd(cell1, L"xmFormatCellInsertCol");
				SendCtrlCmd(cell1, L"xmFormatCellInsertCol");
				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");

				int colRemark = getItemCol(cell1, headrow, L"Remarks");
				cell1.SetRowColumn(1, colRemark);
				cell1.SetAnchorRowColumn(1, colRemark);
				SendCtrlCmd(cell1, L"xmFormatCellDeleteCol");
			}
			cell1.SetRowColumn(1, 1);
			cell1.SetAnchorRowColumn(1, 1);

			row = headrow + 1;
			rowCount = cell1.GetValidRow();
			while (row <= rowCount)
			{
				str = cell1.GetItemString(row, purchercol);
				if (str == L"")break;
				xstring susername = publiccode::GetUser().name;
				cell1.SetItemString(row, purchercol - 1, susername);
				row++;
			}

			if (SendToPurcher(supplier, cell1.GetData()) == -1) return 1;
			if (strs.find(L",L", 0) > 0)
			{
				supplier = strs.left(strs.find(L",L", 0));
				strs = strs.mid(strs.find(L",L", 0) + 1, 9999);
			}
			else
			{
				supplier = strs;
				strs = L"";
			}

		}
		OnUpdate();
		//OnSaveEx(true);
		//alert(L"询价信息已发送给:"+purchors);

		return 1;
	}

	//焦点激活处理函数
	int OnSetFocus(TEvent* evt, LPARAM param)
	{
		//重置工具条
		SetAgent();
		return 1;
	}

	int OpenTemplate(xstring id)
	{
		xml x = ViewObject::RetrieveData(L"/sale/data/TO/template/param", L"TemplateID", id);

		xml sheet ;
		sheet.loadXML(x.selectSingleNode(L"data/*").xml);

		dw_cell.LoadTemplate(sheet);
		dw_cell.Redraw();

		return 1;
	}

	int OpenDocument(xstring id)
	{
		trace(L"BusinessItemID:" + id);
		xml x = ViewObject::RetrieveData(L"/sale/data/TO/business/document", L"BusinessItemID", id);

		/*
		xml sheet ;
		sheet.setNativePointer(x.CreateInstance());
		sheet.loadXML(x.selectSingleNode(L"data/*").xml);
		*/

		//trace(x.xml());
		dw_cell.LoadTemplate(x);
		dw_cell.Redraw();

		return 1;
	}

	xml GetProduct(xstring GoodsNo)
	{
		return  ViewObject::RetrieveData(L"/sale/data/ProductLibrary3/ProductByGoodsNoWithShip", L"GoodsNo", GoodsNo);
	}

	int OpenDocumentEntity(xstring id)
	{
		xml x = ViewObject::RetrieveData(L"/sale/data/TO/business/documententity", L"BusinessID", id);

		/*
		xml sheet ;
		sheet.setNativePointer(x.CreateInstance());
		sheet.loadXML(x.selectSingleNode(L"data/*").xml);
		*/

		dw_cell.LoadTemplate(x);
		dw_cell.Redraw();

		return 1;
	}

	int Reset()
	{
		action = L"new";
		entityID = L"";
		entityItemID = L"";
		templateID = L"";
		return 1;
	}

	xstring UploadImage(xstring guid)
	{
		return UploadImage(guid, L"");
	}

	xstring UploadImage(xstring guid, xstring filename)
	{
		xstring name = guid + L".jpg";
		xstring str = name.mid(0, 2);
		str = str.toUpper();
		int ret = 1;
		if (filename != L"")
			ret = xaserver::Upload(L"product" + str, name, filename, GetHWND(), L"", false);
		else
			ret = xaserver::Upload(L"product" + str, name.c_str(), GetHWND(), L"", false);
		if (ret == -1) return L"";
		if (ret == 0)
		{
			alert(L"图片上传失败！");
			return L"";
		}
		return GetImageUrl(guid);

		/*
		xstring appPath = GetModuleTmpPath();
		xaserver::CreateDirectory(appPath);
		ret = xaserver::DownLoadFile(GetServerUrl(),L"/business/products/chanpin/"+str+L"/"+name,name,appPath+L"/"+name);
		if(ret < 0)
		{
			alert(L"图片下载失败1！");
			return L"";
		}

		xutil::SmallImage(appPath+L"\\"+name,appPath+L"\\"+L"x_"+name,120,120);
		int ret_1 = xaserver::Upload(L"product"+str, L"x_"+name,appPath+L"\\x_"+name, GetHWND(),L"",false);
		//xaserver::DeleteFile(appPath+L"x_"+name);
		//xaserver::DeleteFile(appPath+name);
		if(ret_1 != 1)
		{
			alert(L"上传缩略图失败!");
			return L"";
		}
		return appPath+L"/"+name;
		*/
	}

	xstring UploadImage1(xstring guid, xstring filename)
	{
		xstring name = guid + L".jpg";
		xstring str = name.mid(0, 2);
		str = str.toUpper();
		int ret = 1;
		if (filename != L"")
			ret = xaserver::Upload(L"product" + str, name, filename, GetHWND(), L"", false);
		else
			ret = xaserver::Upload(L"product" + str, name, GetHWND(), L"", false);
		if (ret == -1) return L"";
		if (ret == 0)
		{
			alert(L"图片上传失败！");
			return L"";
		}

		xstring appPath = GetModuleTmpPath();
		xaserver::CreateDirectory(appPath);
		ret = xaserver::DownLoadFile(GetServerUrl(), L"/business/products/chanpin/" + str + L"/" + name, name, appPath + L"/" + name);
		if (ret < 0)
		{
			alert(L"图片下载失败1！");
			return L"";
		}

		xutil::SmallImage(appPath + L"\\" + name, appPath + L"\\" + L"x_" + name, 120, 120);
		int ret_1 = xaserver::Upload(L"product" + str, L"x_" + name, appPath + L"\\x_" + name, GetHWND(), L"", false);
		//xaserver::DeleteFile(appPath+L"x_"+name);
		//xaserver::DeleteFile(appPath+name);
		if (ret_1 != 1)
		{
			alert(L"上传缩略图失败!");
			return L"";
		}
		return appPath + L"/" + name;
	}

	int ClearImageTerm(int row, xstring tm)
	{
		xstring str = dw_cell.GetItemString(row, 0);
		if (str.right(1) != L";") str += L";";
		if (str.find(tm + L":") >= 0)
		{
			int pos = str.find(L";", str.find(tm + L":") + 1);
			if (pos < 0) return 1;
			str = str.left(str.find(tm + L":")) + str.mid(pos, 99999);
		}
		return 1;
	}

	int AddImageTermEx(int row, xstring tm, xstring guid, xstring path = L"")
	{
		ximageview im = GetControl(L"frame:im1");
		xstring str = dw_cell.GetItemString(row, 0);
		if (str.right(1) != L";") str += L";";
		if (str.find(tm + L":") >= 0)
		{
			int pos = str.find(L";", str.find(tm + L":") + 1);
			if (pos < 0) return 1;
			str = str.left(pos) + L",L" + guid + str.mid(pos, 99999);
		}
		else
		{
			str += tm + L":" + guid + L";";
		}
		dw_cell.SetItemString(row, 0, str);
		return 1;
	}

	int AddImageTerm(int row, xstring tm, xstring guid, xstring path = L"")
	{
		ximageview im = GetControl(L"frame:im1");
		xstring str = dw_cell.GetItemString(row, 0);
		if (str.right(1) != L";") str += L";";
		if (str.find(tm + L":") >= 0)
		{
			int pos = str.find(L";", str.find(tm + L":") + 1);
			if (pos < 0) return 1;
			if (pos > 0 && str.mid(pos - 1, 1) == L":")
				str = str.left(pos) + guid + str.mid(pos, 99999);
			else
				str = str.left(pos) + L",L" + guid + str.mid(pos, 99999);
		}
		else
		{
			str += tm + L":" + guid + 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);
		im.Redraw();
		dw_cell.SetItemString(row, 0, str);
		//trace(L"\r\n"+str);
		return 1;
	}

	int getItemCount(xstring str, xstring tm)
	{
		if (str.find(tm + L":") < 0) return 0;
		int pos = str.find(L";", str.find(tm + L":") + 1);
		if (pos < 0) pos = str.length() + 1;

		xstring images = str.mid(str.find(tm + L":") + (tm + L":").length(), 99999);
		images = images.left(pos);

		int spos = 0;
		int count = 0;
		while (true)
		{
			count++;
			spos = images.find(L",L", spos + 1);
			if (spos < 0) break;
		}
		trace(L" count:" + xstring(count));
		return count;
	}

	int OnImageDel()
	{
		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"工厂图片");
		if (row < startRow) return  0;

		xstring str = dw_cell.GetItemString(row, 0);
		xstring tm = L"customer-photo";
		int colimage = colPhoto;

		int sindex = 0;
		int cindex = 0;

		ximageview im = GetControl(L"frame:im1");
		int index = im.GetSelectIndex();
		if (index < 0 || index > im.GetImageCount()) return 1;

		if (action == L"purch")
		{
			tm = L"supplier-photo";
			colimage = colPhoto1;
			sindex = getItemCount(str, L"customer-photo");
		}
		else
		{
			trace(L"index:" + xstring(index) + L"--" + L"cnt:" + xstring(getItemCount(str, L"customer-photo")));
			if (index >= getItemCount(str, L"customer-photo"))
				return 1;
		}

		if (str.find(tm + L":"))
		{
			//trace(xstring(index)+L"-"+xstring(sindex));

			index -= sindex;
			if (index < 0) return 1;

			int pos = str.find(L";", str.find(tm + L":") + 1);
			if (pos < 0) pos = str.length() + 1;

			xstring imageurl = im.GetImageUrl(index + sindex);
			xstring images = str.mid(str.find(tm + L":") + (tm + L":").length(), 99999);
			images = images.left(pos);
			int spos = 0;
			int i = 0;

			if (action != L"purch" && index == 0 && getItemCount(str, L"customer-photo") == 1)
			{
				images = L";";
			}
			else
			{
				while (true)
				{
					if (i == index) break;
					spos = images.find(L",L", spos + 1);
					if (spos < 0) break;
					i++;
				}
				int epos = images.find(L",L", spos + 1);
				if (spos >= 0)
				{
					if (epos < 0)
						images = images.left(spos);
					else
						images = images.left(spos) + images.mid(epos, 99999);
				}
				if (images.right(1) != L";") images += L";";
			}

			str = str.left(str.find(tm + L":") + (tm + L":").length()) + images + str.mid(pos + 1, 99999);
			dw_cell.SetItemString(row, 0, str);


			if (index >= 0) im.RemoveImage(index + sindex);
			//im.ResetEx();
			im.Redraw();
			if (index == 0)dw_cell.SetItemString(row, colimage, L"");

			if (im.GetImageCount() - sindex >= 1)
			{
				if (images.find(L",L") == 0) images = images.mid(1, 9999);
				int pos1 = images.find(L",L");
				if (pos1 < 0) pos1 = images.find(L";");
				xstring id = images;
				if (pos1 >= 0) id = images.left(pos1);

				if (id != L"")
				{
					xstring name = id + L".jpg";

					//xstring appPath = GetModuleTmpPath();
					//xaserver::CreateDirectory(appPath);
					//xaserver::DownLoadFile(GetServerUrl(),L"/business/products/chanpin/"+id.left(2)+L"/"+name,name,appPath+L"/"+name);

					if (startRow > 1)
					{
						xstring props = dw_cell.GetCellProps(row, colimage);
						props = L"<cellprop><edit edittype='image'/></cellprop>";
						dw_cell.SetCellProps(row, colPhoto, props);
						dw_cell.SetItemString(row, colimage, GetImageUrl(id));
					}
				}
			}
		}
		else
			dw_cell.SetItemString(row, colimage, L"");
		dw_cell.Redraw();

		return 1;
	}

	int OnImageAdd1()
	{
		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 LastRow = dw_cell.GetValidRow();
		if (row < startRow) return  0;

		xstring props = dw_cell.GetCellProps(row, colPhoto);
		props = L"<cellprop><edit edittype='image'/></cellprop>";
		dw_cell.SetCellProps(row, colPhoto, props);
		dw_cell.SetCellProps(row, colPhoto1, props);

		xstring appPath = GetModuleTmpPath();
		xstring guid = ViewObject::GetGuid();
		xstring filename1 = UploadImage(guid);
		if (filename1 != L"")
		{
			if (action == L"purch")
			{
				//dw_cell.SetItemString(row,colPhoto1,file);
				AddImageTerm(row, L"supplier-photo", guid);
				if (dw_cell.GetItemString(row, colPhoto1) == L"")
					dw_cell.SetItemString(row, colPhoto1, appPath + L"\\" + L"x_" + guid + L".jpg");
			}
			else
			{
				//dw_cell.SetItemString(row,colPhoto,file);
				AddImageTerm(row, L"customer-photo", guid);
				if (dw_cell.GetItemString(row, colPhoto) == L"")
					dw_cell.SetItemString(row, colPhoto, appPath + L"\\" + L"x_" + guid + L".jpg");
			}
			dw_cell.SetRowHeight(row, dw_cell.GetRowHeight(row));
			dw_cell.Redraw();
			Redraw();
		}

		return 1;
	}

	int GetOpenFileNames(StringArray items, xstring initFileName, xstring filter, xstring ext)
	{
		//xstring path = GetOpenFileName(L"",
		//		"JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0",
		//		"jpg");		

		wchar_t  szFileName[4096];
		wchar_t szPath[4096];
		szFileName[0] = 0;
		szPath[0] = 0;

		if (initFileName != L"")
		{
			int len = initFileName.length();
			const wchar_t* tmp = initFileName.c_str();
			for (int i = 0; i < len + 1; i++)
			{
				szPath[i] = tmp[i];
			}
		}

		int	 nFilterIndex = 1;
		OPENFILENAMEW ofn;

		ofn.lStructSize = 88;//sizeof(ofn);
		ofn.hwndOwner = 0;
		ofn.hInstance = 0;
		ofn.lpstrFilter = filter;
		//"JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0";
		ofn.lpstrCustomFilter = 0;
		ofn.nMaxCustFilter = 0;
		ofn.nFilterIndex = nFilterIndex;
		ofn.lpstrFile = szPath;
		ofn.nMaxFile = 4096;
		ofn.lpstrFileTitle = szFileName;
		ofn.nMaxFileTitle = 4096;
		ofn.lpstrTitle = L"请指定文件名";
		ofn.lpstrDefExt = ext;
		//"jpg";
		ofn.lpstrInitialDir = 0;
		ofn.Flags = 0x00000010/*OFN_SHOWHELP*/ | 0x00001000/*OFN_FILEMUSTEXIST*/
			| 0x00000200 /*OFN_ALLOWMULTISELECT*/ | 0x00080000 /*OFN_EXPLORER*/;
		ofn.lCustData = 0;
		ofn.lpfnHook = 0;
		ofn.lpTemplateName = 0;

		ofn.nFileOffset = 0;
		ofn.nFileExtension = 0;

		//debugbreak();
		if (file::GetOpenFileName(ofn))
		{
			int pos = ofn.nFileOffset & 0xffff;
			xstring path = szPath;
			if (pos < path.length()) //select one
			{
				items.push_back(path + L"");
			}
			else
			{
				int start = cast(szPath as int);
				start += pos * 2;
				xstring str = cast(start  as xstring);
				while (true)
				{
					if (str == L"")break;
					items.push_back(path + L"/" + str);
					start += (str.length() + 1) * 2;
					str = cast(start  as xstring);
				}
			}
		}
		delete szFileName;
		delete szPath;
		delete ofn;

		return items.length();
	}

	int OnImageAddEx()
	{
		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 LastRow = dw_cell.GetValidRow();
		if (row < startRow) return  0;

		xstring appPath = GetModuleTmpPath();
		StringArray items;
		items = StringArray::make();
		GetOpenFileNames(items, L"",
			"JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0",
			"jpg");
		if (items.length() < 1) return 1;

		int sRow = row;
		for (int i = 0; i < items.length(); i++)
		{
			row = sRow + i;
			xstring props = dw_cell.GetCellProps(row, colPhoto);
			props = L"<cellprop><edit edittype='image'/></cellprop>";
			dw_cell.SetCellProps(row, colPhoto, props);
			dw_cell.SetCellProps(row, colPhoto1, props);

			xstring guid = ViewObject::GetGuid();
			xstring filename1 = UploadImage(guid, items.item(i));
			int rowheight = dw_cell.GetRowHeight(row);
			if (rowheight < 50) rowheight = 50;
			if (filename1 != L"")
			{
				if (action == L"purch")
				{
					//dw_cell.SetItemString(row,colPhoto1,file);
					if (i == 0)
						AddImageTerm(row, L"supplier-photo", guid);
					else
						AddImageTermEx(row, L"supplier-photo", guid);
					if (dw_cell.GetItemString(row, colPhoto1) == L"")
					{
						//dw_cell.SetItemString(row,colPhoto1,appPath+L"\\"+L"x_"+guid+L".jpg");
						dw_cell.SetItemString(row, colPhoto1, GetImageUrl(guid));
						dw_cell.SetRowHeight(row, rowheight);
					}
				}
				else
				{
					//dw_cell.SetItemString(row,colPhoto,file);
					if (i == 0)
						AddImageTerm(row, L"customer-photo", guid);
					else
						AddImageTermEx(row, L"customer-photo", guid);
					if (dw_cell.GetItemString(row, colPhoto) == L"")
					{
						//dw_cell.SetItemString(row,colPhoto,appPath+L"\\"+L"x_"+guid+L".jpg");
						dw_cell.SetItemString(row, colPhoto, GetImageUrl(guid));
						dw_cell.SetRowHeight(row, rowheight);
					}
				}
			}
			//dw_cell.SetRowHeight(row,dw_cell.GetRowHeight(row));
			dw_cell.Redraw();
			Redraw();
		}

		return 1;
	}

	int OnImageAdd()
	{
		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 LastRow = dw_cell.GetValidRow();
		if (row < startRow) return  0;

		xstring props = dw_cell.GetCellProps(row, colPhoto);
		props = L"<cellprop><edit edittype='image'/></cellprop>";
		dw_cell.SetCellProps(row, colPhoto, props);
		dw_cell.SetCellProps(row, colPhoto1, props);

		xstring appPath = GetModuleTmpPath();
		StringArray items;
		items = StringArray::make();
		GetOpenFileNames(items, L"",
			L"JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0",
			"jpg");
		if (items.length() < 1) return 1;

		for (int i = 0; i < items.length(); i++)
		{
			xstring guid = ViewObject::GetGuid();
			xstring filename1 = UploadImage(guid, items.item(i));
			int rowheight = dw_cell.GetRowHeight(row);
			if (rowheight < 50) rowheight = 50;
			if (action == L"purch")
			{
				//dw_cell.SetItemString(row,colPhoto1,file);
				AddImageTerm(row, L"supplier-photo", guid);
				if (dw_cell.GetItemString(row, colPhoto1) == L"")
				{
					//dw_cell.SetItemString(row,colPhoto1,appPath+L"\\"+L"x_"+guid+L".jpg");
					dw_cell.SetItemString(row, colPhoto1, GetImageUrl(guid));
					dw_cell.SetRowHeight(row, rowheight);
				}
			}
			else
			{
				//dw_cell.SetItemString(row,colPhoto,file);
				AddImageTerm(row, L"customer-photo", guid);
				if (dw_cell.GetItemString(row, colPhoto) == L"")
				{
					//dw_cell.SetItemString(row,colPhoto,appPath+L"\\"+L"x_"+guid+L".jpg");
					dw_cell.SetItemString(row, colPhoto, GetImageUrl(guid));
					dw_cell.SetRowHeight(row, rowheight);
				}
			}
			//dw_cell.SetRowHeight(row,dw_cell.GetRowHeight(row));
			dw_cell.Redraw();
			Redraw();
		}

		return 1;
	}

	int OnCellItemChanged(TEvent* evt, int p)
	{
		CELLNMHDR&  hdr = *(CELLNMHDR*)evt->notify.pnmh;
		xstring value = hdr.data;
		int row = hdr.currentrow;
		int col = hdr.currentcol;

		trace(L"\r\n----row:" + xstring(row) + L"--col:" + xstring(col));
		trace(L"\r\n----row:" + xstring(row) + L"--col:" + xstring(col));
		trace(L"\r\n--value:" + dw_cell.GetItemString(row, col) + L"--orig:" + orivalue);
		if (row == ARow && col == ACol && dw_cell.GetItemString(row, col) == orivalue) return 1;
		trace(L"\r\n--enter:");

		ARow = row;
		ACol = col;
		orivalue = dw_cell.GetItemString(ARow, ACol) + L"";

		int startRow = getItemHeadRow(dw_cell);
		if (startRow < 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 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 colCustomerPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo");
		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 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 colSKUNo = getItemCol(dw_cell, startRow - 1, L"SKUID,SKUNo");

		if (col == colFOBPrice)
		{
			xstring fobprice = dw_cell.GetItemString(row, col);
			if (fobprice.find(L"$") >= 0)fobprice = fobprice.mid(1, 999);
			trace(L"+++++L" + fobprice + L"+++++L");
			double colFOBPriceEx = fobprice.toDouble();

			double colFOBPriceS;
			colFOBPriceS = colFOBPriceEx.round(2);
			xstring colFOBPriceS1 = xstring(colFOBPriceS);
			xstring colFOBPriceS2 = colFOBPriceS1.left(colFOBPriceS1.find(L"."));
			xstring colFOBPriceS3 = colFOBPriceS1.mid(colFOBPriceS1.find(L"."), colFOBPriceS1.length());
			xstring colFOBPriceS4 = colFOBPriceS3.mid(1, 2);
			trace(L"******" + colFOBPriceS1 + L"****" + colFOBPriceS2 + L"****" + colFOBPriceS3 + L"****" + colFOBPriceS4 + L"****");

			if (fobprice != L"")dw_cell.SetItemString(row, col, L"$" + colFOBPriceS2 + L"." + colFOBPriceS4);
			return 1;
		}

		if (col == colItemNo)
		{
			if (dw_cell.GetItemString(row, colItemNo) != L"")
			{
				xaserverarg argx ;
				argx.setNativePointer(argx.CreateInstance());
				argx.AddArg(L"GoodsNo", dw_cell.GetItemString(row, colItemNo));
				OpenWindow(L"dev:xpage[CustomerItemNoList.vx]", cast(argx as int));
				if (argx.GetArgString(L"action") != L"ok") return 1;

				xml x1 ;
				x1.loadXML(argx.GetArgString(L"items"));
				if (x1.selectSingleNode(L"//CustomerItemNo"))
				{
					xstring CustomerItemNo = x1.selectSingleNode(L"//CustomerItemNo").text();
					dw_cell.SetItemString(row, colCustomerItemNo, CustomerItemNo);
				}

				xml goods = GetProduct(dw_cell.GetItemString(row, colItemNo));

				if (goods)
				{
					dw_cell.SetItemString(row, colCustomerPhoto, L"");
					resetRowTerm(dw_cell, row, L"customer-photo");
					if (goods.selectSingleNode(L"//SKUID[1]"))
					{
						setRowProp(dw_cell, row, L"SKUID", goods.selectSingleNode(L"//SKUID[1]").text());
					}
					if (goods.selectSingleNode(L"//SKUNo[1]"))
					{
						dw_cell.SetItemString(row, colSKUNo, goods.selectSingleNode(L"//SKUNo[1]").text());
					}
					if (goods.selectSingleNode(L"//EName[1]"))
						dw_cell.SetItemString(row, colItemName, goods.selectSingleNode(L"//EName[1]").text());
					if (goods.selectSingleNode(L"//CName[1]"))
						dw_cell.SetItemString(row, colItemCName, goods.selectSingleNode(L"//CName[1]").text());
					if (goods.selectSingleNode(L"//Packing[1]"))
						dw_cell.SetItemString(row, colPackage, goods.selectSingleNode(L"//Packing[1]").text());
					if (goods.selectSingleNode(L"//POCreatorID[1]"))
					{
						dw_cell.SetItemString(row, colBuyer, goods.selectSingleNode(L"//POCreatorID[1]").text());
					}
					if (goods.selectSingleNode(L"//PackingRate[1]"))
					{
						if (goods.selectSingleNode(L"//InnerQty[1]"))
						{
							xstring str1 = goods.selectSingleNode(L"//PackingRate[1]").text();
							xstring str2 = goods.selectSingleNode(L"//InnerQty[1]").text();
							dw_cell.SetItemString(row, colQtyPerPack, str2 + L"/" + str1);
						}
						else
							dw_cell.SetItemString(row, colQtyPerPack, str1);
					}
					ProcessItemImage(dw_cell.GetItemString(row, colSKUNo), row);
					//ProcessItemImage1(dw_cell.GetItemString(row,colItemNo),row);
					dw_cell.SetRowColumn(row, col);
					dw_cell.SetAnchorRowColumn(row, col);

					dw_cell.Redraw();
				}
			}
		}

		if (col == colVolDesc || col == colQtyPerPack)
		{
			/*计算体积*/
			double v = 0.0;
			xstring desc = dw_cell.GetItemString(row, colVolDesc);
			if (desc.find(L"cm") >= 0)
			{
				desc = desc.replace(L"cm", L"");
				dw_cell.SetItemString(row, colVolDesc, desc);
			}
			if (desc.find(L"CM") >= 0)
			{
				desc = desc.replace(L"CM", L"");
				dw_cell.SetItemString(row, colVolDesc, desc);
			}
			if (desc == L"")
				dw_cell.SetItemString(row, colVol, L"");
			else
			{
				v = calcVol(desc) / 1000000.00;
				xstring str = xstring(v);
				if (str.find(L".") >= 0)	str = str.left(str.find(L".") + 5);
				dw_cell.SetItemString(row, colVol, str);
				dw_cell.Redraw();
			}

			xstring qtyperPack = dw_cell.GetItemString(row, colQtyPerPack);
			if (qtyperPack != L"")
			{
				xstring qty1 = qtyperPack;
				xstring qty2 = L"";
				double qty = 0.00;
				int pos2 = qtyperPack.find(L"/");
				if (pos2 >= 0)
				{
					qty1 = qtyperPack.left(qtyperPack.find(L"/"));
					qty2 = qtyperPack.mid(qtyperPack.find(L"/") + 1, 9999);
				}
				//if(qty1 !=L"") qty = qty1.toDouble();
				//if(qty2 !=L"") qty = qty*qty2.toDouble();
				qty = qty2.toDouble();
				double ttl = 65.0 * qty / v;
				dw_cell.SetItemString(row, col40HQ, ttl.toInt().toString());
			}
		}

		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 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)
			{
				trace(L"\r\n---*****---hit col:" + xstring(col) + L"----");
				xstring pricea = L"";
				xstring priceb = L"";
				xstring pricec = L"";
				if (action == L"purch")
				{
					xstring price0 = dw_cell.GetItemString(row, colPrice0);
					xstring price1 = dw_cell.GetItemString(row, colPrice1);
					xstring price2 = L"";
					if (colPrice2 > 0) price2 = dw_cell.GetItemString(row, colPrice2);
					xstring price3 = L"";
					if (colPrice3 > 0) price3 = dw_cell.GetItemString(row, colPrice3);

					xstring price = L"";

					if (price0 != L"")
					{
						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");
							if (pricea == L"") pricea = price; else pricea += L"+L" + price;
						}
						else if (price.find(L"A") > 0 || price.find(L"a") > 0)
							if (pricea == L"") pricea = price; else pricea += L"+L" + price;
						else if (price.find(L"B") > 0 || price.find(L"b") > 0)
							if (priceb == L"") priceb = price; else priceb += L"+L" + price;
						else if (price.find(L"C") > 0 || price.find(L"c") > 0)
							if (pricec == L"") pricec = price; else pricec += L"+L" + price;
					}
					if (price1 != L"")
					{
						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");
							if (pricea == L"") pricea = price; else pricea += L"+L" + price;
						}
						else if (price.find(L"A") > 0 || price.find(L"a") > 0)
							if (pricea == L"") pricea = price; else pricea += L"+L" + price;
						else if (price.find(L"B") > 0 || price.find(L"b") > 0)
							if (priceb == L"") priceb = price; else priceb += L"+L" + price;
						else if (price.find(L"C") > 0 || price.find(L"c") > 0)
							if (pricec == L"") pricec = price; else pricec += L"+L" + price;
					}
					if (price2 != L"")
					{
						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");
							if (pricea == L"") pricea = price; else pricea += L"+L" + price;
						}
						else if (price.find(L"A") > 0 || price.find(L"a") > 0)
							if (pricea == L"") pricea = price; else pricea += L"+L" + price;
						else if (price.find(L"B") > 0 || price.find(L"b") > 0)
							if (priceb == L"") priceb = price; else priceb += L"+L" + price;
						else if (price.find(L"C") > 0 || price.find(L"c") > 0)
							if (pricec == L"") pricec = price; else pricec += L"+L" + price;
					}
					if (price3 != L"")
					{
						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");
							if (pricea == L"") pricea = price; else pricea += L"+L" + price;
						}
						else if (price.find(L"A") > 0 || price.find(L"a") > 0)
							if (pricea == L"") pricea = price; else pricea += L"+L" + price;
						else if (price.find(L"B") > 0 || price.find(L"b") > 0)
							if (priceb == L"") priceb = price; else priceb += L"+L" + price;
						else if (price.find(L"C") > 0 || price.find(L"c") > 0)
							if (pricec == L"") pricec = price; else pricec += L"+L" + price;
					}
					price = pricec;
					if (priceb != L"")
					{
						if (price == L"")
							price = priceb;
						else
							price += L"+L" + priceb;
					}
					if (pricea != L"")
					{
						if (price == L"")
							price = pricea;
						else
							price += L"+L" + pricea;
					}
					dw_cell.SetItemString(row, colPrice, price);
					dw_cell.Redraw();
				}
			}
		}

		return 1;
	}

	int OnCellSelectChanged(TEvent*, LPARAM p)
	{
		/*ref DWNMHDR  hdr = trust(evt.pnmh as ref DWNMHDR);
		xstring colname=hdr.colname;
		xstring value = hdr.data;
		int row = hdr.row;
		*/
		trace(L"========111============L");
		return 1;
	}

	int OnItemChanged(TEvent*, LPARAM p)
	{
		ref DWNMHDR  hdr = trust(evt.pnmh as ref DWNMHDR);
		xstring colname = hdr.colname;
		xstring value = hdr.data;
		int row = hdr.row;

		if (colname == L"Project")
		{

			setBaseItem(dw_cell, L"项目名称:", value);
		}
		return 1;
	}

	int OnToQuote()
	{
		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 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 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 colTechNote = getItemCol(dw_cell, startRow - 1, L"业务部产品信息");
		int colTechNote1 = 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 colFOBPrice = getItemCol(dw_cell, startRow - 1, L"FOB Price,FOB Price(USD),Fob Price");
		int colQuantity = getItemCol(dw_cell, startRow - 1, L"数量,Qty");

		int colBuyerRemark = getItemCol(dw_cell, startRow - 1, L"采购To业务备注");
		int colFactoryImage = getItemCol(dw_cell, startRow - 1, L"工厂图片");
		int colGWT = getItemCol(dw_cell, startRow - 1, L"毛重,毛重(KG)L");
		int colNWT = getItemCol(dw_cell, startRow - 1, L"净重,净重(KG)L");
		int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)L");
		int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)L");
		int colHQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L");
		int colSKUNo = getItemCol(dw_cell, startRow - 1, L"SKUID,SKUNo");



		ensureRowID();
		int LastRow = dw_cell.GetValidRow();
		xstring content = L"";
		for (int row = startRow; row <= LastRow; row++)
		{
			xstring rowid = getRowID(dw_cell, row);
			if (rowid == L"")continue;
			if (dw_cell.GetItemString(row, colItemName) == L"")
			{
				if (dw_cell.GetItemString(row, colItemCName) == L"") break;
			}
			int i = 1;
			for (i = 1; i <= dw_goods.GetRowCount(); i++)
			{
				if (dw_goods.GetGuid(i) == rowid) break;
			}
			if (i > dw_goods.GetRowCount())
			{
				dw_goods.InsertRow(0);
				KXMLDOMElement e = dw_goods.GetRowElement(i);
				e.setAttribute(L"guid", rowid);
			}

			xstring SKUID = getRowProp(dw_cell, row, L"SKUID");
			if (SKUID != L"")
			{
				dw_goods.SetItemString(i, L"SKUID", SKUID);
				dw_goods.SetItemString(i, L"ItemID", SKUID);
			}
			dw_goods.SetItemString(i, L"SKUNo", dw_cell.GetItemString(row, colSKUNo));
			//dw_goods.SetItemString(i,L"ItemID",dw_cell.GetItemNoteString(row,colSKUNo));

			dw_goods.SetItemString(i, L"CustomerItemNo", dw_cell.GetItemString(row, colCustomerItemNo));
			dw_goods.SetItemString(i, L"GoodsNo", dw_cell.GetItemString(row, colItemNo));
			dw_goods.SetItemString(i, L"ItemName", dw_cell.GetItemString(row, colItemName));
			dw_goods.SetItemString(i, L"CItemName", dw_cell.GetItemString(row, colItemCName));
			dw_goods.SetItemString(i, L"CName", dw_cell.GetItemString(row, colItemCName));

			dw_goods.SetItemString(i, L"TechNote", dw_cell.GetItemString(row, colTechNote));
			dw_goods.SetItemString(i, L"TechNote1", dw_cell.GetItemString(row, colTechNote1));
			dw_goods.SetItemString(i, L"ProductDesc", dw_cell.GetItemString(row, colItemName));

			dw_goods.SetItemString(i, L"Packing", dw_cell.GetItemString(row, colPackage));
			dw_goods.SetItemString(i, L"VolumeDesc", dw_cell.GetItemString(row, colVolDesc));
			dw_goods.SetItemString(i, L"Packages45H", dw_cell.GetItemString(row, colHQ));
			dw_goods.SetItemString(i, L"ItemMiniQty", dw_cell.GetItemString(row, colQuantity));

			if (getRowTerm(dw_cell, row, L"EnquiryLineID") != L"")
			{
				dw_goods.SetItemString(i, L"EnquiryPriceListID", getRowTerm(dw_cell, row, L"EnquiryLineID"));
				dw_goods.SetItemString(i, L"EnquiryLineID", getRowTerm(dw_cell, row, L"EnquiryLineID"));
			}

			//dw_goods.SetItemString(i,L"Packages45H",dw_cell.GetItemString(row,colHQ));
			//dw_goods.SetItemString(i,L"POPrice",dw_cell.GetItemString(row,colBuyerPrice));


			xstring FobUnitPriceEx = dw_cell.GetItemString(row, colFOBPrice);
			if (FobUnitPriceEx == L"$") FobUnitPriceEx = L"";
			if (FobUnitPriceEx.find(L"$") >= 0) FobUnitPriceEx = FobUnitPriceEx.right(FobUnitPriceEx.length() - 1);
			trace(FobUnitPriceEx);
			//dw_goods.SetItemString(i,L"FobUnitPrice",dw_cell.GetItemString(row,colFOBPrice));
			dw_goods.SetItemString(i, L"FobUnitPrice", FobUnitPriceEx);


			dw_goods.SetItemDisplayString(i, L"POCreatorID", dw_cell.GetItemString(row, colPurchor));
			dw_goods.SetItemString(i, L"POCreatorID", GetPurchorByName(dw_cell.GetItemString(row, colPurchor)));


			xstring QtyPerPack = dw_cell.GetItemString(row, colQtyPerPack);
			xstring outer = QtyPerPack;
			if (QtyPerPack.find(L"/") >= 0) outer = QtyPerPack.left(QtyPerPack.find(L"/"));
			xstring inner = L"";
			if (QtyPerPack.find(L"/") >= 0) inner = QtyPerPack.mid(QtyPerPack.find(L"/") + 1, 9999);
			dw_goods.SetItemString(i, L"InnerQty", outer);
			dw_goods.SetItemString(i, L"Packages", inner);

			dw_goods.Redraw();
		}
		int crow = dw_goods.GetRow();
		if (crow > 0)
		{
			OnQuoteLineChanged(crow);
			//OnShowImage(dw_goods.GetItemString(crow,L"SKUNo"),crow);
		}

		return 1;
	}

	int ProcessItemImage(xstring goodsno, int row)
	{
		xml xp ;
		xp.setNativePointer(xml::CreateInstance());
		xaserverarg arg_pic ;
		arg_pic.setNativePointer(arg_pic.CreateInstance());
		arg_pic.AddArg(L"SKUNo", goodsno);

		ximageview im = GetControl(L"frame:im1");
		im.ResetEx();
		xstring res = L"/sale/data/productlibrary3/pref/picture/imagelistskuno";
		if (xurl::get(res, arg_pic.GetString(), xp) != 1)
		{
			trace(xp.xml());
			return 1;
		}
		else
		{
			//alert(xp.xml());
			ClearImageTerm(row, L"customer-photo");
			//alert(xp.xml());
			KXMLDOMNodeList nlistp = xp.selectNodes(L"ImageList/image");
			int lenp = nlistp.length();
			int ip = 0;
			if (lenp > 0) lenp = 1;
			for (ip = 0; ip < lenp; ip++)
			{
				KXMLDOMNode xitem = nlistp.item(ip);
				xstring id = xitem.selectSingleNode(L"@guid").text();
				xstring path = L"";
				if (xitem.selectSingleNode(L"PicPath")) path = xitem.selectSingleNode(L"PicPath").text();
				xstring name = id + L".jpg";
				if (path == L"") path = L"/business/products/chanpin/" + id.left(2) + L"/" + name;
				AddImageTerm(row, L"customer-photo", id, path);
				/*xstring picname = xitem.selectSingleNode(L"PicPath").text();
				if(picname == L"/business/products/Thumbs//")
					picname = L"/business/products/Thumbs/00/00000000-0000-0000-0000-000000000000.jpg";
				im.AddImages(picname,goodsno);*/
				if (ip == 0)
				{
					//xstring appPath = GetModuleTmpPath();
					//xaserver::CreateDirectory(appPath);
					//xaserver::DownLoadFile(GetServerUrl(),path,name,appPath+L"/"+name);

					int startRow = getItemHeadRow(dw_cell);
					if (startRow > 1)
					{
						int colPhoto = getItemCol(dw_cell, startRow, L"Photo,Customer Photo");
						xstring props = dw_cell.GetCellProps(row, colPhoto);
						props = L"<cellprop><edit edittype='image'/></cellprop>";
						dw_cell.SetCellProps(row, colPhoto, props);
						//dw_cell.SetItemString(row,colPhoto,appPath+L"\\"+name);
						dw_cell.SetItemString(row, colPhoto, path);
					}
				}
			}
		}
		return 1;
	}

	int ProcessItemImage1(xstring goodsno, int row)
	{
		xml xp ;
		xp.setNativePointer(xml::CreateInstance());
		xaserverarg arg_pic ;
		arg_pic.setNativePointer(arg_pic.CreateInstance());
		arg_pic.AddArg(L"GoodsNo", goodsno);

		ximageview im = GetControl(L"frame:im1");
		im.ResetEx();
		xstring res = L"/sale/data/ProductLibrary3/pref/picture/imagelistItemNo";
		if (xurl::get(res, arg_pic.GetString(), xp) != 1)
		{
			trace(xp.xml());
			return 1;
		}
		else
		{
			ClearImageTerm(row, L"customer-photo");
			//alert(xp.xml());
			KXMLDOMNodeList nlistp = xp.selectNodes(L"ImageList/image");
			int lenp = nlistp.length();
			int ip = 0;
			for (ip = 0; ip < lenp; ip++)
			{
				KXMLDOMNode xitem = nlistp.item(ip);
				xstring id = xitem.selectSingleNode(L"@guid").text();
				xstring name = id + L".jpg";
				AddImageTerm(row, L"customer-photo", id);
				/*xstring picname = xitem.selectSingleNode(L"PicPath").text();
				if(picname == L"/business/products/Thumbs//")
					picname = L"/business/products/Thumbs/00/00000000-0000-0000-0000-000000000000.jpg";
				im.AddImages(picname,goodsno);*/
				if (ip == 0)
				{
					xstring appPath = GetModuleTmpPath();
					xaserver::CreateDirectory(appPath);
					xaserver::DownLoadFile(GetServerUrl(), L"/business/products/chanpin/" + id.left(2) + L"/" + name, name, appPath + L"/" + name);

					int startRow = getItemHeadRow(dw_cell);
					if (startRow > 1)
					{
						int colPhoto = getItemCol(dw_cell, startRow, L"Photo,Customer Photo");
						xstring props = dw_cell.GetCellProps(row, colPhoto);
						props = L"<cellprop><edit edittype='image'/></cellprop>";
						dw_cell.SetCellProps(row, colPhoto, props);
						dw_cell.SetItemString(row, colPhoto, appPath + L"\\" + name);
					}
				}
			}
		}
		return 1;
	}

	int OnAddBOMItem()
	{
		int startRow = getItemHeadRow(dw_cell);
		int headrow = startRow;
		if (startRow < 1) return 1;
		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");
		if (colPurchPrice3 > 0) return  1;

		if (colPurchPrice2 < 1)
		{
			//dw_cell.SetColumnCount(dw_cell.GetColumnCount()+3);
			//dw_cell.SetColumnCount(dw_cell.GetValidCol()+3);
			dw_cell.SetRowColumn(row, colPurchPrice1 + 1);
			dw_cell.SetAnchorRowColumn(row, colPurchPrice1 + 1);

			SendCtrlCmd(dw_cell, L"xmFormatCellInsertCol");
			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");
		}
		else
		{
			//dw_cell.SetColumnCount(dw_cell.GetColumnCount()+3);
			//dw_cell.SetColumnCount(dw_cell.GetValidCol()+3);
			dw_cell.SetRowColumn(row, colPurchPrice2 + 1);
			dw_cell.SetAnchorRowColumn(row, colPurchPrice2 + 1);

			SendCtrlCmd(dw_cell, L"xmFormatCellInsertCol");
			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");
		}
		return 1;
	}

	//命令发布函数
	int OnCmdDispatch(xstring comdid)
	{
		if (comdid == L"xmAddBOMItem") return OnAddBOMItem();
		if (comdid == L"xmQuoteBill")
		{
			if (dw_base.GetItemString(1, L"CustomerID") == L"")
			{
				alert(L"导出前请输入客户");
				return 1;
			}
			return OnPrint();
		}
		if (comdid == L"tab_quote")
		{
			tabsheet = L"tab_quote";
			return OnToQuote();
		}
		if (comdid == L"xmMySupplier")
			return OnMySupplier();
		if (comdid == L"xmImageAdd")
		{
			OnImageAdd();
			return 1;
		}
		if (comdid == L"xmImageAddEx")
		{
			OnImageAddEx();
			return 1;
		}
		if (comdid == L"xmImageDel")
		{
			OnImageDel();
			return 1;
		}
		else if (comdid == L"xmPurched")
		{
			//if(makeMessage(L"/task/quote/purchar/backtosaler")==-1) return 1;
			return OnSaleBack();
		}
		else if (comdid == L"xmPurch")
		{
			return OnPurch();
		}
		else if (comdid == L"xmSetPurchor")
		{
			return OnNextPurch();
		}
		else if (comdid == L"xmSetPurchor")
		{
			return OnPurchEx();
		}
		else if (comdid == L"xmRefreshTask1")
		{
			win32::PostMessage(GetFrameWindow().GetHWND(), 0x401, L"xmRefreshTask", 0);
			return 1;
		}
		else if (comdid == L"xmFileOpen" || comdid == L"xmOpen" || comdid == L"xmNew")
		{
			xstring suserid = publiccode::GetUser().id;
			xaserverarg args ;
			args.setNativePointer(args.CreateInstance());

			if (comdid == L"xmNew")
				OpenWindow(L"dev:xpage[TONewSelectDlg.vx]", cast(args as int));
			else
				OpenWindow(L"dev:xpage[TOSelectDlg.vx]", cast(args as int));
			fileid = args.GetArgString(L"id");
			templateID = args.GetArgString(L"templateID");
			xstring myaction = args.GetArgString(L"action");
			if (myaction == L"new" && action == L"new") Reset();
			if (myaction == L"new")
			{
				action = L"new";
				trace(args.GetArgString(L"id"));
				return OpenTemplate(args.GetArgString(L"id"));
			}
			else if (myaction == L"open")
			{
				action = L"open";
				entityID = args.GetArgString(L"ID");
				entityItemID = args.GetArgString(L"ItemID");

				OnRetrieve(entityID);
				return OpenDocument(entityItemID);
			}

			return 1;

			args.AddArg(L"src", L"data/QuoteFile/" + suserid);
			args.AddArg(L"process", L"path");
			OpenWindow(L"dev:xpage[trade.document.selectdlg.vx]", cast(args as int));
			if (args.GetArgString(L"result") == L"ok")
			{
				xstring u = args.GetArgString(L"src");
				xml x ;
				
				xaserver::LoadUrl(GetServerUrl(), u, L"", x);
				trace(x.xml());
				dw_cell.LoadTemplateEx(x.documentElement);
				dw_cell.Redraw();
				filename = args.GetArgString(L"filename");
				fileid = args.GetArgString(L"ID");
				win32::SetWindowText(GetHWND(), L"报价文件:" + filename);
			}
			return 1;
		}
		else if (comdid == L"xmFileNew" || comdid == L"xmNew")
		{
			dw_cell.openUrl(templateurl);
			dw_cell.Redraw();
			filename = L"";
			fileid = L"";
			win32::SetWindowText(GetHWND(), L"报价文件:[new]");
			return 1;
		}
		else if (comdid == L"xmFileSave" || comdid == L"xmSave")
		{

			return OnSave();
		}
		else if (comdid == L"xmSaveEx")
		{
			return OnSaveEx();
		}
		else if (comdid == L"xmFileSaveAs" || comdid == L"xmSaveAs")
		{
			return OnSave(/*saveas*/true);
		}
		else if (comdid.left(3) == L"IK_")
		{
			int row = dw_cell.GetRow();
			xstring cmd = comdid.mid(3, comdid.length());
			if (comdid == L"IK_xmFormatCellDeleteRow" && row > 0)
			{
				xstring rowid = getRowID(dw_cell, row);
				if (rowid != L"")
				{
					int frow = LookupRow(rowid);
					if (frow > 0) dw_goods.DeleteRow(frow);
				}
			}
			SendCtrlCmd(dw_cell, cmd);
			return 1;
		}
		else if (comdid == L"xmFormatCellDeleteRow")
		{
			if (action == L"purch")
			{
				int crow = dw_cell.GetRow();
				if (getRowID(dw_cell, crow) == L"") SendCtrlCmd(dw_cell, cmd);
				return 1;
			}
		}
		return 0;
	}

	xstring GetNo()
	{
		xstring  typ = L"C";

		xml x ;
		
		xaserverarg arg ;
		
		arg.AddArg(L"count", L"1");
		arg.AddArg(L"type", typ);
		if (xurl::get(L"/sale/data/SO/goods/usegoods/goodslib/asknos", arg.GetString(), x) != 1)return L"";
		return x.text();
	}

	int OnSaveNewItem(xstring content)
	{
		xml x ;
		
		xaserverarg arg ;
		
		arg.AddArg(L"content", content);
		if (xurl::get(L"/sale/data/ProductLibrary3/update/newestproduct", arg.GetString(), x) != 1)
		{
			xstring error = x.text();
			alert(error);
			return -1;
		}
		return 1;
	}

	int OnSaveEx(bool balert = false)
	{
		//dw_cell.AcceptText();

		OnToQuote();
		if (dw_base.GetItemString(1, L"SalespersonID") == L"")OnInit();

		dw_base.AcceptText();
		dw_goods.AcceptText();

		if (dw_base.GetItemString(1, L"QuoteNo") == L"")
		{
			xstring QuoteNo = QuoteView::MakeBillNo();
			dw_base.SetItemString(1, L"QuoteNo", QuoteNo);
			setBaseItem(dw_cell, L"报价单号:", QuoteNo);
		}
		if (dw_base.GetGuid(1) == L"")
			dw_base.SetGuid(1, entityID);

		xml x1 ;
		bool hasNew = false;

		xstring sdate = publiccode::GetCurrentDate();
		xstring suserid = publiccode::GetUser().id;
		xstring categoryID = L"EF37E57D-5833-4AF9-BA5E-01CCF39C1F20";
		xstring folderID = L"10200009-0000-0000-0001-000000000000";

		for (int i = 1; i <= dw_goods.GetRowCount(); i++)
		{
			if (dw_goods.GetItemString(i, L"ItemID") == L"" || dw_goods.GetItemString(i, L"SKUNo") == L"")
			{
				//alert(L"row:"+xstring(i));
				hasNew = true;
				xstring ItemID = GetGuid();
				dw_goods.SetItemString(i, L"ItemID", ItemID);
				xstring Item = L"<Item update.new='1' update.modify='1' guid='" + ItemID + L"'>";
				Item += L"<SKUID>" + ItemID + L"</SKUID>";
				Item += L"<GoodsNo>" + dw_goods.GetItemString(i, L"GoodsNo") + L"</GoodsNo>";
				xstring SKUNo = GetNo();
				dw_goods.SetItemString(i, L"SKUNo", SKUNo);
				dw_goods.Redraw();

				int frow = LookupCellRow(dw_goods.GetGuid(i));
				//alert(dw_goods.GetGuid(1)+L"--"+xstring(frow));
				if (frow > 0) dw_cell.SetItemString(frow, 1, SKUNo);

				Item += L"<No>" + SKUNo + L"</No>";
				Item += L"<SKUNo>" + SKUNo + L"</SKUNo>";
				Item += L"<CName>" + dw_goods.GetItemString(i, L"CName") + L"</CName>";
				Item += L"<EName>" + dw_goods.GetItemString(i, L"ItemName") + L"</EName>";
				Item += L"<Packing>" + dw_goods.GetItemString(i, L"Packing") + L"</Packing>";

				Item += L"<CategoryID>" + categoryID + L"</CategoryID>";
				Item += L"<FolderID>" + folderID + L"</FolderID>";

				Item += L"<CreateID>" + suserid + L"</CreateID>";
				Item += L"<CreateDate>" + sdate + L"</CreateDate>";
				Item += L"<ModifierID>" + suserid + L"</ModifierID>";
				Item += L"<ModifyDate>" + sdate + L"</ModifyDate>";

				Item += L"</Item>";
			}
			if (hasNew)
			{
				xstring newItem = L"<data>" + Item + L"</data>";
				trace(newItem);
				if (OnSaveNewItem(newItem) == -1) return 1;
			}
		}

		xml x ;
		
		xaserverarg arg ;
		
		dw_goods.DwUpdateAllToEx(x);
		dw_base.DwUpdateAllTo(x);

		xstring error = L"";
		arg.AddArg(L"content", x.xml());

		//trace(x.xml());
		//return 1;

		if (xurl::get(L"/sale/data/Quote/update", arg.GetString(), x) != 1)
		{
			error = x.text();
			alert(error);
		}
		else
		{
			xstring str = x.documentElement.getAttribute(L"text");
			if (str == L"true")
			{
				dw_goods.ResetUpdateStatus();
				dw_base.ResetUpdateStatus();
				if (balert)alert(L"保存成功!");

				return -1;

			}
			else
			{
				alert(L"保存失败!");
				return -1;
			}
		}
		return 1;
	}

	xstring GetExchangeRate(xstring pcur, xstring pdate)
	{

		if (pcur.toUpper() == L"RMB") return L"1";
		xstring exchangeRate = L"";
		if (exchangeRate == L"") {
			xml x = ViewObject::RetrieveData(L"/sale/data/GDN3/profit/param", L"item", L"cryrate");
			if (x.selectSingleNode(L"root/item/@value"))
				exchangeRate = x.selectSingleNode(L"root/item/@value").text();
		}
		return exchangeRate;
	}

	xstring GetExchangeRate(xstring pcur)
	{
		return GetExchangeRate(pcur, L"");
	}

	int OnInit()
	{
		//公司抬头、报价人、报价日期
		xstring sdate = publiccode::GetCurrentDate();
		dw_base.SetItemString(1, L"QuoteDate", sdate);
		xstring suserid = publiccode::GetUser().id;
		xstring susername = publiccode::GetUser().name;
		dw_base.SetItemString(1, L"SalespersonID", suserid);
		dw_base.SetItemDisplayString(1, L"SalespersonID", susername);
		dw_base.SetItemString(1, L"CurrencyCode", L"USD");
		dw_base.SetItemDisplayString(1, L"CurrencyCode", L"USD");

		xstring exchangeRate = L"";
		xml x = ViewObject::RetrieveData(L"/sale/data/GDN3/profit/paramEx", L"ETD", sdate);
		if (x.selectSingleNode(L"root/item/@value"))
			exchangeRate = x.selectSingleNode(L"root/item/@value").text();
		if (exchangeRate != L"")
		{
			dw_base.SetItemString(1, L"ExchangeRate", exchangeRate);
		}
		else
		{
			dw_base.SetItemString(1, L"ExchangeRate", L"6.49");
		}

		//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"宁波家尔佳进出口有限公司");

		/*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;
		xstring sCename;
		xml x1 = RetrieveSqlData(ss,L"id",sg);
		KXMLDOMElement e1 = x1.documentElement;
		scguid = sureNodeText(e1,L"CompanyID");
		sCename = sureNodeText(e1,L"CompanyID/@_displaystring");
		*/

		return 1;
	}

	int OnRowChanged(TEvent* evt, LPARAM p)
	{
		DWNMHDR&  hdr = *(DWNMHDR * )evt->notify.pnmh;
		int row = hdr.row;

		return OnQuoteLineChanged(row);
	}

	int OnQuoteLineChanged(int row)
	{
		ximageview im = GetControl(L"im1");
		im.Reset();
		//xstring skuno = dw_goods.GetItemString(row,L"SKUNo");
		//OnShowImage(skuno,row);
		//im.Redraw();

		xstring rowid = dw_goods.GetGuid(row);
		int frow = LookupCellRow(rowid);
		if (frow > 0)
		{
			xstring str = dw_cell.GetItemString(frow, 0);
			trace(L"\r\ncustomer-photo:" + str);
			ShowImageOne(im, str, L"customer-photo");
			im.Redraw();

			RowChanged(frow);
		}
		return 1;
	}

	int OnShowImage(xstring skuno, int row)
	{
		ximageview im = GetControl(L"im1");

		xml xp ;
		xaserverarg arg_pic ;
		arg_pic.AddArg(L"SKUNo", skuno);

		xstring res = L"/sale/data/ProductLibrary3/pref/picture/imagelistSKUNo";
		xstring customerID = dw_base.GetItemString(1, L"CustomerID");
		xstring customerItemNo = dw_goods.GetItemString(row, L"CustomerItemNo");
		if (customerItemNo != L"")
		{
			trace(customerID + L":" + customerItemNo);
			res = L"/sale/data/ProductLibrary3/pref/picture/customer/imagelistSKUNo";
			arg_pic.AddArg(L"CustomerID", customerID);
			arg_pic.AddArg(L"CustomerItemNo", customerItemNo);
		}

		bool hasIamge = false;
		if (xurl::get(res, arg_pic.GetString(), xp) != 1)
		{
			trace(xp.xml());
			return 1;
		}
		else
		{
			KXMLDOMNodeList  nlistp = xp.selectNodes(L"ImageList/image");
			int lenp = nlistp.length();
			for (int ip = 0; ip < lenp; ip++)
			{
				hasIamge = true;
				KXMLDOMElement xitem = nlistp.item(ip);
				xstring picname = xitem.selectSingleNode(L"PicPath").text();
				xstring goodno = xitem.selectSingleNode(L"GoodsNo").text();
				if (picname == L"/business/products/Thumbs//")
					picname = L"/business/products/Thumbs/00/00000000-0000-0000-0000-000000000000.jpg";
				im.AddImages(picname, goodno);
			}
		}
		if (!hasIamge)
		{
			res = L"/sale/data/ProductLibrary3/pref/picture/imagelistSKUNo";
			if (xurl::get(res, arg_pic.GetString(), xp) != 1)
			{
				trace(xp.xml());
				return 1;
			}
			else
			{
				KXMLDOMNodeList nlistp = xp.selectNodes(L"ImageList/image");
				long lenp = nlistp.length();
				for (int ip = 0; ip < lenp; ip++)
				{
					KXMLDOMNode xitem = nlistp.item(ip);
					xstring picname = xitem.selectSingleNode(L"PicPath").text();
					xstring goodno = xitem.selectSingleNode(L"GoodsNo").text();
					if (picname == L"/business/products/Thumbs//")
						picname = L"/business/products/Thumbs/00/00000000-0000-0000-0000-000000000000.jpg";
					im.AddImages(picname, goodno);
				}
			}
		}
		return 1;
	}

	int OnUpdateEntityFile()
	{
		xcell cell1 = GetControl(L"dw_cell1");
		xstring content = cell1.GetData();
		content = content.mid(content.find(L"<xsheet"), 9999999);
		while (true)
		{
			int pos = content.find(L"<display>");
			int pos1 = 0;
			xstring str = L"";
			if (pos >= 0)
			{
				pos1 = content.find(L"</display>", pos);
				str = content.mid(pos1 + L"</display>".length(), 9999999);
				content = content.left(pos) + str;
			}
			else
				break;
		}
		int ret = 1;
		if (content != L"")
		{
			ret = ProcessSendMessage(L"/task/quote/file-update", entityID, content, L"", false);
		}
		return ret;
	}

	int OnUpdateProcessed()
	{
		int ret = ProcessSendMessage(L"/task/quote/update-processed", taskid, L"", L"", false);
		PostMessage(GetFrameWindow().GetHWND(), 0x401, (WPARAM)L"xmRefreshTask", 0);
		return ret;
	}

	int OnUpdate()
	{
		//set rowid
		ensureRowID();

		xstring content = dw_cell.GetData();
		content = content.mid(content.find(L"<xsheet"), 9999999);
		while (true)
		{
			int pos = content.find(L"<display>");
			int pos1 = 0;
			xstring str = L"";
			if (pos >= 0)
			{
				pos1 = content.find(L"</display>", pos);
				str = content.mid(pos1 + L"</display>".length(), 9999999);
				content = content.left(pos) + str;
			}
			else
				break;
		}
		//trace(content);
		xstring business = L"";
		//trace(content);

		if (action == L"new")
		{
			entityID = ViewObject::GetGuid();
			entityItemID = ViewObject::GetGuid();
		}

		//trace(L"\r\nid:"+entityID+L" termid:"+entityItemID);
		business = L"<business action='" + action + L"' id='" + entityID + L"' itemid='" + entityItemID + L"' processurl='" + processurl + L"' termid='" + templateID + L"'>";
		business += L"<content>" + content + L"</content></business>";
		xstring datacontent = GetSaleFullData(dw_cell);
		bool balter = false;
		if (action == L"purch")
			balter = true;

		int ret = ProcessSendMessage(L"/task/quote/update", L"", business, datacontent, balter);
		//int ret =  ProcessSendMessage(L"/task/quote/update", L"", business,false);



		if (action == L"new" && ret == 1) action = L"open";
		return ret;
	}

	int OnSave(bool saveas = false)
	{
		//dw_cell.AcceptText();
		dw_cell.SetRowColumn(1, 1);
		dw_cell.SetAnchorRowColumn(1, 1);

		if (tabsheet != L"tab_quote") OnToQuote();

		if (getBaseItem(dw_cell, L"报价单号:") == L"")
			setBaseItem(dw_cell, L"报价单号:", dw_base.GetItemString(1, L"QuoteNo"));

		OnUpdate();
		if (action == L"purch") return 1;
		return OnSaveEx(true);

		xstring suserid = publiccode::GetUser().id;
		xstring myurl = L"data/QuoteFile/" + suserid;
		xstring sfilename = filename;
		if (filename == L"" || saveas)
		{
			xaserverarg arg ;
			arg.AddArg(L"src", myurl);
			OpenWindow(L"dev:xpage[trade.document.saveas.vx]", arg);
			if (arg.GetArgString(L"result") == L"ok")
			{
				sfilename = arg.GetArgString(L"filename");
			}
			else
				return 1;
		}

		xstring content = dw_cell.GetData();

		xstring sguid = publiccode::GetGuid();
		xstring sname = sguid;
		xstring str = sname.mid(0, 2);
		str = str.toUpper();
		xstring suri = L"attachment" + str;
		int ret = xaserver::UploadData(suri, sguid + L".jpg", content);
		if (ret < 0)
		{
			alert(L"上传文件出错!");
			return 0;
		}

		xml x ;
		xaserverarg args ;
		args.setNativePointer(args.CreateInstance());
		args.AddArg(L"myurl", myurl);
		args.AddArg(L"name", sfilename);
		args.AddArg(L"filepath", sname);
		args.AddArg(L"fileext", L"xdoc");
		args.AddArg(L"filesource", sfilename);
		args.AddArg(L"filesource", sfilename);
		args.AddArg(L"id", fileid);

		xstring path = L"/sale/data/TDocument3/attachment/update";
		if (filename == L"" || saveas) path = L"/sale/data/TDocument3/attachment/add";
		if (xurl::get(path, args.GetString(), x) != 1)
		{
			alert(L"保存出错了!");
			return 0;
		}
		else
		{
			filename = sfilename;
			SetWindowText(GetHWND(), L"报价文件:" + filename);
			alert(x.text());
		}

		return 1;
	}

	int SendCtrlCmd(xcontrol xc, xstring cmd)
	{
		SendMessage(xc.GetHWND(), 0x401, cmd, 0);
		return 1;
	}

	int OnCellClicked(TEvent*, LPARAM p)
	{
		ref DWNMHDR dwhdr = cast(evt.pnmh as ref DWNMHDR);
		int row = dwhdr.row;
		int col = dwhdr.col;
		//xstring col = dwhdr.colname;
		//xstring data = dwhdr.data;

		//alert(xstring(col));
		int startRow = getItemHeadRow(dw_cell);
		if (startRow < 1) return 1;

		if (row < startRow)
		{
			xstring val = dw_cell.GetItemString(row, col);
			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"报价单号:")
				{
					dwhdr.idFrom = -1;
					return 1;
				}
			}
		}
		if (row == startRow)
		{
			dwhdr.idFrom = -1;
			return 1;
		}
		if (row < startRow + 1) return 1;
		startRow++;

		trace(xstring(row) + L"---" + (startRow - 1).toString());

		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 colCustomerPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo");
		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 colSaler = getItemCol(dw_cell, startRow - 1, L"业务员");

		int colVolDesc = getItemCol(dw_cell, startRow - 1, L"体积描述,长X宽X高,长X宽X高(CM)L");
		int colVol = getItemCol(dw_cell, startRow - 1, L"体积,体积(M3)L");
		int colQtyPerPack = getItemCol(dw_cell, startRow - 1, L"装箱数(内/外),装箱数(外/内)L");
		int col40HQ = getItemCol(dw_cell, startRow - 1, L"40HQ,QTY(40HQ)L");
		int 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 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 colSKUNo = getItemCol(dw_cell, startRow - 1, L"SKUID,SKUNo");

		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 colItemPurchDate = getItemCol(dw_cell, startRow - 1, L"业务发送采购时间");

		dwhdr.idFrom = 0;
		if (action != L"purch")
		{
			if (col == colPONote || col == colProductInfo1 || col == colItemNote || col == colPOPhoto || col == colPOPrice || col == colNW || col == colGW || col == colVol || col == colVolDesc)
			{
				dwhdr.idFrom = -1;
				return 1;
			}
			/*if(col==colProductInfo && dw_cell.GetItemString(row,colItemPurchDate)!=L"")
			{
				dwhdr.idFrom = -1;
				return 1;
			}*/
		}

		if (action != L"purched")
		{
			if (col == colBuyer)
			{
				KXMLDOMNodeList items = purcher.selectNodes(L"//HrEmployee");
				int count = items.length();
				xstring pitems = L"";
				for (int i = 0; i < count; i++)
				{
					pitems += L"&lt;row&gt;&lt;显示列&gt;" + items.item(i).selectSingleNode(L"Name").text + L"&lt;/显示列&gt;&lt;数据列&gt;"
						+ items.item(i).selectSingleNode(L"Name").text + L"&lt;/数据列&gt;&lt;/row&gt;";

				}
				xstring prop = L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''>" +
					"<edit edittype='ddlb' ddlbdataurl='' ddlbxml='&lt;data&gt;" + pitems + L"&lt;/data&gt;'/>" +
					"</cellprop>";
				dw_cell.SetCellProps(row, col, prop);
			}
		}

		if (action != L"purch" && action != L"purched")
		{
			/*if(col ==colBuyer)
			{
				KXMLDOMNodeList items = purcher.selectNodes(L"//HrEmployee");
				int count = items.length();
				xstring pitems = L"";
				for(int i=0;i<count;i++)
				{
					pitems += L"&lt;row&gt;&lt;显示列&gt;"+items.item(i).selectSingleNode(L"Name").text+L"&lt;/显示列&gt;&lt;数据列&gt;"
							+items.item(i).selectSingleNode(L"Name").text + L"&lt;/数据列&gt;&lt;/row&gt;";

				}
				xstring prop=L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''>" +
					"<edit edittype='ddlb' ddlbdataurl='' ddlbxml='&lt;data&gt;" + pitems  + L"&lt;/data&gt;'/>" +
					"</cellprop>";
				dw_cell.SetCellProps(row,col,prop);
			}*/
			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>";
				dw_cell.SetCellProps(row, col, proppack);
			}
		}


		//alert(action);
		if (action == L"purch")
		{
			if (col == colPONote2 || col == colProductInfo || col == colCustomerPhoto || col == colSaler || col == colSKUID || col == colQty || col == colBuyerPrice || col == col40HQ || col == colQtyPerPack || col == colPackage || col == colItemNo || col == colItemCName || col == colCustomerItemNo || col == colItemName || col == colItemSpec //|| colBuyer ==col
				|| col == colVol)
			{
				dwhdr.idFrom = -1;
				return 1;
			}
		}

		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 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 = L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''>" +
					"<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='是'/>" +
					"</cellprop>";
				dw_cell.SetCellProps(row, col, prop2);
				dw_cell.Redraw();
			}
			else if (col == colTyp1 || col == colTyp || col == colTyp2 || col == colTyp3)
			{
				xstring pitems1 = L"";
				pitems1 += L"&lt;row&gt;&lt;显示列&gt;成品&lt;/显示列&gt;&lt;数据列&gt;"
					+ L"成品&lt;/数据列&gt;&lt;/row&gt;";
				pitems1 += L"&lt;row&gt;&lt;显示列&gt;散货&lt;/显示列&gt;&lt;数据列&gt;"
					+ L"散货&lt;/数据列&gt;&lt;/row&gt;";
				pitems1 += L"&lt;row&gt;&lt;显示列&gt;包装&lt;/显示列&gt;&lt;数据列&gt;"
					+ L"包装&lt;/数据列&gt;&lt;/row&gt;";
				xstring prop1 = L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''>" +
					"<edit edittype='ddlb' ddlbdataurl='' ddlbxml='&lt;data&gt;" + pitems1 + L"&lt;/data&gt;'/>" +
					"</cellprop>";
				dw_cell.SetCellProps(row, col, prop1);
			}
		}
		if (ARow != row) RowChanged(row);
		ARow = row;
		ACol = col;
		//orivalue = dw_cell.GetItemString(ARow,ACol);

		return 1;
	}


	int OnCellClicked1(TEvent*, LPARAM p)
	{
		ref DWNMHDR dwhdr = cast(evt.pnmh as ref DWNMHDR);
		int row = dwhdr.row;
		int col = dwhdr.col;
		//xstring col = dwhdr.colname;
		//xstring data = dwhdr.data;

		//alert(xstring(col));
		int startRow = getItemHeadRow(dw_cell);
		if (startRow < 1) return 1;
		if (row == startRow)
		{
			dwhdr.idFrom = -1;
			return 1;
		}
		if (row < startRow + 1) return 1;
		startRow++;

		trace(xstring(row) + L"---" + (startRow - 1).toString());

		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 colCustomerPhoto = getItemCol(dw_cell, startRow - 1, L"Photo,Customer Photo");
		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 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 colSKUNo = getItemCol(dw_cell, startRow - 1, L"SKUID,SKUNo");

		dwhdr.idFrom = 0;
		if (action != L"purch")
		{
			if (col == colPONote || col == colPOPhoto || col == colPOPrice || col == colNW || col == colGW || col == colVol || col == colVolDesc)
			{
				dwhdr.idFrom = -1;
				return 1;
			}
		}

		if (ACol == colFOBPrice && (col != colFOBPrice || row != ARow) && ARow >= startRow)
		{
			xstring fobprice = dw_cell.GetItemString(ARow, ACol);
			if (fobprice.left(1) != L"$") dw_cell.SetItemString(ARow, ACol, L"$" + fobprice);
		}

		if (action != L"purch" && action != L"purched")
		{
			if (col == colBuyer)
			{
				KXMLDOMNodeList items = purcher.selectNodes(L"//HrEmployee");
				int count = items.length();
				xstring pitems = L"";
				for (int i = 0; i < count; i++)
				{
					pitems += L"&lt;row&gt;&lt;显示列&gt;" + items.item(i).selectSingleNode(L"Name").text + L"&lt;/显示列&gt;&lt;数据列&gt;"
						+ items.item(i).selectSingleNode(L"Name").text + L"&lt;/数据列&gt;&lt;/row&gt;";

				}
				xstring prop = L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''>" +
					"<edit edittype='ddlb' ddlbdataurl='' ddlbxml='&lt;data&gt;" + pitems + L"&lt;/data&gt;'/>" +
					"</cellprop>";
				dw_cell.SetCellProps(row, col, prop);
			}
			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>";
				dw_cell.SetCellProps(row, col, proppack);
			}
		}

		if (ACol == colItemNo && col != colItemNo && dw_cell.GetItemString(ARow, colItemNo) != orivalue)
		{
			trace(L"/r/n--------------------");
			if (dw_cell.GetItemString(ARow, colItemNo) != L"")
			{
				xaserverarg argx ;
				argx.setNativePointer(argx.CreateInstance());
				argx.AddArg(L"GoodsNo", dw_cell.GetItemString(ARow, colItemNo));
				OpenWindow(L"dev:xpage[CustomerItemNoList.vx]", cast(argx as int));
				if (argx.GetArgString(L"action") != L"ok")
				{
					ARow = row;
					ACol = col;
					orivalue = dw_cell.GetItemString(row, col);
					return 1;
				}

				xml x1 ;
				
				x1.loadXML(argx.GetArgString(L"items"));
				if (x1.selectSingleNode(L"//CustomerItemNo"))
				{
					xstring CustomerItemNo = x1.selectSingleNode(L"//CustomerItemNo").text();
					dw_cell.SetItemString(ARow, colCustomerItemNo, CustomerItemNo);
				}

				xml goods = GetProduct(dw_cell.GetItemString(ARow, colItemNo));

				if (goods)
				{
					dw_cell.SetItemString(ARow, colCustomerPhoto, L"");
					resetRowTerm(dw_cell, ARow, L"customer-photo");
					if (goods.selectSingleNode(L"//SKUID[1]"))
					{
						setRowProp(dw_cell, ARow, L"SKUID", goods.selectSingleNode(L"//SKUID[1]").text());
					}
					if (goods.selectSingleNode(L"//SKUNo[1]"))
					{
						dw_cell.SetItemString(ARow, colSKUNo, goods.selectSingleNode(L"//SKUNo[1]").text());
					}
					if (goods.selectSingleNode(L"//EName[1]"))
						dw_cell.SetItemString(ARow, colItemName, goods.selectSingleNode(L"//EName[1]").text());
					if (goods.selectSingleNode(L"//CName[1]"))
						dw_cell.SetItemString(ARow, colItemCName, goods.selectSingleNode(L"//CName[1]").text());
					if (goods.selectSingleNode(L"//Packing[1]"))
						dw_cell.SetItemString(ARow, colPackage, goods.selectSingleNode(L"//Packing[1]").text());
					if (goods.selectSingleNode(L"//POCreatorID[1]"))
					{
						dw_cell.SetItemString(ARow, colBuyer, goods.selectSingleNode(L"//POCreatorID[1]").text());
					}
					if (goods.selectSingleNode(L"//PackingRate[1]"))
					{
						if (goods.selectSingleNode(L"//InnerQty[1]"))
						{
							xstring str1 = goods.selectSingleNode(L"//PackingRate[1]").text();
							xstring str2 = goods.selectSingleNode(L"//InnerQty[1]").text();
							dw_cell.SetItemString(ARow, colQtyPerPack, str2 + L"/" + str1);
						}
						else
						{
							xstring str1 = goods.selectSingleNode(L"//PackingRate[1]").text();
							dw_cell.SetItemString(ARow, colQtyPerPack, str1);
						}
					}
					ProcessItemImage(dw_cell.GetItemString(ARow, colSKUNo), ARow);
					//ProcessItemImage1(dw_cell.GetItemString(ARow,colItemNo),ARow);
					dw_cell.SetRowColumn(row, col);
					dw_cell.SetAnchorRowColumn(row, col);
				}
			}
		}

		if (((ACol == colVolDesc && (col != colVolDesc || row != ARow)) || (ACol == colQtyPerPack && (col != colQtyPerPack || row != ARow))) && ARow >= startRow)
		{
			/*计算体积*/
			xstring desc = dw_cell.GetItemString(ARow, colVolDesc);
			if (desc == L"")
				dw_cell.SetItemString(ARow, colVol, L"");
			else
			{
				double v = calcVol(desc) / 1000000.00;
				xstring str = xstring(v);
				if (str.find(L".") >= 0)	str = str.left(str.find(L".") + 5);
				dw_cell.SetItemString(ARow, colVol, str);
				dw_cell.Redraw();
			}

			xstring qtyperPack = dw_cell.GetItemString(ARow, colQtyPerPack);
			if (qtyperPack != L"")
			{
				xstring qty1 = qtyperPack;
				xstring qty2 = L"";
				double qty = 0.00;
				int pos2 = qtyperPack.find(L"/");
				if (pos2 >= 0)
				{
					qty1 = qtyperPack.left(qtyperPack.find(L"/"));
					qty2 = qtyperPack.mid(qtyperPack.find(L"/") + 1, 9999);
				}
				if (qty1 != L"") qty = qty1.toDouble();
				if (qty2 != L"") qty = qty * qty2.toDouble();
				double ttl = 65.0 * qty / v;
				dw_cell.SetItemString(ARow, col40HQ, ttl.toInt().toString());
			}
		}

		//alert(action);
		if (action == L"purch")
		{
			if (col == colSKUID || col == colQty || col == colBuyerPrice || col == col40HQ || col == colQtyPerPack || col == colPackage || col == colItemNo || col == colItemCName || col == colCustomerItemNo || col == colItemName || col == colItemSpec || colBuyer == col
				|| col == colVol)
			{
				dwhdr.idFrom = -1;
				return 1;
			}
		}

		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 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"</cellprop>";
				dw_cell.SetCellProps(row, col, prop2);
				dw_cell.Redraw();
			}
			else if (col == colTyp1 || col == colTyp)
			{
				xstring pitems1 = L"";
				pitems1 += (xstring)L"&lt;row&gt;&lt;显示列&gt;成品&lt;/显示列&gt;&lt;数据列&gt;"
					+ L"成品&lt;/数据列&gt;&lt;/row&gt;";
				pitems1 += (xstring)L"&lt;row&gt;&lt;显示列&gt;散货&lt;/显示列&gt;&lt;数据列&gt;"
					+ L"散货&lt;/数据列&gt;&lt;/row&gt;";
				pitems1 += (xstring)L"&lt;row&gt;&lt;显示列&gt;包装&lt;/显示列&gt;&lt;数据列&gt;"
					+ L"包装&lt;/数据列&gt;&lt;/row&gt;";
				xstring prop1 = (xstring)L"<cellprop searchcolumn='' celltype='' cellformatex='' cellformat='' cellprotectex='' cellprotect='' cellvisibleex='' cellvisible='' cellneeddata='' cellvalid='' cellinitial='' cellsource='' fontstyle='' windowurl=''>" +
					"<edit edittype='ddlb' ddlbdataurl='' ddlbxml='&lt;data&gt;" + pitems1 + L"&lt;/data&gt;'/>" +
					"</cellprop>";
				dw_cell.SetCellProps(row, col, prop1);
			}



			if (((colPrice != col && colPrice1 != col) || row != ARow) && bPurchPrice)
			{
				if (bPurchPrice && action == L"purch")
				{
					xstring price0 = dw_cell.GetItemString(ARow, colPrice0);
					xstring price1 = dw_cell.GetItemString(ARow, colPrice1);
					xstring price = price0;
					if (price0 != L"")
					{
						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");
						}
					}
					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");
						}
						price = price0 + L"+L" + price1;
					}
					dw_cell.SetItemString(ARow, colPrice, price);
				}
			}
			if (colPrice0 != col && colPrice1 != col)
				bPurchPrice = false;
			else
				bPurchPrice = true;

		}
		if (ARow != row) RowChanged(row);
		ARow = row;
		ACol = col;
		orivalue = dw_cell.GetItemString(ARow, ACol);

		return 1;
	}

	int OnImgDBClicked(TEvent* evt, LPARAM pr)
	{
		IMGNNMHDR& nmtv = *(IMGNNMHDR*)evt->notify.pnmh;
		xstring src = nmtv.path;
		/*if(src.length() > 60)
			src = src.right(44);
		else
			src=src.mid(src.find(L"Thumbs", 0)+6, 50);
		*/
		xaserverarg arg ;
		
		//arg.AddArg(L"src",L"/business/products/chanpin"+src);	
		arg.AddArg(L"src", src);

		//win::OpenWindow(L"dev:xpage[BigPicture.vx]",arg);	

		int h = openUrl(L"/sale/view/ProductLibrary/xpage/bigpictureview", &arg);
		return 1;
		/*
		xwin x = new xwin;
		x.setNativePointer(h);
		m_winHwnd = x.GetHWND();

		xstring sh = doc.GetXml();
		int p = cast(sh as int);
		win32::SendMessage(m_winHwnd, 0x401, p, 0);
		*/
		return 1;
	}

	//命令处理事件
	int OnXCommand(TEvent * evt, LPARAM param)
	{
		return OnCmdDispatch(evt->xcommand.pStrID);
	}

	int OnAttachListon()
	{
		//绑定工具条点击事件
		AttachEvent(L"WM_XCOMMAND", OnXCommand);
		//获取焦点事件，用于重置工具条
		AttachEvent(L"WM_SETFOCUS", OnSetFocus);

		AttachEvent(L"frame:im1", L"IMG_LDBCLICK", OnImgDBClicked);

		AttachEvent(L"dw_base", L"DWV_ITEMCHANGED", OnItemChanged);
		AttachEvent(L"dw_goods", L"DWV_ROWFOCUSCHANGED", OnRowChanged);

		AttachEvent(L"dw_cell", L"DWV_CLICKED", OnCellClicked);
		AttachEvent(L"dw_cell", L"CELL_ITEMCHANGED", OnCellItemChanged);
		AttachEvent(L"dw_cell", L"CELL_SELECTCHANGED", OnCellSelectChanged);
		return 1;
	}

	/*
	int  OnRetrieve()
	{
		xml x ;
		
		xaserverarg arg ;
		
		arg.AddArg(L"xxx",L"xxx");
		if (getUrl(L"",arg.GetString(),x)!=1)
		{
			trace(x.text());
			return -1;
		}else
		{
			//dw_list.Retrieve(x);
			//dw_list.Redraw();
		}
		return 1;
	}
	*/

	int SyncPurch(xml x)
	{
		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 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 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 LastRow = dw_cell.GetValidRow();
		KXMLDOMNodeList items = x.selectNodes(L"//Item");
		int size = items.length();
		for (int i = 0; i < size; i++)
		{
			KXMLDOMElement ele = items.item(i);
			xstring rowid = ele.selectSingleNode(L"RowID").text();
			xstring BuyerPrice = ele.selectSingleNode(L"BuyerPrice").text();
			xstring BuyerRemark = L"";
			xstring FactoryImage = L"";
			xstring GWT = L"";
			xstring NWT = L"";
			xstring VolDesc = L"";
			xstring Vol = L"";
			xstring F40HQ = L"";
			xstring PurchedDate = L"";
			xstring supplierphoto = L"";
			xstring  productInfo = L"";
			xstring  productInfo1 = L"";
			xstring  EnquiryLineID = L"";
			xstring  Buyer = L"";

			if (ele.selectSingleNode(L"BuyerRemark")) BuyerRemark = ele.selectSingleNode(L"BuyerRemark").text();
			if (ele.selectSingleNode(L"FactoryImage"))FactoryImage = ele.selectSingleNode(L"FactoryImage").text();
			if (ele.selectSingleNode(L"GWT")) GWT = ele.selectSingleNode(L"GWT").text();
			if (ele.selectSingleNode(L"NWT")) NWT = ele.selectSingleNode(L"NWT").text();
			if (ele.selectSingleNode(L"VolDesc")) VolDesc = ele.selectSingleNode(L"VolDesc").text();
			if (ele.selectSingleNode(L"Vol")) Vol = ele.selectSingleNode(L"Vol").text();
			if (ele.selectSingleNode(L"F40HQ")) F40HQ = ele.selectSingleNode(L"F40HQ").text();
			if (ele.selectSingleNode(L"PurchedDate")) PurchedDate = ele.selectSingleNode(L"PurchedDate").text();
			trace(L"\r\n******" + PurchedDate);
			if (ele.selectSingleNode(L"supplier-photo")) supplierphoto = ele.selectSingleNode(L"supplier-photo").text();
			if (ele.selectSingleNode(L"ProductInfo")) productInfo = ele.selectSingleNode(L"ProductInfo").text();
			if (ele.selectSingleNode(L"ProductInfo1")) productInfo1 = ele.selectSingleNode(L"ProductInfo1").text();
			if (ele.selectSingleNode(L"EnquiryLineID")) EnquiryLineID = ele.selectSingleNode(L"EnquiryLineID").text();
			if (ele.selectSingleNode(L"Buyer")) Buyer = ele.selectSingleNode(L"Buyer").text();

			trace(L"\r\nsupplierphoto:" + supplierphoto);
			for (int row = startRow; row <= LastRow; row++)
			{
				if (dw_cell.GetItemString(row, colItemName) == L"" &&
					dw_cell.GetItemString(row, colItemSpec) == L"") break;
				if (getRowID(dw_cell, row) == rowid)
				{
					dw_cell.SetItemString(row, colBuyerPrice, BuyerPrice);
					dw_cell.SetItemString(row, colBuyerRemark, BuyerRemark);
					dw_cell.SetItemString(row, colFactoryImage, FactoryImage);
					dw_cell.SetItemString(row, colGWT, GWT);
					dw_cell.SetItemString(row, colNWT, NWT);
					dw_cell.SetItemString(row, colVolDesc, VolDesc);
					dw_cell.SetItemString(row, colVol, Vol);
					dw_cell.SetItemString(row, col40HQ, F40HQ);
					dw_cell.SetItemString(row, colPurchedDate, PurchedDate);
					dw_cell.SetItemString(row, colProductInfo, productInfo);
					dw_cell.SetItemString(row, colProductInfo1, productInfo1);
					if (Buyer != L"") dw_cell.SetItemString(row, colBuyer, Buyer);
					if (EnquiryLineID != L"") setRowTerm(dw_cell, row, L"EnquiryLineID", EnquiryLineID);
					if (supplierphoto != L"") setRowTerm(dw_cell, row, L"supplier-photo", supplierphoto);

					xstring props = dw_cell.GetCellProps(row, colPhoto1);
					props = L"<cellprop><edit edittype='image'/></cellprop>";
					dw_cell.SetCellProps(row, colPhoto1, props);

					break;
				}
			}
		}
		return 1;
	}

	int SyncPurch(xstring entityid)
	{
		xml x ;
		
		xaserverarg arg ;
		
		arg.AddArg(L"entityid", entityid);
		//alert(id);
		if (getUrl(L"/sale/data/TO/quote/purchared/item", arg.GetString(), x) != 1)
		{
			trace(x.text());
			return -1;
		}
		return SyncPurch(x);
	}

	int  OnRetrieve(xstring id)
	{
		xml x ;
		
		xaserverarg arg ;
		
		arg.AddArg(L"id", id);
		//alert(id);
		if (getUrl(L"/sale/data/Quote/maint", arg.GetString(), x) != 1)
		{
			trace(x.text());
			return -1;
		}
		else
		{
			dw_base.Retrieve(x);
			dw_base.Redraw();
			dw_goods.Retrieve(x);
			dw_goods.Redraw();
		}
		return 1;
	}

	int onload()
	{
		Reset();
		orivalue = L"";
		ARow = 1;
		ACol = 1;

		tabsheet = L"tab_bill";
		templateID = L"ECDDE57A-43EB-49DD-9287-DC5D0B29ECA1";
		xstring templ = L"";
		taskid = L"";
		xaserverarg  arg;
		if (GetParam()) {
			arg ;
			arg.setNativePointer(GetParam());
			templ = arg.GetArgString(L"template");
			entityID = arg.GetArgString(L"EntityID");
			taskid = arg.GetArgString(L"TaskID");
			if (entityID != L"")action = L"open";

			trace(L"\r\nentity:" + entityID + L" taskid:" + taskid);
		}
		dw_cell = GetControl(L"dw_cell");

		if (templ != L"")
		{
			/*xml x ;
			x.setNativePointer(x.CreateInstance());
			x.loadXML(templ);
			*/
			action = L"purch";

			if (templ.find(L"action=\"") >= 0)
			{
				action = templ.mid(templ.find(L"action=\"") + 8, templ.find(L"\"", templ.find(L"action=\"") + 8) - (templ.find(L"action=\"") + 8));
			}
			if (action == L"") action = L"purch";
			if (templ.find(L"TemplateItemID=\"") >= 0)
			{
				entityItemID = templ.mid(templ.find(L"TemplateItemID=\"") + 16, templ.find(L"\"", templ.find(L"TemplateItemID=\"") + 16) - (templ.find(L"TemplateItemID=\"") + 16));
			}
			if (entityItemID == L"")
			{
				if (templ.find(L" ItemID=\"") >= 0)
				{
					entityItemID = templ.mid(templ.find(L" ItemID=\"") + 9, templ.find(L"\"", templ.find(L" ItemID=\"") + 9) - (templ.find(L" ItemID=\"") + 9));
				}
			}

			/*action = x.documentElement.getAttribute(L"action");
			if(action==L"") action=L"purch";
			entityItemID = x.documentElement.getAttribute(L"TemplateItemID");
			if(entityItemID==L"")entityItemID = x.documentElement.getAttribute(L"ItemID");
			*/
			OpenDocument(entityItemID);
			if (action == L"purched")
			{
				//SyncPurch(x);
				SyncPurch(entityID);
			}
		}
		else
		{
			/*
			templateurl = L"/sale/view/Enquiry3/template/EnquiryQuote";
			if(kind==L"2")
				templateurl = L"/sale/view/Enquiry3/template/EnquiryBill";

			dw_cell.openUrl(templateurl);
			*/
			//win32::SetWindowText(GetHWND(),L"报价文件:[new]");
		}

		ARow = 0;
		ACol = 0;
		bPurchPrice = false;

		dw_goods = GetControl(L"dw_goods");
		//dw_goods .openUrl(L"/sale/view/Quote3/template/goods");
		dw_goods.openUrl(L"/sale/view/Quote3/template/item/pricelist");
		dw_goods.SetColumnState(L"ItemID", false);
		dw_goods.SetColumnState(L"EnquiryLineID", false);
		//dw_goods.SetColumnState(L"EnquiryPriceListID",false);
		dw_goods.SetColumnState(L"POPrices", false);
		dw_goods.SetColumnState(L"ClassifyID", false);
		dw_goods.SetColumnState(L"Description", false);
		dw_goods.SetColumnState(L"CName", false);
		dw_goods.SetColumnState(L"QuoteLineID", false);
		dw_goods.SetColumnState(L"SKUID", false);

		dw_goods.SetAskStyle(true);

		dw_base = GetControl(L"dw_base");
		dw_base.openUrl(L"/sale/view/Quote3/template/base");
		//dw_base.SetSelectionBorder(0);
		dw_base.SetColHeaderHeight(0);
		dw_base.SetRowSelectorWidth(0);
		dw_base.SetHScrollState(false);
		dw_base.SetVScrollState(false);

		if (entityID != L"")
		{
			OnRetrieve(entityID);
			if (templ == L"")OpenDocumentEntity(entityID);
			//if(action==L"purched")SyncPurch(x);				
		}
		else
		{
			if (templ == L"")
			{
				OnInit();
				OpenTemplate(templateID);
			}
		}

		OnAttachEvent();
		filename = L"";

		/*	#define LayerFlow_None			0x00000001		//not layer space
		#define LayerFlow_WE			0x00000002
		#define LayerFlow_NS			0x00000004
		#define LayerFlow_FreeForm		0x00000008
		#define LayerFlow_Control		0x00000010
		#define LayerFlow_HtmlFlow		0x00000020
		#define LayerFlow_Sheets		0x00000040
		#define LayerFlow_Hidden		0x00000080		//not show but layer space
		#define LayerFlow_UnLayer		0x00000100		//not show and not layer space

		#define	LayerFlow_NotLayerNode	(LayerFlow_None | LayerFlow_UnLayer)
		#define LayerFlow_LayerChild	(LayerFlow_WE|LayerFlow_NS|LayerFlow_FreeForm|LayerFlow_Sheets| LayerFlow_HtmlFlow )
		*/

		if (action == L"purch")
		{
			xnode anode = GetAgentNode(L"tabheader");
			anode.SetLayerFlow(0x00000100);
			dw_cell.SetColumnCount(dw_cell.GetValidCol() + 6);
		}
		else
			dw_cell.SetColumnCount(dw_cell.GetValidCol());

		//OnRetrieve();

		return 1;
	}

	xstring GetMySupplier()
	{
		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 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"";
		for (int row = startRow; row <= LastRow; row++)
		{
			if (dw_cell.GetItemString(row, colItemName) == L"" &&
				dw_cell.GetItemString(row, colItemSpec) == L"") break;

			xstring itemStr = L"";
			if (colSupplier >= 1)
			{
				if (dw_cell.GetItemString(row, colSupplier) != L"")
				{
					if (hasParty(dw_cell.GetItemString(row, colSupplier)) == false)
					{
						itemStr += L"<Item update.new='1' update.modify='1'>";
						itemStr += L"<Name>" + dw_cell.GetItemString(row, colSupplier) + L"</Name>";
						itemStr += L"<ShortName>" + dw_cell.GetItemString(row, colSupplier) + L"</ShortName>";
						itemStr += L"</Item>";
					}
				}
			}
			if (colSupplier1 >= 1)
			{
				if (dw_cell.GetItemString(row, colSupplier1) != L"")
				{
					if (hasParty(dw_cell.GetItemString(row, colSupplier1)) == false)
					{
						itemStr += L"<Item update.new='1' update.modify='1'>";
						itemStr += L"<Name>" + dw_cell.GetItemString(row, colSupplier1) + L"</Name>";
						itemStr += L"<ShortName>" + dw_cell.GetItemString(row, colSupplier1) + L"</ShortName>";
						itemStr += L"</Item>";
					}
				}
			}
			if (colSupplier2 >= 1)
			{
				if (dw_cell.GetItemString(row, colSupplier2) != L"")
				{
					if (hasParty(dw_cell.GetItemString(row, colSupplier2)) == false)
					{
						itemStr += L"<Item update.new='1' update.modify='1'>";
						itemStr += L"<Name>" + dw_cell.GetItemString(row, colSupplier2) + L"</Name>";
						itemStr += L"<ShortName>" + dw_cell.GetItemString(row, colSupplier2) + L"</ShortName>";
						itemStr += L"</Item>";
					}
				}
			}
			if (colSupplier3 >= 1)
			{
				if (dw_cell.GetItemString(row, colSupplier3) != L"")
				{
					if (hasParty(dw_cell.GetItemString(row, colSupplier3)) == false)
					{
						itemStr += L"<Item update.new='1' update.modify='1'>";
						itemStr += L"<Name>" + dw_cell.GetItemString(row, colSupplier3) + L"</Name>";
						itemStr += L"<ShortName>" + dw_cell.GetItemString(row, colSupplier3) + L"</ShortName>";
						itemStr += L"</Item>";
					}
				}
			}
			if (itemStr != L"") content += itemStr;
		}
		xstring newEntityItemID = ViewObject::GetGuid();
		content = L"<data>" + content + L"</data>";
		return content;
	}


	int OnMySupplier()
	{
		if (action != L"purch") return 1;
		xstring content = GetMySupplier();
		xaserverarg arg ;
		arg.setNativePointer(xaserverarg::CreateInstance());
		arg.AddArg(L"value", content);
		OpenWindow(L"dev:xpage[QuoteSupplierItem.vx]", cast(arg as int));

		return 1;
	}

	bool hasParty(xstring name)
	{
		xml x ;
		
		xaserverarg arg ;
		arg.setNativePointer(xaserverarg::CreateInstance());
		arg.AddArg(L"Name", name);
		if (getUrl(L"/sale/data/SupplierV3/HasParty", arg.GetString(), x) != 1)
		{
			alert(L"error:" + x.xml());
		}
		xstring count = x.documentElement.getAttribute(L"count");
		if (count != L"0") return true;

		return false;
	}

	int LoadPurcher()
	{
		purcher ;
		purcher.setNativePointer(xml::CreateInstance());
		xaserverarg arg ;
		arg.setNativePointer(xaserverarg::CreateInstance());
		arg.AddArg(L"id", L"采购员");
		if (getUrl(L"/sale/data/Quote/Purcher", arg.GetString(), purcher) != 1)
		{
			alert(L"error:" + purcher.GetXml());
		}
		return 1;
	}

	xstring GetPurchorByName(xstring name)
	{
		KXMLDOMNode n = purcher.selectSingleNode(L"//HrEmployee[Name='" + name + L"']/EmployeeID");
		if (n)
		{
			return n.text();
		}
		else
			return L"";

	}

	int onloaded()
	{
		SetAgent();
		LoadPurcher();

		xaserverarg  arg;
		if (GetParam()) {
			arg ;
			arg.setNativePointer(GetParam());
			if (arg.GetArgString(L"bill.purchor") == L"1") OnNextPurch();
		}
		return 1;
	}
};