Beispiel #1
0
        public void LoadReport()
        {
            DgvFuel.ColumnHeadersDefaultCellStyle.Font = new Font("Tahoma", 8F, FontStyle.Bold);

            DgvFuel.RowTemplate.MinimumHeight = 25;//25 is height.

            //With dgvDonors
            // DgvFuel.Columns(0).Width = 150;
            //DgvFuel.Columns[3].Visible = false;

            try
            {
                DataSet ds = dba.GetAllToTable(_fromDate, _ToDate);
                DgvFuel.DataSource = ds.Tables["FUEL_TMP_ISSUE_HEADER_SUB"].DefaultView;
                //DgvFuel.Columns[1].Width = 70;
                //DgvFuel.Columns[3].Width = 80;
                //DgvFuel.Columns[4].Width = 120;
                //DgvFuel.Columns[5].Width = 110;
                //DgvFuel.Columns[6].Width = 55;
                //DgvFuel.Columns[7].Width = 50;
                //DgvFuel.Columns[8].Width = 72;
                //DgvFuel.Columns[9].Width = 72;
                //DgvFuel.Columns[10].Width = 76;
                //DgvFuel.Columns[10].Visible = ;
                DgvFuel.ClearSelection();
            }
            catch { MessageBox.Show("Error try again....", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button2, MessageBoxOptions.ServiceNotification); }
        }
        private void ReportGen_Load(object sender, EventArgs e)
        {
            DgvFuel.ColumnHeadersDefaultCellStyle.Font = new Font("Tahoma", 8F, FontStyle.Bold);

            DgvFuel.RowTemplate.MinimumHeight = 25;//25 is height.
            GetHeader();
            //With dgvDonors
            // DgvFuel.Columns(0).Width = 150;
            //DgvFuel.Columns[3].Visible = false;

            try
            {
                DataSet ds = dba.FillReportDetails(DateTime.Now.ToString("MM/dd/yyyy"));
                DgvFuel.DataSource        = ds.Tables["FUEL_TMP_ISSUE_HEADER_SUB"].DefaultView;
                DgvFuel.Columns[1].Width  = 70;
                DgvFuel.Columns[3].Width  = 80;
                DgvFuel.Columns[4].Width  = 83;
                DgvFuel.Columns[5].Width  = 120;
                DgvFuel.Columns[6].Width  = 55;
                DgvFuel.Columns[7].Width  = 50;
                DgvFuel.Columns[8].Width  = 72;
                DgvFuel.Columns[9].Width  = 72;
                DgvFuel.Columns[10].Width = 76;
                //DgvFuel.Columns[10].Visible = false;
                DgvFuel.ClearSelection();
            }
            catch { MessageBox.Show("Error try again....", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button2, MessageBoxOptions.ServiceNotification); }

            try
            {
                DataTable table = dba.FillReport(DateTime.Now.ToString("MM/dd/yyyy"));
                DataRow   row   = table.Rows[0];

                LblDate.Text     = "Date:- " + row[2].ToString();
                LblEndMeter.Text = "CLOSING FUEL PUMP M:R:- " + row[3].ToString();

                LblStartMeter.Text = "OPENING FUEL PUMP M:R:- " + dba.FillStartMeterCount(DateTime.Now.ToString("MM/dd/yyyy"));
            }
            catch
            {
                MessageBox.Show("Error");
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            DgvFuel.ClearSelection();
            int height = PnalPrint.Height;

            //DgvFuel.Height = DgvFuel.RowCount * DgvFuel.RowTemplate.Height;

            //Create a Bitmap and draw the pnal on it.
            bitmap = new Bitmap(this.PnalPrint.Width, this.PnalPrint.Height);
            PnalPrint.DrawToBitmap(bitmap, new Rectangle(0, 0, this.PnalPrint.Width, this.PnalPrint.Height));

            //Resize DataGridView back to original height.
            PnalPrint.Height = height;

            //Show the Print Preview Dialog.
            printDocument1.DefaultPageSettings.Landscape = true;
            printPreviewDialog1.Document = printDocument1;
            printPreviewDialog1.PrintPreviewControl.Zoom = 1;
            printDocument1.DefaultPageSettings.Landscape = true;
            printPreviewDialog1.ShowDialog();
        }