private void PreviewReport() { string s_error = ""; try { oRpt = new ReportDocument(); if (Directory.Exists("..\\..\\..\\" + s_dirreport) == false) { s_dirreport = "report"; } oRpt.Load("..\\..\\..\\" + s_dirreport + "\\" + ReportFile, OpenReportMethod.OpenReportByTempCopy); if (dt != null) { oRpt.SetDataSource(dt); } else if (ds != null) { oRpt.SetDataSource(ds); } else { return; } s_error = "soyte"; oRpt.DataDefinition.FormulaFields["soyte"].Text = "'" + ttb.Syte + "'"; s_error = "benhvien"; oRpt.DataDefinition.FormulaFields["benhvien"].Text = "'" + ttb.Tenbv + "'"; s_error = "c1"; oRpt.DataDefinition.FormulaFields["c1"].Text = "'" + c1 + "'"; s_error = "c2"; oRpt.DataDefinition.FormulaFields["c2"].Text = "'" + c2 + "'"; s_error = "c3"; oRpt.DataDefinition.FormulaFields["c3"].Text = "'" + c3 + "'"; s_error = "c4"; oRpt.DataDefinition.FormulaFields["c4"].Text = "'" + c4 + "'"; s_error = "c5"; oRpt.DataDefinition.FormulaFields["c5"].Text = "'" + c5 + "'"; s_error = "c6"; oRpt.DataDefinition.FormulaFields["c6"].Text = "'" + c6 + "'"; s_error = "c7"; oRpt.DataDefinition.FormulaFields["c7"].Text = "'" + c7 + "'"; s_error = "c8"; oRpt.DataDefinition.FormulaFields["c8"].Text = "'" + c8 + "'"; s_error = "c9"; oRpt.DataDefinition.FormulaFields["c9"].Text = "'" + c9 + "'"; s_error = "c10"; oRpt.DataDefinition.FormulaFields["c10"].Text = "'" + c10 + "'"; s_error = "giamdoc"; oRpt.DataDefinition.FormulaFields["giamdoc"].Text = "'" + ttb.Giamdoc(-2) + "'"; s_error = "phutrach"; oRpt.DataDefinition.FormulaFields["phutrach"].Text = "'" + ttb.Phutrach(i_nhom) + "'"; s_error = "thongke"; oRpt.DataDefinition.FormulaFields["thongke"].Text = "'" + ttb.Thongke(i_nhom) + "'"; s_error = "ketoan"; oRpt.DataDefinition.FormulaFields["ketoan"].Text = "'" + ttb.Ketoan(i_nhom) + "'"; s_error = "thukho"; oRpt.DataDefinition.FormulaFields["thukho"].Text = "'" + ttb.Thukho(i_nhom) + "'"; s_error = "l_soluong"; oRpt.DataDefinition.FormulaFields["l_soluong"].Text = i_soluong_le.ToString(); s_error = "l_dongia"; oRpt.DataDefinition.FormulaFields["l_dongia"].Text = i_dongia_le.ToString(); s_error = "l_thanhtien"; oRpt.DataDefinition.FormulaFields["l_thanhtien"].Text = i_thanhtien_le.ToString(); Report.ReportSource = oRpt; } catch (Exception e) { MessageBox.Show(((s_error.Trim() == "")?"Thiếu fomular: " + s_error:"") + "\n The following error was discovered: '" + e.Message + "'. It was occured in '" + e.StackTrace + "'", "Report Viewer", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void butIn_Click(object sender, System.EventArgs e) { if (dsct.Tables[0].Rows.Count == 0 || dsll.Tables[0].Rows.Count == 0) { return; } sql = "select * from ttb_phieuxuat where to_char(ngay,'dd/mm/yyyy')='" + s_ngay + "' and nhom=" + i_nhom; if (i_makp != 0) { sql += " and makp=" + i_makp; } sql += " and kho='" + i_makho.ToString() + "'"; sql += " and loai='" + dsphieu.Tables[0].Rows[phieu.SelectedIndex]["stt"].ToString() + "'"; if (ttb.get_data(sql).Tables[0].Rows.Count == 0) //s_mmyy { MessageBox.Show("Chưa cập nhật không thể in !", ttb.Msg); return; } int i_row = dataGrid1.CurrentCell.RowNumber; string tenfile = "d_phieuxuat.rpt", slydo = dsphieu.Tables[0].Rows[phieu.SelectedIndex]["lydo"].ToString(); if (dataGrid1[i_row, 5].ToString().Trim().Length > 0) { slydo += " (Số phiếu lĩnh : " + dataGrid1[i_row, 5].ToString().Trim() + ")"; } decimal d_tongcong = tongcong(dsct.Tables[0]); if (ttb.bPreview) { frmReport f = new frmReport(ttb, dsct.Tables[0], tenfile, dataGrid1[i_row, 1].ToString(), dataGrid1[i_row, 2].ToString(), dataGrid1[i_row, 3].ToString(), dataGrid1[i_row, 4].ToString(), s_tenkp, slydo, s_tenkho, doiso.Doiso_Unicode(Convert.ToInt64(d_tongcong).ToString()), "", ""); f.ShowDialog(); } else { ReportDocument oRpt = new ReportDocument(); oRpt.Load("..\\..\\..\\report\\" + tenfile, OpenReportMethod.OpenReportByTempCopy); oRpt.SetDataSource(dsct.Tables[0]); oRpt.DataDefinition.FormulaFields["soyte"].Text = "'" + ttb.Syte + "'"; oRpt.DataDefinition.FormulaFields["benhvien"].Text = "'" + ttb.Tenbv + "'"; oRpt.DataDefinition.FormulaFields["c1"].Text = "'" + dataGrid1[i_row, 1].ToString() + "'"; oRpt.DataDefinition.FormulaFields["c2"].Text = "'" + dataGrid1[i_row, 2].ToString() + "'"; oRpt.DataDefinition.FormulaFields["c3"].Text = "'" + dataGrid1[i_row, 3].ToString() + "'"; oRpt.DataDefinition.FormulaFields["c4"].Text = "'" + dataGrid1[i_row, 4].ToString() + "'"; oRpt.DataDefinition.FormulaFields["c5"].Text = "'" + s_tenkp + "'"; oRpt.DataDefinition.FormulaFields["c6"].Text = "'" + slydo + "'"; oRpt.DataDefinition.FormulaFields["c7"].Text = "'" + s_tenkho + "'"; oRpt.DataDefinition.FormulaFields["c8"].Text = "'" + doiso.Doiso_Unicode(Convert.ToInt64(d_tongcong).ToString()) + "'"; oRpt.DataDefinition.FormulaFields["c9"].Text = ""; oRpt.DataDefinition.FormulaFields["c10"].Text = ""; oRpt.DataDefinition.FormulaFields["giamdoc"].Text = "'" + ttb.Giamdoc(i_nhom) + "'"; oRpt.DataDefinition.FormulaFields["phutrach"].Text = "'" + ttb.Phutrach(i_nhom) + "'"; oRpt.DataDefinition.FormulaFields["thongke"].Text = "'" + ttb.Thongke(i_nhom) + "'"; oRpt.DataDefinition.FormulaFields["ketoan"].Text = "'" + ttb.Ketoan(i_nhom) + "'"; oRpt.DataDefinition.FormulaFields["thukho"].Text = "'" + ttb.Thukho(i_nhom) + "'"; //oRpt.PrintOptions.PaperSize=PaperSize.PaperA4; oRpt.PrintOptions.PaperSize = PaperSize.DefaultPaperSize; oRpt.PrintOptions.PaperOrientation = PaperOrientation.Portrait; oRpt.PrintToPrinter(1, false, 0, 0); oRpt.Close(); oRpt.Dispose(); } }