| | |
| | | public: |
| | | xhtml ole_print; |
| | | xcell cell; |
| | | xstring m_SupplierName; |
| | | xstring m_EntityName; |
| | | xstring m_EntityID; |
| | | xstring m_EntityNo; |
| | |
| | | #endif |
| | | |
| | | |
| | | xstring GetSaveFileName(xstring initFileName, xstring filter, xstring ext) |
| | | xstring GetMySaveFileName(xstring initFileName, xstring filter, xstring ext) |
| | | { |
| | | wchar_t szFileName[255]; |
| | | wchar_t szPath[255]; |
| | | szFileName[0] = 0; |
| | | szPath[0] = 0; |
| | | wchar_t szFileName[255] = { 0 }; |
| | | wchar_t szPath[255] = { 0 }; |
| | | |
| | | if(initFileName !=L"") |
| | | { |
| | |
| | | } |
| | | |
| | | int nFilterIndex = 1; |
| | | OPENFILENAMEW ofn; |
| | | |
| | | ofn.lStructSize = 88;//sizeof(ofn); |
| | | ofn.hwndOwner = 0; |
| | | OPENFILENAMEW ofn = { 0 }; |
| | | //::ZeroMemory(&ofn,sizeof(OPENFILENAMEW)) |
| | | //ofn.lStructSize = 88;//sizeof(ofn); |
| | | ofn.lStructSize = sizeof(ofn); |
| | | ofn.hwndOwner = GetHWND(); |
| | | ofn.hInstance = 0; |
| | | ofn.lpstrFilter = filter; |
| | | //"JPEG 文件(*.jpg)\0*.jpg;*.jpeg;*.png;*.gif;*.bmp\0全部文件(*.*)\0*.*\0"; |
| | |
| | | if(m_EntityName==L"SaleOrder") pre=L"PI"; |
| | | if(m_EntityName==L"GDN3")pre=L"INV"; |
| | | } |
| | | xstring file1 = GetSaveFileName(pre+m_EntityNo+L".xlsx", |
| | | if (m_EntityName == L"VATNotify")m_EntityNo = m_EntityNo + m_SupplierName; |
| | | xstring file1 = GetMySaveFileName(pre+m_EntityNo+L".xlsx", |
| | | L"Excel1文件(*.xlsx)\0*.xlsx;*.xls\0Excel97文件(*.xls)\0*.xls\0PDF文件(*.pdf)\0*.pdf\0", |
| | | L"xlsx"); |
| | | if(file1 ==L"") return 1; |
| | |
| | | |
| | | xstring DownLoadPaperPic(xstring guid) |
| | | { |
| | | |
| | | xstring path = xutil::GetModuleTmpPath(); |
| | | xstring ext = L"jpg"; |
| | | xstring filename = guid + L"." + ext; |
| | |
| | | dataUrl = L"/sale/data/"+sEntityName+ L"/"+ dataUrl; |
| | | if(!m_dataset) |
| | | { |
| | | xml x0 = new xml; |
| | | xml x0 ; |
| | | if (xurl::get(dataUrl,arg.GetString(),x0) != 1) |
| | | { |
| | | alert(L"数据集出错了!"); |
| | |
| | | xstring skuno = tail.mid(spos,pos1 - spos ).trim(); |
| | | xstring CustomerID=L""; |
| | | xstring CustomerItemNo=L""; |
| | | if(skuno.find(L",L")>0) |
| | | if(skuno.find(L",")>0) |
| | | { |
| | | CustomerID = skuno.left(skuno.find(L",L")).trim(); |
| | | skuno = skuno.mid(skuno.find(L",L")+1,256).trim(); |
| | | CustomerID = skuno.left(skuno.find(L",")).trim(); |
| | | skuno = skuno.mid(skuno.find(L",")+1,256).trim(); |
| | | } |
| | | if(skuno.find(L",L")>0) |
| | | if(skuno.find(L",")>0) |
| | | { |
| | | CustomerItemNo = skuno.left(skuno.find(L",L")).trim(); |
| | | skuno = skuno.mid(skuno.find(L",L")+1,256).trim(); |
| | | CustomerItemNo = skuno.left(skuno.find(L",")).trim(); |
| | | skuno = skuno.mid(skuno.find(L",")+1,256).trim(); |
| | | } |
| | | xstring src = DownLoadSKUNoPic(skuno,CustomerID,CustomerItemNo); |
| | | head += tail.left(pos) + L"src=\"" + src; |
| | |
| | | |
| | | int updateHtml() |
| | | { |
| | | return 1; |
| | | IHTMLDocument3* doc = (IHTMLDocument3 * )ole_print.GetHtmlDocument(); |
| | | IHTMLElementCollection* rows; |
| | | IHTMLElementCollection* rows = NULL; |
| | | IHTMLElementCollection* rows2 = NULL; |
| | | doc->getElementsByTagName((BSTR)L"tr",&rows); |
| | | IHTMLElementCollection* rows2; |
| | | doc->getElementsByTagName((BSTR)L"td",&rows2); |
| | | long len; |
| | | rows->get_length(&len); |
| | |
| | | m_EntityID = arg.GetArgString(L"EntityID"); |
| | | m_EntityNo = arg.GetArgString(L"EntityNo"); |
| | | m_EntityName = arg.GetArgString(L"EntityName"); |
| | | m_SupplierName = arg.GetArgString(L"SupplierName"); |
| | | m_DocumentID = L""; |
| | | |
| | | OnHtml(arg); |
| | |
| | | SendCtrlCmd(cell,L"xmFormatShowGrid"); |
| | | showgrid = true; |
| | | }*/ |
| | | xml x1 = new xml; |
| | | xml x1 ; |
| | | |
| | | xstring content1 = x.xml(); |
| | | content1 = content1.replace(L"[空]",L" ",0); |
| | |
| | | m_EntityID = arg.GetArgString(L"EntityID"); |
| | | m_EntityNo = arg.GetArgString(L"EntityNo"); |
| | | m_EntityName = arg.GetArgString(L"EntityName"); |
| | | m_SupplierName = arg.GetArgString(L"SupplierName"); |
| | | m_DocumentID = L""; |
| | | OnHtml(arg); |
| | | } |
| | |
| | | content = content.replace(L" ",L"[空]",0); |
| | | content = content.replace(L"&",L"",0); |
| | | |
| | | xml x0 = new xml; |
| | | xml x0 ; |
| | | x0.loadXML(L"<Bill/>"); |
| | | x0.documentElement().settext(content); |
| | | content = x0.xml(); |
| | |
| | | |
| | | x.loadXML(ls_xml); |
| | | xaserverarg arg; |
| | | arg.setNativePointer(xaserverarg::CreateInstance()); |
| | | |
| | | arg.AddArg(L"content", x.xml()); |
| | | |
| | | if(xurl::get(L"/sale/data/DocumentList3/bill/update", arg.GetString(),x)!=1) |
| | |
| | | m_EntityID = arg.GetArgString(L"EntityID"); |
| | | m_EntityNo = arg.GetArgString(L"EntityNo"); |
| | | m_EntityName = arg.GetArgString(L"EntityName"); |
| | | m_SupplierName = arg.GetArgString(L"SupplierName"); |
| | | m_DocumentID = L""; |
| | | return 1; |
| | | } |
| | |
| | | ole_print.ExecWB(27,0); |
| | | return 1; |
| | | alert(L"xxx"); |
| | | xml x1 = new xml; |
| | | xml x1 ; |
| | | |
| | | xaserver::ExecXQuery(GetServerUrl(), L"[xsl.getdevobj.xq]",L"<args/>",x1); |
| | | } |
| | |
| | | m_EntityID = arg.GetArgString(L"EntityID"); |
| | | m_EntityNo = arg.GetArgString(L"EntityNo"); |
| | | m_EntityName = arg.GetArgString(L"EntityName"); |
| | | m_SupplierName = arg.GetArgString(L"SupplierName"); |
| | | m_DocumentID = L""; |
| | | } |
| | | }else |