Exemplo n.º 1
0
        private void PrintSaleInvoice(System.Data.DataTable dt)
        {
            try
            {
                int PageSize   = 25;
                int TotalPages = dt.Rows.Count / 25;
                int remainder  = dt.Rows.Count % 25;
                if (remainder > 0)
                {
                    TotalPages++;
                }
                //FillInvoiceHeader(TotalPages);
                int iStart = 14;
                int pos    = 0;
                int row    = 0;
                m_TotalDiscount = 0;
                for (int page = 0; page < TotalPages; page++)
                {
                    if (page > 0)
                    {
                        iStart = 51;
                    }
                    OpenTemplate();
                    FillInvoiceHeader(page + 1, TotalPages);
                    for (int index = 0; index < PageSize; index++)
                    {
                        if (row >= dt.Rows.Count)
                        {
                            break;
                        }
                        pos = iStart + index;
                        FillCellsWithData(dt, pos, row);
                        row++;
                    }
                    if (page == TotalPages - 1) //Last page
                    {
                        if (TotalPages == 1)
                        {
                            pos = 39;
                        }
                        else
                        {
                            pos = 76;
                        }

                        string      TotDiscountValue     = "F" + pos.ToString();
                        Excel.Range TotDiscountValueCell = (Excel.Range)excelWorksheet.get_Range(TotDiscountValue, TotDiscountValue);
                        TotDiscountValueCell.Value2 = m_TotalDiscount.ToString();

                        pos++;
                        string      TotalValue     = "G" + pos.ToString();
                        Excel.Range TotalValueCell = (Excel.Range)excelWorksheet.get_Range(TotalValue, TotalValue);
                        TotalValueCell.Value2 = m_InvoiceTotal.ToString();
                    }
                    //excelWorkbook.SaveCopyAs("C:\\DEV\\MICS\\TEMPLATES\\inv" + page + ".xls");
                    if (page == 0)
                    {
                        excelWorksheet.PrintOut(1, 1, m_Copies, false, "", false, false, "");
                    }
                    else
                    {
                        excelWorksheet.PrintOut(2, 2, m_Copies, false, "", false, false, "");
                    }

                    excelWorkbook.Close(false, m_TemplatePath, true);
                }
            }
            catch (Exception ex)
            {
                excelWorkbook.Close(false, m_TemplatePath, true);
                throw(ex);
            }
        }
Exemplo n.º 2
0
 /// <summary>
 /// 打印并退出
 /// </summary>
 /// <param name="xlsSheet"></param>
 private void PrintXls(Excel.Worksheet xlsSheet)
 {
     ((Excel._Worksheet)xlsSheet).Activate();
     xlsSheet.PrintOut();
 }