代码之家 › 专栏 › 技术社区 › Kaoru

隐藏打印页c中的特定列#

print-preview datagridview printing winforms c#

1

Kaoru · 技术社区 · 12 年前

我想隐藏打印页面中的列。

这是显示 ID 列仍然可见:

enter image description here

我想隐藏 身份证件 柱

这是我正在使用的代码,我已经声明 this.dataGridView.Columns["ID"].Visible = false ,但 身份证件 列仍然可见。

private void PrintPreview(object sender, EventArgs e)
        {
            PrintPreviewDialog _PrintPreview = new PrintPreviewDialog();
            printDocument1.DefaultPageSettings.Landscape = true;
            _PrintPreview.Document = printDocument1;
            ((Form)_PrintPreview).WindowState = FormWindowState.Maximized;
            _PrintPreview.ShowDialog();

            this.dataGridView1.Columns["ID"].Visible = false;
        }

private void printDocument1_BeginPrint(object sender, PrintEventArgs e)
        {
            try
            {
                strFormat = new StringFormat();
                strFormat.Alignment = StringAlignment.Center;
                strFormat.LineAlignment = StringAlignment.Center;
                strFormat.Trimming = StringTrimming.EllipsisCharacter;

                arrColumnLefts.Clear();
                arrColumnWidths.Clear();
                iCellHeight = 0;
                iRow = 0;
                bFirstPage = true;
                bNewPage = true;

                iTotalWidth = 0;

                foreach (DataGridViewColumn dgvGridCol in dataGridView1.Columns)
                {
                    iTotalWidth += dgvGridCol.Width;
                }
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private void printDocument1_PrintPage(object sender, PrintPageEventArgs e)
        {
            try
            {
                //Set the left margin
                int iLeftMargin = e.MarginBounds.Left;

                //Set the top margin
                int iTopMargin = e.MarginBounds.Top;

                //Whether more pages have to print or not
                bool bMorePagesToPrint = false;

                int iTmpWidth = 0;

                int width = 500;

                int height = 90;

                //For the first page to print set the cell width and header height
                if (bFirstPage)
                {
                    foreach (DataGridViewColumn GridCol in dataGridView1.Columns)
                    {
                        iTmpWidth = (int)(Math.Floor((double)((double)GridCol.Width / (double)iTotalWidth * (double)iTotalWidth * ((double)e.MarginBounds.Width / (double)iTotalWidth))));

                        iHeaderHeight = (int)(e.Graphics.MeasureString(GridCol.HeaderText, GridCol.InheritedStyle.Font, iTmpWidth).Height) + 11;

                        // Save width and height of headres
                        arrColumnLefts.Add(iLeftMargin);
                        arrColumnWidths.Add(iTmpWidth);
                        iLeftMargin += iTmpWidth;
                    }
                }

                //Loop till all the grid rows not get printed
                while (iRow <= dataGridView1.Rows.Count - 1)
                {
                    DataGridViewRow GridRow = dataGridView1.Rows[iRow];

                    //Set the cell height
                    iCellHeight = GridRow.Height + 5;

                    int iCount = 0;

                    //Check whether the current page settings allo more rows to print
                    if (iTopMargin + iCellHeight >= e.MarginBounds.Height + e.MarginBounds.Top)
                    {
                        bNewPage = true;
                        bFirstPage = false;
                        bMorePagesToPrint = true;
                        break;
                    }

                    else
                    {
                        if (bNewPage)
                        {
                            //Draw Header
                            e.Graphics.DrawString("Database Summary", new Font(dataGridView1.Font, FontStyle.Bold), Brushes.Black, e.MarginBounds.Left, e.MarginBounds.Top - e.Graphics.MeasureString("Database Summary", new Font(dataGridView1.Font, FontStyle.Bold), e.MarginBounds.Width).Height - 13);

                            String strDate = DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToShortTimeString();

                            //Draw Date
                            e.Graphics.DrawString(strDate, new Font(dataGridView1.Font, FontStyle.Regular), Brushes.Black, e.MarginBounds.Left + (e.MarginBounds.Width - e.Graphics.MeasureString(strDate, new Font(dataGridView1.Font, FontStyle.Regular), e.MarginBounds.Width).Width), e.MarginBounds.Top - e.Graphics.MeasureString("Database Summary", new Font(new Font(dataGridView1.Font, FontStyle.Regular), FontStyle.Regular), e.MarginBounds.Width).Height - 13);

                            //Draw Image
                            e.Graphics.DrawImage(pb1.Image, new Rectangle(300, 0, width, height));

                            //Draw Columns    
                            iTopMargin = e.MarginBounds.Top;

                            foreach (DataGridViewColumn GridCol in dataGridView1.Columns)
                            {
                                e.Graphics.FillRectangle(new SolidBrush(Color.Aqua), new Rectangle((int)arrColumnLefts[iCount], iTopMargin, (int)arrColumnWidths[iCount], iHeaderHeight));

                                e.Graphics.DrawRectangle(Pens.Black, new Rectangle((int)arrColumnLefts[iCount], iTopMargin, (int)arrColumnWidths[iCount], iHeaderHeight));

                                e.Graphics.DrawString(GridCol.HeaderText, GridCol.InheritedStyle.Font, new SolidBrush(GridCol.InheritedStyle.ForeColor), new RectangleF((int)arrColumnLefts[iCount], iTopMargin, (int)arrColumnWidths[iCount], iHeaderHeight), strFormat);

                                iCount++;
                            }

                            bNewPage = false;
                            iTopMargin += iHeaderHeight;
                        }

                        iCount = 0;

                        //Draw Columns Contents                
                        foreach (DataGridViewCell Cel in GridRow.Cells)
                        {
                            if (Cel.Value != null)
                            {
                                e.Graphics.DrawString(Cel.Value.ToString(), Cel.InheritedStyle.Font, new SolidBrush(Cel.InheritedStyle.ForeColor = System.Drawing.Color.Blue), new RectangleF((int)arrColumnLefts[iCount], (float)iTopMargin, (int)arrColumnWidths[iCount], (float)iCellHeight), strFormat);
                            }

                            //Drawing Cells Borders 
                            e.Graphics.DrawRectangle(Pens.Red, new Rectangle((int)arrColumnLefts[iCount], iTopMargin, (int)arrColumnWidths[iCount], iCellHeight));

                            iCount++;
                        }
                    }

                    iRow++;
                    iTopMargin += iCellHeight;
                }

                //If more lines exist, print another page.
                if (bMorePagesToPrint)
                {
                    e.HasMorePages = true;
                }

                else
                {
                    e.HasMorePages = false;
                }
            }

            catch (Exception exc)
            {
                MessageBox.Show(exc.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

有什么帮助吗?

非常感谢。

非常感谢您的回答!

4 回复 | 直到 12 年前

1

2

etaiso 12 年前

我认为问题出在 printDocument1_PrintPage :

foreach (DataGridViewColumn GridCol in dataGridView1.Columns)
{
    e.Graphics.FillRectangle(new SolidBrush(Color.Aqua), new Rectangle((int)arrColumnLefts[iCount], iTopMargin, (int)arrColumnWidths[iCount], iHeaderHeight));

    e.Graphics.DrawRectangle(Pens.Black, new Rectangle((int)arrColumnLefts[iCount], iTopMargin, (int)arrColumnWidths[iCount], iHeaderHeight));

    e.Graphics.DrawString(GridCol.HeaderText, GridCol.InheritedStyle.Font, new SolidBrush(GridCol.InheritedStyle.ForeColor), new RectangleF((int)arrColumnLefts[iCount], iTopMargin, (int)arrColumnWidths[iCount], iHeaderHeight), strFormat);

    iCount++;
}

你正在循环全部列并打印其值。因此,您应该跳过ID列。请记住,更改特定列 Visible 属性设置为false不会向 dataGridView1.Columns 收集

总之,有一个简单的方法可以实现您的目标:

foreach (DataGridViewColumn GridCol in dataGridView1.Columns)
{
    if (GridCol.Name != "ID")
    {
        e.Graphics.FillRectangle(new SolidBrush(Color.Aqua), new Rectangle((int)arrColumnLefts[iCount], iTopMargin, (int)arrColumnWidths[iCount], iHeaderHeight));

        e.Graphics.DrawRectangle(Pens.Black, new Rectangle((int)arrColumnLefts[iCount], iTopMargin, (int)arrColumnWidths[iCount], iHeaderHeight));

        e.Graphics.DrawString(GridCol.HeaderText, GridCol.InheritedStyle.Font, new SolidBrush(GridCol.InheritedStyle.ForeColor), new RectangleF((int)arrColumnLefts[iCount], iTopMargin, (int)arrColumnWidths[iCount], iHeaderHeight), strFormat);

        iCount++;
    }
}

2

1

Mohammad Ashfaq 12 年前

试着说出你的这句话 this.dataGridView1.Columns[“ID”].Visible=false; 作为你的第一行 打印预览 方法,因为当您调用 _PrintPreview.ShowDialog(); 将呼叫 打印Document1_BeginPrint 因此该列是可见的。

3

1

Sinatr 12 年前

正如莫·阿什法克已经回答的那样,你这里有一个逻辑错误

    private void PrintPreview(object sender, EventArgs e)
    {
        ...
        _PrintPreview.ShowDialog();

        this.dataGridView1.Columns["ID"].Visible = false;
    }

向这边走

    private void PrintPreview(object sender, EventArgs e)
    {
        ...
        this.dataGridView1.Columns["ID"].Visible = false;
        _PrintPreview.ShowDialog();
        this.dataGridView1.Columns["ID"].Visible = true; // restore visibility
    }

接下来是设置列不可见不会阻止枚举它(正如etaiso所回答的那样),替换所有出现的

foreach (DataGridViewColumn dgvGridCol in dataGridView1.Columns)
{
    ...
}

具有

foreach (var column in dataGridView1.Columns)
    if(column.Visible)
    {
        ...
    }

4

0

dazleer 11 年前

尽量不要让ID列的参数为false或true。

但正如etaiso所说,当您在所有行中执行循环时,您正在循环所有列。

你需要做的就是改变

                int iCount = 0;

到

                int iCount = 1;

这样,跳过for循环中的第一列和ID列,列0不会出现在打印预览中