输出Word Excel

function choseCode(code,customerID,payment,saleStaff,contactType,paymentTerm,invoiceDeliver)
{
  parent.opener.document.all("contacter").length=0;
  parent.opener.document.all("customerID").value=customerID;
  parent.opener.document.all("customerInfo").value=document.all(code).value;
  if(parent.opener.document.all("paymentMethodID"))
     parent.opener.document.all("paymentMethodID").value=payment;
  if(parent.opener.document.all("salesStaffID"))
     parent.opener.document.all("salesStaffID").value=saleStaff;
  if(parent.opener.document.all("paymentTerms"))
     parent.opener.document.all("paymentTerms").value=paymentTerm;
  if(parent.opener.document.all("invoiceDeliver"))
     parent.opener.document.all("invoiceDeliver").value=invoiceDeliver;
  var url = '../invoice/getcontacter';
  var pars = "customerID=" + customerID+"&contactType="+contactType+"&t="+Math.random() ;
  var bankAjax = new Ajax.Request(url,{method: 'get', parameters: pars, onComplete: fillContact});

}

function fillContact(requestObj)
{
  try{
      var resultf=requestObj.responseXML.getElementsByTagName("firstName");
      var resultl=requestObj.responseXML.getElementsByTagName("lastName");
      var resulti=requestObj.responseXML.getElementsByTagName("contactID");
    for(i=0;i<=resultf.length-1;i++)
    {
      firstName=resultf[i].firstChild==null?"":resultf[i].firstChild.nodeValue;
      lastName=resultl[i].firstChild==null?"":resultl[i].firstChild.nodeValue;
      contactID=resulti[i].firstChild==null?"":resulti[i].firstChild.nodeValue;
      parent.opener.fillContactOption(contactID,firstName+lastName);
    }
  }catch(e){}
  finally{
     window.close();
  }
}

 function exportExcelInfo(titleName)
 {
   try{
  var ōXL = new ActiveXObject("Excel.Application");
  var ōWB = oXL.Workbooks.Add();
  var ōSheet = oWB.ActiveSheet;
  var PrintA = document.all("tableRpt");
  var Lenr = PrintA.rows.length;
  var colSite =  Math.round(PrintA.rows(0).cells.length / 2);
  oSheet.Cells(1,colSite).value=titleName;
  oSheet.Cells(1,colSite).Font.Bold =1;
  oSheet.Cells(1,colSite).Font.Size=12;
   var info=document.all("info").innerHTML
    oSheet.Cells(2,1).value=info.replace(/&nbsp;/g,'  ');
    oSheet.Cells(2,1).Font.Bold =0;
    oSheet.Cells(2,1).Font.Size=10;
    oSheet.Range('A2:Z2').Select();
    oXL.Selection.Merge();
    oXL.Selection.HorizontalAlignment = -4131;

  var k=0;
  for (i=2;i<Lenr+1;i++,k++)
  {
   var Lenc = PrintA.rows(k).cells.length;
   for (j=0;j<Lenc;j++)
   {
    oSheet.Cells(i+1,j+1).value = PrintA.rows(k).cells(j).innerText;
    oSheet.Cells(i+1,j+1).Font.Size=10;
    if(i==1)
    {
      oSheet.Cells(i+1,j+1).Font.Bold =1;
    }
   }
  }
  oXL.Visible = true;
  ōXL = null;
  }catch(e){}
  finally{
        idTmr  =  window.setInterval("Cleanup();",1);
  }
}

function exportWordInfo(titleName,calcIndex)
{
  try{
      var PrintA = document.all("tableRpt");
      var row_count = PrintA.rows.length-1;
      var col_count = PrintA.rows(0).cells.length;

      var WordApp=new ActiveXObject("Word.Application");

      var wdCharacter=1;
      var wdOrientLandscape = 1;
      var myDoc=WordApp.Documents.Add();

      WordApp.ActiveDocument.PageSetup.Orientation = wdOrientLandscape
      WordApp.Selection.Font.Size=12;
      WordApp.Selection.Font.Bold=1;
      WordApp.Selection.TypeText(titleName);
      WordApp.Selection.Paragraphs(1).Alignment=1;
      WordApp.Selection.MoveRight(1);
      WordApp.Selection.TypeParagraph();
      WordApp.Selection.TypeParagraph();
      WordApp.Selection.Font.Bold=0;
      var info=document.all("info").innerHTML
      WordApp.Selection.Font.Size=10;
      WordApp.Selection.TypeText(info.replace(/&nbsp;/g,'  '));
      WordApp.Selection.Paragraphs(1).Alignment=3;
      WordApp.Selection.MoveRight(1);
      WordApp.Selection.TypeParagraph();
      WordApp.Selection.TypeParagraph();
     var myTable=myDoc.Tables.Add (WordApp.Selection.Range, row_count,col_count)
     var TableRange;

     for (i =0;i<row_count;i++)
     {
       for (n =0;n<col_count ;n++)
       {
          with (myTable.Cell(i+1,n+1).Range)
          {
            font.Size = 10;
            if(i==0)
            {
               font.Bold =1;
            }
            if(n>=calcIndex)
              ParagraphFormat.Alignment=2;
            else
              ParagraphFormat.Alignment=0;
            if(i==0)
              ParagraphFormat.Alignment=1;

            InsertAfter(PrintA.rows(i).cells(n).innerText);
          }
        }
      }

      row_count = 0;
      col_count = 0
      WordApp.Application.Visible=true;
  }catch(e){}
      finally{
         idTmr  =  window.setInterval("Cleanup();",1);
      }
}

function choseProject(customerID)
{

 window.open("../project/choseproject.jsp?customerID="+customerID , "cre", "height=400,top=0,left=0, width=800, toolbar =no, menubar=no, scrollbars=yes, resizable=yes, location=no, status=no");

}

//edit supplier edit by qing 1029
function show_editVendor(ID){
  reValue=window.open("../supplier/editcilent.jsp?id="+ID, "editvendor", "height=600,top=0,left=0, width=800, toolbar =no, menubar=no, scrollbars=no, resizable=yes, location=no, status=no");
}

//edit supplier edit by qing 0127
function show_editCustomer(ID){
 reValue=window.open("../cilent/editcilent.jsp?id="+ID, "editclient", "height=600,top=0,left=0, width=800, toolbar =no, menubar=no, scrollbars=no, resizable=yes, location=no, status=no");
}

function checkPeriod(period)
{
     var url = '../voucher/autocode';
     var pars = "type=checkPeriod"+"&period="+period+"&t="+Math.random();
     var bankAjax = new Ajax.Request(url,{method: 'post', parameters: pars, onComplete: showMsg});
}

function checkPeriod1(period)
{
     var url = '../voucher/autocode';
     var pars = "type=checkPeriod"+"&period="+period+"&t="+Math.random();
     var bankAjax = new Ajax.Request(url,{method: 'post', parameters: pars, onComplete: showMsg1});
}

function showMsg(requestObj)
{
  var resultf=requestObj.responseXML.getElementsByTagName("code");
  var resultc=requestObj.responseXML.getElementsByTagName("check");
  periodExist=resultf[0].firstChild.nodeValue;
  checkOut=resultc[0].firstChild.nodeValue;
  if(periodExist=="0")
  {
      alert(document.all("periodNotFound").value);
      return ;
  }

  if(checkOut==1)
  {
      alert(document.all("periodCheckOut").value);
      return ;
  }
  document.all("form").submit();
}

function showMsg1(requestObj)
{
  var resultf=requestObj.responseXML.getElementsByTagName("code");
  var resultc=requestObj.responseXML.getElementsByTagName("check");
  periodExist=resultf[0].firstChild.nodeValue;
  checkOut=resultc[0].firstChild.nodeValue;
  if(periodExist=="0")
  {
      alert(document.all("periodNotFound").value);
      return ;
  }

  if(checkOut==1)
  {
      alert(document.all("periodCheckOut").value);
      return ;
  }
var   tb   =   document.getElementsByTagName("table");
tb[1].rows[0].cells[1].disabled=true;
  document.all("form").submit();
}